[BUG] [Unraid] Problems with using MariaDB as Database #3
Comments
|
Thanks for opening your first issue here! Be sure to follow the relevant issue templates, or risk having this issue marked as invalid. |
|
@Floppy is this an issue you're aware of with mariadb that requires any different/additional init steps? I'm seeing the same |
|
No, I wasn't aware, but it's definitely a Manyfold bug; I'll investigate. |
|
I've got this replicated locally, so yep, I'll take care of it. |
|
Just released a fix for this (and another MariaDB issue I found at the same time) in v0.74.2. The linuxserver robots should get a build out soon for you; I hope it gets things up and running! |
|
I experience the same error on a new configuration with a fresh mariadb in v0.74.2 |
|
Oh, that's not good. Same error, |
|
For me it's working now since updating |
I've installed it today for the first time, so I downloaded directly the latest image. The issue happens with mariadb and with sqlite too |
|
Hm, SQLite too implies a different error, and should have been caught in our test systems which use it. Could you post the output you see? |
|
|
I don't know if is related or I should open another issue, but I've seen in the logs that there is a complain about the missing secret key, but if I try to run |
|
Looks like something is broken with |
The correct command is (I'm not sure why (or if) rake secret worked before, but rails secret is the right way) |
|
OK, @AndreaPro the issue is indeed that your SECRET_KEY_BASE value is missing, it's not database related. We should probably move that to another issue (unless @thespad has already fixed it) and close this one, because the original issue seems to be fixed. |
You need to update your docs then :)
|
|
LOL so I do! My bad! |
|
Done :) |
Yes, I've pushed a fix for the helper script that should sort out the secret generation. |
Is there an existing issue for this?
Current Behavior
Initial Database Setup fails when using MariaDB, so the container cannot be set up.
Expected Behavior
Successful setup using Mariadb
Steps To Reproduce
Environment
CPU architecture
x86-64
Docker creation
Container logs
Linuxserver.io version: v0.74.1-ls4 Build-date: 2024-07-25T12:50:51+00:00 ─────────────────────────────────────── Waiting for DB to be available **** Running Manyfold database init. **** Illegal option -p Illegal option -p Mysql2::Error: Table 'manyfold.flipper_gates' doesn't exist. You likely need to run `rails g flipper:active_record` and/or `rails db:migrate`. bin/rails aborted! StandardError: An error has occurred, all later migrations canceled: (StandardError) Mysql2::Error: Cannot drop index 'index_taggings_on_tag_id': needed in a foreign key constraint /app/www/vendor/bundle/ruby/3.3.0/gems/mysql2-0.5.6/lib/mysql2/client.rb:151:in `_query' /app/www/vendor/bundle/ruby/3.3.0/gems/mysql2-0.5.6/lib/mysql2/client.rb:151:in `block in query' /app/www/vendor/bundle/ruby/3.3.0/gems/mysql2-0.5.6/lib/mysql2/client.rb:150:in `handle_interrupt' /app/www/vendor/bundle/ruby/3.3.0/gems/mysql2-0.5.6/lib/mysql2/client.rb:150:in `query' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/connection_adapters/mysql2/database_statements.rb:100:in `block (2 levels) in raw_execute' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/connection_adapters/abstract_adapter.rb:1028:in `block in with_raw_connection' /app/www/vendor/bundle/ruby/3.3.0/gems/activesupport-7.1.3.4/lib/active_support/concurrency/null_lock.rb:9:in `synchronize' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/connection_adapters/abstract_adapter.rb:1000:in `with_raw_connection' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/connection_adapters/mysql2/database_statements.rb:98:in `block in raw_execute' /app/www/vendor/bundle/ruby/3.3.0/gems/activesupport-7.1.3.4/lib/active_support/notifications/instrumenter.rb:58:in `instrument' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/connection_adapters/abstract_adapter.rb:1143:in `log' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/connection_adapters/mysql2/database_statements.rb:97:in `raw_execute' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/connection_adapters/abstract/database_statements.rb:521:in `internal_execute' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/connection_adapters/abstract/database_statements.rb:131:in `execute' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/connection_adapters/abstract/query_cache.rb:25:in `execute' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/connection_adapters/abstract/schema_statements.rb:942:in `remove_index' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration/default_strategy.rb:10:in `method_missing' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1047:in `block in method_missing' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1017:in `block in say_with_time' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1017:in `say_with_time' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1036:in `method_missing' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration/compatibility.rb:447:in `remove_index' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:735:in `method_missing' /app/www/db/migrate/20210212143002_add_missing_unique_indices.acts_as_taggable_on_engine.rb:11:in `up' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:949:in `up' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:989:in `public_send' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:989:in `exec_migration' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:970:in `block (2 levels) in migrate' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:969:in `block in migrate' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:227:in `with_connection' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:968:in `migrate' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1178:in `migrate' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1529:in `block in execute_migration_in_transaction' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1582:in `ddl_transaction' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1528:in `execute_migration_in_transaction' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1503:in `each' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1503:in `migrate_without_lock' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1448:in `block in migrate' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1600:in `with_advisory_lock' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1448:in `migrate' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1274:in `up' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1249:in `migrate' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/tasks/database_tasks.rb:243:in `migrate' /app/www/vendor/bundle/ruby/3.3.0/bundler/gems/data-migrate-9f3e76af0139/lib/data_migrate/database_tasks.rb:217:in `block (3 levels) in migrate_with_data' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/tasks/database_tasks.rb:501:in `block in with_temporary_connection' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/tasks/database_tasks.rb:518:in `with_temporary_pool' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/tasks/database_tasks.rb:500:in `with_temporary_connection' /app/www/vendor/bundle/ruby/3.3.0/bundler/gems/data-migrate-9f3e76af0139/lib/data_migrate/database_tasks.rb:213:in `block (2 levels) in migrate_with_data' /app/www/vendor/bundle/ruby/3.3.0/bundler/gems/data-migrate-9f3e76af0139/lib/data_migrate/database_tasks.rb:208:in `each' /app/www/vendor/bundle/ruby/3.3.0/bundler/gems/data-migrate-9f3e76af0139/lib/data_migrate/database_tasks.rb:208:in `block in migrate_with_data' /app/www/vendor/bundle/ruby/3.3.0/bundler/gems/data-migrate-9f3e76af0139/lib/data_migrate/database_tasks.rb:207:in `each' /app/www/vendor/bundle/ruby/3.3.0/bundler/gems/data-migrate-9f3e76af0139/lib/data_migrate/database_tasks.rb:207:in `migrate_with_data' /app/www/vendor/bundle/ruby/3.3.0/bundler/gems/data-migrate-9f3e76af0139/lib/data_migrate/database_tasks.rb:250:in `block (2 levels) in prepare_all_with_data' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/tasks/database_tasks.rb:518:in `with_temporary_pool' /app/www/vendor/bundle/ruby/3.3.0/bundler/gems/data-migrate-9f3e76af0139/lib/data_migrate/database_tasks.rb:230:in `block in prepare_all_with_data' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/tasks/database_tasks.rb:562:in `block (2 levels) in each_current_configuration' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/tasks/database_tasks.rb:559:in `each' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/tasks/database_tasks.rb:559:in `block in each_current_configuration' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/tasks/database_tasks.rb:558:in `each' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/tasks/database_tasks.rb:558:in `each_current_configuration' /app/www/vendor/bundle/ruby/3.3.0/bundler/gems/data-migrate-9f3e76af0139/lib/data_migrate/database_tasks.rb:227:in `prepare_all_with_data' /app/www/vendor/bundle/ruby/3.3.0/bundler/gems/data-migrate-9f3e76af0139/tasks/databases.rake:153:in `block (3 levels) in <main>' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/task.rb:281:in `block in execute' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/task.rb:281:in `each' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/task.rb:281:in `execute' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/task.rb:219:in `block in invoke_with_call_chain' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/task.rb:199:in `synchronize' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/task.rb:199:in `invoke_with_call_chain' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/task.rb:188:in `invoke' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/application.rb:188:in `invoke_task' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/application.rb:138:in `block (2 levels) in top_level' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/application.rb:138:in `each' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/application.rb:138:in `block in top_level' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/application.rb:147:in `run_with_threads' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/application.rb:132:in `top_level' /app/www/vendor/bundle/ruby/3.3.0/gems/railties-7.1.3.4/lib/rails/commands/rake/rake_command.rb:27:in `block (2 levels) in perform' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/application.rb:214:in `standard_exception_handling' /app/www/vendor/bundle/ruby/3.3.0/gems/railties-7.1.3.4/lib/rails/commands/rake/rake_command.rb:27:in `block in perform' /app/www/vendor/bundle/ruby/3.3.0/gems/railties-7.1.3.4/lib/rails/commands/rake/rake_command.rb:44:in `block in with_rake' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/rake_module.rb:59:in `with_application' /app/www/vendor/bundle/ruby/3.3.0/gems/railties-7.1.3.4/lib/rails/commands/rake/rake_command.rb:41:in `with_rake' /app/www/vendor/bundle/ruby/3.3.0/gems/railties-7.1.3.4/lib/rails/commands/rake/rake_command.rb:20:in `perform' /app/www/vendor/bundle/ruby/3.3.0/gems/railties-7.1.3.4/lib/rails/command.rb:156:in `invoke_rake' /app/www/vendor/bundle/ruby/3.3.0/gems/railties-7.1.3.4/lib/rails/command.rb:73:in `block in invoke' /app/www/vendor/bundle/ruby/3.3.0/gems/railties-7.1.3.4/lib/rails/command.rb:149:in `with_argv' /app/www/vendor/bundle/ruby/3.3.0/gems/railties-7.1.3.4/lib/rails/command.rb:69:in `invoke' /app/www/vendor/bundle/ruby/3.3.0/gems/railties-7.1.3.4/lib/rails/commands.rb:18:in `<main>' /app/www/vendor/bundle/ruby/3.3.0/gems/bootsnap-1.18.3/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:30:in `require' Caused by: ActiveRecord::StatementInvalid: Mysql2::Error: Cannot drop index 'index_taggings_on_tag_id': needed in a foreign key constraint (ActiveRecord::StatementInvalid) /app/www/vendor/bundle/ruby/3.3.0/gems/mysql2-0.5.6/lib/mysql2/client.rb:151:in `_query' /app/www/vendor/bundle/ruby/3.3.0/gems/mysql2-0.5.6/lib/mysql2/client.rb:151:in `block in query' /app/www/vendor/bundle/ruby/3.3.0/gems/mysql2-0.5.6/lib/mysql2/client.rb:150:in `handle_interrupt' /app/www/vendor/bundle/ruby/3.3.0/gems/mysql2-0.5.6/lib/mysql2/client.rb:150:in `query' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/connection_adapters/mysql2/database_statements.rb:100:in `block (2 levels) in raw_execute' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/connection_adapters/abstract_adapter.rb:1028:in `block in with_raw_connection' /app/www/vendor/bundle/ruby/3.3.0/gems/activesupport-7.1.3.4/lib/active_support/concurrency/null_lock.rb:9:in `synchronize' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/connection_adapters/abstract_adapter.rb:1000:in `with_raw_connection' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/connection_adapters/mysql2/database_statements.rb:98:in `block in raw_execute' /app/www/vendor/bundle/ruby/3.3.0/gems/activesupport-7.1.3.4/lib/active_support/notifications/instrumenter.rb:58:in `instrument' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/connection_adapters/abstract_adapter.rb:1143:in `log' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/connection_adapters/mysql2/database_statements.rb:97:in `raw_execute' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/connection_adapters/abstract/database_statements.rb:521:in `internal_execute' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/connection_adapters/abstract/database_statements.rb:131:in `execute' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/connection_adapters/abstract/query_cache.rb:25:in `execute' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/connection_adapters/abstract/schema_statements.rb:942:in `remove_index' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration/default_strategy.rb:10:in `method_missing' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1047:in `block in method_missing' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1017:in `block in say_with_time' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1017:in `say_with_time' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1036:in `method_missing' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration/compatibility.rb:447:in `remove_index' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:735:in `method_missing' /app/www/db/migrate/20210212143002_add_missing_unique_indices.acts_as_taggable_on_engine.rb:11:in `up' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:949:in `up' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:989:in `public_send' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:989:in `exec_migration' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:970:in `block (2 levels) in migrate' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:969:in `block in migrate' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:227:in `with_connection' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:968:in `migrate' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1178:in `migrate' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1529:in `block in execute_migration_in_transaction' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1582:in `ddl_transaction' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1528:in `execute_migration_in_transaction' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1503:in `each' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1503:in `migrate_without_lock' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1448:in `block in migrate' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1600:in `with_advisory_lock' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1448:in `migrate' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1274:in `up' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1249:in `migrate' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/tasks/database_tasks.rb:243:in `migrate' /app/www/vendor/bundle/ruby/3.3.0/bundler/gems/data-migrate-9f3e76af0139/lib/data_migrate/database_tasks.rb:217:in `block (3 levels) in migrate_with_data' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/tasks/database_tasks.rb:501:in `block in with_temporary_connection' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/tasks/database_tasks.rb:518:in `with_temporary_pool' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/tasks/database_tasks.rb:500:in `with_temporary_connection' /app/www/vendor/bundle/ruby/3.3.0/bundler/gems/data-migrate-9f3e76af0139/lib/data_migrate/database_tasks.rb:213:in `block (2 levels) in migrate_with_data' /app/www/vendor/bundle/ruby/3.3.0/bundler/gems/data-migrate-9f3e76af0139/lib/data_migrate/database_tasks.rb:208:in `each' /app/www/vendor/bundle/ruby/3.3.0/bundler/gems/data-migrate-9f3e76af0139/lib/data_migrate/database_tasks.rb:208:in `block in migrate_with_data' /app/www/vendor/bundle/ruby/3.3.0/bundler/gems/data-migrate-9f3e76af0139/lib/data_migrate/database_tasks.rb:207:in `each' /app/www/vendor/bundle/ruby/3.3.0/bundler/gems/data-migrate-9f3e76af0139/lib/data_migrate/database_tasks.rb:207:in `migrate_with_data' /app/www/vendor/bundle/ruby/3.3.0/bundler/gems/data-migrate-9f3e76af0139/lib/data_migrate/database_tasks.rb:250:in `block (2 levels) in prepare_all_with_data' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/tasks/database_tasks.rb:518:in `with_temporary_pool' /app/www/vendor/bundle/ruby/3.3.0/bundler/gems/data-migrate-9f3e76af0139/lib/data_migrate/database_tasks.rb:230:in `block in prepare_all_with_data' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/tasks/database_tasks.rb:562:in `block (2 levels) in each_current_configuration' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/tasks/database_tasks.rb:559:in `each' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/tasks/database_tasks.rb:559:in `block in each_current_configuration' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/tasks/database_tasks.rb:558:in `each' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/tasks/database_tasks.rb:558:in `each_current_configuration' /app/www/vendor/bundle/ruby/3.3.0/bundler/gems/data-migrate-9f3e76af0139/lib/data_migrate/database_tasks.rb:227:in `prepare_all_with_data' /app/www/vendor/bundle/ruby/3.3.0/bundler/gems/data-migrate-9f3e76af0139/tasks/databases.rake:153:in `block (3 levels) in <main>' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/task.rb:281:in `block in execute' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/task.rb:281:in `each' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/task.rb:281:in `execute' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/task.rb:219:in `block in invoke_with_call_chain' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/task.rb:199:in `synchronize' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/task.rb:199:in `invoke_with_call_chain' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/task.rb:188:in `invoke' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/application.rb:188:in `invoke_task' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/application.rb:138:in `block (2 levels) in top_level' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/application.rb:138:in `each' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/application.rb:138:in `block in top_level' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/application.rb:147:in `run_with_threads' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/application.rb:132:in `top_level' /app/www/vendor/bundle/ruby/3.3.0/gems/railties-7.1.3.4/lib/rails/commands/rake/rake_command.rb:27:in `block (2 levels) in perform' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/application.rb:214:in `standard_exception_handling' /app/www/vendor/bundle/ruby/3.3.0/gems/railties-7.1.3.4/lib/rails/commands/rake/rake_command.rb:27:in `block in perform' /app/www/vendor/bundle/ruby/3.3.0/gems/railties-7.1.3.4/lib/rails/commands/rake/rake_command.rb:44:in `block in with_rake' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/rake_module.rb:59:in `with_application' /app/www/vendor/bundle/ruby/3.3.0/gems/railties-7.1.3.4/lib/rails/commands/rake/rake_command.rb:41:in `with_rake' /app/www/vendor/bundle/ruby/3.3.0/gems/railties-7.1.3.4/lib/rails/commands/rake/rake_command.rb:20:in `perform' /app/www/vendor/bundle/ruby/3.3.0/gems/railties-7.1.3.4/lib/rails/command.rb:156:in `invoke_rake' /app/www/vendor/bundle/ruby/3.3.0/gems/railties-7.1.3.4/lib/rails/command.rb:73:in `block in invoke' /app/www/vendor/bundle/ruby/3.3.0/gems/railties-7.1.3.4/lib/rails/command.rb:149:in `with_argv' /app/www/vendor/bundle/ruby/3.3.0/gems/railties-7.1.3.4/lib/rails/command.rb:69:in `invoke' /app/www/vendor/bundle/ruby/3.3.0/gems/railties-7.1.3.4/lib/rails/commands.rb:18:in `<main>' /app/www/vendor/bundle/ruby/3.3.0/gems/bootsnap-1.18.3/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:30:in `require' Caused by: Mysql2::Error: Cannot drop index 'index_taggings_on_tag_id': needed in a foreign key constraint (Mysql2::Error) /app/www/vendor/bundle/ruby/3.3.0/gems/mysql2-0.5.6/lib/mysql2/client.rb:151:in `_query' /app/www/vendor/bundle/ruby/3.3.0/gems/mysql2-0.5.6/lib/mysql2/client.rb:151:in `block in query' /app/www/vendor/bundle/ruby/3.3.0/gems/mysql2-0.5.6/lib/mysql2/client.rb:150:in `handle_interrupt' /app/www/vendor/bundle/ruby/3.3.0/gems/mysql2-0.5.6/lib/mysql2/client.rb:150:in `query' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/connection_adapters/mysql2/database_statements.rb:100:in `block (2 levels) in raw_execute' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/connection_adapters/abstract_adapter.rb:1028:in `block in with_raw_connection' /app/www/vendor/bundle/ruby/3.3.0/gems/activesupport-7.1.3.4/lib/active_support/concurrency/null_lock.rb:9:in `synchronize' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/connection_adapters/abstract_adapter.rb:1000:in `with_raw_connection' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/connection_adapters/mysql2/database_statements.rb:98:in `block in raw_execute' /app/www/vendor/bundle/ruby/3.3.0/gems/activesupport-7.1.3.4/lib/active_support/notifications/instrumenter.rb:58:in `instrument' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/connection_adapters/abstract_adapter.rb:1143:in `log' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/connection_adapters/mysql2/database_statements.rb:97:in `raw_execute' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/connection_adapters/abstract/database_statements.rb:521:in `internal_execute' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/connection_adapters/abstract/database_statements.rb:131:in `execute' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/connection_adapters/abstract/query_cache.rb:25:in `execute' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/connection_adapters/abstract/schema_statements.rb:942:in `remove_index' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration/default_strategy.rb:10:in `method_missing' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1047:in `block in method_missing' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1017:in `block in say_with_time' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1017:in `say_with_time' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1036:in `method_missing' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration/compatibility.rb:447:in `remove_index' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:735:in `method_missing' /app/www/db/migrate/20210212143002_add_missing_unique_indices.acts_as_taggable_on_engine.rb:11:in `up' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:949:in `up' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:989:in `public_send' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:989:in `exec_migration' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:970:in `block (2 levels) in migrate' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:969:in `block in migrate' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:227:in `with_connection' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:968:in `migrate' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1178:in `migrate' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1529:in `block in execute_migration_in_transaction' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1582:in `ddl_transaction' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1528:in `execute_migration_in_transaction' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1503:in `each' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1503:in `migrate_without_lock' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1448:in `block in migrate' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1600:in `with_advisory_lock' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1448:in `migrate' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1274:in `up' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1249:in `migrate' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/tasks/database_tasks.rb:243:in `migrate' /app/www/vendor/bundle/ruby/3.3.0/bundler/gems/data-migrate-9f3e76af0139/lib/data_migrate/database_tasks.rb:217:in `block (3 levels) in migrate_with_data' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/tasks/database_tasks.rb:501:in `block in with_temporary_connection' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/tasks/database_tasks.rb:518:in `with_temporary_pool' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/tasks/database_tasks.rb:500:in `with_temporary_connection' /app/www/vendor/bundle/ruby/3.3.0/bundler/gems/data-migrate-9f3e76af0139/lib/data_migrate/database_tasks.rb:213:in `block (2 levels) in migrate_with_data' /app/www/vendor/bundle/ruby/3.3.0/bundler/gems/data-migrate-9f3e76af0139/lib/data_migrate/database_tasks.rb:208:in `each' /app/www/vendor/bundle/ruby/3.3.0/bundler/gems/data-migrate-9f3e76af0139/lib/data_migrate/database_tasks.rb:208:in `block in migrate_with_data' /app/www/vendor/bundle/ruby/3.3.0/bundler/gems/data-migrate-9f3e76af0139/lib/data_migrate/database_tasks.rb:207:in `each' /app/www/vendor/bundle/ruby/3.3.0/bundler/gems/data-migrate-9f3e76af0139/lib/data_migrate/database_tasks.rb:207:in `migrate_with_data' /app/www/vendor/bundle/ruby/3.3.0/bundler/gems/data-migrate-9f3e76af0139/lib/data_migrate/database_tasks.rb:250:in `block (2 levels) in prepare_all_with_data' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/tasks/database_tasks.rb:518:in `with_temporary_pool' /app/www/vendor/bundle/ruby/3.3.0/bundler/gems/data-migrate-9f3e76af0139/lib/data_migrate/database_tasks.rb:230:in `block in prepare_all_with_data' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/tasks/database_tasks.rb:562:in `block (2 levels) in each_current_configuration' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/tasks/database_tasks.rb:559:in `each' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/tasks/database_tasks.rb:559:in `block in each_current_configuration' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/tasks/database_tasks.rb:558:in `each' /app/www/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/tasks/database_tasks.rb:558:in `each_current_configuration' /app/www/vendor/bundle/ruby/3.3.0/bundler/gems/data-migrate-9f3e76af0139/lib/data_migrate/database_tasks.rb:227:in `prepare_all_with_data' /app/www/vendor/bundle/ruby/3.3.0/bundler/gems/data-migrate-9f3e76af0139/tasks/databases.rake:153:in `block (3 levels) in <main>' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/task.rb:281:in `block in execute' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/task.rb:281:in `each' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/task.rb:281:in `execute' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/task.rb:219:in `block in invoke_with_call_chain' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/task.rb:199:in `synchronize' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/task.rb:199:in `invoke_with_call_chain' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/task.rb:188:in `invoke' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/application.rb:188:in `invoke_task' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/application.rb:138:in `block (2 levels) in top_level' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/application.rb:138:in `each' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/application.rb:138:in `block in top_level' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/application.rb:147:in `run_with_threads' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/application.rb:132:in `top_level' /app/www/vendor/bundle/ruby/3.3.0/gems/railties-7.1.3.4/lib/rails/commands/rake/rake_command.rb:27:in `block (2 levels) in perform' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/application.rb:214:in `standard_exception_handling' /app/www/vendor/bundle/ruby/3.3.0/gems/railties-7.1.3.4/lib/rails/commands/rake/rake_command.rb:27:in `block in perform' /app/www/vendor/bundle/ruby/3.3.0/gems/railties-7.1.3.4/lib/rails/commands/rake/rake_command.rb:44:in `block in with_rake' /app/www/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/lib/rake/rake_module.rb:59:in `with_application' /app/www/vendor/bundle/ruby/3.3.0/gems/railties-7.1.3.4/lib/rails/commands/rake/rake_command.rb:41:in `with_rake' /app/www/vendor/bundle/ruby/3.3.0/gems/railties-7.1.3.4/lib/rails/commands/rake/rake_command.rb:20:in `perform' /app/www/vendor/bundle/ruby/3.3.0/gems/railties-7.1.3.4/lib/rails/command.rb:156:in `invoke_rake' /app/www/vendor/bundle/ruby/3.3.0/gems/railties-7.1.3.4/lib/rails/command.rb:73:in `block in invoke' /app/www/vendor/bundle/ruby/3.3.0/gems/railties-7.1.3.4/lib/rails/command.rb:149:in `with_argv' /app/www/vendor/bundle/ruby/3.3.0/gems/railties-7.1.3.4/lib/rails/command.rb:69:in `invoke' /app/www/vendor/bundle/ruby/3.3.0/gems/railties-7.1.3.4/lib/rails/commands.rb:18:in `<main>' /app/www/vendor/bundle/ruby/3.3.0/gems/bootsnap-1.18.3/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:30:in `require' Tasks: TOP => db:prepare:with_data (See full trace by running task with --trace) == 20210130201037 CreateLibraries: migrating ================================== -- create_table(:libraries) -> 0.0638s == 20210130201037 CreateLibraries: migrated (0.0641s) ========================= == 20210130203243 CreateModels: migrating ===================================== -- create_table(:models) -> 0.0697s == 20210130203243 CreateModels: migrated (0.0698s) ============================ == 20210205230918 CreateParts: migrating ====================================== -- create_table(:parts) -> 0.0953s == 20210205230918 CreateParts: migrated (0.0956s) ============================= == 20210210153744 AddFieldsToParts: migrating ================================= -- add_column(:parts, :presupported, :boolean, {:default=>false, :null=>false}) -> 0.0958s -- add_column(:parts, :printed, :boolean, {:default=>false, :null=>false}) -> 0.0759s == 20210210153744 AddFieldsToParts: migrated (0.1721s) ======================== == 20210212143001 ActsAsTaggableOnMigration: migrating ======================== -- create_table(:tags, {:options=>"ENGINE=InnoDB", :id=>:integer}) -> 0.0999s -- create_table(:taggings, {:options=>"ENGINE=InnoDB", :id=>:integer}) -> 0.0816s -- add_index(:taggings, :tag_id, {:name=>"index_taggings_on_tag_id"}) -> 0.1079s -- add_index(:taggings, [:taggable_id, :taggable_type, :context], {:name=>"taggings_taggable_context_idx"}) -> 0.1059s == 20210212143001 ActsAsTaggableOnMigration: migrated (0.3972s) =============== == 20210212143002 AddMissingUniqueIndices: migrating ========================== -- add_index(:tags, :name, {:unique=>true, :name=>"index_tags_on_name"}) -> 0.1073s -- index_exists?(:taggings, :tag_id, {:name=>"index_taggings_on_tag_id"}) -> 0.0044s -- remove_index(:taggings, :tag_id, {:name=>"index_taggings_on_tag_id"}) s6-rc: warning: unable to start service init-manyfold-config: command exited 1The text was updated successfully, but these errors were encountered: