Project

General

Profile

Bug #23093

Transient test failure with PG DB deadlock

Added by Michael Moll 7 months ago. Updated 3 months ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Tests
Target version:
Difficulty:
Triaged:
Bugzilla link:
Team Backlog:
Fixed in Releases:
Found in Releases:

Description

ActiveRecord::Deadlocked: PG::TRDeadlockDetected: ERROR:  deadlock detected
DETAIL:  Process 21225 waits for AccessExclusiveLock on relation 130465041 of database 130464378; blocked by process 21232.
Process 21232 waits for AccessShareLock on relation 130464767 of database 130464378; blocked by process 21225.
HINT:  See server log for query details.
: TRUNCATE TABLE "public"."bookmarks", "public"."config_group_classes", "public"."config_groups", "public"."host_config_groups", "public"."hostgroup_classes", "public"."http_proxies", "public"."messages", "public"."parameters", "public"."roles", "public"."sources", "public"."users", "public"."audits", "public"."cached_user_roles", "public"."cached_usergroup_members", "public"."domains", "public"."environments", "public"."fact_names", "public"."external_usergroups", "public"."filters", "public"."host_status", "public"."host_classes", "public"."hostgroups", "public"."lookup_values", "public"."locations_organizations", "public"."logs", "public"."key_pairs", "public"."nics", "public"."notification_blueprints", "public"."mail_notifications", "public"."models", "public"."media_operatingsystems", "public"."notification_recipients", "public"."notifications", "public"."permissions", "public"."os_default_templates", "public"."operatingsystems_provisioning_templates", "public"."operatingsystems_ptables", "public"."operatingsystems_puppetclasses", "public"."personal_access_tokens", "public"."reports", "public"."sessions", "public"."settings", "public"."realms", "public"."ssh_keys", "public"."taxonomies", "public"."template_combinations", "public"."table_preferences", "public"."subnet_domains", "public"."template_kinds", "public"."user_roles", "public"."usergroup_members", "public"."templates", "public"."tokens", "public"."trends", "public"."widgets", "public"."hosts", "public"."architectures_operatingsystems", "public"."filterings", "public"."trend_counters", "public"."compute_attributes", "public"."user_mail_notifications", "public"."usergroups", "public"."test_facets", "public"."environment_classes", "public"."images", "public"."auth_sources", "public"."fact_values", "public"."features", "public"."compute_resources", "public"."compute_profiles", "public"."features_smart_proxies", "public"."smart_proxies", "public"."puppetclasses", "public"."subnets", "public"."operatingsystems", "public"."lookup_keys", "public"."architectures", "public"."media", "public"."taxable_taxonomies", "public"."module_test_facets" RESTART IDENTITY CASCADE;
    test/integration_test_helper.rb:195:in `block in <class:IntegrationTest>'
    test/test_helper.rb:75:in `after_teardown' (ActiveRecord::Deadlocked)
/usr/local/rvm/gems/ruby-2.4.3@test_develop-0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:73  

Associated revisions

Revision 88bb73d0 (diff)
Added by Michael Moll 7 months ago

Fixes #23093 - prevent DB deadlocks in IntegrationTestHelper

History

#1 Updated by The Foreman Bot 7 months ago

  • Pull request https://github.com/theforeman/foreman/pull/5388 added

#2 Updated by Michael Moll 7 months ago

  • % Done changed from 0 to 100
  • Status changed from Ready For Testing to Closed

Also available in: Atom PDF