Details
-
Type:
Incident report
-
Status: Closed
-
Priority:
Blocker
-
Resolution: Fixed
-
Affects Version/s: 1.8.1
-
Fix Version/s: 1.8.2
-
Component/s: Proxy (P), Server (S)
-
Labels:None
-
Environment:Zabbix_server - linux/zabbix_server 1.8.1/mysql
Zabbix proxy/child node - linux/1.8.1/oracle
Description
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')