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

TimescaleDB 2.13.x and PostgreSQL 16.x incompatibility

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Duplicate
    • Icon: Trivial Trivial
    • None
    • 6.4.9, 6.4.10
    • Frontend (F)
    • None

      Steps to reproduce:

      1. Have zabbix, with lot of data and timescaledb compression
      2. Upgrade to postgresql 16 (any minor version)
      3. Upgrade timescaledb to 2.13.0
      4. Go to dashboard, postgresql error log

      Result:

       

      Related timescaledb bugs and commits (check latest comments):

      https://github.com/timescale/timescaledb/pull/6377
      https://github.com/timescale/timescaledb/issues/4774

      note that enable_presorted_aggregate=off doesn't affect and solve this issue, optimizer still there.
      related postgresql commit:
      https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=1349d2790bf48a4de072931c722f39337e72055e

       

      i.e. looks like this combination (postgresql 16+timescaledb 2.13.0, specifically) is not fully compatible yet, should wait for next timescaledb release

            zabbix.support Zabbix Support Team
            giomac George Machitidze
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: