ZABBIX BUGS AND ISSUES
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-5671

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

    Details

    • Type: Bug Bug
    • Status: 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

      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

          • Assignee:
            Alexey Fukalov
            Reporter:
            Olgierd Wolodkiewicz
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: