Flaky test './spec/lib/gitlab/background_migration/disable_expiration_policies_linked_to_no_container_images_spec.rb[1:1:4:1:1]' # Gitlab::BackgroundMigration::DisableExpirationPoliciesLinkedToNoContainerImages#perform a range with a single element behave
Job #1331565784 failed for 53f5ad14:
1) Gitlab::BackgroundMigration::DisableExpirationPoliciesLinkedToNoContainerImages#perform the whole range behaves like disabling policies with no images disables the proper policies
Got 0 failures and 2 other errors:
Shared Example Group: "disabling policies with no images" called from ./spec/lib/gitlab/background_migration/disable_expiration_policies_linked_to_no_container_images_spec.rb:41
1.1) Failure/Error:
ActiveRecord::Base
.connection
.execute(sql)
ActiveRecord::StatementInvalid:
PG::SyntaxError: ERROR: syntax error at or near "MATERIALIZED"
LINE 1: WITH batched_relation AS MATERIALIZED (SELECT "c...
^
# ./lib/gitlab/background_migration/disable_expiration_policies_linked_to_no_container_images.rb:37:in `execute'
# ./lib/gitlab/background_migration/disable_expiration_policies_linked_to_no_container_images.rb:28:in `block in perform'
# ./app/models/concerns/each_batch.rb:94:in `block in each_batch'
# ./app/models/concerns/each_batch.rb:68:in `step'
# ./app/models/concerns/each_batch.rb:68:in `each_batch'
# ./lib/gitlab/background_migration/disable_expiration_policies_linked_to_no_container_images.rb:19:in `perform'
# ./spec/lib/gitlab/background_migration/disable_expiration_policies_linked_to_no_container_images_spec.rb:24:in `block (3 levels) in <top (required)>'
# ./spec/lib/gitlab/background_migration/disable_expiration_policies_linked_to_no_container_images_spec.rb:28:in `block (4 levels) in <top (required)>'
# ./spec/spec_helper.rb:372:in `block (3 levels) in <top (required)>'
# ./spec/support/sidekiq_middleware.rb:9:in `with_sidekiq_server_middleware'
# ./spec/spec_helper.rb:363:in `block (2 levels) in <top (required)>'
# ./spec/spec_helper.rb:359:in `block (3 levels) in <top (required)>'
# ./lib/gitlab/application_context.rb:31:in `with_raw_context'
# ./spec/spec_helper.rb:359:in `block (2 levels) in <top (required)>'
# ./spec/support/database_cleaner.rb:58:in `block (2 levels) in <top (required)>'
# ------------------
# --- Caused by: ---
# PG::SyntaxError:
# ERROR: syntax error at or near "MATERIALIZED"
# LINE 1: WITH batched_relation AS MATERIALIZED (SELECT "c...
# ^
# ./lib/gitlab/background_migration/disable_expiration_policies_linked_to_no_container_images.rb:37:in `execute'
1.2) Failure/Error: DatabaseCleaner.clean_with(:deletion, cache_tables: false, except: except)
ActiveRecord::StatementInvalid:
PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block
# ./spec/support/db_cleaner.rb:7:in `delete_from_all_tables!'
# ./spec/support/database_cleaner.rb:60:in `block (2 levels) in <top (required)>'
# ------------------
# --- Caused by: ---
# PG::InFailedSqlTransaction:
# ERROR: current transaction is aborted, commands ignored until end of transaction block
# ./spec/support/db_cleaner.rb:7:in `delete_from_all_tables!'
2) Gitlab::BackgroundMigration::DisableExpirationPoliciesLinkedToNoContainerImages#perform a range with no policies to disable behaves like disabling policies with no images disables the proper policies
Got 0 failures and 2 other errors:
Shared Example Group: "disabling policies with no images" called from ./spec/lib/gitlab/background_migration/disable_expiration_policies_linked_to_no_container_images_spec.rb:62
2.1) Failure/Error: migration_context.down(migration_schema_version)
ActiveRecord::StatementInvalid:
PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block
# ./spec/support/helpers/migrations_helpers.rb:108:in `block in schema_migrate_down!'
# ./spec/support/helpers/migrations_helpers.rb:128:in `disable_migrations_output'
# ./spec/support/helpers/migrations_helpers.rb:107:in `schema_migrate_down!'
# ./ee/spec/support/helpers/ee/migrations_helpers.rb:33:in `block in schema_migrate_down!'
# ./ee/spec/support/helpers/ee/migrations_helpers.rb:50:in `with_db_config'
# ./ee/spec/support/helpers/ee/migrations_helpers.rb:33:in `schema_migrate_down!'
# ./spec/support/migration.rb:23:in `block (2 levels) in <top (required)>'
# ./spec/spec_helper.rb:372:in `block (3 levels) in <top (required)>'
# ./spec/support/sidekiq_middleware.rb:9:in `with_sidekiq_server_middleware'
# ./spec/spec_helper.rb:363:in `block (2 levels) in <top (required)>'
# ./spec/spec_helper.rb:359:in `block (3 levels) in <top (required)>'
# ./lib/gitlab/application_context.rb:31:in `with_raw_context'
# ./spec/spec_helper.rb:359:in `block (2 levels) in <top (required)>'
# ./spec/support/database_cleaner.rb:58:in `block (2 levels) in <top (required)>'
# ------------------
# --- Caused by: ---
# PG::InFailedSqlTransaction:
# ERROR: current transaction is aborted, commands ignored until end of transaction block
# ./spec/support/helpers/migrations_helpers.rb:108:in `block in schema_migrate_down!'
2.2) Failure/Error: DatabaseCleaner.clean_with(:deletion, cache_tables: false, except: except)
ActiveRecord::StatementInvalid:
PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block
# ./spec/support/db_cleaner.rb:7:in `delete_from_all_tables!'
# ./spec/support/database_cleaner.rb:60:in `block (2 levels) in <top (required)>'
# ------------------
# --- Caused by: ---
# PG::InFailedSqlTransaction:
# ERROR: current transaction is aborted, commands ignored until end of transaction block
# ./spec/support/db_cleaner.rb:7:in `delete_from_all_tables!'
3) Gitlab::BackgroundMigration::DisableExpirationPoliciesLinkedToNoContainerImages#perform a range with only images behaves like disabling policies with no images disables the proper policies
Got 0 failures and 2 other errors:
Shared Example Group: "disabling policies with no images" called from ./spec/lib/gitlab/background_migration/disable_expiration_policies_linked_to_no_container_images_spec.rb:83
3.1) Failure/Error: migration_context.down(migration_schema_version)
ActiveRecord::StatementInvalid:
PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block
# ./spec/support/helpers/migrations_helpers.rb:108:in `block in schema_migrate_down!'
# ./spec/support/helpers/migrations_helpers.rb:128:in `disable_migrations_output'
# ./spec/support/helpers/migrations_helpers.rb:107:in `schema_migrate_down!'
# ./ee/spec/support/helpers/ee/migrations_helpers.rb:33:in `block in schema_migrate_down!'
# ./ee/spec/support/helpers/ee/migrations_helpers.rb:50:in `with_db_config'
# ./ee/spec/support/helpers/ee/migrations_helpers.rb:33:in `schema_migrate_down!'
# ./spec/support/migration.rb:23:in `block (2 levels) in <top (required)>'
# ./spec/spec_helper.rb:372:in `block (3 levels) in <top (required)>'
# ./spec/support/sidekiq_middleware.rb:9:in `with_sidekiq_server_middleware'
# ./spec/spec_helper.rb:363:in `block (2 levels) in <top (required)>'
# ./spec/spec_helper.rb:359:in `block (3 levels) in <top (required)>'
# ./lib/gitlab/application_context.rb:31:in `with_raw_context'
# ./spec/spec_helper.rb:359:in `block (2 levels) in <top (required)>'
# ./spec/support/database_cleaner.rb:58:in `block (2 levels) in <top (required)>'
# ------------------
# --- Caused by: ---
# PG::InFailedSqlTransaction:
# ERROR: current transaction is aborted, commands ignored until end of transaction block
# ./spec/support/helpers/migrations_helpers.rb:108:in `block in schema_migrate_down!'
3.2) Failure/Error: DatabaseCleaner.clean_with(:deletion, cache_tables: false, except: except)
ActiveRecord::StatementInvalid:
PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block
# ./spec/support/db_cleaner.rb:7:in `delete_from_all_tables!'
# ./spec/support/database_cleaner.rb:60:in `block (2 levels) in <top (required)>'
# ------------------
# --- Caused by: ---
# PG::InFailedSqlTransaction:
# ERROR: current transaction is aborted, commands ignored until end of transaction block
# ./spec/support/db_cleaner.rb:7:in `delete_from_all_tables!'
4) Gitlab::BackgroundMigration::DisableExpirationPoliciesLinkedToNoContainerImages#perform a range with a single element behaves like disabling policies with no images disables the proper policies
Got 0 failures and 2 other errors:
Shared Example Group: "disabling policies with no images" called from ./spec/lib/gitlab/background_migration/disable_expiration_policies_linked_to_no_container_images_spec.rb:104
4.1) Failure/Error: migration_context.down(migration_schema_version)
ActiveRecord::StatementInvalid:
PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block
# ./spec/support/helpers/migrations_helpers.rb:108:in `block in schema_migrate_down!'
# ./spec/support/helpers/migrations_helpers.rb:128:in `disable_migrations_output'
# ./spec/support/helpers/migrations_helpers.rb:107:in `schema_migrate_down!'
# ./ee/spec/support/helpers/ee/migrations_helpers.rb:33:in `block in schema_migrate_down!'
# ./ee/spec/support/helpers/ee/migrations_helpers.rb:50:in `with_db_config'
# ./ee/spec/support/helpers/ee/migrations_helpers.rb:33:in `schema_migrate_down!'
# ./spec/support/migration.rb:23:in `block (2 levels) in <top (required)>'
# ./spec/spec_helper.rb:372:in `block (3 levels) in <top (required)>'
# ./spec/support/sidekiq_middleware.rb:9:in `with_sidekiq_server_middleware'
# ./spec/spec_helper.rb:363:in `block (2 levels) in <top (required)>'
# ./spec/spec_helper.rb:359:in `block (3 levels) in <top (required)>'
# ./lib/gitlab/application_context.rb:31:in `with_raw_context'
# ./spec/spec_helper.rb:359:in `block (2 levels) in <top (required)>'
# ./spec/support/database_cleaner.rb:58:in `block (2 levels) in <top (required)>'
# ------------------
# --- Caused by: ---
# PG::InFailedSqlTransaction:
# ERROR: current transaction is aborted, commands ignored until end of transaction block
# ./spec/support/helpers/migrations_helpers.rb:108:in `block in schema_migrate_down!'
4.2) Failure/Error: DatabaseCleaner.clean_with(:deletion, cache_tables: false, except: except)
ActiveRecord::StatementInvalid:
PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block
# ./spec/support/db_cleaner.rb:7:in `delete_from_all_tables!'
# ./spec/support/database_cleaner.rb:60:in `block (2 levels) in <top (required)>'
# ------------------
# --- Caused by: ---
# PG::InFailedSqlTransaction:
# ERROR: current transaction is aborted, commands ignored until end of transaction block
# ./spec/support/db_cleaner.rb:7:in `delete_from_all_tables!'
Finished in 22 minutes 54 seconds (files took 59.2 seconds to load)
137 examples, 4 failures
Failed examples:
rspec './spec/lib/gitlab/background_migration/disable_expiration_policies_linked_to_no_container_images_spec.rb[1:1:1:1:1]' # Gitlab::BackgroundMigration::DisableExpirationPoliciesLinkedToNoContainerImages#perform the whole range behaves like disabling policies with no images disables the proper policies
rspec './spec/lib/gitlab/background_migration/disable_expiration_policies_linked_to_no_container_images_spec.rb[1:1:2:1:1]' # Gitlab::BackgroundMigration::DisableExpirationPoliciesLinkedToNoContainerImages#perform a range with no policies to disable behaves like disabling policies with no images disables the proper policies
rspec './spec/lib/gitlab/background_migration/disable_expiration_policies_linked_to_no_container_images_spec.rb[1:1:3:1:1]' # Gitlab::BackgroundMigration::DisableExpirationPoliciesLinkedToNoContainerImages#perform a range with only images behaves like disabling policies with no images disables the proper policies
rspec './spec/lib/gitlab/background_migration/disable_expiration_policies_linked_to_no_container_images_spec.rb[1:1:4:1:1]' # Gitlab::BackgroundMigration::DisableExpirationPoliciesLinkedToNoContainerImages#perform a range with a single element behaves like disabling policies with no images disables the proper policies