Lock wait timeout exceeded

gistfile1.txt

Mysql::Error: Lock wait timeout exceeded; try restarting transaction: INSERT INTO `weekly_balances` (`start_date`, `context_id`, `context_type`, `register_id`, `approved_by`, `approved_at`, `created_at`, `rem_approve_w1`, `rem_approve_w2`, `rem_overrun`) VALUES ('2011-04-11', 997, 'Shop', 0, NULL, NULL, '2011-04-15 05:41:23', 0, 0, 0)
/opt/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/activerecord-3.0.5/lib/active_record/connection_adapters/abstract_adapter.rb:207:in `rescue in log'
/opt/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/activerecord-3.0.5/lib/active_record/connection_adapters/abstract_adapter.rb:199:in `log'
/opt/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/activerecord-3.0.5/lib/active_record/connection_adapters/mysql_adapter.rb:289:in `execute'
/opt/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/activerecord-3.0.5/lib/active_record/connection_adapters/abstract/database_statements.rb:282:in `insert_sql'
/opt/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/activerecord-3.0.5/lib/active_record/connection_adapters/mysql_adapter.rb:300:in `insert_sql'
/opt/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/activerecord-3.0.5/lib/active_record/connection_adapters/abstract/database_statements.rb:44:in `insert'
/opt/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/activerecord-3.0.5/lib/active_record/connection_adapters/abstract/query_cache.rb:16:in `insert'
/opt/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/arel-2.0.7/lib/arel/select_manager.rb:191:in `insert'
/opt/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/activerecord-3.0.5/lib/active_record/relation.rb:14:in `insert'
/opt/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/activerecord-3.0.5/lib/active_record/persistence.rb:270:in `create'
/opt/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/activerecord-3.0.5/lib/active_record/timestamp.rb:47:in `create'
/opt/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/activerecord-3.0.5/lib/active_record/callbacks.rb:281:in `block in create'
/opt/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/activesupport-3.0.5/lib/active_support/callbacks.rb:413:in `_run_create_callbacks'
/opt/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/activerecord-3.0.5/lib/active_record/callbacks.rb:281:in `create'
/opt/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/activerecord-3.0.5/lib/active_record/persistence.rb:246:in `create_or_update'
/opt/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/activerecord-3.0.5/lib/active_record/callbacks.rb:277:in `block in create_or_update'
/opt/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/activesupport-3.0.5/lib/active_support/callbacks.rb:428:in `_run_save_callbacks'
/opt/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/activerecord-3.0.5/lib/active_record/callbacks.rb:277:in `create_or_update'
/opt/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/activerecord-3.0.5/lib/active_record/persistence.rb:56:in `save!'
/opt/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/activerecord-3.0.5/lib/active_record/validations.rb:49:in `save!'
/opt/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/activerecord-3.0.5/lib/active_record/attribute_methods/dirty.rb:30:in `save!'
/opt/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/activerecord-3.0.5/lib/active_record/transactions.rb:245:in `block in save!'
/opt/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/activerecord-3.0.5/lib/active_record/transactions.rb:292:in `block in with_transaction_returning_status'
/opt/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/activerecord-3.0.5/lib/active_record/connection_adapters/abstract/database_statements.rb:139:in `transaction'
/opt/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/activerecord-3.0.5/lib/active_record/transactions.rb:207:in `transaction'
/opt/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/activerecord-3.0.5/lib/active_record/transactions.rb:290:in `with_transaction_returning_status'
/opt/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/activerecord-3.0.5/lib/active_record/transactions.rb:245:in `save!'
/opt/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/activerecord-3.0.5/lib/active_record/validations.rb:34:in `create!'
/var/www/samesystem/app/models/weekly_balance_line.rb:236:in `block in import_csv'
/var/www/samesystem/app/models/weekly_balance_line.rb:231:in `each'
/var/www/samesystem/app/models/weekly_balance_line.rb:231:in `import_csv'
/var/www/samesystem/app/models/import.rb:530:in `block in bianco_weekly_balance_import'
/var/www/samesystem/app/models/import.rb:556:in `block in bianco_file_import'
/var/www/samesystem/app/models/import.rb:555:in `each'
/var/www/samesystem/app/models/import.rb:555:in `bianco_file_import'
/var/www/samesystem/app/models/import.rb:529:in `bianco_weekly_balance_import'
/var/www/samesystem/vendor/plugins/delayed_job/lib/delayed/performable_method.rb:39:in `perform'
/var/www/samesystem/vendor/plugins/delayed_job/lib/delayed/backend/base.rb:85:in `invoke_job'
/var/www/samesystem/vendor/plugins/delayed_job/lib/delayed/worker.rb:119:in `block (2 levels) in run'
/opt/ruby-1.9.2/lib/ruby/1.9.1/timeout.rb:57:in `timeout'
/var/www/samesystem/vendor/plugins/delayed_job/lib/delayed/worker.rb:119:in `block in run'
/opt/ruby-1.9.2/lib/ruby/1.9.1/benchmark.rb:309:in `realtime'
/var/www/samesystem/vendor/plugins/delayed_job/lib/delayed/worker.rb:118:in `run'
/var/www/samesystem/vendor/plugins/delayed_job/lib/delayed/worker.rb:176:in `reserve_and_run_one_job'
/var/www/samesystem/vendor/plugins/delayed_job/lib/delayed/worker.rb:103:in `block in work_off'
/var/www/samesystem/vendor/plugins/delayed_job/lib/delayed/worker.rb:102:in `times'
/var/www/samesystem/vendor/plugins/delayed_job/lib/delayed/worker.rb:102:in `work_off'
/var/www/samesystem/vendor/plugins/delayed_job/lib/delayed/worker.rb:77:in `block (2 levels) in start'
/opt/ruby-1.9.2/lib/ruby/1.9.1/benchmark.rb:309:in `realtime'
/var/www/samesystem/vendor/plugins/delayed_job/lib/delayed/worker.rb:76:in `block in start'
/var/www/samesystem/vendor/plugins/delayed_job/lib/delayed/worker.rb:73:in `loop'
/var/www/samesystem/vendor/plugins/delayed_job/lib/delayed/worker.rb:73:in `start'
/var/www/samesystem/lib/tasks/daemon_tasks.rake:33:in `block (5 levels) in <top (required)>'
/var/www/samesystem/lib/tasks/daemon_tasks.rake:26:in `fork'
/var/www/samesystem/lib/tasks/daemon_tasks.rake:26:in `block (4 levels) in <top (required)>'
/var/www/samesystem/lib/tasks/daemon_tasks.rake:85:in `call'
/var/www/samesystem/lib/tasks/daemon_tasks.rake:85:in `block (5 levels) in <top (required)>'
/var/www/samesystem/lib/tasks/daemon_tasks.rake:124:in `call'
/var/www/samesystem/lib/tasks/daemon_tasks.rake:124:in `sleep'
/var/www/samesystem/lib/tasks/daemon_tasks.rake:124:in `block (5 levels) in <top (required)>'
/var/www/samesystem/lib/tasks/daemon_tasks.rake:119:in `loop'
/var/www/samesystem/lib/tasks/daemon_tasks.rake:119:in `block (4 levels) in <top (required)>'
/var/www/samesystem/lib/tasks/daemon_tasks.rake:42:in `fork'
/var/www/samesystem/lib/tasks/daemon_tasks.rake:42:in `block (3 levels) in <top (required)>'
/opt/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:634:in `call'
/opt/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:634:in `block in execute'
/opt/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:629:in `each'
/opt/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:629:in `execute'
/opt/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:595:in `block in invoke_with_call_chain'
/opt/ruby-1.9.2/lib/ruby/1.9.1/monitor.rb:201:in `mon_synchronize'
/opt/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:588:in `invoke_with_call_chain'
/opt/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:581:in `invoke'
/opt/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:2041:in `invoke_task'
/opt/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:2019:in `block (2 levels) in top_level'
/opt/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:2019:in `each'
/opt/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:2019:in `block in top_level'
/opt/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:2058:in `standard_exception_handling'
/opt/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:2013:in `top_level'
/opt/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:1992:in `run'
/opt/ruby/bin/rake:31:in `<main>'