[ZBX-4159] Zabbix frontend does not take into account "nodeid" when updating record for the "acknowledges" and "housekeeper" table in the "ids" table Created: 2011 Sep 21 Updated: 2017 May 30 Resolved: 2011 Nov 08 |
|
| Status: | Closed |
| Project: | ZABBIX BUGS AND ISSUES |
| Component/s: | None |
| Affects Version/s: | 1.8.7 |
| Fix Version/s: | 1.8.9, 1.9.8 (beta) |
| Type: | Incident report | Priority: | Critical |
| Reporter: | Igor Danoshaites (Inactive) | Assignee: | Unassigned |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||
| 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"): -------
------- |
| Comments |
| Comment by Igor Danoshaites (Inactive) [ 2011 Sep 28 ] | ||||||||
|
The same problem occurred for them again, now for the "housekeeper" table: mysql> select * from ids where table_name='housekeeper';
-------
------- After deleting this incorrect "nextid" value error disappeared again. Would be very nice to fix this issue. | ||||||||
| Comment by Alexey Fukalov [ 2011 Oct 07 ] | ||||||||
|
dev branch: svn://svn.zabbix.com/branches/dev/ZBX-4159 | ||||||||
| Comment by Alexey Fukalov [ 2011 Oct 10 ] | ||||||||
|
svn://svn.zabbix.com/branches/1.8 22227 | ||||||||
| Comment by Aleksandrs Saveljevs [ 2011 Oct 14 ] | ||||||||
|
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". | ||||||||
| Comment by Alexey Fukalov [ 2011 Nov 07 ] | ||||||||
|
dev branch: svn://svn.zabbix.com/branches/dev/ZBX-4159 | ||||||||
| Comment by Alexey Fukalov [ 2011 Nov 08 ] | ||||||||
|
COMMIT: svn://svn.zabbix.com/branches/1.8 23037 | ||||||||
| Comment by Alexey Fukalov [ 2011 Nov 08 ] | ||||||||
|
COMMIT: svn://svn.zabbix.com/trunk 23042 | ||||||||
| Comment by Alexander Vladishev [ 2011 Nov 08 ] | ||||||||
|
"[ CMaintenance::create ] Incorrect value for unsigned int field" occur while creating a new maintenance period. <sasha> CLOSED |