Housekeeper cannot drop chunks

XMLWordPrintable

    • Type: Problem report
    • Resolution: Unresolved
    • Priority: Trivial
    • None
    • Affects Version/s: 6.4.6
    • Component/s: 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

            Assignee:
            Zabbix Support Team
            Reporter:
            Evgeny Semerikov
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated: