Bug 952718 - Agent unable to complete initial inventory report due to db time out
Summary: Agent unable to complete initial inventory report due to db time out
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: JBoss Operations Network
Classification: JBoss
Component: Performance
Version: JON 3.1.2
Hardware: x86_64
OS: Linux
unspecified
high
Target Milestone: ER01
: JON 3.2.0
Assignee: RHQ Project Maintainer
QA Contact: Mike Foley
URL:
Whiteboard:
Depends On: 905654
Blocks: 1030066
TreeView+ depends on / blocked
 
Reported: 2013-04-16 14:34 UTC by Viet Nguyen
Modified: 2014-01-02 20:38 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed:
Type: Bug
Embargoed:

Attachments (Terms of Use)
log files (11.30 KB, text/rtf)
2013-04-16 14:41 UTC, Viet Nguyen 		no flags Details
View All

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.
Note You need to log in before you can comment on or make changes to this bug.