При большом числе устройств обновление триггера невозможно без остановки заббикс-сервера.
....
Обновлено: Триггер "Firmware" в "142.131-1228".
Обновлено: Триггер "Firmware" в "135.22-1228".
pg_query(): Query failed: ERROR: deadlock detected DETAIL: Process 25505 waits for ShareLock on transaction 206525113; blocked by process 10143. Process 10143 waits for ShareLock on transaction 206525048; blocked by process 25505. HINT: See server log for query details. CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."items" x WHERE "itemid" OPERATOR(pg_catalog.=) $1 FOR SHARE OF x" [include/db.inc.php:508]
Error in query [INSERT INTO functions (functionid,itemid,triggerid,function,parameter) VALUES (123981,159836,72567,'str','"Build 1.20.B07"')] [ERROR: deadlock detected DETAIL: Process 25505 waits for ShareLock on transaction 206525113; blocked by process 10143. Process 10143 waits for ShareLock on transaction 206525048; blocked by process 25505. HINT: See server log for query details. CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."items" x WHERE "itemid" OPERATOR(pg_catalog.=) $1 FOR SHARE OF x"]
Не удалось раскрыть выражение "({128.68-1228:Firmware.str("Build 1.20.B07")}#1 & {128.68-1228:Hardware.str("B1")}#1) | ( {128.68-1228:Firmware.str("Build 2.40.B003")}#1 & {128.68-1228:Hardware.str("B1")}=1)".
....
....
Обновлено: Триггер "Firmware" в "142.131-1228".
Обновлено: Триггер "Firmware" в "135.22-1228".
pg_query(): Query failed: ERROR: deadlock detected DETAIL: Process 25505 waits for ShareLock on transaction 206525113; blocked by process 10143. Process 10143 waits for ShareLock on transaction 206525048; blocked by process 25505. HINT: See server log for query details. CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."items" x WHERE "itemid" OPERATOR(pg_catalog.=) $1 FOR SHARE OF x" [include/db.inc.php:508]
Error in query [INSERT INTO functions (functionid,itemid,triggerid,function,parameter) VALUES (123981,159836,72567,'str','"Build 1.20.B07"')] [ERROR: deadlock detected DETAIL: Process 25505 waits for ShareLock on transaction 206525113; blocked by process 10143. Process 10143 waits for ShareLock on transaction 206525048; blocked by process 25505. HINT: See server log for query details. CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."items" x WHERE "itemid" OPERATOR(pg_catalog.=) $1 FOR SHARE OF x"]
Не удалось раскрыть выражение "({128.68-1228:Firmware.str("Build 1.20.B07")}#1 & {128.68-1228:Hardware.str("B1")}#1) | ( {128.68-1228:Firmware.str("Build 2.40.B003")}#1 & {128.68-1228:Hardware.str("B1")}=1)".
....
Comment