Content

Upgrade Issue from Version 7.47 to 8.1

Hey Community,

there is an Openproject Installation 7.47 on Debian 8/9 and I like to upgrade it to the newest version 8.1.

After upgrade I run:

openproject configure

In postinstall section I get following error(s):

...
[openproject] ./bin/postinstall

* * * * * * * * * * * * * * * * * * * * * * * * *

* OpenProject requires UTF-8 encoding set on MySQL < 5.7 *
and UTF-8mb4 beyond that. Please ensure having set
* *
production:
* encoding: utf8mb4 *

* in config/database.yml. *
Otherwise, you WILL run into encoding issue when using 4 byte
* UTF-8 characters since utf8 encoding in MySQL doesn't support them. *

* If you have been running utf8 in the past, please see this guide *
on how to convert your database:
* https://mathiasbynens.be/notes/mysql-utf8mb4 *

* * * * * * * * * * * * * * * * * * * * * * * * *

== 10000000000000 ToV710AggregatedMigrations: migrating =======================
rake aborted!
StandardError: An error has occurred, all later migrations canceled:

It appears you are migrating from an incompatible version of ChiliProject. Yourdatabase has only some migrations from ChiliProject < v2.4.0 Please update your database to the schema of ChiliProject v2.4.0 and run the OpenProject migrations again. The following migrations are missing: [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 13, 14, 18, 21, 28, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 20090214190337, 20090312172426, 20090312194159, 20090318181151, 20090323224724, 20090401221305, 20090401231134, 20090403001910, 20090406161854, 20090425161243, 20090503121501, 20090503121505, 20090503121510, 20090614091200, 20090704172350, 20090704172355, 20090704172358, 20091010093521, 20091017212227, 20091017212457, 20091017212644, 20091017212938, 20091017213027, 20091017213113, 20091017213151, 20091017213228, 20091017213257, 20091017213332, 20091017213444, 20091017213536, 20091017213642, 20091017213716, 20091017213757, 20091017213835, 20091017213910, 20091017214015, 20091017214107, 20091017214136, 20091017214236, 20091017214308, 20091017214336, 20091017214406, 20091017214440, 20091017214519, 20091017214611, 20091017214644, 20091017214720, 20091017214750, 20091025163651, 20091108092559, 20091114105931, 20091123212029, 20091205124427, 20091220183509, 20091220183727, 20091220184736, 20091225164732, 20091227112908, 20100129193402, 20100129193813, 20100221100219, 20100313132032, 20100313171051, 20100705164950, 20100714111651, 20100714111652, 20100714111653, 20100714111654, 20100804112053, 20100819172912, 20101104182107, 20101107130441, 20101114115114, 20101114115359, 20110220160626, 20110223180944, 20110223180953, 20110224000000, 20110226120112, 20110226120132, 20110227125750, 20110228000000, 20110228000100, 20110314014400, 20110401192910, 20110519194936, 20110729125454]
/opt/openproject/db/migrate/10000000000000_to_v710_aggregated_migrations.rb:168:in raise\_on\_incomplete_migrations' /opt/openproject/db/migrate/10000000000000\_to\_v710\_aggregated\_migrations.rb:152:inraise_on_incomplete_3_0_migrations'
/opt/openproject/db/migrate/10000000000000_to_v710_aggregated_migrations.rb:114:in up' /opt/openproject/vendor/bundle/ruby/2.5.0/gems/activerecord-5.1.6/lib/active\_record/migration.rb:795:inexec_migration'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/activerecord-5.1.6/lib/active_record/migration.rb:776:in block (2 levels) in migrate' /opt/openproject/vendor/bundle/ruby/2.5.0/gems/activerecord-5.1.6/lib/active_record/migration.rb:775:inblock in migrate'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/activerecord-5.1.6/lib/active_record/connection_adapters/abstract/connection_pool.rb:408:in with\_connection' /opt/openproject/vendor/bundle/ruby/2.5.0/gems/activerecord-5.1.6/lib/active_record/migration.rb:774:inmigrate'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/activerecord-5.1.6/lib/active_record/migration.rb:953:in migrate' /opt/openproject/vendor/bundle/ruby/2.5.0/gems/activerecord-5.1.6/lib/active\_record/migration.rb:1230:inblock in execute_migration_in_transaction'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/activerecord-5.1.6/lib/active_record/migration.rb:1300:in ddl\_transaction' /opt/openproject/vendor/bundle/ruby/2.5.0/gems/activerecord-5.1.6/lib/active\_record/migration.rb:1229:inexecute_migration_in_transaction'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/activerecord-5.1.6/lib/active_record/migration.rb:1201:in block in migrate\_without_lock' /opt/openproject/vendor/bundle/ruby/2.5.0/gems/activerecord-5.1.6/lib/active_record/migration.rb:1200:ineach'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/activerecord-5.1.6/lib/active_record/migration.rb:1200:in migrate\_without_lock' /opt/openproject/vendor/bundle/ruby/2.5.0/gems/activerecord-5.1.6/lib/active_record/migration.rb:1148:inblock in migrate'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/activerecord-5.1.6/lib/active_record/migration.rb:1317:in with\_advisory_lock' /opt/openproject/vendor/bundle/ruby/2.5.0/gems/activerecord-5.1.6/lib/active_record/migration.rb:1148:inmigrate'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/activerecord-5.1.6/lib/active_record/migration.rb:1007:in up' /opt/openproject/vendor/bundle/ruby/2.5.0/gems/activerecord-5.1.6/lib/active_record/migration.rb:985:inmigrate'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/activerecord-5.1.6/lib/active_record/railties/databases.rake:58:in block (2 levels) in <top (required)>' /opt/openproject/vendor/bundle/ruby/2.5.0/gems/rake-12.3.1/exe/rake:27:in<top (required)>'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/bundler-1.15.2/lib/bundler/cli/exec.rb:74:in load' /opt/openproject/vendor/bundle/ruby/2.5.0/gems/bundler-1.15.2/lib/bundler/cli/exec.rb:74:inkernel_load'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/bundler-1.15.2/lib/bundler/cli/exec.rb:27:in run' /opt/openproject/vendor/bundle/ruby/2.5.0/gems/bundler-1.15.2/lib/bundler/cli.rb:360:inexec'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/bundler-1.15.2/lib/bundler/vendor/thor/lib/thor/command.rb:27:in run' /opt/openproject/vendor/bundle/ruby/2.5.0/gems/bundler-1.15.2/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:ininvoke_command'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/bundler-1.15.2/lib/bundler/vendor/thor/lib/thor.rb:369:in dispatch' /opt/openproject/vendor/bundle/ruby/2.5.0/gems/bundler-1.15.2/lib/bundler/cli.rb:20:indispatch'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/bundler-1.15.2/lib/bundler/vendor/thor/lib/thor/base.rb:444:in start' /opt/openproject/vendor/bundle/ruby/2.5.0/gems/bundler-1.15.2/lib/bundler/cli.rb:10:instart'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/bundler-1.15.2/exe/bundle:30:in block in <top (required)>' /opt/openproject/vendor/bundle/ruby/2.5.0/gems/bundler-1.15.2/lib/bundler/friendly\_errors.rb:121:inwith_friendly_errors'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/bundler-1.15.2/exe/bundle:22:in <top (required)>' /opt/openproject/bin/bundle:3:inload'
/opt/openproject/bin/bundle:3:in `

'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)

I now switched back to version 7.47 and all is fine, but how can I upgrade to version 8? I'm confused about the ChilyProject messages which I never get before. I upgraded from 5 to 6 to 7 and now ... bam!

So, what I have to do to upgrade my installation to version 8?

UPDATE

Verify, it's not an mysql error. Test it with different versions and utf-8/utf8mb4 settings.

Replies (3)

RE: Upgrade Issue from Version 7.47 to 8.1 - Added by Sebastian H. over 6 years ago

Nobody has an idea?

It's a little bit confused, even no answer in the bug forum where i have reported it too.

RE: Upgrade Issue from Version 7.47 to 8.1 - Added by Sebastian Plattner about 6 years ago

Hey

I saw the same, this helped me:
Add all these missing Migratons to your Database with INSERT INTO schema_migrations VALUES ('21'); and then run your migration with openproject run rake db:migration

I hope it does work for you too.
cheers

RE: Upgrade Issue from Version 7.47 to 8.1 - Added by Sebastian H. about 6 years ago

Hi,

thanks for the hint. Migration starts but throw errors.

Mysql2::Error: Table 'custom_actions_statuses' already exists

Dropping the table results in:

Index name 'index_custom_actions_statuses_on_custom_action_id' on table 'custom_actions_statuses' already exists

Removing the index brings me back to the first error and I'm in a loop.

Top Menu

Side Menu