[ZBX-13554] Zabbix server crash with new item db.odbc.discovery Created: 2018 Feb 28  Updated: 2019 Feb 28  Resolved: 2018 Feb 28

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Proxy (P), Server (S)
Affects Version/s: 3.4.6, 4.0.0alpha1
Fix Version/s: None

Type: Incident report Priority: Major
Reporter: majki Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: crash, items, odbc
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Centos 7

Attachments: HTML File logs    
Issue Links:
Duplicate
duplicates ZBX-10654 Zabbix Server 3.0.1 crash shortly aft... Closed

 Description   

The Zabbix server is crashig
We configure new item db.odbc.discovery[mysql,test] in zabbix frontend
the dsn to base mysql version is working
isql test goes ok, we can connect to database
query returns values.
Version of mysql server-> 5.5.41-0+wheezy(remote machine)
Version of my sql on client We use [MySQL ODBC 5.3 ANSI Driver]Driver=/usr/lib64/libmyodbc5a.so(Local machine)
logs from zabbix_server in file logs attachment

zabbix_get -s 127.0.0.1 -k db.odbc.select[mysql,test]
ZBX_NOTSUPPORTED: Unsupported item key.

Regards
Majk

 Comments   
Comment by Andris Mednis [ 2018 Feb 28 ]

Relevant log file part:

 19151:20180228:140609.739 Got signal [signal:11(SIGSEGV),reason:1,refaddr:(nil)]. Crashing ...
 ...
 19151:20180228:140609.742 === Backtrace: ===
 19151:20180228:140609.743 19: /usr/sbin/zabbix_server: poller #15 [got 0 values in 0.000013 sec, getting values](zbx_log_fatal_info+0x13c) [0x55611e06dfbc]
 19151:20180228:140609.743 18: /usr/sbin/zabbix_server: poller #15 [got 0 values in 0.000013 sec, getting values](+0xf13d1) [0x55611e06e3d1]
 19151:20180228:140609.744 17: /lib64/libpthread.so.0(+0xf5e0) [0x7fcd049345e0]
 19151:20180228:140609.744 16: /lib64/libc.so.6(+0x86c31) [0x7fcd01430c31]
 19151:20180228:140609.744 15: /usr/lib64/mysql/libmysqlclient.so.18(my_strdup+0x18) [0x7fcd04bb2bb8]
 19151:20180228:140609.744 14: /usr/lib64/libmyodbc5w.so(myodbc_init+0xa2) [0x7fcb554d44f2]
 19151:20180228:140609.744 13: /usr/lib64/libmyodbc5w.so(my_SQLAllocEnv+0x1c) [0x7fcb554d7fbc]
 19151:20180228:140609.744 12: /lib64/libodbc.so.2(+0xd8dc) [0x7fcd033638dc]
 19151:20180228:140609.744 11: /lib64/libodbc.so.2(SQLConnect+0x1a7) [0x7fcd03365af7]
 19151:20180228:140609.744 10: /usr/sbin/zabbix_server: poller #15 [got 0 values in 0.000013 sec, getting values](zbx_odbc_connect+0x1ad) [0x55611e00c86b]
 19151:20180228:140609.744 9: /usr/sbin/zabbix_server: poller #15 [got 0 values in 0.000013 sec, getting values](get_value_db+0x221) [0x55611dfdda85]
 19151:20180228:140609.744 8: /usr/sbin/zabbix_server: poller #15 [got 0 values in 0.000013 sec, getting values](+0x52a7c) [0x55611dfcfa7c]
 19151:20180228:140609.744 7: /usr/sbin/zabbix_server: poller #15 [got 0 values in 0.000013 sec, getting values](+0x53f17) [0x55611dfd0f17]
 19151:20180228:140609.744 6: /usr/sbin/zabbix_server: poller #15 [got 0 values in 0.000013 sec, getting values](poller_thread+0x1aa) [0x55611dfd1c18]
 19151:20180228:140609.745 5: /usr/sbin/zabbix_server: poller #15 [got 0 values in 0.000013 sec, getting values](zbx_thread_start+0x32) [0x55611e07b3ad]
 19151:20180228:140609.745 4: /usr/sbin/zabbix_server: poller #15 [got 0 values in 0.000013 sec, getting values](MAIN_ZABBIX_ENTRY+0x900) [0x55611dfbdfc1]
 19151:20180228:140609.745 3: /usr/sbin/zabbix_server: poller #15 [got 0 values in 0.000013 sec, getting values](daemon_start+0x31b) [0x55611e06d708]
 19151:20180228:140609.745 2: /usr/sbin/zabbix_server: poller #15 [got 0 values in 0.000013 sec, getting values](main+0x312) [0x55611dfbd6bf]
 19151:20180228:140609.745 1: /lib64/libc.so.6(__libc_start_main+0xf5) [0x7fcd013cbc05]
 19151:20180228:140609.745 0: /usr/sbin/zabbix_server: poller #15 [got 0 values in 0.000013 sec, getting values](+0x33f09) [0x55611dfb0f09]
Comment by Glebs Ivanovskis (Inactive) [ 2018 Feb 28 ]

Closing as Duplicate of ZBX-10654.

Comment by Hamilton Jimenez Vasquez [ 2019 Feb 28 ]

How you did you get that fixed? I've been having the same issues as you in a Server with Ubuntu 14.04 and Zabbix 4.0, it was working fine with Zabbix 3.0 but now , since the upgraded on Zabbix, it has been crashing. I tried different configurations and nothing seems to work. I'm trying to get it to work in a laptop with the same conditions only for testing but it is failing in the same way.

Comment by majki [ 2019 Feb 28 ]

Hi 

This is some mysql bug. I was searching in my sql forum about it.

It looks that this is well known mysql  bug, oracle didn't fix it.

I install second  instance with maria db  it works.

 

Regards

 

Comment by Hamilton Jimenez Vasquez [ 2019 Feb 28 ]

Finally, after days working on it, got it working by using the old odbc library + the package that comes by default when you install libmyodbc and that's libmyodbc.so

 

This was killing me, but I'm glad is working now. if somebody needs helps I can send you the entire library. I'm using Zabbix 4.0, MySQL 5.5.62 and Ubuntu Server 14.04

Generated at Fri Apr 26 13:53:19 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.