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

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 ]

People

Vote (0)
Watch (1)

Dates

  • Created:
    Updated:
    Resolved: