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

Deadlock/stacktrace on tag update

    XMLWordPrintable

Details

    • Incident report
    • Status: Closed
    • Trivial
    • Resolution: Won't fix
    • 5.2.0
    • None
    • Server (S)
    • None

    Description

      Steps to reproduce:

      1. Update tag on Template
      2. May require poor performance for MySQL Server 8.0

      Result:

      1589987:20201130:130933.819 [Z3005] query failed: [1213] Deadlock found when trying to get lock; try restarting transaction [update ids set nextid=nextid+58 where table_name='trigger_tag' and field_name='triggertagid']zabbix_server [1589987]: ERROR [file:db.c,line:824] Something impossible has just happened.1589987:20201130:130933.832 === Backtrace: ===1589987:20201130:130933.874 13: /usr/sbin/zabbix_server: lld worker #1 [processed 8 LLD rules, idle 5.561231 sec during 6.253115 sec](zbx_backtrace+0x52) [0x5606d245e179]1589987:20201130:130933.874 12: /usr/sbin/zabbix_server: lld worker #1 [processed 8 LLD rules, idle 5.561231 sec during 6.253115 sec](+0x263a7a) [0x5606d24d1a7a]1589987:20201130:130933.874 11: /usr/sbin/zabbix_server: lld worker #1 [processed 8 LLD rules, idle 5.561231 sec during 6.253115 sec](DBget_maxid_num+0x112) [0x5606d24d1c1e]1589987:20201130:130933.874 10: /usr/sbin/zabbix_server: lld worker #1 [processed 8 LLD rules, idle 5.561231 sec during 6.253115 sec](+0x15c018) [0x5606d23ca018]1589987:20201130:130933.874 9: /usr/sbin/zabbix_server: lld worker #1 [processed 8 LLD rules, idle 5.561231 sec during 6.253115 sec](lld_update_triggers+0x2e9) [0x5606d23ccd36]1589987:20201130:130933.874 8: /usr/sbin/zabbix_server: lld worker #1 [processed 8 LLD rules, idle 5.561231 sec during 6.253115 sec](lld_process_discovery_rule+0x5a1) [0x5606d23a44dd]1589987:20201130:130933.874 7: /usr/sbin/zabbix_server: lld worker #1 [processed 8 LLD rules, idle 5.561231 sec during 6.253115 sec](+0x1328ad) [0x5606d23a08ad]1589987:20201130:130933.874 6: /usr/sbin/zabbix_server: lld worker #1 [processed 8 LLD rules, idle 5.561231 sec during 6.253115 sec](lld_worker_thread+0x36c) [0x5606d23a0ff8]1589987:20201130:130933.874 5: /usr/sbin/zabbix_server: lld worker #1 [processed 8 LLD rules, idle 5.561231 sec during 6.253115 sec](zbx_thread_start+0x3b) [0x5606d246dfae]1589987:20201130:130933.874 4: /usr/sbin/zabbix_server: lld worker #1 [processed 8 LLD rules, idle 5.561231 sec during 6.253115 sec](MAIN_ZABBIX_ENTRY+0xfd2) [0x5606d22b88d3]1589987:20201130:130933.874 3: /usr/sbin/zabbix_server: lld worker #1 [processed 8 LLD rules, idle 5.561231 sec during 6.253115 sec](daemon_start+0x303) [0x5606d245dcbb]1589987:20201130:130933.874 2: /usr/sbin/zabbix_server: lld worker #1 [processed 8 LLD rules, idle 5.561231 sec during 6.253115 sec](main+0x309) [0x5606d22b789e]1589987:20201130:130933.874 1: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0x7f6d7bcb90b3]1589987:20201130:130933.874 0: /usr/sbin/zabbix_server: lld worker #1 [processed 8 LLD rules, idle 5.561231 sec during 6.253115 sec](_start+0x2e) [0x5606d22b688e]
      

      Expected:

      No deadlocks, no thread crashes when updating a tag on a Template.

      Attachments

        Activity

          People

            igorbach Igor Gorbach
            clontarfx@gmail.com Shane Arnold
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: