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

Zabbix frontend does not take into account "nodeid" when updating record for the "acknowledges" and "housekeeper" table in the "ids" table

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Critical Critical
    • Resolution: Fixed
    • Affects Version/s: 1.8.7
    • Fix Version/s: 1.8.9, 1.9.8 (beta)
    • Component/s: None
    • Labels:
      None

      Description

      Zabbix frontend does not take into account "nodeid" when updating record for the "acknowledges" table in the "ids" table.

      That is why in some cases in the frontend can appear the following error: "[ CEvent::acknowledge ] DB::reserveIds ID out of range for [acknowledges]"

      At the same time in the Zabbix DB in the "ids" table for the "acknowledges" table in the "nextid" field will be incorrect "1000000000015291" value, instead of the correct value "1001000000015291"):

      --------------------------------------------------------------------+

      nodeid table_name field_name nextid

      --------------------------------------------------------------------+
      10 | acknowledges | acknowledgeid | 1000000000015291 |

        Activity

        Igor Danoshaites created issue -
        Igor Danoshaites made changes -
        Field Original Value New Value
        Link This issue is duplicated by NTC-1 [ NTC-1 ]
        Igor Danoshaites made changes -
        Summary Zabbix fronend does not take into account "nodeid" when updating record for the "acknowledges" table in the "ids" table Zabbix frontend does not take into account "nodeid" when updating record for the "acknowledges" table in the "ids" table
        Description Zabbix fronend does not take into account "nodeid" when updating record for the "acknowledges" table in the "ids" table.

        That is why in some cases in the frontend can appear the following error: "[ CEvent::acknowledge ] DB::reserveIds ID out of range for [acknowledges]"

        At the same time in the Zabbix DB in the "ids" table for the "acknowledges" table in the "nextid" field will be incorrect "1000000000015291" value, instead of the correct value "1001000000015291"):

        +--------+----------------------+--------------------------+------------------+
        | nodeid | table_name | field_name | nextid |
        +--------+----------------------+--------------------------+------------------+
        10 | acknowledges | acknowledgeid | 1000000000015291 |
        Zabbix frontend does not take into account "nodeid" when updating record for the "acknowledges" table in the "ids" table.

        That is why in some cases in the frontend can appear the following error: "[ CEvent::acknowledge ] DB::reserveIds ID out of range for [acknowledges]"

        At the same time in the Zabbix DB in the "ids" table for the "acknowledges" table in the "nextid" field will be incorrect "1000000000015291" value, instead of the correct value "1001000000015291"):

        +--------+----------------------+--------------------------+------------------+
        | nodeid | table_name | field_name | nextid |
        +--------+----------------------+--------------------------+------------------+
        10 | acknowledges | acknowledgeid | 1000000000015291 |
        Hide
        Igor Danoshaites added a comment -

        The same problem occurred for them again, now for the "housekeeper" table:

        mysql> select * from ids where table_name='housekeeper';
        ------------------------------------------------+

        nodeid table_name field_name nextid

        ------------------------------------------------+

        10 housekeeper housekeeperid 1000000000000119

        ------------------------------------------------+
        1 row in set (0.00 sec)

        After deleting this incorrect "nextid" value error disappeared again.

        Would be very nice to fix this issue.

        Show
        Igor Danoshaites added a comment - The same problem occurred for them again, now for the "housekeeper" table: mysql> select * from ids where table_name='housekeeper'; ------- ----------- ------------- -----------------+ nodeid table_name field_name nextid ------- ----------- ------------- -----------------+ 10 housekeeper housekeeperid 1000000000000119 ------- ----------- ------------- -----------------+ 1 row in set (0.00 sec) After deleting this incorrect "nextid" value error disappeared again. Would be very nice to fix this issue.
        Igor Danoshaites made changes -
        Summary Zabbix frontend does not take into account "nodeid" when updating record for the "acknowledges" table in the "ids" table Zabbix frontend does not take into account "nodeid" when updating record for the "acknowledges" and "housekeeper" table in the "ids" table
        Alexey Fukalov made changes -
        Assignee Igor Danoshaites [ igor ] Alexei Fukalov [ vedmak ]
        Hide
        Alexey Fukalov added a comment -

        dev branch: svn://svn.zabbix.com/branches/dev/ZBX-4159

        Show
        Alexey Fukalov added a comment - dev branch: svn://svn.zabbix.com/branches/dev/ZBX-4159
        Alexey Fukalov made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Aleksandrs Saveljevs made changes -
        Assignee Alexei Fukalov [ vedmak ] Aleksandrs Saveljevs [ asaveljevs ]
        Aleksandrs Saveljevs made changes -
        Resolution Fixed [ 1 ]
        Status Resolved [ 5 ] Reopened [ 4 ]
        Assignee Aleksandrs Saveljevs [ asaveljevs ] Alexei Fukalov [ vedmak ]
        Alexey Fukalov made changes -
        Status Reopened [ 4 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Aleksandrs Saveljevs made changes -
        Status Resolved [ 5 ] Tested [ 10002 ]
        Hide
        Alexey Fukalov added a comment -

        svn://svn.zabbix.com/branches/1.8 22227

        Show
        Alexey Fukalov added a comment - svn://svn.zabbix.com/branches/1.8 22227
        Alexey Fukalov made changes -
        Status Tested [ 10002 ] Closed [ 6 ]
        Oleksiy Zagorskyi made changes -
        Resolution Fixed [ 1 ]
        Status Closed [ 6 ] Reopened [ 4 ]
        Oleksiy Zagorskyi made changes -
        Fix Version/s 1.8.9 [ 10500 ]
        Fix Version/s 1.9.7 (trunk) [ 10502 ]
        Oleksiy Zagorskyi made changes -
        Status Reopened [ 4 ] Closed [ 6 ]
        Resolution Fixed [ 1 ]
        Hide
        Aleksandrs Saveljevs added a comment -

        The fix does not work.

        Suppose an event is acknowledged on a child node. This acknowledge has a historical ID, meaning it does not have a source node identifier - only the destination node number. Events for child nodes can also be acknowledged on master nodes. Thus, a conflict is possible between an ID generated on the child node and ID generated on the master node.

        Four tables are subject to this problem: "events", "acknowledges", "auditlog", "auditlog_details".

        Show
        Aleksandrs Saveljevs added a comment - The fix does not work. Suppose an event is acknowledged on a child node. This acknowledge has a historical ID, meaning it does not have a source node identifier - only the destination node number. Events for child nodes can also be acknowledged on master nodes. Thus, a conflict is possible between an ID generated on the child node and ID generated on the master node. Four tables are subject to this problem: "events", "acknowledges", "auditlog", "auditlog_details".
        Aleksandrs Saveljevs made changes -
        Resolution Fixed [ 1 ]
        Status Closed [ 6 ] Reopened [ 4 ]
        Assignee Alexei Fukalov [ vedmak ]
        Aleksandrs Saveljevs made changes -
        Assignee Alexander Vladishev [ sasha ]
        richlv made changes -
        Fix Version/s 1.9.8 (trunk) [ 10701 ]
        Fix Version/s 1.9.7 (beta) [ 10502 ]
        Alexey Fukalov made changes -
        Assignee Alexander Vladishev [ sasha ] Alexei Fukalov [ vedmak ]
        Hide
        Alexey Fukalov added a comment -

        dev branch: svn://svn.zabbix.com/branches/dev/ZBX-4159

        Show
        Alexey Fukalov added a comment - dev branch: svn://svn.zabbix.com/branches/dev/ZBX-4159
        Alexey Fukalov made changes -
        Status Reopened [ 4 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Alexander Vladishev made changes -
        Resolution Fixed [ 1 ]
        Status Resolved [ 5 ] Reopened [ 4 ]
        Alexey Fukalov made changes -
        Status Reopened [ 4 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Alexander Vladishev made changes -
        Status Resolved [ 5 ] Tested [ 10002 ]
        Hide
        Alexey Fukalov added a comment -

        COMMIT: svn://svn.zabbix.com/branches/1.8 23037

        Show
        Alexey Fukalov added a comment - COMMIT: svn://svn.zabbix.com/branches/1.8 23037
        Hide
        Alexey Fukalov added a comment -

        COMMIT: svn://svn.zabbix.com/trunk 23042

        Show
        Alexey Fukalov added a comment - COMMIT: svn://svn.zabbix.com/trunk 23042
        Alexey Fukalov made changes -
        Status Tested [ 10002 ] Closed [ 6 ]
        Hide
        Alexander Vladishev added a comment - - edited

        "[ CMaintenance::create ] Incorrect value for unsigned int field" occur while creating a new maintenance period.

        <sasha> CLOSED

        Show
        Alexander Vladishev added a comment - - edited "[ CMaintenance::create ] Incorrect value for unsigned int field" occur while creating a new maintenance period. <sasha> CLOSED
        Alexander Vladishev made changes -
        Resolution Fixed [ 1 ]
        Status Closed [ 6 ] Reopened [ 4 ]
        Alexey Fukalov made changes -
        Status Reopened [ 4 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Alexander Vladishev made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Assignee Alexei Fukalov [ vedmak ]
        Alexei Vladishev made changes -
        Workflow Zabbix workflow [ 23027 ] Zabbix workflow - new [ 45209 ]

          People

          • Assignee:
            Unassigned
            Reporter:
            Igor Danoshaites
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: