none
数据库补丁由sp2升级到sp4,服务升级失败 RRS feed

  • 问题

  • 系统版本:windows 2003企业版

    数据库版本:SQLSERVER2005 ent



    场景:线上数据库最近发现不时的报错:

    SQL Server 断言: 文件: <lckmgr.cpp>,行=10850 失败的断言 = 'GetLocalLockPartition () == xactLockInfo->GetLocalLockPartition ()'。此错误可能与时间有关。如果重新运行该语句后错误仍然存在,请使用 DBCC CHECKDB 来检查数据库的结构是否完整,或重新启动服务器以确保内存中的数据结构未破坏。

    查资料发现由于是补丁问题,sp2上需要打一个更新补丁。

    由于记得线上此数据库是打过sp4补丁的,当时挺纳闷的。最终经查看,数据库补丁号仍然是3042.于是决定重新打补丁。



    打补丁的过程中,服务升级失败,其它都成功了。

    summary.txt

    ----------------------------------------------------------------------------------

    Product : 数据库服务 (MSSQLSERVER)
    Product Version (Previous): 3042
    Product Version (Final) : 
    Status : 失败
    Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB2463332_sqlrun_sql.msp.log
    Error Number : 29538
    Error Description : MSP Error: 29538 SQL Server 安装程序没有重命名文件 c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mssqlsystemresource1.ldf 所需的管理员权限。若要继续,请确保文件存在,并授予当前运行安装程序的帐户管理员权限或使用管理员帐户登录,然后再次运行 SQL Server 安装程序。

    ---------------------------------------------------------------------------------------

    HotFix:

    06/08/2013 03:09:44.156 Copy Engine: Creating MSP install log file at: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB2463332_sqlrun_sql.msp.log
    06/08/2013 03:09:44.171 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
    06/08/2013 03:09:44.171 Registry: Cannot read registry key value "Debug", error 0
    06/08/2013 03:11:08.937 MSP Error: 29538 SQL Server 安装程序没有重命名文件 c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mssqlsystemresource1.ldf 所需的管理员权限。若要继续,请确保文件存在,并授予当前运行安装程序的帐户管理员权限或使用管理员帐户登录,然后再次运行 SQL Server 安装程序。
    06/08/2013 03:11:49.171 MSP returned 1603: 安装过程中出现严重错误。
    06/08/2013 03:11:49.171 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
    06/08/2013 03:11:49.171 Registry: Cannot read registry key value "Debug", error 0
    06/08/2013 03:11:50.000 Copy Engine: Error, unable to install MSP file: c:\7b4a4a6552f466813c45a048\HotFixSQL\Files\sqlrun_sql.msp
    06/08/2013 03:11:50.062 The following exception occurred: 无法安装 Windows Installer MSP 文件 Date: 06/08/2013 03:11:50.000 File: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\copyengine.cpp Line: 807
    06/08/2013 03:11:50.546 Watson: Param1 = Do_sqlFileRename
    06/08/2013 03:11:50.546 Watson: Param2 = 0x7362
    06/08/2013 03:11:50.546 Watson: Param3 = Do_sqlFileRename
    06/08/2013 03:11:50.546 Watson: Param4 = 0x7362
    06/08/2013 03:11:50.546 Watson: Param5 = sqlca\sqlfilerename.cpp@142

    -------------------------------------------------------------------------------------

    SQL9_Hotfix_KB2463332_sqlrun_sql.msp.log

    Property(S): SQL200564Hotfix5000 = c:\7b4a4a6552f466813c45a048\HotFixSQL\Files\sqlrun_sql.msp
    MSI (s) (74:D8) [03:11:49:062]: 产品: Microsoft SQL Server 2005 (64 位) - 无法安装更新 'SQL Server Database Services 2005 (64 位) Service Pack 4 CHS (KB2463332)'。错误码 1603。可以在日志文件 C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB2463332_sqlrun_sql.msp.log 中找到其他信息。

    MSI (s) (74:D8) [03:11:49:062]: Note: 1: 1729 
    MSI (s) (74:D8) [03:11:49:062]: Transforming table Error.

    MSI (s) (74:D8) [03:11:49:062]: Note: 1: 2262 2: Error 3: -2147287038 
    MSI (s) (74:D8) [03:11:49:078]: Transforming table Error.

    MSI (s) (74:D8) [03:11:49:078]: Transforming table Error.

    MSI (s) (74:D8) [03:11:49:078]: Note: 1: 2262 2: Error 3: -2147287038 
    MSI (s) (74:D8) [03:11:49:078]: Transforming table Error.

    MSI (s) (74:D8) [03:11:49:078]: Note: 1: 2262 2: Error 3: -2147287038 
    MSI (s) (74:D8) [03:11:49:078]: Transforming table Error.

    MSI (s) (74:D8) [03:11:49:078]: Note: 1: 2262 2: Error 3: -2147287038 
    MSI (s) (74:D8) [03:11:49:078]: Transforming table Error.

    MSI (s) (74:D8) [03:11:49:078]: Note: 1: 2262 2: Error 3: -2147287038 
    MSI (s) (74:D8) [03:11:49:093]: Transforming table Error.

    MSI (s) (74:D8) [03:11:49:093]: Transforming table Error.

    MSI (s) (74:D8) [03:11:49:093]: Note: 1: 2262 2: Error 3: -2147287038 
    MSI (s) (74:D8) [03:11:49:093]: Transforming table Error.

    MSI (s) (74:D8) [03:11:49:093]: Note: 1: 2262 2: Error 3: -2147287038 
    MSI (s) (74:D8) [03:11:49:093]: Transforming table Error.

    MSI (s) (74:D8) [03:11:49:093]: Note: 1: 2262 2: Error 3: -2147287038 
    MSI (s) (74:D8) [03:11:49:093]: 产品: Microsoft SQL Server 2005 (64 位) -- 配置失败。

    MSI (s) (74:D8) [03:11:49:093]: Attempting to delete file c:\WINDOWS\Installer\344bc1.msp
    MSI (s) (74:D8) [03:11:49:093]: Unable to delete the file. LastError = 32
    MSI (s) (74:D8) [03:11:49:109]: Cleaning up uninstalled install packages, if any exist
    MSI (s) (74:D8) [03:11:49:109]: MainEngineThread is returning 1603
    MSI (s) (74:5C) [03:11:49:109]: Destroying RemoteAPI object.
    MSI (s) (74:98) [03:11:49:109]: Custom Action Manager thread ending.
    === 记录停止: 2013-6-8 3:11:49 ===
    MSI (c) (DC:7C) [03:11:49:156]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
    MSI (c) (DC:7C) [03:11:49:156]: MainEngineThread is returning 1603
    === Verbose logging stopped: 2013-6-8 3:11:49 ===
    用的是administrator登录的,怎么会权限不够呢。

     -----------------------------------------------------------------------------------------------

    用的是administrator登录的,怎么会权限不够呢。

    找到一篇文章说是sql write服务的问题,它上边列出的解决方法没看太懂。不过看线上系统的这个服务确实是没开启的,回去做个试验没打补丁前,sql vss write也是没有启用的,开始打补丁也成功了。

    请教各位有没有具体的解决方法?

    现在服务器上的resource文件有两个,一个是mssqlsystemresource1,一个是mssqlsystemresource。

    http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/4e3ecb75-592e-4c29-8707-8997704c8e1b

      
    2013年6月18日 7:08

答案