[ZBX-7363] history syncer fails to add item (zbx_vc_add_value():FAIL) Created: 2013 Nov 14  Updated: 2018 Aug 30  Resolved: 2016 Jan 25

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 2.2.0
Fix Version/s: None

Type: Incident report Priority: Major
Reporter: Gerrit Fluck Assignee: Unassigned
Resolution: Won't fix Votes: 2
Labels: dm, history, synchronization
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Linux version 3.10.7 gentoo amd64



 Description   

We have a node setup with 3 nodes (1 master and 2 child nodes), all gentoo 64 bit machines with same kernel

Master Node ID 1
--> Child Node ID3
--> Child Node ID4

Log entries are from node 3.
After successfully inserting item in local history

 13399:20131114:151517.041 query [txnlev:1] [insert into history (itemid,clock,ns,value) values (300300000000064,1384438507,980511332,0.000000),(300300000000065,1384438508,976509910,0.000000),(300300000000066,1384438509,974621617,0.000000),(300300000000067,1384438511,36463966,0.000000),(300300000000068,1384438511,57185880,0.000000),(300300000000069,1384438512,74096359,0.000000);
insert into history_sync (nodeid,itemid,clock,ns,value) values (3,300300000000064,1384438507,980511332,0.000000),(3,300300000000065,1384438508,976509910,0.000000),(3,300300000000066,1384438509,974621617,0.000000),(3,300300000000067,1384438511,36463966,0.000000),(3,300300000000068,1384438511,57185880,0.000000),(3,300300000000069,1384438512,74096359,0.000000);
insert into history_uint (itemid,clock,ns,value) values (300100000011065,1384438508,961778389,1),(300100000011007,1384438510,965445862,4294950912);
insert into history_uint_sync (nodeid,itemid,clock,ns,value) values (3,300100000011065,1384438508,961778389,1),(3,300100000011007,1384438510,965445862,4294950912);
insert into history_text (id,itemid,clock,ns,value) values (300000000024152,300100000011045,1384438515,587031711,''),(300000000024153,300100000011046,1384438516,589438628,'[ens192] 00:50:56:bf:48:f2');
]

sync seems to fail:

 13400:20131114:151517.041 history syncer #4 [synced 0 items in 0.000041 sec, syncing history]
 13400:20131114:151517.041 In DCsync_history() history_first:33328 history_num:0
 13400:20131114:151517.041 history syncer #4 [synced 0 items in 0.000041 sec, idle 5 sec]
 13399:20131114:151517.042 In zbx_vc_add_value() itemid:300300000000064 value_type:0 timestamp:1384438507.980511332
 13399:20131114:151517.042 End of zbx_vc_add_value():FAIL
 13399:20131114:151517.042 In zbx_vc_add_value() itemid:300100000011065 value_type:3 timestamp:1384438508.961778389
 13399:20131114:151517.043 End of zbx_vc_add_value():FAIL
 13399:20131114:151517.043 In zbx_vc_add_value() itemid:300300000000065 value_type:0 timestamp:1384438508.976509910
 13399:20131114:151517.043 End of zbx_vc_add_value():FAIL

Although master seems to successfully save the history:

 13344:20131114:151518.062 NODE 3: sending [History<AD>3<AD>3<AD>history_sync
300100000010999<AD>1384438502<AD>99.8813<AD>951327825
300300000000059<AD>1384438502<AD>0.0000<AD>970419067
300100000011000<AD>1384438503<AD>0.0021<AD>953979868
300300000000060<AD>1384438503<AD>0.0000<AD>973655838
300100000011001<AD>1384438504<AD>0.0607<AD>957529798
300300000000061<AD>1384438504<AD>0.0000<AD>977182637
300100000011002<AD>1384438505<AD>0.0503<AD>958513588
300300000000062<AD>1384438505<AD>0.0000<AD>978526894
300300000000063<AD>1384438506<AD>0.0000<AD>981091763
300300000000064<AD>1384438507<AD>0.0000<AD>980511332
300300000000065<AD>1384438508<AD>0.0000<AD>976509910
300300000000066<AD>1384438509<AD>0.0000<AD>974621617
300300000000067<AD>1384438511<AD>0.0000<AD>36463966
300300000000068<AD>1384438511<AD>0.0000<AD>57185880
300300000000069<AD>1384438512<AD>0.0000<AD>74096359] to Node [1]
 13344:20131114:151518.069 NODE 3: receiving [OK] from Node [1]
 13344:20131114:151518.069 OK

What are those messages about?

We have many sync problems since 2.2.0.

Gerrit



 Comments   
Comment by Aleksandrs Saveljevs [ 2016 Jan 25 ]

According to the following comment

 * Function: zbx_vc_add_value                                                 *
 *                                                                            *
 * Purpose: adds an item value to the value cache                             *
 *                                                                            *
 ...
 *                                                                            *
 * Return value:  SUCCEED - the item values were added successfully           *
 *                FAIL    - failed to add item values to cache (not fatal     *
 *                          failure - cache might be in low memory mode)      *

the following message does not necessarily indicate a problem:

End of zbx_vc_add_value():FAIL
Comment by Aleksandrs Saveljevs [ 2016 Jan 25 ]

With distributed monitoring removed in Zabbix 2.4, this issue is unlikely to be looked into, so closing as "Won't fix".

Comment by George [ 2018 Aug 30 ]

Hi, I'm a bit confused. Does this mean that this functionality works in a later version? ... or does this mean that this will not be supported from 2.4 and onwards???

Generated at Sat Apr 27 02:11:13 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.