-
Incident report
-
Resolution: Duplicate
-
Major
-
None
-
2.4.1
-
None
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]
- duplicates
-
ZBX-7665 Zabbix 2.2.1 ODBC monitor crash - in "poller".
- Closed