Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-8977

MySQL ODBC monitoring crash problem

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • 2.4.1
    • Server (S)
    • 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]

            Unassigned Unassigned
            iDen Denis
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: