Redmine

Hi,

I try to upgrade Redmine from 0.8.7 to 0.9.2 but it failed at the database migration step "rake db:migrate RAILS_ENV=production" (see error message below).

Before the Redmine upgrade, I just upgraded rails as required.

Not only I'm not able to upgrade Redmine to 0.9.2, I'm no more able to re-install Redmine 0.8.7 from scratch as the same problem appears. It is quite stressful.

I didn't see any message on that problem.

• ruby 1.8.7 (2008-08-11 patchlevel 72) [i686-linux]
• rack (1.0.1)
• rails (2.3.5)
• rake (0.8.3)
• mysql

[root@ppfm redmine_ppfm]# rake db:migrate RAILS_ENV=production --trace
(in /home/httpd/redmine_ppfm)
** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
rake aborted!
Mysql::ProtocolError: invalid packet: sequence number mismatch(3 != 1(expected)): SET NAMES 'utf8'
/home/httpd/redmine_ppfm/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:219:in `log'
/home/httpd/redmine_ppfm/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:323:in `execute'
/home/httpd/redmine_ppfm/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:599:in `configure_connection'
/home/httpd/redmine_ppfm/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:594:in `connect'
/home/httpd/redmine_ppfm/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:203:in `initialize'
/home/httpd/redmine_ppfm/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:75:in `new'
/home/httpd/redmine_ppfm/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:75:in `mysql_connection'
/home/httpd/redmine_ppfm/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:223:in `send'
/home/httpd/redmine_ppfm/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:223:in `new_connection'
/home/httpd/redmine_ppfm/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:245:in `checkout_new_connection'
/home/httpd/redmine_ppfm/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:188:in `checkout'
/home/httpd/redmine_ppfm/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in `loop'
/home/httpd/redmine_ppfm/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in `checkout'
/usr/local/lib/ruby/1.8/monitor.rb:242:in `synchronize'
/home/httpd/redmine_ppfm/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:183:in `checkout'
/home/httpd/redmine_ppfm/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:98:in `connection'
/home/httpd/redmine_ppfm/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:326:in `retrieve_connection'
/home/httpd/redmine_ppfm/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:123:in `retrieve_connection'
/home/httpd/redmine_ppfm/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:115:in `connection'
/home/httpd/redmine_ppfm/vendor/plugins/awesome_nested_set/lib/awesome_nested_set.rb:217:in `quoted_left_column_name'
/home/httpd/redmine_ppfm/vendor/plugins/awesome_nested_set/lib/awesome_nested_set.rb:93:in `acts_as_nested_set'
/home/httpd/redmine_ppfm/app/models/project.rb:54
/usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
/usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/dependencies.rb:158:in `require'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/dependencies.rb:265:in `require_or_load_without_engine_additions'
/home/httpd/redmine_ppfm/vendor/plugins/engines/lib/engines/rails_extensions/dependencies.rb:132:in `require_or_load'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/dependencies.rb:425:in `load_missing_constant'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/dependencies.rb:80:in `const_missing'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/dependencies.rb:92:in `const_missing'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/dependencies.rb:437:in `load_missing_constant'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/dependencies.rb:96:in `const_missing'
/home/httpd/redmine_ppfm/app/models/attachment.rb:36
/usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
/usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/dependencies.rb:158:in `require'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/dependencies.rb:265:in `require_or_load_without_engine_additions'
/home/httpd/redmine_ppfm/vendor/plugins/engines/lib/engines/rails_extensions/dependencies.rb:132:in `require_or_load'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/dependencies.rb:425:in `load_missing_constant'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/dependencies.rb:80:in `const_missing'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/dependencies.rb:92:in `const_missing'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/dependencies.rb:437:in `load_missing_constant'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/dependencies.rb:80:in `const_missing'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/dependencies.rb:437:in `load_missing_constant'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/dependencies.rb:80:in `const_missing'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/dependencies.rb:437:in `load_missing_constant'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/dependencies.rb:80:in `const_missing'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/dependencies.rb:437:in `load_missing_constant'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/dependencies.rb:80:in `const_missing'
/home/httpd/redmine_ppfm/vendor/plugins/acts_as_attachable/lib/acts_as_attachable.rb:33:in `acts_as_attachable'
/home/httpd/redmine_ppfm/app/models/message.rb:22
/usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
/usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/dependencies.rb:158:in `require'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/dependencies.rb:265:in `require_or_load_without_engine_additions'
/home/httpd/redmine_ppfm/vendor/plugins/engines/lib/engines/rails_extensions/dependencies.rb:132:in `require_or_load'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/dependencies.rb:425:in `load_missing_constant'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/dependencies.rb:80:in `const_missing'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/dependencies.rb:92:in `const_missing'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/inflector.rb:361:in `constantize'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/inflector.rb:360:in `each'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/inflector.rb:360:in `constantize'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/core_ext/string/inflections.rb:162:in `constantize'
/home/httpd/redmine_ppfm/vendor/rails/activerecord/lib/active_record/observer.rb:157:in `observed_class'
/home/httpd/redmine_ppfm/vendor/rails/activerecord/lib/active_record/observer.rb:183:in `observed_classes'
/home/httpd/redmine_ppfm/vendor/rails/activerecord/lib/active_record/observer.rb:166:in `initialize'
/usr/local/lib/ruby/1.8/singleton.rb:94:in `new'
/usr/local/lib/ruby/1.8/singleton.rb:94:in `instance'
/home/httpd/redmine_ppfm/vendor/rails/activerecord/lib/active_record/observer.rb:38:in `instantiate_observers'
/home/httpd/redmine_ppfm/vendor/rails/activerecord/lib/active_record/observer.rb:36:in `each'
/home/httpd/redmine_ppfm/vendor/rails/activerecord/lib/active_record/observer.rb:36:in `instantiate_observers'
/home/httpd/redmine_ppfm/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:15:in `define_dispatcher_callbacks'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/callbacks.rb:182:in `call'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/callbacks.rb:182:in `evaluate_method'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/callbacks.rb:166:in `call'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/callbacks.rb:90:in `run'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/callbacks.rb:90:in `each'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/callbacks.rb:90:in `send'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/callbacks.rb:90:in `run'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/callbacks.rb:276:in `run_callbacks'
/home/httpd/redmine_ppfm/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:51:in `send'
/home/httpd/redmine_ppfm/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:51:in `run_prepare_callbacks'
/home/httpd/redmine_ppfm/config/../vendor/rails/railties/lib/initializer.rb:631:in `prepare_dispatcher'
/home/httpd/redmine_ppfm/config/../vendor/rails/railties/lib/initializer.rb:185:in `process'
/home/httpd/redmine_ppfm/config/../vendor/rails/railties/lib/initializer.rb:113:in `send'
/home/httpd/redmine_ppfm/config/../vendor/rails/railties/lib/initializer.rb:113:in `run'
/home/httpd/redmine_ppfm/config/environment.rb:20
/usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
/usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/dependencies.rb:156:in `require'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/dependencies.rb:521:in `new_constants_in'
/home/httpd/redmine_ppfm/vendor/rails/activesupport/lib/active_support/dependencies.rb:156:in `require'
/home/httpd/redmine_ppfm/vendor/rails/railties/lib/tasks/misc.rake:4
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:617:in `call'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:617:in `execute'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:612:in `each'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:612:in `execute'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:578:in `invoke_with_call_chain'
/usr/local/lib/ruby/1.8/monitor.rb:242:in `synchronize'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:571:in `invoke_with_call_chain'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:588:in `invoke_prerequisites'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:585:in `each'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:585:in `invoke_prerequisites'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:577:in `invoke_with_call_chain'
/usr/local/lib/ruby/1.8/monitor.rb:242:in `synchronize'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:571:in `invoke_with_call_chain'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:564:in `invoke'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:2019:in `invoke_task'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:1997:in `top_level'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:1997:in `each'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:1997:in `top_level'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:2036:in `standard_exception_handling'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:1991:in `top_level'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:1970:in `run'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:2036:in `standard_exception_handling'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:1967:in `run'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/bin/rake:31
/usr/local/bin/rake:19:in `load'
/usr/local/bin/rake:19

Thanks for your help,

Oana