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

History Is Lost On Next Query After Oracle Database Restart

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Unresolved
    • Icon: Trivial Trivial
    • None
    • None
    • Proxy (P), Server (S)

      One query will always fail after server restart, resulting in loss of data.

      1. Start zabbix server.
      2. Send some data to trapper and observe it in latest data.
      3. Now restart Oracle database and wait a minute.
      4. Send new data to trapper

      Expected:
      New value is displayed in latest data.

      Actual:
      Value is missing for no reason, since database is up and running.

       25374:20170731:120250.140 [Z3007] query failed: [-1] ORA-03113: end-of-file on communication channel
      Process ID: 10709
      Session ID: 41 Serial number: 471
       25374:20170731:120250.170 [Z3007] query failed: [-1] ORA-01036: illegal variable name/number
      

      Note:
      All values that come immediately after this one will succeed.

            Unassigned Unassigned
            vso Vladislavs Sokurenko
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: