Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.
Bug 1350834 - ExclusiveLock held by Candlepin, resulting in INSERTs waiting for a lock and thus a hanging Satellite
ExclusiveLock held by Candlepin, resulting in INSERTs waiting for a lock and ...
Status: CLOSED ERRATA
Product: Red Hat Satellite 6
Classification: Red Hat
Component: Candlepin (Show other bugs)
6.1.8
Unspecified Unspecified
unspecified Severity medium (vote)
: 6.1.11
: Unused
Assigned To: satellite6-bugs
jcallaha
: Triaged
Depends On: 1350771
Blocks:
  Show dependency treegraph
 
Reported: 2016-06-28 09:33 EDT by Barnaby Court
Modified: 2017-02-23 14:18 EST (History)
9 users (show)

See Also:
Fixed In Version: candlepin-0.9.49.17-1
Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: 1350771
Environment:
Last Closed: 2016-11-17 11:21:56 EST
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)
verification screenshot (210.23 KB, image/png)
2016-11-16 22:46 EST, jcallaha
no flags Details


External Trackers
Tracker ID Priority Status Summary Last Updated
Red Hat Product Errata RHBA-2016:2804 normal SHIPPED_LIVE Satellite 6.1.11 Bug Release 2016-11-17 16:21:17 EST

  None (edit)
Comment 2 Barnaby Court 2016-10-20 16:38:22 EDT
Fixed upstream in candlepin-0.9.49.17-1
Comment 4 jcallaha 2016-11-16 22:45:46 EST
Verified in Satellite 6.1.11.

I created a script to generate esx data to a json file. This way I could create the required number of entries (1,500 Hypervisors; 45,000 Guests).
https://gist.github.com/JacobCallahan/1c948ca2466aaeb5de395743f1555e19

# python2.7 genvirt.py -h
usage: genvirt.py [-h] hypervisors guests path

positional arguments:
  hypervisors  The number of hypervisors to create.
  guests       The number of guests per hypervisor to create.
  path         The file path to save the output to.

optional arguments:
  -h, --help   show this help message and exit

# python2.7 genvirt.py 500 30 test1.json
# python2.7 genvirt.py 500 30 test2.json
# python2.7 genvirt.py 500 30 test3.json
# ll
-rw-r--r--. 1 root root 1.7M Nov 17 03:31 test1.json
-rw-r--r--. 1 root root 1.7M Nov 17 03:31 test2.json
-rw-r--r--. 1 root root 1.7M Nov 17 03:31 test3.json

# for virt in test1.json test2.json test3.json; do curl -k -X POST --cert /etc/pki/consumer/cert.pem --key /etc/pki/consumer/key.pem https://ibm-x3550m3-07.lab.eng.brq.redhat.com/rhsm/hypervisors -H "Content-Type: application/json" -d @"$virt"; done;

The processes completed successfully, with no interrupts to content host page loading. Average content host page load times after process is 4.8s.
Comment 5 jcallaha 2016-11-16 22:46 EST
Created attachment 1221453 [details]
verification screenshot
Comment 7 errata-xmlrpc 2016-11-17 11:21:56 EST
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHBA-2016:2804

Note You need to log in before you can comment on or make changes to this bug.