firstResult/maxResults specified with collection fetch; applying in memory!

[udayatom]

Hello friends,

                  Now i changed to RHQ Server 4.6.0, now i server log throws like this, what is it means and why. How to fix.

13:52:51,106 WARN  [org.hibernate.hql.internal.ast.QueryTranslatorImpl] (http--127.0.0.1-7080-1) HHH000104: firstResult/maxResults specified with collection fetch; applying in memory!
.
.
.
13:53:51,119 WARN  [org.hibernate.hql.internal.ast.QueryTranslatorImpl] (http--127.0.0.1-7080-2) HHH000104: firstResult/maxResults specified with collection fetch; applying in memory!
.
.
.
.
13:54:51,079 WARN  [org.hibernate.hql.internal.ast.QueryTranslatorImpl] (http--127.0.0.1-7080-3) HHH000104: firstResult/maxResults specified with collection fetch; applying in memory!
13:55:51,065 WARN  [org.hibernate.hql.internal.ast.QueryTranslatorImpl] (http--127.0.0.1-7080-4) HHH000104: firstResult/maxResults specified with collection fetch; applying in memory!

Regards,

Udaya

[pathduck]

Hello Udaya.

This is something I see in our logs too. Apparently it is a known issue:

https://community.jboss.org/message/817549#817549

-Stian

[jayshaughnessy]

This is a warning related to performance, not correctness.  Seeing this does not indicate or explain any incorrect behavior, only the possibility of a slow query.  As an aside, the vast majority of these warnings will go away in RHQ 4.8.

[pathduck]

It might or might not be related, but I am getting a lot of these warnings when trying to open historical graphs and they do not show at all.

I might open a bug for it actually, it seems to be an issue with the new graphs.

-Stian