Имя: Пароль:
1C
1С v8
Ошибка при обновление статистики через 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);
"

оно?