36951:20101212:130319.023 In DBlld_update_trigger() jp_row:'{"{#SNMPINDEX}":3,"{#SNMPVALUE}":"SSKD Real"}' 36951:20101212:130319.024 In substitute_discovery_macros() data:'BIG trafic Port IN №{#SNMPINDEX} {#SNMPVALUE}' 36951:20101212:130319.024 End of substitute_discovery_macros() data:'BIG trafic Port IN №3 SSKD Real' 36951:20101212:130319.024 Query [txnlev:1] [select distinct t.triggerid,t.expression from triggers t,trigger_discovery td where t.triggerid=td.triggerid and td.parent_triggerid=179098 and t.description='BIG trafic Port IN №3 SSKD Real'] 36951:20101212:130319.024 Query [txnlev:1] [select distinct t.triggerid,td.name,t.description from triggers t,trigger_discovery td where t.triggerid=td.triggerid and td.parent_triggerid=179098] 36951:20101212:130319.024 In substitute_discovery_macros() data:'BIG trafic Port IN №{#SNMPINDEX} {#SNMPVALUE}' 36951:20101212:130319.024 End of substitute_discovery_macros() data:'BIG trafic Port IN №3 SSKD Real' 36951:20101212:130319.024 In substitute_discovery_macros() data:'BIG trafic Port IN №{#SNMPINDEX} {#SNMPVALUE}' 36951:20101212:130319.024 End of substitute_discovery_macros() data:'BIG trafic Port IN №3 SSKD Real' 36951:20101212:130319.024 Query [txnlev:1] [select distinct t.triggerid,t.expression from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and i.hostid=10054 and t.description='BIG trafic Port IN №3 SSKD Real'] 36951:20101212:130319.024 In DBget_nextid() tablename:'triggers' 36951:20101212:130319.024 Query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='triggers' and field_name='triggerid'] 36951:20101212:130319.025 Query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='triggers' and field_name='triggerid'] 36951:20101212:130319.025 Query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='triggers' and field_name='triggerid'] 36951:20101212:130319.025 End of DBget_nextid() "triggers"."triggerid":179101 36951:20101212:130319.025 In DCget_nextid() table:'trigger_discovery' num:1 36951:20101212:130319.025 End of DCget_nextid() table:'trigger_discovery' [165389:165389] 36951:20101212:130319.025 Query [txnlev:1] [select f.itemid,f.functionid,f.function,f.parameter,i.key_,i.flags from functions f,items i where f.itemid=i.itemid and f.triggerid=179098] 36951:20101212:130319.025 In DBlld_get_item() 36951:20101212:130319.025 In substitute_discovery_macros() data:'ifInOctets[{#SNMPVALUE}]' 36951:20101212:130319.025 End of substitute_discovery_macros() data:'ifInOctets[SSKD Real]' 36951:20101212:130319.025 Query [txnlev:1] [select itemid from items where hostid=10054 and key_='ifInOctets[SSKD Real]'] 36951:20101212:130319.025 End of DBlld_get_item():SUCCEED 36951:20101212:130319.025 In DBget_nextid() tablename:'functions' 36951:20101212:130319.025 Query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='functions' and field_name='functionid'] 36951:20101212:130319.025 Query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='functions' and field_name='functionid'] 36951:20101212:130319.026 Query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='functions' and field_name='functionid'] 36951:20101212:130319.026 End of DBget_nextid() "functions"."functionid":13633 36951:20101212:130319.026 Query [txnlev:1] [insert into triggers (triggerid,description,priority,status,comments,url,type,value,value_flags,flags,error) values (179101,'BIG trafic Port IN №3 SSKD Real',4,0,'','',1,0,1,4,'Trigger just added. No status update so far.'); insert into trigger_discovery (triggerdiscoveryid,triggerid,parent_triggerid,name) values (165389,179101,179098,'BIG trafic Port IN №{#SNMPINDEX} {#SNMPVALUE}'); insert into functions (functionid,itemid,triggerid,function,parameter) values (13633,24890,179101,'last','0'); update triggers set expression='{13633}>10000' where triggerid=179101; ] 36951:20101212:130319.026 End of DBlld_update_trigger():SUCCEED 36951:20101212:130319.026 In DBlld_update_trigger() jp_row:'{"{#SNMPINDEX}":4,"{#SNMPVALUE}":"MON"}' 36951:20101212:130319.026 In substitute_discovery_macros() data:'BIG trafic Port IN №{#SNMPINDEX} {#SNMPVALUE}' 36951:20101212:130319.026 End of substitute_discovery_macros() data:'BIG trafic Port IN №4 MON' 36951:20101212:130319.026 Query [txnlev:1] [select distinct t.triggerid,t.expression from triggers t,trigger_discovery td where t.triggerid=td.triggerid and td.parent_triggerid=179098 and t.description='BIG trafic Port IN №4 MON'] 36951:20101212:130319.027 Query [txnlev:1] [select distinct t.triggerid,td.name,t.description from triggers t,trigger_discovery td where t.triggerid=td.triggerid and td.parent_triggerid=179098] 36951:20101212:130319.027 In substitute_discovery_macros() data:'BIG trafic Port IN №{#SNMPINDEX} {#SNMPVALUE}' 36951:20101212:130319.027 End of substitute_discovery_macros() data:'BIG trafic Port IN №4 MON' 36951:20101212:130319.027 In substitute_discovery_macros() data:'BIG trafic Port IN №{#SNMPINDEX} {#SNMPVALUE}' 36951:20101212:130319.027 End of substitute_discovery_macros() data:'BIG trafic Port IN №4 MON' 36951:20101212:130319.027 In substitute_discovery_macros() data:'BIG trafic Port IN №{#SNMPINDEX} {#SNMPVALUE}' 36951:20101212:130319.027 End of substitute_discovery_macros() data:'BIG trafic Port IN №4 MON' 36951:20101212:130319.027 Query [txnlev:1] [select distinct t.triggerid,t.expression from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and i.hostid=10054 and t.description='BIG trafic Port IN №4 MON'] 36951:20101212:130319.027 In DBget_nextid() tablename:'triggers' 36951:20101212:130319.027 Query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='triggers' and field_name='triggerid'] 36951:20101212:130319.027 Query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='triggers' and field_name='triggerid'] 36951:20101212:130319.027 Query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='triggers' and field_name='triggerid'] 36951:20101212:130319.027 End of DBget_nextid() "triggers"."triggerid":179102 36951:20101212:130319.027 In DCget_nextid() table:'trigger_discovery' num:1 36951:20101212:130319.027 End of DCget_nextid() table:'trigger_discovery' [165390:165390] 36951:20101212:130319.027 Query [txnlev:1] [select f.itemid,f.functionid,f.function,f.parameter,i.key_,i.flags from functions f,items i where f.itemid=i.itemid and f.triggerid=179098] 36951:20101212:130319.027 In DBlld_get_item() 36951:20101212:130319.027 In substitute_discovery_macros() data:'ifInOctets[{#SNMPVALUE}]' 36951:20101212:130319.027 End of substitute_discovery_macros() data:'ifInOctets[MON]' 36951:20101212:130319.027 Query [txnlev:1] [select itemid from items where hostid=10054 and key_='ifInOctets[MON]'] 36951:20101212:130319.027 DBlld_get_item() Can't find item [(null)] on the host 36951:20101212:130319.027 End of DBlld_get_item():FAIL 36951:20101212:130319.027 End of DBlld_update_trigger():FAIL