Upgrading Windows BItnami to CentOS Redmine (getting DB Migration error)

Added by Dominic Prakash 2 months ago

Current Version
- RUBYGEMS VERSION: 3.0.6
- RUBY VERSION: 2.4.6 (2019-04-01 patchlevel 354) [x86_64-linux]
- INSTALLATION DIRECTORY: /usr/local/rvm/gems/ruby-2.4.6
Redmine Version: 3.4.12
System: CentOS 7.7
MySQL: 5.6.46
Httpd: Apache 2.4.6 with Passennger

I am in the process of upgrading Redmine from 3.2.0 to 3.4.12 as per the doc/UPGRADING documentation and during DB migration I got the folowing error:

Command: bundle exec rake db:migrate RAILS_ENV="production"

Mysql2::Error: Duplicate column name 'default_status_id': ALTER TABLE `trackers` ADD `default_status_id` int(11)
/usr/local/rvm/gems/ruby-2.4.6/gems/mysql2-0.4.10/lib/mysql2/client.rb:120:in `_query'
....

I went through different documentation and many suggest to drop that column and prceed. I am not sure about it.

Later when I try to upgrade from 3.2.0 to 3.2.9, I got the same error too.

Any pointers please?

Replies (1)

RE: Upgrading Windows BItnami to CentOS Redmine (getting DB Migration error) - Added by Dominic Prakash about 1 month ago

After trying various option I was able to solve this issue.

I installed Ruby version 2.3.8

There are some difference between bitnami (windows) version 3.2.0 and the core Redmi version (3.2.0). So instead of upgrding I actually installed the "approximately" same version in my CentOS. First, separately exported the DB with and without data from both Win and new CentOS installations. I did not see any table structural differences. Next I inspected the newly installed database and checked the "INSERT" staements. There were 4 INSERT seatements noted and I removed those records manually from `users`, `email_addresses`, `roles` and `schema_migrations`. Before removing the records from `schema_migrations`, I copied the stement and replaced into the windows exported SQL with full data.

Then I imported the data into the new DB structure. Now I am able to upgrade to subsequent versions. Now I have upgraded from 3.2.0 to 3.2.9.

(1-1/1)