[ZBX-19986] zabbix_server [3973741]: ERROR [file and function: <lld_item.c,lld_items_get>, revision:1765c4f1bc, line:817] Something impossible has just happened. Created: 2021 Sep 20  Updated: 2024 Apr 10  Resolved: 2021 Sep 21

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 5.4.4
Fix Version/s: None

Type: Problem report Priority: Trivial
Reporter: xffan Assignee: user-e65a8 (Inactive)
Resolution: Fixed Votes: 0
Labels: lld
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

centos8.4 timescaledb

Attachments: Text File zabbix_server.log    
Issue Links:
Sub-task
part of ZBX-19964 ERROR [file and function: <lld_item.c... Closed
Team: Team A

 Description   

Upgrade zabbix datebase from mysql to timescaledb,find many error in zabbix-server.log

zabbix_server [3973741]: ERROR [file and function: <lld_item.c,lld_items_get>, revision:1765c4f1bc, line:817] Something impossible has just happened.
3973741:20210920:143957.496 === Backtrace: ===
3973741:20210920:143957.496 11: /usr/sbin/zabbix_server: lld worker #1 [processed 21 LLD rules, idle 4.663205 sec during 5.068758 sec](zbx_backtrace+0x3f) [0x5651f780503a]
3973741:20210920:143957.496 10: /usr/sbin/zabbix_server: lld worker #1 [processed 21 LLD rules, idle 4.663205 sec during 5.068758 sec](+0x156444) [0x5651f7747444]
3973741:20210920:143957.496 9: /usr/sbin/zabbix_server: lld worker #1 [processed 21 LLD rules, idle 4.663205 sec during 5.068758 sec](lld_update_items+0xea) [0x5651f77528a0]
3973741:20210920:143957.496 8: /usr/sbin/zabbix_server: lld worker #1 [processed 21 LLD rules, idle 4.663205 sec during 5.068758 sec](lld_process_discovery_rule+0x47e) [0x5651f7735968]
3973741:20210920:143957.496 7: /usr/sbin/zabbix_server: lld worker #1 [processed 21 LLD rules, idle 4.663205 sec during 5.068758 sec](+0x141717) [0x5651f7732717]
3973741:20210920:143957.496 6: /usr/sbin/zabbix_server: lld worker #1 [processed 21 LLD rules, idle 4.663205 sec during 5.068758 sec](lld_worker_thread+0x2f6) [0x5651f7732d77]
3973741:20210920:143957.496 5: /usr/sbin/zabbix_server: lld worker #1 [processed 21 LLD rules, idle 4.663205 sec during 5.068758 sec](zbx_thread_start+0x37) [0x5651f7814f8b]
3973741:20210920:143957.496 4: /usr/sbin/zabbix_server: lld worker #1 [processed 21 LLD rules, idle 4.663205 sec during 5.068758 sec](MAIN_ZABBIX_ENTRY+0x10de) [0x5651f76462a2]
3973741:20210920:143957.496 3: /usr/sbin/zabbix_server: lld worker #1 [processed 21 LLD rules, idle 4.663205 sec during 5.068758 sec](daemon_start+0x2ff) [0x5651f7804c64]
3973741:20210920:143957.496 2: /usr/sbin/zabbix_server: lld worker #1 [processed 21 LLD rules, idle 4.663205 sec during 5.068758 sec](main+0x2f6) [0x5651f76450f0]
3973741:20210920:143957.496 1: /lib64/libc.so.6(__libc_start_main+0xf3) [0x7f2508f6b493]
3973741:20210920:143957.496 0: /usr/sbin/zabbix_server: lld worker #1 [processed 21 LLD rules, idle 4.663205 sec during 5.068758 sec](_start+0x2e) [0x5651f7643fee]
zabbix_server [3973741]: ERROR [file and function: <lld_item.c,lld_items_get>, revision:1765c4f1bc, line:817] Something impossible has just happened.
3973741:20210920:143957.496 === Backtrace: ===
3973741:20210920:143957.497 11: /usr/sbin/zabbix_server: lld worker #1 [processed 21 LLD rules, idle 4.663205 sec during 5.068758 sec](zbx_backtrace+0x3f) [0x5651f780503a]
3973741:20210920:143957.497 10: /usr/sbin/zabbix_server: lld worker #1 [processed 21 LLD rules, idle 4.663205 sec during 5.068758 sec](+0x156444) [0x5651f7747444]
3973741:20210920:143957.497 9: /usr/sbin/zabbix_server: lld worker #1 [processed 21 LLD rules, idle 4.663205 sec during 5.068758 sec](lld_update_items+0xea) [0x5651f77528a0]
3973741:20210920:143957.497 8: /usr/sbin/zabbix_server: lld worker #1 [processed 21 LLD rules, idle 4.663205 sec during 5.068758 sec](lld_process_discovery_rule+0x47e) [0x5651f7735968]
3973741:20210920:143957.497 7: /usr/sbin/zabbix_server: lld worker #1 [processed 21 LLD rules, idle 4.663205 sec during 5.068758 sec](+0x141717) [0x5651f7732717]
3973741:20210920:143957.497 6: /usr/sbin/zabbix_server: lld worker #1 [processed 21 LLD rules, idle 4.663205 sec during 5.068758 sec](lld_worker_thread+0x2f6) [0x5651f7732d77]
3973741:20210920:143957.497 5: /usr/sbin/zabbix_server: lld worker #1 [processed 21 LLD rules, idle 4.663205 sec during 5.068758 sec](zbx_thread_start+0x37) [0x5651f7814f8b]
3973741:20210920:143957.497 4: /usr/sbin/zabbix_server: lld worker #1 [processed 21 LLD rules, idle 4.663205 sec during 5.068758 sec](MAIN_ZABBIX_ENTRY+0x10de) [0x5651f76462a2]
3973741:20210920:143957.497 3: /usr/sbin/zabbix_server: lld worker #1 [processed 21 LLD rules, idle 4.663205 sec during 5.068758 sec](daemon_start+0x2ff) [0x5651f7804c64]
3973741:20210920:143957.497 2: /usr/sbin/zabbix_server: lld worker #1 [processed 21 LLD rules, idle 4.663205 sec during 5.068758 sec](main+0x2f6) [0x5651f76450f0]
3973741:20210920:143957.497 1: /lib64/libc.so.6(__libc_start_main+0xf3) [0x7f2508f6b493]
3973741:20210920:143957.497 0: /usr/sbin/zabbix_server: lld worker #1 [processed 21 LLD rules, idle 4.663205 sec during 5.068758 sec](_start+0x2e) [0x5651f7643fee]


 Comments   
Comment by user-e65a8 (Inactive) [ 2021 Sep 20 ]

Hello,

Thank you for reporting this.

Could you please clarify the versions of the databases that you are using and whether the templates were updated.

Thank you in advance.

 

Best regards, 

Tatiana

Comment by xffan [ 2021 Sep 20 ]

Thanks .  I solved the problem like ZBX-17116.

i used pgloader for load mysql data into PostgreSQL. i disabled foreign key.So it led to this problem.

i am running this sql:

select * from item_discovery a where not exists (select null from items b where a.itemid = b.itemid);

and delete it:

delete from item_discovery a where not exists (select null from items b where a.itemid = b.itemid);

finally i enabled foreign key.

Comment by user-e65a8 (Inactive) [ 2021 Sep 21 ]

Hello, 

Thank you for reporting the issue. We will close this ticket.

 

Best regards,

Tatiana

Generated at Fri Apr 18 13:51:34 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.