Bug 611740

Summary: Perf: Huge contention on RHQ_RESOURCE_ERROR
Product: [Other] RHQ Project Reporter: Heiko W. Rupp <hrupp>
Component: Core ServerAssignee: RHQ Project Maintainer <rhq-maint>
Status: CLOSED CURRENTRELEASE QA Contact: Mike Foley <mfoley>
Severity: medium Docs Contact:
Priority: low    
Version: 3.0.0CC: jshaughn
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-06-02 19:06:05 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:
Bug Depends On:    
Bug Blocks: 620933    
Attachments:
Description Flags
Oracle EM showing TM contention
none
Oracle EM showing top activity none

Description Heiko W. Rupp 2010-07-06 10:29:19 UTC 
There is huge contention on inserting into RHQ resource error table - looks like from the (only 700 rows) like those may come from multiple plugins sending reports about ResourceComponent unable to start at around the same time (as with the perf plugin)

Statement is 

insert into RHQ_RESOURCE_ERROR (TIME_OCCURRED, RESOURCE_ID, ERROR_TYPE, SUMMARY, DETAIL, ID) values (:1 , :2 , :3 , :4 , :5 , :6 )

See screenshot (s)
Comment 1 Heiko W. Rupp 2010-07-06 10:30:05 UTC 
Created attachment 429733 [details]
Oracle EM showing TM contention
Comment 2 Heiko W. Rupp 2010-07-06 10:30:40 UTC 
Created attachment 429734 [details]
Oracle EM showing top activity