[ZBX-8210] Zabbix server crashed on Oracle DB Created: 2014 May 14  Updated: 2017 May 30  Resolved: 2014 May 20

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 2.2.3
Fix Version/s: 2.2.4rc1, 2.3.0

Type: Incident report Priority: Blocker
Reporter: Kodai Terashima Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: crash, eventlog, oracle, valuecache
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: Text File oracle-crash.log    
Issue Links:
Duplicate
is duplicated by ZBX-8257 A crash in history syncer possibly du... Closed

 Description   

Zabbix server crashed on Oracle DB.

12339:20140513:093128.227 In zbx_vc_get_value_range() itemid:52956 value_type:2 seconds:0 count:1 timestamp:1399941084
12339:20140513:093128.227 End of zbx_vc_get_value_range():SUCCEED count:1 cached:1
12339:20140513:093128.227 Got signal [signal:11(SIGSEGV),reason:1,refaddr:(nil)]. Crashing ...



 Comments   
Comment by Oleksii Zagorskyi [ 2014 May 14 ]

Bcktrace from attached log:

 12339:20140513:093128.227 === Backtrace: ===
 12339:20140513:093128.232 11: /usr/local/sbin/zabbix_server: history syncer #3 [synced 139 items in 0.085522 sec, syncing history](print_fatal_info+0xcd) [0x461e6d]
 12339:20140513:093128.232 10: /usr/local/sbin/zabbix_server: history syncer #3 [synced 139 items in 0.085522 sec, syncing history] [0x4625f9]
 12339:20140513:093128.232 9: /lib64/libc.so.6 [0x3fe02302f0]
 12339:20140513:093128.232 8: /lib64/libc.so.6(strcmp+0) [0x3fe0277ef0]
 12339:20140513:093128.232 7: /usr/local/sbin/zabbix_server: history syncer #3 [synced 139 items in 0.085522 sec, syncing history](evaluate_function+0x1152) [0x477392]
 12339:20140513:093128.232 6: /usr/local/sbin/zabbix_server: history syncer #3 [synced 139 items in 0.085522 sec, syncing history](evaluate_expressions+0x9bc) [0x47f8fc]
 12339:20140513:093128.232 5: /usr/local/sbin/zabbix_server: history syncer #3 [synced 139 items in 0.085522 sec, syncing history](DCsync_history+0x17a0) [0x44e0f0]
 12339:20140513:093128.232 4: /usr/local/sbin/zabbix_server: history syncer #3 [synced 139 items in 0.085522 sec, syncing history](main_dbsyncer_loop+0x148) [0x418b68]
 12339:20140513:093128.233 3: /usr/local/sbin/zabbix_server: history syncer #3 [synced 139 items in 0.085522 sec, syncing history](MAIN_ZABBIX_ENTRY+0x943) [0x417d53]
 12339:20140513:093128.233 2: /usr/local/sbin/zabbix_server: history syncer #3 [synced 139 items in 0.085522 sec, syncing history](daemon_start+0x1af) [0x46152f]
 12339:20140513:093128.233 1: /lib64/libc.so.6(__libc_start_main+0xf4) [0x3fe021d994]
 12339:20140513:093128.233 0: /usr/local/sbin/zabbix_server: history syncer #3 [synced 139 items in 0.085522 sec, syncing history] [0x412f29]
Comment by Juris Miščenko (Inactive) [ 2014 May 16 ]

Fix for 2.2 available at svn://svn.zabbix.com/branches/dev/ZBX-8210

Comment by Alexander Vladishev [ 2014 May 20 ]

The problem doesn't related to Oracle backend.

It can caused while processing of logsource() trigger function.

Comment by Juris Miščenko (Inactive) [ 2014 May 20 ]

Fix merged in 2.2.4rc1 r45677, 2.3.0 (trunk) r45679

Generated at Fri Apr 19 16:49:25 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.