Bug 664597

Summary: oracle generating alerts on locking raw metric table
Product: [Other] RHQ Project Reporter: Charles Crouch <ccrouch>
Component: Core ServerAssignee: RHQ Project Maintainer <rhq-maint>
Status: CLOSED INSUFFICIENT_DATA QA Contact: Mike Foley <mfoley>
Severity: medium Docs Contact:
Priority: low    
Version: 3.0.0CC: hbrock, jshaughn
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2013-02-26 21:33:50 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: 717358    

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.