Постгресс базы в заббиксе не работают, при изменении шаблона, и работающем сервере.
Любое массовое изменение приводит к дедлокам. приходится останавливать сервер, для внесения изменений.
Кто силен с английским и багзиллой - добавьте, а?
Как пример - попытался добавить график
Любое массовое изменение приводит к дедлокам. приходится останавливать сервер, для внесения изменений.
Кто силен с английским и багзиллой - добавьте, а?
Как пример - попытался добавить график
Code:
pg_query(): Query failed: ERROR: deadlock detected DETAIL: Process 5011 waits for ShareLock on transaction 73142150; blocked by process 22285. Process 22285 waits for ShareLock on transaction 73142126; blocked by process 5011. 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:511]
Error in query [INSERT INTO graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type) VALUES ('147683','59000','234931','0','0','C80000','0','2','0')] [ERROR: deadlock detected DETAIL: Process 5011 waits for ShareLock on transaction 73142150; blocked by process 22285. Process 22285 waits for ShareLock on transaction 73142126; blocked by process 5011. 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"]
Ошибка при выполнении SQL запроса "INSERT INTO graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type) VALUES ('147683','59000','234931','0','0','C80000','0','2','0')".
Code:
192.168.117.1 postgres 2013-05-16 10:24:40 MSK 40P01 INSERT ERROR: deadlock detected
192.168.117.1 postgres 2013-05-16 10:24:40 MSK 40P01 INSERT DETAIL: Process 5011 waits for ShareLock on transaction 73142150; blocked by process 22285.
Process 22285 waits for ShareLock on transaction 73142126; blocked by process 5011.
Process 5011: INSERT INTO graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type) VALUES ('147683','59000','234931','0','0','C80000','0','2','0')
Process 22285: update items set lastclock=1368685472,lastns=844073960,prevvalue=lastvalue,lastvalue='UPS-1' where itemid=25952;
update items set lastclock=1368685473,lastns=86926116,prevvalue=lastvalue,lastvalue='UPS-2' where itemid=25953;
update items set lastclock=1368685470,lastns=444997609,prevorgvalue='1022378997126983',prevvalue=lastvalue,lastvalue='1071990648' where itemid=97050;
update items set lastclock=1368685474,lastns=519274337,prevvalue=lastvalue,lastvalue='0.080000' where itemid=97849;
update items set lastclock=1368685470,lastns=439292032,prevvalue=lastvalue,lastvalue='0.060000' where itemid=97850;
update items set lastclock=1368685471,lastns=686184212,prevorgvalue='86513788548',prevvalue=lastvalue,lastvalue='163976' where itemid=98311;
update items set lastclock=1368685472,lastns=981163209,prevorgvalue='30434977139',prevvalue=lastvalue,lastvalue='157624' where itemid=98312;
update items set lastclock=1368685473,lastns=125836154,prevorgvalue='5469856169',prevvalue=lastvalue,lastvalue='576' where itemid=9831
192.168.117.1 postgres 2013-05-16 10:24:40 MSK 40P01 INSERT HINT: See server log for query details.
192.168.117.1 postgres 2013-05-16 10:24:40 MSK 40P01 INSERT CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."items" x WHERE "itemid" OPERATOR(pg_catalog.=) $1 FOR SHARE OF x"
192.168.117.1 postgres 2013-05-16 10:24:40 MSK 40P01 INSERT STATEMENT: INSERT INTO graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type) VALUES ('147683','59000','234931','0','0','C80000','0','2','0')
Comment