Compression policy jobs fail to successfully complete.
Microsoft Windows Server 2016
Install method: Windows Zip file release for PG 12
All my compression policy jobs have failed for approximately the last 6 weeks. Before that the compression jobs ran without any problems for over 18 months. Job failures occur on tables with time columns of both type timestamp and bigint. It appears that the failures started when I upgraded the Timescale extension from version 2.3.0 to 2.7.0. I have updated the Timescale extension to version 2.7.2, and the problem persists. I have also deleted the compression policy on one hypertable and recreated it, and it still fails.
I can manually compress a chunk in a hypertable with the compress_chunk() function without any problems.
Below is the output from the job_stats function for one of my compression policy jobs.
- job_id: 1000
- last_run_started_at: 8/2/2022 5:19:18 PM
- last_successful_finish: 6/26/2022 2:18:27 PM
- last_run_status: Failed
- job_status: Scheduled
- last_run_duration: 1.7
- next_start: 8/3/2022 3:11:50 PM
- total_runs: 63
- total_successes: 26
- total_failures: 37
How do I get more information about why the job is failing?