-
Problem report
-
Resolution: Fixed
-
Critical
-
5.0.24
-
None
-
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
- depends on
-
ZBX-20419 A deadlock occurred in lld worker (ids)
- Closed