- 
    Incident report 
- 
    Resolution: Duplicate
- 
    Major 
- 
    None
- 
    2.0.3
- 
    RHEL + Oracle g11r2
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
- duplicates
- 
                    ZBX-5759 Oracle fetch failure -         
- Closed
 
-