-
Incident report
-
Resolution: Fixed
-
Blocker
-
1.8.1
-
None
-
Zabbix_server - linux/zabbix_server 1.8.1/mysql
Zabbix proxy/child node - linux/1.8.1/oracle
When i up zabbix proxy or child node with oracle backend, it get configuration from main server and get values from agent, but do not stores it in table proxy_history. In log of zabbix_proxy i see queries look like:
insert into proxy_history (itemid,clock,value) values (23473,1265894823,'0.101368');
insert into proxy_history (itemid,clock,value) values (23443,1265894823,'391331046.000000');
insert into proxy_history (itemid,clock,value) values (23474,1265894824,'0.000000');
insert into proxy_history (itemid,clock,value) values (23469,1265894824,'0.000000');
insert into proxy_history (itemid,clock,value) values (23444,1265894824,'1413573977.000000');
insert into proxy_history (itemid,clock,value) values (23475,1265894825,'0.000000');
insert into proxy_history (itemid,clock,value) values (23445,1265894825,'0.000000');
insert into proxy_history (itemid,clock,value) values (23526,1265894826,'74.004794');
insert into proxy_history (itemid,clock,value) values (23446,1265894826,'391331046.000000');
But this queries don't execute without error because field ID in table proxy_history is not null, but in this queries it has been ommited.
Oracle error:
ERROR: ORA-01400: cannot insert NULL into ("ZABBIX"."PROXY_HISTORY"."ID")
Query
= insert into proxy_history (itemid,clock,value)
values (23446,1265894826,'391331046.000000')