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

Zabbix proxy/child with oracle don't stores values in proxy_history table and don't send it to zabbix_server/main node

    XMLWordPrintable

Details

    • Incident report
    • Resolution: Fixed
    • Blocker
    • 1.8.2
    • 1.8.1
    • Proxy (P), Server (S)
    • None
    • Zabbix_server - linux/zabbix_server 1.8.1/mysql
      Zabbix proxy/child node - linux/1.8.1/oracle

    Description

      When i up zabbix proxy or child node with oracle backend, it get configuration from main server and get values from agent, but do not stores it in table proxy_history. In log of zabbix_proxy i see queries look like:

      insert into proxy_history (itemid,clock,value) values (23473,1265894823,'0.101368');
      insert into proxy_history (itemid,clock,value) values (23443,1265894823,'391331046.000000');
      insert into proxy_history (itemid,clock,value) values (23474,1265894824,'0.000000');
      insert into proxy_history (itemid,clock,value) values (23469,1265894824,'0.000000');
      insert into proxy_history (itemid,clock,value) values (23444,1265894824,'1413573977.000000');
      insert into proxy_history (itemid,clock,value) values (23475,1265894825,'0.000000');
      insert into proxy_history (itemid,clock,value) values (23445,1265894825,'0.000000');
      insert into proxy_history (itemid,clock,value) values (23526,1265894826,'74.004794');
      insert into proxy_history (itemid,clock,value) values (23446,1265894826,'391331046.000000');

      But this queries don't execute without error because field ID in table proxy_history is not null, but in this queries it has been ommited.
      Oracle error:
      ERROR: ORA-01400: cannot insert NULL into ("ZABBIX"."PROXY_HISTORY"."ID")

      Query
      = insert into proxy_history (itemid,clock,value)
      values (23446,1265894826,'391331046.000000')

      Attachments

        Activity

          People

            sasha Alexander Vladishev
            inakrin Fyodor
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: