Bug 1394930

Summary: Deadlocks private channel family and Server
Product: Red Hat Satellite 5 Reporter: Shannon Hughes <shughes>
Component: APIAssignee: Jan Dobes <jdobes>
Status: CLOSED DUPLICATE QA Contact: Red Hat Satellite QA List <satqe-list>
Severity: high Docs Contact:
Priority: high    
Version: 560CC: ggainey, rw3594, tlestach, xdmoon
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2017-02-17 18:43:53 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Bug Depends On:    
Bug Blocks: 465198, 1340444    

Description Shannon Hughes 2016-11-14 19:22:21 UTC
Description of problem:

Hitting some new deadlocks during API calls being made from kickstart post scripts. Will be attaching the two Oracle trace files. 

 current SQL:
  SELECT PCF.CREATED FROM RHNPRIVATECHANNELFAMILY PCF INNER JOIN RHNSERVER S ON S.ORG_ID = PCF.ORG_ID WHERE S.ID = :B1 FOR UPDATE