Dear Support,

I report this problem with zabbix_sender and hazardous updates in history_log, sometimes the items and history_log are not updated.
I am not sure this linked with zabbix_sender but I did not notice this with zabbix agent and type log items.

The operation is the following:

• zabbix_sender sends a syslog record to zabbix trapper item (type log)
• the log shows successfull zabbix_sender
• the log shows successfull update of table items (but this is wrong)
• the log shows successfull insert in table history_log (but this is wrong)

Thanks for help,
Alain

ZABBIX_SENDER LOG
4305:20120307:103837.636 Trapper got [{
"request":"sender data",
"data":[

{ "host":"sapzas03", "key":"rsyslog.zabbix", "value":"Mar 7 10:38:37 sapzas03 RYGU7300: [ID 702911 local0.notice] TEST ZABBIX"}

]}] len 179
4305:20120307:103837.636 In recv_agenthistory()
4305:20120307:103837.636 In process_hist_data()
4305:20120307:103837.636 In process_mass_data()
4305:20120307:103837.636 In calc_timestamp()
4305:20120307:103837.636 calc_timestamp() 00:00:00 00/00/0000
4305:20120307:103837.636 End of calc_timestamp() timestamp:0
4305:20120307:103837.636 End of process_mass_data()
4305:20120307:103837.636 End of process_hist_data():SUCCEED
4305:20120307:103837.636 In zbx_send_response()
4305:20120307:103837.636 zbx_send_response() '

{ "response":"success", "info":"Processed 1 Failed 0 Total 1 Seconds spent 0.000174"}

'
4305:20120307:103837.636 End of zbx_send_response():SUCCEED
4305:20120307:103837.636 End of recv_agenthistory()

.....................

ITEMS UPDATE LOG
update items set lastclock=1331113117,lastns=636212241,lastlogsize=0,mtime=0,prevvalue=lastvalue,lastvalue='Mar 7 10:38:37 sapzas03 RYGU7300: [ID 702911 local0.notice] TEST ZABBIX' where itemid=37338;
]
4350:20120307:103838.153 End of DCmass_update_items()

.......................

HISTORY_LOG INSERT LOG
insert into history_log (id,itemid,clock,timestamp,source,severity,value,logeventid,ns) values (556381,37338,1331113117,0,'',0,'Mar 7 10:38:37 sapzas03 RYGU7300: [ID 702911 local0.notice] TEST ZABBIX',0,636212241);
]
4350:20120307:103838.155 End of DCmass_add_history()

...........................

ITEMS TABLE DOES NOT CONTAIN THE UPDATE
zabbix=> select lastclock,lastvalue from items where itemid=37338;
lastclock | lastvalue

1331111445 | Mar 7 10:10:45 sapzas03 su: [ID 366847 auth.info] 'su wldeploy' s
ucceeded for ZGKD7217 on /dev/pts/17
(1 row)

............................

HISTORY_LOG DOES NOT CONTAIN THE INSERTED RECORD
zabbix=> select clock,value from history_log where itemid=37338;
clock | value
...
1331111312 | Mar 7 10:08:32 sapzas03 sshd[17906]: [ID 548632 auth.error] warni
ng: /etc/hosts.allow, line 13: can't verify hostname: gethostbyname(mgzfw04.msap
zstg.mgt.w-ha.net) failed
1331111389 | Mar 7 10:09:49 sapzas03 sshd[17915]: [ID 800047 auth.info] Accept
ed password for ZGKD7217 from 192.168.125.1 port 30780 ssh2
1331111445 | Mar 7 10:10:45 sapzas03 su: [ID 366847 auth.info] 'su wldeploy' s
ucceeded for ZGKD7217 on /dev/pts/17
1331113438 | Mar 7 10:43:58 sapzas03 sshd[21639]: [ID 548632 auth.error] warni
ng: /etc/hosts.allow, line 13: can't verify hostname: gethostbyname(mgzfw04.msap
zstg.mgt.w-ha.net) failed
(14 rows)

..............................

UPDATE AND INSERT ARE SUCCESSFULL IF DONE MANUALLY
zabbix=> update items set lastclock=1331113117,lastns=636212241,lastlogsize=0,mtime=0,prevvalue=lastvalue,lastvalue='Mar 7 10:38:37 sapzas03 RYGU7300: [ID 702911 local0.notice] TEST ZABBIX' where itemid=37338;
UPDATE 1
zabbix=> insert into history_log (id,itemid,clock,timestamp,source,severity,value,logeventid,ns) values (556381,37338,1331113117,0,'',0,'Mar 7 10:38:37 sapzas03 RYGU7300: [ID 702911 local0.notice] TEST ZABBIX',0,636212241);
INSERT 39029367 1