-
Problem report
-
Resolution: Commercial support required
-
Trivial
-
None
-
7.0.15
-
Docker environment timescale/timescaledb:2.19.3-pg15
TimescaleDB 2.19.3
PostgreSQL 15.12
Compression policy for history and history_uint in -infinity state
when call compression jobs for this tables we got
LOG: server process (PID 183786) was terminated by signal 9: Killed
DETAIL: Failed process was running: CALL _timescaledb_functions.policy_compression()
LOG: terminating any other active server processes
FATAL: the database system is in recovery mode
LOG: all server processes terminated; reinitializing
job_id | application_name | schedule_interval | max_runtime | max_retries | retry_period | proc_schema | proc_name | owner | scheduled | fixed_schedule | config
| next_start | initial_start | hypertable_schema | hypertable_name | check_schema | check_name
--------+---------------------------+-------------------+-------------+-------------+--------------+------------------------+--------------------+--------+-----------+----------------+-----------------------------------------------------
---------+-------------------------------+---------------+-------------------+-----------------+------------------------+--------------------------
1000 | Compression Policy [1000] | 1 day | 00:00:00 | -1 | 01:00:00 | _timescaledb_functions | policy_compression | zabbix | t | f | \{"hypertable_id": 1, "compress_after": 612000}
| -infinity | | public | history | _timescaledb_functions | policy_compression_check
1001 | Compression Policy [1001] | 1 day | 00:00:00 | -1 | 01:00:00 | _timescaledb_functions | policy_compression | zabbix | t | f | \{"hypertable_id": 2, "compress_after": 612000}
| -infinity | | public | history_uint | _timescaledb_functions | policy_compression_check
1004 | Compression Policy [1004] | 1 day | 00:00:00 | -1 | 01:00:00 | _timescaledb_functions | policy_compression | zabbix | t | f | \{"hypertable_id": 3, "compress_after": 612000}
| 2025-07-15 15:49:26.97526+03 | | public | history_log | _timescaledb_functions | policy_compression_check
1003 | Compression Policy [1003] | 1 day | 00:00:00 | -1 | 01:00:00 | _timescaledb_functions | policy_compression | zabbix | t | f | \{"hypertable_id": 4, "compress_after": 612000}
| 2025-07-15 15:49:28.01218+03 | | public | history_text | _timescaledb_functions | policy_compression_check
1002 | Compression Policy [1002] | 1 day | 00:00:00 | -1 | 01:00:00 | _timescaledb_functions | policy_compression | zabbix | t | f | \{"hypertable_id": 5, "compress_after": 612000}
| 2025-07-15 15:49:28.509636+03 | | public | history_str | _timescaledb_functions | policy_compression_check
1005 | Compression Policy [1005] | 1 day | 00:00:00 | -1 | 01:00:00 | _timescaledb_functions | policy_compression | zabbix | t | f | \{"hypertable_id": 6, "compress_after": 612000}
| 2025-07-15 15:49:27.36708+03 | | public | history_bin | _timescaledb_functions | policy_compression_check
1008 | Compression Policy [1008] | 1 day | 00:00:00 | -1 | 01:00:00 | _timescaledb_functions | policy_compression | zabbix | t | f | {"hypertable_id": 7, "compress_created_before": "170
:00:00"} | 2025-07-15 15:50:06.319478+03 | | public | auditlog | _timescaledb_functions | policy_compression_check
1006 | Compression Policy [1006] | 1 day | 00:00:00 | -1 | 01:00:00 | _timescaledb_functions | policy_compression | zabbix | t | f | \{"hypertable_id": 8, "compress_after": 612000}
| 2025-07-15 15:49:26.896061+03 | | public | trends | _timescaledb_functions | policy_compression_check
1007 | Compression Policy [1007] | 1 day | 00:00:00 | -1 | 01:00:00 | _timescaledb_functions | policy_compression | zabbix | t | f | \{"hypertable_id": 9, "compress_after": 612000}
| 2025-07-15 15:49:27.023209+03 | | public | trends_uint | _timescaledb_functions | policy_compression_check
(9 строк)