[ZBX-7665] Zabbix 2.2.1 ODBC monitor crash - in "poller". Created: 2014 Jan 16  Updated: 2024 Jan 12  Resolved: 2014 Aug 25

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

Type: Incident report Priority: Critical
Reporter: Brian Chand Assignee: Unassigned
Resolution: Won't fix Votes: 2
Labels: crash, mysql, odbc
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Ubuntu 12.04 LTS


Attachments: Text File zabbix_server.log    
Issue Links:
Duplicate
duplicates ZBX-10897 crash using unixODBC with an Oracle d... Closed
is duplicated by ZBX-7731 One child process died (PID:36456,exi... Closed
is duplicated by ZBX-8799 Zabbix 2.2.6 installed from packages ... Closed
is duplicated by ZBX-10654 Zabbix Server 3.0.1 crash shortly aft... Closed
is duplicated by ZBX-14898 Zabbix server stops with error Closed
is duplicated by ZBX-8977 MySQL ODBC monitoring crash problem Closed
is duplicated by ZBX-9960 ODBC error: file not found Closed
is duplicated by ZBX-11016 Zabbix Server crashed in poller, odbc... Closed
is duplicated by ZBX-10023 Crash Zabbix to Monitoring ODBC for M... Closed
is duplicated by ZBX-18888 Zabbix Server Crashed when using data... Closed
is duplicated by ZBX-23931 Zabbix Proxy started crashing after a... Closed
Sub-task
depends on ZBX-12159 Resolving TNS names via LDAP crash on... Confirmed

 Description   

Adding an ODBC monitor item for a remote MySQL database causes zabbix server process to crash as soon as the item is checked. This happens every time. The same query returns the expected data without error when tested using isql from the zabbix server. This will also crash a proxy.

Message in log:
Got signal [signal:11(SIGSEGV),reason:1,refaddr:0x3f]. Crashing ...



 Comments   
Comment by richlv [ 2014 Jan 16 ]

backtrace from the log :

 21074:20140115:163749.163 Starting Zabbix Server. Zabbix 2.2.1 (revision 40808).
...
  21089:20140115:163817.595 poller #4 [got 0 values in 0.000054 sec, getting values]
 21089:20140115:163817.595 In get_values()
 21089:20140115:163817.595 In DCconfig_get_poller_items() poller_type:0
 21089:20140115:163817.595 End of DCconfig_get_poller_items():1
 21089:20140115:163817.595 In substitute_key_macros() data:'db.odbc.select[ipadbattery,absolute]'
 21089:20140115:163817.595 End of substitute_key_macros():SUCCEED data:'db.odbc.select[ipadbattery,absolute]'
 21089:20140115:163817.595 In substitute_simple_macros() data:'select batterylevel from absolutemanage.iphone_dynamic_info,absolutemanage.iphone_info where absolutemanage.iphone_info.id = absolutemanage.iphone_dynamic_info.id and devicename='SFO-Airport-5410''
 21089:20140115:163817.595 In substitute_simple_macros() data:EMPTY
 21089:20140115:163817.595 In substitute_simple_macros() data:EMPTY
 21089:20140115:163817.595 In get_value() key:'db.odbc.select[ipadbattery,absolute]'
 21089:20140115:163817.595 In get_value_db() key_orig:'db.odbc.select[ipadbattery,absolute]'
 21089:20140115:163817.595 In odbc_DBconnect() db_dsn:'absolute' user:''
 21089:20140115:163817.598 Got signal [signal:11(SIGSEGV),reason:1,refaddr:0x3f]. Crashing ...
...
 21089:20140115:163817.598 === Backtrace: ===
 21089:20140115:163817.598 16: /usr/sbin/zabbix_server: poller #4 [got 0 values in 0.000054 sec, getting values](print_fatal_info+0xae) [0x46130e]
 21089:20140115:163817.598 15: /usr/sbin/zabbix_server: poller #4 [got 0 values in 0.000054 sec, getting values]() [0x461731]
 21089:20140115:163817.598 14: /lib/x86_64-linux-gnu/libc.so.6(+0x364a0) [0x7f2c4a9d74a0]
 21089:20140115:163817.598 13: /usr/lib/libmysqlclient.so.18(+0x39c4e) [0x7f2c4cf39c4e]
 21089:20140115:163817.598 12: /usr/lib/libmysqlclient.so.18(+0x39ebe) [0x7f2c4cf39ebe]
 21089:20140115:163817.598 11: /usr/lib/libmyodbc5a.so(copy_and_convert+0xd7) [0x7f2c4187bdc7]
 21089:20140115:163817.598 10: /usr/lib/libmyodbc5a.so(sqlchar_as_sqlwchar+0x13f) [0x7f2c4187c8cd]
 21089:20140115:163817.598 9: /usr/lib/libmyodbc5a.so(SQLConnect+0x5f) [0x7f2c417e825b]
 21089:20140115:163817.598 8: /usr/lib/x86_64-linux-gnu/libodbc.so.1(SQLConnect+0x1ba) [0x7f2c4c4e77ea]
 21089:20140115:163817.598 7: /usr/sbin/zabbix_server: poller #4 [got 0 values in 0.000054 sec, getting values](odbc_DBconnect+0x120) [0x492200]
 21089:20140115:163817.598 6: /usr/sbin/zabbix_server: poller #4 [got 0 values in 0.000054 sec, getting values](get_value_db+0x94) [0x428624]
 21089:20140115:163817.598 5: /usr/sbin/zabbix_server: poller #4 [got 0 values in 0.000054 sec, getting values]() [0x423109]
 21089:20140115:163817.598 4: /usr/sbin/zabbix_server: poller #4 [got 0 values in 0.000054 sec, getting values](main_poller_loop+0x83) [0x423683]
 21089:20140115:163817.598 3: /usr/sbin/zabbix_server: poller #4 [got 0 values in 0.000054 sec, getting values](MAIN_ZABBIX_ENTRY+0x682) [0x418742]
 21089:20140115:163817.598 2: /usr/sbin/zabbix_server: poller #4 [got 0 values in 0.000054 sec, getting values](daemon_start+0x1b2) [0x460bc2]
 21089:20140115:163817.599 1: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xed) [0x7f2c4a9c276d]
 21089:20140115:163817.599 0: /usr/sbin/zabbix_server: poller #4 [got 0 values in 0.000054 sec, getting values]() [0x413735]
Comment by Oleksii Zagorskyi [ 2014 Jan 31 ]

Similar duplicate is linked.
Just a difference - looks like Oracle is there for the odbc-item.

Comment by Alexander Vladishev [ 2014 May 29 ]

Another crash with Oracle connector:

 11147:20140430:071415.666 Got signal [signal:11(SIGSEGV),reason:1,refaddr:0x3c]. Crashing ...
 11147:20140430:071415.666 ====== Fatal information: ======
 11147:20140430:071415.666 Program counter: 0x4c36212
 11147:20140430:071415.666 === Registers: ===
 11147:20140430:071415.666 gs      =               63 =                   99 =                   99
 11147:20140430:071415.666 fs      =                0 =                    0 =                    0
 11147:20140430:071415.666 es      =               2b =                   43 =                   43
 11147:20140430:071415.666 ds      =               2b =                   43 =                   43
 11147:20140430:071415.666 edi     =              de8 =                 3560 =                 3560
 11147:20140430:071415.666 esi     =          8780894 =            142084244 =            142084244
 11147:20140430:071415.666 ebp     =         fffa7118 =           4294603032 =              -364264
 11147:20140430:071415.666 esp     =         fffa6fec =           4294602732 =              -364564
 11147:20140430:071415.666 ebx     =          66092b4 =            106992308 =            106992308
 11147:20140430:071415.666 edx     =          8780230 =            142082608 =            142082608
 11147:20140430:071415.666 ecx     =                0 =                    0 =                    0
 11147:20140430:071415.666 eax     =                0 =                    0 =                    0
 11147:20140430:071415.666 trapno  =                e =                   14 =                   14
 11147:20140430:071415.666 err     =                4 =                    4 =                    4
 11147:20140430:071415.666 eip     =          4c36212 =             79913490 =             79913490
 11147:20140430:071415.666 cs      =               23 =                   35 =                   35
 11147:20140430:071415.666 efl     =           210246 =              2163270 =              2163270
 11147:20140430:071415.666 uesp    =         fffa6fec =           4294602732 =              -364564
 11147:20140430:071415.666 ss      =               2b =                   43 =                   43
 11147:20140430:071415.666 === Stack frame: ===
 11147:20140430:071415.666 +0x40(%ebp) = ebp + 64 = 00000001 =          1 =           1
 11147:20140430:071415.666 +0x3c(%ebp) = ebp + 60 = 00000000 =          0 =           0
 11147:20140430:071415.666 +0x38(%ebp) = ebp + 56 = 00000558 =       1368 =        1368
 11147:20140430:071415.666 +0x34(%ebp) = ebp + 52 = 08709e70 =  141598320 =   141598320
 11147:20140430:071415.666 +0x30(%ebp) = ebp + 48 = ffffffff = 4294967295 =          -1
 11147:20140430:071415.666 +0x2c(%ebp) = ebp + 44 = 066092b4 =  106992308 =   106992308
 11147:20140430:071415.666 +0x28(%ebp) = ebp + 40 = 01000000 =   16777216 =    16777216
 11147:20140430:071415.666 +0x24(%ebp) = ebp + 36 = 00000000 =          0 =           0
 11147:20140430:071415.666 +0x20(%ebp) = ebp + 32 = 00000000 =          0 =           0
 11147:20140430:071415.666 +0x1c(%ebp) = ebp + 28 = 000017d8 =       6104 =        6104
 11147:20140430:071415.666 +0x18(%ebp) = ebp + 24 = 06461774 =  105256820 =   105256820
 11147:20140430:071415.666 +0x14(%ebp) = ebp + 20 = 01004000 =   16793600 =    16793600
 11147:20140430:071415.666 +0x10(%ebp) = ebp + 16 = fffa7138 = 4294603064 =     -364232
 11147:20140430:071415.666 +0x0c(%ebp) = ebp + 12 = 00000558 =       1368 =        1368
 11147:20140430:071415.666 +0x08(%ebp) = ebp +  8 = 08780230 =  142082608 =   142082608 <--- call arguments
 11147:20140430:071415.666 +0x04(%ebp) = ebp +  4 = 04c78986                            <--- return address
 11147:20140430:071415.666      (%ebp) = ebp      = fffa7164                            <--- saved ebp value
 11147:20140430:071415.666 -0x04(%ebp) = ebp -  4 = 066092b4 =  106992308 =   106992308 <--- local variables
 11147:20140430:071415.666 -0x08(%ebp) = ebp -  8 = 08709e74 =  141598324 =   141598324
 11147:20140430:071415.666 -0x0c(%ebp) = ebp - 12 = 08780230 =  142082608 =   142082608
 11147:20140430:071415.666 -0x10(%ebp) = ebp - 16 = 00000000 =          0 =           0
 11147:20140430:071415.666 -0x14(%ebp) = ebp - 20 = 08780894 =  142084244 =   142084244
 11147:20140430:071415.666 -0x18(%ebp) = ebp - 24 = 0878076c =  142083948 =   142083948
 11147:20140430:071415.666 -0x1c(%ebp) = ebp - 28 = 00000000 =          0 =           0
 11147:20140430:071415.666 -0x20(%ebp) = ebp - 32 = 08709e74 =  141598324 =   141598324
 11147:20140430:071415.666 -0x24(%ebp) = ebp - 36 = 066092b4 =  106992308 =   106992308
 11147:20140430:071415.666 -0x28(%ebp) = ebp - 40 = 04a48fd0 =   77893584 =    77893584
 11147:20140430:071415.666 -0x2c(%ebp) = ebp - 44 = 04a00000 =   77594624 =    77594624
 11147:20140430:071415.666 -0x30(%ebp) = ebp - 48 = 00000001 =          1 =           1
 11147:20140430:071415.667 -0x34(%ebp) = ebp - 52 = 01c10940 =   29428032 =    29428032
 11147:20140430:071415.667 -0x38(%ebp) = ebp - 56 = 04a92720 =   78194464 =    78194464
 11147:20140430:071415.667 -0x3c(%ebp) = ebp - 60 = 00000000 =          0 =           0
 11147:20140430:071415.667 -0x40(%ebp) = ebp - 64 = 00000001 =          1 =           1
 11147:20140430:071415.667 === Backtrace: ===
 11147:20140430:071415.668 19: zabbix_proxy: poller #10 [got 0 values in 0.000000 sec, getting values](print_fatal_info+0x454) [0x80ab774]
 11147:20140430:071415.668 18: zabbix_proxy: poller #10 [got 0 values in 0.000000 sec, getting values]() [0x80abf90]
 11147:20140430:071415.668 17: [0xdeb410]
 11147:20140430:071415.668 16: /opt/u01/app/oracle/product/11.2.0/client/lib/libclntsh.so.11.1(kpuhhaloc+0x334) [0x4c36212]
 11147:20140430:071415.668 15: /opt/u01/app/oracle/product/11.2.0/client/lib/libclntsh.so.11.1(kpughndl0+0x214) [0x4c78986]
 11147:20140430:071415.668 14: /opt/u01/app/oracle/product/11.2.0/client/lib/libclntsh.so.11.1(OCIHandleAlloc+0x38) [0x4c53ec8]
 11147:20140430:071415.668 13: /opt/u01/app/oracle/product/11.2.0/client/lib/libsqora.so.11.1(bcoSQLAllocEnv+0xe2) [0xe6ce5e]
 11147:20140430:071415.668 12: /opt/u01/app/oracle/product/11.2.0/client/lib/libsqora.so.11.1(+0x61c77) [0xebbc77]
 11147:20140430:071415.668 11: /opt/u01/app/oracle/product/11.2.0/client/lib/libsqora.so.11.1(SQLAllocHandle+0x33) [0xebbe29]
 11147:20140430:071415.668 10: /usr/lib/libodbc.so.2(+0xda83) [0x131a83]
 11147:20140430:071415.668 9: /usr/lib/libodbc.so.2(SQLConnect+0x186) [0x132ae6]
 11147:20140430:071415.668 8: zabbix_proxy: poller #10 [got 0 values in 0.000000 sec, getting values](odbc_DBconnect+0x182) [0x80d6432]
 11147:20140430:071415.668 7: zabbix_proxy: poller #10 [got 0 values in 0.000000 sec, getting values](get_value_db+0xd0) [0x806df50]
 11147:20140430:071415.668 6: zabbix_proxy: poller #10 [got 0 values in 0.000000 sec, getting values]() [0x806727c]
 11147:20140430:071415.668 5: zabbix_proxy: poller #10 [got 0 values in 0.000000 sec, getting values](main_poller_loop+0xa8) [0x8067968]
 11147:20140430:071415.668 4: zabbix_proxy: poller #10 [got 0 values in 0.000000 sec, getting values](MAIN_ZABBIX_ENTRY+0x713) [0x8057563]
 11147:20140430:071415.668 3: zabbix_proxy: poller #10 [got 0 values in 0.000000 sec, getting values](daemon_start+0x1e0) [0x80aa8c0]
 11147:20140430:071415.668 2: zabbix_proxy: poller #10 [got 0 values in 0.000000 sec, getting values](main+0x336) [0x8057d56]
 11147:20140430:071415.668 1: /lib/libc.so.6(__libc_start_main+0xe6) [0x867ce6]
 11147:20140430:071415.668 0: zabbix_proxy: poller #10 [got 0 values in 0.000000 sec, getting values]() [0x8056631]
 11147:20140430:071415.668 === Memory map: ===
 11147:20140430:071415.668 00112000-00117000 r-xp 00000000 fd:01 49723                              /usr/lib/libOpenIPMIposix.so.0.0.1
 11147:20140430:071415.668 00117000-00118000 rw-p 00004000 fd:01 49723                              /usr/lib/libOpenIPMIposix.so.0.0.1
 11147:20140430:071415.668 00118000-0011b000 r-xp 00000000 fd:01 48488                              /lib/libdl-2.12.so
 11147:20140430:071415.668 0011b000-0011c000 r--p 00002000 fd:01 48488                              /lib/libdl-2.12.so
 11147:20140430:071415.668 0011c000-0011d000 rw-p 00003000 fd:01 48488                              /lib/libdl-2.12.so
 11147:20140430:071415.668 0011d000-00123000 r-xp 00000000 fd:01 49713                              /usr/lib/libgdbm.so.2.0.0
 11147:20140430:071415.668 00123000-00124000 rw-p 00005000 fd:01 49713                              /usr/lib/libgdbm.so.2.0.0
 11147:20140430:071415.668 00124000-00190000 r-xp 00000000 fd:01 49291                              /usr/lib/libodbc.so.2.0.0
 11147:20140430:071415.668 00190000-00194000 rw-p 0006c000 fd:01 49291                              /usr/lib/libodbc.so.2.0.0
 11147:20140430:071415.668 00194000-00195000 rw-p 00000000 00:00 0 
 11147:20140430:071415.668 00195000-001bd000 r-xp 00000000 fd:01 48490                              /lib/libm-2.12.so
 11147:20140430:071415.668 001bd000-001be000 r--p 00027000 fd:01 48490                              /lib/libm-2.12.so
 11147:20140430:071415.668 001be000-001bf000 rw-p 00028000 fd:01 48490                              /lib/libm-2.12.so
 11147:20140430:071415.668 001bf000-001c6000 r-xp 00000000 fd:01 48510                              /lib/librt-2.12.so
 11147:20140430:071415.668 001c6000-001c7000 r--p 00006000 fd:01 48510                              /lib/librt-2.12.so
 11147:20140430:071415.668 001c7000-001c8000 rw-p 00007000 fd:01 48510                              /lib/librt-2.12.so
 11147:20140430:071415.668 001c8000-001da000 r-xp 00000000 fd:01 49328                              /lib/libz.so.1.2.3
 11147:20140430:071415.668 001da000-001db000 r--p 00011000 fd:01 49328                              /lib/libz.so.1.2.3
 11147:20140430:071415.668 001db000-001dc000 rw-p 00012000 fd:01 49328                              /lib/libz.so.1.2.3
 11147:20140430:071415.668 001dc000-001dd000 r-xp 00000000 fd:01 145971                             /usr/lib/gconv/ISO8859-1.so
 11147:20140430:071415.668 001dd000-001de000 r--p 00000000 fd:01 145971                             /usr/lib/gconv/ISO8859-1.so
 11147:20140430:071415.668 001de000-001df000 rw-p 00001000 fd:01 145971                             /usr/lib/gconv/ISO8859-1.so
 11147:20140430:071415.668 001df000-0030c000 r-xp 00000000 fd:01 150697                             /usr/lib/mysql/libmysqlclient.so.16.0.0
 11147:20140430:071415.669 0030c000-00353000 rw-p 0012d000 fd:01 150697                             /usr/lib/mysql/libmysqlclient.so.16.0.0
 11147:20140430:071415.669 00353000-00354000 rw-p 00000000 00:00 0 
 11147:20140430:071415.669 00354000-004c9000 r-xp 00000000 fd:01 49607                              /usr/lib/libcrypto.so.1.0.0
 11147:20140430:071415.669 004c9000-004ca000 ---p 00175000 fd:01 49607                              /usr/lib/libcrypto.so.1.0.0
 11147:20140430:071415.669 004ca000-004d8000 r--p 00175000 fd:01 49607                              /usr/lib/libcrypto.so.1.0.0
 11147:20140430:071415.669 004d8000-004de000 rw-p 00183000 fd:01 49607                              /usr/lib/libcrypto.so.1.0.0
 11147:20140430:071415.669 004de000-004e1000 rw-p 00000000 00:00 0 
 11147:20140430:071415.669 004e1000-0052c000 r-xp 00000000 fd:01 49699                              /lib/libldap-2.4.so.2.5.6
 11147:20140430:071415.669 0052c000-0052d000 r--p 0004a000 fd:01 49699                              /lib/libldap-2.4.so.2.5.6
 11147:20140430:071415.669 0052d000-0052e000 rw-p 0004b000 fd:01 49699                              /lib/libldap-2.4.so.2.5.6
 11147:20140430:071415.669 0052e000-00543000 r-xp 00000000 fd:01 48508                              /lib/libresolv-2.12.so
 11147:20140430:071415.669 00543000-00544000 ---p 00015000 fd:01 48508                              /lib/libresolv-2.12.so
 11147:20140430:071415.669 00544000-00545000 r--p 00015000 fd:01 48508                              /lib/libresolv-2.12.so
 11147:20140430:071415.669 00545000-00546000 rw-p 00016000 fd:01 48508                              /lib/libresolv-2.12.so
 11147:20140430:071415.669 00546000-00548000 rw-p 00000000 00:00 0 
 11147:20140430:071415.669 00548000-0054f000 r-xp 00000000 fd:01 48486                              /lib/libcrypt-2.12.so
 11147:20140430:071415.669 0054f000-00550000 r--p 00007000 fd:01 48486                              /lib/libcrypt-2.12.so
 11147:20140430:071415.669 00550000-00551000 rw-p 00008000 fd:01 48486                              /lib/libcrypt-2.12.so
 11147:20140430:071415.669 00551000-00578000 rw-p 00000000 00:00 0 
 11147:20140430:071415.669 00578000-0058f000 r-xp 00000000 fd:01 48492                              /lib/libnsl-2.12.so
 11147:20140430:071415.669 0058f000-00590000 r--p 00016000 fd:01 48492                              /lib/libnsl-2.12.so
 11147:20140430:071415.669 00590000-00591000 rw-p 00017000 fd:01 48492                              /lib/libnsl-2.12.so
 11257:20140430:071415.643 proxy #122 started [unreachable poller #44]
 11147:20140430:071415.670 00591000-00593000 rw-p 00000000 00:00 0 
 11147:20140430:071415.670 00593000-005e6000 r-xp 00000000 fd:01 49609                              /usr/lib/libssl.so.1.0.0
 11147:20140430:071415.670 005e6000-005e8000 r--p 00052000 fd:01 49609                              /usr/lib/libssl.so.1.0.0
 11147:20140430:071415.670 005e8000-005eb000 rw-p 00054000 fd:01 49609                              /usr/lib/libssl.so.1.0.0
 11147:20140430:071415.670 005eb000-005f2000 r-xp 00000000 fd:01 49729                              /usr/lib/libOpenIPMIutils.so.0.0.1
 11249:20140430:071415.644 proxy #114 started [unreachable poller #36]
 11147:20140430:071415.670 005f2000-005f3000 rw-p 00006000 fd:01 49729                              /usr/lib/libOpenIPMIutils.so.0.0.1
 11147:20140430:071415.670 005f3000-005f7000 r-xp 00000000 fd:01 49599                              /lib/libplc4.so
 11147:20140430:071415.670 005f7000-005f8000 r--p 00003000 fd:01 49599                              /lib/libplc4.so
 11147:20140430:071415.670 005f8000-005f9000 rw-p 00004000 fd:01 49599                              /lib/libplc4.so
 11225:20140430:071415.645 proxy #90 started [unreachable poller #12]
 11147:20140430:071415.670 005fa000-006e4000 r-xp 00000000 fd:01 49717                              /usr/lib/libOpenIPMI.so.0.0.5
 11147:20140430:071415.670 006e4000-006f3000 rw-p 000e9000 fd:01 49717                              /usr/lib/libOpenIPMI.so.0.0.5
 11147:20140430:071415.670 006f3000-006f5000 rw-p 00000000 00:00 0 
 11229:20140430:071415.646 proxy #94 started [unreachable poller #16]
 11147:20140430:071415.670 006f5000-0070c000 r-xp 00000000 fd:01 48506                              /lib/libpthread-2.12.so
 11147:20140430:071415.670 0070c000-0070d000 r--p 00016000 fd:01 48506                              /lib/libpthread-2.12.so
 11147:20140430:071415.670 0070d000-0070e000 rw-p 00017000 fd:01 48506                              /lib/libpthread-2.12.so
 11147:20140430:071415.670 0070e000-00710000 rw-p 00000000 00:00 0 
 11147:20140430:071415.670 00710000-00732000 r-xp 00000000 fd:01 38496                              /lib/libncurses.so.5.7
 11147:20140430:071415.670 00732000-00733000 rw-p 00021000 fd:01 38496                              /lib/libncurses.so.5.7
 11147:20140430:071415.670 00733000-0076c000 r-xp 00000000 fd:01 49695                              /usr/lib/libssl3.so
 11147:20140430:071415.670 0076c000-0076e000 r--p 00038000 fd:01 49695                              /usr/lib/libssl3.so
 11147:20140430:071415.670 0076e000-0076f000 rw-p 0003a000 fd:01 49695                              /usr/lib/libssl3.so
 11260:20140430:071415.646 proxy #125 started [unreachable poller #47]
 11147:20140430:071415.670 0076f000-00778000 r-xp 00000000 fd:01 49345                              /lib/libkrb5support.so.0.1
 11147:20140430:071415.670 00778000-00779000 r--p 00008000 fd:01 49345                              /lib/libkrb5support.so.0.1
 11147:20140430:071415.670 00779000-0077a000 rw-p 00009000 fd:01 49345                              /lib/libkrb5support.so.0.1
 11147:20140430:071415.670 0077a000-0077c000 r-xp 00000000 fd:01 49334                              /lib/libkeyutils.so.1.3
 11147:20140430:071415.670 0077c000-0077d000 r--p 00001000 fd:01 49334                              /lib/libkeyutils.so.1.3
 11147:20140430:071415.670 0077d000-0077e000 rw-p 00002000 fd:01 49334                              /lib/libkeyutils.so.1.3
 11147:20140430:071415.670 0077e000-0077f000 r-xp 00000000 fd:01 49426                              /lib/libaio.so.1.0.1
 11147:20140430:071415.670 0077f000-00780000 rw-p 00000000 fd:01 49426                              /lib/libaio.so.1.0.1
 11147:20140430:071415.670 00786000-0082d000 r-xp 00000000 fd:01 49742                              /usr/lib/libnetsnmp.so.20.0.0
 11147:20140430:071415.670 0082d000-0082f000 r--p 000a6000 fd:01 49742                              /usr/lib/libnetsnmp.so.20.0.0
 11147:20140430:071415.670 0082f000-00831000 rw-p 000a8000 fd:01 49742                              /usr/lib/libnetsnmp.so.20.0.0
 11147:20140430:071415.670 00831000-00851000 rw-p 00000000 00:00 0 
 11147:20140430:071415.670 00851000-009e1000 r-xp 00000000 fd:01 48482                              /lib/libc-2.12.so
 11147:20140430:071415.670 009e1000-009e3000 r--p 0018f000 fd:01 48482                              /lib/libc-2.12.so
 11147:20140430:071415.670 009e3000-009e4000 rw-p 00191000 fd:01 48482                              /lib/libc-2.12.so
 11147:20140430:071415.670 009e4000-009e7000 rw-p 00000000 00:00 0 
 11147:20140430:071415.670 009e7000-00a0f000 r-xp 00000000 fd:01 49694                              /usr/lib/libsmime3.so
 11147:20140430:071415.670 00a0f000-00a11000 r--p 00027000 fd:01 49694                              /usr/lib/libsmime3.so
 11147:20140430:071415.670 00a11000-00a12000 rw-p 00029000 fd:01 49694                              /usr/lib/libsmime3.so
 11147:20140430:071415.670 00a12000-00a1a000 r-xp 00000000 fd:01 48494                              /lib/libnss_compat-2.12.so
 11147:20140430:071415.670 00a1a000-00a1b000 r--p 00007000 fd:01 48494                              /lib/libnss_compat-2.12.so
 11147:20140430:071415.670 00a1b000-00a1c000 rw-p 00008000 fd:01 48494                              /lib/libnss_compat-2.12.so
 11147:20140430:071415.670 00a22000-00a2b000 r-xp 00000000 fd:01 49120                              /usr/lib/libltdl.so.7.2.1
 11147:20140430:071415.670 00a2b000-00a2c000 rw-p 00008000 fd:01 49120                              /usr/lib/libltdl.so.7.2.1
 11147:20140430:071415.670 00a2c000-00a48000 r-xp 00000000 fd:01 49391                              /usr/lib/libnssutil3.so
 11147:20140430:071415.670 00a48000-00a4b000 r--p 0001c000 fd:01 49391                              /usr/lib/libnssutil3.so
 11147:20140430:071415.670 00a4b000-00a4c000 rw-p 0001f000 fd:01 49391                              /usr/lib/libnssutil3.so
 11147:20140430:071415.670 00a4c000-00a86000 r-xp 00000000 fd:01 49596                              /lib/libnspr4.so
 11147:20140430:071415.671 00a86000-00a87000 r--p 00039000 fd:01 49596                              /lib/libnspr4.so
 11147:20140430:071415.671 00a87000-00a88000 rw-p 0003a000 fd:01 49596                              /lib/libnspr4.so
 11147:20140430:071415.671 00a88000-00a8a000 rw-p 00000000 00:00 0 
 11147:20140430:071415.671 00a8a000-00abb000 r-xp 00000000 fd:01 49681                              /lib/libidn.so.11.6.1
 11147:20140430:071415.671 00abb000-00abc000 rw-p 00030000 fd:01 49681                              /lib/libidn.so.11.6.1
 11147:20140430:071415.671 00abc000-00af9000 r-xp 00000000 fd:01 49337                              /lib/libgssapi_krb5.so.2.2
 11147:20140430:071415.671 00af9000-00afa000 r--p 0003c000 fd:01 49337                              /lib/libgssapi_krb5.so.2.2
 11147:20140430:071415.671 00afa000-00afb000 rw-p 0003d000 fd:01 49337                              /lib/libgssapi_krb5.so.2.2
 11147:20140430:071415.671 00afb000-00b24000 r-xp 00000000 fd:01 49341                              /lib/libk5crypto.so.3.1
 11147:20140430:071415.671 00b24000-00b25000 ---p 00029000 fd:01 49341                              /lib/libk5crypto.so.3.1
 11147:20140430:071415.671 00b25000-00b26000 r--p 00029000 fd:01 49341                              /lib/libk5crypto.so.3.1
 11147:20140430:071415.671 00b26000-00b27000 rw-p 0002a000 fd:01 49341                              /lib/libk5crypto.so.3.1
 11147:20140430:071415.671 00b27000-00b31000 r-xp 00000000 fd:01 48502                              /lib/libnss_nis-2.12.so
 11147:20140430:071415.671 00b31000-00b32000 r--p 00009000 fd:01 48502                              /lib/libnss_nis-2.12.so
 11147:20140430:071415.671 00b32000-00b33000 rw-p 0000a000 fd:01 48502                              /lib/libnss_nis-2.12.so
 11147:20140430:071415.671 00b3f000-00b92000 r-xp 00000000 fd:01 49709                              /usr/lib/libcurl.so.4.1.1
 11147:20140430:071415.671 00b92000-00b94000 rw-p 00052000 fd:01 49709                              /usr/lib/libcurl.so.4.1.1
 11147:20140430:071415.671 00b94000-00bdd000 r-xp 00000000 fd:01 48472                              /lib/libfreebl3.so
 11147:20140430:071415.671 00bdd000-00bde000 r--p 00048000 fd:01 48472                              /lib/libfreebl3.so
 11147:20140430:071415.671 00bde000-00bdf000 rw-p 00049000 fd:01 48472                              /lib/libfreebl3.so
 11147:20140430:071415.671 00bdf000-00be3000 rw-p 00000000 00:00 0 
 11147:20140430:071415.671 00be3000-00bf9000 r-xp 00000000 fd:01 38553                              /lib/libtinfo.so.5.7
 11147:20140430:071415.671 00bf9000-00bfc000 rw-p 00015000 fd:01 38553                              /lib/libtinfo.so.5.7
 11147:20140430:071415.671 00bfc000-00c08000 r-xp 00000000 fd:01 48498                              /lib/libnss_files-2.12.so
 11147:20140430:071415.671 00c08000-00c09000 r--p 0000b000 fd:01 48498                              /lib/libnss_files-2.12.so
 11147:20140430:071415.671 00c09000-00c0a000 rw-p 0000c000 fd:01 48498                              /lib/libnss_files-2.12.so
 11147:20140430:071415.671 00c11000-00d56000 r-xp 00000000 fd:01 49683                              /usr/lib/libxml2.so.2.7.6
 11147:20140430:071415.671 00d56000-00d5b000 rw-p 00144000 fd:01 49683                              /usr/lib/libxml2.so.2.7.6
 11147:20140430:071415.671 00d5b000-00d5c000 rw-p 00000000 00:00 0 
 11147:20140430:071415.671 00d5c000-00d79000 r-xp 00000000 fd:01 28166                              /lib/libselinux.so.1
 11147:20140430:071415.671 00d79000-00d7a000 r--p 0001c000 fd:01 28166                              /lib/libselinux.so.1
 11147:20140430:071415.671 00d7a000-00d7b000 rw-p 0001d000 fd:01 28166                              /lib/libselinux.so.1
 11147:20140430:071415.671 00d7b000-00d93000 r-xp 00000000 fd:02 5359                               /opt/unixODBC/lib/libodbcinst.so
 11147:20140430:071415.671 00d93000-00d95000 rw-p 00017000 fd:02 5359                               /opt/unixODBC/lib/libodbcinst.so
 11147:20140430:071415.671 00d95000-00db2000 r-xp 00000000 fd:01 18775                              /lib/libgcc_s-4.4.6-20120305.so.1
 11147:20140430:071415.671 00db2000-00db3000 rw-p 0001d000 fd:01 18775                              /lib/libgcc_s-4.4.6-20120305.so.1
 11147:20140430:071415.671 00dd4000-00dd7000 r-xp 00000000 fd:01 49330                              /lib/libcom_err.so.2.1
 11147:20140430:071415.671 00dd7000-00dd8000 r--p 00002000 fd:01 49330                              /lib/libcom_err.so.2.1
 11147:20140430:071415.671 00dd8000-00dd9000 rw-p 00003000 fd:01 49330                              /lib/libcom_err.so.2.1
 11147:20140430:071415.671 00dda000-00ddd000 r-xp 00000000 fd:01 49601                              /lib/libplds4.so
 11147:20140430:071415.671 00ddd000-00dde000 r--p 00002000 fd:01 49601                              /lib/libplds4.so
 11147:20140430:071415.671 00dde000-00ddf000 rw-p 00003000 fd:01 49601                              /lib/libplds4.so
 11147:20140430:071415.671 00deb000-00dec000 r-xp 00000000 00:00 0                                  [vdso]
 11147:20140430:071415.671 00e4b000-00e58000 r-xp 00000000 fd:01 49697                              /lib/liblber-2.4.so.2.5.6
 11147:20140430:071415.671 00e58000-00e59000 r--p 0000d000 fd:01 49697                              /lib/liblber-2.4.so.2.5.6
 11147:20140430:071415.671 00e59000-00e5a000 rw-p 0000e000 fd:01 49697                              /lib/liblber-2.4.so.2.5.6
 11147:20140430:071415.671 00e5a000-00ed7000 r-xp 00000000 fd:02 1312                               /opt/u01/app/oracle/product/11.2.0/client/lib/libsqora.so.11.1
 11147:20140430:071415.671 00ed7000-00eed000 rw-p 0007d000 fd:02 1312                               /opt/u01/app/oracle/product/11.2.0/client/lib/libsqora.so.11.1
 11147:20140430:071415.671 00efe000-00f17000 r-xp 00000000 fd:01 49622                              /usr/lib/libsasl2.so.2.0.23
 11147:20140430:071415.671 00f17000-00f18000 r--p 00018000 fd:01 49622                              /usr/lib/libsasl2.so.2.0.23
 11147:20140430:071415.672 00f18000-00f19000 rw-p 00019000 fd:01 49622                              /usr/lib/libsasl2.so.2.0.23
 11147:20140430:071415.672 00f5a000-00f81000 r-xp 00000000 fd:01 38495                              /usr/lib/libssh2.so.1.0.1
 11147:20140430:071415.672 00f81000-00f82000 rw-p 00026000 fd:01 38495                              /usr/lib/libssh2.so.1.0.1
 11147:20140430:071415.672 00fa4000-00fc2000 r-xp 00000000 fd:01 4934                               /lib/ld-2.12.so
 11147:20140430:071415.672 00fc2000-00fc3000 r--p 0001d000 fd:01 4934                               /lib/ld-2.12.so
 11147:20140430:071415.672 00fc3000-00fc4000 rw-p 0001e000 fd:01 4934                               /lib/ld-2.12.so
 11147:20140430:071415.672 00fc4000-010f9000 r-xp 00000000 fd:01 17073                              /usr/lib/libnss3.so
 11147:20140430:071415.672 010f9000-010fc000 r--p 00134000 fd:01 17073                              /usr/lib/libnss3.so
 11147:20140430:071415.672 010fc000-010fe000 rw-p 00137000 fd:01 17073                              /usr/lib/libnss3.so
 11147:20140430:071415.672 010fe000-011cd000 r-xp 00000000 fd:01 49343                              /lib/libkrb5.so.3.3
 11147:20140430:071415.672 011cd000-011d3000 r--p 000ce000 fd:01 49343                              /lib/libkrb5.so.3.3
 11147:20140430:071415.672 011d3000-011d4000 rw-p 000d4000 fd:01 49343                              /lib/libkrb5.so.3.3
 11147:20140430:071415.672 03ac9000-03ce6000 r-xp 00000000 fd:02 1327                               /opt/u01/app/oracle/product/11.2.0/client/lib/libnnz11.so
 11147:20140430:071415.672 03ce6000-03d14000 rw-p 0021d000 fd:02 1327                               /opt/u01/app/oracle/product/11.2.0/client/lib/libnnz11.so
 11147:20140430:071415.672 03d14000-03d16000 rw-p 00000000 00:00 0 
 11147:20140430:071415.672 04a00000-06607000 r-xp 00000000 fd:02 1094                               /opt/u01/app/oracle/product/11.2.0/client/lib/libclntsh.so.11.1
 11147:20140430:071415.672 06607000-066eb000 rw-p 01c07000 fd:02 1094                               /opt/u01/app/oracle/product/11.2.0/client/lib/libclntsh.so.11.1
 11147:20140430:071415.672 066eb000-06705000 rw-p 00000000 00:00 0 
 11147:20140430:071415.672 08048000-0814f000 r-xp 00000000 fd:01 50130                              /usr/sbin/zabbix_proxy_mysql
 11147:20140430:071415.672 0814f000-08181000 rw-p 00106000 fd:01 50130                              /usr/sbin/zabbix_proxy_mysql
 11147:20140430:071415.672 08181000-08188000 rw-p 00000000 00:00 0 
 11147:20140430:071415.672 08687000-086a8000 rw-p 00000000 00:00 0 
 11147:20140430:071415.672 086a8000-086db000 rw-p 00000000 00:00 0 
 11147:20140430:071415.672 086db000-0878d000 rw-p 00000000 00:00 0 
 11147:20140430:071415.672 f0725000-f0748000 rw-p 00000000 00:00 0 
 11147:20140430:071415.672 f0755000-f0756000 rw-p 00000000 00:00 0 
 11147:20140430:071415.672 f0756000-f075d000 r--s 00000000 fd:01 146034                             /usr/lib/gconv/gconv-modules.cache
 11147:20140430:071415.672 f075d000-f075e000 rw-s 00000000 00:04 6127636                            /SYSV7901c370 (deleted)
 11147:20140430:071415.672 f075e000-f095e000 r--p 00000000 fd:01 4925                               /usr/lib/locale/locale-archive
 11147:20140430:071415.672 f095e000-f275e000 rw-s 00000000 00:04 12812293                           /SYSV7701c392 (deleted)
 11147:20140430:071415.672 f275e000-f276d000 rw-s 00000000 00:04 12779524                           /SYSV5301c392 (deleted)
 11147:20140430:071415.672 f276d000-f29d4000 rw-s 00000000 00:04 12746755                           /SYSV7301c392 (deleted)
 11147:20140430:071415.672 f29d4000-f376e000 rw-s 00000000 00:04 12713986                           /SYSV6701c392 (deleted)
 11147:20140430:071415.672 f376e000-f576e000 rw-s 00000000 00:04 12681217                           /SYSV7801c392 (deleted)
 11147:20140430:071415.672 f576e000-f776e000 rw-s 00000000 00:04 12648448                           /SYSV6801c392 (deleted)
 11147:20140430:071415.672 f776e000-f777a000 rw-p 00000000 00:00 0 
 11147:20140430:071415.672 f7787000-f7788000 rw-p 00000000 00:00 0 
 11147:20140430:071415.672 f7788000-f7789000 rw-p 00000000 00:00 0 
 11147:20140430:071415.672 fff95000-fffc5000 rwxp 00000000 00:00 0                                  [stack]
 11147:20140430:071415.672 ================================
 11147:20140430:071415.672 Please consider attaching a disassembly listing to your bug report.
 11147:20140430:071415.672 This listing can be produced with, e.g., objdump -DSswx zabbix_proxy.
 11147:20140430:071415.672 ================================
 11123:20140430:071415.673 One child process died (PID:11147,exitcode/signal:11). Exiting ...
Comment by Juris Miščenko (Inactive) [ 2014 Jun 02 ]

Brian, what version of ODBC is that and what version of the MySQL ODBC driver are you using?
I'm marking this as needing information. Whoever replies - please reopen the issue.

Comment by Brian Chand [ 2014 Jun 02 ]

ODBC package is unixodbc version 2.2.14p2-5
MySQL is 5.2.7

Comment by Juris Miščenko (Inactive) [ 2014 Jun 03 ]

Although I've tried, I can't seem to reproduce this. Also, what is the version of the MySQL client library and the odbc mysql driver? On Ubuntu, you should be able to see this via dpkg -l | grep libmyodbc | awk '{print $3}'.

Comment by Brian Chand [ 2014 Jun 03 ]

The command outputs version 5.1.10-1

Comment by v99glu [ 2014 Jun 04 ]

I also have this problem with database monitor item quering Oracle Database. My environment is: CentOS 6.5 x86_64, uname - Linux 2.6.32-431.el6.x86_64 #1 SMP x86_64 x86_64 x86_64 GNU/Linux, Zabbix server v2.2.1 (revision 40808), unixODBC 2.3.2, mysql-server-5.1.71-1.el6.x86_64, Oracle instant client 11.2.0.4.0.

At the same time, database monitor items quering MySQL Database work well.

Comment by Juris Miščenko (Inactive) [ 2014 Jun 04 ]

Brian, MySQL 5.2.x, 5.3.x and 5.4.x were never released as stable and neither are they available via the 12.04 Ubuntu repos. The 5.5.x branch was started back in 2009. How did you get 5.2.7 on your system? Is the MySQL client library also from the same tree? Run the following command and paste the output here in a comment: dpkg -l | grep -i libmysqlclient | sed -E 's/ii [^ ] ([^ ]) [^ ] ([^ ])/\1 : \2/'

Comment by Oleksii Zagorskyi [ 2014 Jun 09 ]

See also ZBX-8322

Comment by Brian Chand [ 2014 Jun 09 ]

Here's the full breakdown:
odbcinst.ini and odbc.ini are pointing to libmyodbc5a from package mysql-connector-odbc-5.2.6-linux-debian6.0-x86-64bit obtained from dev.mysql.com.

libmyodbc is version 5.1.10-1

libmysql dpkg output is:
ii libmysqlclient18 1:5.5.34-rel32.0-591.precise Percona Server database client library

I'm using libmyodbc5a instead of libmyodbc to avoid this bug:
https://bugs.launchpad.net/percona-server/+bug/1089968

Comment by Juris Miščenko (Inactive) [ 2014 Jun 11 ]

Brian, I couldn't reproduce this behaviour and seeing as the crash is occuring inside the libmysqlclient library, this means I have to delve into that codebase to see what's happening. The problem with that is that as your library compilation doesn't include debug symbols, it would take some extra effort to find the problem. Unfortunately, all of that is offset by the fact that you're using an unstable, stale and never released version of MySQL.

It has been decided to not fix this as this issue maybe occurring due to those factors.

The only thing I can advise you is to upgrade your database to a stable version like the 5.5.x branch and see if the behavior repeats. If it does, reopen this issue ticket with the gathered information.

Thank you.

Comment by Aleksandrs Saveljevs [ 2014 Aug 22 ]

While investigating ZBX-8629, I have managed to reproduce this crash with unixODBC 2.3.1 and a manually downloaded MySQL ODBC connector 5.3.4 (from http://dev.mysql.com/downloads/connector/odbc/). With MySQL driver 5.1.x, which is currently available in Debian packages, it seems to work fine.

This crash in odbc_DBconnect() happens with libmyodbc5a.so, the ANSI version of MySQL driver. With the Unicode version of the library, libmyodbc5w.so, it connects successfully, but hangs in odbc_DBselect().

Reopening to investigate...

Comment by Aleksandrs Saveljevs [ 2014 Aug 25 ]

Unlike ZBX-8629, this does not look to be a problem with Zabbix. Reported a bug on MySQL tracker: http://bugs.mysql.com/73709 .

Comment by Aleksandrs Saveljevs [ 2014 Aug 25 ]

Closing as "Won't fix" again because there seems to be nothing to fix on Zabbix side. Will reopen if it turns out otherwise.

Comment by natalyad [ 2015 Jan 09 ]

Hi Aleksandrs,

I see that the issue was closed , but i still would like to know how to solve this problem
suitable to this issue :http://bugs.mysql.com/73709
should i compile the zabbix_server somehow differently ?

Comment by Aleksandrs Saveljevs [ 2015 Jan 09 ]

natad, there currently seems to be no solution on Zabbix side. At least I am not aware of one and we should wait until the bug is fixed on MySQL side. Thank you for asking for details on the MySQL bug tracker!

One workaround would be to try to find versions of libmysqlclient and libmyodbc that work well together. If we can trust one of my comments above, then MySQL driver 5.1.x worked well with libmysqlclient that I had installed on Debian in August.

Another workaround that we use for ODBC development is we use another database as the main Zabbix database. For instance, if we wish to test MySQL ODBC, then we use PostgreSQL as the Zabbix backend. However, that might obviously not be a good solution for production environments.

Comment by natalyad [ 2015 Jan 09 ]

Hi Aleksandrs,
I tried this one on el6 :

"One workaround would be to try to find versions of libmysqlclient and libmyodbc that work well together. If we can trust one of my comments above, then MySQL driver 5.1.x worked well with libmysqlclient that I had installed on Debian in August."

as you wrote and iny case i received crach .
Do zabbix have other way to do mysql queries ?

Comment by Aleksandrs Saveljevs [ 2015 Jan 10 ]

Yet another workaround would be to install a SQLite3-based Zabbix proxy and perform MySQL ODBC queries through that. This is a variation of the second workaround mentioned above.

Comment by Aleksandrs Saveljevs [ 2015 Oct 19 ]

One of the working workarounds is described in ZBX-9960.

Comment by Aleksandrs Saveljevs [ 2015 Oct 28 ]

Thanks to martins-v, this issue has been documented at https://www.zabbix.com/documentation/3.0/manual/config/items/itemtypes/odbc_checks#important_notes and https://www.zabbix.com/documentation/3.0/manual/installation/known_issues?&#odbc_checks .

Comment by Eduardo Wutzl da Silva [ 2015 Oct 29 ]

In version 7 and 8 of Debian, we switched to the driver that was installed via apt-get package with

ii  libmyodbc:amd64                5.1.10-3                    amd64        the MySQL ODBC driver
ii  libodbc1:amd64                 2.3.1-3                     amd64        ODBC library for Unix
ii  odbcinst                       2.3.1-3                     amd64        Helper program for accessing odbc ini files
ii  odbcinst1debian2:amd64         2.3.1-3                     amd64        Support library for accessing odbc ini files
ii  unixodbc                       2.3.1-3                     amd64        Basic ODBC tools
ii  unixodbc-dev                   2.3.1-3                     amd64        ODBC libraries for UNIX (development files)

The drivers are in

 /usr/lib/x86_64-linux-gnu/odbc/ 

Sample configuration.

[mysql]
Description = ODBC for MySQL
Driver  = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so
Setup	= /usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so

Item was supported again and no longer occur crashes

Regard's

Comment by Michael Mol [ 2016 Apr 12 ]

This was working fine for me in Zabbix 3.0.1 with MySQL 3.6 for a while, and then it broke again.

Zabbix could fix this by having the MySQL ODBC poller relegate ODBC queries out to a subprocess that doesn't link against libmysql. This would be a very simple (if not ideal, from an efficiency standpoint) solution that would armor the Zabbix server and proxy architecture against future issues like these.

Comment by kanibal [ 2016 Jul 23 ]

There was a change of SQLLEN size from 4 to 8 bytes for 64 bit platforms between unixODBC versions 2.2.14 and 2.3.x, hence different major versions of the library (libodbc.so.1 and libodbc.so.2). As they say, this can affect drivers compiled with old definition of SQLLEN type. Please try with unixODBC 2.2.14

Comment by kanibal [ 2016 Jul 23 ]

I had the same issue with Oracle Client, it looks like that there was a change of SQLLEN size from 4 to 8 bytes for 64 bit platforms between unixODBC versions 2.2.14 and 2.3.x, hence different major versions of the library (libodbc.so.1 and libodbc.so.2). This can affect drivers compiled with old definition of SQLLEN type. I remove installed unixODBC 2.3 of Base repo of CentOS 7 and manually install 2.2.14 from base repo of CentOS 6. Also I use the Oracle client 11.2.0.4 that is the recommended for unixODBC 2.2.14.
Additional, I added the enviroment variables to the systemd script of zabbix-server, because, systemd units don't take enviroments from the system. This was checking the EnviromentFile variable of the script

[root@zabbix ~]# cat /usr/lib/systemd/system/zabbix-server.service
[Unit]
Description=Zabbix Server
After=syslog.target
After=network.target

[Service]
Environment="CONFFILE=/etc/zabbix/zabbix_server.conf"
EnvironmentFile=-/etc/sysconfig/zabbix-server
Type=forking
Restart=on-failure
PIDFile=/run/zabbix/zabbix_server.pid
KillMode=control-group
ExecStart=/usr/sbin/zabbix_server -c $CONFFILE
ExecStop=/bin/kill -SIGTERM $MAINPID
RestartSec=10s

[Install]
WantedBy=multi-user.target

And later adding to the file that is called:

[root@zabbix ~]# cat /etc/sysconfig/zabbix-server
ORACLE_HOME=/usr/lib/oracle/11.2/client64
LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib:/usr/lib64:/usr/lib:$LD_LIBRARY_PATH
TNS_ADMIN=/usr/lib/oracle/11.2/client64/network/admin
PATH=$PATH:$ORACLE_HOME/bin

You can check this by findind the main pid of zabbix-server and runnning:

[root@zabbix ~]# strings -a /proc/24415/environ 
LANG=en_US.UTF-8
PATH=$PATH:$ORACLE_HOME/bin
CONFFILE=/etc/zabbix/zabbix_server.conf
ORACLE_HOME=/usr/lib/oracle/11.2/client64
LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib:/usr/lib64:/usr/lib:$LD_LIBRARY_PATH
TNS_ADMIN=/usr/lib/oracle/11.2/client64/network/admin

Let me know if this helps.

Setup

Using zabbix 3, CentOS 7, Postgres and Nginx.

Comment by Kevin Doren [ 2018 Aug 03 ]

This bug has been with us since Zabbix 2.0.  Under CentOS 7 with Zabbix 3.4, there is only one version of mysql-connector-odbc which I found to work.

https://repo.mysql.com/yum/mysql-connectors-community/el/7/x86_64/mysql-connector-odbc-5.2.7-1.el7.x86_64.rpm

All other versions (i.e. 5.3.11 and  8.0.12) cause zabbix to crash.

FYI you can add the following line to /etc/yum.conf to prevent accidentally updating it:

exclude=mysql-connector-odbc # keep using mysql-connector-odbc.x86_64 0:5.2.7-1.el7 (newer versions can crash Zabbix)

Comment by Mathias Hallski [ 2018 Oct 08 ]

We hit the same problem, CentOS 7 with Zabbix 3.4.  Tried following Kevin's suggestion (using the official MySQL RPM for odbc-5.2.7-1.el7) but without any success.  YMMV.

What we did get to work was moving all the ODBC related checks to a minimally lightweight Zabbix proxy, using SQLite.  I think going forward we'll probably use this approach increasingly - keeping the central Zabbix server itself doing little more than collecting via active proxies at our various sites, with all proxies using SQLite which "side steps" the issue of ODBC compatibility.

Comment by Kirill Sklyarov [ 2019 Apr 10 ]
*** Error in `/usr/sbin/zabbix_server: poller #47 [got 0 values in 0.000027 sec, getting values]': free(): invalid pointer: 0x000055cee72f7718 ***
======= Backtrace: =========
/lib64/libc.so.6(+0x81489)[0x7f2c579c4489]
/usr/lib64/libmyodbc5w.so(MySQLGetPrivateProfileStringW+0x110)[0x7f2c28799160]
/usr/lib64/libmyodbc5w.so(ds_lookup+0x4e)[0x7f2c28798c3e]
/usr/lib64/libmyodbc5w.so(MySQLConnect+0xcd)[0x7f2c286e7e8d]
/lib64/libodbc.so.2(SQLConnect+0xa63)[0x7f2c597073b3]
/usr/sbin/zabbix_server: poller #47 [got 0 values in 0.000027 sec, getting values](zbx_odbc_connect+0x1ad)[0x55cee501c5eb]
/usr/sbin/zabbix_server: poller #47 [got 0 values in 0.000027 sec, getting values](get_value_db+0x221)[0x55cee4ff07e9]
/usr/sbin/zabbix_server: poller #47 [got 0 values in 0.000027 sec, getting values](+0x52230)[0x55cee4fe1230]
/usr/sbin/zabbix_server: poller #47 [got 0 values in 0.000027 sec, getting values](+0x54850)[0x55cee4fe3850]
/usr/sbin/zabbix_server: poller #47 [got 0 values in 0.000027 sec, getting values](poller_thread+0x1b7)[0x55cee4fe48ec]
/usr/sbin/zabbix_server: poller #47 [got 0 values in 0.000027 sec, getting values](zbx_thread_start+0x37)[0x55cee5130964]
/usr/sbin/zabbix_server: poller #47 [got 0 values in 0.000027 sec, getting values](MAIN_ZABBIX_ENTRY+0x9c3)[0x55cee4fcec26]
/usr/sbin/zabbix_server: poller #47 [got 0 values in 0.000027 sec, getting values](daemon_start+0x31b)[0x55cee5122b82]
/usr/sbin/zabbix_server: poller #47 [got 0 values in 0.000027 sec, getting values](main+0x312)[0x55cee4fce261]
/lib64/libc.so.6(__libc_start_main+0xf5)[0x7f2c579653d5]
/usr/sbin/zabbix_server: poller #47 [got 0 values in 0.000027 sec, getting values](+0x3e369)[0x55cee4fcd369]
======= Memory map: ========
55cee4f8f000-55cee5255000 r-xp 00000000 fd:00 12422                      /usr/sbin/zabbix_server_mysql
55cee5454000-55cee54c1000 r--p 002c5000 fd:00 12422                      /usr/sbin/zabbix_server_mysql
55cee54c1000-55cee54cc000 rw-p 00332000 fd:00 12422                      /usr/sbin/zabbix_server_mysql
55cee54cc000-55cee54d5000 rw-p 00000000 00:00 0
55cee71da000-55cee71fb000 rw-p 00000000 00:00 0                          [heap]
55cee71fb000-55cee728b000 rw-p 00000000 00:00 0                          [heap]
55cee728b000-55cee741c000 rw-p 00000000 00:00 0                          [heap]
7f2c24000000-7f2c24021000 rw-p 00000000 00:00 0
7f2c24021000-7f2c28000000 ---p 00000000 00:00 0
7f2c28485000-7f2c28495000 r-xp 00000000 fd:00 20013                      /usr/lib64/libodbcinst.so.2.0.0
7f2c28495000-7f2c28695000 ---p 00010000 fd:00 20013                      /usr/lib64/libodbcinst.so.2.0.0
7f2c28695000-7f2c28696000 r--p 00010000 fd:00 20013                      /usr/lib64/libodbcinst.so.2.0.0
7f2c28696000-7f2c28697000 rw-p 00011000 fd:00 20013                      /usr/lib64/libodbcinst.so.2.0.0
7f2c28697000-7f2c289cc000 r-xp 00000000 fd:00 21629                      /usr/lib64/libmyodbc5w.so
7f2c289cc000-7f2c28bcb000 ---p 00335000 fd:00 21629                      /usr/lib64/libmyodbc5w.so
7f2c28bcb000-7f2c28cad000 rw-p 00334000 fd:00 21629                      /usr/lib64/libmyodbc5w.so
7f2c28cad000-7f2c28cb2000 rw-p 00000000 00:00 0
7f2c28cb2000-7f2c28cb4000 r-xp 00000000 fd:00 3638                       /usr/lib64/gconv/ISO8859-1.so
7f2c28cb4000-7f2c28eb3000 ---p 00002000 fd:00 3638                       /usr/lib64/gconv/ISO8859-1.so
7f2c28eb3000-7f2c28eb4000 r--p 00001000 fd:00 3638                       /usr/lib64/gconv/ISO8859-1.so
7f2c28eb4000-7f2c28eb5000 rw-p 00002000 fd:00 3638                       /usr/lib64/gconv/ISO8859-1.so
7f2c28eb5000-7f2c28eba000 r-xp 00000000 fd:00 3419                       /usr/lib64/libnss_dns-2.17.so
7f2c28eba000-7f2c290ba000 ---p 00005000 fd:00 3419                       /usr/lib64/libnss_dns-2.17.so
7f2c290ba000-7f2c290bb000 r--p 00005000 fd:00 3419                       /usr/lib64/libnss_dns-2.17.so
7f2c290bb000-7f2c290bc000 rw-p 00006000 fd:00 3419                       /usr/lib64/libnss_dns-2.17.so
7f2c290bc000-7f2c290e4000 r-xp 00000000 fd:00 21132                      /usr/lib64/libnsspem.so
7f2c290e4000-7f2c292e4000 ---p 00028000 fd:00 21132                      /usr/lib64/libnsspem.so
7f2c292e4000-7f2c292e5000 r--p 00028000 fd:00 21132                      /usr/lib64/libnsspem.so
7f2c292e5000-7f2c292e6000 rw-p 00029000 fd:00 21132                      /usr/lib64/libnsspem.so
7f2c292e6000-7f2c292e8000 r-xp 00000000 fd:00 5425                       /usr/lib64/libnsssysinit.so
7f2c292e8000-7f2c294e7000 ---p 00002000 fd:00 5425                       /usr/lib64/libnsssysinit.so
7f2c294e7000-7f2c294e8000 r--p 00001000 fd:00 5425                       /usr/lib64/libnsssysinit.so
7f2c294e8000-7f2c294e9000 rw-p 00002000 fd:00 5425                       /usr/lib64/libnsssysinit.so
7f2c294e9000-7f2c2956c000 r-xp 00000000 fd:00 3074                       /usr/lib64/libfreeblpriv3.so
7f2c2956c000-7f2c2976b000 ---p 00083000 fd:00 3074                       /usr/lib64/libfreeblpriv3.so
7f2c2976b000-7f2c2976d000 r--p 00082000 fd:00 3074                       /usr/lib64/libfreeblpriv3.so
7f2c2976d000-7f2c2976e000 rw-p 00084000 fd:00 3074                       /usr/lib64/libfreeblpriv3.so
7f2c2976e000-7f2c29772000 rw-p 00000000 00:00 0
7f2c29772000-7f2c29823000 r-xp 00000000 fd:00 4735                       /usr/lib64/libsqlite3.so.0.8.6
7f2c29823000-7f2c29a22000 ---p 000b1000 fd:00 4735                       /usr/lib64/libsqlite3.so.0.8.6
7f2c29a22000-7f2c29a24000 r--p 000b0000 fd:00 4735                       /usr/lib64/libsqlite3.so.0.8.6
7f2c29a24000-7f2c29a27000 rw-p 000b2000 fd:00 4735                       /usr/lib64/libsqlite3.so.0.8.6
7f2c29a27000-7f2c29a63000 r-xp 00000000 fd:00 5423                       /usr/lib64/libsoftokn3.so
7f2c29a63000-7f2c29c63000 ---p 0003c000 fd:00 5423                       /usr/lib64/libsoftokn3.so
7f2c29c63000-7f2c29c64000 r--p 0003c000 fd:00 5423                       /usr/lib64/libsoftokn3.so
7f2c29c64000-7f2c29c65000 rw-p 0003d000 fd:00 5423                       /usr/lib64/libsoftokn3.so
7f2c29c65000-7f2c3018f000 r--p 00000000 fd:00 21113                      /usr/lib/locale/locale-archive
7f2c3018f000-7f2c3818f000 rw-s 00000000 00:04 4423687                    /SYSV00000000 (deleted)
7f2c3818f000-7f2c4818f000 rw-s 00000000 00:04 4358149                    /SYSV00000000 (deleted)
7f2c4818f000-7f2c5018f000 rw-s 00000000 00:04 4325380                    /SYSV00000000 (deleted)
7f2c5018f000-7f2c5218f000 rw-s 00000000 00:04 4292611                    /SYSV00000000 (deleted)
7f2c5218f000-7f2c5418f000 rw-s 00000000 00:04 4259842                    /SYSV00000000 (deleted)
7f2c5418f000-7f2c5419b000 r-xp 00000000 fd:00 3421                       /usr/lib64/libnss_files-2.17.so
7f2c5419b000-7f2c5439a000 ---p 0000c000 fd:00 3421                       /usr/lib64/libnss_files-2.17.so
7f2c5439a000-7f2c5439b000 r--p 0000b000 fd:00 3421                       /usr/lib64/libnss_files-2.17.so
7f2c5439b000-7f2c5439c000 rw-p 0000c000 fd:00 3421                       /usr/lib64/libnss_files-2.17.so
7f2c5439c000-7f2c543a2000 rw-p 00000000 00:00 0
7f2c543a2000-7f2c543a4000 r-xp 00000000 fd:00 3072                       /usr/lib64/libfreebl3.so
7f2c543a4000-7f2c545a3000 ---p 00002000 fd:00 3072                       /usr/lib64/libfreebl3.so
7f2c545a3000-7f2c545a4000 r--p 00001000 fd:00 3072                       /usr/lib64/libfreebl3.so
7f2c545a4000-7f2c545a5000 rw-p 00002000 fd:00 3072                       /usr/lib64/libfreebl3.so
7f2c545a5000-7f2c545c9000 r-xp 00000000 fd:00 3922                       /usr/lib64/libselinux.so.1
7f2c545c9000-7f2c547c8000 ---p 00024000 fd:00 3922                       /usr/lib64/libselinux.so.1
7f2c547c8000-7f2c547c9000 r--p 00023000 fd:00 3922                       /usr/lib64/libselinux.so.1
7f2c547c9000-7f2c547ca000 rw-p 00024000 fd:00 3922                       /usr/lib64/libselinux.so.1
7f2c547ca000-7f2c547cc000 rw-p 00000000 00:00 0
7f2c547cc000-7f2c547d3000 r-xp 00000000 fd:00 3433                       /usr/lib64/librt-2.17.so
7f2c547d3000-7f2c549d2000 ---p 00007000 fd:00 3433                       /usr/lib64/librt-2.17.so
7f2c549d2000-7f2c549d3000 r--p 00006000 fd:00 3433                       /usr/lib64/librt-2.17.so
7f2c549d3000-7f2c549d4000 rw-p 00007000 fd:00 3433                       /usr/lib64/librt-2.17.so
7f2c549d4000-7f2c549dc000 r-xp 00000000 fd:00 3406                       /usr/lib64/libcrypt-2.17.so
7f2c549dc000-7f2c54bdb000 ---p 00008000 fd:00 3406                       /usr/lib64/libcrypt-2.17.so
7f2c54bdb000-7f2c54bdc000 r--p 00007000 fd:00 3406                       /usr/lib64/libcrypt-2.17.so
7f2c54bdc000-7f2c54bdd000 rw-p 00008000 fd:00 3406                       /usr/lib64/libcrypt-2.17.so
7f2c54bdd000-7f2c54c0b000 rw-p 00000000 00:00 0
7f2c54c0b000-7f2c54c0e000 r-xp 00000000 fd:00 4055                       /usr/lib64/libkeyutils.so.1.5
7f2c54c0e000-7f2c54e0d000 ---p 00003000 fd:00 4055                       /usr/lib64/libkeyutils.so.1.5
7f2c54e0d000-7f2c54e0e000 r--p 00002000 fd:00 4055                       /usr/lib64/libkeyutils.so.1.5
7f2c54e0e000-7f2c54e0f000 rw-p 00003000 fd:00 4055                       /usr/lib64/libkeyutils.so.1.5
7f2c54e0f000-7f2c54e1d000 r-xp 00000000 fd:00 4541                       /usr/lib64/libkrb5support.so.0.1
7f2c54e1d000-7f2c5501d000 ---p 0000e000 fd:00 4541                       /usr/lib64/libkrb5support.so.0.1
7f2c5501d000-7f2c5501e000 r--p 0000e000 fd:00 4541                       /usr/lib64/libkrb5support.so.0.1
7f2c5501e000-7f2c5501f000 rw-p 0000f000 fd:00 4541                       /usr/lib64/libkrb5support.so.0.1
7f2c5501f000-7f2c55051000 r-xp 00000000 fd:00 5513                       /usr/lib64/libidn.so.11.6.11
7f2c55051000-7f2c55250000 ---p 00032000 fd:00 5513                       /usr/lib64/libidn.so.11.6.11
7f2c55250000-7f2c55251000 r--p 00031000 fd:00 5513                       /usr/lib64/libidn.so.11.6.11
7f2c55251000-7f2c55252000 rw-p 00032000 fd:00 5513                       /usr/lib64/libidn.so.11.6.11
7f2c55252000-7f2c5528c000 r-xp 00000000 fd:00 3720                       /usr/lib64/libnspr4.so
7f2c5528c000-7f2c5548b000 ---p 0003a000 fd:00 3720                       /usr/lib64/libnspr4.so
7f2c5548b000-7f2c5548c000 r--p 00039000 fd:00 3720                       /usr/lib64/libnspr4.so
7f2c5548c000-7f2c5548e000 rw-p 0003a000 fd:00 3720                       /usr/lib64/libnspr4.so
7f2c5548e000-7f2c55490000 rw-p 00000000 00:00 0
7f2c55490000-7f2c55494000 r-xp 00000000 fd:00 3729                       /usr/lib64/libplc4.so
7f2c55494000-7f2c55693000 ---p 00004000 fd:00 3729                       /usr/lib64/libplc4.so
7f2c55693000-7f2c55694000 r--p 00003000 fd:00 3729                       /usr/lib64/libplc4.so
7f2c55694000-7f2c55695000 rw-p 00004000 fd:00 3729                       /usr/lib64/libplc4.so
7f2c55695000-7f2c55698000 r-xp 00000000 fd:00 3730                       /usr/lib64/libplds4.so
7f2c55698000-7f2c55897000 ---p 00003000 fd:00 3730                       /usr/lib64/libplds4.so
7f2c55897000-7f2c55898000 r--p 00002000 fd:00 3730                       /usr/lib64/libplds4.so
7f2c55898000-7f2c55899000 rw-p 00003000 fd:00 3730                       /usr/lib64/libplds4.so
7f2c55899000-7f2c558c1000 r-xp 00000000 fd:00 4515                       /usr/lib64/libnssutil3.so
7f2c558c1000-7f2c55ac1000 ---p 00028000 fd:00 4515                       /usr/lib64/libnssutil3.so
7f2c55ac1000-7f2c55ac8000 r--p 00028000 fd:00 4515                       /usr/lib64/libnssutil3.so
7f2c55ac8000-7f2c55ac9000 rw-p 0002f000 fd:00 4515                       /usr/lib64/libnssutil3.so
7f2c55ac9000-7f2c55bed000 r-xp 00000000 fd:00 5427                       /usr/lib64/libnss3.so
7f2c55bed000-7f2c55ded000 ---p 00124000 fd:00 5427                       /usr/lib64/libnss3.so
7f2c55ded000-7f2c55df2000 r--p 00124000 fd:00 5427                       /usr/lib64/libnss3.so
7f2c55df2000-7f2c55df4000 rw-p 00129000 fd:00 5427                       /usr/lib64/libnss3.so
7f2c55df4000-7f2c55df6000 rw-p 00000000 00:00 0
7f2c55df6000-7f2c55e1a000 r-xp 00000000 fd:00 21134                      /usr/lib64/libsmime3.so
7f2c55e1a000-7f2c56019000 ---p 00024000 fd:00 21134                      /usr/lib64/libsmime3.so
7f2c56019000-7f2c5601c000 r--p 00023000 fd:00 21134                      /usr/lib64/libsmime3.so
7f2c5601c000-7f2c5601d000 rw-p 00026000 fd:00 21134                      /usr/lib64/libsmime3.so
7f2c5601d000-7f2c5606a000 r-xp 00000000 fd:00 21135                      /usr/lib64/libssl3.so
7f2c5606a000-7f2c56269000 ---p 0004d000 fd:00 21135                      /usr/lib64/libssl3.so
7f2c56269000-7f2c5626d000 r--p 0004c000 fd:00 21135                      /usr/lib64/libssl3.so
7f2c5626d000-7f2c5626e000 rw-p 00050000 fd:00 21135                      /usr/lib64/libssl3.so
7f2c5626e000-7f2c5626f000 rw-p 00000000 00:00 0
7f2c5626f000-7f2c5628b000 r-xp 00000000 fd:00 5441                       /usr/lib64/libsasl2.so.3.0.0
7f2c5628b000-7f2c5648a000 ---p 0001c000 fd:00 5441                       /usr/lib64/libsasl2.so.3.0.0
7f2c5648a000-7f2c5648b000 r--p 0001b000 fd:00 5441                       /usr/lib64/libsasl2.so.3.0.0
7f2c5648b000-7f2c5648c000 rw-p 0001c000 fd:00 5441                       /usr/lib64/libsasl2.so.3.0.0
7f2c5648c000-7f2c56493000 r-xp 00000000 fd:00 5650                       /usr/lib64/libgdbm.so.4.0.0
7f2c56493000-7f2c56693000 ---p 00007000 fd:00 5650                       /usr/lib64/libgdbm.so.4.0.0
7f2c56693000-7f2c56694000 r--p 00007000 fd:00 5650                       /usr/lib64/libgdbm.so.4.0.0
7f2c56694000-7f2c56695000 rw-p 00008000 fd:00 5650                       /usr/lib64/libgdbm.so.4.0.0
7f2c56695000-7f2c5669d000 r-xp 00000000 fd:00 19983                      /usr/lib64/libOpenIPMIutils.so.0.0.1
7f2c5669d000-7f2c5689d000 ---p 00008000 fd:00 19983                      /usr/lib64/libOpenIPMIutils.so.0.0.1
7f2c5689d000-7f2c5689e000 r--p 00008000 fd:00 19983                      /usr/lib64/libOpenIPMIutils.so.0.0.1
7f2c5689e000-7f2c5689f000 rw-p 00009000 fd:00 19983                      /usr/lib64/libOpenIPMIutils.so.0.0.1
7f2c5689f000-7f2c568a8000 r-xp 00000000 fd:00 19989                      /usr/lib64/libltdl.so.7.3.0
7f2c568a8000-7f2c56aa7000 ---p 00009000 fd:00 19989                      /usr/lib64/libltdl.so.7.3.0
7f2c56aa7000-7f2c56aa8000 r--p 00008000 fd:00 19989                      /usr/lib64/libltdl.so.7.3.0
7f2c56aa8000-7f2c56aa9000 rw-p 00009000 fd:00 19989                      /usr/lib64/libltdl.so.7.3.0
7f2c56aa9000-7f2c56ace000 r-xp 00000000 fd:00 4559                       /usr/lib64/liblzma.so.5.2.2
7f2c56ace000-7f2c56ccd000 ---p 00025000 fd:00 4559                       /usr/lib64/liblzma.so.5.2.2
7f2c56ccd000-7f2c56cce000 r--p 00024000 fd:00 4559                       /usr/lib64/liblzma.so.5.2.2
7f2c56cce000-7f2c56ccf000 rw-p 00025000 fd:00 4559                       /usr/lib64/liblzma.so.5.2.2
7f2c56ccf000-7f2c56d00000 r-xp 00000000 fd:00 4533                       /usr/lib64/libk5crypto.so.3.1
7f2c56d00000-7f2c56eff000 ---p 00031000 fd:00 4533                       /usr/lib64/libk5crypto.so.3.1
7f2c56eff000-7f2c56f01000 r--p 00030000 fd:00 4533                       /usr/lib64/libk5crypto.so.3.1
7f2c56f01000-7f2c56f02000 rw-p 00032000 fd:00 4533                       /usr/lib64/libk5crypto.so.3.1
7f2c56f02000-7f2c56f05000 r-xp 00000000 fd:00 3733                       /usr/lib64/libcom_err.so.2.1
7f2c56f05000-7f2c57104000 ---p 00003000 fd:00 3733                       /usr/lib64/libcom_err.so.2.1
7f2c57104000-7f2c57105000 r--p 00002000 fd:00 3733                       /usr/lib64/libcom_err.so.2.1
7f2c57105000-7f2c57106000 rw-p 00003000 fd:00 3733                       /usr/lib64/libcom_err.so.2.1
7f2c57106000-7f2c571df000 r-xp 00000000 fd:00 4539                       /usr/lib64/libkrb5.so.3.3
7f2c571df000-7f2c573de000 ---p 000d9000 fd:00 4539                       /usr/lib64/libkrb5.so.3.3
7f2c573de000-7f2c573ec000 r--p 000d8000 fd:00 4539                       /usr/lib64/libkrb5.so.3.3
7f2c573ec000-7f2c573ef000 rw-p 000e6000 fd:00 4539                       /usr/lib64/libkrb5.so.3.3
7f2c573ef000-7f2c57439000 r-xp 00000000 fd:00 4529                       /usr/lib64/libgssapi_krb5.so.2.2
7f2c57439000-7f2c57639000 ---p 0004a000 fd:00 4529                       /usr/lib64/libgssapi_krb5.so.2.2
7f2c57639000-7f2c5763a000 r--p 0004a000 fd:00 4529                       /usr/lib64/libgssapi_krb5.so.2.2
7f2c5763a000-7f2c5763c000 rw-p 0004b000 fd:00 4529                       /usr/lib64/libgssapi_krb5.so.2.2
7f2c5763c000-7f2c57725000 r-xp 00000000 fd:00 3736                       /usr/lib64/libstdc++.so.6.0.19
7f2c57725000-7f2c57924000 ---p 000e9000 fd:00 3736                       /usr/lib64/libstdc++.so.6.0.19
7f2c57924000-7f2c5792c000 r--p 000e8000 fd:00 3736                       /usr/lib64/libstdc++.so.6.0.19
7f2c5792c000-7f2c5792e000 rw-p 000f0000 fd:00 3736                       /usr/lib64/libstdc++.so.6.0.19
7f2c5792e000-7f2c57943000 rw-p 00000000 00:00 0
7f2c57943000-7f2c57b05000 r-xp 00000000 fd:00 3401                       /usr/lib64/libc-2.17.so
7f2c57b05000-7f2c57d05000 ---p 001c2000 fd:00 3401                       /usr/lib64/libc-2.17.so
7f2c57d05000-7f2c57d09000 r--p 001c2000 fd:00 3401                       /usr/lib64/libc-2.17.so
7f2c57d09000-7f2c57d0b000 rw-p 001c6000 fd:00 3401                       /usr/lib64/libc-2.17.so
7f2c57d0b000-7f2c57d10000 rw-p 00000000 00:00 0
7f2c57d10000-7f2c57d25000 r-xp 00000000 fd:00 21047                      /usr/lib64/libgcc_s-4.8.5-20150702.so.1
7f2c57d25000-7f2c57f24000 ---p 00015000 fd:00 21047                      /usr/lib64/libgcc_s-4.8.5-20150702.so.1
7f2c57f24000-7f2c57f25000 r--p 00014000 fd:00 21047                      /usr/lib64/libgcc_s-4.8.5-20150702.so.1
7f2c57f25000-7f2c57f26000 rw-p 00015000 fd:00 21047                      /usr/lib64/libgcc_s-4.8.5-20150702.so.1
7f2c57f26000-7f2c57f86000 r-xp 00000000 fd:00 3904                       /usr/lib64/libpcre.so.1.2.0
7f2c57f86000-7f2c58186000 ---p 00060000 fd:00 3904                       /usr/lib64/libpcre.so.1.2.0
7f2c58186000-7f2c58187000 r--p 00060000 fd:00 3904                       /usr/lib64/libpcre.so.1.2.0
7f2c58187000-7f2c58188000 rw-p 00061000 fd:00 3904                       /usr/lib64/libpcre.so.1.2.0
7f2c58188000-7f2c5819e000 r-xp 00000000 fd:00 3431                       /usr/lib64/libresolv-2.17.so
7f2c5819e000-7f2c5839d000 ---p 00016000 fd:00 3431                       /usr/lib64/libresolv-2.17.so
7f2c5839d000-7f2c5839e000 r--p 00015000 fd:00 3431                       /usr/lib64/libresolv-2.17.so
7f2c5839e000-7f2c5839f000 rw-p 00016000 fd:00 3431                       /usr/lib64/libresolv-2.17.so
7f2c5839f000-7f2c583a1000 rw-p 00000000 00:00 0
7f2c583a1000-7f2c58407000 r-xp 00000000 fd:00 6905                       /usr/lib64/libcurl.so.4.3.0
7f2c58407000-7f2c58606000 ---p 00066000 fd:00 6905                       /usr/lib64/libcurl.so.4.3.0
7f2c58606000-7f2c58608000 r--p 00065000 fd:00 6905                       /usr/lib64/libcurl.so.4.3.0
7f2c58608000-7f2c58609000 rw-p 00067000 fd:00 6905                       /usr/lib64/libcurl.so.4.3.0
7f2c58609000-7f2c5860a000 rw-p 00000000 00:00 0
7f2c5860a000-7f2c58618000 r-xp 00000000 fd:00 6984                       /usr/lib64/liblber-2.4.so.2.10.7
7f2c58618000-7f2c58817000 ---p 0000e000 fd:00 6984                       /usr/lib64/liblber-2.4.so.2.10.7
7f2c58817000-7f2c58818000 r--p 0000d000 fd:00 6984                       /usr/lib64/liblber-2.4.so.2.10.7
7f2c58818000-7f2c58819000 rw-p 0000e000 fd:00 6984                       /usr/lib64/liblber-2.4.so.2.10.7
7f2c58819000-7f2c5886b000 r-xp 00000000 fd:00 6986                       /usr/lib64/libldap-2.4.so.2.10.7
7f2c5886b000-7f2c58a6b000 ---p 00052000 fd:00 6986                       /usr/lib64/libldap-2.4.so.2.10.7
7f2c58a6b000-7f2c58a6d000 r--p 00052000 fd:00 6986                       /usr/lib64/libldap-2.4.so.2.10.7
7f2c58a6d000-7f2c58a6e000 rw-p 00054000 fd:00 6986                       /usr/lib64/libldap-2.4.so.2.10.7
7f2c58a6e000-7f2c58ab4000 r-xp 00000000 fd:00 19135                      /usr/lib64/libevent-2.0.so.5.1.9
7f2c58ab4000-7f2c58cb3000 ---p 00046000 fd:00 19135                      /usr/lib64/libevent-2.0.so.5.1.9
7f2c58cb3000-7f2c58cb4000 r--p 00045000 fd:00 19135                      /usr/lib64/libevent-2.0.so.5.1.9
7f2c58cb4000-7f2c58cb5000 rw-p 00046000 fd:00 19135                      /usr/lib64/libevent-2.0.so.5.1.9
7f2c58cb5000-7f2c58cb6000 rw-p 00000000 00:00 0
7f2c58cb6000-7f2c58cbc000 r-xp 00000000 fd:00 19977                      /usr/lib64/libOpenIPMIposix.so.0.0.1
7f2c58cbc000-7f2c58ebc000 ---p 00006000 fd:00 19977                      /usr/lib64/libOpenIPMIposix.so.0.0.1
7f2c58ebc000-7f2c58ebd000 r--p 00006000 fd:00 19977                      /usr/lib64/libOpenIPMIposix.so.0.0.1
7f2c58ebd000-7f2c58ebe000 rw-p 00007000 fd:00 19977                      /usr/lib64/libOpenIPMIposix.so.0.0.1
7f2c58ebe000-7f2c58fab000 r-xp 00000000 fd:00 19971                      /usr/lib64/libOpenIPMI.so.0.0.5
7f2c58fab000-7f2c591ab000 ---p 000ed000 fd:00 19971                      /usr/lib64/libOpenIPMI.so.0.0.5
7f2c591ab000-7f2c591c1000 r--p 000ed000 fd:00 19971                      /usr/lib64/libOpenIPMI.so.0.0.5
7f2c591c1000-7f2c591c7000 rw-p 00103000 fd:00 19971                      /usr/lib64/libOpenIPMI.so.0.0.5
7f2c591c7000-7f2c591cb000 rw-p 00000000 00:00 0
7f2c591cb000-7f2c591f3000 r-xp 00000000 fd:00 6900                       /usr/lib64/libssh2.so.1.0.1
7f2c591f3000-7f2c593f3000 ---p 00028000 fd:00 6900                       /usr/lib64/libssh2.so.1.0.1
7f2c593f3000-7f2c593f4000 r--p 00028000 fd:00 6900                       /usr/lib64/libssh2.so.1.0.1
7f2c593f4000-7f2c593f5000 rw-p 00029000 fd:00 6900                       /usr/lib64/libssh2.so.1.0.1
7f2c593f5000-7f2c594bd000 r-xp 00000000 fd:00 20044                      /usr/lib64/libnetsnmp.so.31.0.2
7f2c594bd000-7f2c596bc000 ---p 000c8000 fd:00 20044                      /usr/lib64/libnetsnmp.so.31.0.2
7f2c596bc000-7f2c596bf000 r--p 000c7000 fd:00 20044                      /usr/lib64/libnetsnmp.so.31.0.2
7f2c596bf000-7f2c596c1000 rw-p 000ca000 fd:00 20044                      /usr/lib64/libnetsnmp.so.31.0.2
7f2c596c1000-7f2c596f7000 rw-p 00000000 00:00 0
7f2c596f7000-7f2c59757000 r-xp 00000000 fd:00 20004                      /usr/lib64/libodbc.so.2.0.0
7f2c59757000-7f2c59956000 ---p 00060000 fd:00 20004                      /usr/lib64/libodbc.so.2.0.0
7f2c59956000-7f2c59957000 r--p 0005f000 fd:00 20004                      /usr/lib64/libodbc.so.2.0.0
7f2c59957000-7f2c5995e000 rw-p 00060000 fd:00 20004                      /usr/lib64/libodbc.so.2.0.0
7f2c5995e000-7f2c5995f000 rw-p 00000000 00:00 0
7f2c5995f000-7f2c59abe000 r-xp 00000000 fd:00 4609                       /usr/lib64/libxml2.so.2.9.1
7f2c59abe000-7f2c59cbd000 ---p 0015f000 fd:00 4609                       /usr/lib64/libxml2.so.2.9.1
7f2c59cbd000-7f2c59cc5000 r--p 0015e000 fd:00 4609                       /usr/lib64/libxml2.so.2.9.1
7f2c59cc5000-7f2c59cc7000 rw-p 00166000 fd:00 4609                       /usr/lib64/libxml2.so.2.9.1
7f2c59cc7000-7f2c59cc9000 rw-p 00000000 00:00 0
7f2c59cc9000-7f2c59ccb000 r-xp 00000000 fd:00 3409                       /usr/lib64/libdl-2.17.so
7f2c59ccb000-7f2c59ecb000 ---p 00002000 fd:00 3409                       /usr/lib64/libdl-2.17.so
7f2c59ecb000-7f2c59ecc000 r--p 00002000 fd:00 3409                       /usr/lib64/libdl-2.17.so
7f2c59ecc000-7f2c59ecd000 rw-p 00003000 fd:00 3409                       /usr/lib64/libdl-2.17.so
7f2c59ecd000-7f2c5a102000 r-xp 00000000 fd:00 4496                       /usr/lib64/libcrypto.so.1.0.2k
7f2c5a102000-7f2c5a302000 ---p 00235000 fd:00 4496                       /usr/lib64/libcrypto.so.1.0.2k
7f2c5a302000-7f2c5a31e000 r--p 00235000 fd:00 4496                       /usr/lib64/libcrypto.so.1.0.2k
7f2c5a31e000-7f2c5a32b000 rw-p 00251000 fd:00 4496                       /usr/lib64/libcrypto.so.1.0.2k
7f2c5a32b000-7f2c5a32f000 rw-p 00000000 00:00 0
7f2c5a32f000-7f2c5a396000 r-xp 00000000 fd:00 4498                       /usr/lib64/libssl.so.1.0.2k
7f2c5a396000-7f2c5a596000 ---p 00067000 fd:00 4498                       /usr/lib64/libssl.so.1.0.2k
7f2c5a596000-7f2c5a59a000 r--p 00067000 fd:00 4498                       /usr/lib64/libssl.so.1.0.2k
7f2c5a59a000-7f2c5a5a1000 rw-p 0006b000 fd:00 4498                       /usr/lib64/libssl.so.1.0.2k
7f2c5a5a1000-7f2c5a6a2000 r-xp 00000000 fd:00 3411                       /usr/lib64/libm-2.17.so
7f2c5a6a2000-7f2c5a8a1000 ---p 00101000 fd:00 3411                       /usr/lib64/libm-2.17.so
7f2c5a8a1000-7f2c5a8a2000 r--p 00100000 fd:00 3411                       /usr/lib64/libm-2.17.so
7f2c5a8a2000-7f2c5a8a3000 rw-p 00101000 fd:00 3411                       /usr/lib64/libm-2.17.so
7f2c5a8a3000-7f2c5a8b8000 r-xp 00000000 fd:00 3723                       /usr/lib64/libz.so.1.2.7
7f2c5a8b8000-7f2c5aab7000 ---p 00015000 fd:00 3723                       /usr/lib64/libz.so.1.2.7
7f2c5aab7000-7f2c5aab8000 r--p 00014000 fd:00 3723                       /usr/lib64/libz.so.1.2.7
7f2c5aab8000-7f2c5aab9000 rw-p 00015000 fd:00 3723                       /usr/lib64/libz.so.1.2.7
7f2c5aab9000-7f2c5aad0000 r-xp 00000000 fd:00 3429                       /usr/lib64/libpthread-2.17.so
7f2c5aad0000-7f2c5accf000 ---p 00017000 fd:00 3429                       /usr/lib64/libpthread-2.17.so
7f2c5accf000-7f2c5acd0000 r--p 00016000 fd:00 3429                       /usr/lib64/libpthread-2.17.so
7f2c5acd0000-7f2c5acd1000 rw-p 00017000 fd:00 3429                       /usr/lib64/libpthread-2.17.so
7f2c5acd1000-7f2c5acd5000 rw-p 00000000 00:00 0
7f2c5acd5000-7f2c5aff5000 r-xp 00000000 fd:00 19602                      /usr/lib64/libmysqlclient.so.18.0.0
7f2c5aff5000-7f2c5b1f4000 ---p 00320000 fd:00 19602                      /usr/lib64/libmysqlclient.so.18.0.0
7f2c5b1f4000-7f2c5b1fc000 r--p 0031f000 fd:00 19602                      /usr/lib64/libmysqlclient.so.18.0.0
7f2c5b1fc000-7f2c5b26f000 rw-p 00327000 fd:00 19602                      /usr/lib64/libmysqlclient.so.18.0.0
7f2c5b26f000-7f2c5b279000 rw-p 00000000 00:00 0
7f2c5b279000-7f2c5b29b000 r-xp 00000000 fd:00 1949                       /usr/lib64/ld-2.17.so
7f2c5b466000-7f2c5b477000 rw-s 00000000 00:04 4390918                    /SYSV00000000 (deleted)
7f2c5b477000-7f2c5b48f000 rw-p 00000000 00:00 0
7f2c5b48f000-7f2c5b490000 rw-p 00000000 00:00 0
7f2c5b490000-7f2c5b497000 r--s 00000000 fd:00 49                         /usr/lib64/gconv/gconv-modules.cache
7f2c5b497000-7f2c5b498000 rw-s 00000000 00:04 4227073                    /SYSV00000000 (deleted)
7f2c5b498000-7f2c5b499000 rw-p 00000000 00:00 0
7f2c5b499000-7f2c5b49a000 rw-p 00000000 00:00 0
7f2c5b49a000-7f2c5b49b000 r--p 00021000 fd:00 1949                       /usr/lib64/ld-2.17.so
7f2c5b49b000-7f2c5b49c000 rw-p 00022000 fd:00 1949                       /usr/lib64/ld-2.17.so
7f2c5b49c000-7f2c5b49d000 rw-p 00000000 00:00 0
7ffe6f931000-7ffe6fcd1000 rw-p 00000000 00:00 0                          [stack]
7ffe6fd52000-7ffe6fd54000 r-xp 00000000 00:00 0                          [vdso]
ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0                  [vsyscall]
 13906:20190410:170015.242 One child process died (PID:14069,exitcode/signal:6). Exiting ...
zabbix_server [13906]: Error waiting for process with PID 14069: [10] No child processes

still crahs, i try 3 other versions(5.2.7, 5.3.12, 8.0.15 )of ODBC driver and all is die on check ;C

$ cat /etc/centos-release
CentOS Linux release 7.6.1810 (Core)
$ uname -a
Linux zabbix.****.** 3.10.0-957.1.3.el7.x86_64 #1 SMP Thu Nov 29 14:49:43 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux
$ zabbix_server -V
zabbix_server (Zabbix) 4.2.0
Revision 91746 29 March 2019, compilation time: Mar 29 2019 13:20:31

Copyright (C) 2019 Zabbix SIA
License GPLv2+: GNU GPL version 2 or later <http://gnu.org/licenses/gpl.html>.
This is free software: you are free to change and redistribute it according to
the license. There is NO WARRANTY, to the extent permitted by law.

This product includes software developed by the OpenSSL Project
for use in the OpenSSL Toolkit (http://www.openssl.org/).

Compiled with OpenSSL 1.0.1e-fips 11 Feb 2013
Running with OpenSSL 1.0.1e-fips 11 Feb 2013
Comment by Vladislavs Sokurenko [ 2021 Aug 19 ]

Please note that database connections are removed from pollers in ZBXNEXT-782 since 5.4 and it helps in some cases.

Generated at Fri Mar 29 03:58:12 EET 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.