Database deadlock and zabbix_sender

XMLWordPrintable

    • Type: Incident report
    • Resolution: Cannot Reproduce
    • Priority: Major
    • None
    • Affects Version/s: 2.2.4
    • Component/s: Server (S)
    • Environment:
      Centos 6.5 installed from zabbix repo

      We use a zabbix_send to send some data to zabbix server, sometimes we lose some values, there is no error with zabbix_send command but there is a deadlock message in zabbix server log.

      5272:20140905:112846.983 [Z3005] query failed: [1213] Deadlock found when
      trying to get lock; try restarting transaction [insert into history (itemid,
      clock,ns,value) values (23924,1409909324,652099333,97.382080),(24704,
      1409909324,657767674,0.910510),(23264,1409909324,657767677,2.071186),(24584,
      1409909324,662823990,98.645050),(24104,1409909324,667969311,97.381378),
      (24404,1409909324,686709908,0.000000),(25036,1409909324,1689478,1.008725),
      (25037,1409909325,1689482,1.002255),(25038,1409909325,1689486,0.993211),
      (25039,1409909325,1689490,1.001397),(25026,1409909325,1689491,19.761384),
      (25035,1409909325,1689492,7.725000),(25040,1409909325,1689496,1.001397),
      (25027,1409909325,1689497,19.761384),(25028,1409909325,1689498,1.000000),
      (24967,1409909325,1689499,4.905467),(24968,1409909325,1689503,4.909267),
      (24705,1409909325,669177564,0.000000),(23265,1409909325,669207487,0.000000),
      (24225,1409909325,676410392,97.397430),(23625,1409909325,676444448,9.907282),
      (24345,1409909325,680195499,85.465894),(24969,1409909325,1689507,4.837822),
      (24105,1409909325,685184471,99.982815),(23925,1409909325,698488232,
      99.982815),(24405,1409909325,700201431,1.010014),(24970,1409909324,1689511,
      4.884186),(24957,1409909324,1689512,44.516497),(24966,1409909324,1689513,
      25.412500),(24971,1409909324,1689517,4.884186),(24958,1409909325,1689518,
      44.516497),(24959,1409909325,1689519,1.000000),(24706,1409909326,704295904,
      1.244886),(24406,1409909326,710867873,11.688536),(23266,1409909326,710907212,
      0.000000),(24106,1409909326,714339513,99.999833),(24346,1409909326,723155112,
      91.462517),(23926,1409909326,724210167,99.998625),(25126,1409909326,
      726541829,100.000000),(24226,1409909326,728341968,99.982815);
      ]

            Assignee:
            Unassigned
            Reporter:
            Tomasz Zielinski
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: