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

Housekeeper cannot drop chunks

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Unresolved
    • Icon: Trivial Trivial
    • None
    • 6.4.6
    • Server (S)
    • None

      Hello, I'm faced with this error after updating to 6.4.6:

      928052:20230905:203405.400 forced execution of the housekeeper
      928052:20230905:203405.400 executing housekeeper
      928052:20230905:203405.449 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  function drop_chunks(relation => unknown, older_than => integer) does not exist
      LINE 1: select drop_chunks(relation=>'history',older_than=>169272564...
                     ^
      HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
       [select drop_chunks(relation=>'history',older_than=>1692725645)]
      928052:20230905:203405.449 cannot drop chunks for history
      928052:20230905:203405.449 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  function drop_chunks(relation => unknown, older_than => integer) does not exist
      LINE 1: select drop_chunks(relation=>'history_str',older_than=>16927...
                     ^
      HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
       [select drop_chunks(relation=>'history_str',older_than=>1692725645)]
      928052:20230905:203405.449 cannot drop chunks for history_str
      928052:20230905:203405.449 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  function drop_chunks(relation => unknown, older_than => integer) does not exist
      LINE 1: select drop_chunks(relation=>'history_log',older_than=>16927...
                     ^
      HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
       [select drop_chunks(relation=>'history_log',older_than=>1692725645)]
      928052:20230905:203405.449 cannot drop chunks for history_log
      928052:20230905:203405.450 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  function drop_chunks(relation => unknown, older_than => integer) does not exist
      LINE 1: select drop_chunks(relation=>'history_uint',older_than=>1692...
                     ^
      HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
       [select drop_chunks(relation=>'history_uint',older_than=>1692725645)]
      928052:20230905:203405.450 cannot drop chunks for history_uint
      928052:20230905:203405.450 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  function drop_chunks(relation => unknown, older_than => integer) does not exist
      LINE 1: select drop_chunks(relation=>'history_text',older_than=>1692...
                     ^
      HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
       [select drop_chunks(relation=>'history_text',older_than=>1692725645)]
      928052:20230905:203405.450 cannot drop chunks for history_text
      928052:20230905:203405.450 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  function drop_chunks(relation => unknown, older_than => integer) does not exist
      LINE 1: select drop_chunks(relation=>'trends',older_than=>1691516045...
                     ^
      HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
       [select drop_chunks(relation=>'trends',older_than=>1691516045)]
      928052:20230905:203405.450 cannot drop chunks for trends
      928052:20230905:203405.450 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  function drop_chunks(relation => unknown, older_than => integer) does not exist
      LINE 1: select drop_chunks(relation=>'trends_uint',older_than=>16915...
                     ^
      HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
       [select drop_chunks(relation=>'trends_uint',older_than=>1691516045)]
      928052:20230905:203405.450 cannot drop chunks for trends_uint
      928052:20230905:203406.717 housekeeper [deleted 0 hist/trends, 0 items/triggers, 0 events, 58 problems, 0 sessions, 0 alarms, 0 audit, 0 records in 1.292279 sec, idle for 1 hour(s)]
      

      Btw, in 6.4.3 I'm see only message about deleted 0 hist/trends.

      DB is PostgreSQL 14.5 with TimescaleDB 2.8.1

            zabbix.support Zabbix Support Team
            Evgeny.Semerikov@x5.ru Evgeny Semerikov
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated: