Content
Issues after update from V12.4.5 to V12.5.0
Added by Gerald EN about 2 years ago
Dear Community,
after an version update from 12.4.5->12.5.0 this morning our OP server is not functional anymore.
The server reboots permanently and the logfile shows the following entries:
################LOG################
Mar 20 20:52:28 svrmgmt systemd[1]: openproject-web-1.service: Main process exited, code=exited, status=1/FAILURE
Mar 20 20:52:28 svrmgmt systemd[1]: openproject-web-1.service: Failed with result 'exit-code'.
Mar 20 20:52:29 svrmgmt systemd[1]: openproject-web-1.service: Service RestartSec=100ms expired, scheduling restart.
Mar 20 20:52:29 svrmgmt systemd[1]: openproject-web-1.service: Scheduled restart job, restart counter is at 549.
Mar 20 20:52:29 svrmgmt systemd[1]: Stopped openproject-web-1.service.
Mar 20 20:52:29 svrmgmt systemd[1]: Started openproject-web-1.service.
Mar 20 20:52:40 svrmgmt openproject-web-1.service[92495]: /opt/openproject/config/constants/settings/definition.rb:1279:in `find_env_var_override': Using unprefixed environment variables is deprecated. Please use OPENPROJECT_RAILS_CACHE_STORE instead of RAILS_CACHE_STORE (StructuredWarnings::StandardWarning)
Mar 20 20:52:40 svrmgmt openproject-web-1.service[92495]: => Booting Puma
Mar 20 20:52:40 svrmgmt openproject-web-1.service[92495]: => Rails 7.0.4.2 application starting in production
Mar 20 20:52:40 svrmgmt openproject-web-1.service[92495]: => Run `bin/rails server --help` for more startup options
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: Exiting
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: /opt/openproject/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:627:in `check_pending!': (ActiveRecord::PendingMigrationError)
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: Migrations are pending. To resolve this issue, run:
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: bin/rails db:migrate RAILS_ENV=production
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: You have 10 pending migrations:
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: 20221029194419_add_timestamps_to_queries.rb
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: 20221129074635_remove_activity_type_from_journals_table.rb
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: 20221130150352_create_project_journals.rb
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: 20221201140825_add_non_null_constraint_on_projects_identifier.rb
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: 20221202130039_fill_project_journals_with_existing_data.rb
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: 20221213092910_remove_default_values_from_journal_tables_definition.rb
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: 20230130134630_add_index_for_work_package_journals_project_id.rb
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: 20230306083203_non_null_data_reference_on_journals.rb
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: 20230309104056_unique_index_on_custom_fields_projects.rb
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: 20230314093106_add_update_delete_cascade_to_work_packages_project_id.rb
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/config/initializers/06-pending_migrations_check.rb:34:in `<top (required)>'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/railties-7.0.4.2/lib/rails/engine.rb:667:in `load'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/railties-7.0.4.2/lib/rails/engine.rb:667:in `block in load_config_initializer'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/activesupport-7.0.4.2/lib/active_support/notifications.rb:208:in `instrument'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/railties-7.0.4.2/lib/rails/engine.rb:666:in `load_config_initializer'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/railties-7.0.4.2/lib/rails/engine.rb:620:in `block (2 levels) in <class:Engine>'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/railties-7.0.4.2/lib/rails/engine.rb:619:in `each'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/railties-7.0.4.2/lib/rails/engine.rb:619:in `block in <class:Engine>'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/railties-7.0.4.2/lib/rails/initializable.rb:32:in `instance_exec'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/railties-7.0.4.2/lib/rails/initializable.rb:32:in `run'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/railties-7.0.4.2/lib/rails/initializable.rb:61:in `block in run_initializers'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/ruby-3.2.1/lib/ruby/3.2.0/tsort.rb:228:in `block in tsort_each'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/ruby-3.2.1/lib/ruby/3.2.0/tsort.rb:350:in `block (2 levels) in each_strongly_connected_component'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/ruby-3.2.1/lib/ruby/3.2.0/tsort.rb:422:in `block (2 levels) in each_strongly_connected_component_from'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/ruby-3.2.1/lib/ruby/3.2.0/tsort.rb:431:in `each_strongly_connected_component_from'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/ruby-3.2.1/lib/ruby/3.2.0/tsort.rb:421:in `block in each_strongly_connected_component_from'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/railties-7.0.4.2/lib/rails/initializable.rb:50:in `each'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/railties-7.0.4.2/lib/rails/initializable.rb:50:in `tsort_each_child'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/ruby-3.2.1/lib/ruby/3.2.0/tsort.rb:415:in `call'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/ruby-3.2.1/lib/ruby/3.2.0/tsort.rb:415:in `each_strongly_connected_component_from'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/ruby-3.2.1/lib/ruby/3.2.0/tsort.rb:349:in `block in each_strongly_connected_component'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/ruby-3.2.1/lib/ruby/3.2.0/tsort.rb:347:in `each'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/ruby-3.2.1/lib/ruby/3.2.0/tsort.rb:347:in `call'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/ruby-3.2.1/lib/ruby/3.2.0/tsort.rb:347:in `each_strongly_connected_component'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/ruby-3.2.1/lib/ruby/3.2.0/tsort.rb:226:in `tsort_each'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/ruby-3.2.1/lib/ruby/3.2.0/tsort.rb:205:in `tsort_each'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/railties-7.0.4.2/lib/rails/initializable.rb:60:in `run_initializers'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/railties-7.0.4.2/lib/rails/application.rb:372:in `initialize!'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/railties-7.0.4.2/lib/rails/railtie.rb:226:in `public_send'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/railties-7.0.4.2/lib/rails/railtie.rb:226:in `method_missing'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/config/environment.rb:32:in `<top (required)>'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from <internal:/opt/openproject/vendor/ruby-3.2.1/lib/ruby/3.2.0/rubygems/core_ext/kernel_require.rb>:37:in `require'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/zeitwerk-2.6.7/lib/zeitwerk/kernel.rb:38:in `require'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from config.ru:31:in `block in <main>'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/rack-2.2.6.3/lib/rack/builder.rb:116:in `eval'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/rack-2.2.6.3/lib/rack/builder.rb:116:in `new_from_string'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/rack-2.2.6.3/lib/rack/builder.rb:105:in `load_file'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/rack-2.2.6.3/lib/rack/builder.rb:66:in `parse_file'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/rack-2.2.6.3/lib/rack/server.rb:349:in `build_app_and_options_from_config'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/rack-2.2.6.3/lib/rack/server.rb:249:in `app'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/rack-2.2.6.3/lib/rack/server.rb:422:in `wrapped_app'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/rack-2.2.6.3/lib/rack/server.rb:312:in `block in start'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/rack-2.2.6.3/lib/rack/server.rb:379:in `handle_profiling'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/rack-2.2.6.3/lib/rack/server.rb:311:in `start'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/railties-7.0.4.2/lib/rails/commands/server/server_command.rb:38:in `start'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/railties-7.0.4.2/lib/rails/commands/server/server_command.rb:143:in `block in perform'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from <internal:kernel>:90:in `tap'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/railties-7.0.4.2/lib/rails/commands/server/server_command.rb:134:in `perform'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/thor-1.2.1/lib/thor/command.rb:27:in `run'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/thor-1.2.1/lib/thor/invocation.rb:127:in `invoke_command'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/thor-1.2.1/lib/thor.rb:392:in `dispatch'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/railties-7.0.4.2/lib/rails/command/base.rb:87:in `perform'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/railties-7.0.4.2/lib/rails/command.rb:48:in `invoke'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/railties-7.0.4.2/lib/rails/commands.rb:18:in `<top (required)>'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from <internal:/opt/openproject/vendor/ruby-3.2.1/lib/ruby/3.2.0/rubygems/core_ext/kernel_require.rb>:37:in `require'
Mar 20 20:52:41 svrmgmt openproject-web-1.service[92495]: from bin/rails:9:in `<main>'
Mar 20 20:52:41 svrmgmt systemd[1]: openproject-web-1.service: Main process exited, code=exited, status=1/FAILURE
Mar 20 20:52:41 svrmgmt systemd[1]: openproject-web-1.service: Failed with result 'exit-code'.
Mar 20 20:52:41 svrmgmt systemd[1]: openproject-web-1.service: Service RestartSec=100ms expired, scheduling restart.
Mar 20 20:52:41 svrmgmt systemd[1]: openproject-web-1.service: Scheduled restart job, restart counter is at 550.
Mar 20 20:52:41 svrmgmt systemd[1]: Stopped openproject-web-1.service.
Mar 20 20:52:41 svrmgmt systemd[1]: Started openproject-web-1.service.
################LOG#################
/opt/openproject/bin/rails db:migrate RAILS_ENV=production
Traceback (most recent call last):
4: from /opt/openproject/bin/rails:3:in `<main>'
3: from /opt/openproject/bin/rails:3:in `load'
2: from /opt/openproject/bin/spring:8:in `<top (required)>'
1: from /usr/share/rubygems/rubygems/core_ext/kernel_require.rb:59:in `require'
/usr/share/rubygems/rubygems/core_ext/kernel_require.rb:59:in `require': cannot load such file -- bundler (LoadError)
____________________________________________________
OS: Rocky Linux release 8.7
Any idea how I can solve this problem?
Thanks
Gerald
Replies (5)
Same here, enterprise edition in Docker.
seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/railtie.rb:154:in `block (3 levels) in <class:Railtie>': Ignoring /app/db/schema_cache.yml because it has expired. The current schema version is 20230306083203, but the one in the schema cache file is 20230314093106. (StructuredWarnings::StandardWarning) autoheal_1 | 21-03-2023 07:09:02 Container /compose_web_1 (a5fddf324174) found to be restarting - don't restart seeder_1 | rake aborted! seeder_1 | StandardError: An error has occurred, this and all later migrations canceled: seeder_1 | seeder_1 | Multiple indexes found on custom_fields_projects columns [:custom_field_id, :project_id]. Specify an index name from index_custom_fields_projects_on_custom_field_id_and_project_id, index_custom_fields_projects_on_custom_field_id_and_project_id seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/connection_adapters/abstract/schema_statements.rb:1459:in `index_name_for_remove' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/connection_adapters/postgresql/schema_statements.rb:470:in `remove_index' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:932:in `block in method_missing' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:900:in `block in say_with_time' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:900:in `say_with_time' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:921:in `method_missing' seeder_1 | /app/db/migrate/20230309104056_unique_index_on_custom_fields_projects.rb:35:in `change' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:870:in `exec_migration' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:854:in `block (2 levels) in migrate' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:853:in `block in migrate' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:215:in `with_connection' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:852:in `migrate' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1046:in `migrate' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1360:in `block in execute_migration_in_transaction' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/connection_adapters/abstract/transaction.rb:319:in `block in within_new_transaction' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activesupport-7.0.4.2/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activesupport-7.0.4.2/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activesupport-7.0.4.2/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activesupport-7.0.4.2/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/connection_adapters/abstract/transaction.rb:317:in `within_new_transaction' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/connection_adapters/abstract/database_statements.rb:316:in `transaction' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/transactions.rb:209:in `transaction' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1411:in `ddl_transaction' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1359:in `execute_migration_in_transaction' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1333:in `each' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1333:in `migrate_without_lock' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1282:in `block in migrate' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1432:in `block in with_advisory_lock' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:215:in `with_connection' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1447:in `with_advisory_lock_connection' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1428:in `with_advisory_lock' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1282:in `migrate' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1117:in `up' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1092:in `migrate' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/tasks/database_tasks.rb:262:in `migrate' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/railties/databases.rake:92:in `block (2 levels) in <top (required)>' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/exe/rake:27:in `<top (required)>' seeder_1 | /usr/local/bundle/gems/bundler-2.4.7/lib/bundler/cli/exec.rb:58:in `load' seeder_1 | /usr/local/bundle/gems/bundler-2.4.7/lib/bundler/cli/exec.rb:58:in `kernel_load' seeder_1 | /usr/local/bundle/gems/bundler-2.4.7/lib/bundler/cli/exec.rb:23:in `run' seeder_1 | /usr/local/bundle/gems/bundler-2.4.7/lib/bundler/cli.rb:492:in `exec' seeder_1 | /usr/local/bundle/gems/bundler-2.4.7/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run' seeder_1 | /usr/local/bundle/gems/bundler-2.4.7/lib/bundler/vendor/thor/lib/thor/invocation.rb:127:in `invoke_command' seeder_1 | /usr/local/bundle/gems/bundler-2.4.7/lib/bundler/vendor/thor/lib/thor.rb:392:in `dispatch' seeder_1 | /usr/local/bundle/gems/bundler-2.4.7/lib/bundler/cli.rb:34:in `dispatch' seeder_1 | /usr/local/bundle/gems/bundler-2.4.7/lib/bundler/vendor/thor/lib/thor/base.rb:485:in `start' seeder_1 | /usr/local/bundle/gems/bundler-2.4.7/lib/bundler/cli.rb:28:in `start' seeder_1 | /usr/local/bundle/gems/bundler-2.4.7/exe/bundle:45:in `block in <top (required)>' seeder_1 | /usr/local/bundle/gems/bundler-2.4.7/lib/bundler/friendly_errors.rb:117:in `with_friendly_errors' seeder_1 | /usr/local/bundle/gems/bundler-2.4.7/exe/bundle:33:in `<top (required)>' seeder_1 | /usr/local/bundle/bin/bundle:25:in `load' seeder_1 | /usr/local/bundle/bin/bundle:25:in `<main>' seeder_1 | seeder_1 | Caused by: seeder_1 | ArgumentError: Multiple indexes found on custom_fields_projects columns [:custom_field_id, :project_id]. Specify an index name from index_custom_fields_projects_on_custom_field_id_and_project_id, index_custom_fields_projects_on_custom_field_id_and_project_id seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/connection_adapters/abstract/schema_statements.rb:1459:in `index_name_for_remove' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/connection_adapters/postgresql/schema_statements.rb:470:in `remove_index' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:932:in `block in method_missing' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:900:in `block in say_with_time' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:900:in `say_with_time' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:921:in `method_missing' seeder_1 | /app/db/migrate/20230309104056_unique_index_on_custom_fields_projects.rb:35:in `change' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:870:in `exec_migration' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:854:in `block (2 levels) in migrate' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:853:in `block in migrate' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:215:in `with_connection' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:852:in `migrate' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1046:in `migrate' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1360:in `block in execute_migration_in_transaction' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/connection_adapters/abstract/transaction.rb:319:in `block in within_new_transaction' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activesupport-7.0.4.2/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activesupport-7.0.4.2/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activesupport-7.0.4.2/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activesupport-7.0.4.2/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/connection_adapters/abstract/transaction.rb:317:in `within_new_transaction' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/connection_adapters/abstract/database_statements.rb:316:in `transaction' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/transactions.rb:209:in `transaction' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1411:in `ddl_transaction' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1359:in `execute_migration_in_transaction' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1333:in `each' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1333:in `migrate_without_lock' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1282:in `block in migrate' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1432:in `block in with_advisory_lock' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:215:in `with_connection' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1447:in `with_advisory_lock_connection' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1428:in `with_advisory_lock' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1282:in `migrate' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1117:in `up' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/migration.rb:1092:in `migrate' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/tasks/database_tasks.rb:262:in `migrate' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.2/lib/active_record/railties/databases.rake:92:in `block (2 levels) in <top (required)>' seeder_1 | /app/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/exe/rake:27:in `<top (required)>' seeder_1 | /usr/local/bundle/gems/bundler-2.4.7/lib/bundler/cli/exec.rb:58:in `load' seeder_1 | /usr/local/bundle/gems/bundler-2.4.7/lib/bundler/cli/exec.rb:58:in `kernel_load' seeder_1 | /usr/local/bundle/gems/bundler-2.4.7/lib/bundler/cli/exec.rb:23:in `run' seeder_1 | /usr/local/bundle/gems/bundler-2.4.7/lib/bundler/cli.rb:492:in `exec' seeder_1 | /usr/local/bundle/gems/bundler-2.4.7/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run' seeder_1 | /usr/local/bundle/gems/bundler-2.4.7/lib/bundler/vendor/thor/lib/thor/invocation.rb:127:in `invoke_command' seeder_1 | /usr/local/bundle/gems/bundler-2.4.7/lib/bundler/vendor/thor/lib/thor.rb:392:in `dispatch' seeder_1 | /usr/local/bundle/gems/bundler-2.4.7/lib/bundler/cli.rb:34:in `dispatch' seeder_1 | /usr/local/bundle/gems/bundler-2.4.7/lib/bundler/vendor/thor/lib/thor/base.rb:485:in `start' seeder_1 | /usr/local/bundle/gems/bundler-2.4.7/lib/bundler/cli.rb:28:in `start' seeder_1 | /usr/local/bundle/gems/bundler-2.4.7/exe/bundle:45:in `block in <top (required)>' seeder_1 | /usr/local/bundle/gems/bundler-2.4.7/lib/bundler/friendly_errors.rb:117:in `with_friendly_errors' seeder_1 | /usr/local/bundle/gems/bundler-2.4.7/exe/bundle:33:in `<top (required)>' seeder_1 | /usr/local/bundle/bin/bundle:25:in `load' seeder_1 | /usr/local/bundle/bin/bundle:25:in `<main>' seeder_1 | Tasks: TOP => db:migrate seeder_1 | (See full trace by running task with --trace) seeder_1 | I, [2023-03-21T07:09:03.446692 #622] INFO -- : Migrating to UniqueIndexOnCustomFieldsProjects (20230309104056) seeder_1 | == 20230309104056 UniqueIndexOnCustomFieldsProjects: migrating ================ seeder_1 | -- execute("WITH selection AS ( SELECT project_id, custom_field_id FROM custom_fields_projects GROUP BY (project_id, custom_field_id) ), deletion AS ( DELETE FROM custom_fields_projects ), insertion AS ( INSERT INTO custom_fields_projects ( project_id, custom_field_id ) SELECT project_id, custom_field_id FROM selection ) SELECT 1") seeder_1 | -> 0.0024s seeder_1 | -- remove_index(:custom_fields_projects, [:custom_field_id, :project_id])@Gerald
It says there are 10 migrations missing. Did you perhaps simply not run
sudo openproject configureafter the update?Can you please try that and send us any output if it should fail?
@Rene
This seems to be a separate issue. If Gerald had the same issue there would be only 2 migrations missing, not 10, as the migration that fails for you is the second to last one (https://github.com/opf/openproject/blob/release/12.5/db/migrate/20230309104056_unique_index_on_custom_fields_projects.rb).
I'll answer that in the ticket you created.
@Markus
After downgrading to 12.4.5 and running sudo openproject configure -> OP was functional again.
Upgrading to 12.5.1 and running sudo openproject configure -> OP stays functional.
You are right in 12.5.0 i forgot about the cli command after the upgrade.
Sorry for the confusion.
No worries. I'm glad it's working for you now!
Markus Kahl wrote:
Nice source!