Project

General

Profile

Actions

Bug #10507

closed

Intermittent integration HostTest/HostgroupTest database deadlock

Added by Dominic Cleal over 9 years ago. Updated over 6 years ago.

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

Description

e.g. http://ci.theforeman.org/job/test_develop_pr_core/4818/

HostgroupTest.test_0001_index page

PG::TRDeadlockDetected: ERROR:  deadlock detected
LINE 1: SELECT MAX("audits"."version") AS max_id FROM "audits"  WHER...
                                                      ^
DETAIL:  Process 26762 waits for AccessShareLock on relation 117924672 of database 117924606; blocked by process 26311.
Process 26311 waits for AccessExclusiveLock on relation 117924880 of database 117924606; blocked by process 26762.
HostTest::hosts index multiple actions.test_show_action_buttons (from HostTest__hosts index multiple actions) 

PG::TRDeadlockDetected: ERROR:  deadlock detected
DETAIL:  Process 26311 waits for AccessExclusiveLock on relation 117925276 of database 117924606; blocked by process 26762.
Process 26762 waits for AccessShareLock on relation 117924880 of database 117924606; blocked by process 26311.
HINT:  See server log for query details.
: TRUNCATE TABLE "public"."audits", "public"."bookmarks", "public"."host_config_groups", "public"."locations_organizations", "public"."logs", "public"."messages", "public"."parameters", "public"."sessions", "public"."widgets", "public"."architectures_operatingsystems", "public"."compute_attributes", "public"."config_templates_operatingsystems", "public"."environment_classes", "public"."external_usergroups", "public"."fact_names", "public"."fact_values", "public"."features", "public"."features_smart_proxies", "public"."permissions", "public"."filterings", "public"."filters", "public"."host_classes", "public"."hostgroup_classes", "public"."compute_profiles", "public"."models", "public"."architectures", "public"."images", "public"."compute_resources", "public"."key_pairs", "public"."lookup_keys", "public"."lookup_values", "public"."media", "public"."media_operatingsystems", "public"."nics", "public"."ptables", "public"."operatingsystems_ptables", "public"."puppetclasses", "public"."operatingsystems_puppetclasses", "public"."operatingsystems", "public"."template_kinds", "public"."os_default_templates", "public"."realms", "public"."reports", "public"."domains", "public"."subnet_domains", "public"."smart_proxies", "public"."subnets", "public"."taxonomies", "public"."taxable_taxonomies", "public"."config_templates", "public"."environments", "public"."hostgroups", "public"."template_combinations", "public"."hosts", "public"."tokens", "public"."trends", "public"."cached_user_roles", "public"."cached_usergroup_members", "public"."config_group_classes", "public"."config_groups", "public"."trend_counters", "public"."mail_notifications", "public"."user_mail_notifications", "public"."roles", "public"."user_roles", "public"."usergroups", "public"."usergroup_members", "public"."auth_sources", "public"."users", "public"."settings", "public"."sources" RESTART IDENTITY CASCADE; (ActiveRecord::StatementInvalid)
Actions

Also available in: Atom PDF