Bug 611740 – Perf: Huge contention on RHQ_RESOURCE_ERROR

Bugzilla will be upgraded to version 5.0 on December 2, 2018. The outage period for the upgrade will start at 0:00 UTC and have a duration of 12 hours

Bug 611740 - Perf: Huge contention on RHQ_RESOURCE_ERROR

Summary:	Perf: Huge contention on RHQ_RESOURCE_ERROR

Status:	CLOSED CURRENTRELEASE

Aliases:	None

Product:	RHQ Project
Classification:	Other
Component:	Core Server (Show other bugs)
Sub Component:
Version:	3.0.0
Hardware:	All Linux

Priority	low Severity medium (vote)
Target Milestone:	---
Target Release:	---
Assigned To:	RHQ Project Maintainer
QA Contact:	Mike Foley
Docs Contact:

URL:
Whiteboard:
Keywords:

Depends On:
Blocks:	rhq-perf
	Show dependency tree / graph

Reported:	2010-07-06 06:29 EDT by Heiko W. Rupp
Modified:	2014-06-02 15:06 EDT (History)
CC List:	1 user (show)

See Also:
Fixed In Version:
Doc Type:	Bug Fix
Doc Text:
Story Points:	---
Clone Of:
Environment:
Last Closed:	2014-06-02 15:06:05 EDT
Type:	---
Regression:	---
Mount Type:	---
Documentation:	---
CRM:
Verified Versions:
Category:	---
oVirt Team:	---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---

Attachments	(Terms of Use)
Oracle EM showing TM contention (55.43 KB, image/png) 2010-07-06 06:30 EDT, Heiko W. Rupp	no flags	Details
Oracle EM showing top activity (42.24 KB, image/png) 2010-07-06 06:30 EDT, Heiko W. Rupp	no flags	Details
Add an attachment (proposed patch, testcase, etc.)

Groups: None (edit)

Description Heiko W. Rupp 2010-07-06 06:29:19 EDT

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 06:30:05 EDT

Created attachment 429733 [details]
Oracle EM showing TM contention

Comment 2 Heiko W. Rupp 2010-07-06 06:30:40 EDT

Created attachment 429734 [details]
Oracle EM showing top activity

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