|
Causes |
|||
| caused by |
|
New item value type Binary | Closed |
Team C
[ZBX-23154] Execution of housekeeper on TimescaleDB causes query error on history_bin table Created: 2023 Jul 26 Updated: 2024 Apr 10 Resolved: 2023 Oct 05 |
|
| Status: | Closed |
| Project: | ZABBIX BUGS AND ISSUES |
| Component/s: | Server (S) |
| Affects Version/s: | 7.0.0alpha1 |
| Fix Version/s: | 7.0.0alpha6, 7.0 (plan) |
| Type: | Problem report | Priority: | Trivial |
| Reporter: | Andrejs Kozlovs | Assignee: | Artjoms Rimdjonoks |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||
| Team: | Team C |
||||||||
| Sprint: | Sprint 103 (Aug 2023), Sprint 104 (Sep 2023) | ||||||||
| Story Points: | 1 | ||||||||
| Description |
|
Forced execution of housekeeper after Zabbix server with Timescale start produces the following error: 55029:20230726:110845.126 forced execution of the housekeeper 55029:20230726:110845.126 executing housekeeper 55029:20230726:110845.159 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: "history_bin" is not a hypertable or a continuous aggregate HINT: The operation is only possible on a hypertable or continuous aggregate. [select drop_chunks(relation=>'history_bin',older_than=>1682582925)] 55029:20230726:110845.160 cannot drop chunks for history_bin 55029:20230726:110845.170 housekeeper [deleted 0 hist/trends, 0 items/triggers, 0 events, 0 problems, 0 sessions, 0 alarms, 0 audit, 0 records in 0.029770 sec, idle for 1 hour(s)] |
| Comments |
| Comment by Artjoms Rimdjonoks [ 2023 Sep 29 ] |
|
Available in versions:
|