Ad Widget

Collapse

After enable odbc data monitors zabbix server was crashing .

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • kuncham26
    Junior Member
    • Jun 2016
    • 6
    #1

    After enable odbc data monitors zabbix server was crashing .

    Hi guys ,
    i am using zabbix server 3.0 . odbc version unixODBC-2.3.2 & mysql-connector-odbc-5.2.7-linux-debian6.0-x86-64bit and os ubuntu 14.04.
    via command line, isql to the database is working but while adding a Zabbix item odbc Zabbix server was crashing. could you any help me.
    PFI.

    20448:20200802:125305.695 Got signal [signal:11(SIGSEGV),reason:1,refaddr:0x3f]. Crashing ...
    20448:20200802:125305.695 ====== Fatal information: ======
    20448:20200802:125305.695 Program counter: 0x7faf1aaeff29
    20448:20200802:125305.695 === Registers: ===
    20448:20200802:125305.695 r8 = 7fff54a3b0d6 = 140734613401814 = 140734613401814
    20448:20200802:125305.695 r9 = 7faf1af69a60 = 140390048373344 = 140390048373344
    20448:20200802:125305.695 r10 = 7fff54a3a8e0 = 140734613399776 = 140734613399776
    20448:20200802:125305.695 r11 = 7faf07ae3ba0 = 140389724863392 = 140389724863392
    20448:20200802:125305.695 r12 = 7fff54a3b0d6 = 140734613401814 = 140734613401814
    20448:20200802:125305.695 r13 = 7faf1af78a20 = 140390048434720 = 140390048434720
    20448:20200802:125305.695 r14 = 7faf1af79c20 = 140390048439328 = 140390048439328
    20448:20200802:125305.695 r15 = a2c1b7 = 10666423 = 10666423
    20448:20200802:125305.695 rdi = 7faf1af78a20 = 140390048434720 = 140390048434720
    20448:20200802:125305.695 rsi = 7fff54a3aa50 = 140734613400144 = 140734613400144
    20448:20200802:125305.695 rbp = 3f = 63 = 63
    20448:20200802:125305.695 rbx = a2bbef = 10664943 = 10664943
    20448:20200802:125305.695 rdx = 3f = 63 = 63
    20448:20200802:125305.695 rax = 7fff54a3aa50 = 140734613400144 = 140734613400144
    20448:20200802:125305.695 rcx = a2bbef = 10664943 = 10664943
    20448:20200802:125305.695 rsp = 7fff54a3aa38 = 140734613400120 = 140734613400120
    20448:20200802:125305.695 rip = 7faf1aaeff29 = 140390043680553 = 140390043680553
    20448:20200802:125305.695 efl = 10287 = 66183 = 66183
    20448:20200802:125305.695 csgsfs = 33 = 51 = 51
    20448:20200802:125305.695 err = 4 = 4 = 4
    20448:20200802:125305.695 trapno = e = 14 = 14
    20448:20200802:125305.695 oldmask = 0 = 0 = 0
    20448:20200802:125305.695 cr2 = 3f = 63 = 63
    20448:20200802:125305.695 === Backtrace: ===
    20448:20200802:125305.696 18: /opt/zabbix/sbin/zabbix_server: poller #189 [got 4 values in 0.003635 sec, getting values](print_fatal_info+0xae) [0x47ab9e]
    20448:20200802:125305.696 17: /opt/zabbix/sbin/zabbix_server: poller #189 [got 4 values in 0.003635 sec, getting values]() [0x47ae77]
    20448:20200802:125305.696 16: /lib/x86_64-linux-gnu/libc.so.6(+0x36d40) [0x7faf18daed40]
    20448:20200802:125305.696 15: /usr/lib/x86_64-linux-gnu/libmysqlclient.so.18(+0x3cf29) [0x7faf1aaeff29]
    20448:20200802:125305.696 14: /usr/lib/x86_64-linux-gnu/libmysqlclient.so.18(+0x3d289) [0x7faf1aaf0289]
    20448:20200802:125305.696 13: /usr/lib/x86_64-linux-gnu/odbc/libmyodbc5a.so(copy_and_convert+0xd7) [0x7faf07ae3c77]
    20448:20200802:125305.696 12: /usr/lib/x86_64-linux-gnu/odbc/libmyodbc5a.so(sqlchar_as_sqlwchar+0x13f) [0x7faf07ae477d]
    20448:20200802:125305.696 11: /usr/lib/x86_64-linux-gnu/odbc/libmyodbc5a.so(SQLConnect+0x60) [0x7faf07a4f35a]
    20448:20200802:125305.696 10: /usr/lib/x86_64-linux-gnu/libodbc.so.1(SQLConnect+0x209) [0x7faf1a4e97d9]
    20448:20200802:125305.696 9: /opt/zabbix/sbin/zabbix_server: poller #189 [got 4 values in 0.003635 sec, getting values](odbc_DBconnect+0x121
    ) [0x4a3581]
    20448:20200802:125305.696 8: /opt/zabbix/sbin/zabbix_server: poller #189 [got 4 values in 0.003635 sec, getting values](get_value_db+0x110)
    [0x42f2e0]
    20448:20200802:125305.696 7: /opt/zabbix/sbin/zabbix_server: poller #189 [got 4 values in 0.003635 sec, getting values]() [0x427243]
    20448:20200802:125305.696 6: /opt/zabbix/sbin/zabbix_server: poller #189 [got 4 values in 0.003635 sec, getting values](poller_thread+0xe8)
    [0x4273f8]
    20448:20200802:125305.696 5: /opt/zabbix/sbin/zabbix_server: poller #189 [got 4 values in 0.003635 sec, getting values](zbx_thread_start+0x4
    5) [0x47b725]
    20448:20200802:125305.696 4: /opt/zabbix/sbin/zabbix_server: poller #189 [got 4 values in 0.003635 sec, getting values](MAIN_ZABBIX_ENTRY+0x
    3ed) [0x41a81d]
    20448:20200802:125305.696 3: /opt/zabbix/sbin/zabbix_server: poller #189 [got 4 values in 0.003635 sec, getting values](daemon_start+0x1ad)
    [0x47a49d]
    20448:20200802:125305.696 2: /opt/zabbix/sbin/zabbix_server: poller #189 [got 4 values in 0.003635 sec, getting values](main+0x399) [0x4156f
    9]
    20448:20200802:125305.696 1: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf5) [0x7faf18d99ec5]
    20448:20200802:125305.696 0: /opt/zabbix/sbin/zabbix_server: poller #189 [got 4 values in 0.003635 sec, getting values]() [0x415965]
    20448:20200802:125305.696 === Memory map: ===
    20448:20200802:125305.696 00400000-00561000 r-xp 00000000 08:25 919871 /opt/zabbix/sbin/zabbix_server
    20448:20200802:125305.696 00760000-00761000 r--p 00160000 08:25 919871 /opt/zabbix/sbin/zabbix_server
    20448:20200802:125305.696 00761000-00768000 rw-p 00161000 08:25 919871 /opt/zabbix/sbin/zabbix_server
    20448:20200802:125305.696 00768000-0076e000 rw-p 00000000 00:00 0
    20448:20200802:125305.696 009ca000-009eb000 rw-p 00000000 00:00 0 [heap]
    20448:20200802:125305.696 009eb000-00a25000 rw-p 00000000 00:00 0 [heap]
    20448:20200802:125305.696 00a25000-00a4a000 rw-p 00000000 00:00 0 [heap]
    20448:20200802:125305.696 7faf072bd000-7faf073a3000 r-xp 00000000 08:25 395 /usr/lib/x86_64-linux-gnu/libstdc++.so.6.
    0.19
    20448:20200802:125305.696 7faf073a3000-7faf075a2000 ---p 000e6000 08:25 395 /usr/lib/x86_64-linux-gnu/libstdc++.so.6.
    0.19
    20448:20200802:125305.697 7faf075a2000-7faf075aa000 r--p 000e5000 08:25 395 /usr/lib/x86_64-linux-gnu/libstdc++.so.6.
    0.19
    20448:20200802:125305.697 7faf075aa000-7faf075ac000 rw-p 000ed000 08:25 395 /usr/lib/x86_64-linux-gnu/libstdc++.so.6.
    0.19
    20448:20200802:125305.697 7faf075ac000-7faf075c1000 rw-p 00000000 00:00 0
    20448:20200802:125305.697 7faf075c1000-7faf075c8000 r-xp 00000000 08:25 1044744 /lib/x86_64-linux-gnu/librt-2.19.so
    20448:20200802:125305.697 7faf075c8000-7faf077c7000 ---p 00007000 08:25 1044744 /lib/x86_64-linux-gnu/librt-2.19.so
    20448:20200802:125305.696 7faf072bd000-7faf073a3000 r-xp 00000000 08:25 395 /usr/lib/x86_64-linux-gnu/libstdc++.so.6.
    0.19
    20448:20200802:125305.696 7faf073a3000-7faf075a2000 ---p 000e6000 08:25 395 /usr/lib/x86_64-linux-gnu/libstdc++.so.6.
    0.19
    20448:20200802:125305.697 7faf075a2000-7faf075aa000 r--p 000e5000 08:25 395 /usr/lib/x86_64-linux-gnu/libstdc++.so.6.
    0.19
    20448:20200802:125305.697 7faf075aa000-7faf075ac000 rw-p 000ed000 08:25 395 /usr/lib/x86_64-linux-gnu/libstdc++.so.6.
    0.19
    20448:20200802:125305.697 7faf075ac000-7faf075c1000 rw-p 00000000 00:00 0
    20448:20200802:125305.697 7faf075c1000-7faf075c8000 r-xp 00000000 08:25 1044744 /lib/x86_64-linux-gnu/librt-2.19.so
    20448:20200802:125305.697 7faf075c8000-7faf077c7000 ---p 00007000 08:25 1044744 /lib/x86_64-linux-gnu/librt-2.19.so
    20448:20200802:125305.697 7faf077c7000-7faf077c8000 r--p 00006000 08:25 1044744 /lib/x86_64-linux-gnu/librt-2.19.so
    20448:20200802:125305.697 7faf077c8000-7faf077c9000 rw-p 00007000 08:25 1044744 /lib/x86_64-linux-gnu/librt-2.19.so
    20448:20200802:125305.697 7faf077c9000-7faf077e0000 r-xp 00000000 08:25 8687 /usr/lib/x86_64-linux-gnu/libodbcinst.so.2.0.0
    20448:20200802:125305.697 7faf077e0000-7faf079df000 ---p 00017000 08:25 8687 /usr/lib/x86_64-linux-gnu/libodbcinst.so.2.0.0
    20448:20200802:125305.697 7faf079df000-7faf079e0000 r--p 00016000 08:25 8687 /usr/lib/x86_64-linux-gnu/libodbcinst.so.2.0.0
    20448:20200802:125305.697 7faf079e0000-7faf079e1000 rw-p 00017000 08:25 8687 /usr/lib/x86_64-linux-gnu/libodbcinst.so.2.0.0
    20448:20200802:125305.697 7faf079e1000-7faf079e4000 rw-p 00000000 00:00 0
    20448:20200802:125305.697 7faf079e4000-7faf07d1a000 r-xp 00000000 08:25 8684 /usr/lib/x86_64-linux-gnu/odbc/libmyodbc5a.so
    20448:20200802:125305.697 7faf07d1a000-7faf07f19000 ---p 00336000 08:25 8684 /usr/lib/x86_64-linux-gnu/odbc/libmyodbc5a.so
    20448:20200802:125305.697 7faf07f19000-7faf07ffa000 rw-p 00335000 08:25 8684 /usr/lib/x86_64-linux-gnu/odbc/libmyodbc5a.so
    20448:20200802:125305.697 7faf07ffa000-7faf08000000 rw-p 00000000 00:00 0
    20448:20200802:125305.697 7faf08000000-7faf08021000 rw-p 00000000 00:00 0
    20448:20200802:125305.697 7faf08021000-7faf0c000000 ---p 00000000 00:00 0
    20448:20200802:125305.697 7faf0c1d7000-7faf0c1da000 r-xp 00000000 08:25 2814 /usr/lib/x86_64-linux-gnu/gconv/UTF-16.so
    20448:20200802:125305.697 7faf0c1da000-7faf0c3d9000 ---p 00003000 08:25 2814 /usr/lib/x86_64-linux-gnu/gconv/UTF-16.so
    20448:20200802:125305.697 7faf0c3d9000-7faf0c3da000 r--p 00002000 08:25 2814 /usr/lib/x86_64-linux-gnu/gconv/UTF-16.so
    20448:20200802:125305.697 7faf0c3da000-7faf0c3db000 rw-p 00003000 08:25 2814 /usr/lib/x86_64-linux-gnu/gconv/UTF-16.so
    20448:20200802:125305.697 7faf0c3db000-7faf0c5a0000 r--p 00000000 08:25 5333 /usr/lib/locale/locale-archive
    20448:20200802:125305.697 7faf0c5a0000-7faf0c5b6000 r-xp 00000000 08:25 1044672 /lib/x86_64-linux-gnu/libgcc_s.so.1
    20448:20200802:125305.697 7faf0c5b6000-7faf0c7b5000 ---p 00016000 08:25 1044672 /lib/x86_64-linux-gnu/libgcc_s.so.1
    20448:20200802:125305.697 7faf0c7b5000-7faf0c7b6000 rw-p 00015000 08:25 1044672 /lib/x86_64-linux-gnu/libgcc_s.so.1
    20448:20200802:125305.697 7faf0c7b6000-7faf0c7b7000 ---p 00000000 00:00 0
    20448:20200802:125305.697 7faf0c7b7000-7faf0cfb7000 rw-p 00000000 00:00 0
    20448:20200802:125305.697 7faf0cfb7000-7faf0dfb7000 rw-s 00000000 00:04 11075591 /SYSV76250813 (deleted)
    20448:20200802:125305.697 7faf0dfb7000-7faf0e951000 rw-s 00000000 00:04 11010053 /SYSV73250813 (deleted)
    20448:20200802:125305.697 7faf0e951000-7faf11fb8000 rw-s 00000000 00:04 10977284 /SYSV67250813 (deleted)
    20448:20200802:125305.697 7faf11fb8000-7faf123b8000 rw-s 00000000 00:04 10944515 /SYSV74250813 (deleted)
    20448:20200802:125305.697 7faf123b8000-7faf127b8000 rw-s 00000000 00:04 10911746 /SYSV48250813 (deleted)
    20448:20200802:125305.697 7faf127b8000-7faf137b8000 rw-s 00000000 00:04 10878977 /SYSV68250813 (deleted)
    20448:20200802:125305.697 7faf137b8000-7faf137c3000 r-xp 00000000 08:25 1044707 /lib/x86_64-linux-gnu/libnss_files-2.19.so
    20448:20200802:125305.697 7faf137c3000-7faf139c2000 ---p 0000b000 08:25 1044707 /lib/x86_64-linux-gnu/libnss_files-2.19.so
    20448:20200802:125305.697 7faf139c2000-7faf139c3000 r--p 0000a000 08:25 1044707 /lib/x86_64-linux-gnu/libnss_files-2.19.so
    Tags: None
    • agaraujo
      Junior Member
      • Jan 2021
      • 4
      #2
      You find the solution ?

        Comment

        • Hamardaban
          Senior Member
          Zabbix Certified SpecialistZabbix Certified Professional
          • May 2019
          • 2713
          #3
          Perhaps this is the problem

          8 Known issues
          https://www.zabbix.com/documentation/current/manual/installation/known_issues#odbc_checks

            Comment

            • agaraujo
              Junior Member
              • Jan 2021
              • 4
              #4
              Exactly, I hadn't seen this part of the documentation, but I solved it this way.

              I'm using MariaDB 10.5 and was trying to use Mysql's ODBC on Red Hat 7.9.

              After following the installation steps for Mariadb's ODBC it worked perfectly.

              De qualquer forma obrigado @Hamardaban.

                Comment

                Previous template Next
                Working...