Hello everyone,
I set up Zabbix 7 a few months ago and used Postgresql with the Timescaldb extension for the first time.
I have followed the Zabbix installation instructions for Postgres with Timescaledb.
Some Information:
OS: Debian 12
FS / Space total: 96GB
Postgresql: 16.3
Timescale Extension on Zabbix Database: 2.14.2
Zabbix: 7.02
Required server performance, new values per second - 445.36
In recent months, of course, several locations and devices have been included in the monitoring.
An increase is logical... but for the hard disk to fill up so quickly?
Here is an overview of the items.
Most of them are float and numeric items
I see the following error in the Postgres log:
2024-07-30 13:58:32.400 CEST [2577119] zabbix@zabbix TIPP: The operation is only possible on a hypertable or continuous aggregate.
2024-07-30 13:58:32.400 CEST [2577119] zabbix@zabbix ANWEISUNG: select drop_chunks(relation=>'history_bin',older_than=>17 19662312)
I found the following thread in the forum with the same error message.
The Output of: zabbix=# select * from _timescaledb_catalog.hypertable;
Maybe someone has a tip for me.
I set up Zabbix 7 a few months ago and used Postgresql with the Timescaldb extension for the first time.
I have followed the Zabbix installation instructions for Postgres with Timescaledb.
Some Information:
OS: Debian 12
FS / Space total: 96GB
Postgresql: 16.3
Timescale Extension on Zabbix Database: 2.14.2
Zabbix: 7.02
Required server performance, new values per second - 445.36
In recent months, of course, several locations and devices have been included in the monitoring.
An increase is logical... but for the hard disk to fill up so quickly?
Here is an overview of the items.
Most of them are float and numeric items
2024-07-30 13:58:32.400 CEST [2577119] zabbix@zabbix TIPP: The operation is only possible on a hypertable or continuous aggregate.
2024-07-30 13:58:32.400 CEST [2577119] zabbix@zabbix ANWEISUNG: select drop_chunks(relation=>'history_bin',older_than=>17 19662312)
I found the following thread in the forum with the same error message.
The Output of: zabbix=# select * from _timescaledb_catalog.hypertable;
Code:
id | schema_name | table_name | associated_schema_name | associated_table_prefix | num_dimensions | chunk_sizing_func_schema | chunk_sizing_func_name | chunk_target_size | compression_state | compressed_hypertable_id | status ----+-----------------------+---------------------------+------------------------+-------------------------+----------------+--------------------------+--------------------------+-------------------+-------------------+--------------------------+-------- 9 | _timescaledb_internal | _compressed_hypertable_9 | _timescaledb_internal | _hyper_9 | 0 | _timescaledb_functions | calculate_chunk_interval | 0 | 2 | | 0 1 | public | history | _timescaledb_internal | _hyper_1 | 1 | _timescaledb_functions | calculate_chunk_interval | 0 | 1 | 9 | 0 10 | _timescaledb_internal | _compressed_hypertable_10 | _timescaledb_internal | _hyper_10 | 0 | _timescaledb_functions | calculate_chunk_interval | 0 | 2 | | 0 2 | public | history_uint | _timescaledb_internal | _hyper_2 | 1 | _timescaledb_functions | calculate_chunk_interval | 0 | 1 | 10 | 0 11 | _timescaledb_internal | _compressed_hypertable_11 | _timescaledb_internal | _hyper_11 | 0 | _timescaledb_functions | calculate_chunk_interval | 0 | 2 | | 0 5 | public | history_str | _timescaledb_internal | _hyper_5 | 1 | _timescaledb_functions | calculate_chunk_interval | 0 | 1 | 11 | 0 12 | _timescaledb_internal | _compressed_hypertable_12 | _timescaledb_internal | _hyper_12 | 0 | _timescaledb_functions | calculate_chunk_interval | 0 | 2 | | 0 4 | public | history_text | _timescaledb_internal | _hyper_4 | 1 | _timescaledb_functions | calculate_chunk_interval | 0 | 1 | 12 | 0 13 | _timescaledb_internal | _compressed_hypertable_13 | _timescaledb_internal | _hyper_13 | 0 | _timescaledb_functions | calculate_chunk_interval | 0 | 2 | | 0 3 | public | history_log | _timescaledb_internal | _hyper_3 | 1 | _timescaledb_functions | calculate_chunk_interval | 0 | 1 | 13 | 0 14 | _timescaledb_internal | _compressed_hypertable_14 | _timescaledb_internal | _hyper_14 | 0 | _timescaledb_functions | calculate_chunk_interval | 0 | 2 | | 0 7 | public | trends | _timescaledb_internal | _hyper_7 | 1 | _timescaledb_functions | calculate_chunk_interval | 0 | 1 | 14 | 0 15 | _timescaledb_internal | _compressed_hypertable_15 | _timescaledb_internal | _hyper_15 | 0 | _timescaledb_functions | calculate_chunk_interval | 0 | 2 | | 0 8 | public | trends_uint | _timescaledb_internal | _hyper_8 | 1 | _timescaledb_functions | calculate_chunk_interval | 0 | 1 | 15 | 0 18 | _timescaledb_internal | _compressed_hypertable_18 | _timescaledb_internal | _hyper_18 | 0 | _timescaledb_functions | calculate_chunk_interval | 0 | 2 | | 0 17 | public | auditlog | _timescaledb_internal | _hyper_17 | 1 | _timescaledb_functions | calculate_chunk_interval | 0 | 1 | 18 | 0 (16 Zeilen)