Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-18987

Zabbix 5.0 with TimescaleDB 2.0

    XMLWordPrintable

Details

    • Problem report
    • Status: Closed
    • Minor
    • Resolution: Duplicate
    • 5.0.8
    • None
    • Server (S)
    • None

    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  

      Attachments

        Issue Links

          Activity

            People

              zabbix.dev Zabbix Development Team
              aigars.kadikis Aigars Kadikis
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: