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

A deadlock occurred in lld worker (item_discovery)

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Fixed
    • Icon: Minor Minor
    • 6.4 (plan)
    • 5.0.25
    • Server (S)
    • Sprint 93 (Oct 2022), Sprint 94 (Nov 2022)
    • 0.1

      Deadlock is occurring in many LLDs using Zabbix Sender.

      *** (1) TRANSACTION:
      update item_discovery set lastcheck=1660366916 where (itemid in (154810,154811,154812,154813,154814,154815,154816,154817,154818,154819,154820,154821,154822,154823,154824,154825,154826,154827,154828,154829,154830,154831,154832,154833,154834,154835,154836,154837,154838,154839,154840,154841,154842,154843,154844,154845,154846,154847,154848,154849,154850,154851,154852,154853,154854,154855,154856,154857,154858,154859,154860,154861,154862,154863,154864,154865,154866,154867,154868,154869,154870,154871,154872,154873,154874,154875,154876,154877,154878,154879,154880,154881,154882,154883,154884,154885,154886,154887,154888,154889,154890,154891,154892,154893,154894,154895,154896,154897,154898,154899,154900,154901,154902,154903,154904,154905,154906,154907,154908,154909,154910,154911,154912,154913,154914,154915,154916,154917,154918,154919,154920,154921,154922,154923,154924,154925,154926,154927,154928,154929,154930,154931
      
      *** (2) TRANSACTION:
      update item_discovery set lastcheck=1660366915 where (itemid in (148150,148151,148152,148153,148154,148155,148156,148157,148158,148159,148160,148161,148162,148163,148164,148165,148166,148167,148168,148169,148170,148171,148172,148173,148174,148175,148176,148177,148178,148179,148180,148181,148182,148183,148184,148185,148186,148187,148188,148189,148190,148191,148192,148193,148194,148195,148196,148197,148198,148199,148200,148201,148202,148203,148204,148205,148206,148207,148208,148209,148210,148211,148212,148213,148214,148215,148216,148217,148218,148219,148220,148221,148222,148223,148224,148225,148226,148227,148228,148229,148230,148231,148232,148233,148234,148235,148236,148237,148238,148239,148240,148241,148242,148243,148244,148245,148246,148247,148248,148249,148250,148251,148252,148253,148254,148255,148256,148257,148258,148259,148260,148261,148262,148263,148264,148265,148266,148267,148268,148269,148270,148271
      

      This does not occur with StartLLDProcessors=1.
      It can be reproduced by 2 or more LLD Workers.

      More details are in the attachment files.

        1. INNODB_OUTPUT.txt
          71 kB
          Kim Jongkwon
        2. zabbix_server_deadlock.log
          4.46 MB
          Kim Jongkwon
        3. zbx_export_hosts(3).xml
          3 kB
          Michael Veksler
        4. zbx_export_templates(1).xml
          6 kB
          Michael Veksler

            MVekslers Michael Veksler
            JKKim Kim Jongkwon
            Team B
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved: