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

[ORACLE DB] Latest data does not reflect values inserted in history table

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Won't fix
    • Icon: Trivial Trivial
    • None
    • 4.0.45, 5.0.34, 6.0.17, 6.4.2, 7.0.0alpha1
    • Frontend (F)

      Steps to reproduce:

      1. Setup Zabbix fronted + Oracle db
      2. Create trapper item with value type float, memorize itemid
      3. Open oracle console: rlwrap sqlplus -S ...
      4. Insert value for that item: INSERT INTO history (itemid, clock, value, ns) VALUES (44718, 1684231582, 10.123456, 0);
      5. Check that value really inserted:
      6. select * from history;
      7. Open frontend Latest data, open trapper, select - Values or Show latest 500 values

      Result:
      There are no any values for that item in the frontend page.

      The problem is actual in any Zabbix version starting from 4.0
      The same case in Mysql db works totally fine - values present in the Latest data section.

            zabbix.dev Zabbix Development Team
            lgrigorjeva Larisa Grigorjeva
            Team C
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: