-
Incident report
-
Resolution: Fixed
-
Blocker
-
1.9.3 (alpha)
-
None
(1)
20480:20110329:084429.030 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: insert or update on table "items" violates foreign key constraint "c_items_4"
DETAIL: Key (interfaceid)=(10021) is not present in table "interface".
[insert into items (itemid,type,snmp_community,snmp_oid,hostid,key_,delay,status,value_type,trapper_hosts,units,multiplier,delta,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,formula,logtimefmt,delay_flex,params,ipmi_sensor,data_type,authtype,username,password,publickey,privatekey,flags,filter,interfaceid,port) values (22377,0,'','',10047,'agent.ping',30,0,3,'','',0,0,'',0,'','','1','','','','',0,0,'','','','',0,'',10021,'');
]
(2)
20480:20110329:085258.739 Invalid number of fields "[22190,16,"","",10047,"jmx[\"
\", \"
{#JMXATTR}\"]",30,0,1,"","",0,0,"",0,"","","1","","","","",0,0,"{$JMX_USERNAME}","{$JMX_PASSWORD}","","",2,"",null,""]"