Details
-
Documentation task
-
Status: Closed
-
Trivial
-
Resolution: Fixed
-
None
-
None
-
Ubuntu 20.04.3 LTS
Zabbix 5.4.10-1+ubuntu20.04
Postgresql 12.10-1.pgdg20.04+1 upgraded to 13.6-1.pgdg20.04+1
TimescaleDB 1.7.5~ubuntu20.04 upgraded to 2.6.0~ubuntu20.04
Number of hosts (enabled/disabled) 3841 3841 / 0
Number of items (enabled/disabled/not supported) 11656 11650 / 0 / 6
Number of triggers (enabled/disabled [problem/ok]) 11594 11579 / 15 [10 / 11569]
All hosts only have "ICMP Ping" templateUbuntu 20.04.3 LTS Zabbix 5.4.10-1+ubuntu20.04 Postgresql 12.10-1.pgdg20.04+1 upgraded to 13.6-1.pgdg20.04+1 TimescaleDB 1.7.5~ubuntu20.04 upgraded to 2.6.0~ubuntu20.04 Number of hosts (enabled/disabled) 3841 3841 / 0 Number of items (enabled/disabled/not supported) 11656 11650 / 0 / 6 Number of triggers (enabled/disabled [problem/ok]) 11594 11579 / 15 [10 / 11569] All hosts only have "ICMP Ping" template
-
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
Description
Steps to reproduce:
- Install Zabbix 5.4 on PostgreSQL 12 with TimescaleDB 1.7.5
- Upgrade TimescaleDB to 2.x (2.6.0)
- 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')
- Open Monitoring -> Hosts
- Wait for an eternity as the query will take 100% CPU usage on PostgreSQL without result.
Result:
- 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
Attachments
Issue Links
- is duplicated by
-
ZBX-19039 SQL Query too slow
-
- Closed
-