Bug 1102871

Summary: multiple calls to create or update domain throws deadlock error
Product: Red Hat Satellite Reporter: Tom McKay <tomckay>
Component: ProvisioningAssignee: Dominic Cleal <dcleal>
Status: CLOSED WONTFIX QA Contact: Katello QA List <katello-qa-list>
Severity: medium Docs Contact:
Priority: unspecified    
Version: 6.0.3CC: bbuckingham, bkearney, cwelton, mmccune, tomckay
Target Milestone: UnspecifiedKeywords: Triaged
Target Release: Unused   
Hardware: Unspecified   
OS: Unspecified   
URL: http://projects.theforeman.org/issues/5990
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2015-08-13 16:23:17 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Tom McKay 2014-05-29 17:53:10 UTC 
Running hammer-cli-csv w/ 6 threads against a 7 CPU server

```
E, [2014-05-29T13:48:16.720000 #2214] ERROR -- : 500 Internal Server Error
{
    "error" => {
        "message" => "PGError: ERROR:  deadlock detected\nDETAIL:  Process 13511 waits for ShareLock on transaction 25358; blocked by process 13424.\nProcess 13424 waits for ExclusiveLock on tuple (0,31) of relation 18370 of database 17586; blocked by process 13511.\nHINT:  See server log for query details.\n: UPDATE \"taxonomies\" SET \"updated_at\" = '2014-05-29 21:46:53.703727', \"ignore_types\" = '--- []\n', \"default_info\" = '---\nsystem: []\ndistributor: []\n' WHERE \"taxonomies\".\"type\" IN ('Organization') AND \"taxonomies\".\"id\" = 3"
    }
}
```
Comment 1 Tom McKay 2014-05-29 17:53:12 UTC 
Created from redmine issue http://projects.theforeman.org/issues/5990
Comment 3 Bryan Kearney 2014-06-03 17:32:15 UTC 
check upstream... lzap wants info.
Comment 4 Tom McKay 2015-08-13 16:23:17 UTC 
I am closing this bug as there have been two releases of Sat-6 since creation without customer mentioning similar.