Actions
Bug #10507
closedIntermittent integration HostTest/HostgroupTest database deadlock
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