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

Oracle fetch failure

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Trivial Trivial
    • 2.0.4rc1, 2.1.0
    • None
    • None
    • 2.0.3 oracle debian 64

      I cloned Template OS Linux (little bit custom version) to Template Freeradius, then i deleted almost all triggers. That was ok.
      Then i tried to delete almost all items and get this error -

      Deleted: Item "Software raid md0 state" on "Template Freeradius".
      Deleted: Item "Software raid md1 state" on "Template Freeradius".
      Deleted: Item "Software raid md2 state" on "Template Freeradius".
      Deleted: Item "Maximum number of opened files" on "Template Freeradius".
      Deleted: Item "Maximum number of processes" on "Template Freeradius".
      Deleted: Item "Number of running processes" on "Template Freeradius".
      Deleted: Item "Number of processes" on "Template Freeradius".
      Deleted: Item "Cron proc check" on "Template Freeradius".
      Deleted: Item "Ntpd proc check" on "Template Freeradius".
      Deleted: Item "Sshd proc check" on "Template Freeradius".
      Deleted: Item "Host boot time" on "Template Freeradius".
      Deleted: Item "Interrupts per second" on "Template Freeradius".
      Deleted: Item "Processor load (15 min average per core)" on "Template Freeradius".
      Deleted: Item "Processor load (1 min average per core)" on "Template Freeradius".
      Deleted: Item "Processor load (5 min average per core)" on "Template Freeradius".
      Deleted: Item "Context switches per second" on "Template Freeradius".
      Deleted: Item "CPU $2 time" on "Template Freeradius".
      Deleted: Item "CPU $2 time" on "Template Freeradius".
      Deleted: Item "CPU $2 time" on "Template Freeradius".
      Deleted: Item "CPU $2 time" on "Template Freeradius".
      Deleted: Item "CPU $2 time" on "Template Freeradius".
      Deleted: Item "CPU $2 time" on "Template Freeradius".
      Deleted: Item "CPU $2 time" on "Template Freeradius".
      Deleted: Item "CPU $2 time" on "Template Freeradius".
      Deleted: Item "Host name" on "Template Freeradius".
      Deleted: Item "Host local time" on "Template Freeradius".
      Deleted: Item "Free swap space" on "Template Freeradius".
      Deleted: Item "Free swap space in %" on "Template Freeradius".
      Deleted: Item "Total swap space" on "Template Freeradius".
      Deleted: Item "System information" on "Template Freeradius".
      Deleted: Item "System uptime" on "Template Freeradius".
      Deleted: Item "Number of logged in users" on "Template Freeradius".
      Deleted: Item "Checksum of $1" on "Template Freeradius".
      Deleted: Item "Available memory" on "Template Freeradius".
      Deleted: Item "Total memory" on "Template Freeradius".
      oci_execute(): ORA-01002: fetch out of sequence [include/db.inc.php:449]
      SQL error [ORA-01002: fetch out of sequence] in [SELECT nextid FROM ids WHERE nodeid=0 AND table_name='auditlog' AND field_name='auditid' FOR UPDATE]
      ocifetchinto(): ORA-01002: fetch out of sequence [include/db.inc.php:582]
      oci_execute(): ORA-01002: fetch out of sequence [include/db.inc.php:449]
      SQL error [ORA-01002: fetch out of sequence] in [SELECT nextid FROM ids WHERE nodeid=0 AND table_name='auditlog' AND field_name='auditid' FOR UPDATE]
      ocifetchinto(): ORA-01002: fetch out of sequence [include/db.inc.php:582]
      oci_execute(): ORA-01002: fetch out of sequence [include/db.inc.php:449]
      SQL error [ORA-01002: fetch out of sequence] in [SELECT nextid FROM ids WHERE nodeid=0 AND table_name='auditlog' AND field_name='auditid' FOR UPDATE]
      ocifetchinto(): ORA-01002: fetch out of sequence [include/db.inc.php:582]
      oci_execute(): ORA-01002: fetch out of sequence [include/db.inc.php:449]
      SQL error [ORA-01002: fetch out of sequence] in [SELECT nextid FROM ids WHERE nodeid=0 AND table_name='auditlog' AND field_name='auditid' FOR UPDATE]
      ocifetchinto(): ORA-01002: fetch out of sequence [include/db.inc.php:582]
      oci_execute(): ORA-01002: fetch out of sequence [include/db.inc.php:449]
      SQL error [ORA-01002: fetch out of sequence] in [SELECT nextid FROM ids WHERE nodeid=0 AND table_name='auditlog' AND field_name='auditid' FOR UPDATE]
      ocifetchinto(): ORA-01002: fetch out of sequence [include/db.inc.php:582]
      oci_execute(): ORA-01002: fetch out of sequence [include/db.inc.php:449]
      SQL error [ORA-01002: fetch out of sequence] in [SELECT nextid FROM ids WHERE nodeid=0 AND table_name='auditlog' AND field_name='auditid' FOR UPDATE]
      ocifetchinto(): ORA-01002: fetch out of sequence [include/db.inc.php:582]
      oci_execute(): ORA-01002: fetch out of sequence [include/db.inc.php:449]
      SQL error [ORA-01002: fetch out of sequence] in [SELECT nextid FROM ids WHERE nodeid=0 AND table_name='auditlog' AND field_name='auditid' FOR UPDATE]
      ocifetchinto(): ORA-01002: fetch out of sequence [include/db.inc.php:582]
      oci_execute(): ORA-01002: fetch out of sequence [include/db.inc.php:449]
      SQL error [ORA-01002: fetch out of sequence] in [SELECT nextid FROM ids WHERE nodeid=0 AND table_name='auditlog' AND field_name='auditid' FOR UPDATE]
      ocifetchinto(): ORA-01002: fetch out of sequence [include/db.inc.php:582]
      oci_execute(): ORA-01002: fetch out of sequence [include/db.inc.php:449]
      SQL error [ORA-01002: fetch out of sequence] in [SELECT nextid FROM ids WHERE nodeid=0 AND table_name='auditlog' AND field_name='auditid' FOR UPDATE]
      ocifetchinto(): ORA-01002: fetch out of sequence [include/db.inc.php:582]
      oci_execute(): ORA-01002: fetch out of sequence [include/db.inc.php:449]
      SQL error [ORA-01002: fetch out of sequence] in [SELECT nextid FROM ids WHERE nodeid=0 AND table_name='auditlog' AND field_name='auditid' FOR UPDATE]
      ocifetchinto(): ORA-01002: fetch out of sequence [include/db.inc.php:582]
      oci_execute(): ORA-01002: fetch out of sequence [include/db.inc.php:449]
      SQL error [ORA-01002: fetch out of sequence] in [SELECT nextid FROM ids WHERE nodeid=0 AND table_name='auditlog' AND field_name='auditid' FOR UPDATE]
      ocifetchinto(): ORA-01002: fetch out of sequence [include/db.inc.php:582]
      oci_execute(): ORA-01002: fetch out of sequence [include/db.inc.php:449]
      SQL error [ORA-01002: fetch out of sequence] in [SELECT nextid FROM ids WHERE nodeid=0 AND table_name='auditlog' AND field_name='auditid' FOR UPDATE]
      ocifetchinto(): ORA-01002: fetch out of sequence [include/db.inc.php:582]
      oci_execute(): ORA-01002: fetch out of sequence [include/db.inc.php:449]
      SQL error [ORA-01002: fetch out of sequence] in [SELECT nextid FROM ids WHERE nodeid=0 AND table_name='auditlog' AND field_name='auditid' FOR UPDATE]
      ocifetchinto(): ORA-01002: fetch out of sequence [include/db.inc.php:582]
      oci_execute(): ORA-01002: fetch out of sequence [include/db.inc.php:449]
      SQL error [ORA-01002: fetch out of sequence] in [SELECT nextid FROM ids WHERE nodeid=0 AND table_name='auditlog' AND field_name='auditid' FOR UPDATE]
      ocifetchinto(): ORA-01002: fetch out of sequence [include/db.inc.php:582]
      oci_execute(): ORA-01002: fetch out of sequence [include/db.inc.php:449]
      SQL error [ORA-01002: fetch out of sequence] in [SELECT nextid FROM ids WHERE nodeid=0 AND table_name='auditlog' AND field_name='auditid' FOR UPDATE]
      ocifetchinto(): ORA-01002: fetch out of sequence [include/db.inc.php:582]
      oci_execute(): ORA-01002: fetch out of sequence [include/db.inc.php:449]
      SQL error [ORA-01002: fetch out of sequence] in [SELECT nextid FROM ids WHERE nodeid=0 AND table_name='auditlog' AND field_name='auditid' FOR UPDATE]
      ocifetchinto(): ORA-01002: fetch out of sequence [include/db.inc.php:582]
      oci_execute(): ORA-01002: fetch out of sequence [include/db.inc.php:449]
      SQL error [ORA-01002: fetch out of sequence] in [SELECT nextid FROM ids WHERE nodeid=0 AND table_name='auditlog' AND field_name='auditid' FOR UPDATE]
      ocifetchinto(): ORA-01002: fetch out of sequence [include/db.inc.php:582]
      

      But items deleted.

            Unassigned Unassigned
            netflash Alexander Romanov
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: