-
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