15557:20111208:010525.882 In DBlld_remove_lost_resources() lifetime:1 15557:20111208:010525.882 query [txnlev:1] [select id2.itemid from item_discovery id1,item_discovery id2 where id1.itemid=id2.parent_itemid and id1.parent_itemid=25883 and id2.lastcheck<1323212725] 15557:20111208:010525.883 In DBdelete_items() values_num:1 15557:20111208:010525.883 query [txnlev:1] [select itemid from item_discovery where parent_itemid in (25924)] 15557:20111208:010525.883 In DBdelete_graphs_by_itemids() values_num:1 15557:20111208:010525.883 query [txnlev:1] [select distinct graphid from graphs_items where itemid in (25924)] 15557:20111208:010525.883 query [txnlev:1] [select distinct graphid from graphs_items where graphid in (899) and not itemid in (25924)] 15557:20111208:010525.884 In DBdelete_graphs() values_num:1 15557:20111208:010525.884 query [txnlev:1] [select graphid from graph_discovery where parent_graphid in (899)] 15557:20111208:010525.884 query [txnlev:1] [delete from screens_items where resourcetype=0 and resourceid in (899); delete from profiles where idx='web.favorite.graphids' and source='graphid' and value_id in (899); delete from graphs where graphid in (899); ] 15557:20111208:010525.885 End of DBdelete_graphs() 15557:20111208:010525.885 End of DBdelete_graphs_by_itemids() 15557:20111208:010525.886 In DBdelete_triggers_by_itemids() values_num:1 15557:20111208:010525.886 query [txnlev:1] [select distinct triggerid from functions where itemid in (25924)] 15557:20111208:010525.886 query [txnlev:1] [select triggerid from trigger_discovery where parent_triggerid in (220437)] 15557:20111208:010525.886 query [txnlev:1] [delete from services where triggerid in (220437)] 15557:20111208:010525.886 query [txnlev:1] [select s.serviceid from services s,services_links sl where s.serviceid=sl.serviceupid and s.triggerid is not null group by s.serviceid] 15557:20111208:010525.888 query [txnlev:1] [select serviceid,algorithm,triggerid from services where serviceid not in (select distinct serviceupid from services_links)] 15557:20111208:010525.888 query [txnlev:1] [select priority from triggers where triggerid=220341 and status=0 and value=1] 15557:20111208:010525.888 query [txnlev:1] [select s.status from services s,services_links l where l.serviceupid=2 and s.serviceid=l.servicedownid order by s.status asc limit 1] 15557:20111208:010525.889 query [txnlev:1] [update services set status=0 where serviceid=2] 15557:20111208:010525.889 In DBadd_service_alarm() 15557:20111208:010525.889 In latest_service_alarm(): serviceid [2] status [0] 15557:20111208:010525.889 query [txnlev:1] [select servicealarmid,value from service_alarms where serviceid=2 order by servicealarmid desc limit 1] 15557:20111208:010525.889 End of latest_service_alarm():SUCCEED 15557:20111208:010525.890 End of DBadd_service_alarm() 15557:20111208:010525.890 query [txnlev:1] [select priority from triggers where triggerid=220246 and status=0 and value=1] 15557:20111208:010525.890 query [txnlev:1] [select s.status from services s,services_links l where l.serviceupid=3 and s.serviceid=l.servicedownid order by s.status desc limit 1] 15557:20111208:010525.890 query [txnlev:1] [update services set status=0 where serviceid=3] 15557:20111208:010525.890 In DBadd_service_alarm() 15557:20111208:010525.890 In latest_service_alarm(): serviceid [3] status [0] 15557:20111208:010525.890 query [txnlev:1] [select servicealarmid,value from service_alarms where serviceid=3 order by servicealarmid desc limit 1] 15557:20111208:010525.891 End of latest_service_alarm():SUCCEED 15557:20111208:010525.891 End of DBadd_service_alarm() 15557:20111208:010525.891 query [txnlev:1] [select max(servicedownid),serviceupid from services_links where servicedownid not in (select distinct serviceupid from services_links) group by serviceupid] 15557:20111208:010525.891 query [txnlev:1] [select l.serviceupid,s.algorithm from services_links l,services s where s.serviceid=l.serviceupid and l.servicedownid=2] 15557:20111208:010525.892 query [txnlev:1] [select s.status from services s,services_links l where l.serviceupid=1 and s.serviceid=l.servicedownid order by s.status desc limit 1] 15557:20111208:010525.892 In DBadd_service_alarm() 15557:20111208:010525.892 In latest_service_alarm(): serviceid [1] status [0] 15557:20111208:010525.892 query [txnlev:1] [select servicealarmid,value from service_alarms where serviceid=1 order by servicealarmid desc limit 1] 15557:20111208:010525.893 End of latest_service_alarm():SUCCEED 15557:20111208:010525.893 End of DBadd_service_alarm() 15557:20111208:010525.893 query [txnlev:1] [update services set status=0 where serviceid=1] 15557:20111208:010525.893 query [txnlev:1] [select serviceupid from services_links where servicedownid=2] 15557:20111208:010525.893 query [txnlev:1] [select l.serviceupid,s.algorithm from services_links l,services s where s.serviceid=l.serviceupid and l.servicedownid=1] 15557:20111208:010525.894 query [txnlev:1] [select serviceupid from services_links where servicedownid=1] 15557:20111208:010525.894 query [txnlev:1] [delete from sysmaps_elements where elementtype=2 and elementid in (220437)] 15557:20111208:010525.894 query [txnlev:1] [select distinct actionid from conditions where conditiontype=2 and value='220437'] 15557:20111208:010525.895 query [txnlev:1] [delete from conditions where conditiontype=2 and value='220437'] 15557:20111208:010525.895 query [txnlev:1] [delete from events where source=0 and object=0 and objectid in (220437); delete from triggers where triggerid in (220437); ] 15557:20111208:010525.896 End of DBdelete_triggers_by_itemids() 15557:20111208:010525.896 In DBdelete_history_by_itemids() values_num:1 15557:20111208:010525.896 In DBget_nextid() tablename:'housekeeper' 15557:20111208:010525.896 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='housekeeper' and field_name='housekeeperid'] 15557:20111208:010525.896 query [txnlev:1] [update ids set nextid=nextid+7 where nodeid=0 and table_name='housekeeper' and field_name='housekeeperid'] 15557:20111208:010525.896 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='housekeeper' and field_name='housekeeperid'] 15557:20111208:010525.896 End of DBget_nextid():19980 table:'housekeeper' recid:'housekeeperid' 15557:20111208:010525.896 query [txnlev:1] [insert into housekeeper (housekeeperid,tablename,field,value) values (19980,'history','itemid',25924),(19981,'history_str','itemid',25924),(19982,'history_uint','itemid',25924),(19983,'history_log','itemid',25924),(19984,'history_text','itemid',25924),(19985,'trends','itemid',25924),(19986,'trends_uint','itemid',25924); ] 15557:20111208:010525.897 End of DBdelete_history_by_itemids() 15557:20111208:010525.897 query [txnlev:1] [delete from screens_items where resourcetype in (3,1) and resourceid in (25924); delete from profiles where idx='web.favorite.graphids' and source='itemid' and value_id in (25924); delete from items where itemid in (25924); ] 15557:20111208:010525.898 End of DBdelete_items() 15557:20111208:010525.898 End of DBlld_remove_lost_resources() 15557:20111208:010525.898 query [txnlev:1] [commit;] 15557:20111208:010525.923 End of DBlld_process_discovery_rule() 15557:20111208:010525.923 In calculate_item_nextcheck() interfaceid:30163 itemid:25883 delay:60 flex_intervals:'' now:1323299125 15557:20111208:010525.923 End of calculate_item_nextcheck() nextcheck:1323299183 delay:60 15557:20111208:010525.923 End of get_values():1 15557:20111208:010525.923 poller #1 spent 2.178640 seconds while updating 1 values 15557:20111208:010525.923 In DCconfig_get_poller_nextcheck() poller_type:0 15557:20111208:010525.923 End of DCconfig_get_poller_nextcheck():1323299126 15557:20111208:010525.923 sleeping for 1 seconds