![]() |
![]() |
![]() |
|
Ошибка при обновление статистики через MSSQL | ☑ | ||
---|---|---|---|---|
0
HouK
28.12.22
✎
00:24
|
Добрый день, после обновления платформы 1с, стала возникать ошибка обновления статистики в плане обслуживания mssql
Ниже сообщение MSSQL сервера в логах. Message Executed as user: NT Service\SQLSERVERAGENT. ...00.8 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 23:56:19 Progress: 2022-12-27 23:56:19.99 Source: {03A30EBD-4266-4753-9225-22AF9865473E} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Progress: 2022-12-27 23:56:20.23 Source: Check Database Integrity Task Executing query "USE [base1c] ".: 50% complete End Progress Progress: 2022-12-27 23:57:32.31 Source: Check Database Integrity Task Executing query "DBCC CHECKDB(N'base1c') WITH NO_INFOMSGS ".: 100% complete End Progress Progress: 2022-12-27 23:57:32.34 Source: Maintenance Cleanup Task Executing query "EXECUTE master.dbo.xp_delete_file 0,N'G:\....',...".: 100% complete End Progress Progress: 2022-12-27 23:57:32.38 Source: Back Up Database Task Executing query "EXECUTE master.dbo.xp_create_subdir N'G:\...\U...".: 100% complete End Progress Progress: 2022-12-27 23:58:53.30 Source: Back Up Database Task Executing query "BACKUP DATABASE [base1c] TO DISK = N'G:\...\base1c\...".: 50% complete End Progress Progress: 2022-12-28 00:00:04.97 Source: Back Up Database Task Executing query "declare @backupSetId as int select @backupSetId =...".: 100% complete End Progress Progress: 2022-12-28 00:00:57.22 Source: Update Statistics Task Executing query "use [base1c] ".: 0% complete End Progress Progress: 2022-12-28 00:00:57.35 Source: Update Statistics Task Executing query "UPDATE STATISTICS [dbo].[_Acc28] WITH FULLSCAN ".: 0% complete End Progress Progress: 2022-12-28 00:00:57.35 Source: Update Statistics Task Executing query "use [base1c] ".: 0% complete End Progress Progress: 2022-12-28 00:00:57.41 Source: Update Statistics Task Executing query "UPDATE STATISTICS [dbo].[_Acc28_ExtDim788] WITH ...".: 0% complete End Progress Progress: 2022-12-28 00:00:57.41 Source: Update Statistics Task Executing query "use [base1c] ".: 0% complete End Progress Progress: 2022-12-28 00:00:57.43 Source: Update Statistics Task Executing query "UPDATE STATISTICS [dbo].[_AccChngR794] WITH FULL...".: 0% complete End Progress Progress: 2022-12-28 00:00:57.43 Source: Update Statistics Task Executing query "use [base1c] ".: 0% complete End Progress Progress: 2022-12-28 00:00:57.44 Source: Update Statistics Task Executing query "UPDATE STATISTICS [dbo].[_AccOpt] WITH FULLSCAN ...".: 0% complete End Progress Progress: 2022-12-28 00:00:57.44 Source: Update Statistics Task Executing query "use [base1c] ".: 0% complete End Progress Progress: 2022-12-28 00:00:57.56 Source: Update Statistics Task Executing query "UPDATE STATISTICS [dbo].[_AccRg795] WITH FULLSCA...".: 0% complete End Progress Progress: 2022-12-28 00:00:57.56 Source: Update Statistics Task Executing query "use [base1c] ".: 0% complete End Progress Progress: 2022-12-28 00:00:57.57 Source: Update Statistics Task Executing query "UPDATE STATISTICS [dbo].[_AccRgAT0809] WITH FULL...".: 0% complete End Progress Progress: 2022-12-28 00:00:57.57 Source: Update Statistics Task Executing query "use [base1c] ".: 0% complete End Progress Progress: 2022-12-28 00:00:57.58 Source: Update Statistics Task Executing query "UPDATE STATISTICS [dbo].[_AccRgAT1828] WITH FULL...".: 0% complete End Progress Progress: 2022-12-28 00:00:57.58 Source: Update Statistics Task Executing query "use [base1c] ".: 0% complete End Progress Progress: 2022-12-28 00:00:57.59 Source: Update Statistics Task Executing query "UPDATE STATISTICS [dbo].[_AccRgAT2829] WITH FULL...".: 0% complete End Progress Progress: 2022-12-28 00:00:57.59 Source: Update Statistics Task Executing query "use [base1c] ".: 0% complete End Progress Progress: 2022-12-2... The package execution fa... The step failed. |
|||
1
mistеr
28.12.22
✎
09:02
|
Ошибки то нет...
Может, задача не уложилась в отведенное время |
|||
2
shuhard
28.12.22
✎
10:25
|
(0)[после обновления платформы 1с] какой
[Ниже сообщение MSSQL] SP какие стоят, компрессия включена ? |
|||
3
PLUT
гуру
28.12.22
✎
10:48
|
(0) это не баг, а фича?
было уже на форуме... https://its.1c.ru/db/metod8dev/content/5837/hdoc цЫтата: "Важно! Начиная с версии платформы 8.3.22 необходимо выполнять дефрагментацию индексов по следующему алгоритму: До дефрагментации индекса необходимо включить страничные блокировки. Пример команды: ALTER INDEX index_name ON table_name SET (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON); Выполнить дефрагментацию. Обратно выключить страничные блокировки. Пример команды: ALTER INDEX index_name ON table_name SET (ALLOW_PAGE_LOCKS = OFF, ALLOW_ROW_LOCKS = ON); " оно? |
Форум | Правила | Описание | Объявления | Секции | Поиск | Книга знаний | Вики-миста |