Details
-
Problem report
-
Status: READY TO DEVELOP
-
Trivial
-
Resolution: Unresolved
-
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)
-
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
-