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

    • Type: Incident report
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 1.8.1
    • Fix Version/s: 1.8.2
    • Component/s: Proxy (P), Server (S)
    • Labels:
      None
    • Environment:
      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

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

              Dates

              Created:
              Updated:
              Resolved: