Code: Select all
[1425463817.097157] [002.0] [pid=38505] SELECT * FROM nagios_objects WHERE instance_id='1' AND objecttype_id='1' AND BINARY name1='don-bg7a-p2-n0-zyxel-es31244f' AND name2 IS
[1425463817.097423] [002.0] [pid=38505] INSERT INTO nagios_objects SET instance_id='1', objecttype_id='1' , name1='don-bg7a-p2-n0-zyxel-es31244f'
[1425463817.097588] [002.0] [pid=38505] INSERT INTO nagios_hoststatus SET instance_id='1', host_object_id='16', status_update_time=FROM_UNIXTIME(1424941246), output='PING OK -
[1425463817.098126] [002.0] [pid=38505] DELETE FROM nagios_timedevents WHERE instance_id='1' AND scheduled_time<FROM_UNIXTIME(1425377417)
[1425463817.098215] [002.0] [pid=38505] DELETE FROM nagios_systemcommands WHERE instance_id='1' AND start_time<FROM_UNIXTIME(1424859017)
[1425463817.098291] [002.0] [pid=38505] DELETE FROM nagios_servicechecks WHERE instance_id='1' AND start_time<FROM_UNIXTIME(1424859017)
[1425463817.098365] [002.0] [pid=38505] DELETE FROM nagios_hostchecks WHERE instance_id='1' AND start_time<FROM_UNIXTIME(1424859017)
[1425463817.098471] [002.0] [pid=38505] DELETE FROM nagios_eventhandlers WHERE instance_id='1' AND start_time<FROM_UNIXTIME(1422785417)
[1425463817.098548] [002.0] [pid=38505] DELETE FROM nagios_externalcommands WHERE instance_id='1' AND entry_time<FROM_UNIXTIME(1422785417)
[1425463817.098703] [002.0] [pid=38505] SELECT * FROM nagios_objects WHERE instance_id='1' AND objecttype_id='1' AND BINARY name1='don-bg7a-p2-n1-dlink-des3200-18' AND name2 I
[1425463817.098954] [002.0] [pid=38505] INSERT INTO nagios_objects SET instance_id='1', objecttype_id='1' , name1='don-bg7a-p2-n1-dlink-des3200-18'
[1425463817.099104] [002.0] [pid=38505] INSERT INTO nagios_hoststatus SET instance_id='1', host_object_id='17', status_update_time=FROM_UNIXTIME(1424941246), output='PING OK -
[1425464053.251593] [002.0] [pid=44143] SELECT instance_id FROM nagios_instances WHERE instance_name='default'
[1425464053.251832] [002.0] [pid=44143] INSERT INTO nagios_conninfo SET instance_id='1', connect_time=NOW(), last_checkin_time=NOW(), bytes_processed='0', lines_processed='0',
[1425464053.252014] [002.0] [pid=44143] SELECT object_id, objecttype_id, name1, name2 FROM nagios_objects WHERE instance_id='1'
[1425464053.252218] [002.0] [pid=44143] SELECT UNIX_TIMESTAMP(status_update_time) AS latest_time FROM nagios_programstatus WHERE instance_id='1' ORDER BY status_update_time DE
[1425464053.252302] [002.0] [pid=44143] SELECT UNIX_TIMESTAMP(status_update_time) AS latest_time FROM nagios_hoststatus WHERE instance_id='1' ORDER BY status_update_time DESC
[1425464053.252427] [002.0] [pid=44143] SELECT UNIX_TIMESTAMP(status_update_time) AS latest_time FROM nagios_servicestatus WHERE instance_id='1' ORDER BY status_update_time DE
[1425464053.252539] [002.0] [pid=44143] SELECT UNIX_TIMESTAMP(status_update_time) AS latest_time FROM nagios_contactstatus WHERE instance_id='1' ORDER BY status_update_time DE
[1425464053.252614] [002.0] [pid=44143] SELECT UNIX_TIMESTAMP(queued_time) AS latest_time FROM nagios_timedeventqueue WHERE instance_id='1' ORDER BY queued_time DESC LIMIT 0,1
[1425464053.252719] [002.0] [pid=44143] SELECT UNIX_TIMESTAMP(entry_time) AS latest_time FROM nagios_comments WHERE instance_id='1' ORDER BY entry_time DESC LIMIT 0,1
[1425464053.252875] [002.0] [pid=44143] UPDATE nagios_conninfo SET last_checkin_time=NOW(), bytes_processed='676', lines_processed='63', entries_processed='0' WHERE conninfo_i
[1425464053.253037] [002.0] [pid=44143] SELECT * FROM nagios_objects WHERE instance_id='1' AND objecttype_id='1' AND BINARY name1='don-bs7b-p0-n0-zyxel-es2108g' AND name2 IS N
[1425464053.253325] [002.0] [pid=44143] INSERT INTO nagios_objects SET instance_id='1', objecttype_id='1' , name1='don-bs7b-p0-n0-zyxel-es2108g'
[1425464053.253489] [002.0] [pid=44143] INSERT INTO nagios_hoststatus SET instance_id='1', host_object_id='18', status_update_time=FROM_UNIXTIME(1424941246), output='PING OK -
[1425464053.254038] [002.0] [pid=44143] DELETE FROM nagios_timedevents WHERE instance_id='1' AND scheduled_time<FROM_UNIXTIME(1425377653)
[1425464053.254126] [002.0] [pid=44143] DELETE FROM nagios_systemcommands WHERE instance_id='1' AND start_time<FROM_UNIXTIME(1424859253)
[1425464053.254202] [002.0] [pid=44143] DELETE FROM nagios_servicechecks WHERE instance_id='1' AND start_time<FROM_UNIXTIME(1424859253)
[1425464053.254277] [002.0] [pid=44143] DELETE FROM nagios_hostchecks WHERE instance_id='1' AND start_time<FROM_UNIXTIME(1424859253)
[1425464053.254388] [002.0] [pid=44143] DELETE FROM nagios_eventhandlers WHERE instance_id='1' AND start_time<FROM_UNIXTIME(1422785653)
[1425464053.254464] [002.0] [pid=44143] DELETE FROM nagios_externalcommands WHERE instance_id='1' AND entry_time<FROM_UNIXTIME(1422785653)
[1425464053.254617] [002.0] [pid=44143] SELECT * FROM nagios_objects WHERE instance_id='1' AND objecttype_id='1' AND BINARY name1='don-ca12-p0-n0-dlink-des3200-28' AND name2 I
[1425464053.254875] [002.0] [pid=44143] INSERT INTO nagios_objects SET instance_id='1', objecttype_id='1' , name1='don-ca12-p0-n0-dlink-des3200-28'
[1425464053.255014] [002.0] [pid=44143] INSERT INTO nagios_hoststatus SET instance_id='1', host_object_id='19', status_update_time=FROM_UNIXTIME(1424941246), output='PING OK -
[1426592936.190325] [002.0] [pid=20929] SELECT instance_id FROM nagios_instances WHERE instance_name='default'
[1426592936.237929] [002.0] [pid=20929] INSERT INTO nagios_conninfo SET instance_id='1', connect_time=NOW(), last_checkin_time=NOW(), bytes_processed='0', lines_processed='0',
[1426592936.276460] [002.0] [pid=20929] SELECT object_id, objecttype_id, name1, name2 FROM nagios_objects WHERE instance_id='1'
[1426592936.283247] [002.0] [pid=20929] SELECT UNIX_TIMESTAMP(status_update_time) AS latest_time FROM nagios_programstatus WHERE instance_id='1' ORDER BY status_update_time DE
[1426592936.308085] [002.0] [pid=20929] SELECT UNIX_TIMESTAMP(status_update_time) AS latest_time FROM nagios_hoststatus WHERE instance_id='1' ORDER BY status_update_time DESC
[1426592936.347742] [002.0] [pid=20929] SELECT UNIX_TIMESTAMP(status_update_time) AS latest_time FROM nagios_servicestatus WHERE instance_id='1' ORDER BY status_update_time DE
[1426592936.368602] [002.0] [pid=20929] SELECT UNIX_TIMESTAMP(status_update_time) AS latest_time FROM nagios_contactstatus WHERE instance_id='1' ORDER BY status_update_time DE
[1426592936.369036] [002.0] [pid=20929] SELECT UNIX_TIMESTAMP(queued_time) AS latest_time FROM nagios_timedeventqueue WHERE instance_id='1' ORDER BY queued_time DESC LIMIT 0,1
[1426592936.369453] [002.0] [pid=20929] SELECT UNIX_TIMESTAMP(entry_time) AS latest_time FROM nagios_comments WHERE instance_id='1' ORDER BY entry_time DESC LIMIT 0,1
[1426592936.380965] [002.0] [pid=20929] UPDATE nagios_conninfo SET last_checkin_time=NOW(), bytes_processed='676', lines_processed='63', entries_processed='0' WHERE conninfo_i
[1426592936.381148] [002.0] [pid=20929] SELECT * FROM nagios_objects WHERE instance_id='1' AND objecttype_id='1' AND BINARY name1='don-ch184a-p10-n0-zyxel-es3124' AND name2 IS
[1426592936.432560] [002.0] [pid=20929] INSERT INTO nagios_objects SET instance_id='1', objecttype_id='1' , name1='don-ch184a-p10-n0-zyxel-es3124'
[1426592936.432767] [002.0] [pid=20929] INSERT INTO nagios_hoststatus SET instance_id='1', host_object_id='20', status_update_time=FROM_UNIXTIME(1424941246), output='PING OK -
[1426592936.433361] [002.0] [pid=20929] DELETE FROM nagios_timedevents WHERE instance_id='1' AND scheduled_time<FROM_UNIXTIME(1426506536)
[1426592936.473709] [002.0] [pid=20929] DELETE FROM nagios_hostchecks WHERE instance_id='1' AND start_time<FROM_UNIXTIME(1425988136)
[1426592936.477860] [002.0] [pid=20929] DELETE FROM nagios_eventhandlers WHERE instance_id='1' AND start_time<FROM_UNIXTIME(1423914536)
[1426592936.493537] [002.0] [pid=20929] DELETE FROM nagios_externalcommands WHERE instance_id='1' AND entry_time<FROM_UNIXTIME(1423914536)
[1426592936.494034] [002.0] [pid=20929] SELECT * FROM nagios_objects WHERE instance_id='1' AND objecttype_id='1' AND BINARY name1='don-ch184a-p11-n0-zyxel-es3124' AND name2 IS
[1426592936.494290] [002.0] [pid=20929] INSERT INTO nagios_objects SET instance_id='1', objecttype_id='1' , name1='don-ch184a-p11-n0-zyxel-es3124'
[1426592936.494479] [002.0] [pid=20929] INSERT INTO nagios_hoststatus SET instance_id='1', host_object_id='21', status_update_time=FROM_UNIXTIME(1424941246), output='PING OK -
[1426593033.095967] [002.0] [pid=24202] SELECT instance_id FROM nagios_instances WHERE instance_name='default'
[1426593033.096152] [002.0] [pid=24202] INSERT INTO nagios_conninfo SET instance_id='1', connect_time=NOW(), last_checkin_time=NOW(), bytes_processed='0', lines_processed='0',
[1426593033.096322] [002.0] [pid=24202] SELECT object_id, objecttype_id, name1, name2 FROM nagios_objects WHERE instance_id='1'
[1426593033.096542] [002.0] [pid=24202] SELECT UNIX_TIMESTAMP(status_update_time) AS latest_time FROM nagios_programstatus WHERE instance_id='1' ORDER BY status_update_time DE
[1426593033.096628] [002.0] [pid=24202] SELECT UNIX_TIMESTAMP(status_update_time) AS latest_time FROM nagios_hoststatus WHERE instance_id='1' ORDER BY status_update_time DESC
[1426593033.096749] [002.0] [pid=24202] SELECT UNIX_TIMESTAMP(status_update_time) AS latest_time FROM nagios_servicestatus WHERE instance_id='1' ORDER BY status_update_time DE
[1426593033.096877] [002.0] [pid=24202] SELECT UNIX_TIMESTAMP(status_update_time) AS latest_time FROM nagios_contactstatus WHERE instance_id='1' ORDER BY status_update_time DE
[1426593033.096953] [002.0] [pid=24202] SELECT UNIX_TIMESTAMP(queued_time) AS latest_time FROM nagios_timedeventqueue WHERE instance_id='1' ORDER BY queued_time DESC LIMIT 0,1
[1426593033.097030] [002.0] [pid=24202] SELECT UNIX_TIMESTAMP(entry_time) AS latest_time FROM nagios_comments WHERE instance_id='1' ORDER BY entry_time DESC LIMIT 0,1
[1426593033.097235] [002.0] [pid=24202] UPDATE nagios_conninfo SET last_checkin_time=NOW(), bytes_processed='675', lines_processed='63', entries_processed='0' WHERE conninfo_i
[1426593033.097393] [002.0] [pid=24202] SELECT * FROM nagios_objects WHERE instance_id='1' AND objecttype_id='1' AND BINARY name1='don-ch186a-p3-n0-zyxel-es3124' AND name2 IS
[1426593033.097717] [002.0] [pid=24202] INSERT INTO nagios_objects SET instance_id='1', objecttype_id='1' , name1='don-ch186a-p3-n0-zyxel-es3124'
[1426593033.097886] [002.0] [pid=24202] INSERT INTO nagios_hoststatus SET instance_id='1', host_object_id='22', status_update_time=FROM_UNIXTIME(1424941246), output='PING OK -
[1426593033.098422] [002.0] [pid=24202] DELETE FROM nagios_timedevents WHERE instance_id='1' AND scheduled_time<FROM_UNIXTIME(1426506633)
[1426593033.098509] [002.0] [pid=24202] DELETE FROM nagios_systemcommands WHERE instance_id='1' AND start_time<FROM_UNIXTIME(1425988233)
[1426593033.098585] [002.0] [pid=24202] DELETE FROM nagios_servicechecks WHERE instance_id='1' AND start_time<FROM_UNIXTIME(1425988233)
[1426593033.098659] [002.0] [pid=24202] DELETE FROM nagios_hostchecks WHERE instance_id='1' AND start_time<FROM_UNIXTIME(1425988233)
[1426593033.098779] [002.0] [pid=24202] DELETE FROM nagios_eventhandlers WHERE instance_id='1' AND start_time<FROM_UNIXTIME(1423914633)
[1426593033.098854] [002.0] [pid=24202] DELETE FROM nagios_externalcommands WHERE instance_id='1' AND entry_time<FROM_UNIXTIME(1423914633)
[1426593033.099011] [002.0] [pid=24202] SELECT * FROM nagios_objects WHERE instance_id='1' AND objecttype_id='1' AND BINARY name1='don-ch186a-p3-n1-dlink-des3200-26' AND name2
[1426593033.099260] [002.0] [pid=24202] INSERT INTO nagios_objects SET instance_id='1', objecttype_id='1' , name1='don-ch186a-p3-n1-dlink-des3200-26'
[1426593033.099444] [002.0] [pid=24202] INSERT INTO nagios_hoststatus SET instance_id='1', host_object_id='23', status_update_time=FROM_UNIXTIME(1424941246), output='PING OK -
[1426681458.129417] [002.0] [pid=63381] SELECT instance_id FROM nagios_instances WHERE instance_name='default'
[1426681458.146529] [002.0] [pid=63381] INSERT INTO nagios_conninfo SET instance_id='1', connect_time=NOW(), last_checkin_time=NOW(), bytes_processed='0', lines_processed='0',
[1426681458.186896] [002.0] [pid=63381] SELECT object_id, objecttype_id, name1, name2 FROM nagios_objects WHERE instance_id='1'
[1426681458.199799] [002.0] [pid=63381] SELECT UNIX_TIMESTAMP(status_update_time) AS latest_time FROM nagios_programstatus WHERE instance_id='1' ORDER BY status_update_time DE
[1426681458.199929] [002.0] [pid=63381] SELECT UNIX_TIMESTAMP(status_update_time) AS latest_time FROM nagios_hoststatus WHERE instance_id='1' ORDER BY status_update_time DESC
[1426681458.208163] [002.0] [pid=63381] SELECT UNIX_TIMESTAMP(status_update_time) AS latest_time FROM nagios_servicestatus WHERE instance_id='1' ORDER BY status_update_time DE
[1426681458.212868] [002.0] [pid=63381] SELECT UNIX_TIMESTAMP(status_update_time) AS latest_time FROM nagios_contactstatus WHERE instance_id='1' ORDER BY status_update_time DE
[1426681458.212975] [002.0] [pid=63381] SELECT UNIX_TIMESTAMP(queued_time) AS latest_time FROM nagios_timedeventqueue WHERE instance_id='1' ORDER BY queued_time DESC LIMIT 0,1
[1426681458.213067] [002.0] [pid=63381] SELECT UNIX_TIMESTAMP(entry_time) AS latest_time FROM nagios_comments WHERE instance_id='1' ORDER BY entry_time DESC LIMIT 0,1
[1426681458.213300] [002.0] [pid=63381] UPDATE nagios_conninfo SET last_checkin_time=NOW(), bytes_processed='676', lines_processed='63', entries_processed='0' WHERE conninfo_i
[1426681458.213499] [002.0] [pid=63381] SELECT * FROM nagios_objects WHERE instance_id='1' AND objecttype_id='1' AND BINARY name1='don-cr7-p0-n0-dlink-dgs1100-06' AND name2 IS
[1426681458.278605] [002.0] [pid=63381] INSERT INTO nagios_objects SET instance_id='1', objecttype_id='1' , name1='don-cr7-p0-n0-dlink-dgs1100-06'
[1426681458.278886] [002.0] [pid=63381] INSERT INTO nagios_hoststatus SET instance_id='1', host_object_id='24', status_update_time=FROM_UNIXTIME(1424941246), output='PING OK -
[1426681458.279836] [002.0] [pid=63381] DELETE FROM nagios_timedevents WHERE instance_id='1' AND scheduled_time<FROM_UNIXTIME(1426595058)
[1426681458.279971] [002.0] [pid=63381] DELETE FROM nagios_systemcommands WHERE instance_id='1' AND start_time<FROM_UNIXTIME(1426076658)
[1426681458.280081] [002.0] [pid=63381] DELETE FROM nagios_servicechecks WHERE instance_id='1' AND start_time<FROM_UNIXTIME(1426076658)
[1426681458.280207] [002.0] [pid=63381] DELETE FROM nagios_hostchecks WHERE instance_id='1' AND start_time<FROM_UNIXTIME(1426076658)
[1426681458.280374] [002.0] [pid=63381] DELETE FROM nagios_eventhandlers WHERE instance_id='1' AND start_time<FROM_UNIXTIME(1424003058)
[1426681458.293750] [002.0] [pid=63381] DELETE FROM nagios_externalcommands WHERE instance_id='1' AND entry_time<FROM_UNIXTIME(1424003058)