[ZBX-18902] Zabbix Housekeeper 5.2.3 not working with TimeScaleDB 12.0.0 Created: 2021 Jan 21 Updated: 2021 Jan 27 Resolved: 2021 Jan 27 |
|
Status: | Closed |
Project: | ZABBIX BUGS AND ISSUES |
Component/s: | Server (S) |
Affects Version/s: | 5.2.3 |
Fix Version/s: | None |
Type: | Problem report | Priority: | Trivial |
Reporter: | Denis Pavlov | Assignee: | Arturs Lontons |
Resolution: | Duplicate | Votes: | 0 |
Labels: | None | ||
Remaining Estimate: | Not Specified | ||
Time Spent: | Not Specified | ||
Original Estimate: | Not Specified | ||
Environment: |
Cent OS 8, Zabbix 5.2.3, PostgreSQL 12.5, TimeScaleDB 2.0.0 |
Issue Links: |
|
Description |
Steps to reproduce:
Result: Expected: In TimeScaleDB docs https://docs.timescale.com/latest/api#drop_chunks we see: SELECT drop_chunks('conditions', INTERVAL '3 months'); The first argument is a table, and second argument - interval. And in Zabbix source code we see: zabbix-5.2.3/src/zabbix_server/housekeeper/housekeeper.c: result = DBselect("SELECT drop_chunks(%d,'%s')", keep_from, rule->table); Here on the contrary, the first argument is a interval, and second argument - table.
As result we get error: zabbix=# SELECT drop_chunks(1611234923,'history'); |
Comments |
Comment by Edgar Akhmetshin [ 2021 Jan 27 ] |
Closing as a duplicate: |