Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Microsoft SQL Server Новый топик    Ответить
 Ошибка при обновлении SQL 2014  [new]
virtuOS
Member

Откуда: большая деревня
Сообщений: 266
На сервере включено AlwaysOn. При обновлении вторичной ноды сообшение об ошибке:
автор
Ошибка установки Экземпляры служб компонента SQL Server Database Engine
Ошибка при ожидании дескриптора восстановления компонента Database Engine. Возможные причины см. в журнале ошибок SQL Server.
Код ошибки: 0x851A001A


В логе следующее:

+
2015-01-27 21:42:11.03 spid10s     Starting up database 'model'.
2015-01-27 21:42:11.06 spid10s     Clearing tempdb database.
2015-01-27 21:42:11.06 spid7s      0 transactions rolled back in database 'CRM_ACRHIVE_Y2009' (8:0). This is an informational message only. No user action is required.
2015-01-27 21:42:11.09 spid20s     1 transactions rolled forward in database 'msdb' (4:0). This is an informational message only. No user action is required.
2015-01-27 21:42:11.14 spid10s     Starting up database 'tempdb'.
2015-01-27 21:42:11.17 spid7s      0 transactions rolled back in database 'msdb' (4:0). This is an informational message only. No user action is required.
2015-01-27 21:42:11.32 spid25s     6 transactions rolled forward in database 'CRM_ACRHIVE_Y2013' (12:0). This is an informational message only. No user action is required.
2015-01-27 21:42:11.37 spid25s     0 transactions rolled back in database 'CRM_ACRHIVE_Y2013' (12:0). This is an informational message only. No user action is required.
2015-01-27 21:42:12.23 spid7s      Database 'master' is upgrading script 'SSIS_hotfix_install.sql' from level 201329022 to level 201329048.
2015-01-27 21:42:12.38 spid7s      Error: 945, Severity: 14, State: 2.
2015-01-27 21:42:12.38 spid7s      Database 'SSISDB' cannot be opened due to inaccessible files or insufficient memory or disk space.  See the SQL Server errorlog for details.
2015-01-27 21:42:12.38 spid7s      The failed batch of t-sql statements :
 /*
**  SSIS_hotfix_install.SQL
**  Patch install script for the SSIS server catalog (SSISDB).
*/

PRINT '------------------------------------------------------'
PRINT 'Starting execution of SSIS_HOTFIX_INSTALL.SQL         '
PRINT '------------------------------------------------------'

DECLARE @run_script BIT
SET @run_script=1

DECLARE @ssis_database_name SYSNAME
SET @ssis_database_name = N'SSISDB'

-- Check whether SSISDB exists
IF(DB_ID(@ssis_database_name) IS NULL)
BEGIN
    SET @run_script=0
    PRINT 'Database SSISDB does not exist in current SQL Server instance'
END

-- Check whether SSISDB is online
IF @run_script <> 0
BEGIN
	DECLARE @state_online SYSNAME
	SET @state_online = 'ONLINE'
	SELECT @state_online = UPPER(@state_online COLLATE SQL_Latin1_General_CP1_CI_AS)

	IF NOT EXISTS (SELECT state_desc FROM master.sys.databases WHERE name = @ssis_database_name AND
										 UPPER(state_desc COLLATE SQL_Latin1_General_CP1_CI_AS) LIKE @state_online)
	BEGIN
		SET @run_script=0    
		PRINT 'WARNING! The database SSISDB is not ONLINE. SSIS_HOTFIX_INSTALL.SQL will not be applied. Please run the script manually after the upgrade.'
	END
END

-- Check whether SSISDB is corrupted
IF @run_script <> 0
BEGIN
	IF OBJECT_ID (N'SSISDB.internal.catalog_properties', N'U') IS NULL
	BEGIN
		SET @run_script=0
		PRINT 'Database SSISDB is missing the catalog properties table. The database may be corrupted, or it is not an SSIS Catalog.'
	END
END

IF  @run_script = 0
BEGIN
	PRINT 'Database SSISDB was not patched.'
END
ELSE
BEGIN
	PRINT 'Start applying SSIS_HOTFIX_INSTALL changes.'

	DECLARE @rawCmd NVARCHAR(MAX), @cmd NVARCHAR(MAX)

	DECLARE @targetVersion NVARCHAR(256)
	SELECT @targetVersion = CONVERT(NVARCHAR,SERVERPROPERTY(N'ProductVersion'))

	--Version handler for PCU1
	--1. drop the old SP
	IF OBJECT_ID (N'SSISDB.[catalog].[create_execution]', N'P') IS NOT NULL
	BEGIN
		SET @rawCmd = N'DROP PROCEDURE [catalog].[create...
2015-01-27 21:42:12.38 spid7s      Error: 912, Severity: 21, State: 2.
2015-01-27 21:42:12.38 spid7s      Script level upgrade for database 'master' failed because upgrade step 'SSIS_hotfix_install.sql' encountered error 945, state 2, severity 25. This is a serious error condition which might interfere with regular operation and the database will be taken offline. If the error happened during upgrade of the 'master' database, it will prevent the entire SQL Server instance from starting. Examine the previous errorlog entries for errors, take the appropriate corrective actions and re-start the database so that the script upgrade steps run to completion.
2015-01-27 21:42:12.38 spid7s      Error: 3417, Severity: 21, State: 3.
2015-01-27 21:42:12.38 spid7s      Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. For more information about how to rebuild the master database, see SQL Server Books Online.
2015-01-27 21:42:12.38 spid7s      SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
27 янв 15, 21:56    [17179488]     Ответить | Цитировать Сообщить модератору
 Re: Ошибка при обновлении SQL 2014  [new]
virtuOS
Member

Откуда: большая деревня
Сообщений: 266
Помогло решение отсюда. Осталось понять, почему AlwaysOn так плохо реагирует на каталог SSIS в группе доступности.
28 янв 15, 09:55    [17180788]     Ответить | Цитировать Сообщить модератору
Все форумы / Microsoft SQL Server Ответить