[ZBX-18987] Zabbix 5.0 with TimescaleDB 2.0 Created: 2021 Feb 08  Updated: 2021 Feb 11  Resolved: 2021 Feb 11

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 5.0.8
Fix Version/s: None

Type: Problem report Priority: Minor
Reporter: Aigars Kadikis Assignee: Zabbix Development Team
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
duplicates ZBX-18854 TimescaleDB 2.0 changes are not compa... Closed
Sub-task

 Description   

Environment: TimescaleDB 2.0.1 (PostgreSQL 12.5).

When a stock 5.0.8 server been prepared with an enabled TimescaleDB extension, the server at startup says:

     6:20210208:133517.613 Starting Zabbix Server. Zabbix 5.0.8 (revision d3c78f9).
     6:20210208:133517.613 ****** Enabled features ******
     6:20210208:133517.613 SNMP monitoring:           YES
     6:20210208:133517.613 IPMI monitoring:           YES
     6:20210208:133517.613 Web monitoring:            YES
     6:20210208:133517.613 VMware monitoring:         YES
     6:20210208:133517.613 SMTP authentication:       YES
     6:20210208:133517.613 ODBC:                      YES
     6:20210208:133517.613 SSH support:               YES
     6:20210208:133517.613 IPv6 support:              YES
     6:20210208:133517.613 TLS support:               YES
     6:20210208:133517.613 ******************************
     6:20210208:133517.613 using configuration file: /etc/zabbix/zabbix_server.conf
     6:20210208:133517.706 current database version (mandatory/optional): 05000000/05000002
     6:20210208:133517.706 required mandatory version: 05000000
     6:20210208:133517.854 server #0 started [main process]
   202:20210208:133517.854 server #1 started [configuration syncer #1]
   210:20210208:133517.982 server #9 started [poller #1]
   211:20210208:133517.984 server #10 started [unreachable poller #1]
   212:20210208:133517.984 server #11 started [trapper #1]
   213:20210208:133517.987 server #12 started [trapper #2]
   214:20210208:133517.989 server #13 started [icmp pinger #1]
   215:20210208:133517.992 server #14 started [alert manager #1]
   216:20210208:133517.993 server #15 started [alerter #1]
   217:20210208:133517.993 server #16 started [preprocessing manager #1]
   209:20210208:133517.994 server #8 started [task manager #1]
   205:20210208:133517.994 server #4 started [http poller #1]
   206:20210208:133517.995 server #5 started [history syncer #1]
   207:20210208:133517.995 server #6 started [escalator #1]
   208:20210208:133517.996 server #7 started [self-monitoring #1]
   222:20210208:133518.002 server #21 started [alert syncer #1]
   203:20210208:133518.005 server #2 started [housekeeper #1]
   204:20210208:133518.006 server #3 started [timer #1]
   218:20210208:133518.008 server #17 started [preprocessing worker #1]
   219:20210208:133518.009 server #18 started [preprocessing worker #2]
   220:20210208:133518.009 server #19 started [lld manager #1]
   221:20210208:133518.010 server #20 started [lld worker #1]
   203:20210208:133518.322 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  relation "_timescaledb_config.bgw_policy_compress_chunks" does not exist
LINE 1: select (p.older_than).integer_interval from _timescaledb_con...
                                                    ^
 [select (p.older_than).integer_interval from _timescaledb_config.bgw_policy_compress_chunks p inner join _timescaledb_catalog.hypertable h on (h.id = p.hypertable_id) where h.table_name='history']
   210:20210208:133518.326 Zabbix agent item "vm.memory.size[total]" on host "Zabbix server" failed: first network error, wait for 15 seconds
   203:20210208:133518.326 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  function add_compress_chunks_policy(unknown, integer) does not exist
LINE 1: select add_compress_chunks_policy('history', integer '612000...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
 [select add_compress_chunks_policy('history', integer '612000')]
   203:20210208:133518.326 failed to add compression policy to table 'history'
   203:20210208:133518.335 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  relation "_timescaledb_config.bgw_policy_compress_chunks" does not exist
LINE 1: select (p.older_than).integer_interval from _timescaledb_con...
                                                    ^
 [select (p.older_than).integer_interval from _timescaledb_config.bgw_policy_compress_chunks p inner join _timescaledb_catalog.hypertable h on (h.id = p.hypertable_id) where h.table_name='history_uint']
   203:20210208:133518.336 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  function add_compress_chunks_policy(unknown, integer) does not exist
LINE 1: select add_compress_chunks_policy('history_uint', integer '6...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
 [select add_compress_chunks_policy('history_uint', integer '612000')]
   203:20210208:133518.336 failed to add compression policy to table 'history_uint'
   203:20210208:133518.347 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  relation "_timescaledb_config.bgw_policy_compress_chunks" does not exist
LINE 1: select (p.older_than).integer_interval from _timescaledb_con...
                                                    ^
 [select (p.older_than).integer_interval from _timescaledb_config.bgw_policy_compress_chunks p inner join _timescaledb_catalog.hypertable h on (h.id = p.hypertable_id) where h.table_name='history_str']
   203:20210208:133518.348 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  function add_compress_chunks_policy(unknown, integer) does not exist
LINE 1: select add_compress_chunks_policy('history_str', integer '61...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
 [select add_compress_chunks_policy('history_str', integer '612000')]
   203:20210208:133518.348 failed to add compression policy to table 'history_str'
   203:20210208:133518.355 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  relation "_timescaledb_config.bgw_policy_compress_chunks" does not exist
LINE 1: select (p.older_than).integer_interval from _timescaledb_con...
                                                    ^
 [select (p.older_than).integer_interval from _timescaledb_config.bgw_policy_compress_chunks p inner join _timescaledb_catalog.hypertable h on (h.id = p.hypertable_id) where h.table_name='history_text']
   203:20210208:133518.355 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  function add_compress_chunks_policy(unknown, integer) does not exist
LINE 1: select add_compress_chunks_policy('history_text', integer '6...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
 [select add_compress_chunks_policy('history_text', integer '612000')]
   203:20210208:133518.355 failed to add compression policy to table 'history_text'
   203:20210208:133518.364 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  relation "_timescaledb_config.bgw_policy_compress_chunks" does not exist
LINE 1: select (p.older_than).integer_interval from _timescaledb_con...
                                                    ^
 [select (p.older_than).integer_interval from _timescaledb_config.bgw_policy_compress_chunks p inner join _timescaledb_catalog.hypertable h on (h.id = p.hypertable_id) where h.table_name='history_log']
   203:20210208:133518.364 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  function add_compress_chunks_policy(unknown, integer) does not exist
LINE 1: select add_compress_chunks_policy('history_log', integer '61...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
 [select add_compress_chunks_policy('history_log', integer '612000')]
   203:20210208:133518.364 failed to add compression policy to table 'history_log'
   203:20210208:133518.371 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  relation "_timescaledb_config.bgw_policy_compress_chunks" does not exist
LINE 1: select (p.older_than).integer_interval from _timescaledb_con...
                                                    ^
 [select (p.older_than).integer_interval from _timescaledb_config.bgw_policy_compress_chunks p inner join _timescaledb_catalog.hypertable h on (h.id = p.hypertable_id) where h.table_name='trends']
   203:20210208:133518.371 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  function add_compress_chunks_policy(unknown, integer) does not exist
LINE 1: select add_compress_chunks_policy('trends', integer '612000'...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
 [select add_compress_chunks_policy('trends', integer '612000')]
   203:20210208:133518.371 failed to add compression policy to table 'trends'
   203:20210208:133518.377 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  relation "_timescaledb_config.bgw_policy_compress_chunks" does not exist
LINE 1: select (p.older_than).integer_interval from _timescaledb_con...
                                                    ^
 [select (p.older_than).integer_interval from _timescaledb_config.bgw_policy_compress_chunks p inner join _timescaledb_catalog.hypertable h on (h.id = p.hypertable_id) where h.table_name='trends_uint']
   203:20210208:133518.378 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  function add_compress_chunks_policy(unknown, integer) does not exist
LINE 1: select add_compress_chunks_policy('trends_uint', integer '61...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
 [select add_compress_chunks_policy('trends_uint', integer '612000')]
   203:20210208:133518.378 failed to add compression policy to table 'trends_uint'

 

To reproduce. Start TimescaleDB container:

docker run --name ts20 -t -e POSTGRES_PASSWORD="zabbix" -e POSTGRES_DB="dummy_db" -p 7413:5432 -d timescale/timescaledb:2.0.1-pg12

Preparing database:

docker exec -it ts20 bash
su - postgres
createuser --pwprompt zabbix
createdb -O zabbix z50

wget https://cdn.zabbix.com/zabbix/sources/stable/5.0/zabbix-5.0.8.tar.gz
gunzip zabbix-5.0.8.tar.gz
tar xvf zabbix-5.0.8.tar

cd zabbix-5.0.8/database/postgresql
cat schema.sql images.sql data.sql timescaledb.sql| psql --username=zabbix z50 

exit
exit

Linking backend with the container:

docker run --name z50srv \
-e TZ="Europe/Riga" \
-e DB_SERVER_HOST="10.133.112.87" \
-e DB_SERVER_PORT="7413" \
-e POSTGRES_DB="z50" \
-d zabbix/zabbix-server-pgsql:centos-5.0.8

See logs:

docker logs z50srv

P.S. In the same time, it works fine if use version 1.7.0:

docker run --name ts17 -t -e POSTGRES_PASSWORD="zabbix" -e POSTGRES_DB="dummy_db" -p 7413:5432 -d timescale/timescaledb:1.7.0-pg12 

Generated at Wed Jun 04 20:35:18 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.