Project

General

Profile

Error during upgrade from Redmine 1.4.4 to 2.6.6

Added by Ilia Sam over 8 years ago

Dear Community,

I have old redmine server in production with Redmine v. 1.4.4 on Debian.

I am trying to upgrade this server to v 2.6.6 using this guide [[http://www.redmine.org/projects/redmine/wiki/RedmineUpgrade]]
Had some problem, solved by installing (apt-get install ruby1.9.1-dev libmysqlclient-dev ruby-dev libfcgi libfcgi-dev libpq-dev libsqlite3-dev)
My problem was:
__________________
root@debian:/usr/share/redmine/redmine/config# bundle exec rake db:migrate RAILS_ENV=production
(in /usr/share/redmine/redmine)
20111201201315 AddUniqueIndexToIssueRelations: migrating =================
-- add_index(:issue_relations, [:issue_from_id, :issue_to_id], {:unique=>true})
rake aborted!
StandardError: An error has occurred, all later migrations canceled:

Index name 'index_issue_relations_on_issue_from_id_and_issue_to_id' on table 'issue_relations' already exists/var/lib/gems/1.9.1/gems/activerecord-4.2.3/lib/active_record/connection_adapters/abstract/schema_statements.rb:936:in `add_index_options'
/var/lib/gems/1.9.1/gems/activerecord-4.2.3/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:534:in `add_index'
/var/lib/gems/1.9.1/gems/activerecord-4.2.3/lib/active_record/migration.rb:661:in `block in method_missing'
/var/lib/gems/1.9.1/gems/activerecord-4.2.3/lib/active_record/migration.rb:631:in `block in say_with_time'
/var/lib/gems/1.9.1/gems/activerecord-4.2.3/lib/active_record/migration.rb:631:in `say_with_time'
/var/lib/gems/1.9.1/gems/activerecord-4.2.3/lib/active_record/migration.rb:651:in `method_missing'
/var/lib/gems/1.9.1/gems/activerecord-4.2.3/lib/active_record/migration.rb:416:in `method_missing'
/usr/share/redmine/redmine/db/migrate/20111201201315_add_unique_index_to_issue_relations.rb:10:in `up'
/var/lib/gems/1.9.1/gems/activerecord-4.2.3/lib/active_record/migration.rb:568:in `up'
/var/lib/gems/1.9.1/gems/activerecord-4.2.3/lib/active_record/migration.rb:608:in `exec_migration'
/var/lib/gems/1.9.1/gems/activerecord-4.2.3/lib/active_record/migration.rb:589:in `block (2 levels) in migrate'
/var/lib/gems/1.9.1/gems/activerecord-4.2.3/lib/active_record/migration.rb:588:in `block in migrate'
/var/lib/gems/1.9.1/gems/activerecord-4.2.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:292:in `with_connection'
/var/lib/gems/1.9.1/gems/activerecord-4.2.3/lib/active_record/migration.rb:587:in `migrate'
/var/lib/gems/1.9.1/gems/activerecord-4.2.3/lib/active_record/migration.rb:764:in `migrate'
/var/lib/gems/1.9.1/gems/activerecord-4.2.3/lib/active_record/migration.rb:994:in `block in execute_migration_in_transaction'
/var/lib/gems/1.9.1/gems/activerecord-4.2.3/lib/active_record/migration.rb:1042:in `ddl_transaction'
/var/lib/gems/1.9.1/gems/activerecord-4.2.3/lib/active_record/migration.rb:993:in `execute_migration_in_transaction'
/var/lib/gems/1.9.1/gems/activerecord-4.2.3/lib/active_record/migration.rb:955:in `block in migrate'
/var/lib/gems/1.9.1/gems/activerecord-4.2.3/lib/active_record/migration.rb:951:in `each'
/var/lib/gems/1.9.1/gems/activerecord-4.2.3/lib/active_record/migration.rb:951:in `migrate'
/var/lib/gems/1.9.1/gems/activerecord-4.2.3/lib/active_record/migration.rb:819:in `up'
/var/lib/gems/1.9.1/gems/activerecord-4.2.3/lib/active_record/migration.rb:797:in `migrate'
/var/lib/gems/1.9.1/gems/activerecord-4.2.3/lib/active_record/tasks/database_tasks.rb:137:in `migrate'
/var/lib/gems/1.9.1/gems/activerecord-4.2.3/lib/active_record/railties/databases.rake:44:in `block (2 levels) in <top (required)>'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)
_______________________________

___________
ruby -v
ruby 1.9.3p194 (2012-04-20 revision 35410) [x86_64-linux]
rails -v
Rails 4.2.3
___________

UPD:
Problem SOLVED

Just drop duplicate items from database:

mysql -u redmine_default -p

use redmine_default
DROP INDEX index_issue_relations_on_issue_from_id_and_issue_to_id ON issue_relations;
ALTER TABLE `repositories` DROP `identifier`;
ALTER TABLE `repositories` DROP `is_default`;
ALTER TABLE `custom_fields` DROP `multiple`;
ALTER TABLE `auth_sources` DROP `filter`;
exit

then run:
bundle install --without development test

Maybe my post will help someone