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

TSDB upgrade doesn't work

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Fixed
    • Icon: Trivial Trivial
    • 7.0.0alpha8, 7.0 (plan)
    • 7.0.0alpha1
    • Server (S)
    • None
    • Sprint 106 (Nov 2023), Sprint 107 (Dec 2023), S2401
    • 1

      Upgrade patch for TimescaleDB starting from 6050008 fails

      [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']
 19717:20230725:093511.711 database upgrade failed on patch 06050008, exiting in 10 seconds

       

        1. image-2023-12-12-12-53-42-648.png
          image-2023-12-12-12-53-42-648.png
          36 kB
        2. image-2023-12-12-12-55-43-972.png
          image-2023-12-12-12-55-43-972.png
          147 kB
        3. image-2023-12-12-12-56-26-152.png
          image-2023-12-12-12-56-26-152.png
          50 kB
        4. image-2023-12-12-14-16-58-671.png
          image-2023-12-12-14-16-58-671.png
          158 kB

            vso Vladislavs Sokurenko
            ak Andrejs Kozlovs
            Team A
            Votes:
            3 Vote for this issue
            Watchers:
            13 Start watching this issue

              Created:
              Updated:
              Resolved: