Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $ rake sunspot:solr:reindex --trace
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/neuron-client-0.1.0/lib/neuron-client/connected.rb:125: warning: don't put space before argument parentheses
- WARNING: 'task :t, arg, :needs => [deps]' is deprecated. Please use 'task :t, [args] => [deps]' instead.
- at /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/sunspot_rails-1.2.1/lib/sunspot/rails/tasks.rb:41
- ** Invoke sunspot:solr:reindex (first_time)
- ** Invoke sunspot:reindex (first_time)
- ** Invoke environment (first_time)
- ** Execute environment
- ** Execute sunspot:reindex
- rake aborted!
- Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DISTINCT `sites`.publisher_id FROM `sites` INNER JOIN zones ON ( sites.id = zone' at line 1: SELECT DISTINCT `sites`.*, DISTINCT `sites`.publisher_id FROM `sites` INNER JOIN zones ON ( sites.id = zones.site_id ) INNER JOIN ad_zones ON ( zones.id = ad_zones.zone_id ) INNER JOIN ads ON ( ad_zones.ad_id = ads.id AND (`ad_zones`.`expires_at` IS NULL)) WHERE (ads.campaign_id = 1 ) ORDER BY sites.name
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/activerecord-3.0.10/lib/active_record/connection_adapters/abstract_adapter.rb:207:in `log_without_newrelic_instrumentation'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/newrelic_rpm-3.1.2/lib/new_relic/agent/instrumentation/rails3/active_record_instrumentation.rb:67:in `log'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/newrelic_rpm-3.1.2/lib/new_relic/agent/method_tracer.rb:242:in `trace_execution_scoped'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/newrelic_rpm-3.1.2/lib/new_relic/agent/instrumentation/rails3/active_record_instrumentation.rb:63:in `log'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/mysql2-0.2.13/lib/active_record/connection_adapters/mysql2_adapter.rb:265:in `execute'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/mysql2-0.2.13/lib/active_record/connection_adapters/mysql2_adapter.rb:586:in `select'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/activerecord-3.0.10/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/activerecord-3.0.10/lib/active_record/connection_adapters/abstract/query_cache.rb:56:in `select_all'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/activerecord-3.0.10/lib/active_record/base.rb:473:in `find_by_sql_without_trace_ActiveRecord_self_name_find_by_sql'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/newrelic_rpm-3.1.2/lib/new_relic/agent/method_tracer.rb:491:in `find_by_sql'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/newrelic_rpm-3.1.2/lib/new_relic/agent/method_tracer.rb:242:in `trace_execution_scoped'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/newrelic_rpm-3.1.2/lib/new_relic/agent/method_tracer.rb:486:in `find_by_sql'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/activerecord-3.0.10/lib/active_record/relation.rb:64:in `to_a'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/activerecord-3.0.10/lib/active_record/relation.rb:366:in `method_missing'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/activerecord-3.0.10/lib/active_record/associations.rb:1499:in `publisher_ids'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/sunspot-1.2.1/lib/sunspot/data_extractor.rb:17:in `send'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/sunspot-1.2.1/lib/sunspot/data_extractor.rb:17:in `value_for'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/sunspot-1.2.1/lib/sunspot/field_factory.rb:58:in `populate_document'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/sunspot-1.2.1/lib/sunspot/indexer.rb:95:in `prepare'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/sunspot-1.2.1/lib/sunspot/indexer.rb:94:in `each'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/sunspot-1.2.1/lib/sunspot/indexer.rb:94:in `prepare'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/sunspot-1.2.1/lib/sunspot/indexer.rb:24:in `add'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/sunspot-1.2.1/lib/sunspot/indexer.rb:24:in `map'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/sunspot-1.2.1/lib/sunspot/indexer.rb:24:in `add'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/sunspot-1.2.1/lib/sunspot/session.rb:91:in `index'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/sunspot-1.2.1/lib/sunspot/session_proxy/abstract_session_proxy.rb:11:in `index'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/sunspot-1.2.1/lib/sunspot.rb:175:in `index_without_trace_SolrClient_Sunspot_index'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/newrelic_rpm-3.1.2/lib/new_relic/agent/method_tracer.rb:491:in `index'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/newrelic_rpm-3.1.2/lib/new_relic/agent/method_tracer.rb:242:in `trace_execution_scoped'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/newrelic_rpm-3.1.2/lib/new_relic/agent/method_tracer.rb:486:in `index'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/sunspot_rails-1.2.1/lib/sunspot/rails/searchable.rb:237:in `solr_index'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/sunspot_rails-1.2.1/lib/sunspot/rails/searchable.rb:322:in `solr_benchmark'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/sunspot_rails-1.2.1/lib/sunspot/rails/searchable.rb:236:in `solr_index'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/activerecord-3.0.10/lib/active_record/relation/batches.rb:69:in `find_in_batches'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/activerecord-3.0.10/lib/active_record/base.rb:446:in `__send__'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/activerecord-3.0.10/lib/active_record/base.rb:446:in `find_in_batches'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/sunspot_rails-1.2.1/lib/sunspot/rails/searchable.rb:235:in `solr_index'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/sunspot_rails-1.2.1/lib/sunspot/rails/searchable.rb:184:in `solr_reindex'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/sunspot_rails-1.2.1/lib/sunspot/rails/tasks.rb:57
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/sunspot_rails-1.2.1/lib/sunspot/rails/tasks.rb:56:in `each'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/sunspot_rails-1.2.1/lib/sunspot/rails/tasks.rb:56
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/rake-0.9.2/lib/rake/task.rb:205:in `call'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/rake-0.9.2/lib/rake/task.rb:205:in `execute'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/rake-0.9.2/lib/rake/task.rb:200:in `each'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/rake-0.9.2/lib/rake/task.rb:200:in `execute'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/rake-0.9.2/lib/rake/task.rb:158:in `invoke_with_call_chain'
- /Users/jon/.rvm/rubies/ree-1.8.7-2011.03/lib/ruby/1.8/monitor.rb:242:in `synchronize'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/rake-0.9.2/lib/rake/task.rb:151:in `invoke_with_call_chain'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/rake-0.9.2/lib/rake/task.rb:176:in `invoke_prerequisites'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/rake-0.9.2/lib/rake/task.rb:174:in `each'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/rake-0.9.2/lib/rake/task.rb:174:in `invoke_prerequisites'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/rake-0.9.2/lib/rake/task.rb:157:in `invoke_with_call_chain'
- /Users/jon/.rvm/rubies/ree-1.8.7-2011.03/lib/ruby/1.8/monitor.rb:242:in `synchronize'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/rake-0.9.2/lib/rake/task.rb:151:in `invoke_with_call_chain'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/rake-0.9.2/lib/rake/task.rb:144:in `invoke'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/rake-0.9.2/lib/rake/application.rb:112:in `invoke_task'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/rake-0.9.2/lib/rake/application.rb:90:in `top_level'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/rake-0.9.2/lib/rake/application.rb:90:in `each'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/rake-0.9.2/lib/rake/application.rb:90:in `top_level'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/rake-0.9.2/lib/rake/application.rb:129:in `standard_exception_handling'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/rake-0.9.2/lib/rake/application.rb:84:in `top_level'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/rake-0.9.2/lib/rake/application.rb:62:in `run'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/rake-0.9.2/lib/rake/application.rb:129:in `standard_exception_handling'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/rake-0.9.2/lib/rake/application.rb:59:in `run'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/gems/rake-0.9.2/bin/rake:32
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/bin/rake:19:in `load'
- /Users/jon/.rvm/gems/ree-1.8.7-2011.03@rails3/bin/rake:19
- Tasks: TOP => sunspot:solr:reindex => sunspot:reindex
Add Comment
Please, Sign In to add comment