24270:20130629:020759.633 proxy #1 started [configuration syncer #1]
 24270:20130629:020759.670 In process_configuration_sync()
 24270:20130629:020810.176 Received configuration data from server. Datalen 54271872
 24270:20130629:020810.439 In process_proxyconfig_table() table:'globalmacro'
 24270:20130629:020810.439 ZBX-6630 Start reading table [globalmacro] into memory
 24270:20130629:020810.439 ZBX-6630 Start sorting vector del
 24270:20130629:020810.439 ZBX-6630 Is it special table ?
 24270:20130629:020810.439 ZBX-6630 Start checking add/del/update
 24270:20130629:020810.439 ZBX-6630 Start sorting vector ins
 24270:20130629:020810.439 ZBX-6630 Start moving records (3 special tables only)
 24270:20130629:020810.439 ZBX-6630 Start actual update/insert
 24270:20130629:020810.439 ZBX-6630 Succeeded. Start freeing memory
 24270:20130629:020810.439 End of process_proxyconfig_table():SUCCEED
 24270:20130629:020810.440 In process_proxyconfig_table() table:'hosts'
 24270:20130629:020810.440 ZBX-6630 Start reading table [hosts] into memory
 24270:20130629:020810.446 ZBX-6630 Start sorting vector del
 24270:20130629:020810.446 ZBX-6630 Is it special table ?
 24270:20130629:020810.446 ZBX-6630 Start checking add/del/update
 24270:20130629:020810.449 ZBX-6630 Start sorting vector ins
 24270:20130629:020810.449 ZBX-6630 Start moving records (3 special tables only)
 24270:20130629:020810.449 ZBX-6630 Start actual update/insert
 24270:20130629:020810.451 ZBX-6630 Succeeded. Start freeing memory
 24270:20130629:020810.451 End of process_proxyconfig_table():SUCCEED
 24270:20130629:020810.452 In process_proxyconfig_table() table:'interface'
 24270:20130629:020810.452 ZBX-6630 Start reading table [interface] into memory
 24270:20130629:020810.460 ZBX-6630 Start sorting vector del
 24270:20130629:020810.460 ZBX-6630 Is it special table ?
 24270:20130629:020810.460 ZBX-6630 Start checking add/del/update
 24270:20130629:020810.463 ZBX-6630 Start sorting vector ins
 24270:20130629:020810.463 ZBX-6630 Start moving records (3 special tables only)
 24270:20130629:020810.463 ZBX-6630 Start actual update/insert
 24270:20130629:020810.467 ZBX-6630 Succeeded. Start freeing memory
 24270:20130629:020810.468 End of process_proxyconfig_table():SUCCEED
 24270:20130629:020810.468 In process_proxyconfig_table() table:'hosts_templates'
 24270:20130629:020810.469 ZBX-6630 Start reading table [hosts_templates] into memory
 24270:20130629:020810.485 ZBX-6630 Start sorting vector del
 24270:20130629:020810.485 ZBX-6630 Is it special table ?
 24270:20130629:020810.485 ZBX-6630 Start checking add/del/update
 24270:20130629:020810.501 ZBX-6630 Start sorting vector ins
 24270:20130629:020810.501 ZBX-6630 Start moving records (3 special tables only)
 24270:20130629:020810.501 ZBX-6630 Start actual update/insert
 24270:20130629:020810.506 ZBX-6630 Succeeded. Start freeing memory
 24270:20130629:020810.506 End of process_proxyconfig_table():SUCCEED
 24270:20130629:020810.506 In process_proxyconfig_table() table:'hostmacro'
 24270:20130629:020810.506 ZBX-6630 Start reading table [hostmacro] into memory
 24270:20130629:020810.506 ZBX-6630 Start sorting vector del
 24270:20130629:020810.506 ZBX-6630 Is it special table ?
 24270:20130629:020810.506 ZBX-6630 Start checking add/del/update
 24270:20130629:020810.506 ZBX-6630 Start sorting vector ins
 24270:20130629:020810.506 ZBX-6630 Start moving records (3 special tables only)
 24270:20130629:020810.506 ZBX-6630 Start actual update/insert
 24270:20130629:020810.506 ZBX-6630 Succeeded. Start freeing memory
 24270:20130629:020810.506 End of process_proxyconfig_table():SUCCEED
 24270:20130629:020810.579 In process_proxyconfig_table() table:'items'
 24270:20130629:020810.650 ZBX-6630 Start reading table [items] into memory
 24270:20130629:020812.607 slow query: 1.956635 sec, "select itemid,type,snmp_community,snmp_oid,hostid,key_,delay,status,value_type,trapper_hosts,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 from items"
 24270:20130629:020813.230 ZBX-6630 Start sorting vector del
 24270:20130629:020813.342 ZBX-6630 Is it special table ?
 24270:20130629:020813.342 ZBX-6630 Start checking add/del/update
 24270:20130629:020838.915 ZBX-6630 Start sorting vector ins
 24270:20130629:020838.915 ZBX-6630 Start moving records (3 special tables only)
 24270:20130629:020838.915 ZBX-6630 Start actual update/insert
 24270:20130629:020840.278 ZBX-6630 Succeeded. Start freeing memory
 24270:20130629:020840.304 End of process_proxyconfig_table():SUCCEED
 24270:20130629:020840.378 In process_proxyconfig_table() table:'drules'
 24270:20130629:020840.408 ZBX-6630 Start reading table [drules] into memory
 24270:20130629:020840.408 ZBX-6630 Start sorting vector del
 24270:20130629:020840.408 ZBX-6630 Is it special table ?
 24270:20130629:020840.408 ZBX-6630 Start checking add/del/update
 24270:20130629:020840.408 ZBX-6630 Start sorting vector ins
 24270:20130629:020840.409 ZBX-6630 Start moving records (3 special tables only)
 24270:20130629:020840.409 ZBX-6630 Start actual update/insert
 24270:20130629:020840.409 ZBX-6630 Succeeded. Start freeing memory
 24270:20130629:020840.409 End of process_proxyconfig_table():SUCCEED
 24270:20130629:020840.409 In process_proxyconfig_table() table:'dchecks'
 24270:20130629:020840.409 ZBX-6630 Start reading table [dchecks] into memory
 24270:20130629:020840.409 ZBX-6630 Start sorting vector del
 24270:20130629:020840.409 ZBX-6630 Is it special table ?
 24270:20130629:020840.409 ZBX-6630 Start checking add/del/update
 24270:20130629:020840.409 ZBX-6630 Start sorting vector ins
 24270:20130629:020840.409 ZBX-6630 Start moving records (3 special tables only)
 24270:20130629:020840.409 ZBX-6630 Start actual update/insert
 24270:20130629:020840.409 ZBX-6630 Succeeded. Start freeing memory
 24270:20130629:020840.409 End of process_proxyconfig_table():SUCCEED
 24270:20130629:020840.409 In process_proxyconfig_table() table:'regexps'
 24270:20130629:020840.409 ZBX-6630 Start reading table [regexps] into memory
 24270:20130629:020840.409 ZBX-6630 Start sorting vector del
 24270:20130629:020840.409 ZBX-6630 Is it special table ?
 24270:20130629:020840.409 ZBX-6630 Start checking add/del/update
 24270:20130629:020840.409 ZBX-6630 Start sorting vector ins
 24270:20130629:020840.409 ZBX-6630 Start moving records (3 special tables only)
 24270:20130629:020840.409 ZBX-6630 Start actual update/insert
 24270:20130629:020840.409 ZBX-6630 Succeeded. Start freeing memory
 24270:20130629:020840.409 End of process_proxyconfig_table():SUCCEED
 24270:20130629:020840.409 In process_proxyconfig_table() table:'expressions'
 24270:20130629:020840.409 ZBX-6630 Start reading table [expressions] into memory
 24270:20130629:020840.409 ZBX-6630 Start sorting vector del
 24270:20130629:020840.409 ZBX-6630 Is it special table ?
 24270:20130629:020840.409 ZBX-6630 Start checking add/del/update
 24270:20130629:020840.409 ZBX-6630 Start sorting vector ins
 24270:20130629:020840.409 ZBX-6630 Start moving records (3 special tables only)
 24270:20130629:020840.409 ZBX-6630 Start actual update/insert
 24270:20130629:020840.409 ZBX-6630 Succeeded. Start freeing memory
 24270:20130629:020840.409 End of process_proxyconfig_table():SUCCEED
 24270:20130629:020840.409 In process_proxyconfig_table() table:'groups'
 24270:20130629:020840.409 ZBX-6630 Start reading table [groups] into memory
 24270:20130629:020840.409 ZBX-6630 Start sorting vector del
 24270:20130629:020840.409 ZBX-6630 Is it special table ?
 24270:20130629:020840.409 ZBX-6630 Start checking add/del/update
 24270:20130629:020840.409 ZBX-6630 Start sorting vector ins
 24270:20130629:020840.409 ZBX-6630 Start moving records (3 special tables only)
 24270:20130629:020840.409 ZBX-6630 Start actual update/insert
 24270:20130629:020840.409 ZBX-6630 Succeeded. Start freeing memory
 24270:20130629:020840.409 End of process_proxyconfig_table():SUCCEED
 24270:20130629:020840.409 In process_proxyconfig_table() table:'config'
 24270:20130629:020840.409 ZBX-6630 Start reading table [config] into memory
 24270:20130629:020840.409 ZBX-6630 Start sorting vector del
 24270:20130629:020840.409 ZBX-6630 Is it special table ?
 24270:20130629:020840.409 ZBX-6630 Start checking add/del/update
 24270:20130629:020840.409 ZBX-6630 Start sorting vector ins
 24270:20130629:020840.409 ZBX-6630 Start moving records (3 special tables only)
 24270:20130629:020840.409 ZBX-6630 Start actual update/insert
 24270:20130629:020840.409 ZBX-6630 Succeeded. Start freeing memory
 24270:20130629:020840.409 End of process_proxyconfig_table():SUCCEED
 24270:20130629:020840.409 In process_proxyconfig_table() table:'applications'
 24270:20130629:020840.409 ZBX-6630 Start reading table [applications] into memory
 24270:20130629:020840.409 ZBX-6630 Start sorting vector del
 24270:20130629:020840.409 ZBX-6630 Is it special table ?
 24270:20130629:020840.409 ZBX-6630 Start checking add/del/update
 24270:20130629:020840.409 ZBX-6630 Start sorting vector ins
 24270:20130629:020840.409 ZBX-6630 Start moving records (3 special tables only)
 24270:20130629:020840.409 ZBX-6630 Start actual update/insert
 24270:20130629:020840.409 ZBX-6630 Succeeded. Start freeing memory
 24270:20130629:020840.409 End of process_proxyconfig_table():SUCCEED
 24270:20130629:020840.409 In process_proxyconfig_table() table:'httptest'
 24270:20130629:020840.409 ZBX-6630 Start reading table [httptest] into memory
 24270:20130629:020840.409 ZBX-6630 Start sorting vector del
 24270:20130629:020840.409 ZBX-6630 Is it special table ?
 24270:20130629:020840.409 ZBX-6630 Start checking add/del/update
 24270:20130629:020840.409 ZBX-6630 Start sorting vector ins
 24270:20130629:020840.409 ZBX-6630 Start moving records (3 special tables only)
 24270:20130629:020840.409 ZBX-6630 Start actual update/insert
 24270:20130629:020840.410 ZBX-6630 Succeeded. Start freeing memory
 24270:20130629:020840.410 End of process_proxyconfig_table():SUCCEED
 24270:20130629:020840.410 In process_proxyconfig_table() table:'httptestitem'
 24270:20130629:020840.410 ZBX-6630 Start reading table [httptestitem] into memory
 24270:20130629:020840.410 ZBX-6630 Start sorting vector del
 24270:20130629:020840.410 ZBX-6630 Is it special table ?
 24270:20130629:020840.410 ZBX-6630 Start checking add/del/update
 24270:20130629:020840.410 ZBX-6630 Start sorting vector ins
 24270:20130629:020840.410 ZBX-6630 Start moving records (3 special tables only)
 24270:20130629:020840.410 ZBX-6630 Start actual update/insert
 24270:20130629:020840.410 ZBX-6630 Succeeded. Start freeing memory
 24270:20130629:020840.410 End of process_proxyconfig_table():SUCCEED
 24270:20130629:020840.410 In process_proxyconfig_table() table:'httpstep'
 24270:20130629:020840.410 ZBX-6630 Start reading table [httpstep] into memory
 24270:20130629:020840.410 ZBX-6630 Start sorting vector del
 24270:20130629:020840.410 ZBX-6630 Is it special table ?
 24270:20130629:020840.410 ZBX-6630 Start checking add/del/update
 24270:20130629:020840.410 ZBX-6630 Start sorting vector ins
 24270:20130629:020840.410 ZBX-6630 Start moving records (3 special tables only)
 24270:20130629:020840.410 ZBX-6630 Start actual update/insert
 24270:20130629:020840.410 ZBX-6630 Succeeded. Start freeing memory
 24270:20130629:020840.410 End of process_proxyconfig_table():SUCCEED
 24270:20130629:020840.410 In process_proxyconfig_table() table:'httpstepitem'
 24270:20130629:020840.410 ZBX-6630 Start reading table [httpstepitem] into memory
 24270:20130629:020840.410 ZBX-6630 Start sorting vector del
 24270:20130629:020840.410 ZBX-6630 Is it special table ?
 24270:20130629:020840.410 ZBX-6630 Start checking add/del/update
 24270:20130629:020840.410 ZBX-6630 Start sorting vector ins
 24270:20130629:020840.410 ZBX-6630 Start moving records (3 special tables only)
 24270:20130629:020840.410 ZBX-6630 Start actual update/insert
 24270:20130629:020840.410 ZBX-6630 Succeeded. Start freeing memory
 24270:20130629:020840.410 End of process_proxyconfig_table():SUCCEED
 24270:20130629:020842.672 slow query: 2.177577 sec, "select i.itemid,i.hostid,h.proxy_hostid,i.type,i.data_type,i.value_type,i.key_,i.snmp_community,i.snmp_oid,i.port,i.snmpv3_securityname,i.snmpv3_securitylevel,i.snmpv3_authpassphrase,i.snmpv3_privpassphrase,i.ipmi_sensor,i.delay,i.delay_flex,i.trapper_hosts,i.logtimefmt,i.params,i.status,i.authtype,i.username,i.password,i.publickey,i.privatekey,i.flags,i.interfaceid,i.lastclock from items i,hosts h where i.hostid=h.hostid and h.status in (0) and i.status in (0,3)"
 24270:20130629:020844.918 End of process_configuration_sync()