2018-08-03 04:06:07.822 AWST 10.1.12.112(58406) zabbix zabbix LOG: process 90981 still waiting for AccessShareLock on relation 89797 of database 16403 after 1000.144 ms 2018-08-03 04:06:07.822 AWST 10.1.12.112(58406) zabbix zabbix DETAIL: Process holding the lock: 91837. Wait queue: 91321, 90981, 90712, 91496, 91384. 2018-08-03 04:06:07.822 AWST 10.1.12.112(58406) zabbix zabbix STATEMENT: select distinct g.graphid,g.name,g.width,g.height,g.yaxismin,g.yaxismax,g.show_work_period,g.show_triggers,g.graphtype,g.show_legend,g.show_3d,g.percent_left,g.percent_right,g.ymin_type,g.ymin_itemid,g.ymax_type,g.ymax_itemid from graphs g,graphs_items gi,items i,item_discovery id where g.graphid=gi.graphid and gi.itemid=i.itemid and i.itemid=id.itemid and id.parent_itemid=23002324 2018-08-03 04:06:15.359 AWST 10.1.12.112(58406) zabbix zabbix LOG: process 90981 still waiting for RowExclusiveLock on relation 73422 of database 16403 after 1000.118 ms at character 13 2018-08-03 04:06:15.359 AWST 10.1.12.112(58406) zabbix zabbix DETAIL: Processes holding the lock: 72418, 91945. Wait queue: 90981, 90768, 91193, 90701, 91288, 91737, 90712, 91384, 91321, 91053, 91222, 90931. 2018-08-03 04:06:15.359 AWST 10.1.12.112(58406) zabbix zabbix STATEMENT: insert into history_uint (itemid,clock,ns,value) values (23766667,1533240367,356209256,1),(23772339,1533240367,356209256,1),(23766493,1533240367,356209256,1),(23770784,1533240367,356209256,1),(23773653,1533240367,356209256,1),(23765892,1533240367,356209256,1),(23767215,1533240367,356209256,1),(23771063,1533240367,356209256,1),(23768771,1533240367,356209256,1),(23770217,1533240367,356209256,1),(23768481,1533240367,356209256,1),(23771590,1533240367,356209256,1),(23768646,1533240367,356209256,1),(23768372,1533240367,356209256,1),(30691773,1533240367,356209256,1),(30811398,1533240367,356209256,1),(30854836,1533240367,356209256,1),(30857836,1533240367,356209256,1),(30860793,1533240367,356209256,1),(30921910,1533240367,356209256,1),(31014989,1533240367,356209256,1),(31017689,1533240367,356209256,1),(31023389,1533240367,356209256,1),(32821463,1533240367,356209256,1),(32681685,1533240367,356209256,1),(32821631,1533240367,356209256,1),(32828649,1533240367,356209256,1),(32821098,1533240367,356209256,1),(21819041,1533240372,107532007,10485760),(30510932,1533240372,107532007,0),(21868061,1533240372,107532007,0),(21819048,1533240372,107532007,327680),(30510939,1533240372,107532007,1000000000),(30510923,1533240372,107532007,574864),(21867950,1533240372,107532007,536744),(21819037,1533240372,107532007,94019584),(21819039,1533240372,107532007,236478464),(21819044,1533240372,107532007,616148992),(21819043,1533240372,107532007,20971520),(21819067,1533240372,107532007,1),(21868060,1533240372,107532007,2),(21819051,1533240372,107532007,0),(21819065,1533240372,107532007,240),(32865779,1533240372,487424531,10000000),(32865772,1533240372,487424531,100000000),(32865797,1533240372,487424531,57832),(32865759,1533240372,487424531,1000000000),(32865817,1533240372,487424531,0),(32865802,1533240372,487424531,55896),(32865767,1533240372,487424531,1000000000),(32865760,1533240372,487424531,1000000000),(32865695,1533240372,487424531,23008),(32865770,1533240372,487424531,1000000000),(32865682,1533240372,487424531,17640),(32865692,1533240372,487424531,904),(32865812,1533240372,487424531,26056),(32865752,1533240372,487424531,1000000000),(32865694,1533240372,487424531,69608),(32865764,1533240372,487424531,1000000000),(32865815,1533240372,487424531,0),(32865707,1533240372,487424531,16),(32865761,1533240372,487424531,1000000000),(32865798,1533240372,487424531,57856),(32865808,1533240372,487424531,1096),(32865785,1533240372,487424531,248),(32865748,1533240372,508754589,1000000000),(32865763,1533240372,508754589,1000000000),(32865805,1533240372,508754589,82864),(32865754,1533240372,508754589,10000000),(32865821,1533240372,508754589,51480),(32865674,1533240372,508754589,688),(32865685,1533240372,508754589,6144),(32865756,1533240372,508754589,1000000000),(32865709,1533240372,508754589,45280),(32865753,1533240372,508754589,2000000000),(32865769,1533240372,508754589,1000000000),(32865765,1533240372,508754589,1000000000),(32865755,1533240372,508754589,10000000),(32865777,1533240372,508754589,1000000000),(32865757,1533240372,508754589,1000000000),(32865793,1533240372,508754589,57864),(32865773,1533240372,508754589,1000000000),(32865687,1533240372,508754589,1864),(32865781,1533240372,508754589,100000000),(32865766,1533240372,508754589,1000000000),(32865771,1533240372,508754589,1000000000),(32865789,1533240372,508754589,0),(32865811,1533240372,508754589,0),(32865704,1533240372,508754589,0),(32865780,1533240372,508754589,10000000),(32865813,1533240372,508754589,0),(32865690,1533240372,508754589,1064),(32865816,1533240372,508754589,0),(32865768,1533240372,508754589,1000000000),(32865782,1533240372,508754589,1000000000),(32865799,1533240372,508754589,57496),(32865801,1533240372,508754589,56760),(32865686,1533240372,508754589,2568),(32865795,1533240372,508754589,90248),(32865698,1533240372,508754589,296),(32865749,1533240372,508754589,1000000000),(32865774,1533240372,508754589,10000000),(32865676,1533240372,508754589,0),(32865807,1533240372,508754589,89304),(32865818,1533240372,512914121,384),(30511023,1533240372,852036509,1000000000),(21868353,1533240372,852036509,0),(30511017,1533240372,852036509,647688),(21868352,1533240372,852036509,2),(21819678,1533240372,852036509,125597),(21819646,1533240372,852036509,753377280),(30511006,1533240372,852036509,0),(21819673,1533240372,852036509,280),(21819657,1533240372,852036509,0),(21868434,1533240372,852036509,0),(21868407,1533240372,852036509,85488),(21819676,1533240372,852036509,1),(21819654,1533240372,852036509,0),(21819652,1533240372,852036509,431570944),(21819674,1533240372,852036509,1),(21819662,1533240372,852036509,1323302912),(21819647,1533240372,852036509,207937536),(30511022,1533240372,852036509,0),(21819661,1533240372,852036509,31508660224),(21819667,1533240372,852036509,34),(21819649,1533240372,852036509,10485760),(30511016,1533240372,852036509,0),(21819655,1533240372,852036509,0),(21868294,1533240372,852036509,596616),(21868351,1533240372,852036509,0),(21819675,1533240372,852036509,1),(21819645,1533240372,852036509,81399808),(21868354,1533240372,852036509,3),(21819651,1533240372,852036509,20971520),(21819659,1533240372,852036509,0),(21819660,1533240372,852036509,0),(21819656,1533240372,852036509,327680),(21819653,1533240372,852036509,0),(30511007,1533240372,852036509,98208),(21819677,1533240372,852036509,1); 2018-08-03 04:06:15.541 AWST 10.1.12.112(58319) zabbix zabbix LOG: process 90712 still waiting for RowExclusiveLock on relation 73422 of database 16403 after 1000.098 ms at character 13 2018-08-03 04:06:15.541 AWST 10.1.12.112(58319) zabbix zabbix DETAIL: Processes holding the lock: 72418, 91945. Wait queue: 90981, 90768, 91193, 90701, 91288, 91737, 90712, 91384, 91321, 91053, 91222, 90931, 91247, 91842, 90893. 2018-08-03 04:06:15.541 AWST 10.1.12.112(58319) zabbix zabbix STATEMENT: insert into history_uint (itemid,clock,ns,value) values (4650973,1533240374,379807096,17026772992),(5272273,1533240374,379852253,1228405731328),(25007173,1533240374,380367848,435353022464),(30022573,1533240374,380641938,24017629184),(3831073,1533240374,380770807,23358074880),(5312173,1533240374,380835939,9902747648),(22966873,1533240374,380948884,25330446336),(4238473,1533240374,380968172,29338103808),(5616073,1533240374,381098354,1422913536),(26022673,1533240374,381266849,158330880); 2018-08-03 04:06:15.846 AWST 10.1.12.112(58420) zabbix zabbix LOG: process 91053 still waiting for RowExclusiveLock on relation 73422 of database 16403 after 1000.103 ms at character 13 2018-08-03 04:06:15.846 AWST 10.1.12.112(58420) zabbix zabbix DETAIL: Processes holding the lock: 72418, 91945. Wait queue: 90981, 90768, 91193, 90701, 91288, 91737, 90712, 91384, 91321, 91053, 91222, 90931, 91247, 91842, 90893, 90907. 2018-08-03 04:06:15.846 AWST 10.1.12.112(58420) zabbix zabbix STATEMENT: insert into history_uint (itemid,clock,ns,value) values (31654958,1533240360,750582991,1),(24875513,1533240360,750790191,1),(4833620,1533240361,792923324,2146058240),(4833621,1533240361,792928073,1836863488),(4867642,1533240361,793805838,22075670528),(4867648,1533240361,794516823,42947571712),(23038990,1533240362,706191692,2781302784),(31654633,1533240362,783793667,1),(19635778,1533240362,783977167,0),(19816267,1533240362,784102267,0),(21765663,1533240363,269215522,1),(5611263,1533240363,292235379,1),(3393963,1533240363,300346177,1),(22423563,1533240363,316254549,1),(22362963,1533240363,326997867,1),(9492963,1533240363,331390042,1),(7606263,1533240363,335238293,1),(6325863,1533240363,357156235,1),(7608063,1533240363,366304452,1),(7606863,1533240363,371068346,1),(7723263,1533240363,385771390,1),(26707263,1533240363,399951808,1),(8561763,1533240363,411393707,1),(31212753,1533240363,490995072,1),(23830563,1533240363,504836163,1),(4682763,1533240363,517459508,1),(8851263,1533240363,533633313,1),(31651181,1533240363,563295155,1),(23768696,1533240363,822371089,1),(23766740,1533240363,822371089,1),(26009969,1533240363,822371089,1),(23771419,1533240363,822371089,1),(24487993,1533240363,822371089,1),(23766973,1533240363,822371089,1),(23769440,1533240363,822371089,1),(23766438,1533240363,822371089,1),(23769014,1533240363,822371089,1),(23766833,1533240363,822371089,1),(23771295,1533240363,822371089,1),(23769060,1533240363,822371089,1),(31652993,1533240363,984418647,1),(23771878,1533240364,181621833,1),(23772023,1533240364,181621833,1),(23766934,1533240364,181621833,1),(23770033,1533240364,181621833,1),(23768043,1533240364,181621833,1),(23769472,1533240364,181621833,1),(23772374,1533240364,181621833,1),(23773085,1533240364,181621833,1),(30280702,1533240364,181621833,1),(31652056,1533240364,525632568,1),(31655032,1533240364,946558535,1),(24836545,1533240365,719964417,1),(23772669,1533240365,719964417,1),(23766224,1533240365,719964417,1),(23769319,1533240365,719964417,1),(23772499,1533240365,719964417,1),(23766818,1533240365,719964417,1),(23767273,1533240365,719964417,1),(23773511,1533240365,719964417,1),(24488097,1533240365,719964417,1),(23769482,1533240365,719964417,1),(23772141,1533240365,719964417,1),(31655565,1533240366,511349857,1),(29712915,1533240366,512080118,1),(2825454,1533240366,737600153,2146058240),(2825455,1533240366,737604623,1898299392),(26286176,1533240366,738452776,89491767296),(26286182,1533240366,739160966,107372081152),(7608066,1533240366,750076649,1),(19031766,1533240366,752030785,1),(7723566,1533240366,758680204,1),(11170866,1533240366,763885040,1),(24643566,1533240366,765737004,1),(24534066,1533240366,776390959,1),(19641642,1533240367,948183435,0),(4070768,1533240368,238117421,1),(17708468,1533240368,268903712,1),(31212939,1533240369,187681688,1),(31212879,1533240369,187877945,134268),(7607769,1533240369,209218531,1),(11370369,1533240369,539354785,1),(31212880,1533240370,188398010,202); 2018-08-03 04:06:16.388 AWST 10.1.12.112(58449) zabbix zabbix LOG: process 91247 still waiting for RowExclusiveLock on relation 73422 of database 16403 after 1000.091 ms at character 13 2018-08-03 04:06:16.388 AWST 10.1.12.112(58449) zabbix zabbix DETAIL: Processes holding the lock: 72418, 91945. Wait queue: 90981, 90768, 91193, 90701, 91288, 91737, 90712, 91384, 91321, 91053, 91222, 90931, 91247, 91842, 90893, 90907, 91496, 90671, 91099. 2018-08-03 04:06:16.388 AWST 10.1.12.112(58449) zabbix zabbix STATEMENT: insert into history_uint (itemid,clock,ns,value) values (24641431,1533240362,699003665,1),(23769340,1533240362,699003665,1),(24812334,1533240362,699003665,1),(23769044,1533240362,699003665,1),(23766427,1533240362,699003665,1),(23766969,1533240362,699003665,1),(23766737,1533240362,699003665,1),(23769648,1533240362,699003665,1),(23767551,1533240362,699003665,1),(23771916,1533240362,699003665,1),(23766146,1533240362,699003665,1),(23767480,1533240362,699003665,1),(23770905,1533240362,699003665,1),(23768580,1533240362,699003665,1),(31652147,1533240362,726553724,1),(31653334,1533240362,816978220,1),(23766924,1533240363,234428556,1),(23773686,1533240363,234428556,1),(29407531,1533240363,234428556,1),(23767020,1533240363,234428556,1),(23773596,1533240363,234428556,1),(23766940,1533240363,234428556,1),(23771057,1533240363,234428556,1),(30042750,1533240363,234428556,1),(23773392,1533240363,234428556,1),(23767278,1533240363,234428556,1),(23771741,1533240363,234428556,1),(23768945,1533240363,234428556,1),(23771508,1533240363,234428556,1),(23770113,1533240363,234428556,1),(23765782,1533240363,234428556,1),(26427841,1533240363,234428556,1),(23769422,1533240363,234428556,1),(23766588,1533240363,234428556,1),(23768975,1533240363,234428556,1),(30043460,1533240363,234428556,1),(23770278,1533240363,234428556,1),(23766988,1533240363,234428556,1),(23772443,1533240363,234428556,1),(23765730,1533240363,234428556,1),(23768141,1533240363,234428556,1),(23769855,1533240363,234428556,1),(29468617,1533240363,234428556,1),(23765819,1533240363,234428556,1),(23768047,1533240363,234428556,1),(23771882,1533240363,234428556,1),(23768937,1533240363,234428556,1),(23771748,1533240363,234428556,1),(31654398,1533240363,427522710,1),(24567365,1533240363,726402028,0),(24567272,1533240363,816782385,0),(31652622,1533240363,858332987,1),(19635828,1533240363,858502887,0),(19816319,1533240363,858610887,0),(23769829,1533240364,16341663,1),(23768416,1533240364,16341663,1),(23771596,1533240364,16341663,1),(9493864,1533240364,550276801,1),(30010264,1533240364,664359242,1),(10460615,1533240365,604078717,897),(24566181,1533240365,604265717,0),(10460619,1533240365,604354817,0),(10460620,1533240365,604435217,0),(10460621,1533240365,604519817,0),(19638033,1533240365,604598817,0),(19638034,1533240365,604676417,0),(10460623,1533240365,604754617,0),(10460624,1533240365,604834717,0),(24571030,1533240365,604914017,0),(10460625,1533240365,604997217,0),(10460629,1533240365,605088617,0),(10460631,1533240365,605172917,0),(10460632,1533240365,605254417,0),(10460633,1533240365,605336017,0),(30255043,1533240365,605354017,2),(31651542,1533240366,656679677,1),(26010288,1533240366,690114492,1),(23770387,1533240366,690114492,1),(23769779,1533240366,690114492,1),(23768201,1533240366,690114492,1),(23766769,1533240366,690114492,1),(23767266,1533240366,690114492,1),(23767952,1533240366,690114492,1),(23768931,1533240366,690114492,1),(30280804,1533240366,690114492,1),(23768159,1533240366,690114492,1),(23766854,1533240367,224091981,1),(29387916,1533240367,224091981,1),(23768174,1533240367,224091981,1),(23766700,1533240367,224091981,1),(23768216,1533240367,224091981,1),(23772322,1533240367,224091981,1),(23773408,1533240367,224091981,1),(24488404,1533240367,224091981,1),(31212637,1533240367,738097243,1),(31212697,1533240367,738240824,1073741424),(32074867,1533240367,743692922,1),(8579467,1533240367,747125468,1),(17049967,1533240367,747716201,1),(31655530,1533240368,527301034,1),(24875750,1533240369,826976983,1),(31654722,1533240369,827621143,1),(31653388,1533240370,160798484,1),(19642290,1533240370,160988284,0),(10640470,1533240370,384335854,1),(31212911,1533240371,191319718,6),(5608271,1533240371,211941188,1),(22899671,1533240371,219684972,1),(5179571,1533240371,279360390,1),(29387470,1533240371,451199226,1),(3449472,1533240372,252077105,1),(7606872,1533240372,259296840,1),(5178671,1533240372,442837923,1),(31212883,1533240373,283598534,1),(8292673,1533240373,314308568,1); 2018-08-03 04:06:42.830 AWST 10.1.12.119(41356) zabbix zabbix LOG: process 91853 still waiting for AccessShareLock on relation 91501 of database 16403 after 1000.083 ms 2018-08-03 04:06:42.830 AWST 10.1.12.119(41356) zabbix zabbix DETAIL: Process holding the lock: 72418. Wait queue: 91945, 91853. 2018-08-03 04:06:42.830 AWST 10.1.12.119(41356) zabbix zabbix STATEMENT: SELECT itemid,COUNT(*) AS count,AVG(value) AS avg,MIN(value) AS min,MAX(value) AS max,round(1542* MOD(CAST(clock AS BIGINT)+3199,3600)/(3600),0) AS i,MAX(clock) AS clock FROM history_uint WHERE itemid='23767052' AND clock>='1533236801' AND clock<='1533240401' GROUP BY itemid,round(1542* MOD(CAST(clock AS BIGINT)+3199,3600)/(3600),0) 2018-08-03 04:06:43.909 AWST 10.1.12.119(41302) zabbix zabbix LOG: process 90902 still waiting for AccessShareLock on relation 91501 of database 16403 after 1000.094 ms 2018-08-03 04:06:43.909 AWST 10.1.12.119(41302) zabbix zabbix DETAIL: Process holding the lock: 72418. Wait queue: 91945, 91853, 90902. 2018-08-03 04:06:43.909 AWST 10.1.12.119(41302) zabbix zabbix STATEMENT: SELECT * FROM history_uint h WHERE h.itemid='30387143' AND h.clock>1533154002 ORDER BY h.clock DESC LIMIT 1