benchbase icon indicating copy to clipboard operation
benchbase copied to clipboard

Fix PG monitoring errors

Open bpkroth opened this issue 8 months ago • 0 comments

Noticed these in some of the CI runs. Might have been there earlier and I missed it. Should probably have a check for that as well as improved checking of results actually being logged.

@anjagruenheid do you mind taking a quick look?

Error:  2024-06-03 20:55:40,800 [Thread-5]  com.oltpbenchmark.api.collectors.monitoring.DatabaseMonitor extractQueryMetrics - ERROR: relation "pg_stat_statements" does not exist
  Position: 223
[INFO ] 2024-06-03 20:55:41,719 [main]  com.oltpbenchmark.ThreadBench runRateLimitedMultiPhase - TERMINATE :: Waiting for all terminals to finish ..
Error:  2024-06-03 20:55:41,720 [Thread-5]  com.oltpbenchmark.api.collectors.monitoring.DatabaseMonitor extractQueryMetrics - Error when extracting per query metrics.
Error:  2024-06-03 20:55:41,720 [Thread-5]  com.oltpbenchmark.api.collectors.monitoring.DatabaseMonitor extractQueryMetrics - ERROR: relation "pg_stat_statements" does not exist
  Position: 223
Error:  2024-06-03 20:55:41,721 [Thread-5]  com.oltpbenchmark.api.collectors.monitoring.DatabaseMonitor cleanupCache - Error when cleaning up cached plans.
Error:  2024-06-03 20:55:41,721 [Thread-5]  com.oltpbenchmark.api.collectors.monitoring.DatabaseMonitor cleanupCache - ERROR: function pg_stat_statements_reset() does not exist
  Hint: No function matches the given name and argument types. You might need to add explicit type casts.
  Position: 8
[WARN ] 2024-06-03 20:55:41,721 [Thread-5]  com.oltpbenchmark.api.collectors.monitoring.DatabaseMonitor writeSingleQueryEventsToCSV - No query events have been recorded, file not written.
[WARN ] 2024-06-03 20:55:41,721 [Thread-5]  com.oltpbenchmark.api.collectors.monitoring.DatabaseMonitor writeRepeatedQueryEventsToCSV - No repeated query events have been recorded, file not written.

bpkroth avatar Jun 03 '24 21:06 bpkroth