[ZBX-8977] MySQL ODBC monitoring crash problem Created: 2014 Oct 31  Updated: 2017 May 30  Resolved: 2014 Oct 31

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

Type: Incident report Priority: Major
Reporter: Denis Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

CentOS 6.6 x64
unixODBC-2.2.14-14.el6.x86_64
mysql-connector-odbc-debuginfo-5.3.4-1.el6.x86_64
mysql-connector-odbc-setup-5.3.4-1.el6.x86_64
mysql-connector-odbc-5.3.4-1.el6.x86_64
DB standalone srv: Percona-Server-server-56-5.6.21-rel69.0.el6.x86_64


Attachments: Text File zabbix_crash.txt     Text File zabbix_crash1.txt    
Issue Links:
Duplicate
duplicates ZBX-7665 Zabbix 2.2.1 ODBC monitor crash - in ... Closed

 Description   

While creating MySQL monitoring item via ODBC in zabbix it keeps crashing.
At the same time oracle monitoring item via ODBC working fine gathering desired items.
isql command line utility works fine for both DSNs (mysql, oracle) executing desired queries.

odbcinst.ini
[MysqlDriver]
Description = MySQL driver
Driver = /usr/lib64/libmyodbc5a.so
SETUP = /usr/lib64/libmyodbc5S.so
UsageCount = 1

odbc.ini
[zabbix_odbc]
Description = Zabbix Database
Driver = MysqlDriver
Server = 192.168.119.103
Port = 3306
Database = zabbix_dist
User = zabbix
Password = zabbix

omited zabbix_server.log (full versions attached)
12206:20141031:101708.776 Got signal [signal:11(SIGSEGV),reason:1,refaddr:0x3f]. Crashing ...
12206:20141031:101708.776 ====== Fatal information: ======
12206:20141031:101708.776 Program counter: 0x7fb2975c5f76
12206:20141031:101708.776 === Registers: ===
12206:20141031:101708.776 r8 = 7fff0ea44a3b = 140733439035963 = 140733439035963
12206:20141031:101708.776 r9 = 7fb2978bb8e0 = 140405023422688 = 140405023422688
12206:20141031:101708.776 r10 = 7fb2978ca420 = 140405023482912 = 140405023482912
12206:20141031:101708.776 r11 = 7fb28d2ca9d0 = 140404849420752 = 140404849420752
12206:20141031:101708.776 r12 = 1f922c0 = 33104576 = 33104576
12206:20141031:101708.776 r13 = 7fb2975c5f40 = 140405020319552 = 140405020319552
12206:20141031:101708.776 r14 = 1f92dcc = 33107404 = 33107404
12206:20141031:101708.776 r15 = 7fff0ea44a31 = 140733439035953 = 140733439035953
12206:20141031:101708.776 rdi = 7fb2978cc500 = 140405023491328 = 140405023491328
12206:20141031:101708.777 rsi = 3f = 63 = 63
12206:20141031:101708.777 rbp = 7fff0ea43730 = 140733439031088 = 140733439031088
12206:20141031:101708.777 rbx = 7fb2978cc500 = 140405023491328 = 140405023491328
12206:20141031:101708.777 rdx = 1f922ff = 33104639 = 33104639
12206:20141031:101708.777 rax = 1f922fe = 33104638 = 33104638
12206:20141031:101708.777 rcx = 1f92dcc = 33107404 = 33107404
12206:20141031:101708.777 rsp = 7fff0ea43728 = 140733439031080 = 140733439031080
12206:20141031:101708.777 rip = 7fb2975c5f76 = 140405020319606 = 140405020319606
12206:20141031:101708.777 efl = 10202 = 66050 = 66050
12206:20141031:101708.777 csgsfs = 33 = 51 = 51
12206:20141031:101708.777 err = 4 = 4 = 4
12206:20141031:101708.777 trapno = e = 14 = 14
12206:20141031:101708.777 oldmask = 0 = 0 = 0
12206:20141031:101708.777 cr2 = 3f = 63 = 63
12206:20141031:101708.777 === Backtrace: ===
12206:20141031:101708.779 17: zabbix_server: poller #4 [got 0 values in 0.000004 sec, getting values](print_fatal_info+0x280) [0x468660]
12206:20141031:101708.779 16: zabbix_server: poller #4 [got 0 values in 0.000004 sec, getting values]() [0x468d7c]
12206:20141031:101708.779 15: /lib64/libc.so.6(+0x326a0) [0x7fb294d0c6a0]
12206:20141031:101708.779 14: /usr/lib64/libmysqlclient.so.16(+0x41f76) [0x7fb2975c5f76]
12206:20141031:101708.779 13: /usr/lib64/libmyodbc5a.so(copy_and_convert+0xd7) [0x7fb28d2caaa7]
12206:20141031:101708.779 12: /usr/lib64/libmyodbc5a.so(sqlchar_as_sqlwchar+0x1d3) [0x7fb28d2cb8d3]
12206:20141031:101708.780 11: /usr/lib64/libmyodbc5a.so(SQLConnect+0x62) [0x7fb28d235f72]
12206:20141031:101708.780 10: /usr/lib64/libodbc.so.2(SQLConnect+0x1b2) [0x7fb296dcc8c2]
12206:20141031:101708.780 9: zabbix_server: poller #4 [got 0 values in 0.000004 sec, getting values](odbc_DBconnect+0x151) [0x49b101]
12206:20141031:101708.780 8: zabbix_server: poller #4 [got 0 values in 0.000004 sec, getting values](get_value_db+0xa2) [0x42de82]
12206:20141031:101708.780 7: zabbix_server: poller #4 [got 0 values in 0.000004 sec, getting values]() [0x425aa4]
12206:20141031:101708.780 6: zabbix_server: poller #4 [got 0 values in 0.000004 sec, getting values](poller_thread+0xf3) [0x425f43]
12206:20141031:101708.780 5: zabbix_server: poller #4 [got 0 values in 0.000004 sec, getting values](zbx_thread_start+0x64) [0x4690b4]
12206:20141031:101708.780 4: zabbix_server: poller #4 [got 0 values in 0.000004 sec, getting values](MAIN_ZABBIX_ENTRY+0x3de) [0x418a4e]
12206:20141031:101708.781 3: zabbix_server: poller #4 [got 0 values in 0.000004 sec, getting values](daemon_start+0x1a1) [0x467651]
12206:20141031:101708.781 2: zabbix_server: poller #4 [got 0 values in 0.000004 sec, getting values](main+0x37e) [0x41915e]
12206:20141031:101708.781 1: /lib64/libc.so.6(__libc_start_main+0xfd) [0x7fb294cf8d5d]
12206:20141031:101708.781 0: zabbix_server: poller #4 [got 0 values in 0.000004 sec, getting values]() [0x4137e9]

another one only backtrace:
53618:20141031:104708.556 === Backtrace: ===
53618:20141031:104708.557 17: zabbix_server: poller #3 [got 1 values in 0.001741 sec, getting values](print_fatal_info+0x280) [0x468660]
53618:20141031:104708.557 16: zabbix_server: poller #3 [got 1 values in 0.001741 sec, getting values]() [0x468d7c]
53618:20141031:104708.557 15: /lib64/libc.so.6(+0x326a0) [0x7f78f232e6a0]
53618:20141031:104708.557 14: /usr/lib64/libmysqlclient.so.16(+0x41f76) [0x7f78f4be7f76]
53618:20141031:104708.557 13: /usr/lib64/libmyodbc5a.so(copy_and_convert+0xd7) [0x7f78ea8ecaa7]
53618:20141031:104708.557 12: /usr/lib64/libmyodbc5a.so(sqlchar_as_sqlwchar+0x1d3) [0x7f78ea8ed8d3]
53618:20141031:104708.557 11: /usr/lib64/libmyodbc5a.so(SQLConnect+0x62) [0x7f78ea857f72]
53618:20141031:104708.557 10: /usr/lib64/libodbc.so.2(SQLConnect+0x1b2) [0x7f78f43ee8c2]
53618:20141031:104708.557 9: zabbix_server: poller #3 [got 1 values in 0.001741 sec, getting values](odbc_DBconnect+0x151) [0x49b101]
53618:20141031:104708.557 8: zabbix_server: poller #3 [got 1 values in 0.001741 sec, getting values](get_value_db+0xa2) [0x42de82]
53618:20141031:104708.557 7: zabbix_server: poller #3 [got 1 values in 0.001741 sec, getting values]() [0x425aa4]
53618:20141031:104708.557 6: zabbix_server: poller #3 [got 1 values in 0.001741 sec, getting values](poller_thread+0xf3) [0x425f43]
53618:20141031:104708.557 5: zabbix_server: poller #3 [got 1 values in 0.001741 sec, getting values](zbx_thread_start+0x64) [0x4690b4]
53618:20141031:104708.557 4: zabbix_server: poller #3 [got 1 values in 0.001741 sec, getting values](MAIN_ZABBIX_ENTRY+0x3de) [0x418a4e]
53618:20141031:104708.558 3: zabbix_server: poller #3 [got 1 values in 0.001741 sec, getting values](daemon_start+0x1a1) [0x467651]
53618:20141031:104708.558 2: zabbix_server: poller #3 [got 1 values in 0.001741 sec, getting values](main+0x37e) [0x41915e]
53618:20141031:104708.558 1: /lib64/libc.so.6(__libc_start_main+0xfd) [0x7f78f231ad5d]
53618:20141031:104708.558 0: zabbix_server: poller #3 [got 1 values in 0.001741 sec, getting values]() [0x4137e9]


Generated at Fri Apr 26 06:59:06 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.