20190115.093600.00 tr2 [ 1084 b4c] sch [Sch] Regular timer event occured
20190115.093600.00 inf [ 1084 b4c] sch [Sch] Executing job "Purge old data" [Daily at 09:36] (Purge old database records 30:30:30:30:30:30:30:30:30:30:30:30:30:30:30:30:30:30:30:30:30:30:30:30:30:30:30:30)
20190115.093600.00 db1 [ 1084 b4c] sch [DB] Purge old database records 30:30:30:30:30:30:30:30:30:30:30:30:30:30:30:30:30:30:30:30:30:30:30:30:30:30:30:30
20190115.093600.00 db3 [ 1084 b4c] sch [DB] Thread "sch" has got connection "server_t::purge_records()"
20190115.093600.00 db3 [ 1084 b4c] sch [DB] Database is free to use
20190115.093600.00 db3 [ 1084 b4c] sch [IntDB] Statement "BEGIN TRANSACTION"
20190115.093600.00 db3 [ 1084 b4c] sch [DB] Successful BEGIN transaction, 00.001 wait
20190115.093600.00 db3 [ 1084 b4c] sch [IntDB] Statement "DELETE FROM run WHERE beginrecvtime <= '20181216063600001'"
20190115.093600.02 db2 [ 1084 b4c] sch [DB] 2 rows, 00.023, DELETE FROM run WHERE beginrecvtime <= ? [20181216063600001]
20190115.093600.02 db3 [ 1084 b4c] sch [IntDB] Statement "DELETE FROM infection WHERE infectionrecvtime <= '20181216063600024'"
20190115.093600.02 db3 [ 1084 b4c] sch [DB] OK, 00.000, DELETE FROM infection WHERE infectionrecvtime <= ? [20181216063600024]
20190115.093600.02 db3 [ 1084 b4c] sch [IntDB] Statement "DELETE FROM scanstat WHERE recievetime <= '20181216063600024'"
20190115.093600.03 db2 [ 1084 b4c] sch [DB] 7 rows, 00.013, DELETE FROM scanstat WHERE recievetime <= ? [20181216063600024]
20190115.093600.03 db3 [ 1084 b4c] sch [IntDB] Statement "DELETE FROM installation WHERE starttime <= '20181216063600037'"
20190115.093600.03 db3 [ 1084 b4c] sch [DB] OK, 00.000, DELETE FROM installation WHERE starttime <= ? [20181216063600037]
20190115.093600.03 db3 [ 1084 b4c] sch [IntDB] Statement "DELETE FROM procerror WHERE errrecvtime <= '20181216063600037'"
20190115.093600.03 db3 [ 1084 b4c] sch [DB] OK, 00.001, DELETE FROM procerror WHERE errrecvtime <= ? [20181216063600037]
20190115.093600.03 db3 [ 1084 b4c] sch [IntDB] Statement "DELETE FROM jobs_log WHERE completed <= '20181216063600038'"
20190115.093600.05 db2 [ 1084 b4c] sch [DB] 4 rows, 00.013, DELETE FROM jobs_log WHERE completed <= ? [20181216063600038]
20190115.093600.05 db3 [ 1084 b4c] sch [IntDB] Statement "DELETE FROM station_components WHERE modtime <= '20181216063600051'"
20190115.093600.05 db3 [ 1084 b4c] sch [DB] OK, 00.000, DELETE FROM station_components WHERE modtime <= ? [20181216063600051]
20190115.093600.05 db3 [ 1084 b4c] sch [IntDB] Statement "DELETE FROM station_environment WHERE createtime <= '20181216063600051'"
20190115.093600.05 db3 [ 1084 b4c] sch [DB] OK, 00.000, DELETE FROM station_environment WHERE createtime <= ? [20181216063600051]
20190115.093600.05 db3 [ 1084 b4c] sch [IntDB] Statement "DELETE FROM station_vdb WHERE createtime <= '20181216063600051'"
20190115.093600.19 db3 [ 1084 b4c] sch [DB] OK, 00.148, DELETE FROM station_vdb WHERE createtime <= ? [20181216063600051]
20190115.093600.19 db3 [ 1084 b4c] sch [IntDB] Statement "DELETE FROM station_status WHERE createtime <= '20181216063600199'"
20190115.093600.19 db3 [ 1084 b4c] sch [DB] OK, 00.000, DELETE FROM station_status WHERE createtime <= ? [20181216063600199]
20190115.093600.19 db3 [ 1084 b4c] sch [IntDB] Statement "DELETE FROM station_modules WHERE createtime <= '20181216063600199'"
20190115.093600.23 db3 [ 1084 b4c] sch [DB] OK, 00.038, DELETE FROM station_modules WHERE createtime <= ? [20181216063600199]
20190115.093600.23 db3 [ 1084 b4c] sch [IntDB] Statement "DELETE FROM station_running WHERE starttime <= '20181216063600237'"
20190115.093600.23 db3 [ 1084 b4c] sch [DB] OK, 00.000, DELETE FROM station_running WHERE starttime <= ? [20181216063600237]
20190115.093600.23 db3 [ 1084 b4c] sch [IntDB] Statement "DELETE FROM server_jobs_log WHERE completed <= '20181216063600238'"
20190115.093600.23 db2 [ 1084 b4c] sch [DB] 3 rows, 00.000, DELETE FROM server_jobs_log WHERE completed <= ? [20181216063600238]
20190115.093600.23 db3 [ 1084 b4c] sch [IntDB] Statement "DELETE FROM srv_run WHERE arrived <= '20181216063600238'"
20190115.093600.23 db3 [ 1084 b4c] sch [DB] OK, 00.000, DELETE FROM srv_run WHERE arrived <= ? [20181216063600238]
20190115.093600.23 db3 [ 1084 b4c] sch [IntDB] Statement "DELETE FROM srv_infection WHERE arrived <= '20181216063600238'"
20190115.093600.23 db3 [ 1084 b4c] sch [DB] OK, 00.000, DELETE FROM srv_infection WHERE arrived <= ? [20181216063600238]
20190115.093600.23 db3 [ 1084 b4c] sch [IntDB] Statement "DELETE FROM srv_procerror WHERE arrived <= '20181216063600238'"
20190115.093600.23 db3 [ 1084 b4c] sch [DB] OK, 00.000, DELETE FROM srv_procerror WHERE arrived <= ? [20181216063600238]
20190115.093600.23 db3 [ 1084 b4c] sch [IntDB] Statement "DELETE FROM srv_scanstat WHERE arrived <= '20181216063600238'"
20190115.093600.23 db3 [ 1084 b4c] sch [DB] OK, 00.000, DELETE FROM srv_scanstat WHERE arrived <= ? [20181216063600238]
20190115.093600.23 db3 [ 1084 b4c] sch [IntDB] Statement "DELETE FROM srv_installation WHERE arrived <= '20181216063600238'"
20190115.093600.23 db3 [ 1084 b4c] sch [DB] OK, 00.001, DELETE FROM srv_installation WHERE arrived <= ? [20181216063600238]
20190115.093600.23 db3 [ 1084 b4c] sch [IntDB] Statement "DELETE FROM srv_unsent WHERE arrived <= '20181216063600239'"
20190115.093600.23 db3 [ 1084 b4c] sch [DB] OK, 00.000, DELETE FROM srv_unsent WHERE arrived <= ? [20181216063600239]
20190115.093600.23 db3 [ 1084 b4c] sch [IntDB] Statement "DELETE FROM srv_recvhistory WHERE arrived <= '20181216063600239'"
20190115.093600.23 db3 [ 1084 b4c] sch [DB] OK, 00.000, DELETE FROM srv_recvhistory WHERE arrived <= ? [20181216063600239]
20190115.093600.23 db3 [ 1084 b4c] sch [IntDB] Statement "DELETE FROM srv_names WHERE updatetime <= '20181216063600239'"
20190115.093600.23 db3 [ 1084 b4c] sch [DB] OK, 00.000, DELETE FROM srv_names WHERE updatetime <= ? [20181216063600239]
20190115.093600.23 db3 [ 1084 b4c] sch [IntDB] Statement "DELETE FROM srv_status WHERE arrived <= '20181216063600239'"
20190115.093600.23 db3 [ 1084 b4c] sch [DB] OK, 00.000, DELETE FROM srv_status WHERE arrived <= ? [20181216063600239]
20190115.093600.23 db3 [ 1084 b4c] sch [IntDB] Statement "DELETE FROM deleted_stations WHERE deleted <= '20181216063600239'"
20190115.093600.23 db3 [ 1084 b4c] sch [DB] OK, 00.000, DELETE FROM deleted_stations WHERE deleted <= ? [20181216063600239]
20190115.093600.24 db3 [ 1084 b4c] sch [IntDB] Statement "DELETE FROM station_offline_cmd WHERE created <= '20181216063600240'"
20190115.093600.24 db3 [ 1084 b4c] sch [DB] OK, 00.000, DELETE FROM station_offline_cmd WHERE created <= ? [20181216063600240]
20190115.093600.24 db3 [ 1084 b4c] sch [IntDB] Statement "DELETE FROM admin_activity WHERE createtime <= '20181216063600240'"
20190115.093600.24 db3 [ 1084 b4c] sch [DB] OK, 00.000, DELETE FROM admin_activity WHERE createtime <= ? [20181216063600240]
20190115.093600.24 db3 [ 1084 b4c] sch [IntDB] Statement "DELETE FROM activity_data WHERE createtime <= '20181216063600240'"
20190115.093600.24 db3 [ 1084 b4c] sch [DB] OK, 00.000, DELETE FROM activity_data WHERE createtime <= ? [20181216063600240]
20190115.093600.24 db3 [ 1084 b4c] sch [IntDB] Statement "DELETE FROM quarantine_actions WHERE created <= '20181216063600240'"
20190115.093600.24 db3 [ 1084 b4c] sch [DB] OK, 00.000, DELETE FROM quarantine_actions WHERE created <= ? [20181216063600240]
20190115.093600.24 db3 [ 1084 b4c] sch [IntDB] Statement "DELETE FROM station_history WHERE created <= '20181216063600240'"
20190115.093600.24 db3 [ 1084 b4c] sch [DB] OK, 00.001, DELETE FROM station_history WHERE created <= ? [20181216063600240]
20190115.093600.24 db3 [ 1084 b4c] sch [IntDB] Statement "COMMIT"
20190115.093600.33 db3 [ 1084 13e0] mth:2 [Update] tcp/192.168.2.138:1217/00000000031E8190:1/st:SEKRETAR: update is not enabled at this time
20190115.093600.33 db3 [ 1084 13e0] mth:2 [Logger] Last message repeated 3 times
20190115.093600.33 db1 [ 1084 13e0] mth:2 tcp/192.168.2.138:1217/00000000031E8190:1/st:SEKRETAR: scheduling heartbeat event in 30 seconds
20190115.093600.37 db2 [ 1084 3c8] mth:4 [Update] tcp/192.168.3.82:1183/000000000533F3E0:1/st:422-3: agent want product '10-drwbases'; product found, state is 1547510674->1547510674 'S', server revision is 1547510674
20190115.093600.37 db3 [ 1084 3c8] mth:4 [Update] tcp/192.168.3.82:1183/000000000533F3E0:1/st:422-3: zero size update request ignored
20190115.093600.37 db2 [ 1084 3c8] mth:4 [Update] tcp/192.168.3.82:1183/000000000533F3E0:1/st:422-3: agent want product '10-drwupgrade'; product found, state is 1404290322->1404290322 'S', server revision is 1404290322
20190115.093600.37 db3 [ 1084 3c8] mth:4 [Update] tcp/192.168.3.82:1183/000000000533F3E0:1/st:422-3: zero size update request ignored
20190115.093600.37 db2 [ 1084 3c8] mth:4 [Update] tcp/192.168.3.82:1183/000000000533F3E0:1/st:422-3: agent want product '20-drwagntd'; product found, state is 1547510818->1547510818 'S', server revision is 1547510818
20190115.093600.37 db3 [ 1084 3c8] mth:4 [Update] tcp/192.168.3.82:1183/000000000533F3E0:1/st:422-3: zero size update request ignored
20190115.093600.37 db1 [ 1084 3c8] mth:4 tcp/192.168.3.82:1183/000000000533F3E0:1/st:422-3: scheduling heartbeat event in 30 seconds
20190115.093601.11 db3 [ 1084 b4c] sch [DB] Database has been freed but nobody wants it now
20190115.093601.11 db3 [ 1084 b4c] sch [DB] Successful COMMIT transaction, 28 statements, 00.001 wait, 01.108 execute, 00.870 commit
20190115.093601.11 db3 [ 1084 b4c] sch [DB] Successful "purge records" transaction commited well
20190115.093601.11 db3 [ 1084 b4c] sch [DB] Thread "sch" has freed connection "server_t::purge_records()"
20190115.093601.11 db3 [ 1084 b4c] sch [DB] Thread "sch" has got connection "server_t::register_admin_activity()"
20190115.093601.11 db3 [ 1084 b4c] sch [DB] Database is free to use
20190115.093601.11 db3 [ 1084 b4c] sch [IntDB] Statement "BEGIN TRANSACTION"
20190115.093601.11 db3 [ 1084 b4c] sch [DB] Successful BEGIN transaction, 00.001 wait
20190115.093601.11 db3 [ 1084 b4c] sch [IntDB] Statement "INSERT INTO admin_activity VALUES('704e03d3-d11d-b211-bf30-bc04c1305269','','','3','10300','1','20190115063601112')"
20190115.093601.11 db2 [ 1084 b4c] sch [DB] 1 row, 00.000, INSERT INTO admin_activity VALUES(?,?,?,?,?,?,?) ["704e03d3-d11d-b211-bf30-bc04c1305269", "", "", 3, 10300, 1, 20190115063601112]
20190115.093601.11 db3 [ 1084 b4c] sch [IntDB] Statement "COMMIT"
20190115.093601.11 db3 [ 1084 cd0] pth:4 [DB] Thread "pth:4" has got connection "intsrv_n::report_status_to_parent_job_t::process()"
20190115.093601.11 db2 [ 1084 cd0] pth:4 [DB] Database is being used by thread sch (1 waiting)
20190115.093601.20 db2 [ 1084 b4c] sch [DB] Caught sight of waiting thread pth:4, waking it up
20190115.093601.20 db3 [ 1084 b4c] sch [DB] Successful COMMIT transaction, 1 statement, 00.001 wait, 00.095 execute, 00.095 commit
20190115.093601.20 db3 [ 1084 b4c] sch [DB] Successful "register admin activity" transaction commited well
20190115.093601.20 db3 [ 1084 b4c] sch [DB] Thread "sch" has freed connection "server_t::register_admin_activity()"
20190115.093601.20 inf [ 1084 b4c] sch [Sch] Job "Purge old data" said nothing
20190115.093601.20 db3 [ 1084 b4c] sch [Sch] Job "Purge old data" next execution time is 2019-Jan-16 09:36:00
Сообщение было изменено AdminKontory: 15 Январь 2019 - 09:49