Details
-
Bug
-
Resolution: Fixed
-
Major
-
7.1.0
-
7.1.0-1243
-
Untriaged
-
1
-
Unknown
Description
While running query workload I tried to check query stats via:
curl http://localhost:8093/admin/stats
Looks like some data is not updated ... was specifically looking to monitor active vs queued requests.
During tests I run multiple query thread and then check stats and also system:active_requests.
Here is what I see after I launch 16 query threads ... I also lower servicers setting to 4.
system:active_requests:
2021-09-12 15:15:46 | INFO | MainProcess | test_thread | [tuq.run_cbq_query] RUN QUERY SELECT state, node, count(*) as count FROM system:active_requests WHERE statement = 'select sleep(10000)' GROUP BY state, node |
2021-09-12 15:15:46 | INFO | MainProcess | test_thread | [rest_client.query_tool] query params : statement=SELECT+state%2C+node%2C+count%28%2A%29+as+count+FROM+system%3Aactive_requests+WHERE+statement+%3D+%27select+sleep%2810000%29%27+GROUP+BY+state%2C+node&scan_consistency=REQUEST_PLUS |
2021-09-12 15:15:46 | INFO | MainProcess | test_thread | [tuq.run_cbq_query] TOTAL ELAPSED TIME: 45.081809ms |
2021-09-12 15:15:46 | INFO | MainProcess | test_thread | [tuq_graceful_failover.test_failover] {'requestID': '90713ef2-15a1-4940-9f47-fc5afe7f1511', 'signature': {'count': 'number', 'node': 'json', 'state': 'json'}, 'results': [{'count': 16, 'node': '172.23.104.92:8091', 'state': 'running'}], 'status': 'success', 'metrics': {'elapsedTime': '45.081809ms', 'executionTime': '44.966265ms', 'resultCount': 1, 'resultSize': 58, 'serviceLoad': 1}} |
2021-09-12 15:15:46 | INFO | MainProcess | test_thread | [basetestcase.sleep] sleep for 2 secs. ... |
|
and admin/stats via REST:
2021-09-12 15:15:48 | INFO | MainProcess | test_thread | [rest_client.query_tool_stats] query n1ql stats 2021-09-12 15:15:48 | INFO | MainProcess | test_thread | [tuq_graceful_failover.test_failover] {'active_requests.count': 0, 'at_plus.count': 0, 'audit_actions.count': 0, 'audit_actions_failed.count': 0, 'audit_requests_filtered.count': 60, 'audit_requests_total.count': 60, 'cancelled.count': 0, 'deletes.count': 0, 'errors.count': 0, 'index_scans.count': 0, 'inserts.count': 0, 'invalid_requests.count': 0, 'load.value': 25, 'mutations.count': 0, 'prepared.count': 0, 'primary_scans.count': 0, 'queued_requests.count': 0, 'request_time.count': 0, 'request_timer.15m.rate': 0, 'request_timer.1m.rate': 0, 'request_timer.5m.rate': 0, 'request_timer.75%': 0, 'request_timer.95%': 0, 'request_timer.99%': 0, 'request_timer.99.9%': 0, 'request_timer.count': 0, 'request_timer.max': 0, 'request_timer.mean': 0, 'request_timer.mean.rate': 0, 'request_timer.median': 0, 'request_timer.min': 0, 'request_timer.stddev': 0, 'requests.count': 0, 'requests_1000ms.count': 0, 'requests_250ms.count': 0, 'requests_5000ms.count': 0, 'requests_500ms.count': 0, 'result_count.count': 0, 'result_size.count': 0, 'scan_plus.count': 0, 'selects.count': 0, 'service_time.count': 0, 'transaction_time.count': 0, 'transactions.count': 0, 'unbounded.count': 0, 'updates.count': 0, 'warnings.count': 0} |