Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-23482

Upgrade to 7.0.0alpha5 fails on database upgrade on patch 06050008

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Duplicate
    • Icon: Trivial Trivial
    • None
    • 7.0.0alpha5
    • Server (S)
    • Ubuntu 20.04 (focal), Postgresql 14, timescaleDB 2.11.1

      Upgrading from 6.4.1 to 7.0.0alpha5 fails during the database upgrade with:

       44973:20230928:184943.699 starting automatic database upgrade
       44973:20230928:184943.700 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  operation not supported on hypertables that have compression enabled
       [alter table history alter value type double precision;
      alter table history alter value set default '0.0000']
       44973:20230928:184943.700 database upgrade failed on patch 06050008

      The 'value' field in the history table is already 'double precision' so wasn't expecting this DB patch to be applied:

      zabbix=# \d history
                                Table "public.history"
       Column |       Type       | Collation | Nullable |        Default
      --------+------------------+-----------+----------+-----------------------
       itemid | bigint           |           | not null |
       clock  | integer          |           | not null | 0
       value  | double precision |           | not null | '0'::double precision
       ns     | integer          |           | not null | 0

            zabbix.support Zabbix Support Team
            Adrian Cunnelly Adrian Cunnelly
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: