3654:20180125:160003.089 In DCconfig_get_poller_items() poller_type:0
  3655:20180125:160003.089 In substitute_key_macros() data:'db.odbc.discovery[databases_discovery,{$DSN}]'
  3653:20180125:160003.089 In DCconfig_get_poller_nextcheck() poller_type:0
  3654:20180125:160003.089 End of DCconfig_get_poller_items():0
  3655:20180125:160003.089 In substitute_simple_macros() data:'{$DSN}'
  3653:20180125:160003.090 End of DCconfig_get_poller_nextcheck():-1
  3654:20180125:160003.090 In DCconfig_get_poller_nextcheck() poller_type:0
  3653:20180125:160003.090 End of get_values():0
  3655:20180125:160003.090 In DCget_user_macro() macro:'{$DSN}'
  3654:20180125:160003.090 End of DCconfig_get_poller_nextcheck():-1
  3653:20180125:160003.090 __zbx_zbx_setproctitle() title:'poller #3 [got 0 values in 0.001185 sec, idle 5 sec]'
  3655:20180125:160003.090 End of DCget_user_macro()
  3654:20180125:160003.090 End of get_values():0
  3655:20180125:160003.090 End substitute_simple_macros() data:'my-server-name'
  3654:20180125:160003.090 __zbx_zbx_setproctitle() title:'poller #4 [got 0 values in 0.001440 sec, idle 5 sec]'
  3655:20180125:160003.090 End of substitute_key_macros():SUCCEED data:'db.odbc.discovery[databases_discovery,my-server-name]'
  3655:20180125:160003.091 In substitute_simple_macros() data:'SELECT DBName as DBNAME, LogBStartTime as STARTTIME FROM monDBRecovery;'
  3655:20180125:160003.091 In substitute_simple_macros() data:'username'
  3655:20180125:160003.091 In substitute_simple_macros() data:'password'
  3655:20180125:160003.091 In get_value() key:'db.odbc.discovery[databases_discovery,{$DSN}]'
  3655:20180125:160003.091 In get_value_db() key_orig:'db.odbc.discovery[databases_discovery,{$DSN}]'
  3655:20180125:160003.091 In db_odbc_discovery() query:'SELECT DBName as DBNAME, LogBStartTime as STARTTIME FROM monDBRecovery;'
  3655:20180125:160003.091 In odbc_DBconnect() db_dsn:'my-server-name' user:'username'
  3652:20180125:160003.092 __zbx_zbx_setproctitle() title:'poller #2 [got 0 values in 0.000551 sec, getting values]'
  3652:20180125:160003.092 In get_values()
  3652:20180125:160003.092 In DCconfig_get_poller_items() poller_type:0
  3652:20180125:160003.092 End of DCconfig_get_poller_items():0
  3652:20180125:160003.092 In DCconfig_get_poller_nextcheck() poller_type:0
  3652:20180125:160003.093 End of DCconfig_get_poller_nextcheck():-1
  3652:20180125:160003.093 End of get_values():0
  3652:20180125:160003.093 __zbx_zbx_setproctitle() title:'poller #2 [got 0 values in 0.000392 sec, idle 5 sec]'
  3651:20180125:160003.094 __zbx_zbx_setproctitle() title:'poller #1 [got 0 values in 0.000318 sec, getting values]'
  3651:20180125:160003.094 In get_values()
  3651:20180125:160003.094 In DCconfig_get_poller_items() poller_type:0
  3651:20180125:160003.094 End of DCconfig_get_poller_items():0
  3651:20180125:160003.094 In DCconfig_get_poller_nextcheck() poller_type:0
  3651:20180125:160003.094 End of DCconfig_get_poller_nextcheck():-1
  3651:20180125:160003.094 End of get_values():0
  3651:20180125:160003.094 __zbx_zbx_setproctitle() title:'poller #1 [got 0 values in 0.000364 sec, idle 5 sec]'
  3649:20180125:160003.099 __zbx_zbx_setproctitle() title:'self-monitoring [processing data]'
  3649:20180125:160003.099 In collect_selfmon_stats()
  3649:20180125:160003.099 End of collect_selfmon_stats()
  3649:20180125:160003.099 __zbx_zbx_setproctitle() title:'self-monitoring [processed data in 0.000082 sec, idle 1 sec]'
  3644:20180125:160003.101 __zbx_zbx_setproctitle() title:'history syncer #2 [synced 0 items in 0.000135 sec, syncing history]'
  3644:20180125:160003.101 In DCsync_history() history_num:0
  3644:20180125:160003.101 In zbx_flush_correlated_events() events_num:0
  3644:20180125:160003.101 End of zbx_flush_correlated_events() events_num:0
  3644:20180125:160003.101 __zbx_zbx_setproctitle() title:'history syncer #2 [synced 0 items in 0.000050 sec, idle 1 sec]'
  3646:20180125:160003.102 __zbx_zbx_setproctitle() title:'history syncer #4 [synced 0 items in 0.000130 sec, syncing history]'
  3646:20180125:160003.102 In DCsync_history() history_num:0
  3646:20180125:160003.102 In zbx_flush_correlated_events() events_num:0
  3646:20180125:160003.102 End of zbx_flush_correlated_events() events_num:0
  3646:20180125:160003.102 __zbx_zbx_setproctitle() title:'history syncer #4 [synced 0 items in 0.000046 sec, idle 1 sec]'
  3643:20180125:160003.102 __zbx_zbx_setproctitle() title:'history syncer #1 [synced 0 items in 0.000085 sec, syncing history]'
  3645:20180125:160003.103 __zbx_zbx_setproctitle() title:'history syncer #3 [synced 0 items in 0.000256 sec, syncing history]'
  3643:20180125:160003.103 In DCsync_history() history_num:0
  3645:20180125:160003.103 In DCsync_history() history_num:0
  3643:20180125:160003.103 In zbx_flush_correlated_events() events_num:0
  3645:20180125:160003.103 In zbx_flush_correlated_events() events_num:0
  3643:20180125:160003.103 End of zbx_flush_correlated_events() events_num:0
  3645:20180125:160003.103 End of zbx_flush_correlated_events() events_num:0
  3643:20180125:160003.103 __zbx_zbx_setproctitle() title:'history syncer #1 [synced 0 items in 0.000400 sec, idle 1 sec]'
  3645:20180125:160003.103 __zbx_zbx_setproctitle() title:'history syncer #3 [synced 0 items in 0.000331 sec, idle 1 sec]'
  3655:20180125:160003.115 odbc_Diag(): rc_msg:'SQL_SUCCESS_WITH_INFO' rec_nr:1 sql_state:'ZZZZZ' native_err_code:5704 err_msg:'[unixODBC][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Changed client character set setting to '<NULL>'.
'
  3655:20180125:160003.115 odbc_Diag(): rc_msg:'SQL_SUCCESS_WITH_INFO' rec_nr:2 sql_state:'ZZZZZ' native_err_code:5701 err_msg:'[unixODBC][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Changed database context to 'master'.
'
  3655:20180125:160003.115 odbc_Diag(): rc_msg:'SQL_SUCCESS_WITH_INFO' rec_nr:3 sql_state:'ZZZZZ' native_err_code:5703 err_msg:'[unixODBC][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Changed language setting to 'us_english'.
'
  3655:20180125:160003.115 odbc_Diag(): rc_msg:'SQL_SUCCESS_WITH_INFO' rec_nr:4 sql_state:'ZZZZZ' native_err_code:5701 err_msg:'[unixODBC][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Changed database context to 'master'.
'
  3655:20180125:160003.115 odbc_Diag(): rc_msg:'SQL_SUCCESS_WITH_INFO' rec_nr:5 sql_state:'ZZZZZ' native_err_code:5704 err_msg:'[SAP][ASE ODBC Driver][Adaptive Server Enterprise]Changed client character set setting to '<NULL>'.
'
  3655:20180125:160003.115 odbc_Diag(): rc_msg:'SQL_SUCCESS_WITH_INFO' rec_nr:6 sql_state:'ZZZZZ' native_err_code:5701 err_msg:'[SAP][ASE ODBC Driver][Adaptive Server Enterprise]Changed database context to 'master'.
'
  3655:20180125:160003.115 odbc_Diag(): rc_msg:'SQL_SUCCESS_WITH_INFO' rec_nr:7 sql_state:'ZZZZZ' native_err_code:5703 err_msg:'[SAP][ASE ODBC Driver][Adaptive Server Enterprise]Changed language setting to 'us_english'.
'
  3655:20180125:160003.115 odbc_Diag(): rc_msg:'SQL_SUCCESS_WITH_INFO' rec_nr:8 sql_state:'ZZZZZ' native_err_code:5701 err_msg:'[SAP][ASE ODBC Driver][Adaptive Server Enterprise]Changed database context to 'master'.
'
  3655:20180125:160003.117 odbc_DBconnect() connected to SQL Server(15.7.0) using Adaptive Server Enterprise (ANSI)(16.0.00.01)
  3655:20180125:160003.117 End of odbc_DBconnect():SUCCEED
  3655:20180125:160003.117 In odbc_DBselect() query:'SELECT DBName as DBNAME, LogBStartTime as STARTTIME FROM monDBRecovery;'
  3655:20180125:160003.118 odbc_DBselect() selected 2 columns
  3655:20180125:160003.118 End of odbc_DBselect()
  3655:20180125:160003.118 db_odbc_discovery() column[1]:'DBNAME'
  3655:20180125:160003.118 db_odbc_discovery() column[2]:'STARTTIME'
  3655:20180125:160003.118 In odbc_DBfetch()
  3655:20180125:160003.118 End of odbc_DBfetch()
  3655:20180125:160003.119 End of db_odbc_discovery():SUCCEED
  3655:20180125:160003.119 End of get_value_db():SUCCEED
  3655:20180125:160003.119 End of get_value():SUCCEED
  3655:20180125:160003.119 In zbx_activate_item_host() hostid:10304 itemid:30063 type:11
  3655:20180125:160003.120 End of zbx_activate_item_host()
  3655:20180125:160003.120 In zbx_preprocess_item_value()
  3655:20180125:160003.120 In lld_process_discovery_rule() itemid:30063
  3655:20180125:160003.120 query [txnlev:0] [select hostid,key_,state,evaltype,formula,error,lifetime from items where itemid=30063]
  3655:20180125:160003.123 In substitute_simple_macros() data:'30d'
  3655:20180125:160003.123 query [txnlev:0] [select item_conditionid,macro,value from item_condition where itemid=30063]
  3655:20180125:160003.124 In lld_rows_get()
  3655:20180125:160003.124 End of lld_rows_get():SUCCEED
  3655:20180125:160003.124 In lld_update_items()
  3655:20180125:160003.124 In lld_item_prototypes_get()
  3655:20180125:160003.124 query [txnlev:0] [select i.itemid,i.name,i.key_,i.type,i.value_type,i.delay,i.history,i.trends,i.status,i.trapper_hosts,i.units,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_authprotocol,i.snmpv3_authpassphrase,i.snmpv3_privprotocol,i.snmpv3_privpassphrase,i.authtype,i.username,i.password,i.publickey,i.privatekey,i.description,i.interfaceid,i.snmpv3_contextname,i.jmx_endpoint,i.master_itemid from items i,item_discovery id where i.itemid=id.itemid and id.parent_itemid=30063]
  3655:20180125:160003.126 query [txnlev:0] [select ip.itemid,ip.step,ip.type,ip.params from item_preproc ip,item_discovery id where ip.itemid=id.itemid and id.parent_itemid=30063]
  3655:20180125:160003.128 End of lld_item_prototypes_get():1 prototypes
  3655:20180125:160003.128 In lld_application_prototypes_get()
  3655:20180125:160003.128 query [txnlev:0] [select application_prototypeid,name from application_prototype where itemid=30063]
  3655:20180125:160003.129 End of lld_application_prototypes_get():0 prototypes
  3655:20180125:160003.129 In lld_applications_get()
  3655:20180125:160003.129 query [txnlev:0] [select a.applicationid,a.name,ap.application_prototypeid,ad.lastcheck,ad.ts_delete,ad.name,ad.application_discoveryid from applications a,application_discovery ad,application_prototype ap where ap.itemid=30063 and ad.application_prototypeid=ap.application_prototypeid and a.applicationid=ad.applicationid]
  3655:20180125:160003.131 End of lld_applications_get():0 applications
  3655:20180125:160003.131 In lld_applications_make()
  3655:20180125:160003.131 End of lld_applications_make():0 applications
  3655:20180125:160003.131 In lld_applications_validate()
  3655:20180125:160003.131 End of lld_applications_validate()
  3655:20180125:160003.131 In lld_item_application_prototypes_get()
  3655:20180125:160003.131 query [txnlev:0] [select application_prototypeid,itemid from item_application_prototype where itemid=30064]
  3655:20180125:160003.133 query [txnlev:0] [select applicationid,itemid from items_applications where itemid=30064]
  3655:20180125:160003.134 End of lld_item_application_prototypes_get()
  3655:20180125:160003.134 In lld_items_get()
  3655:20180125:160003.134 query [txnlev:0] [select id.itemid,id.key_,id.lastcheck,id.ts_delete,i.name,i.key_,i.type,i.value_type,i.delay,i.history,i.trends,i.trapper_hosts,i.units,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_authprotocol,i.snmpv3_authpassphrase,i.snmpv3_privprotocol,i.snmpv3_privpassphrase,i.authtype,i.username,i.password,i.publickey,i.privatekey,i.description,i.interfaceid,i.snmpv3_contextname,i.jmx_endpoint,i.master_itemid,id.parent_itemid from item_discovery id join items i on id.itemid=i.itemid where id.parent_itemid=30064]
  3655:20180125:160003.135 End of lld_items_get()
  3655:20180125:160003.135 In lld_items_make()
  3655:20180125:160003.135 End of lld_items_make():0 items
  3655:20180125:160003.135 In lld_items_validate()
  3655:20180125:160003.135 End of lld_items_validate()
  3655:20180125:160003.135 In lld_items_applications_get()
  3655:20180125:160003.135 query [txnlev:0] [select ia.itemappid,ia.itemid,ia.applicationid from items_applications ia,item_discovery id1,item_discovery id2 where id1.itemid=ia.itemid and id1.parent_itemid=id2.itemid and id2.parent_itemid=30063]
  3655:20180125:160003.136 End of lld_items_applications_get():0 links
  3655:20180125:160003.136 In lld_items_applications_make()
  3655:20180125:160003.136 End of lld_items_applications_make():0 links
  3655:20180125:160003.136 In lld_link_dependent_items()
  3655:20180125:160003.136 End of lld_link_dependent_items()
  3655:20180125:160003.136 query [txnlev:1] [begin;]
  3655:20180125:160003.137 In lld_items_save()
  3655:20180125:160003.137 End of lld_items_save()
  3655:20180125:160003.137 In lld_items_preproc_save()
  3655:20180125:160003.137 End of lld_items_preproc_save() added:0 updated:0 removed:0
  3655:20180125:160003.137 In lld_applications_save()
  3655:20180125:160003.137 End of lld_applications_save()
  3655:20180125:160003.137 In lld_items_applications_save()
  3655:20180125:160003.137 End of lld_items_applications_save()
  3655:20180125:160003.137 query [txnlev:1] [commit;]
  3655:20180125:160003.137 In lld_remove_lost_items()
  3655:20180125:160003.137 End of lld_remove_lost_items()
  3655:20180125:160003.137 In lld_remove_lost_applications()
  3655:20180125:160003.137 End of lld_remove_lost_applications()
  3655:20180125:160003.137 End of lld_update_items()
  3655:20180125:160003.138 In lld_update_triggers()
  3655:20180125:160003.138 query [txnlev:0] [select distinct t.triggerid,t.description,t.expression,t.status,t.type,t.priority,t.comments,t.url,t.recovery_expression,t.recovery_mode,t.correlation_mode,t.correlation_tag,t.manual_close 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=30063]
  3655:20180125:160003.142 End of lld_update_triggers()
  3655:20180125:160003.142 In lld_update_graphs()
  3655:20180125:160003.142 query [txnlev:0] [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,g.ymin_itemid,g.ymax_type,g.ymax_itemid from graphs g,graphs_items gi,items i,item_discovery id where g.graphid=gi.graphid and gi.itemid=i.itemid and i.itemid=id.itemid and id.parent_itemid=30063]
  3655:20180125:160003.145 End of lld_update_graphs()
  3655:20180125:160003.145 In lld_update_hosts()
  3655:20180125:160003.145 query [txnlev:0] [select h.proxy_hostid,h.ipmi_authtype,h.ipmi_privilege,h.ipmi_username,h.ipmi_password,h.tls_connect,h.tls_accept,h.tls_issuer,h.tls_subject,h.tls_psk_identity,h.tls_psk from hosts h,items i where h.hostid=i.hostid and i.itemid=30063]
  3655:20180125:160003.147 query [txnlev:0] [select hi.interfaceid,hi.type,hi.main,hi.useip,hi.ip,hi.dns,hi.port,hi.bulk from interface hi,items i where hi.hostid=i.hostid and i.itemid=30063]
  3655:20180125:160003.148 In lld_hostmacros_get()
  3655:20180125:160003.148 query [txnlev:0] [select hm.macro,hm.value from hostmacro hm,items i where hm.hostid=i.hostid and i.itemid=30063]
  3647:20180125:160003.148 __zbx_zbx_setproctitle() title:'escalator #1 [processed 0 escalations in 0.003760 sec, processing escalations]'
  3647:20180125:160003.148 In process_escalations()
  3647:20180125:160003.148 query [txnlev:0] [select escalationid,actionid,triggerid,eventid,r_eventid,nextcheck,esc_step,status,itemid,acknowledgeid from escalations where triggerid is not null order by actionid,triggerid,itemid,escalationid]
  3655:20180125:160003.149 End of lld_hostmacros_get()
  3655:20180125:160003.150 query [txnlev:0] [select h.hostid,h.host,h.name,h.status,hi.inventory_mode from hosts h,host_discovery hd left join host_inventory hi on hd.hostid=hi.hostid where h.hostid=hd.hostid and hd.parent_itemid=30063]
  3647:20180125:160003.150 End of process_escalations()
  3647:20180125:160003.150 In process_escalations()
  3647:20180125:160003.150 query [txnlev:0] [select escalationid,actionid,triggerid,eventid,r_eventid,nextcheck,esc_step,status,itemid,acknowledgeid from escalations where itemid is not null order by actionid,triggerid,itemid,escalationid]
  3647:20180125:160003.151 End of process_escalations()
  3647:20180125:160003.151 In process_escalations()
  3647:20180125:160003.151 query [txnlev:0] [select escalationid,actionid,triggerid,eventid,r_eventid,nextcheck,esc_step,status,itemid,acknowledgeid from escalations where triggerid is null and itemid is null order by actionid,triggerid,itemid,escalationid]
  3655:20180125:160003.152 End of lld_update_hosts()
  3655:20180125:160003.152 End of lld_process_discovery_rule()
  3655:20180125:160003.152 End of zbx_preprocess_item_value()
  3655:20180125:160003.152 End of get_values():1
  3655:20180125:160003.152 __zbx_zbx_setproctitle() title:'poller #5 [got 1 values in 0.063839 sec, idle 5 sec]'
  3647:20180125:160003.152 End of process_escalations()
  3647:20180125:160003.152 __zbx_zbx_setproctitle() title:'escalator #1 [processed 0 escalations in 0.003848 sec, idle 3 sec]'
  3664:20180125:160003.575 End of zbx_ipc_service_recv():2
  3664:20180125:160003.575 In zbx_ipc_service_recv() timeout:1
  3663:20180125:160003.852 End of zbx_ipc_service_recv():2
  3663:20180125:160003.852 In am_db_flush_alert_updates() updates:0
  3663:20180125:160003.852 End of am_db_flush_alert_updates():SUCCEED
  3663:20180125:160003.852 In am_db_queue_alerts()
  3663:20180125:160003.852 In am_db_get_alerts()
  3663:20180125:160003.852 query [txnlev:0] [select a.alertid,a.mediatypeid,a.sendto,a.subject,a.message,a.status,a.retries,e.source,e.object,e.objectid from alerts a left join events e on a.eventid=e.eventid where alerttype=0 and a.status=3 order by a.alertid]
  3663:20180125:160003.855 End of am_db_get_alerts() alerts:0
  3663:20180125:160003.856 End of am_db_queue_alerts():SUCCEED