timescaledb scheme.sql references config table, but config table has been replaced by settings table

XMLWordPrintable

    • Type: Problem report
    • Resolution: Unresolved
    • Priority: Trivial
    • None
    • Affects Version/s: 7.4.6
    • Component/s: None
    • None

      upgraded from 7.2.4 to 7.4.6

      noticed in log:

       1677:20260130:142308.819 Table "history_bin" is not a hypertable. Execute TimescaleDB configuration step as described in Zabbix documentation to upgrade schema.
        1677:20260130:142308.851 Unexpected TimescaleDB configuration: the auditlog table does not have compress_created_before compression policy

      attempted to "3. Run the postgresql/timescaledb/schema.sql script;"

      but:

      psql:schema.sql:112: NOTICE:  TimescaleDB version 2.18.2 is valid
      psql:schema.sql:112: ERROR:  relation "config" does not exist
      LINE 1: SELECT db_extension FROM config
                                       ^
      QUERY:  SELECT db_extension FROM config
      CONTEXT:  PL/pgSQL function inline_code_block line 62 at SQL statement
      **

       

      zabbix 7.4.0 upgrade notes state:

      "The settings table now replaces the config table "...

       

            Assignee:
            Zabbix Support Team
            Reporter:
            Dave E Martin
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: