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

        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.
        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
        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
        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".
        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
        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
        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

          People

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

            Dates

            • Created:
              Updated:
              Resolved: