36951:20101212:130319.158 In DBlld_update_graph() jp_row:'{"{#SNMPINDEX}":3,"{#SNMPVALUE}":"SSKD Real"}' 36951:20101212:130319.158 In substitute_discovery_macros() data:'Port Trafic №{#SNMPINDEX} {#SNMPVALUE}' 36951:20101212:130319.158 End of substitute_discovery_macros() data:'Port Trafic №3 SSKD Real' 36951:20101212:130319.158 Query [txnlev:1] [select distinct g.graphid from graphs g,graph_discovery gd where g.graphid=gd.graphid and gd.parent_graphid=782 and g.name='Port Trafic №3 SSKD Real'] 36951:20101212:130319.158 Query [txnlev:1] [select distinct g.graphid,gd.name,g.name from graphs g,graph_discovery gd where g.graphid=gd.graphid and gd.parent_graphid=782] 36951:20101212:130319.158 In substitute_discovery_macros() data:'Port Trafic №{#SNMPINDEX} {#SNMPVALUE}' 36951:20101212:130319.158 End of substitute_discovery_macros() data:'Port Trafic №3 SSKD Real' 36951:20101212:130319.158 In substitute_discovery_macros() data:'Port Trafic №{#SNMPINDEX} {#SNMPVALUE}' 36951:20101212:130319.158 End of substitute_discovery_macros() data:'Port Trafic №3 SSKD Real' 36951:20101212:130319.158 Query [txnlev:1] [select distinct g.graphid from graphs g,graphs_items gi,items i where g.graphid=gi.graphid and gi.itemid=i.itemid and i.hostid=10054 and g.name='Port Trafic №3 SSKD Real'] 36951:20101212:130319.158 In DBget_graphitems() 36951:20101212:130319.158 Query [txnlev:1] [select 0,i.itemid,i.key_,gi.drawtype,gi.sortorder,gi.color,gi.yaxisside,gi.calc_fnc,gi.type,gi.periods_cnt,i.flags from graphs_items gi,items i where gi.itemid=i.itemid and gi.graphid=782] 36951:20101212:130319.158 DBget_graphitems() [0] itemid:24885 key:'ifInOctets[{#SNMPVALUE}]' 36951:20101212:130319.158 DBget_graphitems() [1] itemid:24886 key:'ifOutOctets[{#SNMPVALUE}]' 36951:20101212:130319.158 End of DBget_graphitems() 36951:20101212:130319.158 In DBlld_get_item() 36951:20101212:130319.158 In substitute_discovery_macros() data:'ifInOctets[{#SNMPVALUE}]' 36951:20101212:130319.158 End of substitute_discovery_macros() data:'ifInOctets[SSKD Real]' 36951:20101212:130319.158 Query [txnlev:1] [select itemid from items where hostid=10054 and key_='ifInOctets[SSKD Real]'] 36951:20101212:130319.160 End of DBlld_get_item():SUCCEED 36951:20101212:130319.160 In DBlld_get_item() 36951:20101212:130319.160 In substitute_discovery_macros() data:'ifOutOctets[{#SNMPVALUE}]' 36951:20101212:130319.160 End of substitute_discovery_macros() data:'ifOutOctets[SSKD Real]' 36951:20101212:130319.160 Query [txnlev:1] [select itemid from items where hostid=10054 and key_='ifOutOctets[SSKD Real]'] 36951:20101212:130319.161 End of DBlld_get_item():SUCCEED 36951:20101212:130319.161 In DBget_nextid() tablename:'graphs' 36951:20101212:130319.161 Query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='graphs' and field_name='graphid'] 36951:20101212:130319.161 Query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='graphs' and field_name='graphid'] 36951:20101212:130319.161 Query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='graphs' and field_name='graphid'] 36951:20101212:130319.161 End of DBget_nextid() "graphs"."graphid":785 36951:20101212:130319.161 In DCget_nextid() table:'graph_discovery' num:1 36951:20101212:130319.161 End of DCget_nextid() table:'graph_discovery' [132:132] 36951:20101212:130319.161 In DBget_nextid() tablename:'graphs_items' 36951:20101212:130319.161 Query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='graphs_items' and field_name='gitemid'] 36951:20101212:130319.161 Query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='graphs_items' and field_name='gitemid'] 36951:20101212:130319.161 Query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='graphs_items' and field_name='gitemid'] 36951:20101212:130319.161 End of DBget_nextid() "graphs_items"."gitemid":2063 36951:20101212:130319.161 In DBget_nextid() tablename:'graphs_items' 36951:20101212:130319.161 Query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='graphs_items' and field_name='gitemid'] 36951:20101212:130319.161 Query [txnlev:1] [update ids set nextid=nextid+1 where nodeid=0 and table_name='graphs_items' and field_name='gitemid'] 36951:20101212:130319.161 Query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='graphs_items' and field_name='gitemid'] 36951:20101212:130319.161 End of DBget_nextid() "graphs_items"."gitemid":2064 36951:20101212:130319.161 Query [txnlev:1] [insert into graphs (graphid,name,width,height,yaxismin,yaxismax,show_work_period,show_triggers,graphtype,show_legend,show_3d,percent_left,percent_right,ymin_type,ymax_type,ymin_itemid,ymax_itemid,flags) values (785,'Port Trafic №3 SSKD Real',900,200,0.000000,100.000000,0,0,0,1,0,0.000000,0.000000,0,0,null,null,4); insert into graph_discovery (graphdiscoveryid,graphid,parent_graphid,name) values (132,785,782,'Port Trafic №{#SNMPINDEX} {#SNMPVALUE}'); insert into graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type,periods_cnt) values (2063,785,24890,0,0,'770077',0,2,0,5); insert into graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type,periods_cnt) values (2064,785,24893,0,1,'009900',0,2,0,5); ] 36951:20101212:130319.162 End of DBlld_update_graph():SUCCEED 36951:20101212:130319.162 In DBlld_update_graph() jp_row:'{"{#SNMPINDEX}":4,"{#SNMPVALUE}":"MON"}' 36951:20101212:130319.162 In substitute_discovery_macros() data:'Port Trafic №{#SNMPINDEX} {#SNMPVALUE}' 36951:20101212:130319.162 End of substitute_discovery_macros() data:'Port Trafic №4 MON' 36951:20101212:130319.162 Query [txnlev:1] [select distinct g.graphid from graphs g,graph_discovery gd where g.graphid=gd.graphid and gd.parent_graphid=782 and g.name='Port Trafic №4 MON'] 36951:20101212:130319.162 Query [txnlev:1] [select distinct g.graphid,gd.name,g.name from graphs g,graph_discovery gd where g.graphid=gd.graphid and gd.parent_graphid=782] 36951:20101212:130319.162 In substitute_discovery_macros() data:'Port Trafic №{#SNMPINDEX} {#SNMPVALUE}' 36951:20101212:130319.162 End of substitute_discovery_macros() data:'Port Trafic №4 MON' 36951:20101212:130319.162 In substitute_discovery_macros() data:'Port Trafic №{#SNMPINDEX} {#SNMPVALUE}' 36951:20101212:130319.162 End of substitute_discovery_macros() data:'Port Trafic №4 MON' 36951:20101212:130319.162 In substitute_discovery_macros() data:'Port Trafic №{#SNMPINDEX} {#SNMPVALUE}' 36951:20101212:130319.162 End of substitute_discovery_macros() data:'Port Trafic №4 MON' 36951:20101212:130319.162 Query [txnlev:1] [select distinct g.graphid from graphs g,graphs_items gi,items i where g.graphid=gi.graphid and gi.itemid=i.itemid and i.hostid=10054 and g.name='Port Trafic №4 MON'] 36951:20101212:130319.162 In DBget_graphitems() 36951:20101212:130319.162 Query [txnlev:1] [select 0,i.itemid,i.key_,gi.drawtype,gi.sortorder,gi.color,gi.yaxisside,gi.calc_fnc,gi.type,gi.periods_cnt,i.flags from graphs_items gi,items i where gi.itemid=i.itemid and gi.graphid=782] 36951:20101212:130319.162 DBget_graphitems() [0] itemid:24885 key:'ifInOctets[{#SNMPVALUE}]' 36951:20101212:130319.162 DBget_graphitems() [1] itemid:24886 key:'ifOutOctets[{#SNMPVALUE}]' 36951:20101212:130319.162 End of DBget_graphitems() 36951:20101212:130319.163 In DBlld_get_item() 36951:20101212:130319.163 In substitute_discovery_macros() data:'ifInOctets[{#SNMPVALUE}]' 36951:20101212:130319.163 End of substitute_discovery_macros() data:'ifInOctets[MON]' 36951:20101212:130319.163 Query [txnlev:1] [select itemid from items where hostid=10054 and key_='ifInOctets[MON]'] 36951:20101212:130319.163 DBlld_get_item() Can't find item [(null)] on the host 36951:20101212:130319.163 End of DBlld_get_item():FAIL 36951:20101212:130319.163 End of DBlld_update_graph():FAIL