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

Deadlocks when doing updates in frontend

    XMLWordPrintable

    Details

      Description

      After updating to 2.0.5 and migrating from MySQL to PostgreSQL I get database deadlock errors in the frontend and server. This happens only when I do big updates, e.g. a mass update of say 5 items in a template that affects +/- 200 hosts., or add an item to a graph in a template that affects +/- 200 hosts. I have tested and reproduced this issue on 2.0.4, 2.0.5 and 2.0.6rc1 (build from today). Output is below.

      Please fix =) This makes Zabbix pretty much unusable at the moment. Thanks =)

      The frontend says:

      pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: deadlock detected
      DETAIL: Process 27240 waits for ShareLock on transaction 60472129; blocked by process 16899.
      Process 16899 waits for ShareLock on transaction 60472111; blocked by process 27240.
      HINT: See server log for query details. [include/db.inc.php:511]
      Error in query [UPDATE items SET itemid='24886', name='CPU load 5 min.', key_='system.cpu.load[,avg5]', hostid='10191', data_type='0', templateid='23218' WHERE itemid='24886'] [ERROR: deadlock detected
      DETAIL: Process 27240 waits for ShareLock on transaction 60472129; blocked by process 16899.
      Process 16899 waits for ShareLock on transaction 60472111; blocked by process 27240.
      HINT: See server log for query details.]
      SQL statement execution has failed "UPDATE items SET itemid='24886', name='CPU load 5 min.', key_='system.cpu.load[,avg5]', hostid='10191', data_type='0', templateid='23218' WHERE itemid='24886'".

      The server log says:

      15529:20130412:124338.325 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: deadlock detected
      DETAIL: Process 16898 waits for ShareLock on transaction 60520439; blocked by process 29128.
      Process 29128 waits for ShareLock on transaction 60520782; blocked by process 16898.
      HINT: See server log for query details.
      [update items set lastclock=1365770616,lastns=561569156 where itemid=27816;
      update items set lastclock=1365770616,lastns=561579705,prevvalue=lastvalue,lastvalue='224' where itemid=28416;
      update items set lastclock=1365770616,lastns=302651170,prevvalue=lastvalue,lastvalue='613212160' where itemid=28716;
      update items set lastclock=1365770616,lastns=551991016,prevorgvalue='762111404',prevvalue=lastvalue,lastvalue='30' where itemid=29316;
      update items set lastclock=1365770617,lastns=169215296,prevorgvalue='118116762.000000',prevvalue=lastvalue,lastvalue='4.231995' where itemid=29317;
      update items set lastclock=1365770616,lastns=546063388,prevvalue=lastvalue,lastvalue='0.000000' where itemid=30816;
      update items set lastclock=1365770616,lastns=542054316,prevorgvalue='4832954719933',prevvalue=lastvalue,lastvalue='176368' where itemid=31116;
      update items set lastclock=1365770616,lastns=316427168,prevvalue=lastvalue,lastvalue='99.987835' where itemid=32316;
      update items set lastclock=1365770616,lastns=548915639,prevvalue=lastvalue,lastvalue='431656960.000000' where itemid=32916;
      update items set lastclock=1365770616,lastns=267261904,prevvalue=lastvalue,lastvalue='0.000000' where itemid=35015;
      update items set lastclock=1365770616,lastns=481598851,prevvalue=lastvalue,lastvalue='0.000000' where itemid=35315;
      update items set lastclock=1365770616,lastns=319833010,prevvalue=lastvalue,lastvalue='0.000000' where itemid=35615;
      update items set lastclock=1365770617,lastns=223887844,prevvalue=lastvalue,lastvalue='0.000000' where itemid=35616;
      update items set lastclock=1365770616,lastns=279684185,prevvalue=lastvalue,lastvalue='0.000000' where itemid=35916;
      update items set lastclock=1365770616,lastns=560938090,prevvalue=lastvalue,lastvalue='58.434954' where itemid=36216;
      update items set lastclock=1365770616,lastns=541687245,prevvalue=lastvalue,lastvalue='0.133333' where itemid=37116;
      update items set lastclock=1365770616,lastns=560763618,prevorgvalue='0',prevvalue=lastvalue,lastvalue='0' where itemid=38316;
      update items set lastclock=1365770616,lastns=569940112,prevorgvalue='2108535572',prevvalue=lastvalue,lastvalue='187168' where itemid=38616;
      update items set lastclock=1365770616,lastns=569692616,prevorgvalue='3214077800',prevvalue=lastvalue,lastvalue='16011388' where itemid=39216;
      update items set lastclock=1365770616,lastns=204900162,prevvalue=lastvalue,lastvalue='0.000000' where itemid=40415;
      update items set lastclock=1365770616,lastns=562987893,prevvalue=lastvalue,lastvalue='0.220000' where itemid=43416;
      update items set lastclock=1365770616,lastns=563620867,prevvalue=lastvalue,lastvalue='4788543488' where itemid=43716;
      update items set lastclock=1365770616,lastns=562166618,prevvalue=lastvalue,lastvalue='0.031107' where itemid=44916;
      update items set lastclock=1365770616,lastns=557792718,prevvalue=lastvalue,lastvalue='646864896' where itemid=47316;
      update items set lastclock=1365770617,lastns=226301020,prevvalue=lastvalue,lastvalue='954822656' where itemid=47317;
      update items set lastclock=1365770616,lastns=540178712,prevorgvalue='20412991',prevvalue=lastvalue,lastvalue='110' where itemid=47616;
      update items set lastclock=1365770616,lastns=327193929 where itemid=50016;
      update items set lastclock=1365770616,lastns=483620055,prevvalue=lastvalue,lastvalue='0.285283' where itemid=50916;
      update items set lastclock=1365770609,lastns=109283839,prevvalue=lastvalue,lastvalue='1' where itemid=54509;
      update items set lastclock=1365770616,lastns=558854234,prevorgvalue='36673212',prevvalue=lastvalue,lastvalue='1' where itemid=54516;
      update items set lastclock=1365770616,lastns=553266161 where itemid=54816;
      update items set lastclock=1365770616,lastns=547901192,prevvalue=lastvalue,lastvalue='0' where itemid=55116;
      update items set lastclock=1365770616,lastns=549314815,prevvalue=lastvalue,lastvalue='47' where itemid=55416;
      update items set lastclock=1365770616,lastns=554931271 where itemid=56016;
      update items set lastclock=1365770616,lastns=550141456,prevvalue=lastvalue,lastvalue='4504125440' where itemid=57216;
      update items set lastclock=1365770616,lastns=551531260,prevvalue=lastvalue,lastvalue='21831680' where itemid=57816;
      update items set lastclock=1365770616,lastns=312446169,prevvalue=lastvalue,lastvalue='3007836160' where itemid=59016;
      update items set lastclock=1365770616,lastns=553843121,prevvalue=lastvalue,lastvalue='7.496334' where itemid=59616;
      update items set lastclock=1365770616,lastns=555852700,prevvalue=lastvalue,lastvalue='152662016' where itemid=60516;
      update items set lastclock=1365770616,lastns=711966030,prevvalue=lastvalue,lastvalue='5.700000' where itemid=63216;
      update items set lastclock=1365770616,lastns=286373353,prevvalue=lastvalue,lastvalue='0.000000' where itemid=65015;
      update items set lastclock=1365770616,lastns=545778074,prevorgvalue='179651698',prevvalue=lastvalue,lastvalue='1' where itemid=65616;
      update items set lastclock=1365770616,lastns=277285095,prevorgvalue='596743682',prevvalue=lastvalue,lastvalue='0' where itemid=65916;
      update items set lastclock=1365770616,lastns=545996487,prevorgvalue='1365194848',prevvalue=lastvalue,lastvalue='0' where itemid=66216;
      update items set lastclock=1365770617,lastns=232363082,prevorgvalue='241947359',prevvalue=lastvalue,lastvalue='103248' where itemid=66217;
      update items set lastclock=1365770616,lastns=274827460,prevorgvalue='1914242',prevvalue=lastvalue,lastvalue='0' where itemid=66516;
      update items set lastclock=1365770616,lastns=575203559,prevvalue=lastvalue,lastvalue='BRI0-Signaling' where itemid=69816;
      update items set lastclock=1365770617,lastns=159796611,prevvalue=lastvalue,lastvalue='FastEthernet1' where itemid=69817;
      update items set lastclock=1365770616,lastns=562796994,prevorgvalue='1977330113',prevvalue=lastvalue,lastvalue='58839' where itemid=70416;
      update items set lastclock=1365770616,lastns=543407177,prevvalue=lastvalue,lastvalue='0.000000' where itemid=72816;
      update items set lastclock=1365770616,lastns=558772588,prevorgvalue='3175569716',prevvalue=lastvalue,lastvalue='72443' where itemid=74016;
      update items set lastclock=1365770616,lastns=554321125,prevvalue=lastvalue,lastvalue='1077362688' where itemid=74916;
      update items set lastclock=1365770617,lastns=166681403,prevvalue=lastvalue,lastvalue='34942976' where itemid=75217;
      update items set lastclock=1365770616,lastns=567855625,prevvalue=lastvalue,lastvalue='1379442688' where itemid=75516;
      update items set lastclock=1365770616,lastns=306604099,prevorgvalue='681467035',prevvalue=lastvalue,lastvalue='0' where itemid=75816;
      update items set lastclock=1365770616,lastns=283279904,prevorgvalue='2953874046',prevvalue=lastvalue,lastvalue='36' where itemid=76116;
      update items set lastclock=1365770617,lastns=163824540,prevorgvalue='2257726301',prevvalue=lastvalue,lastvalue='0' where itemid=76117;
      update items set lastclock=1365770616,lastns=299912329,prevorgvalue='3259722099',prevvalue=lastvalue,lastvalue='22' where itemid=76416;
      update items set lastclock=1365770616,lastns=208954399,prevorgvalue='2204733624',prevvalue=lastvalue,lastvalue='0' where itemid=77316;
      update items set lastclock=1365770616,lastns=549401045,prevorgvalue='1468776541',prevvalue=lastvalue,lastvalue='1' where itemid=77616;
      update items set lastclock=1365770614,lastns=113732744,prevvalue=lastvalue,lastvalue='1' where itemid=78214;
      update items set lastclock=1365770616,lastns=555742358,prevvalue=lastvalue,lastvalue='0' where itemid=78216;
      update items set lastclock=1365770614,lastns=113732744,prevvalue=lastvalue,lastvalue='1' where itemid=78514;
      update items set lastclock=1365770616,lastns=548625418,prevvalue=lastvalue,lastvalue='5.140000' where itemid=78516;
      update items set lastclock=1365770616,lastns=295340895,prevvalue=lastvalue,lastvalue='0.000000' where itemid=79415;
      update items set lastclock=1365770616,lastns=557898105,prevvalue=lastvalue,lastvalue='1364458963' where itemid=79716;
      update items set lastclock=1365770616,lastns=431324072,prevvalue=lastvalue,lastvalue='0.000000' where itemid=80315;
      update items set lastclock=1365770616,lastns=301643544,prevvalue=lastvalue,lastvalue='0' where itemid=80616;
      update items set lastclock=1365770616,lastns=273485962,prevvalue=lastvalue,lastvalue='0.000000' where itemid=80915;
      update items set lastclock=1365770616,lastns=553947686,prevvalue=lastvalue,lastvalue='36298752' where itemid=81516;
      update items set lastclock=1365770616,lastns=539877971,prevvalue=lastvalue,lastvalue='593006592.000000' where itemid=81816;
      update items set lastclock=1365770616,lastns=578558878,prevvalue=lastvalue,lastvalue='1' where itemid=82416;
      update items set lastclock=1365770616,lastns=211642138,prevvalue=lastvalue,lastvalue='1469345792' where itemid=83016;
      update items set lastclock=1365770616,lastns=295715277,prevvalue=lastvalue,lastvalue='0.000000' where itemid=84515;
      update items set lastclock=1365770616,lastns=281757703,prevvalue=lastvalue,lastvalue='41624637440' where itemid=84816;
      update items set lastclock=1365770616,lastns=560488654,prevvalue=lastvalue,lastvalue='0' where itemid=124716;
      update items set lastclock=1365770616,lastns=584610137,prevvalue=lastvalue,lastvalue='802' where itemid=125016;
      update items set lastclock=1365770616,lastns=559884050,prevvalue=lastvalue,lastvalue='2147102720' where itemid=125916;
      update items set lastclock=1365770616,lastns=279234686,prevvalue=lastvalue,lastvalue='0.010000' where itemid=127716;
      update items set lastclock=1365770616,lastns=539674122,prevvalue=lastvalue,lastvalue='86.230798' where itemid=128016;
      update items set lastclock=1365770616,lastns=276869990,prevorgvalue='2417237630.000000',prevvalue=lastvalue,lastvalue='290.078352' where itemid=128616;
      update items set lastclock=1365770616,lastns=544227206,prevvalue=lastvalue,lastvalue='7857426432' where itemid=129516;
      update items set lastclock=1365770616,lastns=551772974,prevvalue=lastvalue,lastvalue='4.431420' where itemid=130116;
      update items set lastclock=1365770616,lastns=558238836,prevvalue=lastvalue,lastvalue='355373056.000000' where itemid=130416;
      update items set lastclock=1365770616,lastns=322599206,prevvalue=lastvalue,lastvalue='0.000000' where itemid=130716;
      update items set lastclock=1365770616,lastns=560727887,prevvalue=lastvalue,lastvalue='96.421415' where itemid=131016;
      update items set lastclock=1365770616,lastns=287153069,prevvalue=lastvalue,lastvalue='0.000000' where itemid=131315;
      update items set lastclock=1365770616,lastns=314450564,prevvalue=lastvalue,lastvalue='99.971008' where itemid=131616;
      update items set lastclock=1365770616,lastns=339997129,prevvalue=lastvalue,lastvalue='0.000000' where itemid=131915;
      update items set lastclock=1365770617,lastns=136731320,prevvalue=lastvalue,lastvalue='0.000000' where itemid=131916;
      update items set lastclock=1365770616,lastns=309114196,prevvalue=lastvalue,lastvalue='75.928587' where itemid=132216;
      update items set lastclock=1365770616,lastns=753618142,prevvalue=lastvalue,lastvalue='OK' where itemid=133112;
      update items set lastclock=1365770616,lastns=350603310,prevvalue=lastvalue,lastvalue='OK' where itemid=133114;
      update items set lastclock=1365770616,lastns=562923212,prevvalue=lastvalue,lastvalue='1' where itemid=133116;
      update items set lastclock=1365770616,lastns=547506186,prevvalue=lastvalue,lastvalue='8172924928' where itemid=133416;
      update items set lastclock=1365770616,lastns=543951747,prevorgvalue='10534114313385',prevvalue=lastvalue,lastvalue='64845' where itemid=136416;
      update items set lastclock=1365770617,lastns=228251079,prevvalue=lastvalue,lastvalue='0.762212' where itemid=136717;
      update items set lastclock=1365770616,lastns=552747122,prevvalue=lastvalue,lastvalue='99.383231' where itemid=137616;
      update items set lastclock=1365770616,lastns=123149521,prevvalue=lastvalue,lastvalue='0.000000' where itemid=142115;
      update items set lastclock=1365770616,lastns=561439019,prevvalue=lastvalue,lastvalue='0.300000' where itemid=142716;
      update items set lastclock=1365770616,lastns=541061381,prevvalue=lastvalue,lastvalue='0.021250' where itemid=143016;
      ]
      15529:20130412:124338.325 query [update items set lastclock=1365770616,lastns=561569156 where itemid=27816;
      update items set lastclock=1365770616,lastns=561579705,prevvalue=lastvalue,lastvalue='224' where itemid=28416;
      update items set lastclock=1365770616,lastns=302651170,prevvalue=lastvalue,lastvalue='613212160' where itemid=28716;
      update items set lastclock=1365770616,lastns=551991016,prevorgvalue='762111404',prevvalue=lastvalue,lastvalue='30' where itemid=29316;
      update items set lastclock=1365770617,lastns=169215296,prevorgvalue='118116762.000000',prevvalue=lastvalue,lastvalue='4.231995' where itemid=29317;
      update items set lastclock=1365770616,lastns=546063388,prevvalue=lastvalue,lastvalue='0.000000' where itemid=30816;
      update items set lastclock=1365770616,lastns=542054316,prevorgvalue='4832954719933',prevvalue=lastvalue,lastvalue='176368' where itemid=31116;
      update items set lastclock=1365770616,lastns=316427168,prevvalue=lastvalue,lastvalue='99.987835' where itemid=32316;
      update items set lastclock=1365770616,lastns=548915639,prevvalue=lastvalue,lastvalue='431656960.000000' where itemid=32916;
      update items set lastclock=1365770616,lastns=267261904,prevvalue=lastvalue,lastvalue='0.000000' where itemid=35015;
      update items set lastclock=1365770616,lastns=481598851,prevvalue=lastvalue,lastvalue='0.000000' where itemid=35315;
      update items set lastclock=1365770616,lastns=319833010,prevvalue=lastvalue,lastvalue='0.000000' where itemid=35615;
      update items set lastclock=1365770617,lastns=223887844,prevvalue=lastvalue,lastvalue='0.000000' where itemid=35616;
      update items set lastclock=1365770616,lastns=279684185,prevvalue=lastvalue,lastvalue='0.000000' where itemid=35916;
      update items set lastclock=1365770616,lastns=560938090,prevvalue=lastvalue,lastvalue='58.434954' where itemid=36216;
      update items set lastclock=1365770616,lastns=541687245,prevvalue=lastvalue,lastvalue='0.133333' where itemid=37116;
      update items set lastclock=1365770616,lastns=560763618,prevorgvalue='0',prevvalue=lastvalue,lastvalue='0' where itemid=38316;
      update items set lastclock=1365770616,lastns=569940112,prevorgvalue='2108535572',prevvalue=lastvalue,lastvalue='187168' where itemid=38616;
      update items set lastclock=1365770616,lastns=569692616,prevorgvalue='3214077800',prevvalue=lastvalue,lastvalue='16011388' where itemid=39216;
      update items set lastclock=1365770616,lastns=204900162,prevvalue=lastvalue,lastvalue='0.000000' where itemid=40415;
      update items set lastclock=1365770616,lastns=562987893,prevvalue=lastvalue,lastvalue='0.220000' where itemid=43416;
      update items set lastclock=1365770616,lastns=563620867,prevvalue=lastvalue,lastvalue='4788543488' where itemid=43716;
      update items set lastclock=1365770616,lastns=562166618,prevvalue=lastvalue,lastvalue='0.031107' where itemid=44916;
      update items set lastclock=1365770616,lastns=557792718,prevvalue=lastvalue,lastvalue='646864896' where itemid=47316;
      update items set lastclock=1365770617,lastns=226301020,prevvalue=lastvalue,lastvalue='954822656' where itemid=47317;
      update items set lastclock=1365770616,lastns=540178712,prevorgvalue='20412991',prevvalue=lastvalue,lastvalue='110' where itemid=47616;
      update items set lastclock=1365770616,lastns=327193929 where itemid=50016;
      update items set lastclock=1365770616,lastns=483620055,prevvalue=lastvalue,lastvalue='0.285283' where itemid=50916;
      update items set lastclock=1365770609,lastns=109283839,prevvalue=lastvalue,lastvalue='1' where itemid=54509;
      update items set lastclock=1365770616,lastns=558854234,prevorgvalue='36673212',prevvalue=lastvalue,lastvalue='1' where itemid=54516;
      update items set lastclock=1365770616,lastns=553266161 where itemid=54816;
      update items set lastclock=1365770616,lastns=547901192,prevvalue=lastvalue,lastvalue='0' where itemid=55116;
      update items set lastclock=1365770616,lastns=549314815,prevvalue=lastvalue,lastvalue='47' where itemid=55416;
      update items set lastclock=1365770616,lastns=554931271 where itemid=56016;
      update items set lastclock=1365770616,lastns=550141456,prevvalue=lastvalue,lastvalue='4504125440' where itemid=57216;
      update items set lastclock=1365770616,lastns=551531260,prevvalue=lastvalue,lastvalue='21831680' where itemid=57816;
      update items set lastclock=1365770616,lastns=312446169,prevvalue=lastvalue,lastvalue='3007836160' where itemid=59016;
      update items set lastclock=1365770616,lastns=553843121,prevvalue=lastvalue,lastvalue='7.496334' where itemid=59616;
      update items set lastclock=1365770616,lastns=555852700,prevvalue=lastvalue,lastvalue='152662016' where itemid=60516;
      update items set lastclock=1365770616,lastns=711966030,prevvalue=lastvalue,lastvalue='5.700000' where itemid=63216;
      update items set lastclock=1365770616,lastns=286373353,prevvalue=lastvalue,lastvalue='0.000000' where itemid=65015;
      update items set lastclock=1365770616,lastns=545778074,prevorgvalue='179651698',prevvalue=lastvalue,lastvalue='1' where itemid=65616;
      update items set lastclock=1365770616,lastns=277285095,prevorgvalue='596743682',prevvalue=lastvalue,lastvalue='0' where itemid=65916;
      update items set lastclock=1365770616,lastns=545996487,prevorgvalue='1365194848',prevvalue=lastvalue,lastvalue='0' where itemid=66216;
      update items set lastclock=1365770617,lastns=232363082,prevorgvalue='241947359',prevvalue=lastvalue,lastvalue='103248' where itemid=66217;
      update items set lastclock=1365770616,lastns=274827460,prevorgvalue='1914242',prevvalue=lastvalue,lastvalue='0' where itemid=66516;
      update items set lastclock=1365770616,lastns=575203559,prevvalue=lastvalue,lastvalue='BRI0-Signaling' where itemid=69816;
      update items set lastclock=1365770617,lastns=159796611,prevvalue=lastvalue,lastvalue='FastEthernet1' where itemid=69817;
      update items set lastclock=1365770616,lastns=562796994,prevorgvalue='1977330113',prevvalue=lastvalue,lastvalue='58839' where itemid=70416;
      update items set lastclock=1365770616,lastns=543407177,prevvalue=lastvalue,lastvalue='0.000000' where itemid=72816;
      update items set lastclock=1365770616,lastns=558772588,prevorgvalue='3175569716',prevvalue=lastvalue,lastvalue='72443' where itemid=74016;
      update items set lastclock=1365770616,lastns=554321125,prevvalue=lastvalue,lastvalue='1077362688' where itemid=74916;
      update items set lastclock=1365770617,lastns=166681403,prevvalue=lastvalue,lastvalue='34942976' where itemid=75217;
      update items set lastclock=1365770616,lastns=567855625,prevvalue=lastvalue,lastvalue='1379442688' where itemid=75516;
      update items set lastclock=1365770616,lastns=306604099,prevorgvalue='681467035',prevvalue=lastvalue,lastvalue='0' where itemid=75816;
      update items set lastclock=1365770616,lastns=283279904,prevorgvalue='2953874046',prevvalue=lastvalue,lastvalue='36' where itemid=76116;
      update items set lastclock=1365770617,lastns=163824540,prevorgvalue='2257726301',prevvalue=lastvalue,lastvalue='0' where itemid=76117;
      update items set lastclock=1365770616,lastns=299912329,prevorgvalue='3259722099',prevvalue=lastvalue,lastvalue='22' where itemid=76416;
      update items set lastclock=1365770616,lastns=208954399,prevorgvalue='2204733624',prevvalue=lastvalue,lastvalue='0' where itemid=77316;
      update items set lastclock=1365770616,lastns=549401045,prevorgvalue='1468776541',prevvalue=lastvalue,lastvalue='1' where itemid=77616;
      update items set lastclock=1365770614,lastns=113732744,prevvalue=lastvalue,lastvalue='1' where itemid=78214;
      update items set lastclock=1365770616,lastns=555742358,prevvalue=lastvalue,lastvalue='0' where itemid=78216;
      update items set lastclock=1365770614,lastns=113732744,prevvalue=lastvalue,lastvalue='1' where itemid=78514;
      update items set lastclock=1365770616,lastns=548625418,prevvalue=lastvalue,lastvalue='5.140000' where itemid=78516;
      update items set lastclock=1365770616,lastns=295340895,prevvalue=lastvalue,lastvalue='0.000000' where itemid=79415;
      update items set lastclock=1365770616,lastns=557898105,prevvalue=lastvalue,lastvalue='1364458963' where itemid=79716;
      update items set lastclock=1365770616,lastns=431324072,prevvalue=lastvalue,lastvalue='0.000000' where itemid=80315;
      update items set lastclock=1365770616,lastns=301643544,prevvalue=lastvalue,lastvalue='0' where itemid=80616;
      update items set lastclock=1365770616,lastns=273485962,prevvalue=lastvalue,lastvalue='0.000000' where itemid=80915;
      update items set lastclock=1365770616,lastns=553947686,prevvalue=lastvalue,lastvalue='36298752' where itemid=81516;
      update items set lastclock=1365770616,lastns=539877971,prevvalue=lastvalue,lastvalue='593006592.000000' where itemid=81816;
      update items set lastclock=1365770616,lastns=578558878,prevvalue=lastvalue,lastvalue='1' where itemid=82416;
      update items set lastclock=1365770616,lastns=211642138,prevvalue=lastvalue,lastvalue='1469345792' where itemid=83016;
      update items set lastclock=1365770616,lastns=295715277,prevvalue=lastvalue,lastvalue='0.000000' where itemid=84515;
      update items set lastclock=1365770616,lastns=281757703,prevvalue=lastvalue,lastvalue='41624637440' where itemid=84816;
      update items set lastclock=1365770616,lastns=560488654,prevvalue=lastvalue,lastvalue='0' where itemid=124716;
      update items set lastclock=1365770616,lastns=584610137,prevvalue=lastvalue,lastvalue='802' where itemid=125016;
      update items set lastclock=1365770616,lastns=559884050,prevvalue=lastvalue,lastvalue='2147102720' where itemid=125916;
      update items set lastclock=1365770616,lastns=279234686,prevvalue=lastvalue,lastvalue='0.010000' where itemid=127716;
      update items set lastclock=1365770616,lastns=539674122,prevvalue=lastvalue,lastvalue='86.230798' where itemid=128016;
      update items set lastclock=1365770616,lastns=276869990,prevorgvalue='2417237630.000000',prevvalue=lastvalue,lastvalue='290.078352' where itemid=128616;
      update items set lastclock=1365770616,lastns=544227206,prevvalue=lastvalue,lastvalue='7857426432' where itemid=129516;
      update items set lastclock=1365770616,lastns=551772974,prevvalue=lastvalue,lastvalue='4.431420' where itemid=130116;
      update items set lastclock=1365770616,lastns=558238836,prevvalue=lastvalue,lastvalue='355373056.000000' where itemid=130416;
      update items set lastclock=1365770616,lastns=322599206,prevvalue=lastvalue,lastvalue='0.000000' where itemid=130716;
      update items set lastclock=1365770616,lastns=560727887,prevvalue=lastvalue,lastvalue='96.421415' where itemid=131016;
      update items set lastclock=1365770616,lastns=287153069,prevvalue=lastvalue,lastvalue='0.000000' where itemid=131315;
      update items set lastclock=1365770616,lastns=314450564,prevvalue=lastvalue,lastvalue='99.971008' where itemid=131616;
      update items set lastclock=1365770616,lastns=339997129,prevvalue=lastvalue,lastvalue='0.000000' where itemid=131915;
      update items set lastclock=1365770617,lastns=136731320,prevvalue=lastvalue,lastvalue='0.000000' where itemid=131916;
      update items set lastclock=1365770616,lastns=309114196,prevvalue=lastvalue,lastvalue='75.928587' where itemid=132216;
      update items set lastclock=1365770616,lastns=753618142,prevvalue=lastvalue,lastvalue='OK' where itemid=133112;
      update items set lastclock=1365770616,lastns=350603310,prevvalue=lastvalue,lastvalue='OK' where itemid=133114;
      update items set lastclock=1365770616,lastns=562923212,prevvalue=lastvalue,lastvalue='1' where itemid=133116;
      update items set lastclock=1365770616,lastns=547506186,prevvalue=lastvalue,lastvalue='8172924928' where itemid=133416;
      update items set lastclock=1365770616,lastns=543951747,prevorgvalue='10534114313385',prevvalue=lastvalue,lastvalue='64845' where itemid=136416;
      update items set lastclock=1365770617,lastns=228251079,prevvalue=lastvalue,lastvalue='0.762212' where itemid=136717;
      update items set lastclock=1365770616,lastns=552747122,prevvalue=lastvalue,lastvalue='99.383231' where itemid=137616;
      update items set lastclock=1365770616,lastns=123149521,prevvalue=lastvalue,lastvalue='0.000000' where itemid=142115;
      update items set lastclock=1365770616,lastns=561439019,prevvalue=lastvalue,lastvalue='0.300000' where itemid=142716;
      update items set lastclock=1365770616,lastns=541061381,prevvalue=lastvalue,lastvalue='0.021250' where itemid=143016;
      ] failed, setting transaction as failed
      15529:20130412:124338.325 End of DCmass_update_items()

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              krimson Jasper Spit
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: