Bug 664597 - oracle generating alerts on locking raw metric table
Summary: oracle generating alerts on locking raw metric table
Keywords:
Status: CLOSED INSUFFICIENT_DATA
Alias: None
Product: RHQ Project
Classification: Other
Component: Core Server
Version: 3.0.0
Hardware: Unspecified
OS: Unspecified
low
medium
Target Milestone: ---
: ---
Assignee: RHQ Project Maintainer
QA Contact: Mike Foley
URL:
Whiteboard:
Depends On:
Blocks: jon30-perf
TreeView+ depends on / blocked
 
Reported: 2010-12-20 22:11 UTC by Charles Crouch
Modified: 2018-11-14 16:19 UTC (History)
2 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2013-02-26 21:33:50 UTC
Embargoed:


Attachments (Terms of Use)

Description Charles Crouch 2010-12-20 22:11:22 UTC
Seeing the following alerts from an Oracle instance being used as the backend of a two server node JON install:

"Oracle: ora-user: User JON (SID 442, Serial 46861, OS user os-user on host localhost, process JDBC Thin Clien) has blocked 3 users for at least 112 seconds by holding an Row-X TM lock on TABLE JON.RHQ_MEAS_DATA_NUM_R07 on db_host. MID1051"

Comment 3 Jay Shaughnessy 2013-02-26 21:33:50 UTC
Closing due to inactivity and because the measurement tables are going away.


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