Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Trivial Trivial
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.0.4rc1, 2.1.0
    • Component/s: None
    • Environment:
      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.

        Issue Links

          Activity

          Hide
          Alexander Romanov added a comment -

          also my frontend db.inc.php patched like ZBX-5691

          Show
          Alexander Romanov added a comment - also my frontend db.inc.php patched like ZBX-5691
          Hide
          Alexander Vladishev added a comment -

          Related issue: ZBX-5671

          Show
          Alexander Vladishev added a comment - Related issue: ZBX-5671
          Hide
          Toms added a comment -

          Fixed in dev. branch: svn://svn.zabbix.com/branches/dev/ZBX-5759

          Show
          Toms added a comment - Fixed in dev. branch: svn://svn.zabbix.com/branches/dev/ZBX-5759
          Hide
          Eduards Samersovs added a comment -

          Tested

          Show
          Eduards Samersovs added a comment - Tested
          Hide
          Toms added a comment -

          Fixed in 2.0.4rc1 r31511, 2.1.0 r31512

          Show
          Toms added a comment - Fixed in 2.0.4rc1 r31511, 2.1.0 r31512
          Hide
          Oleksiy Zagorskyi added a comment -

          Looks like similar error has appeared in 2.2.8, see ZBX-9789

          Show
          Oleksiy Zagorskyi added a comment - Looks like similar error has appeared in 2.2.8, see ZBX-9789

            People

            • Assignee:
              Toms
              Reporter:
              Alexander Romanov
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: