Redmine

Hi there,

When i try to delete group, i can't delete group(occur error)

Ways to reproduce:
1. Administration - Groups - delete group - occur error
2. The groups with a few users are deleted. However, the groups with many users are not deleted and occur error.

Please help me.

- error log
ActiveRecord::StatementInvalid in GroupsController#destroy

Mysql::Error: Lock wait timeout exceeded; try restarting transaction: DELETE FROM `member_roles` WHERE `id` = 62076

RAILS_ROOT: /home/sh1594.lee/perforce_project/Remine121
Application Trace | Framework Trace | Full Trace

/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:227:in `log'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:324:in `execute'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:265:in `update_sql'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:339:in `update_sql'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:270:in `delete_sql'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:54:in `delete_without_query_dirty'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:19:in `delete'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/base.rb:2617:in `destroy_without_lock'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/locking/optimistic.rb:113:in `destroy_without_callbacks'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/callbacks.rb:337:in `destroy_without_transactions'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/transactions.rb:229:in `send'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/transactions.rb:229:in `with_transaction_returning_status'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:136:in `transaction'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/transactions.rb:182:in `transaction'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/transactions.rb:228:in `with_transaction_returning_status'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/transactions.rb:192:in `destroy'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/associations.rb:1430:in `has_many_dependent_destroy_for_member_roles'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/associations/association_collection.rb:392:in `method_missing'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/associations/association_proxy.rb:215:in `each'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/associations/association_proxy.rb:215:in `send'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/associations/association_proxy.rb:215:in `method_missing'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/associations/association_collection.rb:392:in `method_missing'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/associations.rb:1422:in `has_many_dependent_destroy_for_member_roles'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activesupport/lib/active_support/callbacks.rb:178:in `send'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activesupport/lib/active_support/callbacks.rb:178:in `evaluate_method'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activesupport/lib/active_support/callbacks.rb:166:in `call'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activesupport/lib/active_support/callbacks.rb:93:in `run'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activesupport/lib/active_support/callbacks.rb:92:in `each'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activesupport/lib/active_support/callbacks.rb:92:in `send'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activesupport/lib/active_support/callbacks.rb:92:in `run'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activesupport/lib/active_support/callbacks.rb:276:in `run_callbacks'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/callbacks.rb:344:in `callback'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/callbacks.rb:336:in `destroy_without_transactions'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/transactions.rb:229:in `send'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/transactions.rb:229:in `with_transaction_returning_status'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:136:in `transaction'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/transactions.rb:182:in `transaction'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/transactions.rb:228:in `with_transaction_returning_status'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/transactions.rb:192:in `destroy'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/associations.rb:1430:in `has_many_dependent_destroy_for_members'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/associations/association_collection.rb:392:in `method_missing'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/associations/association_proxy.rb:215:in `each'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/associations/association_proxy.rb:215:in `send'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/associations/association_proxy.rb:215:in `method_missing'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/associations/association_collection.rb:392:in `method_missing'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/associations.rb:1422:in `has_many_dependent_destroy_for_members'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activesupport/lib/active_support/callbacks.rb:178:in `send'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activesupport/lib/active_support/callbacks.rb:178:in `evaluate_method'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activesupport/lib/active_support/callbacks.rb:166:in `call'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activesupport/lib/active_support/callbacks.rb:93:in `run'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activesupport/lib/active_support/callbacks.rb:92:in `each'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activesupport/lib/active_support/callbacks.rb:92:in `send'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activesupport/lib/active_support/callbacks.rb:92:in `run'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activesupport/lib/active_support/callbacks.rb:276:in `run_callbacks'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/callbacks.rb:344:in `callback'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/callbacks.rb:336:in `destroy_without_transactions'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/transactions.rb:229:in `send'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/transactions.rb:229:in `with_transaction_returning_status'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:136:in `transaction'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/transactions.rb:182:in `transaction'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/transactions.rb:228:in `with_transaction_returning_status'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/transactions.rb:192:in `destroy'
/home/sh1594.lee/perforce_project/Remine121/app/controllers/groups_controller.rb:103:in `destroy'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/actionpack/lib/action_controller/base.rb:1333:in `send'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/actionpack/lib/action_controller/base.rb:1333:in `perform_action_without_filters'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/actionpack/lib/action_controller/filters.rb:617:in `call_filters'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/actionpack/lib/action_controller/filters.rb:610:in `perform_action_without_benchmark'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activesupport/lib/active_support/core_ext/benchmark.rb:17:in `ms'
/usr/lib/ruby/1.8/benchmark.rb:308:in `realtime'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activesupport/lib/active_support/core_ext/benchmark.rb:17:in `ms'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/actionpack/lib/action_controller/rescue.rb:160:in `perform_action_without_flash'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/actionpack/lib/action_controller/flash.rb:151:in `perform_action'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/actionpack/lib/action_controller/base.rb:532:in `send'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/actionpack/lib/action_controller/base.rb:532:in `process_without_filters'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/actionpack/lib/action_controller/filters.rb:606:in `process'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/actionpack/lib/action_controller/base.rb:391:in `process'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/actionpack/lib/action_controller/base.rb:386:in `call'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/actionpack/lib/action_controller/routing/route_set.rb:438:in `call'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:87:in `dispatch'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:121:in `_call'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:130:in `build_middleware_stack'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/query_cache.rb:29:in `call'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/query_cache.rb:29:in `call'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:34:in `cache'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/query_cache.rb:9:in `cache'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/query_cache.rb:28:in `call'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:361:in `call'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/actionpack/lib/action_controller/string_coercion.rb:25:in `call'
/usr/lib/ruby/gems/1.8/gems/rack-1.1.0/lib/rack/head.rb:9:in `call'
/usr/lib/ruby/gems/1.8/gems/rack-1.1.0/lib/rack/methodoverride.rb:24:in `call'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/actionpack/lib/action_controller/params_parser.rb:15:in `call'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/actionpack/lib/action_controller/session/cookie_store.rb:99:in `call'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/actionpack/lib/action_controller/failsafe.rb:26:in `call'
/usr/lib/ruby/gems/1.8/gems/rack-1.1.0/lib/rack/lock.rb:11:in `call'
/usr/lib/ruby/gems/1.8/gems/rack-1.1.0/lib/rack/lock.rb:11:in `synchronize'
/usr/lib/ruby/gems/1.8/gems/rack-1.1.0/lib/rack/lock.rb:11:in `call'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:106:in `call'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/railties/lib/rails/rack/static.rb:31:in `call'
/usr/lib/ruby/gems/1.8/gems/rack-1.1.0/lib/rack/urlmap.rb:47:in `call'
/usr/lib/ruby/gems/1.8/gems/rack-1.1.0/lib/rack/urlmap.rb:41:in `each'
/usr/lib/ruby/gems/1.8/gems/rack-1.1.0/lib/rack/urlmap.rb:41:in `call'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/railties/lib/rails/rack/log_tailer.rb:17:in `call'
/usr/lib/ruby/gems/1.8/gems/rack-1.1.0/lib/rack/content_length.rb:13:in `call'
/usr/lib/ruby/gems/1.8/gems/rack-1.1.0/lib/rack/handler/webrick.rb:48:in `service'
/usr/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'
/usr/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'
/usr/lib/ruby/1.8/webrick/server.rb:173:in `start_thread'
/usr/lib/ruby/1.8/webrick/server.rb:162:in `start'
/usr/lib/ruby/1.8/webrick/server.rb:162:in `start_thread'
/usr/lib/ruby/1.8/webrick/server.rb:95:in `start'
/usr/lib/ruby/1.8/webrick/server.rb:92:in `each'
/usr/lib/ruby/1.8/webrick/server.rb:92:in `start'
/usr/lib/ruby/1.8/webrick/server.rb:23:in `start'
/usr/lib/ruby/1.8/webrick/server.rb:82:in `start'
/usr/lib/ruby/gems/1.8/gems/rack-1.1.0/lib/rack/handler/webrick.rb:14:in `run'
/home/sh1594.lee/perforce_project/Remine121/vendor/rails/railties/lib/commands/server.rb:111
/usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:29:in `gem_original_require'
/usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:29:in `require'
script/server:3

Best regards,
Mr.Lee