ZABBIX BUGS AND ISSUES

In GUI in Admin -> General -> GUI when I update settings (Save) i have error with NEXTID/IDS <-> auditlog

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Minor Minor
  • Resolution: Fixed
  • Affects Version/s: 2.0.3
  • Fix Version/s: 2.0.4rc1, 2.1.0
  • Component/s: Frontend (F)
  • Labels:
  • Environment:
    RHEL + Oracle RAC g11r2
  • Zabbix ID:
    RTF

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

Activity

Hide
Alexander Vladishev added a comment -

Confirmed in 2.0 branch r29972

Show
Alexander Vladishev added a comment - Confirmed in 2.0 branch r29972
Hide
Alexey Fukalov added a comment -

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

Show
Alexey Fukalov added a comment - Dev branch: svn://svn.zabbix.com/branches/dev/ZBX-5671
Hide
Eduards Samersovs added a comment -

Tested!

Show
Eduards Samersovs added a comment - Tested!
Hide
Alexey Fukalov added a comment -

Fixed in 2.0.4rc r30923, pre-2.1.0 r30924.

Show
Alexey Fukalov added a comment - Fixed in 2.0.4rc r30923, pre-2.1.0 r30924.

People

Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved: