Гость
Форумы / SQLite [игнор отключен] [закрыт для гостей] / Чистка логов 1С с помощью SQLLite / 3 сообщений из 3, страница 1 из 1
10.07.2018, 13:39
    #39672057
ANDiv123
Гость
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Чистка логов 1С с помощью SQLLite
Пытаюсь удалить из логов сервера 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");

Помогите решить данный вопрос. В скуле я не силен.
Заранее благодарен!
...
Рейтинг: 0 / 0
10.07.2018, 13:44
    #39672062
Dima T
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Чистка логов 1С с помощью SQLLite
В гугле тоже не силен? Это почитай https://infostart.ru/public/402536/
...
Рейтинг: 0 / 0
10.07.2018, 13:52
    #39672071
ANDiv123
Гость
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Чистка логов 1С с помощью SQLLite
гуглил. но как ни странно, данная статья не попадалась.
Благодарю.
Счас попробуем полечить
...
Рейтинг: 0 / 0
Форумы / SQLite [игнор отключен] [закрыт для гостей] / Чистка логов 1С с помощью SQLLite / 3 сообщений из 3, страница 1 из 1
Целевая тема:
Создать новую тему:
Автор:
Найденые пользователи ...
Разблокировать пользователей ...
Читали форум (0):
Пользователи онлайн (0):
x
x
Закрыть


Просмотр
0 / 0
Close
Debug Console [Select Text]