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

Details

    • Incident report
    • Status: Needs documenting
    • Minor
    • Resolution: Unresolved
    • 5.0.25
    • None
    • Server (S)
    • Team B
    • Support backlog
    • 0.1

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

              zabbix.dev Zabbix Development Team
              JKKim Kim Jongkwon
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated: