23069:20120620:143007.780 Starting Zabbix Server. Zabbix 2.1.0 (revision 28316). 23069:20120620:143007.780 ****** Enabled features ****** 23069:20120620:143007.780 SNMP monitoring: YES 23069:20120620:143007.780 IPMI monitoring: YES 23069:20120620:143007.780 WEB monitoring: YES 23069:20120620:143007.780 Jabber notifications: YES 23069:20120620:143007.780 Ez Texting notifications: YES 23069:20120620:143007.780 ODBC: YES 23069:20120620:143007.780 SSH2 support: YES 23069:20120620:143007.780 IPv6 support: YES 23069:20120620:143007.780 ****************************** ... 23079:20120620:143054.341 In get_values() 23079:20120620:143054.341 In DCconfig_get_poller_items() poller_type:0 23079:20120620:143054.341 End of DCconfig_get_poller_items():1 23079:20120620:143054.341 In substitute_key_macros() data:'vfs.fs.discovery' 23079:20120620:143054.341 End of substitute_key_macros():SUCCEED data:'vfs.fs.discovery' 23079:20120620:143054.341 In substitute_simple_macros() data:'10050' 23079:20120620:143054.341 In get_value() key:'vfs.fs.discovery' 23079:20120620:143054.341 In get_value_agent() host:'it3' addr:'10.20.0.12' key:'vfs.fs.discovery' 23079:20120620:143054.342 Sending [vfs.fs.discovery ] 23079:20120620:143054.349 get value from agent result: '{ "data":[ { "{#FSNAME}":"C:\\", "{#FSTYPE}":"NTFS"}, { "{#FSNAME}":"D:\\", "{#FSTYPE}":"NTFS"}, { "{#FSNAME}":"E:\\", "{#FSTYPE}":"UNKNOWN"}]}' 23079:20120620:143054.349 End of get_value():SUCCEED 23079:20120620:143054.349 In activate_host() hostid:10197 itemid:26694 type:0 23079:20120620:143054.349 In DBlld_process_discovery_rule() itemid:26694 23079:20120620:143054.349 query [txnlev:0] [select hostid,key_,status,filter,error,lifetime from items where itemid=26694] 23079:20120620:143054.350 In substitute_simple_macros() data:'30' 23079:20120620:143054.350 query [txnlev:1] [begin;] 23079:20120620:143054.350 query [txnlev:1] [select r.name,e.expression,e.expression_type,e.exp_delimiter,e.case_sensitive from regexps r,expressions e where r.regexpid=e.regexpid and r.name='File systems for discovery'] 23079:20120620:143054.350 DBlld_process_discovery_rule() f_macro:'{#FSTYPE}' f_regexp:'@File systems for discovery' 23079:20120620:143054.350 In DBlld_update_items() 23079:20120620:143054.350 query [txnlev:1] [select i.itemid,i.name,i.key_,i.type,i.value_type,i.data_type,i.delay,i.delay_flex,i.history,i.trends,i.status,i.trapper_hosts,i.units,i.multiplier,i.delta,i.formula,i.logtimefmt,i.valuemapid,i.params,i.ipmi_sensor,i.snmp_community,i.snmp_oid,i.port,i.snmpv3_securityname,i.snmpv3_securitylevel,i.snmpv3_authpassphrase,i.snmpv3_privpassphrase,i.authtype,i.username,i.password,i.publickey,i.privatekey,i.description,i.interfaceid from items i,item_discovery id where i.itemid=id.itemid and id.parent_itemid=26694] 23079:20120620:143054.351 In DBlld_check_record() jp_row:'{"{#FSNAME}":"C:\\","{#FSTYPE}":"NTFS"}' 23079:20120620:143054.351 End of DBlld_check_record():SUCCEED 23079:20120620:143054.351 In DBlld_make_item() 23079:20120620:143054.351 In substitute_key_macros() data:'vfs.fs.size[{#FSNAME},pfree]' 23079:20120620:143054.351 In substitute_discovery_macros() data:'{#FSNAME}' 23079:20120620:143054.351 End of substitute_discovery_macros() data:'C:\' 23079:20120620:143054.351 End of substitute_key_macros():SUCCEED data:'vfs.fs.size[C:\,pfree]' 23079:20120620:143054.351 query [txnlev:1] [select distinct i.itemid from items i,item_discovery id where i.itemid=id.itemid and id.parent_itemid=26695 and i.key_='vfs.fs.size[C:\\,pfree]'] 23079:20120620:143054.352 query [txnlev:1] [select itemid from items where hostid=10197 and key_='vfs.fs.size[C:\\,pfree]' and itemid<>26700] 23079:20120620:143054.352 In substitute_discovery_macros() data:'Free disk space on $1 (percentage)' 23079:20120620:143054.352 End of substitute_discovery_macros() data:'Free disk space on $1 (percentage)' 23079:20120620:143054.352 In substitute_key_macros() data:'' 23079:20120620:143054.352 End of substitute_key_macros():FAIL data:'' 23079:20120620:143054.352 query [txnlev:1] [select applicationid from items_applications where itemid=26695] 23079:20120620:143054.353 query [txnlev:1] [select applicationid from items_applications where itemid=26700] 23079:20120620:143054.353 End of DBlld_make_item():SUCCEED 23079:20120620:143054.353 In DBlld_check_record() jp_row:'{"{#FSNAME}":"D:\\","{#FSTYPE}":"NTFS"}' 23079:20120620:143054.353 End of DBlld_check_record():SUCCEED 23079:20120620:143054.353 In DBlld_make_item() 23079:20120620:143054.353 In substitute_key_macros() data:'vfs.fs.size[{#FSNAME},pfree]' 23079:20120620:143054.353 In substitute_discovery_macros() data:'{#FSNAME}' 23079:20120620:143054.353 End of substitute_discovery_macros() data:'D:\' 23079:20120620:143054.353 End of substitute_key_macros():SUCCEED data:'vfs.fs.size[D:\,pfree]' 23079:20120620:143054.353 query [txnlev:1] [select distinct i.itemid from items i,item_discovery id where i.itemid=id.itemid and id.parent_itemid=26695 and i.key_='vfs.fs.size[D:\\,pfree]'] 23079:20120620:143054.354 query [txnlev:1] [select itemid from items where hostid=10197 and key_='vfs.fs.size[D:\\,pfree]' and itemid<>26701] 23079:20120620:143054.354 In substitute_discovery_macros() data:'Free disk space on $1 (percentage)' 23079:20120620:143054.354 End of substitute_discovery_macros() data:'Free disk space on $1 (percentage)' 23079:20120620:143054.354 In substitute_key_macros() data:'' 23079:20120620:143054.354 End of substitute_key_macros():FAIL data:'' 23079:20120620:143054.354 query [txnlev:1] [select applicationid from items_applications where itemid=26695] 23079:20120620:143054.354 query [txnlev:1] [select applicationid from items_applications where itemid=26701] 23079:20120620:143054.354 End of DBlld_make_item():SUCCEED 23079:20120620:143054.355 In DBlld_check_record() jp_row:'{"{#FSNAME}":"E:\\","{#FSTYPE}":"UNKNOWN"}' 23079:20120620:143054.355 End of DBlld_check_record():FAIL 23079:20120620:143054.355 query [txnlev:1] [update items set name='Free disk space on $1 (percentage)',key_='vfs.fs.size[C:\\,pfree]',type=0,value_type=0,data_type=0,delay=600,delay_flex='',history=7,trends=365,trapper_hosts='',units='%',multiplier=0,delta=0,formula='1',logtimefmt='',valuemapid=null,params='',ipmi_sensor='',snmp_community='',snmp_oid='',port='',snmpv3_securityname='',snmpv3_securitylevel=0,snmpv3_authpassphrase='',snmpv3_privpassphrase='',authtype=0,username='',password='',publickey='',privatekey='',description='',interfaceid=30356,flags=4 where itemid=26700; update item_discovery set key_='vfs.fs.size[{#FSNAME},pfree]',lastcheck=1340191854,ts_delete=0 where itemid=26700 and parent_itemid=26695; update items set name='Free disk space on $1 (percentage)',key_='vfs.fs.size[D:\\,pfree]',type=0,value_type=0,data_type=0,delay=600,delay_flex='',history=7,trends=365,trapper_hosts='',units='%',multiplier=0,delta=0,formula='1',logtimefmt='',valuemapid=null,params='',ipmi_sensor='',snmp_community='',snmp_oid='',port='',snmpv3_securityname='',snmpv3_securitylevel=0,snmpv3_authpassphrase='',snmpv3_privpassphrase='',authtype=0,username='',password='',publickey='',privatekey='',description='',interfaceid=30356,flags=4 where itemid=26701; update item_discovery set key_='vfs.fs.size[{#FSNAME},pfree]',lastcheck=1340191854,ts_delete=0 where itemid=26701 and parent_itemid=26695; ] 23079:20120620:143054.356 End of DBlld_update_items() 23079:20120620:143054.356 In DBlld_update_triggers() 23079:20120620:143054.356 query [txnlev:1] [select distinct t.triggerid,t.description,t.expression,t.status,t.type,t.priority,t.comments,t.url from triggers t,functions f,items i,item_discovery id where t.triggerid=f.triggerid and f.itemid=i.itemid and i.itemid=id.itemid and id.parent_itemid=26694] 23079:20120620:143054.357 In DBlld_check_record() jp_row:'{"{#FSNAME}":"C:\\","{#FSTYPE}":"NTFS"}' 23079:20120620:143054.357 End of DBlld_check_record():SUCCEED 23079:20120620:143054.357 In DBlld_make_trigger() 23079:20120620:143054.357 In substitute_discovery_macros() data:'Free disk space is less than 10% on volume {#FSNAME}' 23079:20120620:143054.357 End of substitute_discovery_macros() data:'Free disk space is less than 10% on volume C:\' 23079:20120620:143054.357 In DBlld_get_trigger_functions() 23079:20120620:143054.357 query [txnlev:1] [select f.functionid,f.itemid,h.host,i.key_,f.function,f.parameter,i.flags from functions f,items i,hosts h where f.itemid=i.itemid and i.hostid=h.hostid and f.triggerid=221158] 23079:20120620:143054.357 In substitute_key_macros() data:'vfs.fs.size[{#FSNAME},pfree]' 23079:20120620:143054.357 In substitute_discovery_macros() data:'{#FSNAME}' 23079:20120620:143054.357 End of substitute_discovery_macros() data:'C:\' 23079:20120620:143054.357 End of substitute_key_macros():SUCCEED data:'vfs.fs.size[C:\,pfree]' 23079:20120620:143054.358 End of DBlld_get_trigger_functions() 23079:20120620:143054.358 In DBlld_expand_trigger_expression() expression:'{15192}<88' 23079:20120620:143054.358 End of DBlld_expand_trigger_expression() expr:'{it3:vfs.fs.size[C:\,pfree].last(0)}<88' 23079:20120620:143054.358 query [txnlev:1] [select distinct t.triggerid,t.expression from triggers t,trigger_discovery td where t.triggerid=td.triggerid and td.parent_triggerid=221158 and t.description='Free disk space is less than 10% on volume C:\\'] 23079:20120620:143054.358 In DBlld_get_trigger_functions() 23079:20120620:143054.358 query [txnlev:1] [select f.functionid,f.itemid,h.host,i.key_,f.function,f.parameter,i.flags from functions f,items i,hosts h where f.itemid=i.itemid and i.hostid=h.hostid and f.triggerid=221169] 23079:20120620:143054.358 End of DBlld_get_trigger_functions() 23079:20120620:143054.358 In DBlld_expand_trigger_expression() expression:'{15203}<88' 23079:20120620:143054.358 End of DBlld_expand_trigger_expression() expr:'{it3:vfs.fs.size[C:\,pfree].last(0)}<88' 23079:20120620:143054.358 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=10197 and t.description='Free disk space is less than 10% on volume C:\\' and t.triggerid<>221169] 23079:20120620:143054.359 End of DBlld_make_trigger():SUCCEED 23079:20120620:143054.359 In DBlld_check_record() jp_row:'{"{#FSNAME}":"D:\\","{#FSTYPE}":"NTFS"}' 23079:20120620:143054.359 End of DBlld_check_record():SUCCEED 23079:20120620:143054.359 In DBlld_make_trigger() 23079:20120620:143054.359 In substitute_discovery_macros() data:'Free disk space is less than 10% on volume {#FSNAME}' 23079:20120620:143054.359 End of substitute_discovery_macros() data:'Free disk space is less than 10% on volume D:\' 23079:20120620:143054.359 In DBlld_get_trigger_functions() 23079:20120620:143054.359 query [txnlev:1] [select f.functionid,f.itemid,h.host,i.key_,f.function,f.parameter,i.flags from functions f,items i,hosts h where f.itemid=i.itemid and i.hostid=h.hostid and f.triggerid=221158] 23079:20120620:143054.360 In substitute_key_macros() data:'vfs.fs.size[{#FSNAME},pfree]' 23079:20120620:143054.360 In substitute_discovery_macros() data:'{#FSNAME}' 23079:20120620:143054.360 End of substitute_discovery_macros() data:'D:\' 23079:20120620:143054.360 End of substitute_key_macros():SUCCEED data:'vfs.fs.size[D:\,pfree]' 23079:20120620:143054.360 End of DBlld_get_trigger_functions() 23079:20120620:143054.360 In DBlld_expand_trigger_expression() expression:'{15192}<88' 23079:20120620:143054.360 End of DBlld_expand_trigger_expression() expr:'{it3:vfs.fs.size[D:\,pfree].last(0)}<88' 23079:20120620:143054.360 query [txnlev:1] [select distinct t.triggerid,t.expression from triggers t,trigger_discovery td where t.triggerid=td.triggerid and td.parent_triggerid=221158 and t.description='Free disk space is less than 10% on volume D:\\'] 23079:20120620:143054.360 In DBlld_get_trigger_functions() 23079:20120620:143054.360 query [txnlev:1] [select f.functionid,f.itemid,h.host,i.key_,f.function,f.parameter,i.flags from functions f,items i,hosts h where f.itemid=i.itemid and i.hostid=h.hostid and f.triggerid=221170] 23079:20120620:143054.360 End of DBlld_get_trigger_functions() 23079:20120620:143054.360 In DBlld_expand_trigger_expression() expression:'{15204}<88' 23079:20120620:143054.360 End of DBlld_expand_trigger_expression() expr:'{it3:vfs.fs.size[D:\,pfree].last(0)}<88' 23079:20120620:143054.361 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=10197 and t.description='Free disk space is less than 10% on volume D:\\' and t.triggerid<>221170] 23079:20120620:143054.361 End of DBlld_make_trigger():SUCCEED 23079:20120620:143054.361 In DBlld_check_record() jp_row:'{"{#FSNAME}":"E:\\","{#FSTYPE}":"UNKNOWN"}' 23079:20120620:143054.361 End of DBlld_check_record():FAIL 23079:20120620:143054.361 query [txnlev:1] [update triggers set description='Free disk space is less than 10% on volume C:\\',priority=2,comments='',url='',type=0,flags=4 where triggerid=221169; update trigger_discovery set name='Free disk space is less than 10% on volume {#FSNAME}' where triggerid=221169 and parent_triggerid=221158; update triggers set description='Free disk space is less than 10% on volume D:\\',priority=2,comments='',url='',type=0,flags=4 where triggerid=221170; update trigger_discovery set name='Free disk space is less than 10% on volume {#FSNAME}' where triggerid=221170 and parent_triggerid=221158; ] 23079:20120620:143054.362 End of DBlld_update_triggers() 23079:20120620:143054.362 In DBlld_update_graphs() 23079:20120620:143054.362 query [txnlev:1] [select distinct g.graphid,g.name,g.width,g.height,g.yaxismin,g.yaxismax,g.show_work_period,g.show_triggers,g.graphtype,g.show_legend,g.show_3d,g.percent_left,g.percent_right,g.ymin_type,i1.itemid,i1.flags,i1.key_,g.ymax_type,i2.itemid,i2.flags,i2.key_ from item_discovery id,items i,graphs_items gi,graphs g left join items i1 on i1.itemid=g.ymin_itemid left join items i2 on i2.itemid=g.ymax_itemid where id.itemid=i.itemid and i.itemid=gi.itemid and gi.graphid=g.graphid and id.parent_itemid=26694] 23079:20120620:143054.363 End of DBlld_update_graphs() 23079:20120620:143054.363 In DBlld_remove_lost_resources() lifetime:30 23079:20120620:143054.363 query [txnlev:1] [select id2.itemdiscoveryid,id2.itemid,id2.lastcheck,id2.ts_delete from item_discovery id1,item_discovery id2 where id1.itemid=id2.parent_itemid and id1.parent_itemid=26694 and id2.lastcheck<1340191854] 23079:20120620:143054.363 In DBdelete_items() values_num:0 23079:20120620:143054.363 End of DBdelete_items() 23079:20120620:143054.363 End of DBlld_remove_lost_resources() 23079:20120620:143054.363 query [txnlev:1] [update items set lastclock=1340191854,lastns=349703736 where itemid=26694] 23079:20120620:143054.364 query [txnlev:1] [commit;] 23079:20120620:143054.365 End of DBlld_process_discovery_rule() 23079:20120620:143054.365 End of get_values():1 23079:20120620:143054.365 poller #1 spent 0.023971 seconds while updating 1 values 23079:20120620:143054.365 In DCconfig_get_poller_nextcheck() poller_type:0 23079:20120620:143054.365 End of DCconfig_get_poller_nextcheck():1340191914 23079:20120620:143054.365 sleeping for 5 seconds ... trigger prototype expression has been changed from: {it3:vfs.fs.size[{#FSNAME},pfree].last(0)}<88 to: {it3:vfs.fs.size[{#FSNAME},pfree].last(0)}<5 .... 23079:20120620:143154.376 In get_values() 23079:20120620:143154.376 In DCconfig_get_poller_items() poller_type:0 23079:20120620:143154.376 End of DCconfig_get_poller_items():1 23079:20120620:143154.376 In substitute_key_macros() data:'vfs.fs.discovery' 23079:20120620:143154.376 End of substitute_key_macros():SUCCEED data:'vfs.fs.discovery' 23079:20120620:143154.376 In substitute_simple_macros() data:'10050' 23079:20120620:143154.376 In get_value() key:'vfs.fs.discovery' 23079:20120620:143154.376 In get_value_agent() host:'it3' addr:'10.20.0.12' key:'vfs.fs.discovery' 23079:20120620:143154.376 Sending [vfs.fs.discovery ] 23079:20120620:143154.384 get value from agent result: '{ "data":[ { "{#FSNAME}":"C:\\", "{#FSTYPE}":"NTFS"}, { "{#FSNAME}":"D:\\", "{#FSTYPE}":"NTFS"}, { "{#FSNAME}":"E:\\", "{#FSTYPE}":"UNKNOWN"}]}' 23079:20120620:143154.384 End of get_value():SUCCEED 23079:20120620:143154.384 In activate_host() hostid:10197 itemid:26694 type:0 23079:20120620:143154.384 In DBlld_process_discovery_rule() itemid:26694 23079:20120620:143154.384 query [txnlev:0] [select hostid,key_,status,filter,error,lifetime from items where itemid=26694] 23079:20120620:143154.384 In substitute_simple_macros() data:'30' 23079:20120620:143154.384 query [txnlev:1] [begin;] 23079:20120620:143154.384 query [txnlev:1] [select r.name,e.expression,e.expression_type,e.exp_delimiter,e.case_sensitive from regexps r,expressions e where r.regexpid=e.regexpid and r.name='File systems for discovery'] 23079:20120620:143154.385 DBlld_process_discovery_rule() f_macro:'{#FSTYPE}' f_regexp:'@File systems for discovery' 23079:20120620:143154.385 In DBlld_update_items() 23079:20120620:143154.385 query [txnlev:1] [select i.itemid,i.name,i.key_,i.type,i.value_type,i.data_type,i.delay,i.delay_flex,i.history,i.trends,i.status,i.trapper_hosts,i.units,i.multiplier,i.delta,i.formula,i.logtimefmt,i.valuemapid,i.params,i.ipmi_sensor,i.snmp_community,i.snmp_oid,i.port,i.snmpv3_securityname,i.snmpv3_securitylevel,i.snmpv3_authpassphrase,i.snmpv3_privpassphrase,i.authtype,i.username,i.password,i.publickey,i.privatekey,i.description,i.interfaceid from items i,item_discovery id where i.itemid=id.itemid and id.parent_itemid=26694] 23079:20120620:143154.385 In DBlld_check_record() jp_row:'{"{#FSNAME}":"C:\\","{#FSTYPE}":"NTFS"}' 23079:20120620:143154.386 End of DBlld_check_record():SUCCEED 23079:20120620:143154.386 In DBlld_make_item() 23079:20120620:143154.386 In substitute_key_macros() data:'vfs.fs.size[{#FSNAME},pfree]' 23079:20120620:143154.386 In substitute_discovery_macros() data:'{#FSNAME}' 23079:20120620:143154.386 End of substitute_discovery_macros() data:'C:\' 23079:20120620:143154.386 End of substitute_key_macros():SUCCEED data:'vfs.fs.size[C:\,pfree]' 23079:20120620:143154.386 query [txnlev:1] [select distinct i.itemid from items i,item_discovery id where i.itemid=id.itemid and id.parent_itemid=26695 and i.key_='vfs.fs.size[C:\\,pfree]'] 23079:20120620:143154.386 query [txnlev:1] [select itemid from items where hostid=10197 and key_='vfs.fs.size[C:\\,pfree]' and itemid<>26700] 23079:20120620:143154.387 In substitute_discovery_macros() data:'Free disk space on $1 (percentage)' 23079:20120620:143154.387 End of substitute_discovery_macros() data:'Free disk space on $1 (percentage)' 23079:20120620:143154.387 In substitute_key_macros() data:'' 23079:20120620:143154.387 End of substitute_key_macros():FAIL data:'' 23079:20120620:143154.387 query [txnlev:1] [select applicationid from items_applications where itemid=26695] 23079:20120620:143154.387 query [txnlev:1] [select applicationid from items_applications where itemid=26700] 23079:20120620:143154.387 End of DBlld_make_item():SUCCEED 23079:20120620:143154.387 In DBlld_check_record() jp_row:'{"{#FSNAME}":"D:\\","{#FSTYPE}":"NTFS"}' 23079:20120620:143154.387 End of DBlld_check_record():SUCCEED 23079:20120620:143154.387 In DBlld_make_item() 23079:20120620:143154.387 In substitute_key_macros() data:'vfs.fs.size[{#FSNAME},pfree]' 23079:20120620:143154.387 In substitute_discovery_macros() data:'{#FSNAME}' 23079:20120620:143154.388 End of substitute_discovery_macros() data:'D:\' 23079:20120620:143154.388 End of substitute_key_macros():SUCCEED data:'vfs.fs.size[D:\,pfree]' 23079:20120620:143154.388 query [txnlev:1] [select distinct i.itemid from items i,item_discovery id where i.itemid=id.itemid and id.parent_itemid=26695 and i.key_='vfs.fs.size[D:\\,pfree]'] 23079:20120620:143154.388 query [txnlev:1] [select itemid from items where hostid=10197 and key_='vfs.fs.size[D:\\,pfree]' and itemid<>26701] 23079:20120620:143154.388 In substitute_discovery_macros() data:'Free disk space on $1 (percentage)' 23079:20120620:143154.388 End of substitute_discovery_macros() data:'Free disk space on $1 (percentage)' 23079:20120620:143154.388 In substitute_key_macros() data:'' 23079:20120620:143154.388 End of substitute_key_macros():FAIL data:'' 23079:20120620:143154.389 query [txnlev:1] [select applicationid from items_applications where itemid=26695] 23079:20120620:143154.389 query [txnlev:1] [select applicationid from items_applications where itemid=26701] 23079:20120620:143154.389 End of DBlld_make_item():SUCCEED 23079:20120620:143154.389 In DBlld_check_record() jp_row:'{"{#FSNAME}":"E:\\","{#FSTYPE}":"UNKNOWN"}' 23079:20120620:143154.389 End of DBlld_check_record():FAIL 23079:20120620:143154.389 query [txnlev:1] [update items set name='Free disk space on $1 (percentage)',key_='vfs.fs.size[C:\\,pfree]',type=0,value_type=0,data_type=0,delay=600,delay_flex='',history=7,trends=365,trapper_hosts='',units='%',multiplier=0,delta=0,formula='1',logtimefmt='',valuemapid=null,params='',ipmi_sensor='',snmp_community='',snmp_oid='',port='',snmpv3_securityname='',snmpv3_securitylevel=0,snmpv3_authpassphrase='',snmpv3_privpassphrase='',authtype=0,username='',password='',publickey='',privatekey='',description='',interfaceid=30356,flags=4 where itemid=26700; update item_discovery set key_='vfs.fs.size[{#FSNAME},pfree]',lastcheck=1340191914,ts_delete=0 where itemid=26700 and parent_itemid=26695; update items set name='Free disk space on $1 (percentage)',key_='vfs.fs.size[D:\\,pfree]',type=0,value_type=0,data_type=0,delay=600,delay_flex='',history=7,trends=365,trapper_hosts='',units='%',multiplier=0,delta=0,formula='1',logtimefmt='',valuemapid=null,params='',ipmi_sensor='',snmp_community='',snmp_oid='',port='',snmpv3_securityname='',snmpv3_securitylevel=0,snmpv3_authpassphrase='',snmpv3_privpassphrase='',authtype=0,username='',password='',publickey='',privatekey='',description='',interfaceid=30356,flags=4 where itemid=26701; update item_discovery set key_='vfs.fs.size[{#FSNAME},pfree]',lastcheck=1340191914,ts_delete=0 where itemid=26701 and parent_itemid=26695; ] 23079:20120620:143154.390 End of DBlld_update_items() 23079:20120620:143154.390 In DBlld_update_triggers() 23079:20120620:143154.390 query [txnlev:1] [select distinct t.triggerid,t.description,t.expression,t.status,t.type,t.priority,t.comments,t.url from triggers t,functions f,items i,item_discovery id where t.triggerid=f.triggerid and f.itemid=i.itemid and i.itemid=id.itemid and id.parent_itemid=26694] 23079:20120620:143154.391 In DBlld_check_record() jp_row:'{"{#FSNAME}":"C:\\","{#FSTYPE}":"NTFS"}' 23079:20120620:143154.391 End of DBlld_check_record():SUCCEED 23079:20120620:143154.391 In DBlld_make_trigger() 23079:20120620:143154.391 In substitute_discovery_macros() data:'Free disk space is less than 10% on volume {#FSNAME}' 23079:20120620:143154.391 End of substitute_discovery_macros() data:'Free disk space is less than 10% on volume C:\' 23079:20120620:143154.391 In DBlld_get_trigger_functions() 23079:20120620:143154.391 query [txnlev:1] [select f.functionid,f.itemid,h.host,i.key_,f.function,f.parameter,i.flags from functions f,items i,hosts h where f.itemid=i.itemid and i.hostid=h.hostid and f.triggerid=221158] 23079:20120620:143154.392 In substitute_key_macros() data:'vfs.fs.size[{#FSNAME},pfree]' 23079:20120620:143154.392 In substitute_discovery_macros() data:'{#FSNAME}' 23079:20120620:143154.392 End of substitute_discovery_macros() data:'C:\' 23079:20120620:143154.392 End of substitute_key_macros():SUCCEED data:'vfs.fs.size[C:\,pfree]' 23079:20120620:143154.392 End of DBlld_get_trigger_functions() 23079:20120620:143154.392 In DBlld_expand_trigger_expression() expression:'{15206}<5' 23079:20120620:143154.392 End of DBlld_expand_trigger_expression() expr:'{it3:vfs.fs.size[C:\,pfree].last(0)}<5' 23079:20120620:143154.392 query [txnlev:1] [select distinct t.triggerid,t.expression from triggers t,trigger_discovery td where t.triggerid=td.triggerid and td.parent_triggerid=221158 and t.description='Free disk space is less than 10% on volume C:\\'] 23079:20120620:143154.392 In DBlld_get_trigger_functions() 23079:20120620:143154.392 query [txnlev:1] [select f.functionid,f.itemid,h.host,i.key_,f.function,f.parameter,i.flags from functions f,items i,hosts h where f.itemid=i.itemid and i.hostid=h.hostid and f.triggerid=221169] 23079:20120620:143154.393 End of DBlld_get_trigger_functions() 23079:20120620:143154.393 In DBlld_expand_trigger_expression() expression:'{15203}<88' 23079:20120620:143154.393 End of DBlld_expand_trigger_expression() expr:'{it3:vfs.fs.size[C:\,pfree].last(0)}<88' 23079:20120620:143154.393 query [txnlev:1] [select distinct t.triggerid,t.expression,td.name,t.description from triggers t,trigger_discovery td where t.triggerid=td.triggerid and td.parent_triggerid=221158] 23079:20120620:143154.393 In substitute_discovery_macros() data:'Free disk space is less than 10% on volume {#FSNAME}' 23079:20120620:143154.393 End of substitute_discovery_macros() data:'Free disk space is less than 10% on volume C:\' 23079:20120620:143154.393 In DBlld_get_trigger_functions() 23079:20120620:143154.393 query [txnlev:1] [select f.functionid,f.itemid,h.host,i.key_,f.function,f.parameter,i.flags from functions f,items i,hosts h where f.itemid=i.itemid and i.hostid=h.hostid and f.triggerid=221169] 23079:20120620:143154.394 End of DBlld_get_trigger_functions() 23079:20120620:143154.394 In DBlld_expand_trigger_expression() expression:'{15203}<88' 23079:20120620:143154.394 End of DBlld_expand_trigger_expression() expr:'{it3:vfs.fs.size[C:\,pfree].last(0)}<88' 23079:20120620:143154.394 In DBlld_compare_trigger_items() 23079:20120620:143154.394 query [txnlev:1] [select id.key_,i.key_ from functions f,items i,item_discovery id where f.itemid=i.itemid and i.itemid=id.itemid and f.triggerid=221169] 23079:20120620:143154.394 In substitute_key_macros() data:'vfs.fs.size[{#FSNAME},pfree]' 23079:20120620:143154.394 In substitute_discovery_macros() data:'{#FSNAME}' 23079:20120620:143154.394 End of substitute_discovery_macros() data:'C:\' 23079:20120620:143154.394 End of substitute_key_macros():SUCCEED data:'vfs.fs.size[C:\,pfree]' 23079:20120620:143154.394 End of DBlld_compare_trigger_items():SUCCEED 23079:20120620:143154.394 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=10197 and t.description='Free disk space is less than 10% on volume C:\\' and t.triggerid<>221169] 23079:20120620:143154.395 In DBlld_get_item() 23079:20120620:143154.395 query [txnlev:1] [select itemid from items where hostid=10197 and key_='vfs.fs.size[C:\\,pfree]'] 23079:20120620:143154.395 End of DBlld_get_item():SUCCEED 23079:20120620:143154.395 End of DBlld_make_trigger():SUCCEED 23079:20120620:143154.395 In DBlld_check_record() jp_row:'{"{#FSNAME}":"D:\\","{#FSTYPE}":"NTFS"}' 23079:20120620:143154.395 End of DBlld_check_record():SUCCEED 23079:20120620:143154.395 In DBlld_make_trigger() 23079:20120620:143154.395 In substitute_discovery_macros() data:'Free disk space is less than 10% on volume {#FSNAME}' 23079:20120620:143154.395 End of substitute_discovery_macros() data:'Free disk space is less than 10% on volume D:\' 23079:20120620:143154.396 In DBlld_get_trigger_functions() 23079:20120620:143154.396 query [txnlev:1] [select f.functionid,f.itemid,h.host,i.key_,f.function,f.parameter,i.flags from functions f,items i,hosts h where f.itemid=i.itemid and i.hostid=h.hostid and f.triggerid=221158] 23079:20120620:143154.396 In substitute_key_macros() data:'vfs.fs.size[{#FSNAME},pfree]' 23079:20120620:143154.396 In substitute_discovery_macros() data:'{#FSNAME}' 23079:20120620:143154.396 End of substitute_discovery_macros() data:'D:\' 23079:20120620:143154.396 End of substitute_key_macros():SUCCEED data:'vfs.fs.size[D:\,pfree]' 23079:20120620:143154.396 End of DBlld_get_trigger_functions() 23079:20120620:143154.396 In DBlld_expand_trigger_expression() expression:'{15206}<5' 23079:20120620:143154.396 End of DBlld_expand_trigger_expression() expr:'{it3:vfs.fs.size[D:\,pfree].last(0)}<5' 23079:20120620:143154.396 query [txnlev:1] [select distinct t.triggerid,t.expression from triggers t,trigger_discovery td where t.triggerid=td.triggerid and td.parent_triggerid=221158 and t.description='Free disk space is less than 10% on volume D:\\'] 23079:20120620:143154.397 In DBlld_get_trigger_functions() 23079:20120620:143154.397 query [txnlev:1] [select f.functionid,f.itemid,h.host,i.key_,f.function,f.parameter,i.flags from functions f,items i,hosts h where f.itemid=i.itemid and i.hostid=h.hostid and f.triggerid=221170] 23079:20120620:143154.397 End of DBlld_get_trigger_functions() 23079:20120620:143154.397 In DBlld_expand_trigger_expression() expression:'{15204}<88' 23079:20120620:143154.397 End of DBlld_expand_trigger_expression() expr:'{it3:vfs.fs.size[D:\,pfree].last(0)}<88' 23079:20120620:143154.397 query [txnlev:1] [select distinct t.triggerid,t.expression,td.name,t.description from triggers t,trigger_discovery td where t.triggerid=td.triggerid and td.parent_triggerid=221158] 23079:20120620:143154.397 In substitute_discovery_macros() data:'Free disk space is less than 10% on volume {#FSNAME}' 23079:20120620:143154.397 End of substitute_discovery_macros() data:'Free disk space is less than 10% on volume D:\' 23079:20120620:143154.397 In substitute_discovery_macros() data:'Free disk space is less than 10% on volume {#FSNAME}' 23079:20120620:143154.397 End of substitute_discovery_macros() data:'Free disk space is less than 10% on volume D:\' 23079:20120620:143154.397 In DBlld_get_trigger_functions() 23079:20120620:143154.398 query [txnlev:1] [select f.functionid,f.itemid,h.host,i.key_,f.function,f.parameter,i.flags from functions f,items i,hosts h where f.itemid=i.itemid and i.hostid=h.hostid and f.triggerid=221170] 23079:20120620:143154.398 End of DBlld_get_trigger_functions() 23079:20120620:143154.398 In DBlld_expand_trigger_expression() expression:'{15204}<88' 23079:20120620:143154.398 End of DBlld_expand_trigger_expression() expr:'{it3:vfs.fs.size[D:\,pfree].last(0)}<88' 23079:20120620:143154.398 In DBlld_compare_trigger_items() 23079:20120620:143154.398 query [txnlev:1] [select id.key_,i.key_ from functions f,items i,item_discovery id where f.itemid=i.itemid and i.itemid=id.itemid and f.triggerid=221170] 23079:20120620:143154.398 In substitute_key_macros() data:'vfs.fs.size[{#FSNAME},pfree]' 23079:20120620:143154.398 In substitute_discovery_macros() data:'{#FSNAME}' 23079:20120620:143154.398 End of substitute_discovery_macros() data:'D:\' 23079:20120620:143154.398 End of substitute_key_macros():SUCCEED data:'vfs.fs.size[D:\,pfree]' 23079:20120620:143154.398 End of DBlld_compare_trigger_items():SUCCEED 23079:20120620:143154.399 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=10197 and t.description='Free disk space is less than 10% on volume D:\\' and t.triggerid<>221170] 23079:20120620:143154.399 In DBlld_get_item() 23079:20120620:143154.399 query [txnlev:1] [select itemid from items where hostid=10197 and key_='vfs.fs.size[D:\\,pfree]'] 23079:20120620:143154.399 End of DBlld_get_item():SUCCEED 23079:20120620:143154.399 End of DBlld_make_trigger():SUCCEED 23079:20120620:143154.399 In DBlld_check_record() jp_row:'{"{#FSNAME}":"E:\\","{#FSTYPE}":"UNKNOWN"}' 23079:20120620:143154.399 End of DBlld_check_record():FAIL 23079:20120620:143154.400 In DBget_nextid() tablename:'functions' 23079:20120620:143154.400 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='functions' and field_name='functionid'] 23079:20120620:143154.400 query [txnlev:1] [update ids set nextid=nextid+2 where nodeid=0 and table_name='functions' and field_name='functionid'] 23079:20120620:143154.400 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='functions' and field_name='functionid'] 23079:20120620:143154.400 End of DBget_nextid():15207 table:'functions' recid:'functionid' 23079:20120620:143154.400 query [txnlev:1] [insert into functions (functionid,itemid,triggerid,function,parameter) values (15207,26700,221169,'last','0'),(15208,26701,221170,'last','0'); ] 23079:20120620:143154.401 query [txnlev:1] [update triggers set description='Free disk space is less than 10% on volume C:\\',expression='{15207}<5',priority=2,comments='',url='',type=0,flags=4 where triggerid=221169; update trigger_discovery set name='Free disk space is less than 10% on volume {#FSNAME}' where triggerid=221169 and parent_triggerid=221158; delete from functions where triggerid=221169; update triggers set description='Free disk space is less than 10% on volume D:\\',expression='{15208}<5',priority=2,comments='',url='',type=0,flags=4 where triggerid=221170; update trigger_discovery set name='Free disk space is less than 10% on volume {#FSNAME}' where triggerid=221170 and parent_triggerid=221158; delete from functions where triggerid=221170; ] 23079:20120620:143154.402 End of DBlld_update_triggers() 23079:20120620:143154.402 In DBlld_update_graphs() 23079:20120620:143154.402 query [txnlev:1] [select distinct g.graphid,g.name,g.width,g.height,g.yaxismin,g.yaxismax,g.show_work_period,g.show_triggers,g.graphtype,g.show_legend,g.show_3d,g.percent_left,g.percent_right,g.ymin_type,i1.itemid,i1.flags,i1.key_,g.ymax_type,i2.itemid,i2.flags,i2.key_ from item_discovery id,items i,graphs_items gi,graphs g left join items i1 on i1.itemid=g.ymin_itemid left join items i2 on i2.itemid=g.ymax_itemid where id.itemid=i.itemid and i.itemid=gi.itemid and gi.graphid=g.graphid and id.parent_itemid=26694] 23079:20120620:143154.403 End of DBlld_update_graphs() 23079:20120620:143154.403 In DBlld_remove_lost_resources() lifetime:30 23079:20120620:143154.403 query [txnlev:1] [select id2.itemdiscoveryid,id2.itemid,id2.lastcheck,id2.ts_delete from item_discovery id1,item_discovery id2 where id1.itemid=id2.parent_itemid and id1.parent_itemid=26694 and id2.lastcheck<1340191914] 23079:20120620:143154.403 In DBdelete_items() values_num:0 23079:20120620:143154.403 End of DBdelete_items() 23079:20120620:143154.403 End of DBlld_remove_lost_resources() 23079:20120620:143154.403 query [txnlev:1] [update items set lastclock=1340191914,lastns=384149430 where itemid=26694] 23079:20120620:143154.404 query [txnlev:1] [commit;] 23079:20120620:143154.404 End of DBlld_process_discovery_rule() 23079:20120620:143154.404 End of get_values():1 23079:20120620:143154.404 poller #1 spent 0.028861 seconds while updating 1 values 23079:20120620:143154.405 In DCconfig_get_poller_nextcheck() poller_type:0 23079:20120620:143154.405 End of DCconfig_get_poller_nextcheck():1340191974 23079:20120620:143154.405 sleeping for 5 seconds .. 23079:20120620:143254.415 In get_values() 23079:20120620:143254.415 In DCconfig_get_poller_items() poller_type:0 23079:20120620:143254.415 End of DCconfig_get_poller_items():1 23079:20120620:143254.415 In substitute_key_macros() data:'vfs.fs.discovery' 23079:20120620:143254.416 End of substitute_key_macros():SUCCEED data:'vfs.fs.discovery' 23079:20120620:143254.416 In substitute_simple_macros() data:'10050' 23079:20120620:143254.416 In get_value() key:'vfs.fs.discovery' 23079:20120620:143254.416 In get_value_agent() host:'it3' addr:'10.20.0.12' key:'vfs.fs.discovery' 23079:20120620:143254.416 Sending [vfs.fs.discovery ] 23079:20120620:143254.423 get value from agent result: '{ "data":[ { "{#FSNAME}":"C:\\", "{#FSTYPE}":"NTFS"}, { "{#FSNAME}":"D:\\", "{#FSTYPE}":"NTFS"}, { "{#FSNAME}":"E:\\", "{#FSTYPE}":"UNKNOWN"}]}' 23079:20120620:143254.424 End of get_value():SUCCEED 23079:20120620:143254.424 In activate_host() hostid:10197 itemid:26694 type:0 23079:20120620:143254.424 In DBlld_process_discovery_rule() itemid:26694 23079:20120620:143254.424 query [txnlev:0] [select hostid,key_,status,filter,error,lifetime from items where itemid=26694] 23079:20120620:143254.424 In substitute_simple_macros() data:'30' 23079:20120620:143254.424 query [txnlev:1] [begin;] 23079:20120620:143254.424 query [txnlev:1] [select r.name,e.expression,e.expression_type,e.exp_delimiter,e.case_sensitive from regexps r,expressions e where r.regexpid=e.regexpid and r.name='File systems for discovery'] 23079:20120620:143254.424 DBlld_process_discovery_rule() f_macro:'{#FSTYPE}' f_regexp:'@File systems for discovery' 23079:20120620:143254.424 In DBlld_update_items() 23079:20120620:143254.424 query [txnlev:1] [select i.itemid,i.name,i.key_,i.type,i.value_type,i.data_type,i.delay,i.delay_flex,i.history,i.trends,i.status,i.trapper_hosts,i.units,i.multiplier,i.delta,i.formula,i.logtimefmt,i.valuemapid,i.params,i.ipmi_sensor,i.snmp_community,i.snmp_oid,i.port,i.snmpv3_securityname,i.snmpv3_securitylevel,i.snmpv3_authpassphrase,i.snmpv3_privpassphrase,i.authtype,i.username,i.password,i.publickey,i.privatekey,i.description,i.interfaceid from items i,item_discovery id where i.itemid=id.itemid and id.parent_itemid=26694] 23079:20120620:143254.425 In DBlld_check_record() jp_row:'{"{#FSNAME}":"C:\\","{#FSTYPE}":"NTFS"}' 23079:20120620:143254.425 End of DBlld_check_record():SUCCEED 23079:20120620:143254.425 In DBlld_make_item() 23079:20120620:143254.425 In substitute_key_macros() data:'vfs.fs.size[{#FSNAME},pfree]' 23079:20120620:143254.425 In substitute_discovery_macros() data:'{#FSNAME}' 23079:20120620:143254.425 End of substitute_discovery_macros() data:'C:\' 23079:20120620:143254.425 End of substitute_key_macros():SUCCEED data:'vfs.fs.size[C:\,pfree]' 23079:20120620:143254.425 query [txnlev:1] [select distinct i.itemid from items i,item_discovery id where i.itemid=id.itemid and id.parent_itemid=26695 and i.key_='vfs.fs.size[C:\\,pfree]'] 23079:20120620:143254.425 query [txnlev:1] [select itemid from items where hostid=10197 and key_='vfs.fs.size[C:\\,pfree]' and itemid<>26700] 23079:20120620:143254.425 In substitute_discovery_macros() data:'Free disk space on $1 (percentage)' 23079:20120620:143254.425 End of substitute_discovery_macros() data:'Free disk space on $1 (percentage)' 23079:20120620:143254.425 In substitute_key_macros() data:'' 23079:20120620:143254.425 End of substitute_key_macros():FAIL data:'' 23079:20120620:143254.425 query [txnlev:1] [select applicationid from items_applications where itemid=26695] 23079:20120620:143254.425 query [txnlev:1] [select applicationid from items_applications where itemid=26700] 23079:20120620:143254.425 End of DBlld_make_item():SUCCEED 23079:20120620:143254.425 In DBlld_check_record() jp_row:'{"{#FSNAME}":"D:\\","{#FSTYPE}":"NTFS"}' 23079:20120620:143254.426 End of DBlld_check_record():SUCCEED 23079:20120620:143254.426 In DBlld_make_item() 23079:20120620:143254.426 In substitute_key_macros() data:'vfs.fs.size[{#FSNAME},pfree]' 23079:20120620:143254.426 In substitute_discovery_macros() data:'{#FSNAME}' 23079:20120620:143254.426 End of substitute_discovery_macros() data:'D:\' 23079:20120620:143254.426 End of substitute_key_macros():SUCCEED data:'vfs.fs.size[D:\,pfree]' 23079:20120620:143254.426 query [txnlev:1] [select distinct i.itemid from items i,item_discovery id where i.itemid=id.itemid and id.parent_itemid=26695 and i.key_='vfs.fs.size[D:\\,pfree]'] 23079:20120620:143254.426 query [txnlev:1] [select itemid from items where hostid=10197 and key_='vfs.fs.size[D:\\,pfree]' and itemid<>26701] 23079:20120620:143254.426 In substitute_discovery_macros() data:'Free disk space on $1 (percentage)' 23079:20120620:143254.426 End of substitute_discovery_macros() data:'Free disk space on $1 (percentage)' 23079:20120620:143254.426 In substitute_key_macros() data:'' 23079:20120620:143254.426 End of substitute_key_macros():FAIL data:'' 23079:20120620:143254.426 query [txnlev:1] [select applicationid from items_applications where itemid=26695] 23079:20120620:143254.426 query [txnlev:1] [select applicationid from items_applications where itemid=26701] 23079:20120620:143254.426 End of DBlld_make_item():SUCCEED 23079:20120620:143254.426 In DBlld_check_record() jp_row:'{"{#FSNAME}":"E:\\","{#FSTYPE}":"UNKNOWN"}' 23079:20120620:143254.426 End of DBlld_check_record():FAIL 23079:20120620:143254.426 query [txnlev:1] [update items set name='Free disk space on $1 (percentage)',key_='vfs.fs.size[C:\\,pfree]',type=0,value_type=0,data_type=0,delay=600,delay_flex='',history=7,trends=365,trapper_hosts='',units='%',multiplier=0,delta=0,formula='1',logtimefmt='',valuemapid=null,params='',ipmi_sensor='',snmp_community='',snmp_oid='',port='',snmpv3_securityname='',snmpv3_securitylevel=0,snmpv3_authpassphrase='',snmpv3_privpassphrase='',authtype=0,username='',password='',publickey='',privatekey='',description='',interfaceid=30356,flags=4 where itemid=26700; update item_discovery set key_='vfs.fs.size[{#FSNAME},pfree]',lastcheck=1340191974,ts_delete=0 where itemid=26700 and parent_itemid=26695; update items set name='Free disk space on $1 (percentage)',key_='vfs.fs.size[D:\\,pfree]',type=0,value_type=0,data_type=0,delay=600,delay_flex='',history=7,trends=365,trapper_hosts='',units='%',multiplier=0,delta=0,formula='1',logtimefmt='',valuemapid=null,params='',ipmi_sensor='',snmp_community='',snmp_oid='',port='',snmpv3_securityname='',snmpv3_securitylevel=0,snmpv3_authpassphrase='',snmpv3_privpassphrase='',authtype=0,username='',password='',publickey='',privatekey='',description='',interfaceid=30356,flags=4 where itemid=26701; update item_discovery set key_='vfs.fs.size[{#FSNAME},pfree]',lastcheck=1340191974,ts_delete=0 where itemid=26701 and parent_itemid=26695; ] 23079:20120620:143254.427 End of DBlld_update_items() 23079:20120620:143254.427 In DBlld_update_triggers() 23079:20120620:143254.427 query [txnlev:1] [select distinct t.triggerid,t.description,t.expression,t.status,t.type,t.priority,t.comments,t.url from triggers t,functions f,items i,item_discovery id where t.triggerid=f.triggerid and f.itemid=i.itemid and i.itemid=id.itemid and id.parent_itemid=26694] 23079:20120620:143254.427 In DBlld_check_record() jp_row:'{"{#FSNAME}":"C:\\","{#FSTYPE}":"NTFS"}' 23079:20120620:143254.427 End of DBlld_check_record():SUCCEED 23079:20120620:143254.427 In DBlld_make_trigger() 23079:20120620:143254.427 In substitute_discovery_macros() data:'Free disk space is less than 10% on volume {#FSNAME}' 23079:20120620:143254.427 End of substitute_discovery_macros() data:'Free disk space is less than 10% on volume C:\' 23079:20120620:143254.427 In DBlld_get_trigger_functions() 23079:20120620:143254.427 query [txnlev:1] [select f.functionid,f.itemid,h.host,i.key_,f.function,f.parameter,i.flags from functions f,items i,hosts h where f.itemid=i.itemid and i.hostid=h.hostid and f.triggerid=221158] 23079:20120620:143254.428 In substitute_key_macros() data:'vfs.fs.size[{#FSNAME},pfree]' 23079:20120620:143254.428 In substitute_discovery_macros() data:'{#FSNAME}' 23079:20120620:143254.428 End of substitute_discovery_macros() data:'C:\' 23079:20120620:143254.428 End of substitute_key_macros():SUCCEED data:'vfs.fs.size[C:\,pfree]' 23079:20120620:143254.428 End of DBlld_get_trigger_functions() 23079:20120620:143254.428 In DBlld_expand_trigger_expression() expression:'{15206}<5' 23079:20120620:143254.428 End of DBlld_expand_trigger_expression() expr:'{it3:vfs.fs.size[C:\,pfree].last(0)}<5' 23079:20120620:143254.428 query [txnlev:1] [select distinct t.triggerid,t.expression from triggers t,trigger_discovery td where t.triggerid=td.triggerid and td.parent_triggerid=221158 and t.description='Free disk space is less than 10% on volume C:\\'] 23079:20120620:143254.428 In DBlld_get_trigger_functions() 23079:20120620:143254.428 query [txnlev:1] [select f.functionid,f.itemid,h.host,i.key_,f.function,f.parameter,i.flags from functions f,items i,hosts h where f.itemid=i.itemid and i.hostid=h.hostid and f.triggerid=221169] 23079:20120620:143254.428 End of DBlld_get_trigger_functions() 23079:20120620:143254.428 In DBlld_expand_trigger_expression() expression:'{15207}<5' 23079:20120620:143254.428 End of DBlld_expand_trigger_expression() expr:'{15207}<5' 23079:20120620:143254.428 query [txnlev:1] [select distinct t.triggerid,t.expression,td.name,t.description from triggers t,trigger_discovery td where t.triggerid=td.triggerid and td.parent_triggerid=221158] 23079:20120620:143254.428 In substitute_discovery_macros() data:'Free disk space is less than 10% on volume {#FSNAME}' 23079:20120620:143254.428 End of substitute_discovery_macros() data:'Free disk space is less than 10% on volume C:\' 23079:20120620:143254.428 In DBlld_get_trigger_functions() 23079:20120620:143254.428 query [txnlev:1] [select f.functionid,f.itemid,h.host,i.key_,f.function,f.parameter,i.flags from functions f,items i,hosts h where f.itemid=i.itemid and i.hostid=h.hostid and f.triggerid=221169] 23079:20120620:143254.429 End of DBlld_get_trigger_functions() 23079:20120620:143254.429 In DBlld_expand_trigger_expression() expression:'{15207}<5' 23079:20120620:143254.429 End of DBlld_expand_trigger_expression() expr:'{15207}<5' 23079:20120620:143254.429 In DBlld_compare_trigger_items() 23079:20120620:143254.429 query [txnlev:1] [select id.key_,i.key_ from functions f,items i,item_discovery id where f.itemid=i.itemid and i.itemid=id.itemid and f.triggerid=221169] 23079:20120620:143254.429 End of DBlld_compare_trigger_items():FAIL 23079:20120620:143254.429 In substitute_discovery_macros() data:'Free disk space is less than 10% on volume {#FSNAME}' 23079:20120620:143254.429 End of substitute_discovery_macros() data:'Free disk space is less than 10% on volume C:\' 23079:20120620:143254.429 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=10197 and t.description='Free disk space is less than 10% on volume C:\\'] 23079:20120620:143254.429 In DBlld_get_item() 23079:20120620:143254.429 query [txnlev:1] [select itemid from items where hostid=10197 and key_='vfs.fs.size[C:\\,pfree]'] 23079:20120620:143254.429 End of DBlld_get_item():SUCCEED 23079:20120620:143254.429 End of DBlld_make_trigger():SUCCEED 23079:20120620:143254.429 In DBlld_check_record() jp_row:'{"{#FSNAME}":"D:\\","{#FSTYPE}":"NTFS"}' 23079:20120620:143254.429 End of DBlld_check_record():SUCCEED 23079:20120620:143254.429 In DBlld_make_trigger() 23079:20120620:143254.429 In substitute_discovery_macros() data:'Free disk space is less than 10% on volume {#FSNAME}' 23079:20120620:143254.429 End of substitute_discovery_macros() data:'Free disk space is less than 10% on volume D:\' 23079:20120620:143254.429 In DBlld_get_trigger_functions() 23079:20120620:143254.430 query [txnlev:1] [select f.functionid,f.itemid,h.host,i.key_,f.function,f.parameter,i.flags from functions f,items i,hosts h where f.itemid=i.itemid and i.hostid=h.hostid and f.triggerid=221158] 23079:20120620:143254.430 In substitute_key_macros() data:'vfs.fs.size[{#FSNAME},pfree]' 23079:20120620:143254.430 In substitute_discovery_macros() data:'{#FSNAME}' 23079:20120620:143254.430 End of substitute_discovery_macros() data:'D:\' 23079:20120620:143254.430 End of substitute_key_macros():SUCCEED data:'vfs.fs.size[D:\,pfree]' 23079:20120620:143254.430 End of DBlld_get_trigger_functions() 23079:20120620:143254.430 In DBlld_expand_trigger_expression() expression:'{15206}<5' 23079:20120620:143254.430 End of DBlld_expand_trigger_expression() expr:'{it3:vfs.fs.size[D:\,pfree].last(0)}<5' 23079:20120620:143254.430 query [txnlev:1] [select distinct t.triggerid,t.expression from triggers t,trigger_discovery td where t.triggerid=td.triggerid and td.parent_triggerid=221158 and t.description='Free disk space is less than 10% on volume D:\\'] 23079:20120620:143254.430 In DBlld_get_trigger_functions() 23079:20120620:143254.430 query [txnlev:1] [select f.functionid,f.itemid,h.host,i.key_,f.function,f.parameter,i.flags from functions f,items i,hosts h where f.itemid=i.itemid and i.hostid=h.hostid and f.triggerid=221170] 23079:20120620:143254.430 End of DBlld_get_trigger_functions() 23079:20120620:143254.430 In DBlld_expand_trigger_expression() expression:'{15208}<5' 23079:20120620:143254.430 End of DBlld_expand_trigger_expression() expr:'{15208}<5' 23079:20120620:143254.430 query [txnlev:1] [select distinct t.triggerid,t.expression,td.name,t.description from triggers t,trigger_discovery td where t.triggerid=td.triggerid and td.parent_triggerid=221158] 23079:20120620:143254.430 In substitute_discovery_macros() data:'Free disk space is less than 10% on volume {#FSNAME}' 23079:20120620:143254.430 End of substitute_discovery_macros() data:'Free disk space is less than 10% on volume D:\' 23079:20120620:143254.430 In substitute_discovery_macros() data:'Free disk space is less than 10% on volume {#FSNAME}' 23079:20120620:143254.431 End of substitute_discovery_macros() data:'Free disk space is less than 10% on volume D:\' 23079:20120620:143254.431 In DBlld_get_trigger_functions() 23079:20120620:143254.431 query [txnlev:1] [select f.functionid,f.itemid,h.host,i.key_,f.function,f.parameter,i.flags from functions f,items i,hosts h where f.itemid=i.itemid and i.hostid=h.hostid and f.triggerid=221170] 23079:20120620:143254.431 End of DBlld_get_trigger_functions() 23079:20120620:143254.431 In DBlld_expand_trigger_expression() expression:'{15208}<5' 23079:20120620:143254.431 End of DBlld_expand_trigger_expression() expr:'{15208}<5' 23079:20120620:143254.431 In DBlld_compare_trigger_items() 23079:20120620:143254.431 query [txnlev:1] [select id.key_,i.key_ from functions f,items i,item_discovery id where f.itemid=i.itemid and i.itemid=id.itemid and f.triggerid=221170] 23079:20120620:143254.431 End of DBlld_compare_trigger_items():FAIL 23079:20120620:143254.431 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=10197 and t.description='Free disk space is less than 10% on volume D:\\'] 23079:20120620:143254.431 In DBlld_get_item() 23079:20120620:143254.431 query [txnlev:1] [select itemid from items where hostid=10197 and key_='vfs.fs.size[D:\\,pfree]'] 23079:20120620:143254.431 End of DBlld_get_item():SUCCEED 23079:20120620:143254.431 End of DBlld_make_trigger():SUCCEED 23079:20120620:143254.431 In DBlld_check_record() jp_row:'{"{#FSNAME}":"E:\\","{#FSTYPE}":"UNKNOWN"}' 23079:20120620:143254.431 End of DBlld_check_record():FAIL 23079:20120620:143254.431 In DBget_nextid() tablename:'triggers' 23079:20120620:143254.431 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='triggers' and field_name='triggerid'] 23079:20120620:143254.432 query [txnlev:1] [update ids set nextid=nextid+2 where nodeid=0 and table_name='triggers' and field_name='triggerid'] 23079:20120620:143254.432 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='triggers' and field_name='triggerid'] 23079:20120620:143254.432 End of DBget_nextid():221171 table:'triggers' recid:'triggerid' 23079:20120620:143254.432 In DCget_nextid() table:'trigger_discovery' num:2 23079:20120620:143254.432 query [txnlev:1] [select max(triggerdiscoveryid) from trigger_discovery where triggerdiscoveryid between 0 and 99999999999] 23079:20120620:143254.432 End of DCget_nextid() table:'trigger_discovery' [13:14] 23079:20120620:143254.432 In DBget_nextid() tablename:'functions' 23079:20120620:143254.432 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='functions' and field_name='functionid'] 23079:20120620:143254.432 query [txnlev:1] [update ids set nextid=nextid+2 where nodeid=0 and table_name='functions' and field_name='functionid'] 23079:20120620:143254.432 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='functions' and field_name='functionid'] 23079:20120620:143254.432 End of DBget_nextid():15209 table:'functions' recid:'functionid' 23079:20120620:143254.432 query [txnlev:1] [insert into triggers (triggerid,description,expression,priority,status,comments,url,type,value,value_flags,flags,error) values (221171,'Free disk space is less than 10% on volume C:\\','{15209}<5',2,0,'','',0,0,1,4,'Trigger just added. No status update so far.'),(221172,'Free disk space is less than 10% on volume D:\\','{15210}<5',2,0,'','',0,0,1,4,'Trigger just added. No status update so far.'); ] 23079:20120620:143254.433 query [txnlev:1] [insert into trigger_discovery (triggerdiscoveryid,triggerid,parent_triggerid,name) values (13,221171,221158,'Free disk space is less than 10% on volume {#FSNAME}'), (14,221172,221158,'Free disk space is less than 10% on volume {#FSNAME}'); ] 23079:20120620:143254.433 query [txnlev:1] [insert into functions (functionid,itemid,triggerid,function,parameter) values (15209,26700,221171,'last','0'),(15210,26701,221172,'last','0'); ] 23079:20120620:143254.433 End of DBlld_update_triggers() 23079:20120620:143254.433 In DBlld_update_graphs() 23079:20120620:143254.433 query [txnlev:1] [select distinct g.graphid,g.name,g.width,g.height,g.yaxismin,g.yaxismax,g.show_work_period,g.show_triggers,g.graphtype,g.show_legend,g.show_3d,g.percent_left,g.percent_right,g.ymin_type,i1.itemid,i1.flags,i1.key_,g.ymax_type,i2.itemid,i2.flags,i2.key_ from item_discovery id,items i,graphs_items gi,graphs g left join items i1 on i1.itemid=g.ymin_itemid left join items i2 on i2.itemid=g.ymax_itemid where id.itemid=i.itemid and i.itemid=gi.itemid and gi.graphid=g.graphid and id.parent_itemid=26694] 23079:20120620:143254.433 End of DBlld_update_graphs() 23079:20120620:143254.433 In DBlld_remove_lost_resources() lifetime:30 23079:20120620:143254.433 query [txnlev:1] [select id2.itemdiscoveryid,id2.itemid,id2.lastcheck,id2.ts_delete from item_discovery id1,item_discovery id2 where id1.itemid=id2.parent_itemid and id1.parent_itemid=26694 and id2.lastcheck<1340191974] 23079:20120620:143254.433 In DBdelete_items() values_num:0 23079:20120620:143254.433 End of DBdelete_items() 23079:20120620:143254.433 End of DBlld_remove_lost_resources() 23079:20120620:143254.433 query [txnlev:1] [update items set lastclock=1340191974,lastns=424037587 where itemid=26694] 23079:20120620:143254.434 query [txnlev:1] [commit;] 23079:20120620:143254.435 End of DBlld_process_discovery_rule() 23079:20120620:143254.435 End of get_values():1 23079:20120620:143254.435 poller #1 spent 0.019496 seconds while updating 1 values 23079:20120620:143254.435 In DCconfig_get_poller_nextcheck() poller_type:0 23079:20120620:143254.435 End of DCconfig_get_poller_nextcheck():1340192034 23079:20120620:143254.435 sleeping for 5 seconds