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

[Z3005] query failed: [-1] ORA-24373: invalid length specified for statement []

    Details

    • Type: Problem report
    • Status: Closed
    • Priority: Blocker
    • Resolution: Duplicate
    • Affects Version/s: 4.0.5
    • Fix Version/s: None
    • Component/s: Proxy (P)
    • Labels:
      None
    • Environment:
      zabbix4.0.5 oracle12.2.0.1 rhel 7.4

      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...

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                zabbix.support Zabbix Support Team
                Reporter:
                rochine123 romeo
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: