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

Oracle fetch failure

    XMLWordPrintable

Details

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

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: