Project

General

Profile

Forums » Help »

Migration problem from redmine 0.8.4 (MySQL) to 1.4 (Postgres)

Added by Miguel PELLAROQUE over 10 years ago

I'm trying to migrate my current Redmine from version 0.8.4 to version 1.4 but not only ... I also change my DBMS
0.8.4 -> MySQL
1.4.x -> Postgres

I allready move all my tables to the new postgres but when I run the rake/migrate command I meet a problem

Below, you can see the execution trace of the migration command

#RAILS_ENV=prod_srvelec rake db:migrate --trace
Please install RDoc 2.4.2+ to generate documentation.
  • Invoke db:migrate (first_time)
  • Invoke environment (first_time)
  • Execute environment
  • Execute db:migrate
  • EnableCalendarAndGanttModulesWhereAppropriate: migrating ================*
    rake aborted!
    An error has occurred, this and all later migrations canceled:

PGError: ERROR: relation "enabled_modules_id_seq" does not exist
: SELECT currval('enabled_modules_id_seq')
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:227:in `log'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:520:in `execute'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:1002:in `select_raw'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:989:in `select'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cache'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:62:in `select_all'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:13:in `select_one'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:19:in `select_value'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:983:in `last_insert_id'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:478:in `insert'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/base.rb:2961:in `create_without_timestamps'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/timestamp.rb:53:in `create_without_callbacks'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/callbacks.rb:266:in `create'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/base.rb:2927:in `create_or_update_without_callbacks'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/callbacks.rb:250:in `create_or_update'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/base.rb:2577:in `save_without_validation'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/validations.rb:1089:in `save_without_dirty'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/dirty.rb:79:in `save_without_transactions'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/transactions.rb:229:in `send'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/transactions.rb:229:in `with_transaction_returning_status'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:136:in `transaction'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/transactions.rb:182:in `transaction'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/transactions.rb:228:in `with_transaction_returning_status'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/transactions.rb:196:in `save'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/transactions.rb:208:in `rollback_active_record_state!'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/transactions.rb:196:in `save'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/base.rb:727:in `create'
./db/migrate//20100819172912_enable_calendar_and_gantt_modules_where_appropriate.rb:4:in `up_without_benchmarks'
./db/migrate//20100819172912_enable_calendar_and_gantt_modules_where_appropriate.rb:3:in `each'
./db/migrate//20100819172912_enable_calendar_and_gantt_modules_where_appropriate.rb:3:in `up_without_benchmarks'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/migration.rb:282:in `send'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/migration.rb:282:in `migrate'
/usr/local/lib/ruby/1.8/benchmark.rb:293:in `measure'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/migration.rb:282:in `migrate'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/migration.rb:365:in `__send__'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/migration.rb:365:in `migrate'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/migration.rb:491:in `migrate'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/migration.rb:565:in `call'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/migration.rb:565:in `ddl_transaction'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:136:in `transaction'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/transactions.rb:182:in `transaction'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/migration.rb:565:in `ddl_transaction'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/migration.rb:490:in `migrate'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/migration.rb:477:in `each'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/migration.rb:477:in `migrate'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/migration.rb:401:in `up'
/var/www/redmine_srvelec/vendor/rails/activerecord/lib/active_record/migration.rb:383:in `migrate'
/var/www/redmine_srvelec/vendor/rails/railties/lib/tasks/databases.rake:112
/usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:205:in `call'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:205:in `execute'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:200:in `each'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:200:in `execute'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:158: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.9.2.2/lib/rake/task.rb:151:in `invoke_with_call_chain'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:144:in `invoke'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:116:in `invoke_task'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:94:in `top_level'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:94:in `each'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:94:in `top_level'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:133:in `standard_exception_handling'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:88:in `top_level'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:66:in `run'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:133:in `standard_exception_handling'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:63:in `run'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/bin/rake:33
/usr/local/bin/rake:19:in `load'
/usr/local/bin/rake:19
Tasks: TOP => db:migrate

Maybe somebody in this forum could help me to fix this problem ?


Replies (1)

RE: Migration problem from redmine 0.8.4 (MySQL) to 1.4 (Postgres) - Added by Martin Denizet (redmine.org team member) over 10 years ago

Hi Miguel,

In your situation, I'd try to:
  1. Dump your existing DB using SeedDumper
  2. Make a new, clean install of 0.8.4 with postgres, without loading the Redmine seed data
  3. Load the seed created by SeedDumper
  4. Make a standard update to 1.4

You could also try to use yaml_db

Hope it helps,

Martin

    (1-1/1)