Bug 952718

Summary: Agent unable to complete initial inventory report due to db time out
Product: [JBoss] JBoss Operations Network Reporter: Viet Nguyen <vnguyen>
Component: PerformanceAssignee: RHQ Project Maintainer <rhq-maint>
Status: CLOSED CURRENTRELEASE QA Contact: Mike Foley <mfoley>
Severity: high Docs Contact:
Priority: unspecified    
Version: JON 3.1.2CC: loleary
Target Milestone: ER01   
Target Release: JON 3.2.0   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 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:
Bug Depends On: 905654    
Bug Blocks: 1030066    
Attachments:
Description Flags
log files none

Description Viet Nguyen 2013-04-16 14:34:12 UTC 
Description of problem:
Server can't process inventory report with 5000 top-level resources (generated by perftest).  Seems like the server is trying to to process the huge report in a single batch.

Server and agent RAM: 16GB
Agent jvm: -Xms64M -Xmx2048M
Server jvm: -Xms1024M -Xmx1024M -XX:PermSize=256M -XX:MaxPermSize=256M

Version-Release number of selected component (if applicable):
3.1.2

How reproducible:
100%

Steps to Reproduce:
0.  Increase various postgres settings (timeout, shared mem etc)
1.  Install perftest plugin and start agent with  -Drhq.perftest.scenario=configurable-1 -Drhq.perftest.server-a-count=5000 -Drhq.perftest.service-a-count=0
Comment 1 Viet Nguyen 2013-04-16 14:41:09 UTC 
Created attachment 736327 [details]
log files
Comment 2 Viet Nguyen 2013-04-16 14:49:17 UTC 
Fixed in https://bugzilla.redhat.com/show_bug.cgi?id=906866
Comment 3 Mike Foley 2013-07-15 14:46:04 UTC 
this was fixed as part of work by jay to break the data into smaller chunks.
Comment 4 Larry O'Leary 2013-07-15 15:09:50 UTC 
For clarity, this issue was actually addressed in bug 905654. The fix was to break large inventory reports into smaller chunks when performing the transaction. This prevent the time out issue from occurring when dealing with large inventory reports.