数据库打补丁，服务升级失败

系统版本：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 ===

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

由于我登录系统用的是adminstrator。权限怎么会不够呢，想不通。

找到一篇文章说是sql write服务的问题，它上边列出的解决方法没看太懂。不过看线上系统的这个服务确实是没开启的，回去做个试验先试验下看看。

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