ExportXMLWordPrintable

    • Type: Problem report
    • Resolution: Unresolved
    • Priority: Trivial
    • None
    • Affects Version/s: 7.0.31, 7.4.6, 7.4.15, 8.0.0rc1
    • Component/s: Documentation (D)
    • None
    • Support backlog
    • 0.1
    • 1

      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:
            Artjoms Rimdjonoks
            Reporter:
            Dave E Martin
            Team Doc
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:

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