-
Incident report
-
Resolution: Fixed
-
Minor
-
2.0.3
-
RHEL + Oracle RAC g11r2
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]
Not always, but generally when I update it 2-3 times in short time window.
I think request goes to node1/2 and if I update it few times the IDS nextid is not updated on time on the other node (RAC).
Will exclusive lock help? Will exclusive lock damage zabbix_server's rcache refresh?
IDs are OK, I think:
SQL> select NEXTID from ids where table_name = 'auditlog';
NEXTID
----------
74870
SQL> select max(AUDITID) from auditlog;
MAX(AUDITID)
------------
74870