|
Чистка логов 1С с помощью SQLLite
|
|||
---|---|---|---|
#18+
Пытаюсь удалить из логов сервера 1С все записи фонового задания. Для этого скопировал базу, установил DBBrowser for SqlLite. Тестировал базу командой - PRAGMA integrity_check; тестирование вывело следующее: Данные теста *** in database main *** Main freelist: 216 of 6731961 pages missing from overflow list starting at 6505900 On tree page 34123146 cell 0: 2nd reference to page 6504963 On tree page 34123146 cell 100: 2nd reference to page 6504966 On tree page 34123146 cell 99: 2nd reference to page 6504970 On tree page 34123146 cell 98: 2nd reference to page 6504971 On tree page 34123146 cell 97: 2nd reference to page 5386472 On tree page 34123146 cell 96: 2nd reference to page 6504964 On tree page 34123146 cell 95: 2nd reference to page 6504950 On tree page 34123146 cell 94: 2nd reference to page 6504978 On tree page 34123146 cell 93: 2nd reference to page 6504983 On tree page 34123146 cell 92: 2nd reference to page 6504992 On tree page 34123146 cell 91: 2nd reference to page 6504995 On tree page 34123146 cell 90: 2nd reference to page 6504998 On tree page 34123146 cell 89: 2nd reference to page 6504999 On tree page 34123146 cell 88: 2nd reference to page 6505016 On tree page 34123146 cell 87: 2nd reference to page 6505006 On tree page 34123146 cell 86: 2nd reference to page 6505008 On tree page 34123146 cell 85: 2nd reference to page 3075903 On tree page 34123146 cell 84: 2nd reference to page 6505014 On tree page 34123146 cell 83: 2nd reference to page 6505018 On tree page 34123146 cell 82: 2nd reference to page 6505033 On tree page 34123146 cell 81: 2nd reference to page 6505017 On tree page 34123146 cell 80: 2nd reference to page 6505036 On tree page 34123146 cell 79: 2nd reference to page 6505027 On tree page 34123146 cell 78: 2nd reference to page 6505030 On tree page 34123146 cell 77: 2nd reference to page 6505035 On tree page 34123146 cell 76: 2nd reference to page 6505034 On tree page 34123146 cell 75: 2nd reference to page 6505040 On tree page 34123146 cell 74: 2nd reference to page 6504784 On tree page 34123146 cell 73: 2nd reference to page 6505038 On tree page 34123146 cell 72: 2nd reference to page 5386624 On tree page 34123146 cell 71: 2nd reference to page 6505058 On tree page 34123146 cell 70: 2nd reference to page 6505055 On tree page 34123146 cell 69: 2nd reference to page 6505059 On tree page 34123146 cell 68: 2nd reference to page 6505053 On tree page 34123146 cell 67: 2nd reference to page 6505067 On tree page 34123146 cell 66: 2nd reference to page 6505070 On tree page 34123146 cell 65: 2nd reference to page 6505081 On tree page 34123146 cell 64: 2nd reference to page 6505079 On tree page 34123146 cell 63: 2nd reference to page 6505083 On tree page 34123146 cell 62: 2nd reference to page 5386601 On tree page 34123146 cell 61: 2nd reference to page 6505090 On tree page 34123146 cell 60: 2nd reference to page 6505094 On tree page 34123146 cell 59: 2nd reference to page 5386649 On tree page 34123146 cell 58: 2nd reference to page 6505097 On tree page 34123146 cell 57: 2nd reference to page 6505100 On tree page 34123146 cell 56: 2nd reference to page 6505103 On tree page 34123146 cell 55: 2nd reference to page 6505107 On tree page 34123146 cell 54: 2nd reference to page 6505106 On tree page 34123146 cell 53: 2nd reference to page 6505126 On tree page 34123146 cell 52: 2nd reference to page 6505116 On tree page 34123146 cell 51: 2nd reference to page 6505117 On tree page 34123146 cell 50: 2nd reference to page 6505108 On tree page 34123146 cell 49: 2nd reference to page 6505124 On tree page 34123146 cell 48: 2nd reference to page 5386627 On tree page 34123146 cell 47: 2nd reference to page 6505132 On tree page 34123146 cell 46: 2nd reference to page 6505128 On tree page 34123146 cell 45: 2nd reference to page 6505150 On tree page 34123146 cell 44: 2nd reference to page 6505139 On tree page 34123146 cell 43: 2nd reference to page 6505142 On tree page 34123146 cell 42: 2nd reference to page 6505144 On tree page 34123146 cell 41: 2nd reference to page 6505138 On tree page 34123146 cell 40: 2nd reference to page 6505148 On tree page 34123146 cell 39: 2nd reference to page 6505167 On tree page 34123146 cell 38: 2nd reference to page 6505152 On tree page 34123146 cell 37: 2nd reference to page 6505157 On tree page 34123146 cell 36: 2nd reference to page 6505159 On tree page 34123146 cell 35: 2nd reference to page 6505163 On tree page 34123146 cell 34: 2nd reference to page 6505178 On tree page 34123146 cell 33: 2nd reference to page 6505168 On tree page 34123146 cell 32: 2nd reference to page 6505188 On tree page 34123146 cell 31: 2nd reference to page 6505171 On tree page 34123146 cell 30: 2nd reference to page 6505192 On tree page 34123146 cell 29: 2nd reference to page 6505180 On tree page 34123146 cell 28: 2nd reference to page 5386691 On tree page 34123146 cell 27: 2nd reference to page 6504990 On tree page 34123146 cell 26: 2nd reference to page 6505186 On tree page 34123146 cell 25: 2nd reference to page 6505191 On tree page 34123146 cell 24: 2nd reference to page 6505197 On tree page 34123146 cell 23: 2nd reference to page 6505196 On tree page 34123146 cell 22: 2nd reference to page 6505207 On tree page 34123146 cell 21: 2nd reference to page 6505202 On tree page 34123146 cell 20: 2nd reference to page 6505209 On tree page 34123146 cell 19: 2nd reference to page 6505226 On tree page 34123146 cell 18: 2nd reference to page 6505216 On tree page 34123146 cell 17: 2nd reference to page 6505208 On tree page 34123146 cell 16: 2nd reference to page 6505223 On tree page 34123146 cell 15: 2nd reference to page 6505229 On tree page 34123146 cell 14: 2nd reference to page 3714438 On tree page 34123146 cell 13: 2nd reference to page 6505247 On tree page 34123146 cell 12: 2nd reference to page 6505222 On tree page 34123146 cell 11: 2nd reference to page 6505241 On tree page 34123146 cell 10: 2nd reference to page 6505244 On tree page 34123146 cell 9: 2nd reference to page 6505249 On tree page 34123146 cell 8: 2nd reference to page 6505235 On tree page 34123146 cell 7: 2nd reference to page 6505266 On tree page 34123146 cell 6: 2nd reference to page 5386763 On tree page 34123146 cell 5: 2nd reference to page 6505257 On tree page 34123146 cell 4: 2nd reference to page 6505265 On tree page 34123146 cell 3: 2nd reference to page 6505283 При выполнении команды - delete from EventLog where (eventCode="BackgroundJob"); Выходит ошибка - database disk image is malformed: delete from EventLog where (eventCode="BackgroundJob"); Помогите решить данный вопрос. В скуле я не силен. Заранее благодарен! ... |
|||
:
Нравится:
Не нравится:
|
|||
10.07.2018, 13:39 |
|
Чистка логов 1С с помощью SQLLite
|
|||
---|---|---|---|
#18+
В гугле тоже не силен? Это почитай https://infostart.ru/public/402536/ ... |
|||
:
Нравится:
Не нравится:
|
|||
10.07.2018, 13:44 |
|
|
start [/forum/topic.php?fid=54&msg=39672057&tid=2008445]: |
0ms |
get settings: |
12ms |
get forum list: |
14ms |
check forum access: |
3ms |
check topic access: |
3ms |
track hit: |
69ms |
get topic data: |
14ms |
get forum data: |
3ms |
get page messages: |
50ms |
get tp. blocked users: |
1ms |
others: | 264ms |
total: | 433ms |
0 / 0 |