Problem Description
After upgrading from a pre 6.0 version to a 6+ version getting the following errors.WARNING (query): (query_manager.c:116) at query threads limit - can't start new query
WARNING (query): (query.c:1489) basic query job XXXXXXXX failed to start (22)
Explanation
The parameter names have changed between versions prior to V6 and V6.0.0 and above.query-threads-limit. introduced 6.0
query-threads. removed in 6.0
Solution
In version 6.0.0. and above the parameters to control query threads aresingle-query-threads
https://docs.aerospike.com/server/reference/configuration/index.html#single-query-threads
query-threads-limit
https://docs.aerospike.com/server/reference/configuration/index.html#query-threads-limit
see examples below
single-query-threads
Maximum number of threads allowed for a single query. Value range: 1-128. default 4
"change the id=test to your namespace name id=<your namespace name>
asadm
Admin> enable
Admin+>
Admin+> asinfo -v "set-config:context=namespace;id=test;single-query-threads=12"
source-1:3100 (172.17.0.3) returned:
ok
source-2:3101 (172.17.0.2) returned:
ok
query-threads-limit
Maximum number of threads allowed for all queries. Can be dynamically increased or decreased. Value range: 1-1024. default 128
asadm
Admin> enable
Admin+> asinfo -v "set-config:context=service;query-threads-limit=256"
source-1:3000 (172.17.0.4) returned:
ok
source-2:3000 (172.17.0.3) returned:
ok
Notes
asadm must be run in privileged mode e.g.asadm
Admin> enable
Admin+>