18883:20220426:170414.785 forced execution of the housekeeper
 18883:20220426:170414.785 In zbx_ipc_async_socket_recv() timeout:0
 18883:20220426:170414.785 End of zbx_ipc_async_socket_recv():0
 18883:20220426:170414.785 executing housekeeper
 18883:20220426:170414.785 zbx_setproctitle() title:'housekeeper [connecting to the database]'
 18883:20220426:170414.785 In DBconnect() flag:0
 18883:20220426:170414.790 query [txnlev:0] [select oid from pg_type where typname='bytea']
 18883:20220426:170414.794 query without transaction detected
 18883:20220426:170414.794 query [txnlev:0] [set escape_string_warning to off]
 18883:20220426:170414.794 query without transaction detected
 18883:20220426:170414.794 query [txnlev:0] [set extra_float_digits to 3]
 18883:20220426:170414.794 query [txnlev:0] [show standard_conforming_strings]
 18883:20220426:170414.794 query without transaction detected
 18883:20220426:170414.794 query [txnlev:0] [set bytea_output=escape]
 18883:20220426:170414.794 End of DBconnect():0
 18883:20220426:170414.794 zbx_setproctitle() title:'housekeeper [synchronizing history and trends compression settings]'
 18883:20220426:170414.794 In hk_history_compression_update()
 18883:20220426:170414.794 End of hk_history_compression_update()
 18883:20220426:170414.795 zbx_setproctitle() title:'housekeeper [removing old history and trends]'
 18883:20220426:170414.795 In housekeeping_history_and_trends() now:1650985454
 18883:20220426:170414.795 In hk_history_delete_queue_prepare_all()
 18883:20220426:170414.795 End of hk_history_delete_queue_prepare_all()
 18883:20220426:170414.795 In hk_drop_partition_for_rule() now:1650985454
 18883:20220426:170414.795 query [txnlev:0] [select drop_chunks(relation=>'history',older_than=>1650121454)]
 18883:20220426:170414.795 End of hk_drop_partition_for_rule()
 18883:20220426:170414.795 In hk_drop_partition_for_rule() now:1650985454
 18883:20220426:170414.795 query [txnlev:0] [select drop_chunks(relation=>'history_str',older_than=>1650121454)]
 18883:20220426:170414.795 End of hk_drop_partition_for_rule()
 18883:20220426:170414.795 In hk_drop_partition_for_rule() now:1650985454
 18883:20220426:170414.795 query [txnlev:0] [select drop_chunks(relation=>'history_log',older_than=>1650121454)]
 18883:20220426:170414.796 End of hk_drop_partition_for_rule()
 18883:20220426:170414.796 In hk_drop_partition_for_rule() now:1650985454
 18883:20220426:170414.796 query [txnlev:0] [select drop_chunks(relation=>'history_uint',older_than=>1650121454)]
 18883:20220426:170414.796 End of hk_drop_partition_for_rule()
 18883:20220426:170414.796 In hk_drop_partition_for_rule() now:1650985454
 18883:20220426:170414.796 query [txnlev:0] [select drop_chunks(relation=>'history_text',older_than=>1650121454)]
 18883:20220426:170414.796 End of hk_drop_partition_for_rule()
 18883:20220426:170414.796 In hk_drop_partition_for_rule() now:1650985454
 18883:20220426:170414.796 query [txnlev:0] [select drop_chunks(relation=>'trends',older_than=>1335625454)]
 18883:20220426:170414.796 End of hk_drop_partition_for_rule()
 18883:20220426:170414.796 In hk_drop_partition_for_rule() now:1650985454
 18883:20220426:170414.796 query [txnlev:0] [select drop_chunks(relation=>'trends_uint',older_than=>1335625454)]
 18883:20220426:170414.796 End of hk_drop_partition_for_rule()
 18883:20220426:170414.797 End of housekeeping_history_and_trends():0
 18883:20220426:170414.797 zbx_setproctitle() title:'housekeeper [removing old problems]'
 18883:20220426:170414.797 In housekeeping_problems() now:1650985454
 18883:20220426:170414.797 query without transaction detected
 18883:20220426:170414.797 query [txnlev:0] [delete from problem where r_clock<>0 and r_clock<1650899054]
 18883:20220426:170414.820 End of housekeeping_problems():8
 18883:20220426:170414.820 zbx_setproctitle() title:'housekeeper [removing old events]'
 18883:20220426:170414.820 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:1637062594 now:1650985454
 18883:20220426:170414.820 End of housekeeping_process_rule():0
 18883:20220426:170414.820 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:1607486732 now:1650985454
 18883:20220426:170414.820 query [txnlev:0] [select eventid from events where clock<1607501132 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]
 18883:20220426:170414.821 End of housekeeping_process_rule():0
 18883:20220426:170414.821 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:1650984798 now:1650985454
 18883:20220426:170414.821 End of housekeeping_process_rule():0
 18883:20220426:170414.821 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:1650984798 now:1650985454
 18883:20220426:170414.821 End of housekeeping_process_rule():0
 18883:20220426:170414.821 In housekeeping_process_rule() table:'events' field_name:'eventid' filter:'events.source=1 and events.object=1' min_clock:1650984798 now:1650985454
 18883:20220426:170414.821 End of housekeeping_process_rule():0
 18883:20220426:170414.821 In housekeeping_process_rule() table:'events' field_name:'eventid' filter:'events.source=1 and events.object=2' min_clock:1650984798 now:1650985454
 18883:20220426:170414.821 End of housekeeping_process_rule():0
 18883:20220426:170414.821 In housekeeping_process_rule() table:'events' field_name:'eventid' filter:'events.source=2 and events.object=3' min_clock:1650984798 now:1650985454
 18883:20220426:170414.821 End of housekeeping_process_rule():0
 18883:20220426:170414.821 In housekeeping_process_rule() table:'events' field_name:'eventid' filter:'events.source=4 and events.object=6 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:1650984798 now:1650985454
 18883:20220426:170414.821 End of housekeeping_process_rule():0
 18883:20220426:170414.821 zbx_setproctitle() title:'housekeeper [removing old sessions]'
 18883:20220426:170414.821 In housekeeping_sessions() now:1650985454
 18883:20220426:170414.821 query without transaction detected
 18883:20220426:170414.821 query [txnlev:0] [delete from sessions where lastaccess<1619449454 and ctid = any(array(select ctid from sessions where lastaccess<1619449454 limit 5000))]
 18883:20220426:170414.822 End of housekeeping_sessions():0
 18883:20220426:170414.822 zbx_setproctitle() title:'housekeeper [removing old service alarms]'
 18883:20220426:170414.822 In housekeeping_process_rule() table:'service_alarms' field_name:'servicealarmid' filter:'' min_clock:1650984798 now:1650985454
 18883:20220426:170414.822 End of housekeeping_process_rule():0
 18883:20220426:170414.822 zbx_setproctitle() title:'housekeeper [removing old audit log items]'
 18883:20220426:170414.822 In housekeeping_process_rule() table:'auditlog' field_name:'auditid' filter:'' min_clock:1637585302 now:1650985454
 18883:20220426:170414.822 End of housekeeping_process_rule():0
 18883:20220426:170414.822 zbx_setproctitle() title:'housekeeper [removing old records]'
 18883:20220426:170414.822 In housekeeping_proxy_dhistory() now:1650985454
 18883:20220426:170414.822 query without transaction detected
 18883:20220426:170414.822 query [txnlev:0] [delete from proxy_dhistory where clock<1650899054]
 18883:20220426:170414.822 End of housekeeping_proxy_dhistory():0
 18883:20220426:170414.822 zbx_setproctitle() title:'housekeeper [removing deleted items data]'
 18883:20220426:170414.822 In housekeeping_cleanup()
 18883:20220426:170414.822 query [txnlev:0] [select housekeeperid,tablename,field,value from housekeeper where tablename in ('events') order by tablename]
 18883:20220426:170414.824 End of housekeeping_cleanup():0
 18883:20220426:170414.824 housekeeper [deleted 0 hist/trends, 0 items/triggers, 0 events, 8 problems, 0 sessions, 0 alarms, 0 audit, 0 records in 0.029768 sec, idle for 1 hour(s)]
 18883:20220426:170414.844 zbx_setproctitle() title:'housekeeper [deleted 0 hist/trends, 0 items/triggers, 0 events, 0 sessions, 0 alarms, 0 audit items, 0 records in 0.029768 sec, idle for 1 hour(s)]'
 18883:20220426:170414.844 In zbx_ipc_async_socket_recv() timeout:3600