Cannot drop index 'index_prometheus_alerts_on_project_id_and_prometheus_metric_id': needed in a foreign key constraint
https://gitlab.com/gitlab-org/gitlab-ee/-/jobs/170082932:
Failures:
1) MigrateMirrorAttributesDataFromProjectsToImportState#up migrates the mirror data to the import_state table
Failure/Error: remove_index(table_name, options.merge({ column: column_name }))
StandardError:
An error has occurred, all later migrations canceled:
Mysql2::Error: Cannot drop index 'index_prometheus_alerts_on_project_id_and_prometheus_metric_id': needed in a foreign key constraint: DROP INDEX `index_prometheus_alerts_on_project_id_and_prometheus_metric_id` ON `prometheus_alerts`
# ./config/initializers/connection_fix.rb:20:in `execute'
# ./lib/gitlab/database/migration_helpers.rb:99:in `block in remove_concurrent_index'
# ./lib/gitlab/database/migration_helpers.rb:244:in `disable_statement_timeout'
# ./lib/gitlab/database/migration_helpers.rb:98:in `remove_concurrent_index'
# ./ee/db/migrate/20180912113336_allow_prometheus_alerts_per_environment.rb:31:in `down'
# ./spec/support/helpers/migrations_helpers.rb:101:in `block in schema_migrate_down!'
# ./spec/support/helpers/migrations_helpers.rb:122:in `disable_migrations_output'
# ./spec/support/helpers/migrations_helpers.rb:100:in `schema_migrate_down!'
# ./ee/spec/support/helpers/ee/migrations_helpers.rb:31:in `block in schema_migrate_down!'
# ./ee/spec/support/helpers/ee/migrations_helpers.rb:48:in `with_db_config'
# ./ee/spec/support/helpers/ee/migrations_helpers.rb:31:in `schema_migrate_down!'
# ./spec/spec_helper.rb:221:in `block (2 levels) in <top (required)>'
# ------------------
# --- Caused by: ---
# Mysql2::Error:
# Cannot drop index 'index_prometheus_alerts_on_project_id_and_prometheus_metric_id': needed in a foreign key constraint
# ./config/initializers/connection_fix.rb:20:in `execute'
2) MigrateMirrorAttributesDataFromProjectsToImportState#down migrates the import_state mirror data into the projects table
Failure/Error: remove_index(table_name, options.merge({ column: column_name }))
StandardError:
An error has occurred, all later migrations canceled:
Mysql2::Error: Cannot drop index 'index_prometheus_alerts_on_project_id_and_prometheus_metric_id': needed in a foreign key constraint: DROP INDEX `index_prometheus_alerts_on_project_id_and_prometheus_metric_id` ON `prometheus_alerts`
# ./config/initializers/connection_fix.rb:20:in `execute'
# ./lib/gitlab/database/migration_helpers.rb:99:in `block in remove_concurrent_index'
# ./lib/gitlab/database/migration_helpers.rb:244:in `disable_statement_timeout'
# ./lib/gitlab/database/migration_helpers.rb:98:in `remove_concurrent_index'
# ./ee/db/migrate/20180912113336_allow_prometheus_alerts_per_environment.rb:31:in `down'
# ./spec/support/helpers/migrations_helpers.rb:101:in `block in schema_migrate_down!'
# ./spec/support/helpers/migrations_helpers.rb:122:in `disable_migrations_output'
# ./spec/support/helpers/migrations_helpers.rb:100:in `schema_migrate_down!'
# ./ee/spec/support/helpers/ee/migrations_helpers.rb:31:in `block in schema_migrate_down!'
# ./ee/spec/support/helpers/ee/migrations_helpers.rb:48:in `with_db_config'
# ./ee/spec/support/helpers/ee/migrations_helpers.rb:31:in `schema_migrate_down!'
# ./spec/spec_helper.rb:221:in `block (2 levels) in <top (required)>'
# ------------------
# --- Caused by: ---
# Mysql2::Error:
# Cannot drop index 'index_prometheus_alerts_on_project_id_and_prometheus_metric_id': needed in a foreign key constraint
# ./config/initializers/connection_fix.rb:20:in `execute'
3) Gitlab::BackgroundMigration::RemoveCommaFromWeightSystemNotes#perform processes all notes in the batch
Failure/Error: remove_index(table_name, options.merge({ column: column_name }))
StandardError:
An error has occurred, all later migrations canceled:
Mysql2::Error: Cannot drop index 'index_prometheus_alerts_on_project_id_and_prometheus_metric_id': needed in a foreign key constraint: DROP INDEX `index_prometheus_alerts_on_project_id_and_prometheus_metric_id` ON `prometheus_alerts`
# ./config/initializers/connection_fix.rb:20:in `execute'
# ./lib/gitlab/database/migration_helpers.rb:99:in `block in remove_concurrent_index'
# ./lib/gitlab/database/migration_helpers.rb:244:in `disable_statement_timeout'
# ./lib/gitlab/database/migration_helpers.rb:98:in `remove_concurrent_index'
# ./ee/db/migrate/20180912113336_allow_prometheus_alerts_per_environment.rb:31:in `down'
# ./spec/support/helpers/migrations_helpers.rb:101:in `block in schema_migrate_down!'
# ./spec/support/helpers/migrations_helpers.rb:122:in `disable_migrations_output'
# ./spec/support/helpers/migrations_helpers.rb:100:in `schema_migrate_down!'
# ./ee/spec/support/helpers/ee/migrations_helpers.rb:31:in `block in schema_migrate_down!'
# ./ee/spec/support/helpers/ee/migrations_helpers.rb:48:in `with_db_config'
# ./ee/spec/support/helpers/ee/migrations_helpers.rb:31:in `schema_migrate_down!'
# ./spec/spec_helper.rb:221:in `block (2 levels) in <top (required)>'
# ------------------
# --- Caused by: ---
# Mysql2::Error:
# Cannot drop index 'index_prometheus_alerts_on_project_id_and_prometheus_metric_id': needed in a foreign key constraint
# ./config/initializers/connection_fix.rb:20:in `execute'
Finished in 13 minutes 19 seconds (files took 12.51 seconds to load)
1085 examples, 3 failures, 79 pending
Failed examples:
rspec ./ee/spec/migrations/migrate_mirror_attributes_data_from_projects_to_import_state_spec.rb:24 # MigrateMirrorAttributesDataFromProjectsToImportState#up migrates the mirror data to the import_state table
rspec ./ee/spec/migrations/migrate_mirror_attributes_data_from_projects_to_import_state_spec.rb:48 # MigrateMirrorAttributesDataFromProjectsToImportState#down migrates the import_state mirror data into the projects table
rspec ./ee/spec/lib/gitlab/background_migration/remove_comma_from_weight_system_notes_spec.rb:16 # Gitlab::BackgroundMigration::RemoveCommaFromWeightSystemNotes#perform processes all notes in the batch