[ZBX-5671] In GUI in Admin -> General -> GUI when I update settings (Save) i have error with NEXTID/IDS <-> auditlog Created: 2012 Oct 08  Updated: 2017 May 30  Resolved: 2012 Oct 16

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 2.0.3
Fix Version/s: 2.0.4rc1, 2.1.0

Type: Incident report Priority: Minor
Reporter: Olgierd Wolodkiewicz Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: database, oracle
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

RHEL + Oracle RAC g11r2



 Description   

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



 Comments   
Comment by Alexander Vladishev [ 2012 Oct 16 ]

Confirmed in 2.0 branch r29972

Comment by Alexey Fukalov [ 2012 Oct 16 ]

Dev branch: svn://svn.zabbix.com/branches/dev/ZBX-5671

Comment by Eduards Samersovs (Inactive) [ 2012 Oct 18 ]

Tested!

Comment by Alexey Fukalov [ 2012 Oct 18 ]

Fixed in 2.0.4rc r30923, pre-2.1.0 r30924.

Generated at Thu Apr 25 18:33:31 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.