14157:20181206:090739.556 End of housekeeping_history_and_trends():731569
 14157:20181206:090739.556 __zbx_zbx_setproctitle() title:'housekeeper [removing old problems]'
 14157:20181206:090739.556 In housekeeping_problems() now:1544086863
 14157:20181206:090739.557 query without transaction detected
 14157:20181206:090739.557 query [txnlev:0] [delete from problem where r_clock<>0 and r_clock<1544000463]
 14157:20181206:090744.630 End of housekeeping_problems():35955
 14157:20181206:090744.631 __zbx_zbx_setproctitle() title:'housekeeper [removing old events]'
 14157:20181206:090744.631 In housekeeping_process_rule() table:'events' field_name:'eventid' filter:'events.source=0 and events.object=0 and not exists (select null from problem where events.eventid=problem.eventid) and not exists (select null from problem where events.eventid=problem.r_eventid)' min_clock:1516077850 now:1544086863
 14157:20181206:090744.631 query [txnlev:0] [select eventid from events where clock<1516092250 and events.source=0 and events.object=0 and not exists (select null from problem where events.eventid=problem.eventid) and not exists (select null from problem where events.eventid=problem.r_eventid) order by eventid limit 5000]
 14157:20181206:090744.645 query without transaction detected
 14157:20181206:090744.645 query [txnlev:0] [delete from events where (eventid between 36611840 and 36611847 or eventid between 36611854 and 36611858 or eventid between 36611875 and 36611881 or eventid between 36611883 and 36611889 or eventid between 36611893 and 36611899 or eventid between 36611903 and 36611911 or eventid between 36611916 and 36611922 or eventid between 36611927 and 36611936 or eventid between 36611939 and 36611947 or eventid between 36611950 and 36611966 or eventid between 36611969 and 36611995 or eventid between 36611998 and 36612007 or eventid between 36612009 and 36612016 or eventid between 36612030 and 36612035 or eventid between 36612060 and 36612064 or eventid between 36612071 and 36612082 or eventid between 36612084 and 36612090 or eventid between 36612094 and 36612099 or eventid between 36612114 and 36612120 or eventid between 36612126 and 36612133 or eventid between 36612141 and 36612146 or eventid between 36612149 and 36612163 or eventid between 36612167 and 36612180 or eventid between 36612188 and 36612197 or eventid between 36612204 and 36612209 or eventid between 36612212 and 36612216 or eventid between 36612233 and 36612240 or eventid between 36612244 and 36612254 or eventid between 36612260 and 36612270 or eventid between 36612280 and 36612288 or eventid between 36612290 and 36612294 or eventid between 36612297 and 36612301 or eventid between 36612305 and 36612317 or eventid between 36612342 and 36612362 or eventid between 36612371 and 36612384 or eventid between 36612388 and 36612393 or eventid between 36612401 and 36612410 or eventid between 36612413 and 36612417 or eventid between 36612420 and 36612437 or eventid between 36612442 and 36612463 or eventid between 36612467 and 36612495 or eventid in (36611836,36611837,36611851,36611864,36611865,36611866,36611867,36611870,36611871,36612023,36612024,36612025,36612026,36612038,36612041,36612044,36612047,36612048,36612049,36612050,36612052,36612053,36612054,36612055,36612057,36612067,36612068,36612103,36612104,36612105,36612106,36612110,36612111,36612112,36612124,36612135,36612136,36612137,36612138,36612185,36612186,36612201,36612219,36612220,36612221,36612223,36612225,36612226,36612229,36612256,36612274,36612277,36612278,36612321,36612322,36612323,36612326,36612327,36612328,36612329,36612332,36612333,36612334,36612335,36612338,36612339,36612340,36612366,36612397,36612398,36612440,36612465))]
 14157:20181206:090744.749 query [txnlev:0] [select eventid from events where clock<1516092250 and events.source=0 and events.object=0 and not exists (select null from problem where events.eventid=problem.eventid) and not exists (select null from problem where events.eventid=problem.r_eventid) order by eventid limit 5000]
 14157:20181206:090744.752 End of housekeeping_process_rule():497
 14157:20181206:090744.752 In housekeeping_process_rule() table:'events' field_name:'eventid' filter:'events.source=3 and events.object=0 and not exists (select null from problem where events.eventid=problem.eventid) and not exists (select null from problem where events.eventid=problem.r_eventid)' min_clock:1516078864 now:1544086863
 14157:20181206:090744.752 query [txnlev:0] [select eventid from events where clock<1516093264 and events.source=3 and events.object=0 and not exists (select null from problem where events.eventid=problem.eventid) and not exists (select null from problem where events.eventid=problem.r_eventid) order by eventid limit 5000]
 14157:20181206:090744.757 query without transaction detected
 14157:20181206:090744.757 query [txnlev:0] [delete from events where eventid in (36611882,36611915,36611926,36612020,36612021,36612022,36612029,36612102,36612109,36612139,36612140,36612166,36612184,36612210,36612211,36612218,36612224,36612257,36612258,36612275,36612276,36612331,36612337,36612367,36612368,36612369,36612394,36612441,36612466)]
 14157:20181206:090744.812 query [txnlev:0] [select eventid from events where clock<1516093264 and events.source=3 and events.object=0 and not exists (select null from problem where events.eventid=problem.eventid) and not exists (select null from problem where events.eventid=problem.r_eventid) order by eventid limit 5000]
 14157:20181206:090744.813 End of housekeeping_process_rule():29
 14157:20181206:090744.813 In housekeeping_process_rule() table:'events' field_name:'eventid' filter:'events.source=3 and events.object=4 and not exists (select null from problem where events.eventid=problem.eventid) and not exists (select null from problem where events.eventid=problem.r_eventid)' min_clock:1516077775 now:1544086863
 14157:20181206:090744.813 query [txnlev:0] [select eventid from events where clock<1516092175 and events.source=3 and events.object=4 and not exists (select null from problem where events.eventid=problem.eventid) and not exists (select null from problem where events.eventid=problem.r_eventid) order by eventid limit 5000]
 14157:20181206:090744.817 query without transaction detected
 14157:20181206:090744.817 query [txnlev:0] [delete from events where eventid in (36612036,36612037,36612045,36612046,36612217,36612222,36612330,36612336,36612395,36612396)]
 14157:20181206:090744.822 query [txnlev:0] [select eventid from events where clock<1516092175 and events.source=3 and events.object=4 and not exists (select null from problem where events.eventid=problem.eventid) and not exists (select null from problem where events.eventid=problem.r_eventid) order by eventid limit 5000]
 14157:20181206:090744.823 End of housekeeping_process_rule():10
 14157:20181206:090744.823 In housekeeping_process_rule() table:'events' field_name:'eventid' filter:'events.source=3 and events.object=5 and not exists (select null from problem where events.eventid=problem.eventid) and not exists (select null from problem where events.eventid=problem.r_eventid)' min_clock:1517695766 now:1544086863
 14157:20181206:090744.823 query [txnlev:0] [select eventid from events where clock<1517710166 and events.source=3 and events.object=5 and not exists (select null from problem where events.eventid=problem.eventid) and not exists (select null from problem where events.eventid=problem.r_eventid) order by eventid limit 5000]
 14157:20181206:090744.827 End of housekeeping_process_rule():0
 14157:20181206:090744.827 In housekeeping_process_rule() table:'events' field_name:'eventid' filter:'events.source=1 and events.object=1' min_clock:1543479354 now:1544086863
 14157:20181206:090744.827 query [txnlev:0] [select eventid from events where clock<1543482063 and events.source=1 and events.object=1 order by eventid limit 5000]
 14157:20181206:090744.828 End of housekeeping_process_rule():0
 14157:20181206:090744.828 In housekeeping_process_rule() table:'events' field_name:'eventid' filter:'events.source=1 and events.object=2' min_clock:1543479354 now:1544086863
 14157:20181206:090744.828 query [txnlev:0] [select eventid from events where clock<1543482063 and events.source=1 and events.object=2 order by eventid limit 5000]
 14157:20181206:090744.830 End of housekeeping_process_rule():0
 14157:20181206:090744.831 In housekeeping_process_rule() table:'events' field_name:'eventid' filter:'events.source=2 and events.object=3' min_clock:1520179261 now:1544086863
 14157:20181206:090744.831 query [txnlev:0] [select eventid from events where clock<1520193661 and events.source=2 and events.object=3 order by eventid limit 5000]
 14157:20181206:090744.832 End of housekeeping_process_rule():0
 14157:20181206:090744.832 __zbx_zbx_setproctitle() title:'housekeeper [removing old sessions]'
 14157:20181206:090744.833 In housekeeping_sessions() now:1544086863
 14157:20181206:090744.833 query without transaction detected
 14157:20181206:090744.833 query [txnlev:0] [delete from sessions where lastaccess<1543482063 limit 5000]
 14157:20181206:090744.833 End of housekeeping_sessions():0
 14157:20181206:090744.833 __zbx_zbx_setproctitle() title:'housekeeper [removing old service alarms]'
 14157:20181206:090744.834 In housekeeping_process_rule() table:'service_alarms' field_name:'servicealarmid' filter:'' min_clock:1544035514 now:1544086863
 14157:20181206:090744.834 End of housekeeping_process_rule():0
 14157:20181206:090744.834 __zbx_zbx_setproctitle() title:'housekeeper [removing old audit log items]'
 14157:20181206:090744.834 In housekeeping_process_rule() table:'auditlog' field_name:'auditid' filter:'' min_clock:1516077832 now:1544086863
 14157:20181206:090744.834 query [txnlev:0] [select auditid from auditlog where clock<1516092232 order by auditid limit 5000]
 14157:20181206:090744.836 query without transaction detected
 14157:20181206:090744.836 query [txnlev:0] [delete from auditlog where auditid between 241300 and 241347]
 14157:20181206:090744.842 query [txnlev:0] [select auditid from auditlog where clock<1516092232 order by auditid limit 5000]
 14157:20181206:090744.843 End of housekeeping_process_rule():48
 14157:20181206:090744.843 __zbx_zbx_setproctitle() title:'housekeeper [removing deleted items data]'
 14157:20181206:090744.843 In housekeeping_cleanup()
 14157:20181206:090744.843 query [txnlev:0] [select housekeeperid,tablename,field,value from housekeeper where tablename in ('history','history_log','history_str','history_text','history_uint','trends','trends_uint','events') order by tablename]
 14157:20181206:090744.844 End of housekeeping_cleanup():0
 14157:20181206:090744.844 housekeeper [deleted 731569 hist/trends, 0 items/triggers, 536 events, 35955 problems, 0 sessions, 0 alarms, 48 audit items in 401.789149 sec, idle for 1 hour(s)]
 14157:20181206:090744.844 __zbx_zbx_setproctitle() title:'housekeeper [deleted 731569 hist/trends, 0 items/triggers, 536 events, 0 sessions, 0 alarms, 48 audit items in 401.789149 sec, idle for 1 hour(s)]'