The QueryService needed to cache a result set of 19622624 bytes. What is the root cause for such an issue ?
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