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

When deleting items I have very often: ociexecute(): ORA-01002: fetch out of sequence

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 2.0.3
    • Fix Version/s: None
    • Component/s: Frontend (F)
    • Labels:
    • Environment:
      RHEL + Oracle g11r2

      Description

      Very often when I remove items (mass delete) from template (with assigned hosts) I have errors:

      ociexecute(): ORA-01002: fetch out of sequence [include/db.inc.php:446]
      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:579]
      ociexecute(): ORA-01002: fetch out of sequence [include/db.inc.php:446]
      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:579]

      SQL> select max(auditid) from auditlog;

      MAX(AUDITID)
      ------------
      77327

      SQL> select table_name,nextid from ids where table_name='auditlog';

      TABLE_NAME NEXTID
      ---------------------------------------------------------------- ----------
      auditlog 77327

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              olgierdw Olgierd Wolodkiewicz
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: