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

Zabbix problem with TimeScaleDB (drop_chunks)

XMLWordPrintable

       

      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                                                                              

       .

            Kalimulin Alex Kalimulin
            SuNova SuNova
            Team A
            Votes:
            0 Vote for this issue
            Watchers:
            11 Start watching this issue

              Created:
              Updated:
              Resolved: