It's all about the answers!

Ask a question

The QueryService needed to cache a result set of 19622624 bytes. What is the root cause for such an issue ?


Srinivas Iyer (111) | asked Oct 17 '19, 3:14 a.m.
Hello All,

We are getting this error in our CCM log and it is causing performance issue in Jazz server.  Have you ever come across such an issue and what is solution in order avoid such a huge request



/ccm/oslc/contexts/_qi848CJaEeSy9NmiE0zU4Q/workitems] [ WARN] com.ibm.team.repository                            - The QueryService needed to cache a result set of 19622624 bytes.  This large result set will take a disproportionate amount of room in the query cache.  The AstQuery is:


WorkItemQueryModel r = WorkItemQueryModel.ROOT;
AstQuery q = (AstQuery) IItemQuery.FACTORY.newInstance(r);
q.distinct();
q.filter(r.projectArea()._eq(q.newItemHandleArg())._and(r.workItemType()._eq(q.newStringArg())));
q.orderByDsc(r.modified());

java.lang.Throwable: A huge result set (length in bytes) was found here
        at com.ibm.team.repository.service.internal.QueryService.cacheResult(QueryService.java:328)
        at com.ibm.team.repository.service.internal.QueryService.doExecuteItemQuery(QueryService.java:247)
        at com.ibm.team.repository.service.internal.QueryService.access$0(QueryService.java:236)

        at com.ibm.team.repository.service.internal.QueryService$1.run(QueryService.java:174)


Regards,
Srinivasa M.V
   

One answer



permanent link
Bharath Rao (90034) | answered Oct 18 '19, 1:20 a.m.

 Hello Srinivasa,


Have you checked the query cache size currently set in RTC ?

Here is the technote with the details of query size configuration you could try..

Let me know if it helped or if you have any questions.

Regards,
Bharath

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.