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

Hosts overview after PostgreSQL 12 - 13 upgrade

XMLWordPrintable

    • Icon: Documentation task Documentation task
    • Resolution: Fixed
    • Icon: Trivial Trivial
    • None
    • Documentation (D)
    • None
    • Team B
    • Sprint 85 (Feb 2022), Sprint 86 (Mar 2022), Sprint 87 (Apr 2022), Sprint 88 (May 2022), Sprint 89 (Jun 2022), Sprint 90 (Jul 2022), Sprint 91 (Aug 2022), Sprint 92 (Sep 2022), Sprint 93 (Oct 2022), Sprint 94 (Nov 2022), Sprint 95 (Dec 2022), Sprint 96 (Jan 2023), Sprint 97 (Feb 2023), Sprint 98 (Mar 2023), Sprint 99 (Apr 2023), Sprint 100 (May 2023), Sprint 101 (Jun 2023)
    • 1

      Steps to reproduce:

      1. Install Zabbix 5.4 on PostgreSQL 12 with TimescaleDB 1.7.5
      2. Upgrade TimescaleDB to 2.x (2.6.0)
      3. Upgrade PostgreSQL 12 to 13 (/usr/lib/postgresql/13/bin/pg_upgrade -b /usr/lib/postgresql/12/bin -B /usr/lib/postgresql/13/bin -d /var/lib/postgresql/12/main -D /var/lib/postgresql/13/main -o ' -c config_file=/etc/postgresql/12/main/postgresql.conf' -O ' -c config_file=/etc/postgresql/13/main/postgresql.conf')
      4. Open Monitoring -> Hosts
      5. Wait for an eternity as the query will take 100% CPU usage on PostgreSQL without result.

      Result:

      1. Query stuck: 
        SELECT DISTINCT t.triggerid FROM triggers t,functions f,items i WHERE i.hostid IN (16018,16138,16169,16181,16197,16199,16200,16213,16219,16223,16229,16233,16242,16271,16284,16291,16292,16305,16308,16310,16312,16319,16320,16328,16331,16332,16334,16340,16345,16370,16376,16384,16392,16402,16416,16423,16431,16458,16460,16470,16474,16475,16486,16489,16490,16491,16492,16493,16494,16496) AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND NOT EXISTS (SELECT NULL FROM functions f,items i,hosts h WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=h.hostid AND (i.status<>0 OR h.status<>0)) AND t.status=0 AND t.flags IN (0,4)

       

      Expected:
      See hosts overview

            Miks.Kronkalns Miks Kronkalns
            Homeserv Robbert Vercammen
            Team B
            Votes:
            1 Vote for this issue
            Watchers:
            11 Start watching this issue

              Created:
              Updated:
              Resolved: