[ZBX-15824] [Z3005] query failed: [-1] ORA-24373: invalid length specified for statement [] Created: 2019 Mar 15  Updated: 2019 Mar 15  Resolved: 2019 Mar 15

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

Type: Problem report Priority: Blocker
Reporter: romeo Assignee: Zabbix Support Team
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

zabbix4.0.5 oracle12.2.0.1 rhel 7.4

Attachments: File zabbix_proxy.conf     Text File zabbix_proxy.log    
Issue Links:
Duplicate
duplicates ZBX-15798 Proxy with Oracle backend doesn't upd... Closed

 Description   

Hello, I encountered a problem when start zabbix proxy . error info is :

 28521:20190315:131022.668 End of get_data_from_server():SUCCEED
 28521:20190315:131022.668 received configuration data from server at "192.168.200.228", datalen 19009
 28521:20190315:131022.668 In process_proxyconfig()
 28521:20190315:131022.668 In process_proxyconfig_table() table:'globalmacro'
 28521:20190315:131022.668 query [txnlev:1] [select globalmacroid,macro,value from globalmacro]
zabbix_proxy [28521]: ERROR [file:db.c,line:1568] Something impossible has just happened.
 28521:20190315:131022.671 === Backtrace: ===
 28521:20190315:131022.672 10: ./zabbix_proxy: configuration syncer [loading configuration](zbx_backtrace+0x2b) [0x48df1b]
 28521:20190315:131022.672 9: ./zabbix_proxy: configuration syncer [loading configuration](DBexecute_overflowed_sql+0x93) [0x4bdc33]
 28521:20190315:131022.672 8: ./zabbix_proxy: configuration syncer [loading configuration](process_proxyconfig+0x1772) [0x4c4022]
 28521:20190315:131022.672 7: ./zabbix_proxy: configuration syncer [loading configuration]() [0x427154]
 28521:20190315:131022.672 6: ./zabbix_proxy: configuration syncer [loading configuration](proxyconfig_thread+0xc9) [0x427369]
 28521:20190315:131022.672 5: ./zabbix_proxy: configuration syncer [loading configuration](zbx_thread_start+0x3e) [0x49087e]
 28521:20190315:131022.672 4: ./zabbix_proxy: configuration syncer [loading configuration](MAIN_ZABBIX_ENTRY+0x561) [0x421861]
 28521:20190315:131022.672 3: ./zabbix_proxy: configuration syncer [loading configuration](daemon_start+0x1a5) [0x48da35]
 28521:20190315:131022.672 2: ./zabbix_proxy: configuration syncer [loading configuration](main+0x50d) [0x4209bd]
 28521:20190315:131022.672 1: /lib64/libc.so.6(__libc_start_main+0xf5) [0x7fd79a1f8c05]
 28521:20190315:131022.673 0: ./zabbix_proxy: configuration syncer [loading configuration]() [0x420f30]
 28521:20190315:131022.673 query [txnlev:1] []
 28521:20190315:131022.673 [Z3005] query failed: [-1] ORA-24373: invalid length specified for statement []
 28521:20190315:131022.673 query [] failed, setting transaction as failed
 28521:20190315:131022.673 End of process_proxyconfig_table():FAIL
 28521:20190315:131022.674 failed to update local proxy configuration copy: database error
 28521:20190315:131022.674 End of process_proxyconfig()
 28521:20190315:131022.674 End of process_configuration_sync()
 28521:20190315:131022.674 __zbx_zbx_setproctitle() title:'configuration syncer [synced config 19009 bytes in 0.031196 sec, idle 60 sec]'

please give some help, thanks very much...

 Comments   
Comment by Edgar Akhmetshin [ 2019 Mar 15 ]

Hello Romeo,

Could you attach the following information:

  • which version of the Oracle database used;
  • operating system used and it's version;
  • configure and compile options for the Zabbix Proxy;
  • encoding used for the Proxy database, for example: 
    sqlplus> select parameter,value from v$nls_parameters where parameter='NLS_CHARACTERSET' or parameter='NLS_NCHAR_CHARACTERSET';
  • objdump -Dswx $(which zabbix_proxy) | gzip -c > zabbix_server.objdump.gz
  • ldd $(which zabbix_proxy)

Regards,
Edgar

Comment by romeo [ 2019 Mar 15 ] 
which version of the Oracle database used;
oracle 12.2.0.1

operating system used and it's version;
redhat 7.4 x86_64  Red Hat Enterprise Linux Server release 7.4 (Maipo)

configure and compile options for the Zabbix Proxy;
complie optins:
./configure --prefix=/usr/local/zabbix-4.0.5/ --enable-server --enable-agent --enable-proxy --enable-java --with-unixodbc --with-oracle=/home/oracle/app/oracle/product/12.2.0.1/client_1 --with-net-snmp --with-openipmi --with-ssh2 --with-libcurl --with-libxml2 --with-jabber=/usr/local/libiksemel --with-ldap --enable-ipv6
configure file see the attachment


encoding used for the Proxy database, for example:
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_CHARACTERSET
AL32UTF8

NLS_NCHAR_CHARACTERSET
AL16UTF16
Comment by Edgar Akhmetshin [ 2019 Mar 15 ]

Romeo,

Encoding must be UTF-8. The required encoding is specified in the documentation for all versions: database creation steps.

Please, set accordingly and try again.

Regards,
Edgar

Comment by romeo [ 2019 Mar 15 ]

Hi, I recreate DataBase set Encoding to UTF-8 all of them:
SQL> select parameter,value from v$nls_parameters where parameter='NLS_CHARACTERSET' or parameter='NLS_NCHAR_CHARACTERSET';

PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_CHARACTERSET
AL32UTF8

NLS_NCHAR_CHARACTERSET
UTF8

but zabbix proxy still throw the error info.

Comment by Aigars Kadikis [ 2019 Mar 15 ]

This is known bug in ZBX-15798. Will be fixed in 4.0.6. Closing a duplicate.

For the current situation, I would like to suggest to use 4.0.3 version for the proxy. I know it works well there.

Comment by romeo [ 2019 Mar 15 ]

[zabbix@zabbixproxy sbin]$ ldd zabbix_proxy
linux-vdso.so.1 => (0x00007fff0afee000)
libclntsh.so.12.1 => /home/oracle/app/oracle/product/12.2.0.1/client_1/lib/libclntsh.so.12.1 (0x00007f16e91c5000)
libnnz12.so => /home/oracle/app/oracle/product/12.2.0.1/client_1/lib/libnnz12.so (0x00007f16e8a7b000)
libxml2.so.2 => /lib64/libxml2.so.2 (0x00007f16e86fa000)
libodbc.so.2 => /lib64/libodbc.so.2 (0x00007f16e8492000)
libnetsnmp.so.31 => /lib64/libnetsnmp.so.31 (0x00007f16e818e000)
libssh2.so.1 => /lib64/libssh2.so.1 (0x00007f16e7f64000)
libOpenIPMI.so.0 => /lib64/libOpenIPMI.so.0 (0x00007f16e7c57000)
libOpenIPMIposix.so.0 => /lib64/libOpenIPMIposix.so.0 (0x00007f16e7a50000)
libz.so.1 => /lib64/libz.so.1 (0x00007f16e783a000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f16e761e000)
libevent-2.0.so.5 => /lib64/libevent-2.0.so.5 (0x00007f16e73d5000)
libldap-2.4.so.2 => /lib64/libldap-2.4.so.2 (0x00007f16e7181000)
liblber-2.4.so.2 => /lib64/liblber-2.4.so.2 (0x00007f16e6f72000)
libcurl.so.4 => /lib64/libcurl.so.4 (0x00007f16e6d08000)
libm.so.6 => /lib64/libm.so.6 (0x00007f16e6a06000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007f16e6802000)
libresolv.so.2 => /lib64/libresolv.so.2 (0x00007f16e65e7000)
libpcre.so.1 => /lib64/libpcre.so.1 (0x00007f16e6385000)
libc.so.6 => /lib64/libc.so.6 (0x00007f16e5fc2000)
libmql1.so => /home/oracle/app/oracle/product/12.2.0.1/client_1/lib/libmql1.so (0x00007f16e5d4a000)
libipc1.so => /home/oracle/app/oracle/product/12.2.0.1/client_1/lib/libipc1.so (0x00007f16e5917000)
libons.so => /home/oracle/app/oracle/product/12.2.0.1/client_1/lib/libons.so (0x00007f16e56c9000)
libnsl.so.1 => /lib64/libnsl.so.1 (0x00007f16e54af000)
librt.so.1 => /lib64/librt.so.1 (0x00007f16e52a7000)
libaio.so.1 => /lib64/libaio.so.1 (0x00007f16e50a5000)
/lib64/ld-linux-x86-64.so.2 (0x0000558e87c88000)
libclntshcore.so.12.1 => /home/oracle/app/oracle/product/12.2.0.1/client_1/lib/libclntshcore.so.12.1 (0x00007f16e4ad6000)
libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f16e48c0000)
liblzma.so.5 => /lib64/liblzma.so.5 (0x00007f16e469a000)
libltdl.so.7 => /lib64/libltdl.so.7 (0x00007f16e448f000)
libssl.so.10 => /lib64/libssl.so.10 (0x00007f16e421d000)
libcrypto.so.10 => /lib64/libcrypto.so.10 (0x00007f16e3dbc000)
libOpenIPMIutils.so.0 => /lib64/libOpenIPMIutils.so.0 (0x00007f16e3bb2000)
libgdbm.so.4 => /lib64/libgdbm.so.4 (0x00007f16e39a9000)
libsasl2.so.3 => /lib64/libsasl2.so.3 (0x00007f16e378c000)
libssl3.so => /lib64/libssl3.so (0x00007f16e353f000)
libsmime3.so => /lib64/libsmime3.so (0x00007f16e3318000)
libnss3.so => /lib64/libnss3.so (0x00007f16e2fee000)
libnssutil3.so => /lib64/libnssutil3.so (0x00007f16e2dc0000)
libplds4.so => /lib64/libplds4.so (0x00007f16e2bbc000)
libplc4.so => /lib64/libplc4.so (0x00007f16e29b7000)
libnspr4.so => /lib64/libnspr4.so (0x00007f16e2778000)
libidn.so.11 => /lib64/libidn.so.11 (0x00007f16e2545000)
libgssapi_krb5.so.2 => /lib64/libgssapi_krb5.so.2 (0x00007f16e22f8000)
libkrb5.so.3 => /lib64/libkrb5.so.3 (0x00007f16e200f000)
libk5crypto.so.3 => /lib64/libk5crypto.so.3 (0x00007f16e1ddc000)
libcom_err.so.2 => /lib64/libcom_err.so.2 (0x00007f16e1bd8000)
libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007f16e19a0000)
libkrb5support.so.0 => /lib64/libkrb5support.so.0 (0x00007f16e1791000)
libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x00007f16e158d000)
libfreebl3.so => /lib64/libfreebl3.so (0x00007f16e1389000)
libselinux.so.1 => /lib64/libselinux.so.1 (0x00007f16e1162000)

Comment by romeo [ 2019 Mar 15 ]

thanks very much, I will chose 4.0.3.

Comment by romeo [ 2019 Mar 15 ]

where can I download 4.0.3 source?

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