K003 fails to collect/process data for replicas
When K003 is run (for the 2nd time, to have 2 pg_stat_statements/kcache snapshots analyzed), it works fine for the master node:
[2018-12-27T20:01:12-0800] ========== Perform check: ==========
[2018-12-27T20:01:12-0800] ./resources/checks/K003_top_total_time.sh
[2018-12-27T20:01:16-0800] ========== End of check ===========
[2018-12-27T20:01:16-0800] check 'K003' is finished
[2018-12-27T20:01:17-0800] JSON report saved at: './artifacts/host/json_reports/1_2018_12_26T21_16_44_-0800/K003_top_total_time.json'
[2018-12-27T20:01:17-0800] Markdown report saved at: './artifacts/host/md_reports/1_2018_12_26T21_16_44_-0800/K003_top_total_time.md'
[2018-12-27T20:01:17-0800]
But it always fails when it tries to process data for a replica (any replica):
[2018-12-27T20:02:30-0800] ========== Perform check: ==========
[2018-12-27T20:02:30-0800] ./resources/checks/K003_top_total_time.sh
jq: error: Could not open file ./artifacts/host/json_reports/1_2018_12_26T21_16_44_-0800/tmp_K003/2_proddb_2.json: No such file or directory
^^^ ERROR at line: ['161']
[2018-12-27T20:02:32-0800] ========== End of check ===========
[2018-12-27T20:02:32-0800] WARNING: check 'K003' failed with error ^^^
[2018-12-27T20:02:32-0800]
Edited by postgres-ai