Bug 748027

Summary:	a frequently asked question should be added to the FAQ
Product:	[Other] RHQ Project	Reporter:	Mike Foley <mfoley>
Component:	Documentation	Assignee:	Deon Ballard <dlackey>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Mike Foley <mfoley>
Severity:	high	Docs Contact:
Priority:	medium
Version:	4.1	CC:	hrupp, rbuck
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:	2012-06-28 15:56:27 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:

Description Mike Foley 2011-10-21 18:32:26 UTC

Description of problem:  Customers frequently ask this question.  Consider adding it to the FAQ



spinder: Hopefully a quick question... what does this mean and why does it appear: "WARN  [QueryTranslatorImpl] firstResult/maxResults specified with collection fetch; applying in memory!" ?
<spinder> loleary: great question. It comes up every few months when people get alarmed by it... 
<spinder> iirc it's a messages that comes from within hibernate and have so far been deemed harmless by anyone who has investigate it.
<spinder> s/messages/message   s/investigate/investigated
<mfoley> we should consider adding it to the FAQ if people ask about it frequently
<loleary> SiriusXM is asking and is a bit alarmed... I have told them it is harmless but we should analyze its real meaning and attempt to suppress it if it shouldn't be a warning. 
<loleary> And I agree. If we can not suppress it then at bare minimum, it should probably appear in the FAQ.

Comment 1 Deon Ballard 2011-11-28 16:13:16 UTC

Dropped it in, short and sweet:
http://documentation-stage.bne.redhat.com/docs/en-US/JBoss_Operations_Network/300/html/Frequently_Asked_Questions/index.html#qa.hibernate-warn

And here:
http://rhq-project.org/display/JOPR2/FAQ#FAQ-Iamseeingthiserrorinmyserverlogsorstacktrace%3A%22WARN%26nbsp%3B%5CQueryTranslatorImpl%5CfirstResult%2FmaxResultsspecifiedwithcollectionfetch%3Bapplyinginmemory.%22Whatdoesthatmeanandwhatiscausingit%3F

Comment 2 Robert Buck 2011-11-29 14:49:01 UTC

Good.