ZABBIX BUGS AND ISSUES

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 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
  • Zabbix ID:
    NA

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

Vote (0)
Watch (1)

Dates

  • Created:
    Updated:
    Resolved: