Bug 1356566

Summary:	[RFE] Split Hypervisor Checkin into multiple transactions
Product:	[Community] Candlepin	Reporter:	Filip Nguyen <fnguyen>
Component:	candlepin	Assignee:	vritant <vrjain>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Katello QA List <katello-qa-list>
Severity:	unspecified	Docs Contact:
Priority:	high
Version:	2.0	CC:	bcourt, redakkan, skallesh
Target Milestone:	---	Keywords:	FutureFeature, Triaged
Target Release:	2.0
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:	candlepin-2.0.22-1	Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2017-02-22 08:13:28 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:
Embargoed:

Description Filip Nguyen 2016-07-14 11:54:50 UTC

Description of problem:
Large checkins (e.g. 1350771 ) can result into very long running database transactions. Such long running transactions introduce a danger of lock waits and deadlocks.


How reproducible:
Always

Steps to Reproduce:
1. Submit a checkin with large number of hosts and large number of migrated hosts

Actual results:
Checkin creates one big transaction. Migration of guests between hosts require revocation and auto-heal, both are time consuming. I saw a transaction that lasted for 8 hours

Expected results:
Transactions are shorter, at most minutes.

Comment 2 vritant 2017-02-22 08:16:53 UTC

if there is need for this again, we should discuss with katello folks around accepting partial success etc. we should also focus on one transaction per hypervisor imo.