-
Problem report
-
Resolution: Unresolved
-
Trivial
-
None
-
6.4.6
-
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