19356:20140305:035855.809 Starting Zabbix Proxy (active) [test-mon-master]. Zabbix 2.0.5 (revision 33558).
 19356:20140305:035855.809 **** Enabled features ****
 19356:20140305:035855.809 SNMP monitoring:       YES
 19356:20140305:035855.809 IPMI monitoring:       YES
 19356:20140305:035855.810 WEB monitoring:        YES
 19356:20140305:035855.810 ODBC:                   NO
 19356:20140305:035855.810 SSH2 support:          YES
 19356:20140305:035855.810 IPv6 support:          YES
 19356:20140305:035855.810 **************************
 19356:20140305:035855.810 cannot open database file "/var/lib/zabbix/zabbix_proxy.db": [2] No such file or directory
 19356:20140305:035855.810 creating database ...
 19356:20140305:035855.812 query without transaction detected
 19356:20140305:035855.812 query [txnlev:0] [CREATE TABLE maintenances (
maintenanceid bigint  NOT NULL,
name varchar(128) DEFAULT '' NOT NULL,
maintenance_type integer DEFAULT '0' NOT NULL,
description text DEFAULT '' NOT NULL,
active_since integer DEFAULT '0' NOT NULL,
active_till integer DEFAULT '0' NOT NULL,
PRIMARY KEY (maintenanceid)
);
CREATE INDEX maintenances_1 ON maintenances (active_since,active_till);
CREATE TABLE hosts (
hostid bigint  NOT NULL,
proxy_hostid bigint  NULL REFERENCES hosts (hostid),
host varchar(64) DEFAULT '' NOT NULL,
status integer DEFAULT '0' NOT NULL,
disable_until integer DEFAULT '0' NOT NULL,
error varchar(128) DEFAULT '' NOT NULL,
available integer DEFAULT '0' NOT NULL,
errors_from integer DEFAULT '0' NOT NULL,
lastaccess integer DEFAULT '0' NOT NULL,
ipmi_authtype integer DEFAULT '0' NOT NULL,
ipmi_privilege integer DEFAULT '2' NOT NULL,
ipmi_username varchar(16) DEFAULT '' NOT NULL,
ipmi_password varchar(20) DEFAULT '' NOT NULL,
ipmi_disable_until integer DEFAULT '0' NOT NULL,
ipmi_available integer DEFAULT '0' NOT NULL,
snmp_disable_until integer DEFAULT '0' NOT NULL,
snmp_available integer DEFAULT '0' NOT NULL,
maintenanceid bigint  NULL REFERENCES maintenances (maintenanceid),
maintenance_status integer DEFAULT '0' NOT NULL,
maintenance_type integer DEFAULT '0' NOT NULL,
maintenance_from integer DEFAULT '0' NOT NULL,
ipmi_errors_from integer DEFAULT '0' NOT NULL,
snmp_errors_from integer DEFAULT '0' NOT NULL,
ipmi_error varchar(128) DEFAULT '' NOT NULL,
snmp_error varchar(128) DEFAULT '' NOT NULL,
jmx_disable_until integer DEFAULT '0' NOT NULL,
jmx_available integer DEFAULT '0' NOT NULL,
jmx_errors_from integer DEFAULT '0' NOT NULL,
jmx_error varchar(128) DEFAULT '' NOT NULL,
name varchar(64) DEFAULT '' NOT NULL,
PRIMARY KEY (hostid)
);
CREATE INDEX hosts_1 ON hosts (host);
CREATE INDEX hosts_2 ON hosts (status);
CREATE INDEX hosts_3 ON hosts (proxy_hostid);
CREATE INDEX hosts_4 ON hosts (name);
CREATE TABLE groups (
groupid bigint  NOT NULL,
name varchar(64) DEFAULT '' NOT NULL,
internal integer DEFAULT '0' NOT NULL,
PRIMARY KEY (groupid)
);
CREATE INDEX groups_1 ON groups (name);
CREATE TABLE screens (
screenid bigint  NOT NULL,
name varchar(255)  NOT NULL,
hsize integer DEFAULT '1' NOT NULL,
vsize integer DEFAULT '1' NOT NULL,
templateid bigint  NULL REFERENCES hosts (hostid) ON DELETE CASCADE,
PRIMARY KEY (screenid)
);
CREATE TABLE screens_items (
screenitemid bigint  NOT NULL,
screenid bigint  NOT NULL REFERENCES screens (screenid) ON DELETE CASCADE,
resourcetype integer DEFAULT '0' NOT NULL,
resourceid bigint DEFAULT '0' NOT NULL,
width integer DEFAULT '320' NOT NULL,
height integer DEFAULT '200' NOT NULL,
x integer DEFAULT '0' NOT NULL,
y integer DEFAULT '0' NOT NULL,
colspan integer DEFAULT '0' NOT NULL,
rowspan integer DEFAULT '0' NOT NULL,
elements integer DEFAULT '25' NOT NULL,
valign integer DEFAULT '0' NOT NULL,
halign integer DEFAULT '0' NOT NULL,
style integer DEFAULT '0' NOT NULL,
url varchar(255) DEFAULT '' NOT NULL,
dynamic integer DEFAULT '0' NOT NULL,
sort_triggers integer DEFAULT '0' NOT NULL,
PRIMARY KEY (screenitemid)
);
CREATE TABLE slideshows (
slideshowid bigint  NOT NULL,
name varchar(255) DEFAULT '' NOT NULL,
delay integer DEFAULT '0' NOT NULL,
PRIMARY KEY (slideshowid)
);
CREATE TABLE slides (
slideid bigint  NOT NULL,
slideshowid bigint  NOT NULL REFERENCES slideshows (slideshowid) ON DELETE CASCADE,
screenid bigint  NOT NULL REFERENCES screens (screenid) ON DELETE CASCADE,
step integer DEFAULT '0' NOT NULL,
delay integer DEFAULT '0' NOT NULL,
PRIMARY KEY (slideid)
);
CREATE INDEX slides_slides_1 ON slides (slideshowid);
CREATE TABLE drules (
druleid bigint  NOT NULL,
proxy_hostid bigint  NULL REFERENCES hosts (hostid),
name varchar(255) DEFAULT '' NOT NULL,
iprange varchar(255) DEFAULT '' NOT NULL,
delay integer DEFAULT '3600' NOT NULL,
nextcheck integer DEFAULT '0' NOT NULL,
status integer DEFAULT '0' NOT NULL,
PRIMARY KEY (druleid)
);
CREATE TABLE dchecks (
dcheckid bigint  NOT NULL,
druleid bigint  NOT NULL REFERENCES drules (druleid) ON DELETE CASCADE,
type integer DEFAULT '0' NOT NULL,
key_ varchar(255) DEFAULT '' NOT NULL,
snmp_community varchar(255) DEFAULT '' NOT NULL,
ports varchar(255) DEFAULT '0' NOT NULL,
snmpv3_securityname varchar(64) DEFAULT '' NOT NULL,
snmpv3_securitylevel integer DEFAULT '0' NOT NULL,
snmpv3_authpassphrase varchar(64) DEFAULT '' NOT NULL,
snmpv3_privpassphrase varchar(64) DEFAULT '' NOT NULL,
uniq integer DEFAULT '0' NOT NULL,
PRIMARY KEY (dcheckid)
);
CREATE INDEX dchecks_1 ON dchecks (druleid);
CREATE TABLE applications (
applicationid bigint  NOT NULL,
hostid bigint  NOT NULL REFERENCES hosts (hostid) ON DELETE CASCADE,
name varchar(255) DEFAULT '' NOT NULL,
templateid bigint  NULL REFERENCES applications (applicationid) ON DELETE CASCADE,
PRIMARY KEY (applicationid)
);
CREATE INDEX applications_1 ON applications (templateid);
CREATE UNIQUE INDEX applications_2 ON applications (hostid,name);
CREATE TABLE httptest (
httptestid bigint  NOT NULL,
name varchar(64) DEFAULT '' NOT NULL,
applicationid bigint  NOT NULL REFERENCES applications (applicationid) ON DELETE CASCADE,
nextcheck integer DEFAULT '0' NOT NULL,
delay integer DEFAULT '60' NOT NULL,
status integer DEFAULT '0' NOT NULL,
macros text DEFAULT '' NOT NULL,
agent varchar(255) DEFAULT '' NOT NULL,
authentication integer DEFAULT '0' NOT NULL,
http_user varchar(64) DEFAULT '' NOT NULL,
http_password varchar(64) DEFAULT '' NOT NULL,
PRIMARY KEY (httptestid)
);
CREATE INDEX httptest_httptest_1 ON httptest (applicationid);
CREATE INDEX httptest_2 ON httptest (name);
CREATE INDEX httptest_3 ON httptest (status);
CREATE TABLE httpstep (
httpstepid bigint  NOT NULL,
httptestid bigint  NOT NULL REFERENCES httptest (httptestid) ON DELETE CASCADE,
name varchar(64) DEFAULT '' NOT NULL,
no integer DEFAULT '0' NOT NULL,
url varchar(255) DEFAULT '' NOT NULL,
timeout integer DEFAULT '30' NOT NULL,
posts text DEFAULT '' NOT NULL,
required varchar(255) DEFAULT '' NOT NULL,
status_codes varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (httpstepid)
);
CREATE INDEX httpstep_httpstep_1 ON httpstep (httptestid);
CREATE TABLE interface (
interfaceid bigint  NOT NULL,
hostid bigint  NOT NULL REFERENCES hosts (hostid) ON DELETE CASCADE,
main integer DEFAULT '0' NOT NULL,
type integer DEFAULT '0' NOT NULL,
useip integer DEFAULT '1' NOT NULL,
ip varchar(39) DEFAULT '127.0.0.1' NOT NULL,
dns varchar(64) DEFAULT '' NOT NULL,
port varchar(64) DEFAULT '10050' NOT NULL,
PRIMARY KEY (interfaceid)
);
CREATE INDEX interface_1 ON interface (hostid,type);
CREATE INDEX interface_2 ON interface (ip,dns);
CREATE TABLE valuemaps (
valuemapid bigint  NOT NULL,
name varchar(64) DEFAULT '' NOT NULL,
PRIMARY KEY (valuemapid)
);
CREATE INDEX valuemaps_1 ON valuemaps (name);
CREATE TABLE items (
itemid bigint  NOT NULL,
type integer DEFAULT '0' NOT NULL,
snmp_community varchar(64) DEFAULT '' NOT NULL,
snmp_oid varchar(255) DEFAULT '' NOT NULL,
hostid bigint  NOT NULL REFERENCES hosts (hostid) ON DELETE CASCADE,
name varchar(255) DEFAULT '' NOT NULL,
key_ varchar(255) DEFAULT '' NOT NULL,
delay integer DEFAULT '0' NOT NULL,
history integer DEFAULT '90' NOT NULL,
trends integer DEFAULT '365' NOT NULL,
lastvalue varchar(255)  NULL,
lastclock integer  NULL,
prevvalue varchar(255)  NULL,
status integer DEFAULT '0' NOT NULL,
value_type integer DEFAULT '0' NOT NULL,
trapper_hosts varchar(255) DEFAULT '' NOT NULL,
units varchar(255) DEFAULT '' NOT NULL,
multiplier integer DEFAULT '0' NOT NULL,
delta integer DEFAULT '0' NOT NULL,
prevorgvalue varchar(255)  NULL,
snmpv3_securityname varchar(64) DEFAULT '' NOT NULL,
snmpv3_securitylevel integer DEFAULT '0' NOT NULL,
snmpv3_authpassphrase varchar(64) DEFAULT '' NOT NULL,
snmpv3_privpassphrase varchar(64) DEFAULT '' NOT NULL,
formula varchar(255) DEFAULT '1' NOT NULL,
error varchar(128) DEFAULT '' NOT NULL,
lastlogsize bigint DEFAULT '0' NOT NULL,
logtimefmt varchar(64) DEFAULT '' NOT NULL,
templateid bigint  NULL REFERENCES items (itemid) ON DELETE CASCADE,
valuemapid bigint  NULL REFERENCES valuemaps (valuemapid),
delay_flex varchar(255) DEFAULT '' NOT NULL,
params text DEFAULT '' NOT NULL,
ipmi_sensor varchar(128) DEFAULT '' NOT NULL,
data_type integer DEFAULT '0' NOT NULL,
authtype integer DEFAULT '0' NOT NULL,
username varchar(64) DEFAULT '' NOT NULL,
password varchar(64) DEFAULT '' NOT NULL,
publickey varchar(64) DEFAULT '' NOT NULL,
privatekey varchar(64) DEFAULT '' NOT NULL,
mtime integer DEFAULT '0' NOT NULL,
lastns integer  NULL,
flags integer DEFAULT '0' NOT NULL,
filter varchar(255) DEFAULT '' NOT NULL,
interfaceid bigint  NULL REFERENCES interface (interfaceid),
port varchar(64) DEFAULT '' NOT NULL,
description text DEFAULT '' NOT NULL,
inventory_link integer DEFAULT '0' NOT NULL,
lifetime varchar(64) DEFAULT '30' NOT NULL,
PRIMARY KEY (itemid)
);
CREATE UNIQUE INDEX items_1 ON items (hostid,key_);
CREATE INDEX items_3 ON items (status);
CREATE INDEX items_4 ON items (templateid);
CREATE INDEX items_5 ON items (valuemapid);
CREATE TABLE httpstepitem (
httpstepitemid bigint  NOT NULL,
httpstepid bigint  NOT NULL REFERENCES httpstep (httpstepid) ON DELETE CASCADE,
itemid bigint  NOT NULL REFERENCES items (itemid) ON DELETE CASCADE,
type integer DEFAULT '0' NOT NULL,
PRIMARY KEY (httpstepitemid)
);
CREATE UNIQUE INDEX httpstepitem_httpstepitem_1 ON httpstepitem (httpstepid,itemid);
CREATE TABLE httptestitem (
httptestitemid bigint  NOT NULL,
httptestid bigint  NOT NULL REFERENCES httptest (httptestid) ON DELETE CASCADE,
itemid bigint  NOT NULL REFERENCES items (itemid) ON DELETE CASCADE,
type integer DEFAULT '0' NOT NULL,
PRIMARY KEY (httptestitemid)
);
CREATE UNIQUE INDEX httptestitem_httptestitem_1 ON httptestitem (httptestid,itemid);
CREATE TABLE media_type (
mediatypeid bigint  NOT NULL,
type integer DEFAULT '0' NOT NULL,
description varchar(100) DEFAULT '' NOT NULL,
smtp_server varchar(255) DEFAULT '' NOT NULL,
smtp_helo varchar(255) DEFAULT '' NOT NULL,
smtp_email varchar(255) DEFAULT '' NOT NULL,
exec_path varchar(255) DEFAULT '' NOT NULL,
gsm_modem varchar(255) DEFAULT '' NOT NULL,
username varchar(255) DEFAULT '' NOT NULL,
passwd varchar(255) DEFAULT '' NOT NULL,
status integer DEFAULT '0' NOT NULL,
PRIMARY KEY (mediatypeid)
);
CREATE TABLE users (
userid bigint  NOT NULL,
alias varchar(100) DEFAULT '' NOT NULL,
name varchar(100) DEFAULT '' NOT NULL,
surname varchar(100) DEFAULT '' NOT NULL,
passwd char(32) DEFAULT '' NOT NULL,
url varchar(255) DEFAULT '' NOT NULL,
autologin integer DEFAULT '0' NOT NULL,
autologout integer DEFAULT '900' NOT NULL,
lang varchar(5) DEFAULT 'en_GB' NOT NULL,
refresh integer DEFAULT '30' NOT NULL,
type integer DEFAULT '0' NOT NULL,
theme varchar(128) DEFAULT 'default' NOT NULL,
attempt_failed integer DEFAULT 0 NOT NULL,
attempt_ip varchar(39) DEFAULT '' NOT NULL,
attempt_clock integer DEFAULT 0 NOT NULL,
rows_per_page integer DEFAULT 50 NOT NULL,
PRIMARY KEY (userid)
);
CREATE INDEX users_1 ON users (alias);
CREATE TABLE usrgrp (
usrgrpid bigint  NOT NULL,
name varchar(64) DEFAULT '' NOT NULL,
gui_access integer DEFAULT '0' NOT NULL,
users_status integer DEFAULT '0' NOT NULL,
debug_mode integer DEFAULT '0' NOT NULL,
PRIMARY KEY (usrgrpid)
);
CREATE INDEX usrgrp_1 ON usrgrp (name);
CREATE TABLE users_groups (
id bigint  NOT NULL,
usrgrpid bigint  NOT NULL REFERENCES usrgrp (usrgrpid) ON DELETE CASCADE,
userid bigint  NOT NULL REFERENCES users (userid) ON DELETE CASCADE,
PRIMARY KEY (id)
);
CREATE UNIQUE INDEX users_groups_1 ON users_groups (usrgrpid,userid);
CREATE TABLE scripts (
scriptid bigint  NOT NULL,
name varchar(255) DEFAULT '' NOT NULL,
command varchar(255) DEFAULT '' NOT NULL,
host_access integer DEFAULT '2' NOT NULL,
usrgrpid bigint  NULL REFERENCES usrgrp (usrgrpid),
groupid bigint  NULL REFERENCES groups (groupid),
description text DEFAULT '' NOT NULL,
confirmation varchar(255) DEFAULT '' NOT NULL,
type integer DEFAULT '0' NOT NULL,
execute_on integer DEFAULT '1' NOT NULL,
PRIMARY KEY (scriptid)
);
CREATE TABLE actions (
actionid bigint  NOT NULL,
name varchar(255) DEFAULT '' NOT NULL,
eventsource integer DEFAULT '0' NOT NULL,
evaltype integer DEFAULT '0' NOT NULL,
status integer DEFAULT '0' NOT NULL,
esc_period integer DEFAULT '0' NOT NULL,
def_shortdata varchar(255) DEFAULT '' NOT NULL,
def_longdata text DEFAULT '' NOT NULL,
recovery_msg integer DEFAULT '0' NOT NULL,
r_shortdata varchar(255) DEFAULT '' NOT NULL,
r_longdata text DEFAULT '' NOT NULL,
PRIMARY KEY (actionid)
);
CREATE INDEX actions_1 ON actions (eventsource,status);
CREATE TABLE operations (
operationid bigint  NOT NULL,
actionid bigint  NOT NULL REFERENCES actions (actionid) ON DELETE CASCADE,
operationtype integer DEFAULT '0' NOT NULL,
esc_period integer DEFAULT '0' NOT NULL,
esc_step_from integer DEFAULT '1' NOT NULL,
esc_step_to integer DEFAULT '1' NOT NULL,
evaltype integer DEFAULT '0' NOT NULL,
PRIMARY KEY (operationid)
);
CREATE INDEX operations_1 ON operations (actionid);
CREATE TABLE opmessage (
operationid bigint  NOT NULL REFERENCES operations (operationid) ON DELETE CASCADE,
default_msg integer DEFAULT '0' NOT NULL,
subject varchar(255) DEFAULT '' NOT NULL,
message text DEFAULT '' NOT NULL,
mediatypeid bigint  NULL REFERENCES media_type (mediatypeid),
PRIMARY KEY (operationid)
);
CREATE TABLE opmessage_grp (
opmessage_grpid bigint  NOT NULL,
operationid bigint  NOT NULL REFERENCES operations (operationid) ON DELETE CASCADE,
usrgrpid bigint  NOT NULL REFERENCES usrgrp (usrgrpid),
PRIMARY KEY (opmessage_grpid)
);
CREATE UNIQUE INDEX opmessage_grp_1 ON opmessage_grp (operationid,usrgrpid);
CREATE TABLE opmessage_usr (
opmessage_usrid bigint  NOT NULL,
operationid bigint  NOT NULL REFERENCES operations (operationid) ON DELETE CASCADE,
userid bigint  NOT NULL REFERENCES users (userid),
PRIMARY KEY (opmessage_usrid)
);
CREATE UNIQUE INDEX opmessage_usr_1 ON opmessage_usr (operationid,userid);
CREATE TABLE opcommand (
operationid bigint  NOT NULL REFERENCES operations (operationid) ON DELETE CASCADE,
type integer DEFAULT '0' NOT NULL,
scriptid bigint  NULL REFERENCES scripts (scriptid),
execute_on integer DEFAULT '0' NOT NULL,
port varchar(64) DEFAULT '' NOT NULL,
authtype integer DEFAULT '0' NOT NULL,
username varchar(64) DEFAULT '' NOT NULL,
password varchar(64) DEFAULT '' NOT NULL,
publickey varchar(64) DEFAULT '' NOT NULL,
privatekey varchar(64) DEFAULT '' NOT NULL,
command text DEFAULT '' NOT NULL,
PRIMARY KEY (operationid)
);
CREATE TABLE opcommand_hst (
opcommand_hstid bigint  NOT NULL,
operationid bigint  NOT NULL REFERENCES operations (operationid) ON DELETE CASCADE,
hostid bigint  NULL REFERENCES hosts (hostid),
PRIMARY KEY (opcommand_hstid)
);
CREATE INDEX opcommand_hst_1 ON opcommand_hst (operationid);
CREATE TABLE opcommand_grp (
opcommand_grpid bigint  NOT NULL,
operationid bigint  NOT NULL REFERENCES operations (operationid) ON DELETE CASCADE,
groupid bigint  NOT NULL REFERENCES groups (groupid),
PRIMARY KEY (opcommand_grpid)
);
CREATE INDEX opcommand_grp_1 ON opcommand_grp (operationid);
CREATE TABLE opgroup (
opgroupid bigint  NOT NULL,
operationid bigint  NOT NULL REFERENCES operations (operationid) ON DELETE CASCADE,
groupid bigint  NOT NULL REFERENCES groups (groupid),
PRIMARY KEY (opgroupid)
);
CREATE UNIQUE INDEX opgroup_1 ON opgroup (operationid,groupid);
CREATE TABLE optemplate (
optemplateid bigint  NOT NULL,
operationid bigint  NOT NULL REFERENCES operations (operationid) ON DELETE CASCADE,
templateid bigint  NOT NULL REFERENCES hosts (hostid),
PRIMARY KEY (optemplateid)
);
CREATE UNIQUE INDEX optemplate_1 ON optemplate (operationid,templateid);
CREATE TABLE opconditions (
opconditionid bigint  NOT NULL,
operationid bigint  NOT NULL REFERENCES operations (operationid) ON DELETE CASCADE,
conditiontype integer DEFAULT '0' NOT NULL,
operator integer DEFAULT '0' NOT NULL,
value varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (opconditionid)
);
CREATE INDEX opconditions_1 ON opconditions (operationid);
CREATE TABLE conditions (
conditionid bigint  NOT NULL,
actionid bigint  NOT NULL REFERENCES actions (actionid) ON DELETE CASCADE,
conditiontype integer DEFAULT '0' NOT NULL,
operator integer DEFAULT '0' NOT NULL,
value varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (conditionid)
);
CREATE INDEX conditions_1 ON conditions (actionid);
CREATE TABLE config (
configid bigint  NOT NULL,
alert_history integer DEFAULT '0' NOT NULL,
event_history integer DEFAULT '0' NOT NULL,
refresh_unsupported integer DEFAULT '0' NOT NULL,
work_period varchar(100) DEFAULT '1-5,00:00-24:00' NOT NULL,
alert_usrgrpid bigint  NULL REFERENCES usrgrp (usrgrpid),
event_ack_enable integer DEFAULT '1' NOT NULL,
event_expire integer DEFAULT '7' NOT NULL,
event_show_max integer DEFAULT '100' NOT NULL,
default_theme varchar(128) DEFAULT 'originalblue' NOT NULL,
authentication_type integer DEFAULT '0' NOT NULL,
ldap_host varchar(255) DEFAULT '' NOT NULL,
ldap_port integer DEFAULT 389 NOT NULL,
ldap_base_dn varchar(255) DEFAULT '' NOT NULL,
ldap_bind_dn varchar(255) DEFAULT '' NOT NULL,
ldap_bind_password varchar(128) DEFAULT '' NOT NULL,
ldap_search_attribute varchar(128) DEFAULT '' NOT NULL,
dropdown_first_entry integer DEFAULT '1' NOT NULL,
dropdown_first_remember integer DEFAULT '1' NOT NULL,
discovery_groupid bigint  NOT NULL REFERENCES groups (groupid),
max_in_table integer DEFAULT '50' NOT NULL,
search_limit integer DEFAULT '1000' NOT NULL,
severity_color_0 varchar(6) DEFAULT 'DBDBDB' NOT NULL,
severity_color_1 varchar(6) DEFAULT 'D6F6FF' NOT NULL,
severity_color_2 varchar(6) DEFAULT 'FFF6A5' NOT NULL,
severity_color_3 varchar(6) DEFAULT 'FFB689' NOT NULL,
severity_color_4 varchar(6) DEFAULT 'FF9999' NOT NULL,
severity_color_5 varchar(6) DEFAULT 'FF3838' NOT NULL,
severity_name_0 varchar(32) DEFAULT 'Not classified' NOT NULL,
severity_name_1 varchar(32) DEFAULT 'Information' NOT NULL,
severity_name_2 varchar(32) DEFAULT 'Warning' NOT NULL,
severity_name_3 varchar(32) DEFAULT 'Average' NOT NULL,
severity_name_4 varchar(32) DEFAULT 'High' NOT NULL,
severity_name_5 varchar(32) DEFAULT 'Disaster' NOT NULL,
ok_period integer DEFAULT '1800' NOT NULL,
blink_period integer DEFAULT '1800' NOT NULL,
problem_unack_color varchar(6) DEFAULT 'DC0000' NOT NULL,
problem_ack_color varchar(6) DEFAULT 'DC0000' NOT NULL,
ok_unack_color varchar(6) DEFAULT '00AA00' NOT NULL,
ok_ack_color varchar(6) DEFAULT '00AA00' NOT NULL,
problem_unack_style integer DEFAULT '1' NOT NULL,
problem_ack_style integer DEFAULT '1' NOT NULL,
ok_unack_style integer DEFAULT '1' NOT NULL,
ok_ack_style integer DEFAULT '1' NOT NULL,
snmptrap_logging integer DEFAULT '1' NOT NULL,
server_check_interval integer DEFAULT '10' NOT NULL,
PRIMARY KEY (configid)
);
CREATE TABLE triggers (
triggerid bigint  NOT NULL,
expression varchar(255) DEFAULT '' NOT NULL,
description varchar(255) DEFAULT '' NOT NULL,
url varchar(255) DEFAULT '' NOT NULL,
status integer DEFAULT '0' NOT NULL,
value integer DEFAULT '0' NOT NULL,
priority integer DEFAULT '0' NOT NULL,
lastchange integer DEFAULT '0' NOT NULL,
comments text DEFAULT '' NOT NULL,
error varchar(128) DEFAULT '' NOT NULL,
templateid bigint  NULL REFERENCES triggers (triggerid) ON DELETE CASCADE,
type integer DEFAULT '0' NOT NULL,
value_flags integer DEFAULT '0' NOT NULL,
flags integer DEFAULT '0' NOT NULL,
PRIMARY KEY (triggerid)
);
CREATE INDEX triggers_1 ON triggers (status);
CREATE INDEX triggers_2 ON triggers (value);
CREATE TABLE trigger_depends (
triggerdepid bigint  NOT NULL,
triggerid_down bigint  NOT NULL REFERENCES triggers (triggerid) ON DELETE CASCADE,
triggerid_up bigint  NOT NULL REFERENCES triggers (triggerid) ON DELETE CASCADE,
PRIMARY KEY (triggerdepid)
);
CREATE UNIQUE INDEX trigger_depends_1 ON trigger_depends (triggerid_down,triggerid_up);
CREATE INDEX trigger_depends_2 ON trigger_depends (triggerid_up);
CREATE TABLE functions (
functionid bigint  NOT NULL,
itemid bigint  NOT NULL REFERENCES items (itemid) ON DELETE CASCADE,
triggerid bigint  NOT NULL REFERENCES triggers (triggerid) ON DELETE CASCADE,
function varchar(12) DEFAULT '' NOT NULL,
parameter varchar(255) DEFAULT '0' NOT NULL,
PRIMARY KEY (functionid)
);
CREATE INDEX functions_1 ON functions (triggerid);
CREATE INDEX functions_2 ON functions (itemid,function,parameter);
CREATE TABLE graphs (
graphid bigint  NOT NULL,
name varchar(128) DEFAULT '' NOT NULL,
width integer DEFAULT '0' NOT NULL,
height integer DEFAULT '0' NOT NULL,
yaxismin double(16,4) DEFAULT '0' NOT NULL,
yaxismax double(16,4) DEFAULT '0' NOT NULL,
templateid bigint  NULL REFERENCES graphs (graphid) ON DELETE CASCADE,
show_work_period integer DEFAULT '1' NOT NULL,
show_triggers integer DEFAULT '1' NOT NULL,
graphtype integer DEFAULT '0' NOT NULL,
show_legend integer DEFAULT '1' NOT NULL,
show_3d integer DEFAULT '0' NOT NULL,
percent_left double(16,4) DEFAULT '0' NOT NULL,
percent_right double(16,4) DEFAULT '0' NOT NULL,
ymin_type integer DEFAULT '0' NOT NULL,
ymax_type integer DEFAULT '0' NOT NULL,
ymin_itemid bigint  NULL REFERENCES items (itemid),
ymax_itemid bigint  NULL REFERENCES items (itemid),
flags integer DEFAULT '0' NOT NULL,
PRIMARY KEY (graphid)
);
CREATE INDEX graphs_graphs_1 ON graphs (name);
CREATE TABLE graphs_items (
gitemid bigint  NOT NULL,
graphid bigint  NOT NULL REFERENCES graphs (graphid) ON DELETE CASCADE,
itemid bigint  NOT NULL REFERENCES items (itemid) ON DELETE CASCADE,
drawtype integer DEFAULT '0' NOT NULL,
sortorder integer DEFAULT '0' NOT NULL,
color varchar(6) DEFAULT '009600' NOT NULL,
yaxisside integer DEFAULT '1' NOT NULL,
calc_fnc integer DEFAULT '2' NOT NULL,
type integer DEFAULT '0' NOT NULL,
PRIMARY KEY (gitemid)
);
CREATE INDEX graphs_items_1 ON graphs_items (itemid);
CREATE INDEX graphs_items_2 ON graphs_items (graphid);
CREATE TABLE graph_theme (
graphthemeid bigint  NOT NULL,
description varchar(64) DEFAULT '' NOT NULL,
theme varchar(64) DEFAULT '' NOT NULL,
backgroundcolor varchar(6) DEFAULT 'F0F0F0' NOT NULL,
graphcolor varchar(6) DEFAULT 'FFFFFF' NOT NULL,
graphbordercolor varchar(6) DEFAULT '222222' NOT NULL,
gridcolor varchar(6) DEFAULT 'CCCCCC' NOT NULL,
maingridcolor varchar(6) DEFAULT 'AAAAAA' NOT NULL,
gridbordercolor varchar(6) DEFAULT '000000' NOT NULL,
textcolor varchar(6) DEFAULT '202020' NOT NULL,
highlightcolor varchar(6) DEFAULT 'AA4444' NOT NULL,
leftpercentilecolor varchar(6) DEFAULT '11CC11' NOT NULL,
rightpercentilecolor varchar(6) DEFAULT 'CC1111' NOT NULL,
nonworktimecolor varchar(6) DEFAULT 'CCCCCC' NOT NULL,
gridview integer DEFAULT 1 NOT NULL,
legendview integer DEFAULT 1 NOT NULL,
PRIMARY KEY (graphthemeid)
);
CREATE INDEX graph_theme_1 ON graph_theme (description);
CREATE INDEX graph_theme_2 ON graph_theme (theme);
CREATE TABLE help_items (
itemtype integer DEFAULT '0' NOT NULL,
key_ varchar(255) DEFAULT '' NOT NULL,
description varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (itemtype,key_)
);
CREATE TABLE globalmacro (
globalmacroid bigint  NOT NULL,
macro varchar(64) DEFAULT '' NOT NULL,
value varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (globalmacroid)
);
CREATE INDEX globalmacro_1 ON globalmacro (macro);
CREATE TABLE hostmacro (
hostmacroid bigint  NOT NULL,
hostid bigint  NOT NULL REFERENCES hosts (hostid) ON DELETE CASCADE,
macro varchar(64) DEFAULT '' NOT NULL,
value varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (hostmacroid)
);
CREATE UNIQUE INDEX hostmacro_1 ON hostmacro (hostid,macro);
CREATE TABLE hosts_groups (
hostgroupid bigint  NOT NULL,
hostid bigint  NOT NULL REFERENCES hosts (hostid) ON DELETE CASCADE,
groupid bigint  NOT NULL REFERENCES groups (groupid) ON DELETE CASCADE,
PRIMARY KEY (hostgroupid)
);
CREATE UNIQUE INDEX hosts_groups_1 ON hosts_groups (hostid,groupid);
CREATE INDEX hosts_groups_2 ON hosts_groups (groupid);
CREATE TABLE hosts_templates (
hosttemplateid bigint  NOT NULL,
hostid bigint  NOT NULL REFERENCES hosts (hostid) ON DELETE CASCADE,
templateid bigint  NOT NULL REFERENCES hosts (hostid) ON DELETE CASCADE,
PRIMARY KEY (hosttemplateid)
);
CREATE UNIQUE INDEX hosts_templates_1 ON hosts_templates (hostid,templateid);
CREATE INDEX hosts_templates_2 ON hosts_templates (templateid);
CREATE TABLE items_applications (
itemappid bigint  NOT NULL,
applicationid bigint  NOT NULL REFERENCES applications (applicationid) ON DELETE CASCADE,
itemid bigint  NOT NULL REFERENCES items (itemid) ON DELETE CASCADE,
PRIMARY KEY (itemappid)
);
CREATE UNIQUE INDEX items_applications_1 ON items_applications (applicationid,itemid);
CREATE INDEX items_applications_2 ON items_applications (itemid);
CREATE TABLE mappings (
mappingid bigint  NOT NULL,
valuemapid bigint  NOT NULL REFERENCES valuemaps (valuemapid) ON DELETE CASCADE,
value varchar(64) DEFAULT '' NOT NULL,
newvalue varchar(64) DEFAULT '' NOT NULL,
PRIMARY KEY (mappingid)
);
CREATE INDEX mappings_1 ON mappings (valuemapid);
CREATE TABLE media (
mediaid bigint  NOT NULL,
userid bigint  NOT NULL REFERENCES users (userid) ON DELETE CASCADE,
mediatypeid bigint  NOT NULL REFERENCES media_type (mediatypeid) ON DELETE CASCADE,
sendto varchar(100) DEFAULT '' NOT NULL,
active integer DEFAULT '0' NOT NULL,
severity integer DEFAULT '63' NOT NULL,
period varchar(100) DEFAULT '1-7,00:00-24:00' NOT NULL,
PRIMARY KEY (mediaid)
);
CREATE INDEX media_1 ON media (userid);
CREATE INDEX media_2 ON media (mediatypeid);
CREATE TABLE rights (
rightid bigint  NOT NULL,
groupid bigint  NOT NULL REFERENCES usrgrp (usrgrpid) ON DELETE CASCADE,
permission integer DEFAULT '0' NOT NULL,
id bigint  NOT NULL REFERENCES groups (groupid) ON DELETE CASCADE,
PRIMARY KEY (rightid)
);
CREATE INDEX rights_1 ON rights (groupid);
CREATE INDEX rights_2 ON rights (id);
CREATE TABLE services (
serviceid bigint  NOT NULL,
name varchar(128) DEFAULT '' NOT NULL,
status integer DEFAULT '0' NOT NULL,
algorithm integer DEFAULT '0' NOT NULL,
triggerid bigint  NULL REFERENCES triggers (triggerid) ON DELETE CASCADE,
showsla integer DEFAULT '0' NOT NULL,
goodsla double(16,4) DEFAULT '99.9' NOT NULL,
sortorder integer DEFAULT '0' NOT NULL,
PRIMARY KEY (serviceid)
);
CREATE INDEX services_1 ON services (triggerid);
CREATE TABLE services_links (
linkid bigint  NOT NULL,
serviceupid bigint  NOT NULL REFERENCES services (serviceid) ON DELETE CASCADE,
servicedownid bigint  NOT NULL REFERENCES services (serviceid) ON DELETE CASCADE,
soft integer DEFAULT '0' NOT NULL,
PRIMARY KEY (linkid)
);
CREATE INDEX services_links_links_1 ON services_links (servicedownid);
CREATE UNIQUE INDEX services_links_links_2 ON services_links (serviceupid,servicedownid);
CREATE TABLE services_times (
timeid bigint  NOT NULL,
serviceid bigint  NOT NULL REFERENCES services (serviceid) ON DELETE CASCADE,
type integer DEFAULT '0' NOT NULL,
ts_from integer DEFAULT '0' NOT NULL,
ts_to integer DEFAULT '0' NOT NULL,
note varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (timeid)
);
CREATE INDEX services_times_times_1 ON services_times (serviceid,type,ts_from,ts_to);
CREATE TABLE icon_map (
iconmapid bigint  NOT NULL,
name varchar(64) DEFAULT '' NOT NULL,
default_iconid bigint  NOT NULL REFERENCES images (imageid),
PRIMARY KEY (iconmapid)
);
CREATE INDEX icon_map_1 ON icon_map (name);
CREATE TABLE icon_mapping (
iconmappingid bigint  NOT NULL,
iconmapid bigint  NOT NULL REFERENCES icon_map (iconmapid) ON DELETE CASCADE,
iconid bigint  NOT NULL REFERENCES images (imageid),
inventory_link integer DEFAULT '0' NOT NULL,
expression varchar(64) DEFAULT '' NOT NULL,
sortorder integer DEFAULT '0' NOT NULL,
PRIMARY KEY (iconmappingid)
);
CREATE INDEX icon_mapping_1 ON icon_mapping (iconmapid);
CREATE TABLE sysmaps (
sysmapid bigint  NOT NULL,
name varchar(128) DEFAULT '' NOT NULL,
width integer DEFAULT '600' NOT NULL,
height integer DEFAULT '400' NOT NULL,
backgroundid bigint  NULL REFERENCES images (imageid),
label_type integer DEFAULT '2' NOT NULL,
label_location integer DEFAULT '3' NOT NULL,
highlight integer DEFAULT '1' NOT NULL,
expandproblem integer DEFAULT '1' NOT NULL,
markelements integer DEFAULT '0' NOT NULL,
show_unack integer DEFAULT '0' NOT NULL,
grid_size integer DEFAULT '50' NOT NULL,
grid_show integer DEFAULT '1' NOT NULL,
grid_align integer DEFAULT '1' NOT NULL,
label_format integer DEFAULT '0' NOT NULL,
label_type_host integer DEFAULT '2' NOT NULL,
label_type_hostgroup integer DEFAULT '2' NOT NULL,
label_type_trigger integer DEFAULT '2' NOT NULL,
label_type_map integer DEFAULT '2' NOT NULL,
label_type_image integer DEFAULT '2' NOT NULL,
label_string_host varchar(255) DEFAULT '' NOT NULL,
label_string_hostgroup varchar(255) DEFAULT '' NOT NULL,
label_string_trigger varchar(255) DEFAULT '' NOT NULL,
label_string_map varchar(255) DEFAULT '' NOT NULL,
label_string_image varchar(255) DEFAULT '' NOT NULL,
iconmapid bigint  NULL REFERENCES icon_map (iconmapid),
expand_macros integer DEFAULT '0' NOT NULL,
PRIMARY KEY (sysmapid)
);
CREATE INDEX sysmaps_1 ON sysmaps (name);
CREATE TABLE sysmaps_elements (
selementid bigint  NOT NULL,
sysmapid bigint  NOT NULL REFERENCES sysmaps (sysmapid) ON DELETE CASCADE,
elementid bigint DEFAULT '0' NOT NULL,
elementtype integer DEFAULT '0' NOT NULL,
iconid_off bigint  NULL REFERENCES images (imageid),
iconid_on bigint  NULL REFERENCES images (imageid),
label varchar(255) DEFAULT '' NOT NULL,
label_location integer  NULL,
x integer DEFAULT '0' NOT NULL,
y integer DEFAULT '0' NOT NULL,
iconid_disabled bigint  NULL REFERENCES images (imageid),
iconid_maintenance bigint  NULL REFERENCES images (imageid),
elementsubtype integer DEFAULT '0' NOT NULL,
areatype integer DEFAULT '0' NOT NULL,
width integer DEFAULT '200' NOT NULL,
height integer DEFAULT '200' NOT NULL,
viewtype integer DEFAULT '0' NOT NULL,
use_iconmap integer DEFAULT '1' NOT NULL,
PRIMARY KEY (selementid)
);
CREATE TABLE sysmaps_links (
linkid bigint  NOT NULL,
sysmapid bigint  NOT NULL REFERENCES sysmaps (sysmapid) ON DELETE CASCADE,
selementid1 bigint  NOT NULL REFERENCES sysmaps_elements (selementid) ON DELETE CASCADE,
selementid2 bigint  NOT NULL REFERENCES sysmaps_elements (selementid) ON DELETE CASCADE,
drawtype integer DEFAULT '0' NOT NULL,
color varchar(6) DEFAULT '000000' NOT NULL,
label varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (linkid)
);
CREATE TABLE sysmaps_link_triggers (
linktriggerid bigint  NOT NULL,
linkid bigint  NOT NULL REFERENCES sysmaps_links (linkid) ON DELETE CASCADE,
triggerid bigint  NOT NULL REFERENCES triggers (triggerid) ON DELETE CASCADE,
drawtype integer DEFAULT '0' NOT NULL,
color varchar(6) DEFAULT '000000' NOT NULL,
PRIMARY KEY (linktriggerid)
);
CREATE UNIQUE INDEX sysmaps_link_triggers_1 ON sysmaps_link_triggers (linkid,triggerid);
CREATE TABLE sysmap_element_url (
sysmapelementurlid bigint  NOT NULL,
selementid bigint  NOT NULL REFERENCES sysmaps_elements (selementid) ON DELETE CASCADE,
name varchar(255)  NOT NULL,
url varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (sysmapelementurlid)
);
CREATE UNIQUE INDEX sysmap_element_url_1 ON sysmap_element_url (selementid,name);
CREATE TABLE sysmap_url (
sysmapurlid bigint  NOT NULL,
sysmapid bigint  NOT NULL REFERENCES sysmaps (sysmapid) ON DELETE CASCADE,
name varchar(255)  NOT NULL,
url varchar(255) DEFAULT '' NOT NULL,
elementtype integer DEFAULT '0' NOT NULL,
PRIMARY KEY (sysmapurlid)
);
CREATE UNIQUE INDEX sysmap_url_1 ON sysmap_url (sysmapid,name);
CREATE TABLE maintenances_hosts (
maintenance_hostid bigint  NOT NULL,
maintenanceid bigint  NOT NULL REFERENCES maintenances (maintenanceid) ON DELETE CASCADE,
hostid bigint  NOT NULL REFERENCES hosts (hostid) ON DELETE CASCADE,
PRIMARY KEY (maintenance_hostid)
);
CREATE UNIQUE INDEX maintenances_hosts_1 ON maintenances_hosts (maintenanceid,hostid);
CREATE TABLE maintenances_groups (
maintenance_groupid bigint  NOT NULL,
maintenanceid bigint  NOT NULL REFERENCES maintenances (maintenanceid) ON DELETE CASCADE,
groupid bigint  NOT NULL REFERENCES groups (groupid) ON DELETE CASCADE,
PRIMARY KEY (maintenance_groupid)
);
CREATE UNIQUE INDEX maintenances_groups_1 ON maintenances_groups (maintenanceid,groupid);
CREATE TABLE timeperiods (
timeperiodid bigint  NOT NULL,
timeperiod_type integer DEFAULT '0' NOT NULL,
every integer DEFAULT '0' NOT NULL,
month integer DEFAULT '0' NOT NULL,
dayofweek integer DEFAULT '0' NOT NULL,
day integer DEFAULT '0' NOT NULL,
start_time integer DEFAULT '0' NOT NULL,
period integer DEFAULT '0' NOT NULL,
start_date integer DEFAULT '0' NOT NULL,
PRIMARY KEY (timeperiodid)
);
CREATE TABLE maintenances_windows (
maintenance_timeperiodid bigint  NOT NULL,
maintenanceid bigint  NOT NULL REFERENCES maintenances (maintenanceid) ON DELETE CASCADE,
timeperiodid bigint  NOT NULL REFERENCES timeperiods (timeperiodid) ON DELETE CASCADE,
PRIMARY KEY (maintenance_timeperiodid)
);
CREATE UNIQUE INDEX maintenances_windows_1 ON maintenances_windows (maintenanceid,timeperiodid);
CREATE TABLE regexps (
regexpid bigint  NOT NULL,
name varchar(128) DEFAULT '' NOT NULL,
test_string text DEFAULT '' NOT NULL,
PRIMARY KEY (regexpid)
);
CREATE INDEX regexps_1 ON regexps (name);
CREATE TABLE expressions (
expressionid bigint  NOT NULL,
regexpid bigint  NOT NULL REFERENCES regexps (regexpid) ON DELETE CASCADE,
expression varchar(255) DEFAULT '' NOT NULL,
expression_type integer DEFAULT '0' NOT NULL,
exp_delimiter varchar(1) DEFAULT '' NOT NULL,
case_sensitive integer DEFAULT '0' NOT NULL,
PRIMARY KEY (expressionid)
);
CREATE INDEX expressions_1 ON expressions (regexpid);
CREATE TABLE nodes (
nodeid integer  NOT NULL,
name varchar(64) DEFAULT '0' NOT NULL,
ip varchar(39) DEFAULT '' NOT NULL,
port integer DEFAULT '10051' NOT NULL,
nodetype integer DEFAULT '0' NOT NULL,
masterid integer  NULL REFERENCES nodes (nodeid),
PRIMARY KEY (nodeid)
);
CREATE TABLE node_cksum (
nodeid integer  NOT NULL REFERENCES nodes (nodeid) ON DELETE CASCADE,
tablename varchar(64) DEFAULT '' NOT NULL,
recordid bigint  NOT NULL,
cksumtype integer DEFAULT '0' NOT NULL,
cksum text DEFAULT '' NOT NULL,
sync char(128) DEFAULT '' NOT NULL
);
CREATE INDEX node_cksum_1 ON node_cksum (nodeid,cksumtype,tablename,recordid);
CREATE TABLE ids (
nodeid integer  NOT NULL,
table_name varchar(64) DEFAULT '' NOT NULL,
field_name varchar(64) DEFAULT '' NOT NULL,
nextid bigint  NOT NULL,
PRIMARY KEY (nodeid,table_name,field_name)
);
CREATE TABLE alerts (
alertid bigint  NOT NULL,
actionid bigint  NOT NULL REFERENCES actions (actionid) ON DELETE CASCADE,
eventid bigint  NOT NULL REFERENCES events (eventid) ON DELETE CASCADE,
userid bigint  NULL REFERENCES users (userid) ON DELETE CASCADE,
clock integer DEFAULT '0' NOT NULL,
mediatypeid bigint  NULL REFERENCES media_type (mediatypeid) ON DELETE CASCADE,
sendto varchar(100) DEFAULT '' NOT NULL,
subject varchar(255) DEFAULT '' NOT NULL,
message text DEFAULT '' NOT NULL,
status integer DEFAULT '0' NOT NULL,
retries integer DEFAULT '0' NOT NULL,
error varchar(128) DEFAULT '' NOT NULL,
nextcheck integer DEFAULT '0' NOT NULL,
esc_step integer DEFAULT '0' NOT NULL,
alerttype integer DEFAULT '0' NOT NULL,
PRIMARY KEY (alertid)
);
CREATE INDEX alerts_1 ON alerts (actionid);
CREATE INDEX alerts_2 ON alerts (clock);
CREATE INDEX alerts_3 ON alerts (eventid);
CREATE INDEX alerts_4 ON alerts (status,retries);
CREATE INDEX alerts_5 ON alerts (mediatypeid);
CREATE INDEX alerts_6 ON alerts (userid);
CREATE TABLE history (
itemid bigint  NOT NULL,
clock integer DEFAULT '0' NOT NULL,
value double(16,4) DEFAULT '0.0000' NOT NULL,
ns integer DEFAULT '0' NOT NULL
);
CREATE INDEX history_1 ON history (itemid,clock);
CREATE TABLE history_sync (
id integer  NOT NULL PRIMARY KEY AUTOINCREMENT,
nodeid integer  NOT NULL,
itemid bigint  NOT NULL,
clock integer DEFAULT '0' NOT NULL,
value double(16,4) DEFAULT '0.0000' NOT NULL,
ns integer DEFAULT '0' NOT NULL
);
CREATE INDEX history_sync_1 ON history_sync (nodeid,id);
CREATE TABLE history_uint (
itemid bigint  NOT NULL,
clock integer DEFAULT '0' NOT NULL,
value bigint DEFAULT '0' NOT NULL,
ns integer DEFAULT '0' NOT NULL
);
CREATE INDEX history_uint_1 ON history_uint (itemid,clock);
CREATE TABLE history_uint_sync (
id integer  NOT NULL PRIMARY KEY AUTOINCREMENT,
nodeid integer  NOT NULL,
itemid bigint  NOT NULL,
clock integer DEFAULT '0' NOT NULL,
value bigint DEFAULT '0' NOT NULL,
ns integer DEFAULT '0' NOT NULL
);
CREATE INDEX history_uint_sync_1 ON history_uint_sync (nodeid,id);
CREATE TABLE history_str (
itemid bigint  NOT NULL,
clock integer DEFAULT '0' NOT NULL,
value varchar(255) DEFAULT '' NOT NULL,
ns integer DEFAULT '0' NOT NULL
);
CREATE INDEX history_str_1 ON history_str (itemid,clock);
CREATE TABLE history_str_sync (
id integer  NOT NULL PRIMARY KEY AUTOINCREMENT,
nodeid integer  NOT NULL,
itemid bigint  NOT NULL,
clock integer DEFAULT '0' NOT NULL,
value varchar(255) DEFAULT '' NOT NULL,
ns integer DEFAULT '0' NOT NULL
);
CREATE INDEX history_str_sync_1 ON history_str_sync (nodeid,id);
CREATE TABLE history_log (
id bigint  NOT NULL,
itemid bigint  NOT NULL,
clock integer DEFAULT '0' NOT NULL,
timestamp integer DEFAULT '0' NOT NULL,
source varchar(64) DEFAULT '' NOT NULL,
severity integer DEFAULT '0' NOT NULL,
value text DEFAULT '' NOT NULL,
logeventid integer DEFAULT '0' NOT NULL,
ns integer DEFAULT '0' NOT NULL,
PRIMARY KEY (id)
);
CREATE INDEX history_log_1 ON history_log (itemid,clock);
CREATE UNIQUE INDEX history_log_2 ON history_log (itemid,id);
CREATE TABLE history_text (
id bigint  NOT NULL,
itemid bigint  NOT NULL,
clock integer DEFAULT '0' NOT NULL,
value text DEFAULT '' NOT NULL,
ns integer DEFAULT '0' NOT NULL,
PRIMARY KEY (id)
);
CREATE INDEX history_text_1 ON history_text (itemid,clock);
CREATE UNIQUE INDEX history_text_2 ON history_text (itemid,id);
CREATE TABLE proxy_history (
id integer  NOT NULL PRIMARY KEY AUTOINCREMENT,
itemid bigint  NOT NULL,
clock integer DEFAULT '0' NOT NULL,
timestamp integer DEFAULT '0' NOT NULL,
source varchar(64) DEFAULT '' NOT NULL,
severity integer DEFAULT '0' NOT NULL,
value text DEFAULT '' NOT NULL,
logeventid integer DEFAULT '0' NOT NULL,
ns integer DEFAULT '0' NOT NULL,
status integer DEFAULT '0' NOT NULL
);
CREATE INDEX proxy_history_1 ON proxy_history (clock);
CREATE TABLE proxy_dhistory (
id integer  NOT NULL PRIMARY KEY AUTOINCREMENT,
clock integer DEFAULT '0' NOT NULL,
druleid bigint  NOT NULL,
type integer DEFAULT '0' NOT NULL,
ip varchar(39) DEFAULT '' NOT NULL,
port integer DEFAULT '0' NOT NULL,
key_ varchar(255) DEFAULT '' NOT NULL,
value varchar(255) DEFAULT '' NOT NULL,
status integer DEFAULT '0' NOT NULL,
dcheckid bigint  NULL,
dns varchar(64) DEFAULT '' NOT NULL
);
CREATE INDEX proxy_dhistory_1 ON proxy_dhistory (clock);
CREATE TABLE events (
eventid bigint  NOT NULL,
source integer DEFAULT '0' NOT NULL,
object integer DEFAULT '0' NOT NULL,
objectid bigint DEFAULT '0' NOT NULL,
clock integer DEFAULT '0' NOT NULL,
value integer DEFAULT '0' NOT NULL,
acknowledged integer DEFAULT '0' NOT NULL,
ns integer DEFAULT '0' NOT NULL,
value_changed integer DEFAULT '0' NOT NULL,
PRIMARY KEY (eventid)
);
CREATE INDEX events_1 ON events (object,objectid,eventid);
CREATE INDEX events_2 ON events (clock);
CREATE TABLE trends (
itemid bigint  NOT NULL,
clock integer DEFAULT '0' NOT NULL,
num integer DEFAULT '0' NOT NULL,
value_min double(16,4) DEFAULT '0.0000' NOT NULL,
value_avg double(16,4) DEFAULT '0.0000' NOT NULL,
value_max double(16,4) DEFAULT '0.0000' NOT NULL,
PRIMARY KEY (itemid,clock)
);
CREATE TABLE trends_uint (
itemid bigint  NOT NULL,
clock integer DEFAULT '0' NOT NULL,
num integer DEFAULT '0' NOT NULL,
value_min bigint DEFAULT '0' NOT NULL,
value_avg bigint DEFAULT '0' NOT NULL,
value_max bigint DEFAULT '0' NOT NULL,
PRIMARY KEY (itemid,clock)
);
CREATE TABLE acknowledges (
acknowledgeid bigint  NOT NULL,
userid bigint  NOT NULL REFERENCES users (userid) ON DELETE CASCADE,
eventid bigint  NOT NULL REFERENCES events (eventid) ON DELETE CASCADE,
clock integer DEFAULT '0' NOT NULL,
message varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (acknowledgeid)
);
CREATE INDEX acknowledges_1 ON acknowledges (userid);
CREATE INDEX acknowledges_2 ON acknowledges (eventid);
CREATE INDEX acknowledges_3 ON acknowledges (clock);
CREATE TABLE auditlog (
auditid bigint  NOT NULL,
userid bigint  NOT NULL REFERENCES users (userid) ON DELETE CASCADE,
clock integer DEFAULT '0' NOT NULL,
action integer DEFAULT '0' NOT NULL,
resourcetype integer DEFAULT '0' NOT NULL,
details varchar(128)  DEFAULT '0' NOT NULL,
ip varchar(39) DEFAULT '' NOT NULL,
resourceid bigint DEFAULT '0' NOT NULL,
resourcename varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (auditid)
);
CREATE INDEX auditlog_1 ON auditlog (userid,clock);
CREATE INDEX auditlog_2 ON auditlog (clock);
CREATE TABLE auditlog_details (
auditdetailid bigint  NOT NULL,
auditid bigint  NOT NULL REFERENCES auditlog (auditid) ON DELETE CASCADE,
table_name varchar(64) DEFAULT '' NOT NULL,
field_name varchar(64) DEFAULT '' NOT NULL,
oldvalue text DEFAULT '' NOT NULL,
newvalue text DEFAULT '' NOT NULL,
PRIMARY KEY (auditdetailid)
);
CREATE INDEX auditlog_details_1 ON auditlog_details (auditid);
CREATE TABLE service_alarms (
servicealarmid bigint  NOT NULL,
serviceid bigint  NOT NULL REFERENCES services (serviceid) ON DELETE CASCADE,
clock integer DEFAULT '0' NOT NULL,
value integer DEFAULT '0' NOT NULL,
PRIMARY KEY (servicealarmid)
);
CREATE INDEX service_alarms_1 ON service_alarms (serviceid,clock);
CREATE INDEX service_alarms_2 ON service_alarms (clock);
CREATE TABLE autoreg_host (
autoreg_hostid bigint  NOT NULL,
proxy_hostid bigint  NULL REFERENCES hosts (hostid) ON DELETE CASCADE,
host varchar(64) DEFAULT '' NOT NULL,
listen_ip varchar(39) DEFAULT '' NOT NULL,
listen_port integer DEFAULT '0' NOT NULL,
listen_dns varchar(64) DEFAULT '' NOT NULL,
PRIMARY KEY (autoreg_hostid)
);
CREATE INDEX autoreg_host_1 ON autoreg_host (proxy_hostid,host);
CREATE TABLE proxy_autoreg_host (
id integer  NOT NULL PRIMARY KEY AUTOINCREMENT,
clock integer DEFAULT '0' NOT NULL,
host varchar(64) DEFAULT '' NOT NULL,
listen_ip varchar(39) DEFAULT '' NOT NULL,
listen_port integer DEFAULT '0' NOT NULL,
listen_dns varchar(64) DEFAULT '' NOT NULL
);
CREATE INDEX proxy_autoreg_host_1 ON proxy_autoreg_host (clock);
CREATE TABLE dhosts (
dhostid bigint  NOT NULL,
druleid bigint  NOT NULL REFERENCES drules (druleid) ON DELETE CASCADE,
status integer DEFAULT '0' NOT NULL,
lastup integer DEFAULT '0' NOT NULL,
lastdown integer DEFAULT '0' NOT NULL,
PRIMARY KEY (dhostid)
);
CREATE INDEX dhosts_1 ON dhosts (druleid);
CREATE TABLE dservices (
dserviceid bigint  NOT NULL,
dhostid bigint  NOT NULL REFERENCES dhosts (dhostid) ON DELETE CASCADE,
type integer DEFAULT '0' NOT NULL,
key_ varchar(255) DEFAULT '' NOT NULL,
value varchar(255) DEFAULT '' NOT NULL,
port integer DEFAULT '0' NOT NULL,
status integer DEFAULT '0' NOT NULL,
lastup integer DEFAULT '0' NOT NULL,
lastdown integer DEFAULT '0' NOT NULL,
dcheckid bigint  NOT NULL REFERENCES dchecks (dcheckid) ON DELETE CASCADE,
ip varchar(39) DEFAULT '' NOT NULL,
dns varchar(64) DEFAULT '' NOT NULL,
PRIMARY KEY (dserviceid)
);
CREATE UNIQUE INDEX dservices_1 ON dservices (dcheckid,type,key_,ip,port);
CREATE INDEX dservices_2 ON dservices (dhostid);
CREATE TABLE escalations (
escalationid bigint  NOT NULL,
actionid bigint  NOT NULL,
triggerid bigint  NULL,
eventid bigint  NULL,
r_eventid bigint  NULL,
nextcheck integer DEFAULT '0' NOT NULL,
esc_step integer DEFAULT '0' NOT NULL,
status integer DEFAULT '0' NOT NULL,
PRIMARY KEY (escalationid)
);
CREATE INDEX escalations_1 ON escalations (actionid,triggerid);
CREATE TABLE globalvars (
globalvarid bigint  NOT NULL,
snmp_lastsize integer DEFAULT '0' NOT NULL,
PRIMARY KEY (globalvarid)
);
CREATE TABLE graph_discovery (
graphdiscoveryid bigint  NOT NULL,
graphid bigint  NOT NULL REFERENCES graphs (graphid) ON DELETE CASCADE,
parent_graphid bigint  NOT NULL REFERENCES graphs (graphid) ON DELETE CASCADE,
name varchar(128) DEFAULT '' NOT NULL,
PRIMARY KEY (graphdiscoveryid)
);
CREATE UNIQUE INDEX graph_discovery_1 ON graph_discovery (graphid,parent_graphid);
CREATE TABLE host_inventory (
hostid bigint  NOT NULL REFERENCES hosts (hostid) ON DELETE CASCADE,
inventory_mode integer DEFAULT '0' NOT NULL,
type varchar(64) DEFAULT '' NOT NULL,
type_full varchar(64) DEFAULT '' NOT NULL,
name varchar(64) DEFAULT '' NOT NULL,
alias varchar(64) DEFAULT '' NOT NULL,
os varchar(64) DEFAULT '' NOT NULL,
os_full varchar(255) DEFAULT '' NOT NULL,
os_short varchar(64) DEFAULT '' NOT NULL,
serialno_a varchar(64) DEFAULT '' NOT NULL,
serialno_b varchar(64) DEFAULT '' NOT NULL,
tag varchar(64) DEFAULT '' NOT NULL,
asset_tag varchar(64) DEFAULT '' NOT NULL,
macaddress_a varchar(64) DEFAULT '' NOT NULL,
macaddress_b varchar(64) DEFAULT '' NOT NULL,
hardware varchar(255) DEFAULT '' NOT NULL,
hardware_full text DEFAULT '' NOT NULL,
software varchar(255) DEFAULT '' NOT NULL,
software_full text DEFAULT '' NOT NULL,
software_app_a varchar(64) DEFAULT '' NOT NULL,
software_app_b varchar(64) DEFAULT '' NOT NULL,
software_app_c varchar(64) DEFAULT '' NOT NULL,
software_app_d varchar(64) DEFAULT '' NOT NULL,
software_app_e varchar(64) DEFAULT '' NOT NULL,
contact text DEFAULT '' NOT NULL,
location text DEFAULT '' NOT NULL,
location_lat varchar(16) DEFAULT '' NOT NULL,
location_lon varchar(16) DEFAULT '' NOT NULL,
notes text DEFAULT '' NOT NULL,
chassis varchar(64) DEFAULT '' NOT NULL,
model varchar(64) DEFAULT '' NOT NULL,
hw_arch varchar(32) DEFAULT '' NOT NULL,
vendor varchar(64) DEFAULT '' NOT NULL,
contract_number varchar(64) DEFAULT '' NOT NULL,
installer_name varchar(64) DEFAULT '' NOT NULL,
deployment_status varchar(64) DEFAULT '' NOT NULL,
url_a varchar(255) DEFAULT '' NOT NULL,
url_b varchar(255) DEFAULT '' NOT NULL,
url_c varchar(255) DEFAULT '' NOT NULL,
host_networks text DEFAULT '' NOT NULL,
host_netmask varchar(39) DEFAULT '' NOT NULL,
host_router varchar(39) DEFAULT '' NOT NULL,
oob_ip varchar(39) DEFAULT '' NOT NULL,
oob_netmask varchar(39) DEFAULT '' NOT NULL,
oob_router varchar(39) DEFAULT '' NOT NULL,
date_hw_purchase varchar(64) DEFAULT '' NOT NULL,
date_hw_install varchar(64) DEFAULT '' NOT NULL,
date_hw_expiry varchar(64) DEFAULT '' NOT NULL,
date_hw_decomm varchar(64) DEFAULT '' NOT NULL,
site_address_a varchar(128) DEFAULT '' NOT NULL,
site_address_b varchar(128) DEFAULT '' NOT NULL,
site_address_c varchar(128) DEFAULT '' NOT NULL,
site_city varchar(128) DEFAULT '' NOT NULL,
site_state varchar(64) DEFAULT '' NOT NULL,
site_country varchar(64) DEFAULT '' NOT NULL,
site_zip varchar(64) DEFAULT '' NOT NULL,
site_rack varchar(128) DEFAULT '' NOT NULL,
site_notes text DEFAULT '' NOT NULL,
poc_1_name varchar(128) DEFAULT '' NOT NULL,
poc_1_email varchar(128) DEFAULT '' NOT NULL,
poc_1_phone_a varchar(64) DEFAULT '' NOT NULL,
poc_1_phone_b varchar(64) DEFAULT '' NOT NULL,
poc_1_cell varchar(64) DEFAULT '' NOT NULL,
poc_1_screen varchar(64) DEFAULT '' NOT NULL,
poc_1_notes text DEFAULT '' NOT NULL,
poc_2_name varchar(128) DEFAULT '' NOT NULL,
poc_2_email varchar(128) DEFAULT '' NOT NULL,
poc_2_phone_a varchar(64) DEFAULT '' NOT NULL,
poc_2_phone_b varchar(64) DEFAULT '' NOT NULL,
poc_2_cell varchar(64) DEFAULT '' NOT NULL,
poc_2_screen varchar(64) DEFAULT '' NOT NULL,
poc_2_notes text DEFAULT '' NOT NULL,
PRIMARY KEY (hostid)
);
CREATE TABLE housekeeper (
housekeeperid bigint  NOT NULL,
tablename varchar(64) DEFAULT '' NOT NULL,
field varchar(64) DEFAULT '' NOT NULL,
value bigint  NOT NULL,
PRIMARY KEY (housekeeperid)
);
CREATE TABLE images (
imageid bigint  NOT NULL,
imagetype integer DEFAULT '0' NOT NULL,
name varchar(64) DEFAULT '0' NOT NULL,
image longblob DEFAULT '' NOT NULL,
PRIMARY KEY (imageid)
);
CREATE INDEX images_1 ON images (imagetype,name);
CREATE TABLE item_discovery (
itemdiscoveryid bigint  NOT NULL,
itemid bigint  NOT NULL REFERENCES items (itemid) ON DELETE CASCADE,
parent_itemid bigint  NOT NULL REFERENCES items (itemid) ON DELETE CASCADE,
key_ varchar(255) DEFAULT '' NOT NULL,
lastcheck integer DEFAULT '0' NOT NULL,
ts_delete integer DEFAULT '0' NOT NULL,
PRIMARY KEY (itemdiscoveryid)
);
CREATE UNIQUE INDEX item_discovery_1 ON item_discovery (itemid,parent_itemid);
CREATE TABLE profiles (
profileid bigint  NOT NULL,
userid bigint  NOT NULL REFERENCES users (userid) ON DELETE CASCADE,
idx varchar(96) DEFAULT '' NOT NULL,
idx2 bigint DEFAULT '0' NOT NULL,
value_id bigint DEFAULT '0' NOT NULL,
value_int integer DEFAULT '0' NOT NULL,
value_str varchar(255) DEFAULT '' NOT NULL,
source varchar(96) DEFAULT '' NOT NULL,
type integer DEFAULT '0' NOT NULL,
PRIMARY KEY (profileid)
);
CREATE INDEX profiles_1 ON profiles (userid,idx,idx2);
CREATE INDEX profiles_2 ON profiles (userid,profileid);
CREATE TABLE sessions (
sessionid varchar(32) DEFAULT '' NOT NULL,
userid bigint  NOT NULL REFERENCES users (userid) ON DELETE CASCADE,
lastaccess integer DEFAULT '0' NOT NULL,
status integer DEFAULT '0' NOT NULL,
PRIMARY KEY (sessionid)
);
CREATE INDEX sessions_1 ON sessions (userid,status);
CREATE TABLE trigger_discovery (
triggerdiscoveryid bigint  NOT NULL,
triggerid bigint  NOT NULL REFERENCES triggers (triggerid) ON DELETE CASCADE,
parent_triggerid bigint  NOT NULL REFERENCES triggers (triggerid) ON DELETE CASCADE,
name varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (triggerdiscoveryid)
);
CREATE UNIQUE INDEX trigger_discovery_1 ON trigger_discovery (triggerid,parent_triggerid);
CREATE TABLE user_history (
userhistoryid bigint  NOT NULL,
userid bigint  NOT NULL REFERENCES users (userid) ON DELETE CASCADE,
title1 varchar(255) DEFAULT '' NOT NULL,
url1 varchar(255) DEFAULT '' NOT NULL,
title2 varchar(255) DEFAULT '' NOT NULL,
url2 varchar(255) DEFAULT '' NOT NULL,
title3 varchar(255) DEFAULT '' NOT NULL,
url3 varchar(255) DEFAULT '' NOT NULL,
title4 varchar(255) DEFAULT '' NOT NULL,
url4 varchar(255) DEFAULT '' NOT NULL,
title5 varchar(255) DEFAULT '' NOT NULL,
url5 varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (userhistoryid)
);
CREATE UNIQUE INDEX user_history_1 ON user_history (userid);
]
 19356:20140305:035903.519 In init_database_cache()
 19356:20140305:035903.519 In zbx_mem_required_size() size:0 chunks_num:4 descr:'history cache' param:'HistoryCacheSize'
 19356:20140305:035903.520 End of zbx_mem_required_size() size:495
 19356:20140305:035903.520 In zbx_mem_create() descr:'history cache' param:'HistoryCacheSize' size:8388575
 19356:20140305:035903.520 valid user addresses: [0x7f3345d9d160, 0x7f334659cfd8] total size: 8388216
 19356:20140305:035903.520 End of zbx_mem_create()
 19356:20140305:035903.521 In zbx_mem_required_size() size:0 chunks_num:1 descr:'history text cache' param:'HistoryTextCacheSize'
 19356:20140305:035903.521 End of zbx_mem_required_size() size:411
 19356:20140305:035903.521 In zbx_mem_create() descr:'history text cache' param:'HistoryTextCacheSize' size:16777216
 19356:20140305:035903.521 valid user addresses: [0x7f3344d9d168, 0x7f3345d9cff8] total size: 16776848
 19356:20140305:035903.522 End of zbx_mem_create()
 19356:20140305:035903.522 End of init_database_cache()
 19356:20140305:035903.522 In init_configuration_cache() size:8388608
 19356:20140305:035903.522 In zbx_mem_create() descr:'configuration cache' param:'CacheSize' size:7130317
 19356:20140305:035903.522 valid user addresses: [0x7f33446d0160, 0x7f3344d9ccc8] total size: 7129960
 19356:20140305:035903.523 End of zbx_mem_create()
 19356:20140305:035903.523 In zbx_strpool_create()
 19356:20140305:035903.523 In zbx_mem_create() descr:'string pool' param:'CacheSize' size:1258291
 19356:20140305:035903.524 valid user addresses: [0x7f334cc7f158, 0x7f334cdb2328] total size: 1257936
 19356:20140305:035903.524 End of zbx_mem_create()
 19356:20140305:035903.524 End of zbx_strpool_create()
 19356:20140305:035903.524 End of init_configuration_cache()
 19356:20140305:035903.525 In init_selfmon_collector()
 19356:20140305:035903.525 init_selfmon_collector() size:5992
 19356:20140305:035903.525 End of init_selfmon_collector() collector:0x7f334cdc9000
 19356:20140305:035903.525 In DBconnect() flag:0
 19356:20140305:035903.526 query [txnlev:0] [PRAGMA synchronous = 0]
 19356:20140305:035903.531 query [txnlev:0] [PRAGMA temp_store = 2]
 19356:20140305:035903.532 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
 19356:20140305:035903.532 End of DBconnect():0
 19356:20140305:035903.532 In DCsync_configuration()
 19356:20140305:035903.532 query [txnlev:0] [select alert_history,event_history,refresh_unsupported,discovery_groupid,snmptrap_logging,severity_name_0,severity_name_1,severity_name_2,severity_name_3,severity_name_4,severity_name_5 from config where 1=1]
 19356:20140305:035903.533 query [txnlev:0] [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)]
 19356:20140305:035903.533 query [txnlev:0] [select distinct t.triggerid,t.description,t.expression,t.error,t.priority,t.type,t.value,t.value_flags from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and h.status in (0) and i.status in (0,3) and t.status in (0) and t.flags not in (2)]
 19356:20140305:035903.534 query [txnlev:0] [select d.triggerid_down,d.triggerid_up from trigger_depends d where 1=1 order by d.triggerid_down]
 19356:20140305:035903.534 query [txnlev:0] [select i.itemid,f.functionid,f.function,f.parameter,t.triggerid from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and h.status in (0) and i.status in (0,3) and t.status in (0) and t.flags not in (2)]
 19356:20140305:035903.535 query [txnlev:0] [select hostid,proxy_hostid,host,ipmi_authtype,ipmi_privilege,ipmi_username,ipmi_password,maintenance_status,maintenance_type,maintenance_from,errors_from,available,disable_until,snmp_errors_from,snmp_available,snmp_disable_until,ipmi_errors_from,ipmi_available,ipmi_disable_until,jmx_errors_from,jmx_available,jmx_disable_until,status,name from hosts where status in (0,5,6)]
 19356:20140305:035903.535 query [txnlev:0] [select hostid,templateid from hosts_templates where 1=1 order by hostid,templateid]
 19356:20140305:035903.536 query [txnlev:0] [select globalmacroid,macro,value from globalmacro where 1=1]
 19356:20140305:035903.536 query [txnlev:0] [select hostmacroid,hostid,macro,value from hostmacro where 1=1]
 19356:20140305:035903.536 query [txnlev:0] [select interfaceid,hostid,type,main,useip,ip,dns,port from interface where 1=1]
 19356:20140305:035903.537 In DCsync_config()
 19356:20140305:035903.537 End of DCsync_config()
 19356:20140305:035903.537 In DCsync_items()
 19356:20140305:035903.537 End of DCsync_items()
 19356:20140305:035903.537 In DCsync_triggers()
 19356:20140305:035903.538 End of DCsync_triggers()
 19356:20140305:035903.538 In DCsync_trigdeps()
 19356:20140305:035903.538 End of DCsync_trigdeps()
 19356:20140305:035903.538 In DCsync_functions()
 19356:20140305:035903.538 End of DCsync_functions()
 19356:20140305:035903.539 In DCsync_hosts()
 19356:20140305:035903.539 End of DCsync_hosts()
 19356:20140305:035903.539 In DCsync_htmpls()
 19356:20140305:035903.539 End of DCsync_htmpls()
 19356:20140305:035903.539 In DCsync_gmacros()
 19356:20140305:035903.540 End of DCsync_gmacros()
 19356:20140305:035903.540 In DCsync_hmacros()
 19356:20140305:035903.540 End of DCsync_hmacros()
 19356:20140305:035903.540 In DCsync_interfaces()
 19356:20140305:035903.540 End of DCsync_interfaces()
 19356:20140305:035903.541 DCsync_configuration() config     : sql:0.000418 sync:0.000457 sec.
 19356:20140305:035903.541 DCsync_configuration() items      : sql:0.000654 sync:0.000391 sec.
 19356:20140305:035903.541 DCsync_configuration() triggers   : sql:0.000537 sync:0.000389 sec.
 19356:20140305:035903.541 DCsync_configuration() trigdeps   : sql:0.000336 sync:0.000390 sec.
 19356:20140305:035903.541 DCsync_configuration() functions  : sql:0.000479 sync:0.000390 sec.
 19356:20140305:035903.542 DCsync_configuration() hosts      : sql:0.000488 sync:0.000393 sec.
 19356:20140305:035903.542 DCsync_configuration() templates  : sql:0.000328 sync:0.000386 sec.
 19356:20140305:035903.542 DCsync_configuration() globmacros : sql:0.000319 sync:0.000392 sec.
 19356:20140305:035903.542 DCsync_configuration() hostmacros : sql:0.000319 sync:0.000387 sec.
 19356:20140305:035903.542 DCsync_configuration() interfaces : sql:0.000327 sync:0.000390 sec.
 19356:20140305:035903.543 DCsync_configuration() total sync : 0.003966 sec.
 19356:20140305:035903.543 DCsync_configuration() total      : 0.008170 sec.
 19356:20140305:035903.543 DCsync_configuration() items      : 0 (1009 slots)
 19356:20140305:035903.543 DCsync_configuration() items_hk   : 0 (1009 slots)
 19356:20140305:035903.543 DCsync_configuration() snmpitems  : 0 (1009 slots)
 19356:20140305:035903.544 DCsync_configuration() ipmiitems  : 0 (1009 slots)
 19356:20140305:035903.544 DCsync_configuration() flexitems  : 0 (1009 slots)
 19356:20140305:035903.544 DCsync_configuration() trapitems  : 0 (1009 slots)
 19356:20140305:035903.544 DCsync_configuration() logitems   : 0 (1009 slots)
 19356:20140305:035903.544 DCsync_configuration() dbitems    : 0 (1009 slots)
 19356:20140305:035903.545 DCsync_configuration() sshitems   : 0 (1009 slots)
 19356:20140305:035903.545 DCsync_configuration() telnetitems: 0 (1009 slots)
 19356:20140305:035903.545 DCsync_configuration() jmxitems   : 0 (1009 slots)
 19356:20140305:035903.545 DCsync_configuration() calcitems  : 0 (1009 slots)
 19356:20140305:035903.545 DCsync_configuration() functions  : 0 (1009 slots)
 19356:20140305:035903.546 DCsync_configuration() triggers   : 0 (1009 slots)
 19356:20140305:035903.546 DCsync_configuration() trigdeps   : 0 (1009 slots)
 19356:20140305:035903.546 DCsync_configuration() time_trigs : 0 (0 allocated)
 19356:20140305:035903.546 DCsync_configuration() hosts      : 0 (1009 slots)
 19356:20140305:035903.546 DCsync_configuration() hosts_ph   : 0 (1009 slots)
 19356:20140305:035903.547 DCsync_configuration() proxies    : 0 (1009 slots)
 19356:20140305:035903.547 DCsync_configuration() ipmihosts  : 0 (1009 slots)
 19356:20140305:035903.547 DCsync_configuration() htmpls     : 0 (1009 slots)
 19356:20140305:035903.547 DCsync_configuration() gmacros    : 0 (1009 slots)
 19356:20140305:035903.547 DCsync_configuration() gmacros_m  : 0 (1009 slots)
 19356:20140305:035903.548 DCsync_configuration() hmacros    : 0 (1009 slots)
 19356:20140305:035903.548 DCsync_configuration() hmacros_hm : 0 (1009 slots)
 19356:20140305:035903.548 DCsync_configuration() interfaces : 0 (1009 slots)
 19356:20140305:035903.548 DCsync_configuration() interfac_ht: 0 (1009 slots)
 19356:20140305:035903.548 DCsync_configuration() if_snmpitms: 0 (1009 slots)
 19356:20140305:035903.549 DCsync_configuration() if_snmpaddr: 0 (1009 slots)
 19356:20140305:035903.549 DCsync_configuration() queue[0]   : 0 (0 allocated)
 19356:20140305:035903.549 DCsync_configuration() queue[1]   : 0 (0 allocated)
 19356:20140305:035903.549 DCsync_configuration() queue[2]   : 0 (0 allocated)
 19356:20140305:035903.549 DCsync_configuration() queue[3]   : 0 (0 allocated)
 19356:20140305:035903.550 DCsync_configuration() queue[4]   : 0 (0 allocated)
 19356:20140305:035903.550 DCsync_configuration() pqueue     : 0 (0 allocated)
 19356:20140305:035903.550 DCsync_configuration() configfree : 96.085265%
 19356:20140305:035903.550 DCsync_configuration() strings    : 6 (1009 slots)
 19356:20140305:035903.550 DCsync_configuration() strpoolfree: 99.294042%
 19356:20140305:035903.551 === memory statistics for configuration cache ===
 19356:20140305:035903.551 free chunks of size >= 256 bytes:        1
 19356:20140305:035903.551 min chunk size:    6851184 bytes
 19356:20140305:035903.551 max chunk size:    6851184 bytes
 19356:20140305:035903.551 memory of total size 7129960 bytes fragmented into 43 chunks
 19356:20140305:035903.552 of those,    6851184 bytes are in        1 free chunks
 19356:20140305:035903.552 of those,     278440 bytes are in       42 used chunks
 19356:20140305:035903.552 ================================
 19356:20140305:035903.552 === memory statistics for string pool ===
 19356:20140305:035903.552 free chunks of size >= 256 bytes:        1
 19356:20140305:035903.553 min chunk size:    1249408 bytes
 19356:20140305:035903.553 max chunk size:    1249408 bytes
 19356:20140305:035903.553 memory of total size 1257936 bytes fragmented into 15 chunks
 19356:20140305:035903.553 of those,    1249408 bytes are in        1 free chunks
 19356:20140305:035903.553 of those,       8416 bytes are in       14 used chunks
 19356:20140305:035903.554 ================================
 19356:20140305:035903.554 End of DCsync_configuration()
 19360:20140305:035903.564 proxy #4 started [poller #1]
 19357:20140305:035903.565 proxy #1 started [configuration syncer #1]
 19357:20140305:035903.565 In main_proxyconfig_loop()
 19357:20140305:035903.566 In DBconnect() flag:0
 19358:20140305:035903.566 proxy #2 started [heartbeat sender #1]
 19357:20140305:035903.567 query [txnlev:0] [PRAGMA synchronous = 0]
 19359:20140305:035903.568 proxy #3 started [data sender #1]
 19358:20140305:035903.568 In main_heart_loop()
 19358:20140305:035903.569 In send_heartbeat()
 19359:20140305:035903.573 In main_datasender_loop()
 19358:20140305:035903.573 In connect_to_server() [10.168.24.153]:10051 [timeout:60]
 19359:20140305:035903.574 In DBconnect() flag:0
 19359:20140305:035903.577 query [txnlev:0] [PRAGMA synchronous = 0]
 19360:20140305:035903.581 In main_poller_loop() process_type:'poller' process_num:1
 19360:20140305:035903.581 In DBconnect() flag:0
 19360:20140305:035903.584 query [txnlev:0] [PRAGMA synchronous = 0]
 19359:20140305:035903.591 query [txnlev:0] [PRAGMA temp_store = 2]
 19357:20140305:035903.593 query [txnlev:0] [PRAGMA temp_store = 2]
 19363:20140305:035903.596 proxy #7 started [poller #4]
 19362:20140305:035903.600 proxy #6 started [poller #3]
 19361:20140305:035903.601 proxy #5 started [poller #2]
 19361:20140305:035903.609 In main_poller_loop() process_type:'poller' process_num:2
 19361:20140305:035903.609 In DBconnect() flag:0
 19361:20140305:035903.610 query [txnlev:0] [PRAGMA synchronous = 0]
 19365:20140305:035903.616 proxy #9 started [unreachable poller #1]
 19363:20140305:035903.617 In main_poller_loop() process_type:'poller' process_num:4
 19363:20140305:035903.617 In DBconnect() flag:0
 19364:20140305:035903.617 proxy #8 started [poller #5]
 19363:20140305:035903.618 query [txnlev:0] [PRAGMA synchronous = 0]
 19362:20140305:035903.618 In main_poller_loop() process_type:'poller' process_num:3
 19362:20140305:035903.619 In DBconnect() flag:0
 19362:20140305:035903.619 query [txnlev:0] [PRAGMA synchronous = 0]
 19364:20140305:035903.619 In main_poller_loop() process_type:'poller' process_num:5
 19364:20140305:035903.620 In DBconnect() flag:0
 19364:20140305:035903.620 query [txnlev:0] [PRAGMA synchronous = 0]
 19357:20140305:035903.624 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
 19360:20140305:035903.629 query [txnlev:0] [PRAGMA temp_store = 2]
 19367:20140305:035903.629 proxy #11 started [trapper #2]
 19366:20140305:035903.630 proxy #10 started [trapper #1]
 19368:20140305:035903.631 proxy #12 started [trapper #3]
 19365:20140305:035903.631 In main_poller_loop() process_type:'unreachable poller' process_num:1
 19365:20140305:035903.631 In DBconnect() flag:0
 19367:20140305:035903.632 In main_trapper_loop()
 19366:20140305:035903.632 In main_trapper_loop()
 19367:20140305:035903.633 In DBconnect() flag:0
 19366:20140305:035903.633 In DBconnect() flag:0
 19368:20140305:035903.634 In main_trapper_loop()
 19359:20140305:035903.635 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
 19367:20140305:035903.645 query [txnlev:0] [PRAGMA synchronous = 0]
 19365:20140305:035903.646 query [txnlev:0] [PRAGMA synchronous = 0]
 19368:20140305:035903.646 In DBconnect() flag:0
 19366:20140305:035903.647 query [txnlev:0] [PRAGMA synchronous = 0]
 19368:20140305:035903.648 query [txnlev:0] [PRAGMA synchronous = 0]
 19361:20140305:035903.648 query [txnlev:0] [PRAGMA temp_store = 2]
 19370:20140305:035903.652 proxy #14 started [trapper #5]
 19369:20140305:035903.652 proxy #13 started [trapper #4]
 19363:20140305:035903.653 query [txnlev:0] [PRAGMA temp_store = 2]
 19369:20140305:035903.653 In main_trapper_loop()
 19369:20140305:035903.654 In DBconnect() flag:0
 19357:20140305:035903.654 End of DBconnect():0
 19357:20140305:035903.657 In process_configuration_sync()
 19357:20140305:035903.657 In connect_to_server() [10.168.24.153]:10051 [timeout:600]
 19360:20140305:035903.661 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
 19359:20140305:035903.661 End of DBconnect():0
 19359:20140305:035903.661 In host_availability_sender()
 19359:20140305:035903.661 In get_host_availability_data()
 19359:20140305:035903.662 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
 19370:20140305:035903.665 In main_trapper_loop()
 19369:20140305:035903.666 query [txnlev:0] [PRAGMA synchronous = 0]
 19361:20140305:035903.668 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
 19370:20140305:035903.673 In DBconnect() flag:0
 19362:20140305:035903.673 query [txnlev:0] [PRAGMA temp_store = 2]
 19370:20140305:035903.674 query [txnlev:0] [PRAGMA synchronous = 0]
 19371:20140305:035903.677 proxy #15 started [icmp pinger #1]
 19371:20140305:035903.689 In main_pinger_loop() process_num:1
 19371:20140305:035903.689 In DBconnect() flag:0
 19364:20140305:035903.689 query [txnlev:0] [PRAGMA temp_store = 2]
 19365:20140305:035903.690 query [txnlev:0] [PRAGMA temp_store = 2]
 19371:20140305:035903.691 query [txnlev:0] [PRAGMA synchronous = 0]
 19367:20140305:035903.693 query [txnlev:0] [PRAGMA temp_store = 2]
 19360:20140305:035903.694 End of DBconnect():0
 19359:20140305:035903.694 End of get_host_availability_data():FAIL
 19363:20140305:035903.694 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
 19361:20140305:035903.695 End of DBconnect():0
 19362:20140305:035903.695 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
 19360:20140305:035903.697 In get_values()
 19361:20140305:035903.697 In get_values()
 19359:20140305:035903.697 End of host_availability_sender()
 19360:20140305:035903.697 In DCconfig_get_poller_items() poller_type:0
 19361:20140305:035903.698 In DCconfig_get_poller_items() poller_type:0
 19359:20140305:035903.698 In history_sender()
 19360:20140305:035903.698 End of DCconfig_get_poller_items():0
 19361:20140305:035903.698 End of DCconfig_get_poller_items():0
 19359:20140305:035903.699 In proxy_get_history_data() table:'proxy_history'
 19360:20140305:035903.699 End of get_values():0
 19361:20140305:035903.699 End of get_values():0
 19359:20140305:035903.699 In proxy_get_lastid() [proxy_history.history_lastid]
 19360:20140305:035903.700 poller #1 spent 0.002941 seconds while updating 0 values
 19361:20140305:035903.700 poller #2 spent 0.002879 seconds while updating 0 values
 19359:20140305:035903.700 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
 19360:20140305:035903.700 In DCconfig_get_poller_nextcheck() poller_type:0
 19361:20140305:035903.701 In DCconfig_get_poller_nextcheck() poller_type:0
 19360:20140305:035903.701 End of DCconfig_get_poller_nextcheck():-1
 19361:20140305:035903.701 End of DCconfig_get_poller_nextcheck():-1
 19360:20140305:035903.701 sleeping for 5 seconds
 19361:20140305:035903.701 sleeping for 5 seconds
 19366:20140305:035903.705 query [txnlev:0] [PRAGMA temp_store = 2]
 19372:20140305:035903.705 proxy #16 started [housekeeper #1]
 19368:20140305:035903.706 query [txnlev:0] [PRAGMA temp_store = 2]
 19372:20140305:035903.706 executing housekeeper
 19372:20140305:035903.709 In DBconnect() flag:0
 19372:20140305:035903.710 query [txnlev:0] [PRAGMA synchronous = 0]
 19364:20140305:035903.716 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
 19365:20140305:035903.716 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
 19367:20140305:035903.716 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
 19373:20140305:035903.721 proxy #17 started [http poller #1]
 19369:20140305:035903.725 query [txnlev:0] [PRAGMA temp_store = 2]
 19373:20140305:035903.725 In main_httppoller_loop() process_num:1
 19373:20140305:035903.725 In DBconnect() flag:0
 19373:20140305:035903.726 query [txnlev:0] [PRAGMA synchronous = 0]
 19362:20140305:035903.728 End of DBconnect():0
 19363:20140305:035903.728 End of DBconnect():0
 19359:20140305:035903.728 End of proxy_get_lastid():0
 19368:20140305:035903.729 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
 19365:20140305:035903.729 End of DBconnect():0
 19364:20140305:035903.729 End of DBconnect():0
 19367:20140305:035903.729 End of DBconnect():0
 19366:20140305:035903.730 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
 19364:20140305:035903.730 In get_values()
 19363:20140305:035903.730 In get_values()
 19365:20140305:035903.730 In get_values()
 19362:20140305:035903.731 In get_values()
 19359:20140305:035903.731 query [txnlev:0] [select p.id,h.host,i.key_,p.clock,p.ns,p.timestamp,p.source,p.severity,p.value,p.logeventid,p.status from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p.itemid and p.id>0 order by p.id limit 1000]
 19364:20140305:035903.731 In DCconfig_get_poller_items() poller_type:0
 19363:20140305:035903.731 In DCconfig_get_poller_items() poller_type:0
 19365:20140305:035903.732 In DCconfig_get_poller_items() poller_type:1
 19362:20140305:035903.732 In DCconfig_get_poller_items() poller_type:0
 19364:20140305:035903.732 End of DCconfig_get_poller_items():0
 19363:20140305:035903.732 End of DCconfig_get_poller_items():0
 19365:20140305:035903.733 End of DCconfig_get_poller_items():0
 19362:20140305:035903.733 End of DCconfig_get_poller_items():0
 19363:20140305:035903.733 End of get_values():0
 19364:20140305:035903.733 End of get_values():0
 19365:20140305:035903.733 End of get_values():0
 19362:20140305:035903.734 End of get_values():0
 19364:20140305:035903.734 poller #5 spent 0.003886 seconds while updating 0 values
 19363:20140305:035903.734 poller #4 spent 0.003865 seconds while updating 0 values
 19365:20140305:035903.734 unreachable poller #1 spent 0.003851 seconds while updating 0 values
 19362:20140305:035903.734 poller #3 spent 0.003816 seconds while updating 0 values
 19363:20140305:035903.735 In DCconfig_get_poller_nextcheck() poller_type:0
 19365:20140305:035903.735 In DCconfig_get_poller_nextcheck() poller_type:1
 19364:20140305:035903.735 In DCconfig_get_poller_nextcheck() poller_type:0
 19362:20140305:035903.735 In DCconfig_get_poller_nextcheck() poller_type:0
 19365:20140305:035903.736 End of DCconfig_get_poller_nextcheck():-1
 19363:20140305:035903.736 End of DCconfig_get_poller_nextcheck():-1
 19364:20140305:035903.736 End of DCconfig_get_poller_nextcheck():-1
 19362:20140305:035903.736 End of DCconfig_get_poller_nextcheck():-1
 19365:20140305:035903.736 sleeping for 5 seconds
 19363:20140305:035903.737 sleeping for 5 seconds
 19364:20140305:035903.737 sleeping for 5 seconds
 19362:20140305:035903.737 sleeping for 5 seconds
 19376:20140305:035903.744 proxy #20 started [history syncer #2]
 19370:20140305:035903.744 query [txnlev:0] [PRAGMA temp_store = 2]
 19371:20140305:035903.744 query [txnlev:0] [PRAGMA temp_store = 2]
 19375:20140305:035903.745 proxy #19 started [history syncer #1]
 19377:20140305:035903.747 proxy #21 started [history syncer #3]
 19376:20140305:035903.748 In main_dbsyncer_loop() process_num:2
 19376:20140305:035903.748 In DBconnect() flag:0
 19369:20140305:035903.751 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
 19368:20140305:035903.751 End of DBconnect():0
 19366:20140305:035903.751 End of DBconnect():0
 19359:20140305:035903.752 End of proxy_get_history_data():0 lastid:0
 19359:20140305:035903.752 End of history_sender()
 19359:20140305:035903.752 In history_sender()
 19359:20140305:035903.753 In proxy_get_history_data() table:'proxy_dhistory'
 19359:20140305:035903.753 In proxy_get_lastid() [proxy_dhistory.dhistory_lastid]
 19359:20140305:035903.753 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
 19375:20140305:035903.757 In main_dbsyncer_loop() process_num:1
 19374:20140305:035903.757 proxy #18 started [discoverer #1]
 19375:20140305:035903.758 In DBconnect() flag:0
 19376:20140305:035903.759 query [txnlev:0] [PRAGMA synchronous = 0]
 19375:20140305:035903.760 query [txnlev:0] [PRAGMA synchronous = 0]
 19374:20140305:035903.760 In main_discoverer_loop() process_num:1
 19374:20140305:035903.760 In DBconnect() flag:0
 19374:20140305:035903.761 query [txnlev:0] [PRAGMA synchronous = 0]
 19377:20140305:035903.761 In main_dbsyncer_loop() process_num:3
 19377:20140305:035903.762 In DBconnect() flag:0
 19370:20140305:035903.764 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
 19371:20140305:035903.764 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
 19369:20140305:035903.765 End of DBconnect():0
 19359:20140305:035903.765 End of proxy_get_lastid():0
 19359:20140305:035903.765 query [txnlev:0] [select p.id,p.clock,p.druleid,p.dcheckid,p.type,p.ip,p.dns,p.port,p.key_,p.value,p.status from proxy_dhistory p where p.id>0 order by p.id limit 1000]
 19377:20140305:035903.769 query [txnlev:0] [PRAGMA synchronous = 0]
 19356:20140305:035903.772 proxy #0 started [main process]
 19372:20140305:035903.772 query [txnlev:0] [PRAGMA temp_store = 2]
 19378:20140305:035903.773 proxy #22 started [history syncer #4]
 19378:20140305:035903.773 In main_dbsyncer_loop() process_num:4
 19373:20140305:035903.774 query [txnlev:0] [PRAGMA temp_store = 2]
 19378:20140305:035903.774 In DBconnect() flag:0
 19378:20140305:035903.775 query [txnlev:0] [PRAGMA synchronous = 0]
 19370:20140305:035903.789 End of DBconnect():0
 19359:20140305:035903.789 End of proxy_get_history_data():0 lastid:0
 19371:20140305:035903.789 End of DBconnect():0
 19372:20140305:035903.789 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
 19371:20140305:035903.794 In get_pinger_hosts()
 19359:20140305:035903.794 End of history_sender()
 19371:20140305:035903.794 In DCconfig_get_poller_items() poller_type:3
 19359:20140305:035903.794 In history_sender()
 19371:20140305:035903.795 End of DCconfig_get_poller_items():0
 19359:20140305:035903.795 In proxy_get_history_data() table:'proxy_autoreg_host'
 19359:20140305:035903.795 In proxy_get_lastid() [proxy_autoreg_host.autoreg_host_lastid]
 19371:20140305:035903.795 End of get_pinger_hosts():0
 19359:20140305:035903.796 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
 19371:20140305:035903.796 In process_pinger_hosts()
 19371:20140305:035903.796 End of process_pinger_hosts()
 19371:20140305:035903.796 icmp pinger #1 spent 0.002765 seconds while processing 0 items
 19371:20140305:035903.797 In DCconfig_get_poller_nextcheck() poller_type:3
 19371:20140305:035903.797 End of DCconfig_get_poller_nextcheck():-1
 19371:20140305:035903.797 sleeping for 5 seconds
 19376:20140305:035903.797 query [txnlev:0] [PRAGMA temp_store = 2]
 19373:20140305:035903.799 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
 19375:20140305:035903.805 query [txnlev:0] [PRAGMA temp_store = 2]
 19377:20140305:035903.805 query [txnlev:0] [PRAGMA temp_store = 2]
 19374:20140305:035903.805 query [txnlev:0] [PRAGMA temp_store = 2]
 19372:20140305:035903.806 End of DBconnect():0
 19359:20140305:035903.806 End of proxy_get_lastid():0
 19376:20140305:035903.807 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
 19373:20140305:035903.807 End of DBconnect():0
 19373:20140305:035903.807 In process_httptests()
 19372:20140305:035903.807 In housekeeping_history()
 19359:20140305:035903.808 query [txnlev:0] [select p.id,p.clock,p.host,p.listen_ip,p.listen_dns,p.listen_port from proxy_autoreg_host p where p.id>0 order by p.id limit 1000]
 19373:20140305:035903.808 query [txnlev:0] [select t.httptestid,t.name,t.macros,t.agent,t.authentication,t.http_user,t.http_password from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.nextcheck<=1393991943 and t.httptestid%1=0 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0)]
 19372:20140305:035903.808 In delete_history() table:'proxy_history' now:1393991943
 19375:20140305:035903.808 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
 19374:20140305:035903.809 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
 19376:20140305:035903.809 End of DBconnect():0
 19376:20140305:035903.809 Syncing ...
 19376:20140305:035903.809 In DCsync_history() history_first:0 history_num:0
 19359:20140305:035903.810 End of proxy_get_history_data():0 lastid:0
 19373:20140305:035903.810 End of process_httptests()
 19372:20140305:035903.810 query [txnlev:1] [begin;]
 19372:20140305:035903.811 query [txnlev:1] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
 19376:20140305:035903.811 history syncer #2 spent 0.001468 seconds while processing 0 items
 19372:20140305:035903.811 query [txnlev:1] [rollback;]
 19359:20140305:035903.811 End of history_sender()
 19376:20140305:035903.812 sleeping for 5 seconds
 19359:20140305:035903.812 Datasender spent 0.150560 seconds while processing   0 values.
 19373:20140305:035903.812 http poller #1 spent 0.004900 seconds while updating HTTP tests
 19372:20140305:035903.812 In delete_history() table:'proxy_dhistory' now:1393991943
 19359:20140305:035903.812 sleeping for 1 seconds
 19373:20140305:035903.813 query [txnlev:0] [select min(t.nextcheck) from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.httptestid%1=0 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0)]
 19375:20140305:035903.813 End of DBconnect():0
 19372:20140305:035903.813 query [txnlev:1] [begin;]
 19372:20140305:035903.814 query [txnlev:1] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
 19372:20140305:035903.814 query [txnlev:1] [rollback;]
 19372:20140305:035903.814 In delete_history() table:'proxy_autoreg_host' now:1393991943
 19373:20140305:035903.814 No httptests to process in get_minnextcheck.
 19373:20140305:035903.815 sleeping for 5 seconds
 19375:20140305:035903.815 Syncing ...
 19377:20140305:035903.809 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
 19377:20140305:035903.815 End of DBconnect():0
 19375:20140305:035903.816 In DCsync_history() history_first:0 history_num:0
 19372:20140305:035903.816 query [txnlev:1] [begin;]
 19372:20140305:035903.816 query [txnlev:1] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
 19377:20140305:035903.816 Syncing ...
 19375:20140305:035903.816 history syncer #1 spent 0.000906 seconds while processing 0 items
 19372:20140305:035903.817 query [txnlev:1] [rollback;]
 19377:20140305:035903.817 In DCsync_history() history_first:0 history_num:0
 19375:20140305:035903.817 sleeping for 5 seconds
 19377:20140305:035903.817 history syncer #3 spent 0.000459 seconds while processing 0 items
 19372:20140305:035903.818 housekeeper deleted 0 records from history (spent 0.010419 seconds)
 19374:20140305:035903.818 End of DBconnect():0
 19374:20140305:035903.818 query [txnlev:0] [select distinct r.druleid,r.iprange,r.name,c.dcheckid from drules r left join dchecks c on c.druleid=r.druleid and uniq=1 where r.proxy_hostid is null and r.status=0 and (r.nextcheck<=1393991943 or r.nextcheck>1393991943+r.delay) and r.druleid%1=0]
 19374:20140305:035903.819 discoverer #1 spent 0.000497 seconds while processing rules
 19377:20140305:035903.819 sleeping for 5 seconds
 19372:20140305:035903.820 sleeping for 3600 seconds
 19374:20140305:035903.820 query [txnlev:0] [select count(*),min(nextcheck) from drules where proxy_hostid is null and status=0 and druleid%1=0]
 19374:20140305:035903.820 get_minnextcheck(): no items to update
 19374:20140305:035903.820 sleeping for 60 seconds
 19378:20140305:035903.821 query [txnlev:0] [PRAGMA temp_store = 2]
 19378:20140305:035903.821 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
 19378:20140305:035903.821 End of DBconnect():0
 19378:20140305:035903.821 Syncing ...
 19378:20140305:035903.822 In DCsync_history() history_first:0 history_num:0
 19378:20140305:035903.822 history syncer #4 spent 0.000260 seconds while processing 0 items
 19378:20140305:035903.822 sleeping for 5 seconds
 19359:20140305:035904.813 In host_availability_sender()
 19359:20140305:035904.814 In get_host_availability_data()
 19359:20140305:035904.814 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
 19359:20140305:035904.814 End of get_host_availability_data():FAIL
 19359:20140305:035904.815 End of host_availability_sender()
 19359:20140305:035904.815 In history_sender()
 19359:20140305:035904.815 In proxy_get_history_data() table:'proxy_history'
 19359:20140305:035904.815 In proxy_get_lastid() [proxy_history.history_lastid]
 19359:20140305:035904.815 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
 19359:20140305:035904.816 End of proxy_get_lastid():0
 19359:20140305:035904.816 query [txnlev:0] [select p.id,h.host,i.key_,p.clock,p.ns,p.timestamp,p.source,p.severity,p.value,p.logeventid,p.status from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p.itemid and p.id>0 order by p.id limit 1000]
 19359:20140305:035904.817 End of proxy_get_history_data():0 lastid:0
 19359:20140305:035904.817 End of history_sender()
 19359:20140305:035904.817 In history_sender()
 19359:20140305:035904.817 In proxy_get_history_data() table:'proxy_dhistory'
 19359:20140305:035904.817 In proxy_get_lastid() [proxy_dhistory.dhistory_lastid]
 19359:20140305:035904.818 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
 19359:20140305:035904.818 End of proxy_get_lastid():0
 19359:20140305:035904.818 query [txnlev:0] [select p.id,p.clock,p.druleid,p.dcheckid,p.type,p.ip,p.dns,p.port,p.key_,p.value,p.status from proxy_dhistory p where p.id>0 order by p.id limit 1000]
 19359:20140305:035904.818 End of proxy_get_history_data():0 lastid:0
 19359:20140305:035904.819 End of history_sender()
 19359:20140305:035904.819 In history_sender()
 19359:20140305:035904.819 In proxy_get_history_data() table:'proxy_autoreg_host'
 19359:20140305:035904.819 In proxy_get_lastid() [proxy_autoreg_host.autoreg_host_lastid]
 19359:20140305:035904.820 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
 19359:20140305:035904.820 End of proxy_get_lastid():0
 19359:20140305:035904.820 query [txnlev:0] [select p.id,p.clock,p.host,p.listen_ip,p.listen_dns,p.listen_port from proxy_autoreg_host p where p.id>0 order by p.id limit 1000]
 19359:20140305:035904.820 End of proxy_get_history_data():0 lastid:0
 19359:20140305:035904.821 End of history_sender()
 19359:20140305:035904.821 Datasender spent 0.007746 seconds while processing   0 values.
 19359:20140305:035904.821 sleeping for 1 seconds
 19359:20140305:035905.821 In host_availability_sender()
 19359:20140305:035905.822 In get_host_availability_data()
 19359:20140305:035905.822 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
 19359:20140305:035905.823 End of get_host_availability_data():FAIL
 19359:20140305:035905.823 End of host_availability_sender()
 19359:20140305:035905.823 In history_sender()
 19359:20140305:035905.823 In proxy_get_history_data() table:'proxy_history'
 19359:20140305:035905.824 In proxy_get_lastid() [proxy_history.history_lastid]
 19359:20140305:035905.824 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
 19359:20140305:035905.824 End of proxy_get_lastid():0
 19359:20140305:035905.824 query [txnlev:0] [select p.id,h.host,i.key_,p.clock,p.ns,p.timestamp,p.source,p.severity,p.value,p.logeventid,p.status from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p.itemid and p.id>0 order by p.id limit 1000]
 19359:20140305:035905.825 End of proxy_get_history_data():0 lastid:0
 19359:20140305:035905.825 End of history_sender()
 19359:20140305:035905.825 In history_sender()
 19359:20140305:035905.825 In proxy_get_history_data() table:'proxy_dhistory'
 19359:20140305:035905.826 In proxy_get_lastid() [proxy_dhistory.dhistory_lastid]
 19359:20140305:035905.826 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
 19359:20140305:035905.826 End of proxy_get_lastid():0
 19359:20140305:035905.826 query [txnlev:0] [select p.id,p.clock,p.druleid,p.dcheckid,p.type,p.ip,p.dns,p.port,p.key_,p.value,p.status from proxy_dhistory p where p.id>0 order by p.id limit 1000]
 19359:20140305:035905.827 End of proxy_get_history_data():0 lastid:0
 19359:20140305:035905.827 End of history_sender()
 19359:20140305:035905.827 In history_sender()
 19359:20140305:035905.827 In proxy_get_history_data() table:'proxy_autoreg_host'
 19359:20140305:035905.827 In proxy_get_lastid() [proxy_autoreg_host.autoreg_host_lastid]
 19359:20140305:035905.828 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
 19359:20140305:035905.828 End of proxy_get_lastid():0
 19359:20140305:035905.828 query [txnlev:0] [select p.id,p.clock,p.host,p.listen_ip,p.listen_dns,p.listen_port from proxy_autoreg_host p where p.id>0 order by p.id limit 1000]
 19359:20140305:035905.829 End of proxy_get_history_data():0 lastid:0
 19359:20140305:035905.829 End of history_sender()
 19359:20140305:035905.829 Datasender spent 0.007570 seconds while processing   0 values.
 19359:20140305:035905.829 sleeping for 1 seconds
 19359:20140305:035906.829 In host_availability_sender()
 19359:20140305:035906.830 In get_host_availability_data()
 19359:20140305:035906.830 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
 19359:20140305:035906.831 End of get_host_availability_data():FAIL
 19359:20140305:035906.831 End of host_availability_sender()
 19359:20140305:035906.831 In history_sender()
 19359:20140305:035906.831 In proxy_get_history_data() table:'proxy_history'
 19359:20140305:035906.832 In proxy_get_lastid() [proxy_history.history_lastid]
 19359:20140305:035906.832 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
 19359:20140305:035906.832 End of proxy_get_lastid():0
 19359:20140305:035906.832 query [txnlev:0] [select p.id,h.host,i.key_,p.clock,p.ns,p.timestamp,p.source,p.severity,p.value,p.logeventid,p.status from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p.itemid and p.id>0 order by p.id limit 1000]
 19359:20140305:035906.833 End of proxy_get_history_data():0 lastid:0
 19359:20140305:035906.833 End of history_sender()
 19359:20140305:035906.833 In history_sender()
 19359:20140305:035906.833 In proxy_get_history_data() table:'proxy_dhistory'
 19359:20140305:035906.834 In proxy_get_lastid() [proxy_dhistory.dhistory_lastid]
 19359:20140305:035906.834 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
 19359:20140305:035906.834 End of proxy_get_lastid():0
 19359:20140305:035906.834 query [txnlev:0] [select p.id,p.clock,p.druleid,p.dcheckid,p.type,p.ip,p.dns,p.port,p.key_,p.value,p.status from proxy_dhistory p where p.id>0 order by p.id limit 1000]
 19359:20140305:035906.835 End of proxy_get_history_data():0 lastid:0
 19359:20140305:035906.835 End of history_sender()
 19359:20140305:035906.835 In history_sender()
 19359:20140305:035906.835 In proxy_get_history_data() table:'proxy_autoreg_host'
 19359:20140305:035906.835 In proxy_get_lastid() [proxy_autoreg_host.autoreg_host_lastid]
 19359:20140305:035906.836 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
 19359:20140305:035906.836 End of proxy_get_lastid():0
 19359:20140305:035906.836 query [txnlev:0] [select p.id,p.clock,p.host,p.listen_ip,p.listen_dns,p.listen_port from proxy_autoreg_host p where p.id>0 order by p.id limit 1000]
 19359:20140305:035906.837 End of proxy_get_history_data():0 lastid:0
 19359:20140305:035906.837 End of history_sender()
 19359:20140305:035906.837 Datasender spent 0.007545 seconds while processing   0 values.
 19359:20140305:035906.837 sleeping for 1 seconds
 19359:20140305:035907.838 In host_availability_sender()
 19359:20140305:035907.838 In get_host_availability_data()
 19359:20140305:035907.838 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
 19359:20140305:035907.839 End of get_host_availability_data():FAIL
 19359:20140305:035907.839 End of host_availability_sender()
 19359:20140305:035907.839 In history_sender()
 19359:20140305:035907.839 In proxy_get_history_data() table:'proxy_history'
 19359:20140305:035907.840 In proxy_get_lastid() [proxy_history.history_lastid]
 19359:20140305:035907.840 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
 19359:20140305:035907.840 End of proxy_get_lastid():0
 19359:20140305:035907.840 query [txnlev:0] [select p.id,h.host,i.key_,p.clock,p.ns,p.timestamp,p.source,p.severity,p.value,p.logeventid,p.status from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p.itemid and p.id>0 order by p.id limit 1000]
 19359:20140305:035907.841 End of proxy_get_history_data():0 lastid:0
 19359:20140305:035907.841 End of history_sender()
 19359:20140305:035907.841 In history_sender()
 19359:20140305:035907.842 In proxy_get_history_data() table:'proxy_dhistory'
 19359:20140305:035907.842 In proxy_get_lastid() [proxy_dhistory.dhistory_lastid]
 19359:20140305:035907.842 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
 19359:20140305:035907.842 End of proxy_get_lastid():0
 19359:20140305:035907.842 query [txnlev:0] [select p.id,p.clock,p.druleid,p.dcheckid,p.type,p.ip,p.dns,p.port,p.key_,p.value,p.status from proxy_dhistory p where p.id>0 order by p.id limit 1000]
 19359:20140305:035907.843 End of proxy_get_history_data():0 lastid:0
 19359:20140305:035907.843 End of history_sender()
 19359:20140305:035907.843 In history_sender()
 19359:20140305:035907.843 In proxy_get_history_data() table:'proxy_autoreg_host'
 19359:20140305:035907.844 In proxy_get_lastid() [proxy_autoreg_host.autoreg_host_lastid]
 19359:20140305:035907.844 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
 19359:20140305:035907.844 End of proxy_get_lastid():0
 19359:20140305:035907.844 query [txnlev:0] [select p.id,p.clock,p.host,p.listen_ip,p.listen_dns,p.listen_port from proxy_autoreg_host p where p.id>0 order by p.id limit 1000]
 19359:20140305:035907.845 End of proxy_get_history_data():0 lastid:0
 19359:20140305:035907.845 End of history_sender()
 19359:20140305:035907.845 Datasender spent 0.007579 seconds while processing   0 values.
 19359:20140305:035907.845 sleeping for 1 seconds
 19360:20140305:035908.702 In get_values()
 19361:20140305:035908.702 In get_values()
 19361:20140305:035908.707 In DCconfig_get_poller_items() poller_type:0
 19361:20140305:035908.707 End of DCconfig_get_poller_items():0
 19360:20140305:035908.707 In DCconfig_get_poller_items() poller_type:0
 19361:20140305:035908.708 End of get_values():0
 19360:20140305:035908.708 End of DCconfig_get_poller_items():0
 19361:20140305:035908.708 poller #2 spent 0.005613 seconds while updating 0 values
 19360:20140305:035908.708 End of get_values():0
 19361:20140305:035908.709 In DCconfig_get_poller_nextcheck() poller_type:0
 19360:20140305:035908.709 poller #1 spent 0.006649 seconds while updating 0 values
 19361:20140305:035908.709 End of DCconfig_get_poller_nextcheck():-1
 19360:20140305:035908.709 In DCconfig_get_poller_nextcheck() poller_type:0
 19361:20140305:035908.709 sleeping for 5 seconds
 19360:20140305:035908.710 End of DCconfig_get_poller_nextcheck():-1
 19360:20140305:035908.710 sleeping for 5 seconds
 19363:20140305:035908.738 In get_values()
 19365:20140305:035908.738 In get_values()
 19364:20140305:035908.738 In get_values()
 19362:20140305:035908.738 In get_values()
 19362:20140305:035908.738 In DCconfig_get_poller_items() poller_type:0
 19365:20140305:035908.739 In DCconfig_get_poller_items() poller_type:1
 19364:20140305:035908.739 In DCconfig_get_poller_items() poller_type:0
 19363:20140305:035908.739 In DCconfig_get_poller_items() poller_type:0
 19365:20140305:035908.739 End of DCconfig_get_poller_items():0
 19362:20140305:035908.739 End of DCconfig_get_poller_items():0
 19364:20140305:035908.740 End of DCconfig_get_poller_items():0
 19363:20140305:035908.740 End of DCconfig_get_poller_items():0
 19365:20140305:035908.740 End of get_values():0
 19362:20140305:035908.740 End of get_values():0
 19364:20140305:035908.740 End of get_values():0
 19363:20140305:035908.741 End of get_values():0
 19365:20140305:035908.741 unreachable poller #1 spent 0.002984 seconds while updating 0 values
 19362:20140305:035908.741 poller #3 spent 0.002784 seconds while updating 0 values
 19364:20140305:035908.741 poller #5 spent 0.003201 seconds while updating 0 values
 19363:20140305:035908.741 poller #4 spent 0.003838 seconds while updating 0 values
 19365:20140305:035908.742 In DCconfig_get_poller_nextcheck() poller_type:1
 19362:20140305:035908.742 In DCconfig_get_poller_nextcheck() poller_type:0
 19364:20140305:035908.742 In DCconfig_get_poller_nextcheck() poller_type:0
 19363:20140305:035908.742 In DCconfig_get_poller_nextcheck() poller_type:0
 19365:20140305:035908.742 End of DCconfig_get_poller_nextcheck():-1
 19362:20140305:035908.743 End of DCconfig_get_poller_nextcheck():-1
 19364:20140305:035908.743 End of DCconfig_get_poller_nextcheck():-1
 19363:20140305:035908.743 End of DCconfig_get_poller_nextcheck():-1
 19365:20140305:035908.743 sleeping for 5 seconds
 19362:20140305:035908.743 sleeping for 5 seconds
 19364:20140305:035908.744 sleeping for 5 seconds
 19363:20140305:035908.744 sleeping for 5 seconds
 19371:20140305:035908.798 In get_pinger_hosts()
 19371:20140305:035908.798 In DCconfig_get_poller_items() poller_type:3
 19371:20140305:035908.798 End of DCconfig_get_poller_items():0
 19371:20140305:035908.799 End of get_pinger_hosts():0
 19371:20140305:035908.799 In process_pinger_hosts()
 19371:20140305:035908.799 End of process_pinger_hosts()
 19371:20140305:035908.799 icmp pinger #1 spent 0.001413 seconds while processing 0 items
 19371:20140305:035908.799 In DCconfig_get_poller_nextcheck() poller_type:3
 19371:20140305:035908.800 End of DCconfig_get_poller_nextcheck():-1
 19371:20140305:035908.800 sleeping for 5 seconds
 19376:20140305:035908.813 Syncing ...
 19376:20140305:035908.813 In DCsync_history() history_first:0 history_num:0
 19376:20140305:035908.813 history syncer #2 spent 0.000219 seconds while processing 0 items
 19376:20140305:035908.813 sleeping for 5 seconds
 19373:20140305:035908.816 In process_httptests()
 19373:20140305:035908.816 query [txnlev:0] [select t.httptestid,t.name,t.macros,t.agent,t.authentication,t.http_user,t.http_password from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.nextcheck<=1393991948 and t.httptestid%1=0 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0)]
 19373:20140305:035908.817 End of process_httptests()
 19373:20140305:035908.817 http poller #1 spent 0.001031 seconds while updating HTTP tests
 19373:20140305:035908.817 query [txnlev:0] [select min(t.nextcheck) from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.httptestid%1=0 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0)]
 19373:20140305:035908.818 No httptests to process in get_minnextcheck.
 19373:20140305:035908.818 sleeping for 5 seconds
 19375:20140305:035908.818 Syncing ...
 19375:20140305:035908.818 In DCsync_history() history_first:0 history_num:0
 19375:20140305:035908.818 history syncer #1 spent 0.000201 seconds while processing 0 items
 19375:20140305:035908.819 sleeping for 5 seconds
 19377:20140305:035908.820 Syncing ...
 19377:20140305:035908.820 In DCsync_history() history_first:0 history_num:0
 19377:20140305:035908.821 history syncer #3 spent 0.000223 seconds while processing 0 items
 19377:20140305:035908.821 sleeping for 5 seconds
 19378:20140305:035908.823 Syncing ...
 19378:20140305:035908.823 In DCsync_history() history_first:0 history_num:0
 19378:20140305:035908.823 history syncer #4 spent 0.000199 seconds while processing 0 items
 19378:20140305:035908.823 sleeping for 5 seconds
 19359:20140305:035908.846 In host_availability_sender()
 19359:20140305:035908.846 In get_host_availability_data()
 19359:20140305:035908.846 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
 19359:20140305:035908.846 End of get_host_availability_data():FAIL
 19359:20140305:035908.847 End of host_availability_sender()
 19359:20140305:035908.847 In history_sender()
 19359:20140305:035908.847 In proxy_get_history_data() table:'proxy_history'
 19359:20140305:035908.847 In proxy_get_lastid() [proxy_history.history_lastid]
 19359:20140305:035908.847 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
 19359:20140305:035908.848 End of proxy_get_lastid():0
 19359:20140305:035908.848 query [txnlev:0] [select p.id,h.host,i.key_,p.clock,p.ns,p.timestamp,p.source,p.severity,p.value,p.logeventid,p.status from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p.itemid and p.id>0 order by p.id limit 1000]
 19359:20140305:035908.848 End of proxy_get_history_data():0 lastid:0
 19359:20140305:035908.849 End of history_sender()
 19359:20140305:035908.849 In history_sender()
 19359:20140305:035908.849 In proxy_get_history_data() table:'proxy_dhistory'
 19359:20140305:035908.849 In proxy_get_lastid() [proxy_dhistory.dhistory_lastid]
 19359:20140305:035908.849 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
 19359:20140305:035908.850 End of proxy_get_lastid():0
 19359:20140305:035908.850 query [txnlev:0] [select p.id,p.clock,p.druleid,p.dcheckid,p.type,p.ip,p.dns,p.port,p.key_,p.value,p.status from proxy_dhistory p where p.id>0 order by p.id limit 1000]
 19359:20140305:035908.850 End of proxy_get_history_data():0 lastid:0
 19359:20140305:035908.851 End of history_sender()
 19359:20140305:035908.851 In history_sender()
 19359:20140305:035908.851 In proxy_get_history_data() table:'proxy_autoreg_host'
 19359:20140305:035908.851 In proxy_get_lastid() [proxy_autoreg_host.autoreg_host_lastid]
 19359:20140305:035908.851 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
 19359:20140305:035908.852 End of proxy_get_lastid():0
 19359:20140305:035908.852 query [txnlev:0] [select p.id,p.clock,p.host,p.listen_ip,p.listen_dns,p.listen_port from proxy_autoreg_host p where p.id>0 order by p.id limit 1000]
 19359:20140305:035908.852 End of proxy_get_history_data():0 lastid:0
 19359:20140305:035908.852 End of history_sender()
 19359:20140305:035908.853 Datasender spent 0.007002 seconds while processing   0 values.
 19359:20140305:035908.853 sleeping for 1 seconds
 19359:20140305:035909.853 In host_availability_sender()
 19359:20140305:035909.854 In get_host_availability_data()
 19359:20140305:035909.854 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
 19359:20140305:035909.854 End of get_host_availability_data():FAIL
 19359:20140305:035909.855 End of host_availability_sender()
 19359:20140305:035909.855 In history_sender()
 19359:20140305:035909.855 In proxy_get_history_data() table:'proxy_history'
 19359:20140305:035909.855 In proxy_get_lastid() [proxy_history.history_lastid]
 19359:20140305:035909.856 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
 19359:20140305:035909.856 End of proxy_get_lastid():0
 19359:20140305:035909.856 query [txnlev:0] [select p.id,h.host,i.key_,p.clock,p.ns,p.timestamp,p.source,p.severity,p.value,p.logeventid,p.status from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p.itemid and p.id>0 order by p.id limit 1000]
 19359:20140305:035909.857 End of proxy_get_history_data():0 lastid:0
 19359:20140305:035909.857 End of history_sender()
 19359:20140305:035909.857 In history_sender()
 19359:20140305:035909.857 In proxy_get_history_data() table:'proxy_dhistory'
 19359:20140305:035909.857 In proxy_get_lastid() [proxy_dhistory.dhistory_lastid]
 19359:20140305:035909.858 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
 19359:20140305:035909.858 End of proxy_get_lastid():0
 19359:20140305:035909.858 query [txnlev:0] [select p.id,p.clock,p.druleid,p.dcheckid,p.type,p.ip,p.dns,p.port,p.key_,p.value,p.status from proxy_dhistory p where p.id>0 order by p.id limit 1000]
 19359:20140305:035909.858 End of proxy_get_history_data():0 lastid:0
 19359:20140305:035909.859 End of history_sender()
 19359:20140305:035909.859 In history_sender()
 19359:20140305:035909.859 In proxy_get_history_data() table:'proxy_autoreg_host'
 19359:20140305:035909.859 In proxy_get_lastid() [proxy_autoreg_host.autoreg_host_lastid]
 19359:20140305:035909.859 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
 19359:20140305:035909.860 End of proxy_get_lastid():0
 19359:20140305:035909.860 query [txnlev:0] [select p.id,p.clock,p.host,p.listen_ip,p.listen_dns,p.listen_port from proxy_autoreg_host p where p.id>0 order by p.id limit 1000]
 19359:20140305:035909.860 End of proxy_get_history_data():0 lastid:0
 19359:20140305:035909.861 End of history_sender()
 19359:20140305:035909.861 Datasender spent 0.007611 seconds while processing   0 values.
 19359:20140305:035909.861 sleeping for 1 seconds
 19359:20140305:035910.861 In host_availability_sender()
 19359:20140305:035910.862 In get_host_availability_data()
 19359:20140305:035910.862 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
 19359:20140305:035910.863 End of get_host_availability_data():FAIL
 19359:20140305:035910.863 End of host_availability_sender()
 19359:20140305:035910.864 In history_sender()
 19359:20140305:035910.864 In proxy_get_history_data() table:'proxy_history'
 19359:20140305:035910.864 In proxy_get_lastid() [proxy_history.history_lastid]
 19359:20140305:035910.865 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
 19359:20140305:035910.865 End of proxy_get_lastid():0
 19359:20140305:035910.865 query [txnlev:0] [select p.id,h.host,i.key_,p.clock,p.ns,p.timestamp,p.source,p.severity,p.value,p.logeventid,p.status from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p.itemid and p.id>0 order by p.id limit 1000]
 19359:20140305:035910.866 End of proxy_get_history_data():0 lastid:0
 19359:20140305:035910.866 End of history_sender()
 19359:20140305:035910.867 In history_sender()
 19359:20140305:035910.867 In proxy_get_history_data() table:'proxy_dhistory'
 19359:20140305:035910.867 In proxy_get_lastid() [proxy_dhistory.dhistory_lastid]
 19359:20140305:035910.867 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
 19359:20140305:035910.868 End of proxy_get_lastid():0
 19359:20140305:035910.868 query [txnlev:0] [select p.id,p.clock,p.druleid,p.dcheckid,p.type,p.ip,p.dns,p.port,p.key_,p.value,p.status from proxy_dhistory p where p.id>0 order by p.id limit 1000]
 19359:20140305:035910.868 End of proxy_get_history_data():0 lastid:0
 19359:20140305:035910.869 End of history_sender()
 19359:20140305:035910.869 In history_sender()
 19359:20140305:035910.869 In proxy_get_history_data() table:'proxy_autoreg_host'
 19359:20140305:035910.869 In proxy_get_lastid() [proxy_autoreg_host.autoreg_host_lastid]
 19359:20140305:035910.869 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
 19359:20140305:035910.870 End of proxy_get_lastid():0
 19359:20140305:035910.870 query [txnlev:0] [select p.id,p.clock,p.host,p.listen_ip,p.listen_dns,p.listen_port from proxy_autoreg_host p where p.id>0 order by p.id limit 1000]
 19359:20140305:035910.870 End of proxy_get_history_data():0 lastid:0
 19359:20140305:035910.871 End of history_sender()
 19359:20140305:035910.871 Datasender spent 0.009369 seconds while processing   0 values.
 19359:20140305:035910.871 sleeping for 1 seconds
 19359:20140305:035911.871 In host_availability_sender()
 19359:20140305:035911.872 In get_host_availability_data()
 19359:20140305:035911.872 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
 19359:20140305:035911.872 End of get_host_availability_data():FAIL
 19359:20140305:035911.873 End of host_availability_sender()
 19359:20140305:035911.873 In history_sender()
 19359:20140305:035911.873 In proxy_get_history_data() table:'proxy_history'
 19359:20140305:035911.873 In proxy_get_lastid() [proxy_history.history_lastid]
 19359:20140305:035911.874 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
 19359:20140305:035911.874 End of proxy_get_lastid():0
 19359:20140305:035911.874 query [txnlev:0] [select p.id,h.host,i.key_,p.clock,p.ns,p.timestamp,p.source,p.severity,p.value,p.logeventid,p.status from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p.itemid and p.id>0 order by p.id limit 1000]
 19359:20140305:035911.875 End of proxy_get_history_data():0 lastid:0
 19359:20140305:035911.875 End of history_sender()
 19359:20140305:035911.875 In history_sender()
 19359:20140305:035911.875 In proxy_get_history_data() table:'proxy_dhistory'
 19359:20140305:035911.875 In proxy_get_lastid() [proxy_dhistory.dhistory_lastid]
 19359:20140305:035911.876 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
 19359:20140305:035911.876 End of proxy_get_lastid():0
 19359:20140305:035911.876 query [txnlev:0] [select p.id,p.clock,p.druleid,p.dcheckid,p.type,p.ip,p.dns,p.port,p.key_,p.value,p.status from proxy_dhistory p where p.id>0 order by p.id limit 1000]
 19359:20140305:035911.876 End of proxy_get_history_data():0 lastid:0
 19359:20140305:035911.877 End of history_sender()
 19359:20140305:035911.877 In history_sender()
 19359:20140305:035911.877 In proxy_get_history_data() table:'proxy_autoreg_host'
 19359:20140305:035911.877 In proxy_get_lastid() [proxy_autoreg_host.autoreg_host_lastid]
 19359:20140305:035911.877 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
 19359:20140305:035911.878 End of proxy_get_lastid():0
 19359:20140305:035911.878 query [txnlev:0] [select p.id,p.clock,p.host,p.listen_ip,p.listen_dns,p.listen_port from proxy_autoreg_host p where p.id>0 order by p.id limit 1000]
 19359:20140305:035911.878 End of proxy_get_history_data():0 lastid:0
 19359:20140305:035911.879 End of history_sender()
 19359:20140305:035911.879 Datasender spent 0.007469 seconds while processing   0 values.
 19359:20140305:035911.879 sleeping for 1 seconds
 19359:20140305:035912.879 In host_availability_sender()
 19359:20140305:035912.880 In get_host_availability_data()
 19359:20140305:035912.880 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
 19359:20140305:035912.881 End of get_host_availability_data():FAIL
 19359:20140305:035912.881 End of host_availability_sender()
 19359:20140305:035912.881 In history_sender()
 19359:20140305:035912.882 In proxy_get_history_data() table:'proxy_history'
 19359:20140305:035912.882 In proxy_get_lastid() [proxy_history.history_lastid]
 19359:20140305:035912.882 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
 19359:20140305:035912.883 End of proxy_get_lastid():0
 19359:20140305:035912.883 query [txnlev:0] [select p.id,h.host,i.key_,p.clock,p.ns,p.timestamp,p.source,p.severity,p.value,p.logeventid,p.status from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p.itemid and p.id>0 order by p.id limit 1000]
 19359:20140305:035912.883 End of proxy_get_history_data():0 lastid:0
 19359:20140305:035912.884 End of history_sender()
 19359:20140305:035912.884 In history_sender()
 19359:20140305:035912.884 In proxy_get_history_data() table:'proxy_dhistory'
 19359:20140305:035912.884 In proxy_get_lastid() [proxy_dhistory.dhistory_lastid]
 19359:20140305:035912.885 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
 19359:20140305:035912.885 End of proxy_get_lastid():0
 19359:20140305:035912.885 query [txnlev:0] [select p.id,p.clock,p.druleid,p.dcheckid,p.type,p.ip,p.dns,p.port,p.key_,p.value,p.status from proxy_dhistory p where p.id>0 order by p.id limit 1000]
 19359:20140305:035912.886 End of proxy_get_history_data():0 lastid:0
 19359:20140305:035912.886 End of history_sender()
 19359:20140305:035912.886 In history_sender()
 19359:20140305:035912.886 In proxy_get_history_data() table:'proxy_autoreg_host'
 19359:20140305:035912.886 In proxy_get_lastid() [proxy_autoreg_host.autoreg_host_lastid]
 19359:20140305:035912.887 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
 19359:20140305:035912.887 End of proxy_get_lastid():0
 19359:20140305:035912.887 query [txnlev:0] [select p.id,p.clock,p.host,p.listen_ip,p.listen_dns,p.listen_port from proxy_autoreg_host p where p.id>0 order by p.id limit 1000]
 19359:20140305:035912.887 End of proxy_get_history_data():0 lastid:0
 19359:20140305:035912.888 End of history_sender()
 19359:20140305:035912.888 Datasender spent 0.008473 seconds while processing   0 values.
 19359:20140305:035912.888 sleeping for 1 seconds
 19361:20140305:035913.711 In get_values()
 19360:20140305:035913.711 In get_values()
 19360:20140305:035913.714 In DCconfig_get_poller_items() poller_type:0
 19360:20140305:035913.715 End of DCconfig_get_poller_items():0
 19361:20140305:035913.715 In DCconfig_get_poller_items() poller_type:0
 19360:20140305:035913.715 End of get_values():0
 19361:20140305:035913.715 End of DCconfig_get_poller_items():0
 19360:20140305:035913.715 poller #1 spent 0.004482 seconds while updating 0 values
 19360:20140305:035913.716 In DCconfig_get_poller_nextcheck() poller_type:0
 19361:20140305:035913.716 End of get_values():0
 19360:20140305:035913.716 End of DCconfig_get_poller_nextcheck():-1
 19361:20140305:035913.716 poller #2 spent 0.005753 seconds while updating 0 values
 19361:20140305:035913.717 In DCconfig_get_poller_nextcheck() poller_type:0
 19361:20140305:035913.717 End of DCconfig_get_poller_nextcheck():-1
 19360:20140305:035913.717 sleeping for 5 seconds
 19361:20140305:035913.717 sleeping for 5 seconds
 19362:20140305:035913.745 In get_values()
 19365:20140305:035913.745 In get_values()
 19364:20140305:035913.745 In get_values()
 19363:20140305:035913.745 In get_values()
 19363:20140305:035913.746 In DCconfig_get_poller_items() poller_type:0
 19364:20140305:035913.746 In DCconfig_get_poller_items() poller_type:0
 19365:20140305:035913.746 In DCconfig_get_poller_items() poller_type:1
 19362:20140305:035913.746 In DCconfig_get_poller_items() poller_type:0
 19364:20140305:035913.746 End of DCconfig_get_poller_items():0
 19365:20140305:035913.747 End of DCconfig_get_poller_items():0
 19363:20140305:035913.747 End of DCconfig_get_poller_items():0
 19362:20140305:035913.747 End of DCconfig_get_poller_items():0
 19365:20140305:035913.747 End of get_values():0
 19364:20140305:035913.747 End of get_values():0
 19363:20140305:035913.747 End of get_values():0
 19362:20140305:035913.748 End of get_values():0
 19365:20140305:035913.748 unreachable poller #1 spent 0.002921 seconds while updating 0 values
 19363:20140305:035913.748 poller #4 spent 0.002738 seconds while updating 0 values
 19364:20140305:035913.748 poller #5 spent 0.003149 seconds while updating 0 values
 19362:20140305:035913.748 poller #3 spent 0.003781 seconds while updating 0 values
 19365:20140305:035913.749 In DCconfig_get_poller_nextcheck() poller_type:1
 19364:20140305:035913.749 In DCconfig_get_poller_nextcheck() poller_type:0
 19363:20140305:035913.749 In DCconfig_get_poller_nextcheck() poller_type:0
 19362:20140305:035913.749 In DCconfig_get_poller_nextcheck() poller_type:0
 19365:20140305:035913.750 End of DCconfig_get_poller_nextcheck():-1
 19364:20140305:035913.750 End of DCconfig_get_poller_nextcheck():-1
 19363:20140305:035913.750 End of DCconfig_get_poller_nextcheck():-1
 19362:20140305:035913.750 End of DCconfig_get_poller_nextcheck():-1
 19365:20140305:035913.750 sleeping for 5 seconds
 19364:20140305:035913.751 sleeping for 5 seconds
 19363:20140305:035913.751 sleeping for 5 seconds
 19362:20140305:035913.751 sleeping for 5 seconds
 19371:20140305:035913.801 In get_pinger_hosts()
 19371:20140305:035913.801 In DCconfig_get_poller_items() poller_type:3
 19371:20140305:035913.801 End of DCconfig_get_poller_items():0
 19371:20140305:035913.802 End of get_pinger_hosts():0
 19371:20140305:035913.802 In process_pinger_hosts()
 19371:20140305:035913.802 End of process_pinger_hosts()
 19371:20140305:035913.802 icmp pinger #1 spent 0.001350 seconds while processing 0 items
 19371:20140305:035913.802 In DCconfig_get_poller_nextcheck() poller_type:3
 19371:20140305:035913.803 End of DCconfig_get_poller_nextcheck():-1
 19371:20140305:035913.803 sleeping for 5 seconds
 19376:20140305:035913.814 Syncing ...
 19376:20140305:035913.814 In DCsync_history() history_first:0 history_num:0
 19376:20140305:035913.815 history syncer #2 spent 0.000214 seconds while processing 0 items
 19376:20140305:035913.815 sleeping for 5 seconds
 19375:20140305:035913.819 Syncing ...
 19373:20140305:035913.820 In process_httptests()
 19373:20140305:035913.820 query [txnlev:0] [select t.httptestid,t.name,t.macros,t.agent,t.authentication,t.http_user,t.http_password from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.nextcheck<=1393991953 and t.httptestid%1=0 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0)]
 19375:20140305:035913.820 In DCsync_history() history_first:0 history_num:0
 19375:20140305:035913.821 history syncer #1 spent 0.000561 seconds while processing 0 items
 19375:20140305:035913.821 sleeping for 5 seconds
 19373:20140305:035913.821 End of process_httptests()
 19373:20140305:035913.821 http poller #1 spent 0.001649 seconds while updating HTTP tests
 19373:20140305:035913.821 query [txnlev:0] [select min(t.nextcheck) from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.httptestid%1=0 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0)]
 19377:20140305:035913.822 Syncing ...
 19377:20140305:035913.822 In DCsync_history() history_first:0 history_num:0
 19377:20140305:035913.822 history syncer #3 spent 0.000197 seconds while processing 0 items
 19377:20140305:035913.822 sleeping for 5 seconds
 19373:20140305:035913.823 No httptests to process in get_minnextcheck.
 19373:20140305:035913.823 sleeping for 5 seconds
 19378:20140305:035913.824 Syncing ...
 19378:20140305:035913.824 In DCsync_history() history_first:0 history_num:0
 19378:20140305:035913.824 history syncer #4 spent 0.000199 seconds while processing 0 items
 19378:20140305:035913.824 sleeping for 5 seconds
 19359:20140305:035913.888 In host_availability_sender()
 19359:20140305:035913.889 In get_host_availability_data()
 19359:20140305:035913.889 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
 19359:20140305:035913.889 End of get_host_availability_data():FAIL
 19359:20140305:035913.890 End of host_availability_sender()
 19359:20140305:035913.890 In history_sender()
 19359:20140305:035913.890 In proxy_get_history_data() table:'proxy_history'
 19359:20140305:035913.890 In proxy_get_lastid() [proxy_history.history_lastid]
 19359:20140305:035913.890 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
 19359:20140305:035913.891 End of proxy_get_lastid():0
 19359:20140305:035913.891 query [txnlev:0] [select p.id,h.host,i.key_,p.clock,p.ns,p.timestamp,p.source,p.severity,p.value,p.logeventid,p.status from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p.itemid and p.id>0 order by p.id limit 1000]
 19359:20140305:035913.891 End of proxy_get_history_data():0 lastid:0
 19359:20140305:035913.892 End of history_sender()
 19359:20140305:035913.892 In history_sender()
 19359:20140305:035913.892 In proxy_get_history_data() table:'proxy_dhistory'
 19359:20140305:035913.892 In proxy_get_lastid() [proxy_dhistory.dhistory_lastid]
 19359:20140305:035913.892 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
 19359:20140305:035913.893 End of proxy_get_lastid():0
 19359:20140305:035913.893 query [txnlev:0] [select p.id,p.clock,p.druleid,p.dcheckid,p.type,p.ip,p.dns,p.port,p.key_,p.value,p.status from proxy_dhistory p where p.id>0 order by p.id limit 1000]
 19359:20140305:035913.893 End of proxy_get_history_data():0 lastid:0
 19359:20140305:035913.894 End of history_sender()
 19359:20140305:035913.894 In history_sender()
 19359:20140305:035913.894 In proxy_get_history_data() table:'proxy_autoreg_host'
 19359:20140305:035913.894 In proxy_get_lastid() [proxy_autoreg_host.autoreg_host_lastid]
 19359:20140305:035913.895 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
 19359:20140305:035913.895 End of proxy_get_lastid():0
 19359:20140305:035913.895 query [txnlev:0] [select p.id,p.clock,p.host,p.listen_ip,p.listen_dns,p.listen_port from proxy_autoreg_host p where p.id>0 order by p.id limit 1000]
 19359:20140305:035913.895 End of proxy_get_history_data():0 lastid:0
 19359:20140305:035913.896 End of history_sender()
 19359:20140305:035913.896 Datasender spent 0.007426 seconds while processing   0 values.
 19359:20140305:035913.896 sleeping for 1 seconds
 19370:20140305:035914.180 Trapper got [{
	"request":"active checks",
	"host":"test-mon-master"}] len 56
 19370:20140305:035914.180 In send_list_of_active_checks_json()
 19370:20140305:035914.181 In get_hostid_by_host() host:'test-mon-master'
 19370:20140305:035914.181 query [txnlev:0] [select hostid,status from hosts where host='test-mon-master' and status in (0,1) and proxy_hostid is null]
 19370:20140305:035914.191 query [txnlev:1] [begin;]
 19370:20140305:035914.192 query [txnlev:1] [insert into proxy_autoreg_host (clock,host,listen_ip,listen_dns,listen_port) values (1393991954,'test-mon-master','10.185.20.42','ip-10-185-20-42.ec2.internal',10050)]
 19370:20140305:035914.193 query [txnlev:1] [commit;]
 19370:20140305:035914.193 End of get_hostid_by_host():FAIL
 19370:20140305:035914.193 cannot send list of active checks to [10.185.20.42]: host [test-mon-master] not found
 19370:20140305:035914.194 send_list_of_active_checks_json() sending [{
	"response":"failed",
	"info":"host [test-mon-master] not found"}]
 19370:20140305:035914.194 End of send_list_of_active_checks_json():SUCCEED
 19359:20140305:035914.896 In host_availability_sender()
 19359:20140305:035914.897 In get_host_availability_data()
 19359:20140305:035914.897 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
 19359:20140305:035914.898 End of get_host_availability_data():FAIL
 19359:20140305:035914.898 End of host_availability_sender()
 19359:20140305:035914.899 In history_sender()
 19359:20140305:035914.899 In proxy_get_history_data() table:'proxy_history'
 19359:20140305:035914.899 In proxy_get_lastid() [proxy_history.history_lastid]
 19359:20140305:035914.900 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
 19359:20140305:035914.900 End of proxy_get_lastid():0
 19359:20140305:035914.900 query [txnlev:0] [select p.id,h.host,i.key_,p.clock,p.ns,p.timestamp,p.source,p.severity,p.value,p.logeventid,p.status from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p.itemid and p.id>0 order by p.id limit 1000]
 19359:20140305:035914.901 End of proxy_get_history_data():0 lastid:0
 19359:20140305:035914.901 End of history_sender()
 19359:20140305:035914.901 In history_sender()
 19359:20140305:035914.902 In proxy_get_history_data() table:'proxy_dhistory'
 19359:20140305:035914.902 In proxy_get_lastid() [proxy_dhistory.dhistory_lastid]
 19359:20140305:035914.902 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
 19359:20140305:035914.902 End of proxy_get_lastid():0
 19359:20140305:035914.903 query [txnlev:0] [select p.id,p.clock,p.druleid,p.dcheckid,p.type,p.ip,p.dns,p.port,p.key_,p.value,p.status from proxy_dhistory p where p.id>0 order by p.id limit 1000]
 19359:20140305:035914.903 End of proxy_get_history_data():0 lastid:0
 19359:20140305:035914.903 End of history_sender()
 19359:20140305:035914.903 In history_sender()
 19359:20140305:035914.904 In proxy_get_history_data() table:'proxy_autoreg_host'
 19359:20140305:035914.904 In proxy_get_lastid() [proxy_autoreg_host.autoreg_host_lastid]
 19359:20140305:035914.904 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
 19359:20140305:035914.904 End of proxy_get_lastid():0
 19359:20140305:035914.904 query [txnlev:0] [select p.id,p.clock,p.host,p.listen_ip,p.listen_dns,p.listen_port from proxy_autoreg_host p where p.id>0 order by p.id limit 1000]
 19359:20140305:035914.905 End of proxy_get_history_data():1 lastid:1
 19359:20140305:035914.905 In connect_to_server() [10.168.24.153]:10051 [timeout:600]
 19360:20140305:035918.718 In get_values()
 19361:20140305:035918.718 In get_values()
 19361:20140305:035918.727 In DCconfig_get_poller_items() poller_type:0
 19361:20140305:035918.727 End of DCconfig_get_poller_items():0
 19361:20140305:035918.728 End of get_values():0
 19360:20140305:035918.728 In DCconfig_get_poller_items() poller_type:0
 19361:20140305:035918.728 poller #2 spent 0.010015 seconds while updating 0 values
 19360:20140305:035918.728 End of DCconfig_get_poller_items():0
 19361:20140305:035918.729 In DCconfig_get_poller_nextcheck() poller_type:0
 19360:20140305:035918.729 End of get_values():0
 19361:20140305:035918.729 End of DCconfig_get_poller_nextcheck():-1
 19360:20140305:035918.729 poller #1 spent 0.011448 seconds while updating 0 values
 19361:20140305:035918.730 sleeping for 5 seconds
 19360:20140305:035918.730 In DCconfig_get_poller_nextcheck() poller_type:0
 19360:20140305:035918.730 End of DCconfig_get_poller_nextcheck():-1
 19360:20140305:035918.730 sleeping for 5 seconds
 19365:20140305:035918.752 In get_values()
 19362:20140305:035918.752 In get_values()
 19363:20140305:035918.752 In get_values()
 19364:20140305:035918.752 In get_values()
 19362:20140305:035918.753 In DCconfig_get_poller_items() poller_type:0
 19363:20140305:035918.753 In DCconfig_get_poller_items() poller_type:0
 19364:20140305:035918.753 In DCconfig_get_poller_items() poller_type:0
 19363:20140305:035918.753 End of DCconfig_get_poller_items():0
 19364:20140305:035918.753 End of DCconfig_get_poller_items():0
 19362:20140305:035918.754 End of DCconfig_get_poller_items():0
 19365:20140305:035918.754 In DCconfig_get_poller_items() poller_type:1
 19363:20140305:035918.754 End of get_values():0
 19364:20140305:035918.754 End of get_values():0
 19362:20140305:035918.754 End of get_values():0
 19365:20140305:035918.755 End of DCconfig_get_poller_items():0
 19363:20140305:035918.755 poller #4 spent 0.002589 seconds while updating 0 values
 19364:20140305:035918.755 poller #5 spent 0.002598 seconds while updating 0 values
 19362:20140305:035918.755 poller #3 spent 0.003199 seconds while updating 0 values
 19365:20140305:035918.755 End of get_values():0
 19363:20140305:035918.756 In DCconfig_get_poller_nextcheck() poller_type:0
 19364:20140305:035918.756 In DCconfig_get_poller_nextcheck() poller_type:0
 19365:20140305:035918.756 unreachable poller #1 spent 0.004366 seconds while updating 0 values
 19362:20140305:035918.756 In DCconfig_get_poller_nextcheck() poller_type:0
 19364:20140305:035918.756 End of DCconfig_get_poller_nextcheck():-1
 19363:20140305:035918.757 End of DCconfig_get_poller_nextcheck():-1
 19362:20140305:035918.757 End of DCconfig_get_poller_nextcheck():-1
 19365:20140305:035918.757 In DCconfig_get_poller_nextcheck() poller_type:1
 19364:20140305:035918.757 sleeping for 5 seconds
 19363:20140305:035918.757 sleeping for 5 seconds
 19365:20140305:035918.758 End of DCconfig_get_poller_nextcheck():-1
 19362:20140305:035918.758 sleeping for 5 seconds
 19365:20140305:035918.758 sleeping for 5 seconds
 19371:20140305:035918.804 In get_pinger_hosts()
 19371:20140305:035918.804 In DCconfig_get_poller_items() poller_type:3
 19371:20140305:035918.804 End of DCconfig_get_poller_items():0
 19371:20140305:035918.805 End of get_pinger_hosts():0
 19371:20140305:035918.805 In process_pinger_hosts()
 19371:20140305:035918.805 End of process_pinger_hosts()
 19371:20140305:035918.805 icmp pinger #1 spent 0.001579 seconds while processing 0 items
 19371:20140305:035918.806 In DCconfig_get_poller_nextcheck() poller_type:3
 19371:20140305:035918.806 End of DCconfig_get_poller_nextcheck():-1
 19371:20140305:035918.806 sleeping for 5 seconds
 19376:20140305:035918.816 Syncing ...
 19376:20140305:035918.816 In DCsync_history() history_first:0 history_num:0
 19376:20140305:035918.816 history syncer #2 spent 0.000223 seconds while processing 0 items
 19376:20140305:035918.816 sleeping for 5 seconds
 19375:20140305:035918.822 Syncing ...
 19375:20140305:035918.822 In DCsync_history() history_first:0 history_num:0
 19375:20140305:035918.822 history syncer #1 spent 0.000203 seconds while processing 0 items
 19375:20140305:035918.822 sleeping for 5 seconds
 19377:20140305:035918.823 Syncing ...
 19377:20140305:035918.823 In DCsync_history() history_first:0 history_num:0
 19377:20140305:035918.823 history syncer #3 spent 0.000198 seconds while processing 0 items
 19377:20140305:035918.824 sleeping for 5 seconds
 19373:20140305:035918.824 In process_httptests()
 19373:20140305:035918.824 query [txnlev:0] [select t.httptestid,t.name,t.macros,t.agent,t.authentication,t.http_user,t.http_password from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.nextcheck<=1393991958 and t.httptestid%1=0 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0)]
 19373:20140305:035918.825 End of process_httptests()
 19373:20140305:035918.825 http poller #1 spent 0.001117 seconds while updating HTTP tests
 19373:20140305:035918.825 query [txnlev:0] [select min(t.nextcheck) from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.httptestid%1=0 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0)]
 19378:20140305:035918.825 Syncing ...
 19378:20140305:035918.826 In DCsync_history() history_first:0 history_num:0
 19378:20140305:035918.826 history syncer #4 spent 0.000198 seconds while processing 0 items
 19378:20140305:035918.826 sleeping for 5 seconds
 19373:20140305:035918.826 No httptests to process in get_minnextcheck.
 19373:20140305:035918.827 sleeping for 5 seconds
 19369:20140305:035919.756 Trapper got [{
	"request":"active checks",
	"host":"test-lb-0"}] len 50
 19369:20140305:035919.757 In send_list_of_active_checks_json()
 19369:20140305:035919.758 In get_hostid_by_host() host:'test-lb-0'
 19369:20140305:035919.758 query [txnlev:0] [select hostid,status from hosts where host='test-lb-0' and status in (0,1) and proxy_hostid is null]
 19369:20140305:035919.762 query [txnlev:1] [begin;]
 19369:20140305:035919.762 query [txnlev:1] [insert into proxy_autoreg_host (clock,host,listen_ip,listen_dns,listen_port) values (1393991959,'test-lb-0','10.147.197.184','ip-10-147-197-184.ec2.internal',10050)]
 19369:20140305:035919.763 query [txnlev:1] [commit;]
 19369:20140305:035919.763 End of get_hostid_by_host():FAIL
 19369:20140305:035919.764 cannot send list of active checks to [10.147.197.184]: host [test-lb-0] not found
 19369:20140305:035919.764 send_list_of_active_checks_json() sending [{
	"response":"failed",
	"info":"host [test-lb-0] not found"}]
 19369:20140305:035919.764 End of send_list_of_active_checks_json():SUCCEED
 19361:20140305:035923.731 In get_values()
 19360:20140305:035923.731 In get_values()
 19360:20140305:035923.736 In DCconfig_get_poller_items() poller_type:0
 19360:20140305:035923.736 End of DCconfig_get_poller_items():0
 19360:20140305:035923.736 End of get_values():0
 19361:20140305:035923.736 In DCconfig_get_poller_items() poller_type:0
 19360:20140305:035923.737 poller #1 spent 0.005794 seconds while updating 0 values
 19361:20140305:035923.737 End of DCconfig_get_poller_items():0
 19360:20140305:035923.737 In DCconfig_get_poller_nextcheck() poller_type:0
 19361:20140305:035923.737 End of get_values():0
 19360:20140305:035923.738 End of DCconfig_get_poller_nextcheck():-1
 19361:20140305:035923.738 poller #2 spent 0.007357 seconds while updating 0 values
 19360:20140305:035923.738 sleeping for 5 seconds
 19361:20140305:035923.738 In DCconfig_get_poller_nextcheck() poller_type:0
 19361:20140305:035923.739 End of DCconfig_get_poller_nextcheck():-1
 19361:20140305:035923.739 sleeping for 5 seconds
 19362:20140305:035923.759 In get_values()
 19365:20140305:035923.759 In get_values()
 19364:20140305:035923.759 In get_values()
 19363:20140305:035923.760 In get_values()
 19365:20140305:035923.760 In DCconfig_get_poller_items() poller_type:1
 19362:20140305:035923.760 In DCconfig_get_poller_items() poller_type:0
 19363:20140305:035923.760 In DCconfig_get_poller_items() poller_type:0
 19364:20140305:035923.760 In DCconfig_get_poller_items() poller_type:0
 19365:20140305:035923.761 End of DCconfig_get_poller_items():0
 19362:20140305:035923.761 End of DCconfig_get_poller_items():0
 19363:20140305:035923.761 End of DCconfig_get_poller_items():0
 19364:20140305:035923.761 End of DCconfig_get_poller_items():0
 19362:20140305:035923.762 End of get_values():0
 19365:20140305:035923.762 End of get_values():0
 19363:20140305:035923.762 End of get_values():0
 19364:20140305:035923.762 End of get_values():0
 19362:20140305:035923.762 poller #3 spent 0.003261 seconds while updating 0 values
 19365:20140305:035923.763 unreachable poller #1 spent 0.003246 seconds while updating 0 values
 19363:20140305:035923.763 poller #4 spent 0.003066 seconds while updating 0 values
 19364:20140305:035923.763 poller #5 spent 0.003481 seconds while updating 0 values
 19362:20140305:035923.763 In DCconfig_get_poller_nextcheck() poller_type:0
 19365:20140305:035923.763 In DCconfig_get_poller_nextcheck() poller_type:1
 19364:20140305:035923.764 In DCconfig_get_poller_nextcheck() poller_type:0
 19363:20140305:035923.764 In DCconfig_get_poller_nextcheck() poller_type:0
 19362:20140305:035923.764 End of DCconfig_get_poller_nextcheck():-1
 19365:20140305:035923.764 End of DCconfig_get_poller_nextcheck():-1
 19364:20140305:035923.764 End of DCconfig_get_poller_nextcheck():-1
 19363:20140305:035923.765 End of DCconfig_get_poller_nextcheck():-1
 19362:20140305:035923.765 sleeping for 5 seconds
 19365:20140305:035923.765 sleeping for 5 seconds
 19364:20140305:035923.765 sleeping for 5 seconds
 19363:20140305:035923.765 sleeping for 5 seconds
 19371:20140305:035923.807 In get_pinger_hosts()
 19371:20140305:035923.807 In DCconfig_get_poller_items() poller_type:3
 19371:20140305:035923.807 End of DCconfig_get_poller_items():0
 19371:20140305:035923.807 End of get_pinger_hosts():0
 19371:20140305:035923.808 In process_pinger_hosts()
 19371:20140305:035923.808 End of process_pinger_hosts()
 19371:20140305:035923.808 icmp pinger #1 spent 0.001250 seconds while processing 0 items
 19371:20140305:035923.808 In DCconfig_get_poller_nextcheck() poller_type:3
 19371:20140305:035923.809 End of DCconfig_get_poller_nextcheck():-1
 19371:20140305:035923.809 sleeping for 5 seconds
 19376:20140305:035923.817 Syncing ...
 19376:20140305:035923.817 In DCsync_history() history_first:0 history_num:0
 19376:20140305:035923.817 history syncer #2 spent 0.000241 seconds while processing 0 items
 19376:20140305:035923.818 sleeping for 5 seconds
 19375:20140305:035923.823 Syncing ...
 19375:20140305:035923.823 In DCsync_history() history_first:0 history_num:0
 19375:20140305:035923.823 history syncer #1 spent 0.000241 seconds while processing 0 items
 19375:20140305:035923.824 sleeping for 5 seconds
 19377:20140305:035923.825 Syncing ...
 19377:20140305:035923.825 In DCsync_history() history_first:0 history_num:0
 19377:20140305:035923.826 history syncer #3 spent 0.000236 seconds while processing 0 items
 19377:20140305:035923.826 sleeping for 5 seconds
 19378:20140305:035923.827 Syncing ...
 19378:20140305:035923.827 In DCsync_history() history_first:0 history_num:0
 19378:20140305:035923.827 history syncer #4 spent 0.000202 seconds while processing 0 items
 19373:20140305:035923.827 In process_httptests()
 19373:20140305:035923.827 query [txnlev:0] [select t.httptestid,t.name,t.macros,t.agent,t.authentication,t.http_user,t.http_password from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.nextcheck<=1393991963 and t.httptestid%1=0 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0)]
 19373:20140305:035923.828 End of process_httptests()
 19378:20140305:035923.828 sleeping for 5 seconds
 19373:20140305:035923.829 http poller #1 spent 0.001300 seconds while updating HTTP tests
 19373:20140305:035923.829 query [txnlev:0] [select min(t.nextcheck) from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.httptestid%1=0 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0)]
 19373:20140305:035923.829 No httptests to process in get_minnextcheck.
 19373:20140305:035923.830 sleeping for 5 seconds
 19360:20140305:035928.739 In get_values()
 19361:20140305:035928.740 In get_values()
 19361:20140305:035928.756 In DCconfig_get_poller_items() poller_type:0
 19361:20140305:035928.757 End of DCconfig_get_poller_items():0
 19360:20140305:035928.757 In DCconfig_get_poller_items() poller_type:0
 19360:20140305:035928.757 End of DCconfig_get_poller_items():0
 19361:20140305:035928.757 End of get_values():0
 19360:20140305:035928.758 End of get_values():0
 19361:20140305:035928.758 poller #2 spent 0.018377 seconds while updating 0 values
 19360:20140305:035928.758 poller #1 spent 0.018893 seconds while updating 0 values
 19361:20140305:035928.758 In DCconfig_get_poller_nextcheck() poller_type:0
 19360:20140305:035928.759 In DCconfig_get_poller_nextcheck() poller_type:0
 19361:20140305:035928.759 End of DCconfig_get_poller_nextcheck():-1
 19360:20140305:035928.759 End of DCconfig_get_poller_nextcheck():-1
 19361:20140305:035928.759 sleeping for 5 seconds
 19360:20140305:035928.759 sleeping for 5 seconds
 19363:20140305:035928.766 In get_values()
 19365:20140305:035928.767 In get_values()
 19364:20140305:035928.767 In get_values()
 19362:20140305:035928.767 In get_values()
 19365:20140305:035928.767 In DCconfig_get_poller_items() poller_type:1
 19364:20140305:035928.767 In DCconfig_get_poller_items() poller_type:0
 19362:20140305:035928.768 In DCconfig_get_poller_items() poller_type:0
 19364:20140305:035928.768 End of DCconfig_get_poller_items():0
 19365:20140305:035928.768 End of DCconfig_get_poller_items():0
 19362:20140305:035928.768 End of DCconfig_get_poller_items():0
 19363:20140305:035928.768 In DCconfig_get_poller_items() poller_type:0
 19364:20140305:035928.769 End of get_values():0
 19365:20140305:035928.769 End of get_values():0
 19362:20140305:035928.769 End of get_values():0
 19363:20140305:035928.769 End of DCconfig_get_poller_items():0
 19364:20140305:035928.770 poller #5 spent 0.002642 seconds while updating 0 values
 19365:20140305:035928.770 unreachable poller #1 spent 0.003052 seconds while updating 0 values
 19362:20140305:035928.770 poller #3 spent 0.002866 seconds while updating 0 values
 19363:20140305:035928.770 End of get_values():0
 19364:20140305:035928.770 In DCconfig_get_poller_nextcheck() poller_type:0
 19365:20140305:035928.771 In DCconfig_get_poller_nextcheck() poller_type:1
 19362:20140305:035928.771 In DCconfig_get_poller_nextcheck() poller_type:0
 19363:20140305:035928.771 poller #4 spent 0.004616 seconds while updating 0 values
 19364:20140305:035928.771 End of DCconfig_get_poller_nextcheck():-1
 19365:20140305:035928.771 End of DCconfig_get_poller_nextcheck():-1
 19362:20140305:035928.772 End of DCconfig_get_poller_nextcheck():-1
 19363:20140305:035928.772 In DCconfig_get_poller_nextcheck() poller_type:0
 19364:20140305:035928.772 sleeping for 5 seconds
 19365:20140305:035928.772 sleeping for 5 seconds
 19362:20140305:035928.772 sleeping for 5 seconds
 19363:20140305:035928.773 End of DCconfig_get_poller_nextcheck():-1
 19363:20140305:035928.773 sleeping for 5 seconds
 19371:20140305:035928.810 In get_pinger_hosts()
 19371:20140305:035928.810 In DCconfig_get_poller_items() poller_type:3
 19371:20140305:035928.810 End of DCconfig_get_poller_items():0
 19371:20140305:035928.810 End of get_pinger_hosts():0
 19371:20140305:035928.811 In process_pinger_hosts()
 19371:20140305:035928.811 End of process_pinger_hosts()
 19371:20140305:035928.811 icmp pinger #1 spent 0.001427 seconds while processing 0 items
 19371:20140305:035928.811 In DCconfig_get_poller_nextcheck() poller_type:3
 19371:20140305:035928.811 End of DCconfig_get_poller_nextcheck():-1
 19371:20140305:035928.812 sleeping for 5 seconds
 19376:20140305:035928.818 Syncing ...
 19376:20140305:035928.819 In DCsync_history() history_first:0 history_num:0
 19376:20140305:035928.819 history syncer #2 spent 0.000205 seconds while processing 0 items
 19376:20140305:035928.819 sleeping for 5 seconds
 19375:20140305:035928.824 Syncing ...
 19375:20140305:035928.824 In DCsync_history() history_first:0 history_num:0
 19375:20140305:035928.825 history syncer #1 spent 0.000227 seconds while processing 0 items
 19375:20140305:035928.825 sleeping for 5 seconds
 19377:20140305:035928.826 Syncing ...
 19377:20140305:035928.827 In DCsync_history() history_first:0 history_num:0
 19377:20140305:035928.827 history syncer #3 spent 0.000200 seconds while processing 0 items
 19377:20140305:035928.827 sleeping for 5 seconds
 19378:20140305:035928.829 Syncing ...
 19378:20140305:035928.829 In DCsync_history() history_first:0 history_num:0
 19378:20140305:035928.829 history syncer #4 spent 0.000209 seconds while processing 0 items
 19378:20140305:035928.829 sleeping for 5 seconds
 19373:20140305:035928.830 In process_httptests()
 19373:20140305:035928.830 query [txnlev:0] [select t.httptestid,t.name,t.macros,t.agent,t.authentication,t.http_user,t.http_password from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.nextcheck<=1393991968 and t.httptestid%1=0 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0)]
 19373:20140305:035928.831 End of process_httptests()
 19373:20140305:035928.831 http poller #1 spent 0.001004 seconds while updating HTTP tests
 19373:20140305:035928.831 query [txnlev:0] [select min(t.nextcheck) from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.httptestid%1=0 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0)]
 19373:20140305:035928.832 No httptests to process in get_minnextcheck.
 19373:20140305:035928.832 sleeping for 5 seconds
 19361:20140305:035933.760 In get_values()
 19360:20140305:035933.761 In get_values()
 19360:20140305:035933.767 In DCconfig_get_poller_items() poller_type:0
 19361:20140305:035933.768 In DCconfig_get_poller_items() poller_type:0
 19360:20140305:035933.768 End of DCconfig_get_poller_items():0
 19360:20140305:035933.768 End of get_values():0
 19361:20140305:035933.768 End of DCconfig_get_poller_items():0
 19360:20140305:035933.769 poller #1 spent 0.008145 seconds while updating 0 values
 19361:20140305:035933.769 End of get_values():0
 19360:20140305:035933.769 In DCconfig_get_poller_nextcheck() poller_type:0
 19361:20140305:035933.769 poller #2 spent 0.009161 seconds while updating 0 values
 19360:20140305:035933.770 End of DCconfig_get_poller_nextcheck():-1
 19361:20140305:035933.770 In DCconfig_get_poller_nextcheck() poller_type:0
 19360:20140305:035933.770 sleeping for 5 seconds
 19361:20140305:035933.770 End of DCconfig_get_poller_nextcheck():-1
 19361:20140305:035933.771 sleeping for 5 seconds
 19364:20140305:035933.773 In get_values()
 19362:20140305:035933.774 In get_values()
 19365:20140305:035933.774 In get_values()
 19362:20140305:035933.774 In DCconfig_get_poller_items() poller_type:0
 19363:20140305:035933.774 In get_values()
 19365:20140305:035933.774 In DCconfig_get_poller_items() poller_type:1
 19364:20140305:035933.775 In DCconfig_get_poller_items() poller_type:0
 19362:20140305:035933.775 End of DCconfig_get_poller_items():0
 19363:20140305:035933.775 In DCconfig_get_poller_items() poller_type:0
 19365:20140305:035933.775 End of DCconfig_get_poller_items():0
 19364:20140305:035933.775 End of DCconfig_get_poller_items():0
 19362:20140305:035933.776 End of get_values():0
 19363:20140305:035933.776 End of DCconfig_get_poller_items():0
 19365:20140305:035933.776 End of get_values():0
 19364:20140305:035933.776 End of get_values():0
 19362:20140305:035933.777 poller #3 spent 0.003226 seconds while updating 0 values
 19363:20140305:035933.777 End of get_values():0
 19365:20140305:035933.777 unreachable poller #1 spent 0.003592 seconds while updating 0 values
 19364:20140305:035933.778 poller #5 spent 0.004337 seconds while updating 0 values
 19362:20140305:035933.778 In DCconfig_get_poller_nextcheck() poller_type:0
 19363:20140305:035933.778 poller #4 spent 0.004100 seconds while updating 0 values
 19364:20140305:035933.779 In DCconfig_get_poller_nextcheck() poller_type:0
 19365:20140305:035933.779 In DCconfig_get_poller_nextcheck() poller_type:1
 19362:20140305:035933.779 End of DCconfig_get_poller_nextcheck():-1
 19363:20140305:035933.779 In DCconfig_get_poller_nextcheck() poller_type:0
 19365:20140305:035933.779 End of DCconfig_get_poller_nextcheck():-1
 19364:20140305:035933.780 End of DCconfig_get_poller_nextcheck():-1
 19363:20140305:035933.780 End of DCconfig_get_poller_nextcheck():-1
 19362:20140305:035933.780 sleeping for 5 seconds
 19365:20140305:035933.780 sleeping for 5 seconds
 19364:20140305:035933.780 sleeping for 5 seconds
 19363:20140305:035933.781 sleeping for 5 seconds
 19371:20140305:035933.812 In get_pinger_hosts()
 19371:20140305:035933.813 In DCconfig_get_poller_items() poller_type:3
 19371:20140305:035933.813 End of DCconfig_get_poller_items():0
 19371:20140305:035933.813 End of get_pinger_hosts():0
 19371:20140305:035933.813 In process_pinger_hosts()
 19371:20140305:035933.814 End of process_pinger_hosts()
 19371:20140305:035933.814 icmp pinger #1 spent 0.001250 seconds while processing 0 items
 19371:20140305:035933.814 In DCconfig_get_poller_nextcheck() poller_type:3
 19371:20140305:035933.814 End of DCconfig_get_poller_nextcheck():-1
 19371:20140305:035933.814 sleeping for 5 seconds
 19376:20140305:035933.820 Syncing ...
 19376:20140305:035933.820 In DCsync_history() history_first:0 history_num:0
 19376:20140305:035933.820 history syncer #2 spent 0.000209 seconds while processing 0 items
 19376:20140305:035933.820 sleeping for 5 seconds
 19375:20140305:035933.825 Syncing ...
 19375:20140305:035933.826 In DCsync_history() history_first:0 history_num:0
 19375:20140305:035933.826 history syncer #1 spent 0.000206 seconds while processing 0 items
 19375:20140305:035933.826 sleeping for 5 seconds
 19377:20140305:035933.828 Syncing ...
 19377:20140305:035933.828 In DCsync_history() history_first:0 history_num:0
 19377:20140305:035933.828 history syncer #3 spent 0.000311 seconds while processing 0 items
 19377:20140305:035933.829 sleeping for 5 seconds
 19378:20140305:035933.830 Syncing ...
 19378:20140305:035933.830 In DCsync_history() history_first:0 history_num:0
 19378:20140305:035933.831 history syncer #4 spent 0.000206 seconds while processing 0 items
 19378:20140305:035933.831 sleeping for 5 seconds
 19373:20140305:035933.833 In process_httptests()
 19373:20140305:035933.833 query [txnlev:0] [select t.httptestid,t.name,t.macros,t.agent,t.authentication,t.http_user,t.http_password from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.nextcheck<=1393991973 and t.httptestid%1=0 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0)]
 19373:20140305:035933.834 End of process_httptests()
 19373:20140305:035933.834 http poller #1 spent 0.001052 seconds while updating HTTP tests
 19373:20140305:035933.834 query [txnlev:0] [select min(t.nextcheck) from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.httptestid%1=0 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0)]
 19373:20140305:035933.834 No httptests to process in get_minnextcheck.
 19373:20140305:035933.835 sleeping for 5 seconds
 19360:20140305:035938.771 In get_values()
 19361:20140305:035938.771 In get_values()
 19362:20140305:035938.781 In get_values()
 19364:20140305:035938.781 In get_values()
 19365:20140305:035938.781 In get_values()
 19363:20140305:035938.781 In get_values()
 19364:20140305:035938.786 In DCconfig_get_poller_items() poller_type:0
 19365:20140305:035938.786 In DCconfig_get_poller_items() poller_type:1
 19363:20140305:035938.786 In DCconfig_get_poller_items() poller_type:0
 19365:20140305:035938.786 End of DCconfig_get_poller_items():0
 19363:20140305:035938.787 End of DCconfig_get_poller_items():0
 19364:20140305:035938.787 End of DCconfig_get_poller_items():0
 19362:20140305:035938.787 In DCconfig_get_poller_items() poller_type:0
 19365:20140305:035938.787 End of get_values():0
 19363:20140305:035938.787 End of get_values():0
 19364:20140305:035938.788 End of get_values():0
 19362:20140305:035938.788 End of DCconfig_get_poller_items():0
 19365:20140305:035938.788 unreachable poller #1 spent 0.006487 seconds while updating 0 values
 19363:20140305:035938.788 poller #4 spent 0.006632 seconds while updating 0 values
 19364:20140305:035938.788 poller #5 spent 0.006963 seconds while updating 0 values
 19362:20140305:035938.789 End of get_values():0
 19365:20140305:035938.789 In DCconfig_get_poller_nextcheck() poller_type:1
 19363:20140305:035938.789 In DCconfig_get_poller_nextcheck() poller_type:0
 19364:20140305:035938.789 In DCconfig_get_poller_nextcheck() poller_type:0
 19362:20140305:035938.789 poller #3 spent 0.008124 seconds while updating 0 values
 19365:20140305:035938.790 End of DCconfig_get_poller_nextcheck():-1
 19363:20140305:035938.790 End of DCconfig_get_poller_nextcheck():-1
 19364:20140305:035938.790 End of DCconfig_get_poller_nextcheck():-1
 19362:20140305:035938.790 In DCconfig_get_poller_nextcheck() poller_type:0
 19365:20140305:035938.790 sleeping for 5 seconds
 19363:20140305:035938.791 sleeping for 5 seconds
 19364:20140305:035938.791 sleeping for 5 seconds
 19362:20140305:035938.791 End of DCconfig_get_poller_nextcheck():-1
 19362:20140305:035938.791 sleeping for 5 seconds
 19361:20140305:035938.791 In DCconfig_get_poller_items() poller_type:0
 19361:20140305:035938.792 End of DCconfig_get_poller_items():0
 19361:20140305:035938.792 End of get_values():0
 19360:20140305:035938.792 In DCconfig_get_poller_items() poller_type:0
 19361:20140305:035938.792 poller #2 spent 0.020780 seconds while updating 0 values
 19360:20140305:035938.792 End of DCconfig_get_poller_items():0
 19360:20140305:035938.793 End of get_values():0
 19361:20140305:035938.793 In DCconfig_get_poller_nextcheck() poller_type:0
 19361:20140305:035938.793 End of DCconfig_get_poller_nextcheck():-1
 19360:20140305:035938.793 poller #1 spent 0.022045 seconds while updating 0 values
 19360:20140305:035938.793 In DCconfig_get_poller_nextcheck() poller_type:0
 19361:20140305:035938.794 sleeping for 5 seconds
 19360:20140305:035938.794 End of DCconfig_get_poller_nextcheck():-1
 19360:20140305:035938.794 sleeping for 5 seconds
 19371:20140305:035938.815 In get_pinger_hosts()
 19371:20140305:035938.816 In DCconfig_get_poller_items() poller_type:3
 19371:20140305:035938.816 End of DCconfig_get_poller_items():0
 19371:20140305:035938.816 End of get_pinger_hosts():0
 19371:20140305:035938.816 In process_pinger_hosts()
 19371:20140305:035938.816 End of process_pinger_hosts()
 19371:20140305:035938.816 icmp pinger #1 spent 0.001409 seconds while processing 0 items
 19371:20140305:035938.817 In DCconfig_get_poller_nextcheck() poller_type:3
 19371:20140305:035938.817 End of DCconfig_get_poller_nextcheck():-1
 19371:20140305:035938.817 sleeping for 5 seconds
 19376:20140305:035938.821 Syncing ...
 19376:20140305:035938.821 In DCsync_history() history_first:0 history_num:0
 19376:20140305:035938.821 history syncer #2 spent 0.000203 seconds while processing 0 items
 19376:20140305:035938.822 sleeping for 5 seconds
 19375:20140305:035938.827 Syncing ...
 19375:20140305:035938.827 In DCsync_history() history_first:0 history_num:0
 19375:20140305:035938.827 history syncer #1 spent 0.000200 seconds while processing 0 items
 19375:20140305:035938.827 sleeping for 5 seconds
 19377:20140305:035938.829 Syncing ...
 19377:20140305:035938.829 In DCsync_history() history_first:0 history_num:0
 19377:20140305:035938.830 history syncer #3 spent 0.000198 seconds while processing 0 items
 19377:20140305:035938.830 sleeping for 5 seconds
 19378:20140305:035938.831 Syncing ...
 19378:20140305:035938.832 In DCsync_history() history_first:0 history_num:0
 19378:20140305:035938.832 history syncer #4 spent 0.000197 seconds while processing 0 items
 19378:20140305:035938.832 sleeping for 5 seconds
 19373:20140305:035938.835 In process_httptests()
 19373:20140305:035938.835 query [txnlev:0] [select t.httptestid,t.name,t.macros,t.agent,t.authentication,t.http_user,t.http_password from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.nextcheck<=1393991978 and t.httptestid%1=0 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0)]
 19373:20140305:035938.836 End of process_httptests()
 19373:20140305:035938.836 http poller #1 spent 0.000997 seconds while updating HTTP tests
 19373:20140305:035938.836 query [txnlev:0] [select min(t.nextcheck) from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.httptestid%1=0 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0)]
 19373:20140305:035938.837 No httptests to process in get_minnextcheck.
 19373:20140305:035938.837 sleeping for 5 seconds