Поломался timescale, помогите

[dedy]

Есть zabbix server 5.0.9
postgres 11
timescale 2.1.0

Дёрнул черт обновить timescale - не помню какая версия была до этого. После его обновы в логах сипет постоянно



2021-03-01 16:09:36.023 EET [19759] ERROR: invalid hypertable or continuous aggregate
2021-03-01 16:09:36.023 EET [19759] STATEMENT: SELECT drop_chunks(1610287776,'history_uint')
2021-03-01 16:09:36.023 EET [19759] ERROR: invalid hypertable or continuous aggregate
2021-03-01 16:09:36.023 EET [19759] STATEMENT: SELECT drop_chunks(1610287776,'history_text')
2021-03-01 16:09:36.023 EET [19759] ERROR: invalid hypertable or continuous aggregate
2021-03-01 16:09:36.023 EET [19759] STATEMENT: SELECT drop_chunks(1597327776,'trends')
2021-03-01 16:09:36.023 EET [19759] ERROR: invalid hypertable or continuous aggregate
2021-03-01 16:09:36.023 EET [19759] STATEMENT: SELECT drop_chunks(1597327776,'trends_uint')
2021-03-01 17:09:38.927 EET [1980] ERROR: invalid hypertable or continuous aggregate
2021-03-01 17:09:38.927 EET [1980] STATEMENT: SELECT drop_chunks(1610291378,'history')
2021-03-01 17:09:38.927 EET [1980] ERROR: invalid hypertable or continuous aggregate
2021-03-01 17:09:38.927 EET [1980] STATEMENT: SELECT drop_chunks(1610291378,'history_str')
2021-03-01 17:09:38.928 EET [1980] ERROR: invalid hypertable or continuous aggregate
2021-03-01 17:09:38.928 EET [1980] STATEMENT: SELECT drop_chunks(1610291378,'history_log')
2021-03-01 17:09:38.928 EET [1980] ERROR: invalid hypertable or continuous aggregate
2021-03-01 17:09:38.928 EET [1980] STATEMENT: SELECT drop_chunks(1610291378,'history_uint')
2021-03-01 17:09:38.928 EET [1980] ERROR: invalid hypertable or continuous aggregate
2021-03-01 17:09:38.928 EET [1980] STATEMENT: SELECT drop_chunks(1610291378,'history_text')
2021-03-01 17:09:38.928 EET [1980] ERROR: invalid hypertable or continuous aggregate
2021-03-01 17:09:38.928 EET [1980] STATEMENT: SELECT drop_chunks(1597331378,'trends')
2021-03-01 17:09:38.928 EET [1980] ERROR: invalid hypertable or continuous aggregate
2021-03-01 17:09:38.928 EET [1980] STATEMENT: SELECT drop_chunks(1597331378,'trends_uint')
2021-03-01 18:09:39.796 EET [20002] ERROR: invalid hypertable or continuous aggregate
2021-03-01 18:09:39.796 EET [20002] STATEMENT: SELECT drop_chunks(1610294979,'history')
2021-03-01 18:09:39.797 EET [20002] ERROR: invalid hypertable or continuous aggregate
2021-03-01 18:09:39.797 EET [20002] STATEMENT: SELECT drop_chunks(1610294979,'history_str')
2021-03-01 18:09:39.797 EET [20002] ERROR: invalid hypertable or continuous aggregate
2021-03-01 18:09:39.797 EET [20002] STATEMENT: SELECT drop_chunks(1610294979,'history_log')
2021-03-01 18:09:39.797 EET [20002] ERROR: invalid hypertable or continuous aggregate
2021-03-01 18:09:39.797 EET [20002] STATEMENT: SELECT drop_chunks(1610294979,'history_uint')
2021-03-01 18:09:39.797 EET [20002] ERROR: invalid hypertable or continuous aggregate
2021-03-01 18:09:39.797 EET [20002] STATEMENT: SELECT drop_chunks(1610294979,'history_text')
2021-03-01 18:09:39.797 EET [20002] ERROR: invalid hypertable or continuous aggregate
2021-03-01 18:09:39.797 EET [20002] STATEMENT: SELECT drop_chunks(1597334979,'trends')
2021-03-01 18:09:39.798 EET [20002] ERROR: invalid hypertable or continuous aggregate
2021-03-01 18:09:39.798 EET [20002] STATEMENT: SELECT drop_chunks(1597334979,'trends_uint')



Как можно полечить ?

Исторические данные не особо важны - можно удалить, важны настройки\тригеры и т.д.

Заранее спасибо

[dedy]

удалил новую версию пи поставил старую, ошибок нет, как точно проверить что всё работает правильно ?

[0xbeer]

Добрый день! Аналогичная проблема. Развернул новый Zabbix сервер(5.2) и PostgreSQL13 с Timescaledb-2.1, сыпит такие же ошибки.

Судя по документации, изменилась функция drop_chunks:

TSDB >= 2.0:

SELECT drop_chunks('conditions', 1483228800000);

TSDB <2.0:

SELECT drop_chunks(1483228800000, 'conditions');

[0xbeer]

https://support.zabbix.com/browse/ZBX-18854

Fixed in:

• pre-5.0.10rc1 4189dd282e
• pre-5.2.6rc1 eaf712507e
• pre-5.4.0beta1 c44275c1b7

Обновился для 5.4.0beta1, ошибка ушла.