Skip to content

Instantly share code, notes, and snippets.

@radar
Created September 10, 2013 23:14
Show Gist options
  • Save radar/6517077 to your computer and use it in GitHub Desktop.
Save radar/6517077 to your computer and use it in GitHub Desktop.
=> "PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block\n: SELECT \"pipes\".* FROM \"pipes\" WHERE \"pipes\".\"id\" = $1 ORDER BY \"pipes\".\"id\" ASC LIMIT 1\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/connection_adapters/postgresql_adapter.rb:512:in `exec'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/connection_adapters/postgresql_adapter.rb:512:in `dealloc'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/connection_adapters/postgresql_adapter.rb:501:in `delete'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/connection_adapters/postgresql_adapter.rb:792:in `rescue in exec_cache'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/connection_adapters/postgresql_adapter.rb:772:in `exec_cache'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/connection_adapters/postgresql/database_statements.rb:139:in `block in exec_query'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract_adapter.rb:425:in `block in log'\n/app/vendor/bundle/ruby/2.0.0/gems/activesupport-4.0.0/lib/active_support/notifications/instrumenter.rb:20:in `instrument'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract_adapter.rb:420:in `log'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/connection_adapters/postgresql/database_statements.rb:137:in `exec_query'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/connection_adapters/postgresql_adapter.rb:885:in `select'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract/database_statements.rb:24:in `select_all'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract/query_cache.rb:63:in `select_all'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/querying.rb:36:in `find_by_sql'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/relation.rb:585:in `exec_queries'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/relation.rb:471:in `load'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/relation.rb:220:in `to_a'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/relation/finder_methods.rb:325:in `find_first'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/relation/finder_methods.rb:90:in `first'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-deprecated_finders-1.0.3/lib/active_record/deprecated_finders/relation.rb:129:in `first'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/associations/singular_association.rb:42:in `find_target'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/associations/association.rb:139:in `load_target'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/associations/association.rb:52:in `reload'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/associations/singular_association.rb:9:in `reader'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/associations/builder/association.rb:70:in `pipe'\n/app/app/models/post.rb:17:in `contains_blacklisted_words?'\n/app/app/models/post.rb:25:in `contains_blacklisted_words'\n/app/vendor/bundle/ruby/2.0.0/gems/activesupport-4.0.0/lib/active_support/callbacks.rb:377:in `_run__552502324214964823__create__callbacks'\n/app/vendor/bundle/ruby/2.0.0/gems/activesupport-4.0.0/lib/active_support/callbacks.rb:80:in `run_callbacks'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/callbacks.rb:303:in `create_record'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/timestamp.rb:57:in `create_record'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/persistence.rb:466:in `create_or_update'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/callbacks.rb:299:in `block in create_or_update'\n/app/vendor/bundle/ruby/2.0.0/gems/activesupport-4.0.0/lib/active_support/callbacks.rb:393:in `_run__552502324214964823__save__callbacks'\n/app/vendor/bundle/ruby/2.0.0/gems/activesupport-4.0.0/lib/active_support/callbacks.rb:80:in `run_callbacks'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/callbacks.rb:299:in `create_or_update'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/persistence.rb:128:in `save!'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/validations.rb:57:in `save!'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/attribute_methods/dirty.rb:41:in `save!'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/transactions.rb:275:in `block in save!'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/transactions.rb:326:in `block in with_transaction_returning_status'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract/database_statements.rb:200:in `transaction'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/transactions.rb:209:in `transaction'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/transactions.rb:323:in `with_transaction_returning_status'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/transactions.rb:275:in `save!'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/associations/has_many_association.rb:37:in `insert_record'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/associations/collection_association.rb:463:in `block (2 levels) in create_record'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/associations/collection_association.rb:367:in `add_to_target'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/associations/collection_association.rb:461:in `block in create_record'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/associations/collection_association.rb:152:in `block in transaction'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract/database_statements.rb:202:in `block in transaction'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract/database_statements.rb:210:in `within_new_transaction'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract/database_statements.rb:202:in `transaction'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/transactions.rb:209:in `transaction'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/associations/collection_association.rb:151:in `transaction'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/associations/collection_association.rb:460:in `create_record'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/associations/collection_association.rb:125:in `create!'\n/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/associations/collection_proxy.rb:276:in `create!'\n/app/app/models/pipe.rb:105:in `block in update_twitters'\n/app/app/models/pipe.rb:96:in `each'\n/app/app/models/pipe.rb:96:in `update_twitters'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/performable_method.rb:26:in `perform'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/backend/base.rb:105:in `block in invoke_job'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/lifecycle.rb:60:in `call'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/lifecycle.rb:60:in `block in initialize'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/lifecycle.rb:65:in `call'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/lifecycle.rb:65:in `execute'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/lifecycle.rb:38:in `run_callbacks'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/backend/base.rb:102:in `invoke_job'\n(eval):3:in `block in invoke_job_with_newrelic_transaction_trace'\n/app/vendor/bundle/ruby/2.0.0/gems/newrelic_rpm-3.6.6.147/lib/new_relic/agent/instrumentation/controller_instrumentation.rb:318:in `perform_action_with_newrelic_trace'\n(eval):2:in `invoke_job_with_newrelic_transaction_trace'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/worker.rb:206:in `block (2 levels) in run'\n/app/vendor/ruby-2.0.0/lib/ruby/2.0.0/timeout.rb:66:in `timeout'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/worker.rb:206:in `block in run'\n/app/vendor/ruby-2.0.0/lib/ruby/2.0.0/benchmark.rb:296:in `realtime'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/worker.rb:205:in `run'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/worker.rb:267:in `block in reserve_and_run_one_job'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/lifecycle.rb:60:in `call'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/lifecycle.rb:60:in `block in initialize'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/lifecycle.rb:65:in `call'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/lifecycle.rb:65:in `execute'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/lifecycle.rb:38:in `run_callbacks'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/worker.rb:267:in `reserve_and_run_one_job'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/worker.rb:189:in `block in work_off'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/worker.rb:188:in `times'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/worker.rb:188:in `work_off'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/worker.rb:153:in `block (4 levels) in start'\n/app/vendor/ruby-2.0.0/lib/ruby/2.0.0/benchmark.rb:296:in `realtime'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/worker.rb:152:in `block (3 levels) in start'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/lifecycle.rb:60:in `call'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/lifecycle.rb:60:in `block in initialize'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/lifecycle.rb:65:in `call'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/lifecycle.rb:65:in `execute'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/lifecycle.rb:38:in `run_callbacks'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/worker.rb:151:in `block (2 levels) in start'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/worker.rb:150:in `loop'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/worker.rb:150:in `block in start'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/plugins/clear_locks.rb:7:in `call'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/plugins/clear_locks.rb:7:in `block (2 levels) in <class:ClearLocks>'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/lifecycle.rb:78:in `call'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/lifecycle.rb:78:in `block (2 levels) in add'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/lifecycle.rb:60:in `call'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/lifecycle.rb:60:in `block in initialize'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/lifecycle.rb:78:in `call'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/lifecycle.rb:78:in `block in add'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/lifecycle.rb:65:in `call'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/lifecycle.rb:65:in `execute'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/lifecycle.rb:38:in `run_callbacks'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/worker.rb:149:in `start'\n/app/vendor/bundle/ruby/2.0.0/gems/delayed_job-4.0.0/lib/delayed/tasks.rb:9:in `block (2 levels) in <top (required)>'\n/app/vendor/bundle/ruby/2.0.0/gems/rake-10.1.0/lib/rake/task.rb:236:in `call'\n/app/vendor/bundle/ruby/2.0.0/gems/rake-10.1.0/lib/rake/task.rb:236:in `block in execute'\n/app/vendor/bundle/ruby/2.0.0/gems/rake-10.1.0/lib/rake/task.rb:231:in `each'\n/app/vendor/bundle/ruby/2.0.0/gems/rake-10.1.0/lib/rake/task.rb:231:in `execute'\n/app/vendor/bundle/ruby/2.0.0/gems/rake-10.1.0/lib/rake/task.rb:175:in `block in invoke_with_call_chain'\n/app/vendor/ruby-2.0.0/lib/ruby/2.0.0/monitor.rb:211:in `mon_synchronize'\n/app/vendor/bundle/ruby/2.0.0/gems/rake-10.1.0/lib/rake/task.rb:168:in `invoke_with_call_chain'\n/app/vendor/bundle/ruby/2.0.0/gems/rake-10.1.0/lib/rake/task.rb:161:in `invoke'\n/app/vendor/bundle/ruby/2.0.0/gems/rake-10.1.0/lib/rake/application.rb:149:in `invoke_task'\n/app/vendor/bundle/ruby/2.0.0/gems/rake-10.1.0/lib/rake/application.rb:106:in `block (2 levels) in top_level'\n/app/vendor/bundle/ruby/2.0.0/gems/rake-10.1.0/lib/rake/application.rb:106:in `each'\n/app/vendor/bundle/ruby/2.0.0/gems/rake-10.1.0/lib/rake/application.rb:106:in `block in top_level'\n/app/vendor/bundle/ruby/2.0.0/gems/rake-10.1.0/lib/rake/application.rb:115:in `run_with_threads'\n/app/vendor/bundle/ruby/2.0.0/gems/rake-10.1.0/lib/rake/application.rb:100:in `top_level'\n/app/vendor/bundle/ruby/2.0.0/gems/rake-10.1.0/lib/rake/application.rb:78:in `block in run'\n/app/vendor/bundle/ruby/2.0.0/gems/rake-10.1.0/lib/rake/application.rb:165:in `standard_exception_handling'\n/app/vendor/bundle/ruby/2.0.0/gems/rake-10.1.0/lib/rake/application.rb:75:in `run'\n/app/vendor/bundle/ruby/2.0.0/gems/rake-10.1.0/bin/rake:33:in `<top (required)>'\n/app/vendor/bundle/ruby/2.0.0/bin/rake:23:in `load'\n/app/vendor/bundle/ruby/2.0.0/bin/rake:23:in `<main>'"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment