multi-threaded Client app queries gemfire and gets below error for a query,\\nQuery execution canceled after exceeding max execution time 18000000ms. Query String = SELECT * FROM /routingRule as rr WHERE rr.matchUsingCustomerName

[Nilesh Pathak]

We are using Gemfire 9 , the Region being queried has only 350 records and is very small. Region is partitioned. The issue does not occur immediately but usually after few hours of processing it suddenly appears. The cpu and memory are normal during that time.

 

Does anybody have encountered this before ? Thanks in advance.

[Juan Ramos]

Hello Nilesh,

 

Thanks for contacting the Support Community!.

That said, this is certainly weird... apparently the actual query never finished and, after the query timeout was exceeded, the exception was thrown. Considering that the region has only 350 entries, this certainly shouldn't happen. Can you open a Support Ticket directly and attach all of the relevant artefacts so one of our support engineers can assist you further please?.

Best regards.