[ZBX-7829] "reserveIds" and "refreshIds" functions still assume not 64-bit IDs range in standalone installation. Created: 2014 Feb 18 Updated: 2017 May 30 Resolved: 2014 Feb 25 |
|
Status: | Closed |
Project: | ZABBIX BUGS AND ISSUES |
Component/s: | Frontend (F) |
Affects Version/s: | 2.2.2, 2.3.0 |
Fix Version/s: | 2.2.3rc1, 2.3.0 |
Type: | Incident report | Priority: | Critical |
Reporter: | Oleksii Zagorskyi | Assignee: | Unassigned |
Resolution: | Fixed | Votes: | 0 |
Labels: | dm, ids | ||
Remaining Estimate: | Not Specified | ||
Time Spent: | Not Specified | ||
Original Estimate: | Not Specified |
Issue Links: |
|
Description |
Follow up from In the DB.php:186 we have a code: This code can generates this debug if we try to create something (an item in our case): SQL (0.000169): SELECT nextid FROM ids WHERE nodeid=0 AND table_name='items' AND field_name='itemid' FOR UPDATE SQL (0.00015): DELETE FROM ids WHERE nodeid=0 AND table_name='items' AND field_name='itemid' SQL (0.000139): SELECT MAX(itemid) AS id FROM items WHERE itemid>=0 AND itemid<=99999999999 SQL (0.000129): INSERT INTO ids (nodeid,table_name,field_name,nextid) VALUES (0,'items','itemid',1) Do you see a "WHERE itemid>=0 AND itemid<=99999999999" part ? Where this problem is observed: Suppose we want to revert (not officially supported) a DM (only one node was and is in DB) to standalone. In all configuration tables we had IDs in form like 100100000000002. The same debuglog can be generated if we just truncate the "ids" table. Suggestion: review that part of code and: |
Comments |
Comment by Alexander Vladishev [ 2014 Feb 20 ] |
Related issue: zalex_ua I mentioned that on top of issue description from very beginning |
Comment by Alexander Vladishev [ 2014 Feb 22 ] |
Fixed in the development branch svn://svn.zabbix.com/branches/dev/ZBX-7829 |
Comment by Pavels Jelisejevs (Inactive) [ 2014 Feb 24 ] |
(1) The following functions can also be removed:
sasha RESOLVED in r42956. jelisejev CLOSED. |
Comment by Pavels Jelisejevs (Inactive) [ 2014 Feb 25 ] |
TESTED. |
Comment by Alexander Vladishev [ 2014 Feb 25 ] |
Fixed in pre-2.2.3 r42980 and pre-2.3.0 (trunk) r42981 |