-
Documentation task
-
Resolution: Fixed
-
Major
-
None
Errors in zabbix_server.log:
24889:20190204:215925.404 forced execution of the housekeeper 24889:20190204:215925.404 executing housekeeper 24889:20190204:215925.435 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: function drop_chunks(integer, unknown) does not exist LINE 1: SELECT drop_chunks(1548700165,'history') ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. [SELECT drop_chunks(1548700165,'history')] 24889:20190204:215925.435 cannot drop chunks for history 24889:20190204:215925.435 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: function drop_chunks(integer, unknown) does not exist LINE 1: SELECT drop_chunks(1548700165,'history_uint') ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. [SELECT drop_chunks(1548700165,'history_uint')] 24889:20190204:215925.435 cannot drop chunks for history_uint 24889:20190204:215925.435 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: function drop_chunks(integer, unknown) does not exist LINE 1: SELECT drop_chunks(1517768965,'trends') ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. [SELECT drop_chunks(1517768965,'trends')] 24889:20190204:215925.435 cannot drop chunks for trends 24889:20190204:215925.435 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: function drop_chunks(integer, unknown) does not exist LINE 1: SELECT drop_chunks(1517768965,'trends_uint') ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. [SELECT drop_chunks(1517768965,'trends_uint')] 24889:20190204:215925.435 cannot drop chunks for trends_uint 24889:20190204:215925.610 housekeeper [deleted 0 hist/trends, 26 items/triggers, 659 events, 332 problems, 294 sessions, 0 alarms, 294 audit items in 0.179683 sec, idle for 1 hour(s)]
My env:
zabbix_server --version
zabbix_server (Zabbix) 4.2.0alpha3
sudo -u postgres psql <<< "select version();"
---------------------------------------------------------------------------------------------------------
PostgreSQL 11.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-28), 64-bit
(1 row)
uname -a
Linux LCT-MON-Zabbix 3.10.0-957.1.3.el7.x86_64 #1 SMP Thu Nov 29 14:49:43 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux
yum list timescaledb_11
Installed Packages
timescaledb_11.x86_64 1.1.1-1.rhel7
.
