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

A deadlock occurred in lld worker (ids)

XMLWordPrintable

    • Sprint 90 (Jul 2022)
    • 0.25

      Report for investigation:
      Deadlock output below from the LLD Worker. (Zabbix 5.0.21):

       23195:20220614:120513.150 [Z3005] query failed: [-1] ORA-00060: deadlock detected while waiting for resource [update ids set nextid=nextid+1 where table_name='applications' and field_name='applicationid']
       23195:20220614:120513.150 slow query: 9.876933 sec, "update ids set nextid=nextid+1 where table_name='applications' and field_name='applicationid'"
      zabbix_server [23195]: ERROR [file and function: <db.c,DBget_nextid>, revision:313ff6504e3, line:824] Something impossible has just happened.
       23195:20220614:120513.150 === Backtrace: ===
       23195:20220614:120513.151 11: /usr/local/zabbix/sbin/zabbix_server: lld worker #5 [processed 2 LLD rules, idle 8.152632 sec during 26.677700 sec](zbx_backtrace+0x35) [0x53e535]
       23195:20220614:120513.151 10: /usr/local/zabbix/sbin/zabbix_server: lld worker #5 [processed 2 LLD rules, idle 8.152632 sec during 26.677700 sec](DBget_maxid_num+0x223) [0x58cf13]
       23195:20220614:120513.151 9: /usr/local/zabbix/sbin/zabbix_server: lld worker #5 [processed 2 LLD rules, idle 8.152632 sec during 26.677700 sec]() [0x4cff95]
       23195:20220614:120513.151 8: /usr/local/zabbix/sbin/zabbix_server: lld worker #5 [processed 2 LLD rules, idle 8.152632 sec during 26.677700 sec](lld_update_items+0x2bd9) [0x4d6859]
       23195:20220614:120513.151 7: /usr/local/zabbix/sbin/zabbix_server: lld worker #5 [processed 2 LLD rules, idle 8.152632 sec during 26.677700 sec](lld_process_discovery_rule+0x941) [0x4c1291]
       23195:20220614:120513.151 6: /usr/local/zabbix/sbin/zabbix_server: lld worker #5 [processed 2 LLD rules, idle 8.152632 sec during 26.677700 sec](lld_worker_thread+0x77c) [0x4bf3ec]
       23195:20220614:120513.151 5: /usr/local/zabbix/sbin/zabbix_server: lld worker #5 [processed 2 LLD rules, idle 8.152632 sec during 26.677700 sec](zbx_thread_start+0x3e) [0x548d9e]
       23195:20220614:120513.151 4: /usr/local/zabbix/sbin/zabbix_server: lld worker #5 [processed 2 LLD rules, idle 8.152632 sec during 26.677700 sec](MAIN_ZABBIX_ENTRY+0x6be) [0x43099e]
       23195:20220614:120513.151 3: /usr/local/zabbix/sbin/zabbix_server: lld worker #5 [processed 2 LLD rules, idle 8.152632 sec during 26.677700 sec](daemon_start+0x1b2) [0x53e2f2]
       23195:20220614:120513.151 2: /usr/local/zabbix/sbin/zabbix_server: lld worker #5 [processed 2 LLD rules, idle 8.152632 sec during 26.677700 sec](main+0x3da) [0x42faaa]
       23195:20220614:120513.151 1: /lib64/libc.so.6(__libc_start_main+0xf5) [0x7f9a72934555]
       23195:20220614:120513.151 0: /usr/local/zabbix/sbin/zabbix_server: lld worker #5 [processed 2 LLD rules, idle 8.152632 sec during 26.677700 sec]() [0x42fd97]
      

      Because of that we have the following right after deadlock issue:

       23195:20220614:120513.151 [Z3007] query failed: [-1] ORA-01036: illegal variable name/number
       23195:20220614:120513.151 [Z3007] query failed: [-1] ORA-01036: illegal variable name/number
       23195:20220614:120513.151 [Z3007] query failed: [-1] ORA-01036: illegal variable name/number
      

            wiper Andris Zeila
            dotneft Alexey Pustovalov
            Team A
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved: