[ZBX-12367] zabbix_proxy: poller #3 invalid pointer Created: 2017 Jul 10  Updated: 2019 Dec 10

Status: Open
Project: ZABBIX BUGS AND ISSUES
Component/s: Proxy (P)
Affects Version/s: 3.0.9
Fix Version/s: None

Type: Incident report Priority: Trivial
Reporter: Tyler French Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: mariadb, mysql, odbc
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

CentOS 7


Issue Links:
Sub-task
depends on ZBX-12159 Resolving TNS names via LDAP crash on... Confirmed

 Description   

I have added an ODBC check to verify that a MariaDB cluster node is up and working. We are using the `MariaDB Connector/ODBC` which can be found here. When the proxy checks for this we get the following error:

8819:20170710:155901.978 In get_value() key:'db.odbc.select[Simple-check,sql02]'
  8819:20170710:155901.978 In get_value_db() key_orig:'db.odbc.select[Simple-check,sql02]'
  8819:20170710:155901.978 In db_odbc_select() query:'SELECT COUNT(*) FROM information_schema.tables where table_schema = 'zabbixdb';'
  8819:20170710:155901.978 In odbc_DBconnect() db_dsn:'sql02' user:''
*** Error in `/usr/sbin/zabbix_proxy: poller #3 [got 0 values in 0.000154 sec, getting values]': free(): invalid pointer: 0x00007fad9889b368 ***

Backtrace:

/lib64/libc.so.6(+0x7c503)[0x7fad93430503]
/usr/lib/libmaodbc.so(SQLConnectCommon+0x142)[0x7fad8710b942]
/lib64/libodbc.so.2(SQLConnect+0x1f0)[0x7fad9581cb40]
/usr/sbin/zabbix_proxy: poller #3 [got 0 values in 0.000154 sec, getting values](odbc_DBconnect+0x24d)[0x7fad9667ec49]
/usr/sbin/zabbix_proxy: poller #3 [got 0 values in 0.000154 sec, getting values](+0x4d888)[0x7fad965f2888]
/usr/sbin/zabbix_proxy: poller #3 [got 0 values in 0.000154 sec, getting values](get_value_db+0xa9)[0x7fad965f2b3c]
/usr/sbin/zabbix_proxy: poller #3 [got 0 values in 0.000154 sec, getting values](+0x4041e)[0x7fad965e541e]
/usr/sbin/zabbix_proxy: poller #3 [got 0 values in 0.000154 sec, getting values](+0x41566)[0x7fad965e6566]
/usr/sbin/zabbix_proxy: poller #3 [got 0 values in 0.000154 sec, getting values](poller_thread+0x1b2)[0x7fad965e7224]
/usr/sbin/zabbix_proxy: poller #3 [got 0 values in 0.000154 sec, getting values](zbx_thread_start+0x37)[0x7fad96655363]
/usr/sbin/zabbix_proxy: poller #3 [got 0 values in 0.000154 sec, getting values](MAIN_ZABBIX_ENTRY+0x5cc)[0x7fad965d18d3]
/usr/sbin/zabbix_proxy: poller #3 [got 0 values in 0.000154 sec, getting values](daemon_start+0x32f)[0x7fad96653799]
/usr/sbin/zabbix_proxy: poller #3 [got 0 values in 0.000154 sec, getting values](main+0x2b5)[0x7fad965d1305]
/lib64/libc.so.6(__libc_start_main+0xf5)[0x7fad933d5b35]
/usr/sbin/zabbix_proxy: poller #3 [got 0 values in 0.000154 sec, getting values](+0x2ae19)[0x7fad965cfe19]

Memory Map:

======= Memory map: ========
7fad80000000-7fad80021000 rw-p 00000000 00:00 0 
7fad80021000-7fad84000000 ---p 00000000 00:00 0 
7fad86ed6000-7fad86ee6000 r-xp 00000000 fd:00 29870                      /usr/lib64/libodbcinst.so.2.0.0
7fad86ee6000-7fad870e6000 ---p 00010000 fd:00 29870                      /usr/lib64/libodbcinst.so.2.0.0
7fad870e6000-7fad870e7000 r--p 00010000 fd:00 29870                      /usr/lib64/libodbcinst.so.2.0.0
7fad870e7000-7fad870e8000 rw-p 00011000 fd:00 29870                      /usr/lib64/libodbcinst.so.2.0.0
7fad870e8000-7fad8716f000 r-xp 00000000 fd:00 35231387                   /usr/lib/libmaodbc.so
7fad8716f000-7fad8736f000 ---p 00087000 fd:00 35231387                   /usr/lib/libmaodbc.so
7fad8736f000-7fad8738a000 rw-p 00087000 fd:00 35231387                   /usr/lib/libmaodbc.so
7fad8738a000-7fad87390000 rw-p 00000000 00:00 0 
7fad87390000-7fad87392000 r-xp 00000000 fd:00 33646261                   /usr/lib64/gconv/ISO8859-1.so
7fad87392000-7fad87591000 ---p 00002000 fd:00 33646261                   /usr/lib64/gconv/ISO8859-1.so
7fad87591000-7fad87592000 r--p 00001000 fd:00 33646261                   /usr/lib64/gconv/ISO8859-1.so
7fad87592000-7fad87593000 rw-p 00002000 fd:00 33646261                   /usr/lib64/gconv/ISO8859-1.so
7fad87593000-7fad8dabc000 r--p 00000000 fd:00 34111                      /usr/lib/locale/locale-archive
7fad8dabc000-7fad8e189000 rw-s 00000000 00:04 1853882371                 /SYSV67004863 (deleted)
7fad8e189000-7fad8e589000 rw-s 00000000 00:04 1853849602                 /SYSV48004863 (deleted)
7fad8e589000-7fad8f589000 rw-s 00000000 00:04 1853816833                 /SYSV68004863 (deleted)
7fad8f589000-7fad8f595000 r-xp 00000000 fd:00 369907                     /usr/lib64/libnss_files-2.17.so
7fad8f595000-7fad8f794000 ---p 0000c000 fd:00 369907                     /usr/lib64/libnss_files-2.17.so
7fad8f794000-7fad8f795000 r--p 0000b000 fd:00 369907                     /usr/lib64/libnss_files-2.17.so
7fad8f795000-7fad8f796000 rw-p 0000c000 fd:00 369907                     /usr/lib64/libnss_files-2.17.so
7fad8f796000-7fad8f79c000 rw-p 00000000 00:00 0 
7fad8f79c000-7fad8f7fc000 r-xp 00000000 fd:00 42380                      /usr/lib64/libpcre.so.1.2.0
7fad8f7fc000-7fad8f9fb000 ---p 00060000 fd:00 42380                      /usr/lib64/libpcre.so.1.2.0
7fad8f9fb000-7fad8f9fc000 r--p 0005f000 fd:00 42380                      /usr/lib64/libpcre.so.1.2.0
7fad8f9fc000-7fad8f9fd000 rw-p 00060000 fd:00 42380                      /usr/lib64/libpcre.so.1.2.0
7fad8f9fd000-7fad8f9ff000 r-xp 00000000 fd:00 30637                      /usr/lib64/libfreebl3.so
7fad8f9ff000-7fad8fbfe000 ---p 00002000 fd:00 30637                      /usr/lib64/libfreebl3.so
7fad8fbfe000-7fad8fbff000 r--p 00001000 fd:00 30637                      /usr/lib64/libfreebl3.so
7fad8fbff000-7fad8fc00000 rw-p 00002000 fd:00 30637                      /usr/lib64/libfreebl3.so
7fad8fc00000-7fad8fc24000 r-xp 00000000 fd:00 34159                      /usr/lib64/libselinux.so.1
7fad8fc24000-7fad8fe23000 ---p 00024000 fd:00 34159                      /usr/lib64/libselinux.so.1
7fad8fe23000-7fad8fe24000 r--p 00023000 fd:00 34159                      /usr/lib64/libselinux.so.1
7fad8fe24000-7fad8fe25000 rw-p 00024000 fd:00 34159                      /usr/lib64/libselinux.so.1
7fad8fe25000-7fad8fe27000 rw-p 00000000 00:00 0 
7fad8fe27000-7fad8fe2e000 r-xp 00000000 fd:00 462166                     /usr/lib64/librt-2.17.so
7fad8fe2e000-7fad9002d000 ---p 00007000 fd:00 462166                     /usr/lib64/librt-2.17.so
7fad9002d000-7fad9002e000 r--p 00006000 fd:00 462166                     /usr/lib64/librt-2.17.so
7fad9002e000-7fad9002f000 rw-p 00007000 fd:00 462166                     /usr/lib64/librt-2.17.so
7fad9002f000-7fad90037000 r-xp 00000000 fd:00 34124                      /usr/lib64/libcrypt-2.17.so
7fad90037000-7fad90236000 ---p 00008000 fd:00 34124                      /usr/lib64/libcrypt-2.17.so
7fad90236000-7fad90237000 r--p 00007000 fd:00 34124                      /usr/lib64/libcrypt-2.17.so
7fad90237000-7fad90238000 rw-p 00008000 fd:00 34124                      /usr/lib64/libcrypt-2.17.so
7fad90238000-7fad90266000 rw-p 00000000 00:00 0 
7fad90266000-7fad90269000 r-xp 00000000 fd:00 43039                      /usr/lib64/libkeyutils.so.1.5
7fad90269000-7fad90468000 ---p 00003000 fd:00 43039                      /usr/lib64/libkeyutils.so.1.5
7fad90468000-7fad90469000 r--p 00002000 fd:00 43039                      /usr/lib64/libkeyutils.so.1.5
7fad90469000-7fad9046a000 rw-p 00003000 fd:00 43039                      /usr/lib64/libkeyutils.so.1.5
7fad9046a000-7fad90477000 r-xp 00000000 fd:00 268016                     /usr/lib64/libkrb5support.so.0.1
7fad90477000-7fad90677000 ---p 0000d000 fd:00 268016                     /usr/lib64/libkrb5support.so.0.1
7fad90677000-7fad90678000 r--p 0000d000 fd:00 268016                     /usr/lib64/libkrb5support.so.0.1
7fad90678000-7fad90679000 rw-p 0000e000 fd:00 268016                     /usr/lib64/libkrb5support.so.0.1
7fad90679000-7fad906ab000 r-xp 00000000 fd:00 42792                      /usr/lib64/libidn.so.11.6.11
7fad906ab000-7fad908aa000 ---p 00032000 fd:00 42792                      /usr/lib64/libidn.so.11.6.11
7fad908aa000-7fad908ab000 r--p 00031000 fd:00 42792                      /usr/lib64/libidn.so.11.6.11
7fad908ab000-7fad908ac000 rw-p 00032000 fd:00 42792                      /usr/lib64/libidn.so.11.6.11
7fad908ac000-7fad908e6000 r-xp 00000000 fd:00 34171                      /usr/lib64/libnspr4.so
7fad908e6000-7fad90ae5000 ---p 0003a000 fd:00 34171                      /usr/lib64/libnspr4.so
7fad90ae5000-7fad90ae6000 r--p 00039000 fd:00 34171                      /usr/lib64/libnspr4.so
7fad90ae6000-7fad90ae8000 rw-p 0003a000 fd:00 34171                      /usr/lib64/libnspr4.so
7fad90ae8000-7fad90aea000 rw-p 00000000 00:00 0 
7fad90aea000-7fad90aee000 r-xp 00000000 fd:00 462112                     /usr/lib64/libplc4.so
7fad90aee000-7fad90ced000 ---p 00004000 fd:00 462112                     /usr/lib64/libplc4.so
7fad90ced000-7fad90cee000 r--p 00003000 fd:00 462112                     /usr/lib64/libplc4.so
7fad90cee000-7fad90cef000 rw-p 00004000 fd:00 462112                     /usr/lib64/libplc4.so
7fad90cef000-7fad90cf2000 r-xp 00000000 fd:00 462113                     /usr/lib64/libplds4.so
7fad90cf2000-7fad90ef1000 ---p 00003000 fd:00 462113                     /usr/lib64/libplds4.so
7fad90ef1000-7fad90ef2000 r--p 00002000 fd:00 462113                     /usr/lib64/libplds4.so
7fad90ef2000-7fad90ef3000 rw-p 00003000 fd:00 462113                     /usr/lib64/libplds4.so
7fad90ef3000-7fad90f19000 r-xp 00000000 fd:00 42408                      /usr/lib64/libnssutil3.so
7fad90f19000-7fad91118000 ---p 00026000 fd:00 42408                      /usr/lib64/libnssutil3.so
7fad91118000-7fad9111e000 r--p 00025000 fd:00 42408                      /usr/lib64/libnssutil3.so
7fad9111e000-7fad9111f000 rw-p 0002b000 fd:00 42408                      /usr/lib64/libnssutil3.so
7fad9111f000-7fad9123d000 r-xp 00000000 fd:00 99414                      /usr/lib64/libnss3.so
7fad9123d000-7fad9143c000 ---p 0011e000 fd:00 99414                      /usr/lib64/libnss3.so
7fad9143c000-7fad91441000 r--p 0011d000 fd:00 99414                      /usr/lib64/libnss3.so
7fad91441000-7fad91443000 rw-p 00122000 fd:00 99414                      /usr/lib64/libnss3.so
7fad91443000-7fad91445000 rw-p 00000000 00:00 0 
7fad91445000-7fad91469000 r-xp 00000000 fd:00 239176                     /usr/lib64/libsmime3.so
7fad91469000-7fad91668000 ---p 00024000 fd:00 239176                     /usr/lib64/libsmime3.so
7fad91668000-7fad9166b000 r--p 00023000 fd:00 239176                     /usr/lib64/libsmime3.so
7fad9166b000-7fad9166c000 rw-p 00026000 fd:00 239176                     /usr/lib64/libsmime3.so
7fad9166c000-7fad916aa000 r-xp 00000000 fd:00 239177                     /usr/lib64/libssl3.so
7fad916aa000-7fad918aa000 ---p 0003e000 fd:00 239177                     /usr/lib64/libssl3.so
7fad918aa000-7fad918ad000 r--p 0003e000 fd:00 239177                     /usr/lib64/libssl3.so
7fad918ad000-7fad918ae000 rw-p 00041000 fd:00 239177                     /usr/lib64/libssl3.so
7fad918ae000-7fad918af000 rw-p 00000000 00:00 0 
7fad918af000-7fad918cb000 r-xp 00000000 fd:00 42826                      /usr/lib64/libsasl2.so.3.0.0
7fad918cb000-7fad91aca000 ---p 0001c000 fd:00 42826                      /usr/lib64/libsasl2.so.3.0.0
7fad91aca000-7fad91acb000 r--p 0001b000 fd:00 42826                      /usr/lib64/libsasl2.so.3.0.0
7fad91acb000-7fad91acc000 rw-p 0001c000 fd:00 42826                      /usr/lib64/libsasl2.so.3.0.0
7fad91acc000-7fad91afb000 r-xp 00000000 fd:00 43242                      /usr/lib64/libk5crypto.so.3.1
7fad91afb000-7fad91cfa000 ---p 0002f000 fd:00 43242                      /usr/lib64/libk5crypto.so.3.1
7fad91cfa000-7fad91cfc000 r--p 0002e000 fd:00 43242                      /usr/lib64/libk5crypto.so.3.1
7fad91cfc000-7fad91cfd000 rw-p 00030000 fd:00 43242                      /usr/lib64/libk5crypto.so.3.1
7fad91cfd000-7fad91cfe000 rw-p 00000000 00:00 0 
7fad91cfe000-7fad91d01000 r-xp 00000000 fd:00 42419                      /usr/lib64/libcom_err.so.2.1
7fad91d01000-7fad91f00000 ---p 00003000 fd:00 42419                      /usr/lib64/libcom_err.so.2.1
7fad91f00000-7fad91f01000 r--p 00002000 fd:00 42419                      /usr/lib64/libcom_err.so.2.1
7fad91f01000-7fad91f02000 rw-p 00003000 fd:00 42419                      /usr/lib64/libcom_err.so.2.1
7fad91f02000-7fad91fd8000 r-xp 00000000 fd:00 268014                     /usr/lib64/libkrb5.so.3.3
7fad91fd8000-7fad921d8000 ---p 000d6000 fd:00 268014                     /usr/lib64/libkrb5.so.3.3
7fad921d8000-7fad921e6000 r--p 000d6000 fd:00 268014                     /usr/lib64/libkrb5.so.3.3
7fad921e6000-7fad921e9000 rw-p 000e4000 fd:00 268014                     /usr/lib64/libkrb5.so.3.3
7fad921e9000-7fad92234000 r-xp 00000000 fd:00 42808                      /usr/lib64/libgssapi_krb5.so.2.2
7fad92234000-7fad92434000 ---p 0004b000 fd:00 42808                      /usr/lib64/libgssapi_krb5.so.2.2
7fad92434000-7fad92435000 r--p 0004b000 fd:00 42808                      /usr/lib64/libgssapi_krb5.so.2.2
7fad92435000-7fad92437000 rw-p 0004c000 fd:00 42808                      /usr/lib64/libgssapi_krb5.so.2.2
7fad92437000-7fad9243e000 r-xp 00000000 fd:00 43047                      /usr/lib64/libgdbm.so.4.0.0
7fad9243e000-7fad9263e000 ---p 00007000 fd:00 43047                      /usr/lib64/libgdbm.so.4.0.0
7fad9263e000-7fad9263f000 r--p 00007000 fd:00 43047                      /usr/lib64/libgdbm.so.4.0.0
7fad9263f000-7fad92640000 rw-p 00008000 fd:00 43047                      /usr/lib64/libgdbm.so.4.0.0
7fad92640000-7fad92648000 r-xp 00000000 fd:00 670694                     /usr/lib64/libOpenIPMIutils.so.0.0.1
7fad92648000-7fad92847000 ---p 00008000 fd:00 670694                     /usr/lib64/libOpenIPMIutils.so.0.0.1
7fad92847000-7fad92848000 r--p 00007000 fd:00 670694                     /usr/lib64/libOpenIPMIutils.so.0.0.1
7fad92848000-7fad92849000 rw-p 00008000 fd:00 670694                     /usr/lib64/libOpenIPMIutils.so.0.0.1
7fad92849000-7fad92852000 r-xp 00000000 fd:00 670705                     /usr/lib64/libltdl.so.7.3.0
7fad92852000-7fad92a51000 ---p 00009000 fd:00 670705                     /usr/lib64/libltdl.so.7.3.0
7fad92a51000-7fad92a52000 r--p 00008000 fd:00 670705                     /usr/lib64/libltdl.so.7.3.0
7fad92a52000-7fad92a53000 rw-p 00009000 fd:00 670705                     /usr/lib64/libltdl.so.7.3.0
7fad92a53000-7fad92a78000 r-xp 00000000 fd:00 42391                      /usr/lib64/liblzma.so.5.2.2
7fad92a78000-7fad92c77000 ---p 00025000 fd:00 42391                      /usr/lib64/liblzma.so.5.2.2
7fad92c77000-7fad92c78000 r--p 00024000 fd:00 42391                      /usr/lib64/liblzma.so.5.2.2
7fad92c78000-7fad92c79000 rw-p 00025000 fd:00 42391                      /usr/lib64/liblzma.so.5.2.2
7fad92c79000-7fad92d62000 r-xp 00000000 fd:00 462116                     /usr/lib64/libstdc++.so.6.0.19
7fad92d62000-7fad92f62000 ---p 000e9000 fd:00 462116                     /usr/lib64/libstdc++.so.6.0.19
7fad92f62000-7fad92f6b000 r--p 000e9000 fd:00 462116                     /usr/lib64/libstdc++.so.6.0.19
7fad92f6b000-7fad92f6d000 rw-p 000f2000 fd:00 462116                     /usr/lib64/libstdc++.so.6.0.19
7fad92f6d000-7fad92f82000 rw-p 00000000 00:00 0 
7fad92f82000-7fad92f97000 r-xp 00000000 fd:00 42368                      /usr/lib64/libz.so.1.2.7
7fad92f97000-7fad93196000 ---p 00015000 fd:00 42368                      /usr/lib64/libz.so.1.2.7
7fad93196000-7fad93197000 r--p 00014000 fd:00 42368                      /usr/lib64/libz.so.1.2.7
7fad93197000-7fad93198000 rw-p 00015000 fd:00 42368                      /usr/lib64/libz.so.1.2.7
7fad93198000-7fad931af000 r-xp 00000000 fd:00 462160                     /usr/lib64/libpthread-2.17.so
7fad931af000-7fad933ae000 ---p 00017000 fd:00 462160                     /usr/lib64/libpthread-2.17.so
7fad933ae000-7fad933af000 r--p 00016000 fd:00 462160                     /usr/lib64/libpthread-2.17.so
7fad933af000-7fad933b0000 rw-p 00017000 fd:00 462160                     /usr/lib64/libpthread-2.17.so
7fad933b0000-7fad933b4000 rw-p 00000000 00:00 0 
7fad933b4000-7fad9356a000 r-xp 00000000 fd:00 34120                      /usr/lib64/libc-2.17.so
7fad9356a000-7fad9376a000 ---p 001b6000 fd:00 34120                      /usr/lib64/libc-2.17.so
7fad9376a000-7fad9376e000 r--p 001b6000 fd:00 34120                      /usr/lib64/libc-2.17.so
7fad9376e000-7fad93770000 rw-p 001ba000 fd:00 34120                      /usr/lib64/libc-2.17.so
7fad93770000-7fad93775000 rw-p 00000000 00:00 0 
7fad93775000-7fad9378a000 r-xp 00000000 fd:00 55852                      /usr/lib64/libgcc_s-4.8.5-20150702.so.1
7fad9378a000-7fad93989000 ---p 00015000 fd:00 55852                      /usr/lib64/libgcc_s-4.8.5-20150702.so.1
7fad93989000-7fad9398a000 r--p 00014000 fd:00 55852                      /usr/lib64/libgcc_s-4.8.5-20150702.so.1
7fad9398a000-7fad9398b000 rw-p 00015000 fd:00 55852                      /usr/lib64/libgcc_s-4.8.5-20150702.so.1
7fad9398b000-7fad939a1000 r-xp 00000000 fd:00 462164                     /usr/lib64/libresolv-2.17.so
7fad939a1000-7fad93ba1000 ---p 00016000 fd:00 462164                     /usr/lib64/libresolv-2.17.so
7fad93ba1000-7fad93ba2000 r--p 00016000 fd:00 462164                     /usr/lib64/libresolv-2.17.so
7fad93ba2000-7fad93ba3000 rw-p 00017000 fd:00 462164                     /usr/lib64/libresolv-2.17.so
7fad93ba3000-7fad93ba5000 rw-p 00000000 00:00 0 
7fad93ba5000-7fad93ba7000 r-xp 00000000 fd:00 34126                      /usr/lib64/libdl-2.17.so
7fad93ba7000-7fad93da7000 ---p 00002000 fd:00 34126                      /usr/lib64/libdl-2.17.so
7fad93da7000-7fad93da8000 r--p 00002000 fd:00 34126                      /usr/lib64/libdl-2.17.so
7fad93da8000-7fad93da9000 rw-p 00003000 fd:00 34126                      /usr/lib64/libdl-2.17.so
7fad93da9000-7fad93ea9000 r-xp 00000000 fd:00 34131                      /usr/lib64/libm-2.17.so
7fad93ea9000-7fad940a9000 ---p 00100000 fd:00 34131                      /usr/lib64/libm-2.17.so
7fad940a9000-7fad940aa000 r--p 00100000 fd:00 34131                      /usr/lib64/libm-2.17.so
7fad940aa000-7fad940ab000 rw-p 00101000 fd:00 34131                      /usr/lib64/libm-2.17.so
7fad940ab000-7fad94110000 r-xp 00000000 fd:00 99189                      /usr/lib64/libcurl.so.4.3.0
7fad94110000-7fad94310000 ---p 00065000 fd:00 99189                      /usr/lib64/libcurl.so.4.3.0
7fad94310000-7fad94312000 r--p 00065000 fd:00 99189                      /usr/lib64/libcurl.so.4.3.0
7fad94312000-7fad94313000 rw-p 00067000 fd:00 99189                      /usr/lib64/libcurl.so.4.3.0
7fad94313000-7fad94314000 rw-p 00000000 00:00 0 
7fad94314000-7fad94322000 r-xp 00000000 fd:00 238864                     /usr/lib64/liblber-2.4.so.2.10.3
7fad94322000-7fad94521000 ---p 0000e000 fd:00 238864                     /usr/lib64/liblber-2.4.so.2.10.3
7fad94521000-7fad94522000 r--p 0000d000 fd:00 238864                     /usr/lib64/liblber-2.4.so.2.10.3
7fad94522000-7fad94523000 rw-p 0000e000 fd:00 238864                     /usr/lib64/liblber-2.4.so.2.10.3
7fad94523000-7fad94573000 r-xp 00000000 fd:00 239186                     /usr/lib64/libldap-2.4.so.2.10.3
7fad94573000-7fad94772000 ---p 00050000 fd:00 239186                     /usr/lib64/libldap-2.4.so.2.10.3
7fad94772000-7fad94775000 r--p 0004f000 fd:00 239186                     /usr/lib64/libldap-2.4.so.2.10.3
7fad94775000-7fad94776000 rw-p 00052000 fd:00 239186                     /usr/lib64/libldap-2.4.so.2.10.3
7fad94776000-7fad94936000 r-xp 00000000 fd:00 1601128                    /usr/lib64/libcrypto.so.1.0.1e
7fad94936000-7fad94b36000 ---p 001c0000 fd:00 1601128                    /usr/lib64/libcrypto.so.1.0.1e
7fad94b36000-7fad94b50000 r--p 001c0000 fd:00 1601128                    /usr/lib64/libcrypto.so.1.0.1e
7fad94b50000-7fad94b5c000 rw-p 001da000 fd:00 1601128                    /usr/lib64/libcrypto.so.1.0.1e
7fad94b5c000-7fad94b60000 rw-p 00000000 00:00 0 
7fad94b60000-7fad94bc4000 r-xp 00000000 fd:00 43248                      /usr/lib64/libssl.so.1.0.1e
7fad94bc4000-7fad94dc3000 ---p 00064000 fd:00 43248                      /usr/lib64/libssl.so.1.0.1e
7fad94dc3000-7fad94dc7000 r--p 00063000 fd:00 43248                      /usr/lib64/libssl.so.1.0.1e
7fad94dc7000-7fad94dce000 rw-p 00067000 fd:00 43248                      /usr/lib64/libssl.so.1.0.1e
7fad94dce000-7fad94dd3000 r-xp 00000000 fd:00 670688                     /usr/lib64/libOpenIPMIposix.so.0.0.1
7fad94dd3000-7fad94fd2000 ---p 00005000 fd:00 670688                     /usr/lib64/libOpenIPMIposix.so.0.0.1
7fad94fd2000-7fad94fd3000 r--p 00004000 fd:00 670688                     /usr/lib64/libOpenIPMIposix.so.0.0.1
7fad94fd3000-7fad94fd4000 rw-p 00005000 fd:00 670688                     /usr/lib64/libOpenIPMIposix.so.0.0.1
7fad94fd4000-7fad950c1000 r-xp 00000000 fd:00 670682                     /usr/lib64/libOpenIPMI.so.0.0.5
7fad950c1000-7fad952c1000 ---p 000ed000 fd:00 670682                     /usr/lib64/libOpenIPMI.so.0.0.5
7fad952c1000-7fad952d7000 r--p 000ed000 fd:00 670682                     /usr/lib64/libOpenIPMI.so.0.0.5
7fad952d7000-7fad952dd000 rw-p 00103000 fd:00 670682                     /usr/lib64/libOpenIPMI.so.0.0.5
7fad952dd000-7fad952e1000 rw-p 00000000 00:00 0 
7fad952e1000-7fad95309000 r-xp 00000000 fd:00 584358                     /usr/lib64/libssh2.so.1.0.1
7fad95309000-7fad95509000 ---p 00028000 fd:00 584358                     /usr/lib64/libssh2.so.1.0.1
7fad95509000-7fad9550a000 r--p 00028000 fd:00 584358                     /usr/lib64/libssh2.so.1.0.1
7fad9550a000-7fad9550b000 rw-p 00029000 fd:00 584358                     /usr/lib64/libssh2.so.1.0.1
7fad9550b000-7fad955d3000 r-xp 00000000 fd:00 670696                     /usr/lib64/libnetsnmp.so.31.0.2
7fad955d3000-7fad957d2000 ---p 000c8000 fd:00 670696                     /usr/lib64/libnetsnmp.so.31.0.2
7fad957d2000-7fad957d5000 r--p 000c7000 fd:00 670696                     /usr/lib64/libnetsnmp.so.31.0.2
7fad957d5000-7fad957d7000 rw-p 000ca000 fd:00 670696                     /usr/lib64/libnetsnmp.so.31.0.2
7fad957d7000-7fad9580d000 rw-p 00000000 00:00 0 
7fad9580d000-7fad9586d000 r-xp 00000000 fd:00 29861                      /usr/lib64/libodbc.so.2.0.0
7fad9586d000-7fad95a6c000 ---p 00060000 fd:00 29861                      /usr/lib64/libodbc.so.2.0.0
7fad95a6c000-7fad95a6d000 r--p 0005f000 fd:00 29861                      /usr/lib64/libodbc.so.2.0.0
7fad95a6d000-7fad95a74000 rw-p 00060000 fd:00 29861                      /usr/lib64/libodbc.so.2.0.0
7fad95a74000-7fad95a75000 rw-p 00000000 00:00 0 
7fad95a75000-7fad95bd4000 r-xp 00000000 fd:00 42451                      /usr/lib64/libxml2.so.2.9.1
7fad95bd4000-7fad95dd3000 ---p 0015f000 fd:00 42451                      /usr/lib64/libxml2.so.2.9.1
7fad95dd3000-7fad95ddb000 r--p 0015e000 fd:00 42451                      /usr/lib64/libxml2.so.2.9.1
7fad95ddb000-7fad95ddd000 rw-p 00166000 fd:00 42451                      /usr/lib64/libxml2.so.2.9.1
7fad95ddd000-7fad95ddf000 rw-p 00000000 00:00 0 
7fad95ddf000-7fad960fe000 r-xp 00000000 fd:00 656332                     /usr/lib64/libmysqlclient.so.18.0.0
7fad960fe000-7fad962fe000 ---p 0031f000 fd:00 656332                     /usr/lib64/libmysqlclient.so.18.0.0
7fad962fe000-7fad96306000 r--p 0031f000 fd:00 656332                     /usr/lib64/libmysqlclient.so.18.0.0
7fad96306000-7fad96379000 rw-p 00327000 fd:00 656332                     /usr/lib64/libmysqlclient.so.18.0.0
7fad96379000-7fad96383000 rw-p 00000000 00:00 0 
7fad96383000-7fad963a3000 r-xp 00000000 fd:00 34113                      /usr/lib64/ld-2.17.so
7fad96448000-7fad9644f000 r--s 00000000 fd:00 33646356                   /usr/lib64/gconv/gconv-modules.cache
7fad9644f000-7fad96583000 rw-s 00000000 00:04 1853915140                 /SYSV73004863 (deleted)
7fad96583000-7fad9659a000 rw-p 00000000 00:00 0 
7fad9659d000-7fad9659e000 rw-p 00000000 00:00 0 
7fad9659e000-7fad965a0000 rw-s 00000000 00:04 1853947909                 /SYSV53004863 (deleted)
7fad965a0000-7fad965a1000 rw-p 00000000 00:00 0 
7fad965a1000-7fad965a2000 rw-p 00000000 00:00 0 
7fad965a2000-7fad965a3000 r--p 0001f000 fd:00 34113                      /usr/lib64/ld-2.17.so
7fad965a3000-7fad965a4000 rw-p 00020000 fd:00 34113                      /usr/lib64/ld-2.17.so
7fad965a4000-7fad965a5000 rw-p 00000000 00:00 0 
7fad965a5000-7fad9671f000 r-xp 00000000 fd:00 1618699                    /usr/sbin/zabbix_proxy_mysql
7fad9691e000-7fad96972000 r--p 00179000 fd:00 1618699                    /usr/sbin/zabbix_proxy_mysql
7fad96972000-7fad96979000 rw-p 001cd000 fd:00 1618699                    /usr/sbin/zabbix_proxy_mysql
7fad96979000-7fad9697f000 rw-p 00000000 00:00 0 
7fad9876b000-7fad9878c000 rw-p 00000000 00:00 0                          [heap]
7fad9878c000-7fad987c9000 rw-p 00000000 00:00 0                          [heap]
7fad987c9000-7fad988a5000 rw-p 00000000 00:00 0                          [heap]
7ffcbe603000-7ffcbe8ac000 rw-p 00000000 00:00 0                          [stack]
7ffcbe97a000-7ffcbe97c000 r-xp 00000000 00:00 0                          [vdso]
ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0                  [vsyscall]

I am not



 Comments   
Comment by Vladislavs Sokurenko [ 2017 Jul 11 ]

Which version of MariaDB is your server running on ?

Comment by Glebs Ivanovskis (Inactive) [ 2017 Jul 11 ]

Please let us know exact versions of MariaDB ODBC driver, UnixODBC library and MySQL client library used by your proxy.

Comment by Tyler French [ 2017 Jul 11 ]

@Vladislavs Sokurenko
MariaDB Server Version: MariaDB-server.x86_64 10.2.6-1.el7.centos

@Glebs Ivanovskis
MySQL client: zabbix-proxy-mysql.x86_64 3.0.9-1.el7
MariaDB ODBC Driver: mariadb-connector-odbc-2.0.15-ga-debian-x86_64
UnixODBC library: unixODBC.x86_64 2.3.1-11.el7

Please let me know if there is anything else you all need.

Comment by Glebs Ivanovskis (Inactive) [ 2017 Jul 11 ]

MySQL client: zabbix-proxy-mysql.x86_64 3.0.9-1.el7

No, I meant version of mysqlclient, not Zabbix proxy.

Comment by Tyler French [ 2017 Jul 11 ]

@Glebs Ivanovskis
mysqlclient: libmysqlclient.so.18.0.0

Is that the library you are looking for?

Comment by Glebs Ivanovskis (Inactive) [ 2017 Jul 11 ]

Yes, but I knew it is .so.18 from memory map. I was hoping to get 5.6.x/5.7.y

It is very likely that we will need to look into MySQL, MariaDB and ODBC sources to understand the reason, that's why I'm asking for exact versions.

Comment by Tyler French [ 2017 Jul 11 ]

Ah so then were you looking for this package?
mariadb-libs-5.5.52-1.el7.x86_64

Comment by Glebs Ivanovskis (Inactive) [ 2017 Jul 11 ]

Yeah, looks like this one. So, MariaDB is used also as Zabbix proxy backend, correct?

Comment by Tyler French [ 2017 Jul 11 ]

Yes that is correct.

Comment by Glebs Ivanovskis (Inactive) [ 2017 Jul 11 ]

Thank you for the report and provided information! I think now we have everything we need to investigate this issue. But I'm not promising that it will happen soon. Issue seems quite complex.

Comment by Tyler French [ 2017 Jul 11 ]

Ya i figured that it would take an upgrade of something, which takes a while, before it would be resolved. I have created a python script with pyodbc as a work around for now to complete this check. If it would be helpful I might be able to provide an OVF of the proxy that has this issue.

Comment by Vladislavs Sokurenko [ 2017 Jul 14 ]

Would be interesting to see version of MariaDB Connector/C package if possible.

Sorry, I am quite puzzled,
You say that you use MariaDB-server.x86_64 10.2.6-1.el7.centos
But mariadb-libs-5.5.52-1.el7.x86_64

Shouldn't it be the same version as your server ?

Comment by Tyler French [ 2017 Jul 14 ]

Im not 100% sure on that Vladislavs, the package was installed from their 10.2.6 repo, if you check out the release notes for that version found here(https://mariadb.com/kb/en/mariadb/mariadb-1026-release-notes/), they mention `with backported and reimplemented features from MySQL 5.6 and 5.7` as with all the other 10.X release notes that I checked. My best guess would be that it is current version of that library they are using for this. Running a `yum list mariadb-libs` only comes back with the `5.5.52-1.el7` version that I currently have installed.

vso If I press download in the link provided then I don't see any 5.5.52-1.el7, you could try to install those and see if issue persists please ?

MariaDB-10.2.6-centos7-x86_64-aws-key-managemen..> 16-May-2017 20:34             1226148
MariaDB-10.2.6-centos7-x86_64-client.rpm           16-May-2017 20:34            50259360
MariaDB-10.2.6-centos7-x86_64-common.rpm           16-May-2017 20:34              202204
MariaDB-10.2.6-centos7-x86_64-compat.rpm           16-May-2017 20:34             2975928
MariaDB-10.2.6-centos7-x86_64-connect-engine.rpm   16-May-2017 20:34             2549060
MariaDB-10.2.6-centos7-x86_64-cracklib-password..> 16-May-2017 20:34               16388
MariaDB-10.2.6-centos7-x86_64-devel.rpm            16-May-2017 20:34             6987300
MariaDB-10.2.6-centos7-x86_64-gssapi-server.rpm    16-May-2017 20:34               46904
MariaDB-10.2.6-centos7-x86_64-oqgraph-engine.rpm   16-May-2017 20:34              585840
MariaDB-10.2.6-centos7-x86_64-rocksdb-engine.rpm   16-May-2017 20:34            63196028
MariaDB-10.2.6-centos7-x86_64-server.rpm           16-May-2017 20:34           113526704
MariaDB-10.2.6-centos7-x86_64-shared.rpm           16-May-2017 20:34              396020
MariaDB-10.2.6-centos7-x86_64-test.rpm             16-May-2017 20:34           105610860
MariaDB-10.2.6-centos7-x86_64-tokudb-engine.rpm    16-May-2017 20:34             5554360
galera-25.3.20-1.rhel7.el7.centos.x86_64.rpm       02-May-2017 16:20             8353220
jemalloc-3.6.0-1.el7.x86_64.rpm                    14-Feb-2015 01:09              106112
jemalloc-devel-3.6.0-1.el7.x86_64.rpm              14-Feb-2015 01:09               22876
Comment by Tyler French [ 2017 Jul 14 ]

Doing a `repoquery --whatprovides 'mariadb-libs'` it tells me that they are provided by the `MariaDB-10.2.6-centos7-x86_64-shared.rpm` package.

Generated at Sat Apr 20 08:05:36 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.