Executing housekeeper produces errors in the log for a previously deleted host on TimescaleDB, when overrides are disabled

XMLWordPrintable

    • Type: Problem report
    • Resolution: Unresolved
    • Priority: Trivial
    • None
    • Affects Version/s: 6.0.43rc1, 7.4.6rc1, 8.0.0alpha2 (master)
    • Component/s: Server (S)

      Description
      In case, when host was deleted and housekeeper was not executed before migration to TimescaleDB, the execution of housekeeper with incorrect configuration (disabled overrides) will produces many errors in the log for already deleted items.
      Note: if housekeeper was executed before migration, or it was done on TimescaleDB with correct configuration - no errors are present in the log.
      This behavior was tested and reproduced using Postgresql 17.5, 17.6 and TimescaleDB verions: 2.20.1 and 2.23.1 (Timescale license), but probably is present on other versions too.

      Steps to reproduce:
      Precondition: Zabbix installed on PostgreSQL, default host Zabbix sever exists.

      1. Open Frontend, start the server
      2. Open Data collection -> Hosts
      3. Create new host, gather some data (include data that would be compressed)
      4. Delete the default "Zabbix server" host
      5. Do not execute housekeeper
      6. Stop the server
      7. Install TimescaleDB extension (Timescale license), execute installation script
      8. Start the server
      9. Open Administration -> Housekeeper
      10. Uncheck the Override item history period, Override item trend period
      11. Save the configs, restart the server, or execute config_cache_reload
      12. Execute the housekeeper
      13. See the server's logs

      Result:
      The logs contains many PGRES_FATAL_ERRORs related to every item of deleted host ("Zabbix sever")

      See example:

       7653:20251203:083513.426 forced execution of the housekeeper
  7653:20251203:083513.426 executing housekeeper
  7653:20251203:083513.580 Unable to perform housekeeping for history tables due to having compressed chunks and disabled item history period override.
  7653:20251203:083513.660 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  transparent decompression only supports tableoid system column
 [delete from history where itemid=42255 and ctid = any(array(select ctid from history where itemid=42255 limit 5000))]
  7653:20251203:083513.666 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  transparent decompression only supports tableoid system column
 [delete from history where itemid=33025 and ctid = any(array(select ctid from history where itemid=33025 limit 5000))]
  7653:20251203:083513.669 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  transparent decompression only supports tableoid system column
 [delete from history where itemid=42250 and ctid = any(array(select ctid from history where itemid=42250 limit 5000))]
  7653:20251203:083513.672 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  transparent decompression only supports tableoid system column
 [delete from history where itemid=51791 and ctid = any(array(select ctid from history where itemid=51791 limit 5000))]
  7653:20251203:083513.673 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  transparent decompression only supports tableoid system column
 [delete from history where itemid=23270 and ctid = any(array(select ctid from history where itemid=23270 limit 5000))]
  7653:20251203:083513.675 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  transparent decompression only supports tableoid system column
 [delete from history where itemid=10073 and ctid = any(array(select ctid from history where itemid=10073 limit 5000))]
  7653:20251203:083513.679 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  transparent decompression only supports tableoid system column
 [delete from history where itemid=42270 and ctid = any(array(select ctid from history where itemid=42270 limit 5000))]
  7653:20251203:083513.681 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  transparent decompression only supports tableoid system column
 [delete from history where itemid=44056 and ctid = any(array(select ctid from history where itemid=44056 limit 5000))]
  7653:20251203:083513.683 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  transparent decompression only supports tableoid system column
 [delete from history where itemid=23662 and ctid = any(array(select ctid from history where itemid=23662 limit 5000))] 
.....................

      Expected
      There should be no errors in the log.

            Assignee:
            Zabbix Development Team
            Reporter:
            Nikita Gogolevs
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - Not Specified
                Not Specified
                Logged:
                Time Spent - 0.5h
                0.5h