Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-6754

Deadlock when using "Unlink and clear" on Templates

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Duplicate
    • Icon: Minor Minor
    • None
    • 2.0.6
    • Templates (T)
    • None
    • FreeBSD 9.1 with MySQL

      When going to a servers Templates and clicking "Unlink and clear" link, the server displays a deadlock issue in the logfile.

      I have 14182 monitored items.

      zabbix_server.log
      25516:20130628:082915.967 [Z3005] query failed: [1213] Deadlock found when trying to get lock; try restarting transaction [update items set lastclock=1372400953,lastns=624734330,prevvalue=lastvalue,lastvalue='0.000000' where itemid=23472;
      update items set lastclock=1372400954,lastns=786675517,prevvalue=lastvalue,lastvalue='0.009699' where itemid=23473;
      update items set lastclock=1372400953,lastns=215469153,prevorgvalue='1365067156',prevvalue=lastvalue,lastvalue='422184' where itemid=23532;
      update items set lastclock=1372400953,lastns=534143840,prevorgvalue='3588920922',prevvalue=lastvalue,lastvalue='270536' where itemid=23533;
      update items set lastclock=1372400955,lastns=138420473,prevorgvalue='0',prevvalue=lastvalue,lastvalue='0' where itemid=23534;
      update items set lastclock=1372400955,lastns=238355375,prevvalue=lastvalue,lastvalue='0' where itemid=23594;
      update items set lastclock=1372400952,lastns=843816112,prevorgvalue='5860256766',prevvalue=lastvalue,lastvalue='1403' where itemid=23652;
      update items set lastclock=1372400953,lastns=771581667,prevvalue=lastvalue,lastvalue='0.081250' where itemid=23653;
      update items set lastclock=1372400954,lastns=338131311,prevvalue=lastvalue,lastvalue='0.107500' where itemid=23654;
      update items set lastclock=1372400953,lastns=173713208,prevvalue=lastvalue,lastvalue='87.999036' where itemid=24552;
      update items set lastclock=1372400953,lastns=972598715,prevvalue=lastvalue,lastvalue='51.474601' where itemid=24553;
      update items set lastclock=1372400953,lastns=710894989,prevorgvalue='2295412146',prevvalue=lastvalue,lastvalue='97048' where itemid=24853;
      update items set lastclock=1372400954,lastns=486374452,prevorgvalue='0',prevvalue=lastvalue,lastvalue='0' where itemid=24854;
      update items set lastclock=1372400953,lastns=494039003,prevvalue=lastvalue,lastvalue='0.114891' where itemid=24912;
      update items set lastclock=1372400954,lastns=633103694,prevvalue=lastvalue,lastvalue='383.088757' where itemid=24913;
      update items set lastclock=1372400952,lastns=752040152,prevorgvalue='0',prevvalue=lastvalue,lastvalue='0' where itemid=24972;
      update items set lastclock=1372400953,lastns=782999563,prevorgvalue='3620080243',prevvalue=lastvalue,lastvalue='8160' where itemid=24973;
      update items set lastclock=1372400955,lastns=25372280,prevorgvalue='3620084292',prevvalue=lastvalue,lastvalue='8608' where itemid=24974;
      update items set lastclock=1372400952,lastns=923508697,prevvalue=lastvalue,lastvalue='0.000000' where itemid=25032;
      update items set lastclock=1372400953,lastns=494173480,prevvalue=lastvalue,lastvalue='0.000000' where itemid=25033;
      update items set lastclock=1372400955,lastns=77336590,prevvalue=lastvalue,lastvalue='0.000000' where itemid=25034;
      update items set lastclock=1372400954,lastns=123553341,prevorgvalue='43449368095',prevvalue=lastvalue,lastvalue='1776' where itemid=25153;
      update items set lastclock=1372400954,lastns=667683168,prevvalue=lastvalue,lastvalue='66.986677' where itemid=25154;
      update items set lastclock=1372400955,lastns=410517470,prevvalue=lastvalue,lastvalue='99.788748' where itemid=25155;
      update items set lastclock=1372400952,lastns=797857736,prevvalue=lastvalue,lastvalue='0.000000' where itemid=25452;
      update items set lastclock=1372400953,lastns=738513788,prevvalue=lastvalue,lastvalue='0.000000' where itemid=25453;
      update items set lastclock=1372400954,lastns=909167188,prevorgvalue='3142476480',prevvalue=lastvalue,lastvalue='371' where itemid=25454;
      update items set lastclock=1372400955,lastns=520321045,prevvalue=lastvalue,lastvalue='1' where itemid=25695;
      update items set lastclock=1372400952,lastns=749289587,prevvalue=lastvalue,lastvalue='0.000000' where itemid=25751;
      update items set lastclock=1372400953,lastns=560457539,prevvalue=lastvalue,lastvalue='0.000000' where itemid=25752;
      update items set lastclock=1372400953,lastns=785841601,prevvalue=lastvalue,lastvalue='635' where itemid=25753;
      update items set lastclock=1372400954,lastns=361998385,prevvalue=lastvalue,lastvalue='43' where itemid=25754;
      update items set lastclock=1372400955,lastns=411382531,prevvalue=lastvalue,lastvalue='1.002222' where itemid=25755;
      update items set lastclock=1372400952,lastns=707379795,prevvalue=lastvalue,lastvalue='43016617984' where itemid=25812;
      update items set lastclock=1372400953,lastns=687571373,prevvalue=lastvalue,lastvalue='104664125440' where itemid=25813;
      update items set lastclock=1372400954,lastns=622849849,prevorgvalue='0',prevvalue=lastvalue,lastvalue='0' where itemid=25814;
      update items set lastclock=1372400955,lastns=462236716,prevorgvalue='0',prevvalue=lastvalue,lastvalue='0' where itemid=25815;
      update items set lastclock=1372400952,lastns=835989608,prevorgvalue='0',prevvalue=lastvalue,lastvalue='0' where itemid=25872;
      update items set lastclock=1372400953,lastns=706917143,prevorgvalue='0',prevvalue=lastvalue,lastvalue='0' where itemid=25873;
      update items set lastclock=1372400954,lastns=792241070,prevorgvalue='0',prevvalue=lastvalue,lastvalue='0' where itemid=25874;
      update items set lastclock=1372400952,lastns=623420527,prevvalue=lastvalue,lastvalue='424462' where itemid=25992;
      update items set lastclock=1372400953,lastns=310202684,prevorgvalue='0',prevvalue=lastvalue,lastvalue='0' where itemid=26892;
      update items set lastclock=1372400953,lastns=932367505,prevorgvalue='654978220',prevvalue=lastvalue,lastvalue='1072' where itemid=26893;
      update items set lastclock=1372400955,lastns=159404295,prevorgvalue='864400651',prevvalue=lastvalue,lastvalue='782496' where itemid=26894;
      update items set lastclock=1372400952,lastns=816815433,prevvalue=lastvalue,lastvalue='0.000000' where itemid=28512;
      update items set lastclock=1372400954,lastns=410246552,prevvalue=lastvalue,lastvalue='0.000000' where itemid=28513;
      update items set lastclock=1372400955,lastns=403518482,prevvalue=lastvalue,lastvalue='0.000000' where itemid=28514;
      update items set lastclock=1372400953,lastns=763657206,prevvalue=lastvalue,lastvalue='0.000000' where itemid=28543;
      update items set lastclock=1372400954,lastns=803227973,prevvalue=lastvalue,lastvalue='0.000000' where itemid=28544;
      update items set lastclock=1372400954,lastns=424865975,prevvalue=lastvalue,lastvalue='99.441177' where itemid=28574;
      update items set lastclock=1372400955,lastns=383662873,prevvalue=lastvalue,lastvalue='81.651988' where itemid=28575;
      update items set lastclock=1372400953,lastns=17621975,prevvalue=lastvalue,lastvalue='0.000000' where itemid=28632;
      update items set lastclock=1372400953,lastns=687800480,prevorgvalue='848759114',prevvalue=lastvalue,lastvalue='483' where itemid=28633;
      update items set lastclock=1372400955,lastns=83008805,prevvalue=lastvalue,lastvalue='99.904364' where itemid=28634;
      update items set lastclock=1372400953,lastns=415604672,prevvalue=lastvalue,lastvalue='0.226903' where itemid=28693;
      update items set lastclock=1372400954,lastns=572121865,prevvalue=lastvalue,lastvalue='1.073485' where itemid=28694;
      update items set lastclock=1372400953,lastns=124207640,prevvalue=lastvalue,lastvalue='1' where itemid=28752;
      update items set lastclock=1372400953,lastns=647087420,prevvalue=lastvalue,lastvalue='1' where itemid=28753;
      update items set lastclock=1372400955,lastns=188072976,prevvalue=lastvalue,lastvalue='0.000000' where itemid=28754;
      update items set lastclock=1372400953,lastns=363513905,prevvalue=lastvalue,lastvalue='7' where itemid=28782;
      update items set lastclock=1372400954,lastns=318426563,prevvalue=lastvalue,lastvalue='7' where itemid=28783;
      update items set lastclock=1372400955,lastns=39133555,prevvalue=lastvalue,lastvalue='5' where itemid=28784;
      update items set lastclock=1372400955,lastns=458283701,prevvalue=lastvalue,lastvalue='5' where itemid=28785;
      update items set lastclock=1372400954,lastns=154889306,prevorgvalue='1422693946653',prevvalue=lastvalue,lastvalue='113536' where itemid=28873;
      update items set lastclock=1372400955,lastns=319546500,prevorgvalue='0',prevvalue=lastvalue,lastvalue='0' where itemid=28874;
      update items set lastclock=1372400952,lastns=853402943,prevvalue=lastvalue,lastvalue='16718845952' where itemid=28992;
      update items set lastclock=1372400953,lastns=742249300,prevvalue=lastvalue,lastvalue='9296404480' where itemid=28993;
      update items set lastclock=1372400954,lastns=632211328,prevvalue=lastvalue,lastvalue='8679745536' where itemid=28994;
      update items set lastclock=1372400954,lastns=976928455,prevvalue=lastvalue,lastvalue='1372401001' where itemid=29054;
      update items set lastclock=1372400953,lastns=308537327,prevvalue=lastvalue,lastvalue='68726784' where itemid=29082;
      update items set lastclock=1372400953,lastns=448596950,prevvalue=lastvalue,lastvalue='71237632' where itemid=29083;
      update items set lastclock=1372400955,lastns=98585785,prevvalue=lastvalue,lastvalue='93429760' where itemid=29084;
      update items set lastclock=1372400953,lastns=384518548,prevvalue=lastvalue,lastvalue='0.000000' where itemid=29113;
      update items set lastclock=1372400954,lastns=437222571,prevvalue=lastvalue,lastvalue='303497216.000000' where itemid=29114;
      update items set lastclock=1372400953,lastns=177244444,prevvalue=lastvalue,lastvalue='0.000000' where itemid=29142;
      update items set lastclock=1372400953,lastns=367656008,prevvalue=lastvalue,lastvalue='0.000000' where itemid=29143;
      update items set lastclock=1372400955,lastns=132566935,prevvalue=lastvalue,lastvalue='0.000000' where itemid=29144;
      update items set lastclock=1372400952,lastns=643119728,prevvalue=lastvalue,lastvalue='7' where itemid=29172;
      update items set lastclock=1372400954,lastns=94731665,prevvalue=lastvalue,lastvalue='24' where itemid=29173;
      update items set lastclock=1372400953,lastns=60053210,prevvalue=lastvalue,lastvalue='1372160.000000' where itemid=29292;
      update items set lastclock=1372400954,lastns=169534328,prevvalue=lastvalue,lastvalue='9' where itemid=29293;
      update items set lastclock=1372400955,lastns=113327142,prevvalue=lastvalue,lastvalue='0.000000' where itemid=29294;
      update items set lastclock=1372400953,lastns=62270813,prevvalue=lastvalue,lastvalue='4' where itemid=29322;
      update items set lastclock=1372400953,lastns=858264024,prevvalue=lastvalue,lastvalue='5' where itemid=29323;
      update items set lastclock=1372400954,lastns=795615473,prevvalue=lastvalue,lastvalue='6' where itemid=29324;
      update items set lastclock=1372400953,lastns=286662675,prevvalue=lastvalue,lastvalue='1144285184' where itemid=29352;
      update items set lastclock=1372400953,lastns=455693810,prevvalue=lastvalue,lastvalue='764223488' where itemid=29353;
      update items set lastclock=1372400954,lastns=470699429,prevvalue=lastvalue,lastvalue='67.814338' where itemid=29354;
      update items set lastclock=1372400954,lastns=961922494,prevorgvalue='1300736537',prevvalue=lastvalue,lastvalue='166' where itemid=29414;
      update items set lastclock=1372400955,lastns=327907246,prevvalue=lastvalue,lastvalue='0.019287' where itemid=29415;
      update items set lastclock=1372400953,lastns=772744183,prevvalue=lastvalue,lastvalue='482230272' where itemid=29473;
      update items set lastclock=1372400955,lastns=318697055,prevvalue=lastvalue,lastvalue='664113152' where itemid=29474;
      update items set lastclock=1372400954,lastns=109334023,prevorgvalue='0',prevvalue=lastvalue,lastvalue='0' where itemid=30733;
      update items set lastclock=1372400954,lastns=476341523,prevorgvalue='589386172143',prevvalue=lastvalue,lastvalue='20104' where itemid=30734;
      update items set lastclock=1372400952,lastns=758474948,prevvalue=lastvalue,lastvalue='0.016866' where itemid=30852;
      update items set lastclock=1372400953,lastns=977347589,prevvalue=lastvalue,lastvalue='0.012838' where itemid=30853;
      update items set lastclock=1372400954,lastns=982530871,prevvalue=lastvalue,lastvalue='0.016642' where itemid=30854;
      update items set lastclock=1372400954,lastns=737274988,prevvalue=lastvalue,lastvalue='0.000000' where itemid=30884;
      update items set lastclock=1372400953,lastns=22425204,prevvalue=lastvalue,lastvalue='13809385472' where itemid=31092;
      update items set lastclock=1372400953,lastns=369025958,prevvalue=lastvalue,lastvalue='8389763072' where itemid=31213;
      update items set lastclock=1372400954,lastns=339647429,prevvalue=lastvalue,lastvalue='100.000000' where itemid=31214;
      update items set lastclock=1372400953,lastns=156715934,prevvalue=lastvalue,lastvalue='1' where itemid=31272;
      update items set lastclock=1372400953,lastns=223747642,prevvalue=lastvalue,lastvalue='0.000000' where itemid=31332;
      update items set lastclock=1372400953,lastns=970980545,prevvalue=lastvalue,lastvalue='162361344' where itemid=31333;
      update items set lastclock=1372400955,lastns=423904834,prevvalue=lastvalue,lastvalue='18329600' where itemid=31334;
      update items set lastclock=1372400954,lastns=518930360,prevvalue=lastvalue,lastvalue='1029943296' where itemid=31394;
      update items set lastclock=1372400954,lastns=257747224,prevvalue=lastvalue,lastvalue='18583552' where itemid=31423;
      update items set lastclock=1372400954,lastns=683954637,prevvalue=lastvalue,lastvalue='5' where itemid=31424;
      update items set lastclock=1372400955,lastns=158182220,prevvalue=lastvalue,lastvalue='1084364800' where itemid=31454;
      update items set lastclock=1372400953,lastns=414830827,prevvalue=lastvalue,lastvalue='44.111901' where itemid=31513;
      update items set lastclock=1372400954,lastns=338900804,prevvalue=lastvalue,lastvalue='97.986771' where itemid=31514;
      update items set lastclock=1372400955,lastns=519606077,prevvalue=lastvalue,lastvalue='86.533231' where itemid=31515;
      update items set lastclock=1372400952,lastns=813924673,prevvalue=lastvalue,lastvalue='11288041472' where itemid=31632;
      update items set lastclock=1372400954,lastns=330541594,prevorgvalue='9443514594',prevvalue=lastvalue,lastvalue='19760' where itemid=31633;
      update items set lastclock=1372400955,lastns=10375790,prevorgvalue='101097084239',prevvalue=lastvalue,lastvalue='3608' where itemid=31634;
      update items set lastclock=1372400953,lastns=970735310,prevvalue=lastvalue,lastvalue='1' where itemid=31933;
      update items set lastclock=1372400953,lastns=906159784,prevorgvalue='2917935050',prevvalue=lastvalue,lastvalue='4128' where itemid=32113;
      update items set lastclock=1372400954,lastns=709651752,prevorgvalue='0',prevvalue=lastvalue,lastvalue='0' where itemid=32114;
      update items set lastclock=1372400953,lastns=29972598,prevvalue=lastvalue,lastvalue='251535360' where itemid=32172;
      update items set lastclock=1372400953,lastns=402392145,prevvalue=lastvalue,lastvalue='3801088' where itemid=32173;
      update items set lastclock=1372400955,lastns=13249826,prevvalue=lastvalue,lastvalue='45' where itemid=32174;
      update items set lastclock=1372400955,lastns=46701513,prevorgvalue='7168405120',prevvalue=lastvalue,lastvalue='1260' where itemid=32414;
      update items set lastclock=1372400955,lastns=396401314,prevvalue=lastvalue,lastvalue='0.000000' where itemid=32415;
      update items set lastclock=1372400953,lastns=167478508,prevvalue=lastvalue,lastvalue='100.000000' where itemid=32472;
      update items set lastclock=1372400952,lastns=783984596,prevvalue=lastvalue,lastvalue='81.846609' where itemid=32532;
      update items set lastclock=1372400954,lastns=106334981,prevvalue=lastvalue,lastvalue='89.063979' where itemid=32533;
      update items set lastclock=1372400955,lastns=161055061,prevvalue=lastvalue,lastvalue='84.773122' where itemid=32534;
      update items set lastclock=1372400954,lastns=478435485,prevvalue=lastvalue,lastvalue='22029127680' where itemid=32594;
      update items set lastclock=1372400952,lastns=614823933,prevvalue=lastvalue,lastvalue='4.166992' where itemid=32952;
      update items set lastclock=1372400954,lastns=265318510,prevvalue=lastvalue,lastvalue='4.395508' where itemid=32953;
      update items set lastclock=1372400955,lastns=235734510,prevorgvalue='740441940',prevvalue=lastvalue,lastvalue='633' where itemid=32954;
      update items set lastclock=1372400953,lastns=571528661,prevvalue=lastvalue,lastvalue='' where itemid=33073;
      update items set lastclock=1372400954,lastns=832630138,prevvalue=lastvalue,lastvalue='' where itemid=33074;
      update items set lastclock=1372400953,lastns=741261964,prevvalue=lastvalue,lastvalue='0' where itemid=33133;
      update items set lastclock=1372400954,lastns=739768032,prevvalue=lastvalue,lastvalue='0' where itemid=33134;
      update items set lastclock=1372400952,lastns=813197929,prevvalue=lastvalue,lastvalue='0' where itemid=33162;
      update items set lastclock=1372400953,lastns=792016315,prevvalue=lastvalue,lastvalue='0' where itemid=33163;
      update items set lastclock=1372400954,lastns=610009100,prevvalue=lastvalue,lastvalue='0' where itemid=33164;
      update items set lastclock=1372400952,lastns=985868241,prevvalue=lastvalue,lastvalue='' where itemid=33192;
      update items set lastclock=1372400953,lastns=960496569,prevvalue=lastvalue,lastvalue='' where itemid=33193;
      update items set lastclock=1372400955,lastns=79965477,prevvalue=lastvalue,lastvalue='' where itemid=33194;
      update items set lastclock=1372400954,lastns=262128503,prevvalue=lastvalue,lastvalue='' where itemid=33253;
      update items set lastclock=1372400955,lastns=323547641,prevvalue=lastvalue,lastvalue='' where itemid=33254;
      update items set lastclock=1372400952,lastns=706450055,prevvalue=lastvalue,lastvalue='' where itemid=33312;
      update items set lastclock=1372400953,lastns=810427824,prevvalue=lastvalue,lastvalue='' where itemid=33313;
      update items set lastclock=1372400954,lastns=984138461,prevvalue=lastvalue,lastvalue='' where itemid=33314;
      update items set lastclock=1372400952,lastns=793459647,prevvalue=lastvalue,lastvalue='0' where itemid=33342;
      update items set lastclock=1372400952,lastns=827363661,prevvalue=lastvalue,lastvalue='0' where itemid=33402;
      update items set lastclock=1372400954,lastns=344947098,prevvalue=lastvalue,lastvalue='0' where itemid=33403;
      update items set lastclock=1372400955,lastns=326921019,prevvalue=lastvalue,lastvalue='0' where itemid=33404;
      update items set lastclock=1372400952,lastns=708519699,prevvalue=lastvalue,lastvalue='' where itemid=33432;
      update items set lastclock=1372400954,lastns=288811674,prevvalue=lastvalue,lastvalue='' where itemid=33433;
      update items set lastclock=1372400955,lastns=278497075,prevvalue=lastvalue,lastvalue='file;
      update items set lastclock=1372400955,lastns=395448536,prevvalue=lastvalue,lastvalue='' where itemid=33435;
      update items set lastclock=1372400952,lastns=788469720,prevvalue=lastvalue,lastvalue='0' where itemid=33462;
      update items set lastclock=1372400953,lastns=784506466,prevvalue=lastvalue,lastvalue='0' where itemid=33463;
      update items set lastclock=1372400954,lastns=708652555,prevvalue=lastvalue,lastvalue='0' where itemid=33464;
      update items set lastclock=1372400953,lastns=293776259,prevvalue=lastvalue,lastvalue='0.000000' where itemid=33492;
      update items set lastclock=1372400954,lastns=54184569,prevvalue=lastvalue,lastvalue='0.000000' where itemid=33493;
      update items set lastclock=1372400954,lastns=723523527,prevvalue=lastvalue,lastvalue='0.000000' where itemid=33494;
      update items set lastclock=1372400955,lastns=299341557,prevvalue=lastvalue,lastvalue='6' where itemid=33524;
      update items set lastclock=1372400952,lastns=847816399,prevvalue=lastvalue,lastvalue='' where itemid=33612;
      update items set lastclock=1372400953,lastns=950493334,prevvalue=lastvalue,lastvalue='' where itemid=33613;
      update items set lastclock=1372400955,lastns=450171688,prevvalue=lastvalue,lastvalue='' where itemid=33614;
      update items set lastclock=1372400954,lastns=52311949,prevvalue=lastvalue,lastvalue='295927808' where itemid=33733;
      update items set lastclock=1372400953,lastns=24331699,prevvalue=lastvalue,lastvalue='1372400999' where itemid=33792;
      update items set lastclock=1372400953,lastns=972738142,prevvalue=lastvalue,lastvalue='1073680384' where itemid=33793;
      update items set lastclock=1372400955,lastns=8155030,prevvalue=lastvalue,lastvalue='99.994278' where itemid=33794;
      update items set lastclock=1372400953,lastns=373251341,prevvalue=lastvalue,lastvalue='87.752823' where itemid=33853;
      update items set lastclock=1372400954,lastns=966537914,prevvalue=lastvalue,lastvalue='0.136476' where itemid=33854;
      update items set lastclock=1372400954,lastns=472586641,prevvalue=lastvalue,lastvalue='1' where itemid=33913;
      update items set lastclock=1372400955,lastns=423515822,prevvalue=lastvalue,lastvalue='1' where itemid=33914;
      update items set lastclock=1372400952,lastns=922780332,prevvalue=lastvalue,lastvalue='8257536' where itemid=33942;
      update items set lastclock=1372400953,lastns=530002676,prevvalue=lastvalue,lastvalue='5' where itemid=33943;
      update items set lastclock=1372400954,lastns=513108479,prevvalue=lastvalue,lastvalue='5' where itemid=33944;
      update items set lastclock=1372400952,lastns=936211214,prevvalue=lastvalue,lastvalue='12' where itemid=33972;
      update items set lastclock=1372400954,lastns=412100655,prevvalue=lastvalue,lastvalue='97.884453' where itemid=33973;
      update items set lastclock=1372400955,lastns=190764580,prevvalue=lastvalue,lastvalue='54.696194' where itemid=33974;
      update items set lastclock=1372400953,lastns=1265775,prevvalue=lastvalue,lastvalue='0.000000' where itemid=34092;
      update items set lastclock=1372400953,lastns=817517430,prevvalue=lastvalue,lastvalue='0.000000' where itemid=34093;
      update items set lastclock=1372400954,lastns=437601344,prevvalue=lastvalue,lastvalue='0.000000' where itemid=34094;
      update items set lastclock=1372400952,lastns=753869084,prevvalue=lastvalue,lastvalue='5' where itemid=34122;
      update items set lastclock=1372400954,lastns=492070900,prevvalue=lastvalue,lastvalue='6' where itemid=34124;
      update items set lastclock=1372400954,lastns=310415067,prevvalue=lastvalue,lastvalue='1834563584' where itemid=34153;
      update items set lastclock=1372400954,lastns=492146074,prevvalue=lastvalue,lastvalue='53.381210' where itemid=34154;
      update items set lastclock=1372400953,lastns=870829590,prevvalue=lastvalue,lastvalue='0.362500' where itemid=34692;
      update items set lastclock=1372400954,lastns=566880816,prevorgvalue='83483812728',prevvalue=lastvalue,lastvalue='5609' where itemid=34693;
      update items set lastclock=1372400955,lastns=275789601,prevvalue=lastvalue,lastvalue='73.036093' where itemid=34694;
      update items set lastclock=1372400953,lastns=359190735 where itemid=34752;
      update items set lastclock=1372400954,lastns=126452548 where itemid=34753;
      update items set lastclock=1372400955,lastns=317438971 where itemid=34754;
      update items set lastclock=1372400952,lastns=713645384,prevvalue=lastvalue,lastvalue='0.000000' where itemid=34932;
      update items set lastclock=1372400953,lastns=630599216,prevvalue=lastvalue,lastvalue='0.149875' where itemid=34933;
      update items set lastclock=1372400954,lastns=800372539,prevvalue=lastvalue,lastvalue='0.000000' where itemid=34934;
      update items set lastclock=1372400952,lastns=810318177,prevorgvalue='4178801537834',prevvalue=lastvalue,lastvalue='220888' where itemid=34992;
      update items set lastclock=1372400953,lastns=815222264,prevorgvalue='2401715323927',prevvalue=lastvalue,lastvalue='124448' where itemid=34993;
      update items set lastclock=1372400955,lastns=54582712,prevorgvalue='441886304895',prevvalue=lastvalue,lastvalue='21952' where itemid=34994;
      update items set lastclock=1372400952,lastns=928937554,prevvalue=lastvalue,lastvalue='1' where itemid=35532;
      update items set lastclock=1372400954,lastns=136065917,prevvalue=lastvalue,lastvalue='0' where itemid=35533;
      update items set lastclock=1372400953,lastns=390426013,prevvalue=lastvalue,lastvalue='8' where itemid=35592;
      update items set lastclock=1372400952,lastns=789205764,prevvalue=lastvalue,lastvalue='4' where itemid=36012;
      update items set lastclock=1372400953,lastns=905076709,prevvalue=lastvalue,lastvalue='4' where itemid=36013;
      update items set lastclock=1372400955,lastns=22115802,prevvalue=lastvalue,lastvalue='4' where itemid=36014;
      update items set lastclock=1372400953,lastns=785859520,prevvalue=lastvalue,lastvalue='968257536' where itemid=36313;
      update items set lastclock=1372400955,lastns=320413694,prevvalue=lastvalue,lastvalue='2935504896' where itemid=36314;
      update items set lastclock=1372400955,lastns=67101432,prevvalue=lastvalue,lastvalue='0' where itemid=36344;
      update items set lastclock=1372400953,lastns=371136388,prevvalue=lastvalue,lastvalue='11999541985280' where itemid=36673;
      update items set lastclock=1372400954,lastns=963150201,prevvalue=lastvalue,lastvalue='86.716952' where itemid=36674;
      update items set lastclock=1372400953,lastns=133881677,prevvalue=lastvalue,lastvalue='15937536' where itemid=36700;
      update items set lastclock=1372400953,lastns=945010463,prevvalue=lastvalue,lastvalue='210153472' where itemid=36701;
      update items set lastclock=1372400954,lastns=600515532,prevvalue=lastvalue,lastvalue='144584704' where itemid=36702;
      update items set lastclock=1372400952,lastns=842315268,prevvalue=lastvalue,lastvalue='1' where itemid=37032;
      update items set lastclock=1372400954,lastns=468760851,prevvalue=lastvalue,lastvalue='314646528' where itemid=37092;
      update items set lastclock=1372400954,lastns=333187120,prevvalue=lastvalue,lastvalue='81.522898' where itemid=37153;
      update items set lastclock=1372400953,lastns=166671897,prevvalue=lastvalue,lastvalue='116436992' where itemid=37211;
      update items set lastclock=1372400954,lastns=104314060,prevvalue=lastvalue,lastvalue='26759168' where itemid=37212;
      update items set lastclock=1372400954,lastns=104053381,prevvalue=lastvalue,lastvalue='4' where itemid=37213;
      update items set lastclock=1372400952,lastns=852537114,prevorgvalue='0',prevvalue=lastvalue,lastvalue='0' where itemid=37272;
      update items set lastclock=1372400953,lastns=776240264,prevorgvalue='0',prevvalue=lastvalue,lastvalue='0' where itemid=37273;
      update items set lastclock=1372400955,lastns=22248232,prevorgvalue='0',prevvalue=lastvalue,lastvalue='0' where itemid=37274;
      update items set lastclock=1372400955,lastns=76713948,prevvalue=lastvalue,lastvalue='1521434624' where itemid=37285;
      update items set lastclock=1372400952,lastns=812564962,prevorgvalue='529816185',prevvalue=lastvalue,lastvalue='23944' where itemid=37332;
      update items set lastclock=1372400954,lastns=137829231,prevorgvalue='65600119',prevvalue=lastvalue,lastvalue='2040' where itemid=37333;
      update items set lastclock=1372400954,lastns=513726514,prevorgvalue='529821600',prevvalue=lastvalue,lastvalue='24024' where itemid=37334;
      update items set lastclock=1372400955,lastns=518712687,prevvalue=lastvalue,lastvalue='8562524160' where itemid=37335;
      update items set lastclock=1372400953,lastns=151160705,prevvalue=lastvalue,lastvalue='7818422403072' where itemid=37392;
      update items set lastclock=1372400954,lastns=327903577,prevvalue=lastvalue,lastvalue='9187360251904' where itemid=37393;
      update items set lastclock=1372400954,lastns=521052907,prevvalue=lastvalue,lastvalue='9919367258112' where itemid=37394;
      update items set lastclock=1372400952,lastns=938982685,prevorgvalue='3035937500',prevvalue=lastvalue,lastvalue='937500' where itemid=37511;
      update items set lastclock=1372400953,lastns=209855389,prevvalue=lastvalue,lastvalue='1' where itemid=37902;
      update items set lastclock=1372400953,lastns=732904717,prevorgvalue='662125642',prevvalue=lastvalue,lastvalue='55' where itemid=38232;
      update items set lastclock=1372400954,lastns=794510980,prevvalue=lastvalue,lastvalue='0.000000' where itemid=38233;
      update items set lastclock=1372400955,lastns=253772450,prevvalue=lastvalue,lastvalue='0.000000' where itemid=38234;
      update items set lastclock=1372400952,lastns=672884881,prevvalue=lastvalue,lastvalue='1372400998' where itemid=38471;
      update items set lastclock=1372400953,lastns=454100896,prevvalue=lastvalue,lastvalue='1777868800' where itemid=38472;
      update items set lastclock=1372400954,lastns=688812476,prevvalue=lastvalue,lastvalue='82.788783' where itemid=38473;
      update items set lastclock=1372400953,lastns=291198057,prevvalue=lastvalue,lastvalue='96.528296' where itemid=38772;
      update items set lastclock=1372400954,lastns=11959232,prevvalue=lastvalue,lastvalue='99.920312' where itemid=38773;
      update items set lastclock=1372400954,lastns=971911564,prevvalue=lastvalue,lastvalue='42101350400' where itemid=38774;
      update items set lastclock=1372400952,lastns=640856048,prevorgvalue='66314170677',prevvalue=lastvalue,lastvalue='6864' where itemid=39131;
      update items set lastclock=1372400953,lastns=193632728,prevorgvalue='35915579517',prevvalue=lastvalue,lastvalue='872' where itemid=39132;
      update items set lastclock=1372400954,lastns=128669128,prevorgvalue='307055692406',prevvalue=lastvalue,lastvalue='3176' where itemid=39133;
      update items set lastclock=1372400955,lastns=516088749,prevorgvalue='8159347983',prevvalue=lastvalue,lastvalue='1232' where itemid=39134;
      update items set lastclock=1372400953,lastns=802428018,prevvalue=lastvalue,lastvalue='' where itemid=39312;
      update items set lastclock=1372400954,lastns=408299355,prevvalue=lastvalue,lastvalue='1' where itemid=39313;
      update items set lastclock=1372400952,lastns=931049435,prevvalue=lastvalue,lastvalue='614' where itemid=39370;
      update items set lastclock=1372400952,lastns=705805398,prevvalue=lastvalue,lastvalue='1427' where itemid=39371;
      update items set lastclock=1372400953,lastns=766469890,prevvalue=lastvalue,lastvalue='400' where itemid=39372;
      update items set lastclock=1372400954,lastns=854001267,prevvalue=lastvalue,lastvalue='186' where itemid=39373;
      update items set lastclock=1372400952,lastns=894265584,prevvalue=lastvalue,lastvalue='0.042358' where itemid=39432;
      update items set lastclock=1372400953,lastns=766029083,prevvalue=lastvalue,lastvalue='0.050049' where itemid=39433;
      update items set lastclock=1372400954,lastns=735286407,prevvalue=lastvalue,lastvalue='0.050171' where itemid=39434;
      update items set lastclock=1372400952,lastns=841121607,prevvalue=lastvalue,lastvalue='7709788160' where itemid=39612;
      update items set lastclock=1372400953,lastns=685768637,prevvalue=lastvalue,lastvalue='114713344000' where itemid=39613;
      update items set lastclock=1372400954,lastns=727539770,prevvalue=lastvalue,lastvalue='27116740608' where itemid=39614;
      update items set lastclock=1372400953,lastns=406988623,prevvalue=lastvalue,lastvalue='70.763521' where itemid=39792;
      update items set lastclock=1372400954,lastns=246862972,prevvalue=lastvalue,lastvalue='94.484296' where itemid=39793;
      update items set lastclock=1372400953,lastns=4355436,prevvalue=lastvalue,lastvalue='76.958748' where itemid=39852;
      update items set lastclock=1372400954,lastns=308557977,prevvalue=lastvalue,lastvalue='1971933184' where itemid=39853;
      update items set lastclock=1372400954,lastns=666453158,prevvalue=lastvalue,lastvalue='22.913456' where itemid=39854;
      update items set lastclock=1372400952,lastns=896964696,prevvalue=lastvalue,lastvalue='0.000000' where itemid=39972;
      update items set lastclock=1372400954,lastns=437480690,prevorgvalue='130168746007792563',prevvalue=lastvalue,lastvalue='294368226' where itemid=39973;
      update items set lastclock=1372400955,lastns=45830394,prevorgvalue='130168746013876485',prevvalue=lastvalue,lastvalue='294212228' where itemid=39974;
      update items set lastclock=1372400953,lastns=493441617,prevvalue=lastvalue,lastvalue='1' where itemid=40153;
      update items set lastclock=1372400955,lastns=148053296,prevvalue=lastvalue,lastvalue='1' where itemid=40154;
      update items set lastclock=1372400952,lastns=760357039,prevvalue=lastvalue,lastvalue='0.000000' where itemid=40272;
      update items set lastclock=1372400953,lastns=740941214,prevvalue=lastvalue,lastvalue='99385344.000000' where itemid=40273;
      update items set lastclock=1372400954,lastns=724533475,prevvalue=lastvalue,lastvalue='18' where itemid=40274;
      update items set lastclock=1372400954,lastns=153920060,prevvalue=lastvalue,lastvalue='1' where itemid=40333;
      update items set lastclock=1372400954,lastns=670825904,prevvalue=lastvalue,lastvalue='1' where itemid=40334;
      update items set lastclock=1372400955,lastns=503084510,prevvalue=lastvalue,lastvalue='1' where itemid=40335;
      update items set lastclock=1372400953,lastns=15703534,prevvalue=lastvalue,lastvalue='1' where itemid=40362;
      update items set lastclock=1372400954,lastns=221990301,prevvalue=lastvalue,lastvalue='1' where itemid=40363;
      update items set lastclock=1372400955,lastns=6492574,prevvalue=lastvalue,lastvalue='1' where itemid=40364;
      update items set lastclock=1372400952,lastns=741509929,prevvalue=lastvalue,lastvalue='1' where itemid=40392;
      update items set lastclock=1372400953,lastns=817731946,prevvalue=lastvalue,lastvalue='1' where itemid=40393;
      update items set lastclock=1372400954,lastns=357579817,prevvalue=lastvalue,lastvalue='1' where itemid=40453;
      update items set lastclock=1372400954,lastns=825438308,prevvalue=lastvalue,lastvalue='1' where itemid=40454;
      update items set lastclock=1372400952,lastns=852327292,prevvalue=lastvalue,lastvalue='383315968' where itemid=40482;
      update items set lastclock=1372400953,lastns=828618332,prevvalue=lastvalue,lastvalue='31952896' where itemid=40483;
      update items set lastclock=1372400955,lastns=135058272,prevvalue=lastvalue,lastvalue='166248448' where itemid=40484;
      update items set lastclock=1372400952,lastns=838186135,prevvalue=lastvalue,lastvalue='8' where itemid=40512;
      update items set lastclock=1372400953,lastns=692161877,prevvalue=lastvalue,lastvalue='9' where itemid=40513;
      update items set lastclock=1372400954,lastns=566264914,prevvalue=lastvalue,lastvalue='4' where itemid=40514;
      update items set lastclock=1372400952,lastns=796604942,prevvalue=lastvalue,lastvalue='0' where itemid=40572;
      update items set lastclock=1372400953,lastns=816326244,prevvalue=lastvalue,lastvalue='1' where itemid=40573;
      update items set lastclock=1372400955,lastns=157069280,prevvalue=lastvalue,lastvalue='0' where itemid=40574;
      update items set lastclock=1372400953,lastns=202401003,prevvalue=lastvalue,lastvalue='1' where itemid=40602;
      update items set lastclock=1372400954,lastns=551283527,prevvalue=lastvalue,lastvalue='1' where itemid=40603;
      update items set lastclock=1372400954,lastns=964698316,prevvalue=lastvalue,lastvalue='1' where itemid=40604;
      update items set lastclock=1372400952,lastns=611743146,prevvalue=lastvalue,lastvalue='1.000000' where itemid=40631;
      update items set lastclock=1372400952,lastns=948214550,prevvalue=lastvalue,lastvalue='0.000000' where itemid=40632;
      update items set lastclock=1372400953,lastns=931063600,prevvalue=lastvalue,lastvalue='0.000000' where itemid=40633;
      update items set lastclock=1372400955,lastns=305950678,prevvalue=lastvalue,lastvalue='105799680' where itemid=40634;
      update items set lastclock=1372400953,lastns=225460015,prevvalue=lastvalue,lastvalue='4' where itemid=40662;
      update items set lastclock=1372400953,lastns=868095152,prevvalue=lastvalue,lastvalue='4' where itemid=40663;
      update items set lastclock=1372400953,lastns=448793888,prevvalue=lastvalue,lastvalue='98.151872' where itemid=40993;
      update items set lastclock=1372400954,lastns=690455562,prevvalue=lastvalue,lastvalue='0.033644' where itemid=40994;
      update items set lastclock=1372400955,lastns=381720284,prevvalue=lastvalue,lastvalue='0.000000' where itemid=40995;
      update items set lastclock=1372400953,lastns=414071062,prevvalue=lastvalue,lastvalue='1' where itemid=41173;
      update items set lastclock=1372400952,lastns=645350301,prevvalue=lastvalue,lastvalue='88.687082' where itemid=41232;
      update items set lastclock=1372400953,lastns=316510255,prevvalue=lastvalue,lastvalue='0.000000' where itemid=41233;
      update items set lastclock=1372400954,lastns=752514494,prevvalue=lastvalue,lastvalue='0.717924' where itemid=41234;
      update items set lastclock=1372400953,lastns=94565104,prevvalue=lastvalue,lastvalue='0' where itemid=41292;
      update items set lastclock=1372400953,lastns=737286508,prevvalue=lastvalue,lastvalue='0' where itemid=41293;
      update items set lastclock=1372400955,lastns=232038163,prevvalue=lastvalue,lastvalue='0' where itemid=41294;
      update items set lastclock=1372400952,lastns=671889012,prevvalue=lastvalue,lastvalue='' where itemid=41352;
      update items set lastclock=1372400954,lastns=246964256,prevvalue=lastvalue,lastvalue='' where itemid=41353;
      update items set lastclock=1372400954,lastns=664346140,prevvalue=lastvalue,lastvalue='' where itemid=41354;
      update items set lastclock=1372400953,lastns=296923090,prevvalue=lastvalue,lastvalue='190' where itemid=41412;
      update items set lastclock=1372400954,lastns=477687410,prevvalue=lastvalue,lastvalue='99.418384' where itemid=41414;
      update items set lastclock=1372400955,lastns=519449413,prevvalue=lastvalue,lastvalue='83.279387' where itemid=41415;
      update items set lastclock=1372400953,lastns=200102423,prevvalue=lastvalue,lastvalue='0' where itemid=41442;
      update items set lastclock=1372400953,lastns=906586854,prevvalue=lastvalue,lastvalue='0' where itemid=41443;
      update items set lastclock=1372400955,lastns=248110219,prevvalue=lastvalue,lastvalue='0' where itemid=41444;
      update items set lastclock=1372400953,lastns=113559065,prevvalue=lastvalue,lastvalue='0' where itemid=41472;
      update items set lastclock=1372400954,lastns=351330185,prevvalue=lastvalue,lastvalue='0' where itemid=41473;
      update items set lastclock=1372400954,lastns=659394866,prevvalue=lastvalue,lastvalue='0' where itemid=41474;
      update items set lastclock=1372400953,lastns=147364524,prevvalue=lastvalue,lastvalue='' where itemid=41532;
      update items set lastclock=1372400954,lastns=213291483,prevvalue=lastvalue,lastvalue='' where itemid=41533;
      update items set lastclock=1372400954,lastns=422880380,prevvalue=lastvalue,lastvalue='' where itemid=41534;
      update items set lastclock=1372400955,lastns=514504966,prevvalue=lastvalue,lastvalue='' where itemid=41535;
      update items set lastclock=1372400952,lastns=673472880,prevvalue=lastvalue,lastvalue='' where itemid=41592;
      update items set lastclock=1372400953,lastns=717547884,prevvalue=lastvalue,lastvalue='' where itemid=41593;
      update items set lastclock=1372400955,lastns=368089221,prevvalue=lastvalue,lastvalue='' where itemid=41594;
      update items set lastclock=1372400953,lastns=18321071,prevvalue=lastvalue,lastvalue='0' where itemid=41652;
      update items set lastclock=1372400954,lastns=63812529,prevvalue=lastvalue,lastvalue='0' where itemid=41653;
      update items set lastclock=1372400955,lastns=409026524,prevvalue=lastvalue,lastvalue='0' where itemid=41654;
      update items set lastclock=1372400955,lastns=397908131,prevvalue=lastvalue,lastvalue='0.000000' where itemid=41684;
      update items set lastclock=1372400955,lastns=495824843,prevvalue=lastvalue,lastvalue='30269440' where itemid=41685;
      update items set lastclock=1372400954,lastns=65542822,prevorgvalue='42',prevvalue=lastvalue,lastvalue='0' where itemid=41713;
      update items set lastclock=1372400954,lastns=589859875,prevorgvalue='2748621651',prevvalue=lastvalue,lastvalue='2360' where itemid=41714;
      update items set lastclock=1372400953,lastns=154747746,prevvalue=lastvalue,lastvalue='0.000000' where itemid=41742;
      update items set lastclock=1372400954,lastns=42699775,prevvalue=lastvalue,lastvalue='0.000000' where itemid=41743;
      update items set lastclock=1372400955,lastns=316594645,prevvalue=lastvalue,lastvalue='0.000000' where itemid=41744;
      update items set lastclock=1372400953,lastns=284599687,prevvalue=lastvalue,lastvalue='7' where itemid=41772;
      update items set lastclock=1372400953,lastns=810370910,prevvalue=lastvalue,lastvalue='6' where itemid=41773;
      update items set lastclock=1372400954,lastns=695554198,prevvalue=lastvalue,lastvalue='5' where itemid=41774;
      update items set lastclock=1372400953,lastns=309140685,prevvalue=lastvalue,lastvalue='79258624' where itemid=41832;
      update items set lastclock=1372400953,lastns=820119268,prevvalue=lastvalue,lastvalue='84.389133' where itemid=41833;
      update items set lastclock=1372400954,lastns=692159914,prevvalue=lastvalue,lastvalue='80.737897' where itemid=41834;
      update items set lastclock=1372400953,lastns=690523569,prevvalue=lastvalue,lastvalue='0' where itemid=41862;
      update items set lastclock=1372400953,lastns=710143586,prevvalue=lastvalue,lastvalue='0' where itemid=41892;
      update items set lastclock=1372400953,lastns=669442301,prevvalue=lastvalue,lastvalue='' where itemid=41952;
      update items set lastclock=1372400953,lastns=605211929,prevvalue=lastvalue,lastvalue='0' where itemid=42012;
      update items set lastclock=1372400954,lastns=705787650,prevvalue=lastvalue,lastvalue='0' where itemid=42013;
      update items set lastclock=1372400953,lastns=625865616,prevvalue=lastvalue,lastvalue='' where itemid=42073;
      update items set lastclock=1372400955,lastns=259876085,prevvalue=lastvalue,lastvalue='' where itemid=42074;
      update items set lastclock=1372400955,lastns=477744068,prevvalue=lastvalue,lastvalue='' where itemid=42075;
      update items set lastclock=1372400953,lastns=269647909,prevvalue=lastvalue,lastvalue='0.000000' where itemid=42162;
      update items set lastclock=1372400954,lastns=122129378,prevvalue=lastvalue,lastvalue='0.000000' where itemid=42163;
      update items set lastclock=1372400954,lastns=496353624,prevvalue=lastvalue,lastvalue='0.000000' where itemid=42164;
      update items set lastclock=1372400953,lastns=314860086,prevvalue=lastvalue,lastvalue='0.000000' where itemid=42192;
      update items set lastclock=1372400953,lastns=844595076,prevvalue=lastvalue,lastvalue='0.000000' where itemid=42193;
      update items set lastclock=1372400954,lastns=501239451,prevvalue=lastvalue,lastvalue='0.000000' where itemid=42194;
      update items set lastclock=1372400952,lastns=645012059,prevvalue=lastvalue,lastvalue='0.000000' where itemid=42222;
      update items set lastclock=1372400953,lastns=528431095,prevvalue=lastvalue,lastvalue='0.000000' where itemid=42223;
      update items set lastclock=1372400954,lastns=593502380,prevvalue=lastvalue,lastvalue='0.000000' where itemid=42224;
      update items set lastclock=1372400953,lastns=171717032,prevvalue=lastvalue,lastvalue='0.000000' where itemid=42252;
      update items set lastclock=1372400953,lastns=517513650,prevvalue=lastvalue,lastvalue='0.000000' where itemid=42253;
      update items set lastclock=1372400955,lastns=50106121,prevvalue=lastvalue,lastvalue='0.000000' where itemid=42254;
      update items set lastclock=1372400952,lastns=809801086,prevvalue=lastvalue,lastvalue='0.015625' where itemid=42282;
      update items set lastclock=1372400954,lastns=112044825,prevvalue=lastvalue,lastvalue='0.000000' where itemid=42283;
      update items set lastclock=1372400955,lastns=70805032,prevvalue=lastvalue,lastvalue='0.000000' where itemid=42284;
      update items set lastclock=1372400952,lastns=945955562,prevvalue=lastvalue,lastvalue='0.000000' where itemid=42312;
      update items set lastclock=1372400954,lastns=108448142,prevvalue=lastvalue,lastvalue='0.000000' where itemid=42313;
      update items set lastclock=1372400954,lastns=750788724,prevvalue=lastvalue,lastvalue='0.000000' where itemid=42314;
      update items set lastclock=1372400953,lastns=860587947,prevvalue=lastvalue,lastvalue='1372400998' where itemid=42553;
      update items set lastclock=1372400954,lastns=568612473,prevvalue=lastvalue,lastvalue='1073741824' where itemid=42554;
      update items set lastclock=1372400952,lastns=675386031,prevvalue=lastvalue,lastvalue='85.531643' where itemid=42732;
      update items set lastclock=1372400952,lastns=694942990,prevvalue=lastvalue,lastvalue='0' where itemid=42762;
      update items set lastclock=1372400953,lastns=839252315,prevvalue=lastvalue,lastvalue='0' where itemid=42763;
      update items set lastclock=1372400952,lastns=939035845,prevvalue=lastvalue,lastvalue='' where itemid=42792;
      update items set lastclock=1372400954,lastns=19342369,prevvalue=lastvalue,lastvalue='0' where itemid=42793;
      update items set lastclock=1372400954,lastns=587871379,prevvalue=lastvalue,lastvalue='0' where itemid=42794;
      update items set lastclock=1372400955,lastns=504453265,prevvalue=lastvalue,lastvalue='0' where itemid=42795;
      update items set lastclock=1372400954,lastns=965054222,prevvalue=lastvalue,lastvalue='30209855488' where itemid=42854;
      update items set lastclock=1372400952,lastns=932753958,prevvalue=lastvalue,lastvalue='0' where itemid=42912;
      update items set lastclock=1372400953,lastns=884348360,prevvalue=lastvalue,lastvalue='0' where itemid=42913;
      update items set lastclock=1372400954,lastns=960789928,prevvalue=lastvalue,lastvalue='2.153' where itemid=42914;
      update items set lastclock=1372400953,lastns=556758633,prevorgvalue='130168745352520631',prevvalue=lastvalue,lastvalue='293592516' where itemid=42972;
      update items set lastclock=1372400954,lastns=336765543,prevorgvalue='130168745360164644',prevvalue=lastvalue,lastvalue='293748516' where itemid=42973;
      update items set lastclock=1372400953,lastns=135487389,prevvalue=lastvalue,lastvalue='153587712' where itemid=43001;
      update items set lastclock=1372400953,lastns=728317454,prevvalue=lastvalue,lastvalue='100188160' where itemid=43002;
      update items set lastclock=1372400953,lastns=307173948,prevvalue=lastvalue,lastvalue='10' where itemid=43031;
      update items set lastclock=1372400954,lastns=352309501,prevvalue=lastvalue,lastvalue='13' where itemid=43032;
      update items set lastclock=1372400953,lastns=73196962,prevorgvalue='130168745347840622',prevvalue=lastvalue,lastvalue='286260502' where itemid=43062;
      update items set lastclock=1372400954,lastns=804759705,prevvalue=lastvalue,lastvalue='176' where itemid=43063;
      update items set lastclock=1372400953,lastns=499305138,prevvalue=lastvalue,lastvalue='0.000000' where itemid=43213;
      update items set lastclock=1372400955,lastns=165218155,prevvalue=lastvalue,lastvalue='0.000000' where itemid=43214;
      update items set lastclock=1372400953,lastns=234941295,prevvalue=lastvalue,lastvalue='1986560' where itemid=43242;
      update items set lastclock=1372400954,lastns=197307230,prevvalue=lastvalue,lastvalue='37552128' where itemid=43243;
      update items set lastclock=1372400952,lastns=830099550,prevvalue=lastvalue,lastvalue='1' where itemid=43332;
      update items set lastclock=1372400954,lastns=170655716,prevvalue=lastvalue,lastvalue='1' where itemid=43333;
      update items set lastclock=1372400954,lastns=747395294,prevvalue=lastvalue,lastvalue='1' where itemid=43334;
      update items set lastclock=1372400952,lastns=962530886,prevvalue=lastvalue,lastvalue='0.000000' where itemid=43452;
      update items set lastclock=1372400953,lastns=545810299,prevvalue=lastvalue,lastvalue='0.000000' where itemid=43453;
      update items set lastclock=1372400955,lastns=219676788,prevvalue=lastvalue,lastvalue='0.000000' where itemid=43454;
      update items set lastclock=1372400953,lastns=232108473,prevvalue=lastvalue,lastvalue='0' where itemid=43482;
      update items set lastclock=1372400953,lastns=862978085,prevvalue=lastvalue,lastvalue='1442983936' where itemid=43513;
      update items set lastclock=1372400955,lastns=82465518,prevvalue=lastvalue,lastvalue='7926525952' where itemid=43514;
      update items set lastclock=1372400955,lastns=12113335,prevorgvalue='1043474141',prevvalue=lastvalue,lastvalue='261' where itemid=43574;
      update items set lastclock=1372400952,lastns=642300745,prevvalue=lastvalue,lastvalue='291008512' where itemid=43691;
      update items set lastclock=1372400953,lastns=703260218,prevvalue=lastvalue,lastvalue='2940928' where itemid=43692;
      update items set lastclock=1372400954,lastns=306576734,prevvalue=lastvalue,lastvalue='4' where itemid=43693;
      update items set lastclock=1372400954,lastns=753128603,prevvalue=lastvalue,lastvalue='4' where itemid=43694;
      update items set lastclock=1372400953,lastns=567210866,prevvalue=lastvalue,lastvalue='6064582656' where itemid=43933;
      update items set lastclock=1372400954,lastns=634329012,prevvalue=lastvalue,lastvalue='562192384' where itemid=43934;
      update items set lastclock=1372400952,lastns=961649101,prevvalue=lastvalue,lastvalue='1' where itemid=43992;
      update items set lastclock=1372400954,lastns=892112916,prevvalue=lastvalue,lastvalue='' where itemid=44834;
      update items set lastclock=1372400955,lastns=413144138,prevvalue=lastvalue,lastvalue='' where itemid=44835;
      update items set lastclock=1372400953,lastns=495524146,prevvalue=lastvalue,lastvalue='88.583259' where itemid=44893;
      update items set lastclock=1372400954,lastns=689915945,prevvalue=lastvalue,lastvalue='20834983936' where itemid=44894;
      update items set lastclock=1372400952,lastns=923670565,prevvalue=lastvalue,lastvalue='2601560064' where itemid=45072;
      update items set lastclock=1372400954,lastns=193231940,prevvalue=lastvalue,lastvalue='169930752' where itemid=45073;
      update items set lastclock=1372400954,lastns=716297480,prevorgvalue='1150245581',prevvalue=lastvalue,lastvalue='2112' where itemid=45074;
      update items set lastclock=1372400952,lastns=778009892,prevvalue=lastvalue,lastvalue='0.000000' where itemid=45132;
      update items set lastclock=1372400953,lastns=711990607,prevvalue=lastvalue,lastvalue='0.160156' where itemid=45193;
      update items set lastclock=1372400954,lastns=741643894,prevvalue=lastvalue,lastvalue='0.540527' where itemid=45194;
      update items set lastclock=1372400953,lastns=82458521,prevvalue=lastvalue,lastvalue='0.200000' where itemid=45312;
      update items set lastclock=1372400955,lastns=40088637,prevvalue=lastvalue,lastvalue='4.110000' where itemid=45314;
      update items set lastclock=1372400953,lastns=519002889,prevvalue=lastvalue,lastvalue='7404834816' where itemid=45433;
      update items set lastclock=1372400954,lastns=711021446,prevvalue=lastvalue,lastvalue='47748206592' where itemid=45434;
      update items set lastclock=1372400952,lastns=694412417,prevvalue=lastvalue,lastvalue='4294967296' where itemid=45612;
      update items set lastclock=1372400953,lastns=691904697,prevvalue=lastvalue,lastvalue='100.000000' where itemid=45613;
      update items set lastclock=1372400953,lastns=82187176,prevvalue=lastvalue,lastvalue='0' where itemid=46032;
      update items set lastclock=1372400953,lastns=793866323,prevvalue=lastvalue,lastvalue='0' where itemid=46033;
      update items set lastclock=1372400955,lastns=80396215,prevvalue=lastvalue,lastvalue='' where itemid=46034;
      update items set lastclock=1372400952,lastns=416758996,prevvalue=lastvalue,lastvalue='1' where itemid=46392;
      update items set lastclock=1372400953,lastns=427377023,prevvalue=lastvalue,lastvalue='0.000283' where itemid=46393;
      update items set lastclock=1372400954,lastns=478989011,prevvalue=lastvalue,lastvalue='1' where itemid=46394;
      update items set lastclock=1372400952,lastns=829345075,prevvalue=lastvalue,lastvalue='60' where itemid=46452;
      update items set lastclock=1372400953,lastns=198174851,prevvalue=lastvalue,lastvalue='41.127515' where itemid=46572;
      update items set lastclock=1372400953,lastns=568619726,prevvalue=lastvalue,lastvalue='27.063784' where itemid=46573;
      update items set lastclock=1372400952,lastns=852683026,prevorgvalue='66923032105957',prevvalue=lastvalue,lastvalue='4040584' where itemid=46872;
      update items set lastclock=1372400954,lastns=685332778,prevorgvalue='0',prevvalue=lastvalue,lastvalue='0' where itemid=46873;
      update items set lastclock=1372400955,lastns=211063555,prevorgvalue='0',prevvalue=lastvalue,lastvalue='0' where itemid=46874;
      update items set lastclock=1372400953,lastns=443327571,prevvalue=lastvalue,lastvalue='2.723768' where itemid=47052;
      update items set lastclock=1372400954,lastns=672069652,prevvalue=lastvalue,lastvalue='31.795191' where itemid=47053;
      update items set lastclock=1372400952,lastns=805198294,prevvalue=lastvalue,lastvalue='51857010688' where itemid=47171;
      update items set lastclock=1372400953,lastns=686407577,prevvalue=lastvalue,lastvalue='276921344' where itemid=47172;
      update items set lastclock=1372400954,lastns=325578886,prevvalue=lastvalue,lastvalue='691955687424' where itemid=47173;
      update items set lastclock=1372400955,lastns=197035715,prevvalue=lastvalue,lastvalue='1' where itemid=47234;
      update items set lastclock=1372400953,lastns=639196578,prevvalue=lastvalue,lastvalue='1' where itemid=47352;
      update items set lastclock=1372400955,lastns=304963256,prevvalue=lastvalue,lastvalue='2424995840' where itemid=47354;
      update items set lastclock=1372400954,lastns=631347036,prevorgvalue='3133517197',prevvalue=lastvalue,lastvalue='1007' where itemid=47413;
      update items set lastclock=1372400955,lastns=375429694,prevvalue=lastvalue,lastvalue='0.000000' where itemid=47414;
      update items set lastclock=1372400953,lastns=324403145,prevorgvalue='3926393511681',prevvalue=lastvalue,lastvalue='0' where itemid=47652;
      update items set lastclock=1372400953,lastns=915301457,prevvalue=lastvalue,lastvalue='99.697612' where itemid=47653;
      update items set lastclock=1372400955,lastns=215495861,prevvalue=lastvalue,lastvalue='99.995613' where itemid=47654;
      update items set lastclock=1372400953,lastns=513799726,prevvalue=lastvalue,lastvalue='36872192' where itemid=47892;
      update items set lastclock=1372400954,lastns=617980150,prevvalue=lastvalue,lastvalue='24727552' where itemid=47893;
      update items set lastclock=1372400954,lastns=433016471,prevvalue=lastvalue,lastvalue='3084288' where itemid=48013;
      update items set lastclock=1372400952,lastns=620348017,prevvalue=lastvalue,lastvalue='21' where itemid=48041;
      update items set lastclock=1372400953,lastns=171749030,prevorgvalue='0',prevvalue=lastvalue,lastvalue='0' where itemid=48132;
      update items set lastclock=1372400954,lastns=359685299,prevorgvalue='0',prevvalue=lastvalue,lastvalue='0' where itemid=48133;
      update items set lastclock=1372400953,lastns=169246174,prevvalue=lastvalue,lastvalue='6.910000' where itemid=48192;
      update items set lastclock=1372400954,lastns=100511223,prevvalue=lastvalue,lastvalue='4.770000' where itemid=48193;
      update items set lastclock=1372400955,lastns=279497979,prevvalue=lastvalue,lastvalue='6.800000' where itemid=48194;
      update items set lastclock=1372400953,lastns=700641315,prevvalue=lastvalue,lastvalue='0.000000' where itemid=48223;
      update items set lastclock=1372400954,lastns=360899012,prevvalue=lastvalue,lastvalue='0.000000' where itemid=48224;
      update items set lastclock=1372400953,lastns=555831623,prevvalue=lastvalue,lastvalue='1' where itemid=48252;
      update items set lastclock=1372400954,lastns=5213073,prevvalue=lastvalue,lastvalue='1' where itemid=48253;
      update items set lastclock=1372400955,lastns=233767857,prevvalue=lastvalue,lastvalue='1' where itemid=48254;
      update items set lastclock=1372400953,lastns=565501139,prevvalue=lastvalue,lastvalue='1' where itemid=48282;
      update items set lastclock=1372400954,lastns=907967128,prevvalue=lastvalue,lastvalue='1' where itemid=48283;
      update items set lastclock=1372400953,lastns=309992606,prevvalue=lastvalue,lastvalue='0' where itemid=48312;
      ]
      

            Unassigned Unassigned
            bossiesa Riaan Olivier
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: