-
Problem report
-
Resolution: Duplicate
-
Trivial
-
None
-
7.2.11
-
None
-
None
Hello Team,
As in the title, after the Zabbix startup there are following log messages after upgrading from 7.2.10 to 7.2.11 and TSDB from 2.19.X to 2.20.X
1691698:20250722:140445.766 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: columnstore policy already exists for hypertable or continuous aggregate "history_uint"
HINT: Set option "if_not_exists" to true to avoid error.
[select add_compression_policy('history_uint', integer '612000')]
1691698:20250722:140445.766 failed to add compression policy to table 'history_uint'
1691698:20250722:140445.771 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: columnstore policy already exists for hypertable or continuous aggregate "history_str"
HINT: Set option "if_not_exists" to true to avoid error.
[select add_compression_policy('history_str', integer '612000')]
1691698:20250722:140445.772 failed to add compression policy to table 'history_str'
1691705:20250722:140445.776 thread started [discovery worker #1]
1691851:20250722:140445.777 server #143 started [icmp pinger #12]
1691878:20250722:140445.778 thread started
1691698:20250722:140445.779 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: columnstore policy already exists for hypertable or continuous aggregate "history_text"
HINT: Set option "if_not_exists" to true to avoid error.
[select add_compression_policy('history_text', integer '612000')]
1691698:20250722:140445.779 failed to add compression policy to table 'history_text'
1691698:20250722:140445.783 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: columnstore policy already exists for hypertable or continuous aggregate "history_log"
HINT: Set option "if_not_exists" to true to avoid error.
[select add_compression_policy('history_log', integer '612000')]
1691698:20250722:140445.783 failed to add compression policy to table 'history_log'
1691698:20250722:140445.788 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: columnstore policy already exists for hypertable or continuous aggregate "history_bin"
HINT: Set option "if_not_exists" to true to avoid error.
[select add_compression_policy('history_bin', integer '612000')]
1691698:20250722:140445.788 failed to add compression policy to table 'history_bin'
1691698:20250722:140445.795 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: columnstore policy already exists for hypertable or continuous aggregate "trends"
HINT: Set option "if_not_exists" to true to avoid error.
[select add_compression_policy('trends', integer '612000')]
1691698:20250722:140445.795 failed to add compression policy to table 'trends'
1691698:20250722:140445.802 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: columnstore policy already exists for hypertable or continuous aggregate "trends_uint"
HINT: Set option "if_not_exists" to true to avoid error.
[select add_compression_policy('trends_uint', integer '612000')]
1691698:20250722:140445.802 failed to add compression policy to table 'trends_uint'
1691698:20250722:140445.805 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: columnstore policy already exists for hypertable or continuous aggregate "auditlog"
HINT: Set option "if_not_exists" to true to avoid error.
[select add_compression_policy('auditlog', compress_created_before => interval '612000')]
1691698:20250722:140445.805 failed to add compression policy to table 'auditlog'
- duplicates
-
ZBXNEXT-9770 Replace TimescaleDB functions deprecated starting from version 2.18.0
-
- Closed
-