Member
Отправлено 14 Январь 2019 - 16:15
Добрый день. Такой вопрос. Не выполняются задания по удалению старых записей и удаленных станций. БД внутренняя, 1,5 гига на 112 пользователей. Очистка станций которые не были в сети проходит корректно, а удаление удаленных не хочет. В протоколе выполнения на сервере написано что Purge old data состояние ОК, а там где сообщение/ошибка ничего не написано. И еще. При попытке включить детальный или стандартный лог, получаю ошибку что доступ запрещен.
Кто что посоветует?
Guru
Отправлено 14 Январь 2019 - 19:44
Начнём с конца. Без самозащиты уже смотрели?
tough guy
Отправлено 15 Январь 2019 - 00:12
И почему до сих пор ES6?
Best regards
Member
Отправлено 15 Январь 2019 - 07:30
Начнём с конца. Без самозащиты уже смотрели?
Без самозащиты детальный и стандартный лог включается. А вот удаленные станции не удаляются
20190115.072700.00 inf [ 5836 14e0] sch [Sch] Executing job "Purge old data" [Daily at 07:27] (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.072700.98 inf [ 5836 14e0] sch [Sch] Job "Purge old data" said nothing
Guru
Отправлено 15 Январь 2019 - 09:16
А вот теперь показывайте этот самый детальный лог.
Member
Отправлено 15 Январь 2019 - 09:49
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
Guru
Отправлено 15 Январь 2019 - 09:51
И что при этом остаётся такое, что оставаться не должно?
Member
Отправлено 15 Январь 2019 - 10:15
24 удаленных станций не исчезают
Guru
Отправлено 15 Январь 2019 - 12:00
Когда они были удалены?
Member
Отправлено 15 Январь 2019 - 12:29
давно. месяцев 3-6 назад
Guru
Отправлено 15 Январь 2019 - 12:34
http://<server.addr>:9080/db-query.ds
SELECT * FROM deleted_stations
Сообщение было изменено Afalin: 15 Январь 2019 - 12:34
Member
Отправлено 15 Январь 2019 - 13:22
отобразились все станции удаленные, в строке Deleted стоит 12 и 15 января.
Guru
Отправлено 15 Январь 2019 - 16:50
Тогда предположу, что станции создаются заново, а потом удаляются обратно.
Они вручную удаляются или заданием? Нужно в общем больше подробностей.
Member
Отправлено 16 Январь 2019 - 12:05
Из центра управления выбираю станцию, жму деинсталировать клиент. Он удаляется с компа, а в центре отображается с крестиком. Потом в центре выбираю эту станцию, и нажимаю вверху на красный крест "удалить". Все эти удаленные станции перемещаются "Антивирусная сеть - Status - Deleted". Задание настроено удалять станции удаленные более 30 дней.
Guru
Отправлено 16 Январь 2019 - 12:10
И это было проделано 3-6 месяцев назад именно с этими станциями?
Если да, предлагаю начать с изучения журнала аудита. С целью выяснить, что происходит со станцией между удалениями.
Member
Отправлено 16 Январь 2019 - 14:13
Точно не знаю когда это было, 3-6 месяцев это примерно
Как сжать можно базу или обслужить ее?
Guru
Отправлено 16 Январь 2019 - 16:40
В том же db-query.ds дать запрос VACUUM и посмотреть, что получится.
0 пользователей, 0 гостей, 0 скрытых
Community Forum Software by IP.Board
Владелец лицензии: Doctor Web, Ltd.
