Getting query threads limit - can't start new query

1

Hi,

We are running read/insert workload and getting following error:

Apr 26 17:18:31 ip-10-3-0-134 asd[11295]: Apr 26 2024 17:18:31 GMT: WARNING (query): (query_manager.c:116) at query threads limit - can’t start new query

Apr 26 17:18:31 ip-10-3-0-134 asd[11295]: Apr 26 2024 17:18:31 GMT: WARNING (query): (query.c:1570) basic query job 6773828919562901824 failed to start (22)

Increased the query-threads-limit to 512, still the same.

asinfo -v “set-config:context=service;query-threads-limit=512”

Kindly advise.

Thanks Shubham

2

Basic Query → is a foreground query. Each query by default uses 4 query threads (single-query-threads), query-threads-limit is 128 default - so by default, you can start 128/4 = 32 parallel queries. Now depending on how many parallel queries you are initiating (if you are specifying the query as “short” then it uses only a single query thread), you can play with the settings and the math. Slide below will help explain.

image
image720×405 75.6 KB