Всем привет. Уже не знаю где и куда смотреть. В общем конфиг следующий. На двух серверах поднят виндовый кластер. Успешно установлен один инстанс SQL Serverа, на него успешно накатан SP3. Захотел установить еще один инстанс, ну чтобы сделать конфиг типа active/active. Ну и все приплыли.
1. Запускаю установку SQL сервера на вторй ноде, причем данный узел активен, т.е. держит инстан первого SQL в это время. (если запускать с пассивного узла, то там возникают ошибки дополнительные).
2. Установка успешно идет, SQL Database Services в каком то моменте выдает ошибку:
The setup has encountered an unexpected error while Completing Commit. The error is: The system cannot find the file specified.
ну и все, рою рою интернет, а победить никак не могу, пожалуйста подсажите, что делать???
вот выдержка из лога, сверху и снизу строк по 50 от ошибки:
MSI (s) (8C:84) [17:31:55:360]: Executing op: FeaturePublish(Feature=SQL_SharedTools,Parent=SQL_Engine,Absent=2,Component={9vumaoga8^PCFA]*oO?)
MSI (s) (8C:84) [17:31:55:366]: Executing op: FeaturePublish(Feature=SQL_BC_DEP,Parent=SQL_Engine,Absent=2,Component=SgCJ$(FSl@4)fXJ!N~JX)
MSI (s) (8C:84) [17:31:55:373]: Executing op: ActionStart(Name=PublishProduct,Description=Publishing product information,)
MSI (s) (8C:84) [17:31:55:374]: Executing op: IconCreate(Icon=ARPIcon.ico,Data=BinaryData)
MSI (s) (8C:84) [17:31:55:378]: Executing op: CleanupConfigData()
MSI (s) (8C:84) [17:31:55:378]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Products\DA6E6DADA20A78F469AA3087ED1DC95E\Patches 3: 2
MSI (s) (8C:84) [17:31:55:378]: Executing op: PatchRegister(PatchId={00D9590F-2FA2-47B5-ABED-22776D07EEAE},NewState=2,OldState=1,TransformList=:Target01ToUpgrade01;:#Target01ToUpgrade01,Uninstallable=0,LUAEnabled=0,PatchType=0,DisplayName=Hotfix 3024 for SQL Server Database Services 2005 (64-bit) ENU (KB000000),MoreInfoURL=Hotfix;000000;ENU;http://support.microsoft.com/?kbid=000000)
MSI (s) (8C:84) [17:31:55:409]: Executing op: SourceListPublish(PatchCode={00D9590F-2FA2-47B5-ABED-22776D07EEAE},PatchPackageName=SqlRun_SLP_SQL.msp,DiskPromptTemplate=Please insert next disk,,NumberOfDisks=1)
MSI (s) (8C:84) [17:31:55:409]: Note: 1: 1402 2: UNKNOWN\Installer\Patches\F0959D002AF25B74BADE2277D670EEEA\SourceList 3: 2
MSI (s) (8C:84) [17:31:55:425]: Executing op: PatchSourceListRegisterLastUsed(PatchCode={00D9590F-2FA2-47B5-ABED-22776D07EEAE},LastUsedSource=C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Patch\sql\)
MSI (s) (8C:84) [17:31:55:425]: Entering CMsiConfigurationManager::SetLastUsedSource.
MSI (s) (8C:84) [17:31:55:426]: Specifed source is already in a list.
MSI (s) (8C:84) [17:31:55:426]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (8C:84) [17:31:55:426]: Adding new sources is allowed.
MSI (s) (8C:84) [17:31:55:426]: Set LastUsedSource to: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Patch\sql\.
MSI (s) (8C:84) [17:31:55:426]: Set LastUsedType to: n.
MSI (s) (8C:84) [17:31:55:426]: Set LastUsedIndex to: 1.
MSI (s) (8C:84) [17:31:55:429]: Executing op: PatchCache(PatchId={00D9590F-2FA2-47B5-ABED-22776D07EEAE},PatchPath=C:\Windows\Installer\10d0aad.msp)
MSI (s) (8C:84) [17:31:55:430]: Note: 1: 1402 2: UNKNOWN\Patches\F0959D002AF25B74BADE2277D670EEEA 3: 2
MSI (s) (8C:84) [17:31:55:434]: File will have security applied from OpCode.
MSI (s) (8C:84) [17:31:55:441]: Executing op: RegisterPatchOrder(Continue=0,SequenceType=0,Remove=0)
MSI (s) (8C:84) [17:31:55:446]: Executing op: RegisterPatchOrder(Continue=0,SequenceType=1,Remove=0)
MSI (s) (8C:84) [17:31:55:450]: Executing op: ProductPublish(PackageKey={812CC946-7FD1-4D98-8395-1F4F82D38B0E})
MSI (s) (8C:84) [17:31:55:450]: Transforms are unknown secure.
MSI (s) (8C:84) [17:31:55:450]: Registering storage transform: :SqlRun02.mst
MSI (s) (8C:84) [17:31:55:450]: Transforms are unknown secure.
MSI (s) (8C:84) [17:31:55:450]: Registering storage transform: :InstID02.mst
MSI (s) (8C:84) [17:31:55:450]: Transforms are unknown secure.
MSI (s) (8C:84) [17:31:55:450]: Registering storage transform: :InstName02.mst
MSI (s) (8C:84) [17:31:55:484]: Executing op: UpgradeCodePublish(UpgradeCode={12EEFC9F-91FB-490B-B00B-7164C31C1650})
MSI (s) (8C:84) [17:31:55:486]: Executing op: SourceListPublish(,,DiskPromptTemplate=Please insert next disk,PackagePath=\Setup\,NumberOfDisks=2)
MSI (s) (8C:84) [17:31:55:487]: Note: 1: 1402 2: UNKNOWN\Installer\Products\DA6E6DADA20A78F469AA3087ED1DC95E\SourceList 3: 2
MSI (s) (8C:84) [17:31:55:513]: Executing op: ProductPublishClient(,,)
MSI (s) (8C:84) [17:31:55:517]: Executing op: SourceListRegisterLastUsed(SourceProduct={DAD6E6AD-A02A-4F87-96AA-0378DED19CE5},LastUsedSource=G:\sql_inst\Servers\Setup\)
MSI (s) (8C:84) [17:31:55:517]: Entering CMsiConfigurationManager::SetLastUsedSource.
MSI (s) (8C:84) [17:31:55:517]: Specifed source is already in a list.
MSI (s) (8C:84) [17:31:55:517]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (8C:84) [17:31:55:517]: Adding new sources is allowed.
MSI (s) (8C:84) [17:31:55:517]: Set LastUsedSource to: G:\sql_inst\Servers\Setup\.
MSI (s) (8C:84) [17:31:55:517]: Set LastUsedType to: n.
MSI (s) (8C:84) [17:31:55:517]: Set LastUsedIndex to: 1.
MSI (s) (8C:84) [17:31:55:520]: Executing op: ActionStart(Name=CreateShortcuts,Description=Creating shortcuts,Template=Shortcut: [1])
MSI (s) (8C:84) [17:31:55:522]: Executing op: SetTargetFolder(Folder=23\Microsoft SQL Server 2005\Configuration Tools\)
MSI (s) (8C:84) [17:31:55:529]: SHELL32::SHGetFolderPath returned: C:\ProgramData\Microsoft\Windows\Start Menu\Programs
MSI (s) (8C:84) [17:31:55:529]: Executing op: ShortcutCreate(Name=SqlSAC|SQL Server Surface Area Configuration,,,FileName=C:\Program Files (x86)\Microsoft SQL Server\90\Shared\SqlSAC.exe,,,,,,ShowCmd=1,,,,,)
MSI (s) (8C:84) [17:31:55:531]: Verifying accessibility of file: SQL Server Surface Area Configuration.lnk
MSI (s) (8C:84) [17:31:55:546]: Executing op: ShortcutCreate(Name=SqlWtsn|SQL Server Error and Usage Reporting,,,FileName=C:\Program Files\Microsoft SQL Server\90\Shared\SqlWtsn.exe,,,,,,ShowCmd=1,,,,,)
MSI (s) (8C:84) [17:31:55:550]: Verifying accessibility of file: SQL Server Error and Usage Reporting.lnk
MSI (s) (8C:84) [17:31:55:563]: Executing op: ShortcutCreate(Name=SqlConfM|SQL Server Configuration Manager,,,FileName=C:\Windows\SysWOW64\mmc.exe,Arguments=/32 "C:\Windows\SysWOW64\SQLServerManager.msc",,,,,ShowCmd=1,,,,,)
MSI (s) (8C:84) [17:31:55:565]: Verifying accessibility of file: SQL Server Configuration Manager.lnk
MSI (s) (8C:84) [17:31:55:578]: Executing op: ActionStart(Name=Set_CommitFlag.3EA9D9BF_D9D2_4023_B2A7_9E2137B2FB1B,Description=Completing Commit,)
MSI (s) (8C:84) [17:31:55:586]: Executing op: CustomActionSchedule(Action=Set_CommitFlag.3EA9D9BF_D9D2_4023_B2A7_9E2137B2FB1B,ActionType=1537,Source=BinaryData,Target=Set_CommitFlag,CustomActionData=010Completing Commit500001)
MSI (s) (8C:84) [17:31:55:622]: Executing op: ActionStart(Name=InstallFinalize,,)
MSI (s) (8C:84) [17:31:55:623]: Executing op: CleanupTempFiles(TempFiles=C:\Windows\Installer\10d0aad.msp)
MSI (s) (8C:84) [17:31:55:623]: Scheduling file 'C:\Windows\Installer\10d0aad.msp' for deletion during post-install cleanup (not post-reboot).
MSI (s) (8C:84) [17:31:55:627]: Executing op: End(Checksum=0,ProgressTotalHDWord=0,ProgressTotalLDWord=461233304)
MSI (s) (8C:84) [17:31:55:875]: User policy value 'DisableRollback' is 0
MSI (s) (8C:84) [17:31:55:875]: Machine policy value 'DisableRollback' is 0
MSI (s) (8C:18) [17:31:55:982]: Invoking remote custom action. DLL: C:\Windows\Installer\MSI788A.tmp, Entrypoint: Set_CommitFlag
<Func Name='LaunchFunction'>
Function=Set_CommitFlag
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Set_CommitFlag
PerfTime Start: Set_CommitFlag : Thu Jun 16 17:31:56 2011
<Func Name='Set_CommitFlag'>
MSI (s) (8C:30) [17:31:58:896]: I/O on thread 2196 could not be cancelled. Error: 1168
MSI (s) (8C:30) [17:31:58:896]: I/O on thread 5756 could not be cancelled. Error: 1168
MSI (s) (8C:30) [17:31:58:896]: I/O on thread 3864 could not be cancelled. Error: 1168
MSI (s) (8C:30) [17:31:58:896]: I/O on thread 1864 could not be cancelled. Error: 1168
MSI (s) (8C:30) [17:31:58:896]: I/O on thread 3344 could not be cancelled. Error: 1168
MSI (s) (8C:30) [17:31:58:896]: I/O on thread 3672 could not be cancelled. Error: 1168
MSI (s) (8C:30) [17:31:58:896]: I/O on thread 5856 could not be cancelled. Error: 1168
MSI (s) (8C:30) [17:31:58:896]: I/O on thread 4956 could not be cancelled. Error: 1168
MSI (s) (8C:30) [17:31:58:896]: I/O on thread 6124 could not be cancelled. Error: 1168
MSI (s) (8C:30) [17:31:58:896]: I/O on thread 4740 could not be cancelled. Error: 1168
MSI (s) (8C:30) [17:31:58:896]: I/O on thread 4580 could not be cancelled. Error: 1168
MSI (s) (8C:30) [17:31:58:896]: I/O on thread 4272 could not be cancelled. Error: 1168
MSI (s) (8C:30) [17:31:58:897]: I/O on thread 5204 could not be cancelled. Error: 1168
MSI (s) (8C:30) [17:31:58:897]: I/O on thread 3352 could not be cancelled. Error: 1168
Can I commit?
Error Code: 1603
MSI (s) (8C!24) [17:32:05:233]: Product: Microsoft SQL Server 2005 (64-bit) -- Error 29528. The setup has encountered an unexpected error while Completing Commit. The error is: The system cannot find the file specified.
Error 29528. The setup has encountered an unexpected error while Completing Commit. The error is: The system cannot find the file specified.
<EndFunc Name='LaunchFunction' Return='1603' GetLastError='203'>
CustomAction Set_CommitFlag.3EA9D9BF_D9D2_4023_B2A7_9E2137B2FB1B returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)
MSI (s) (8C:84) [17:32:05:303]: Executing op: Header(Signature=1397708873,Version=500,Timestamp=1053854690,LangId=1033,Platform=589824,ScriptType=2,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1)
MSI (s) (8C:84) [17:32:05:303]: Executing op: DialogInfo(Type=0,Argument=1033)
MSI (s) (8C:84) [17:32:05:304]: Executing op: DialogInfo(Type=1,Argument=Microsoft SQL Server 2005 (64-bit))
MSI (s) (8C:84) [17:32:05:304]: Executing op: RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Rolling back action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription=Removing backup files,CleanupTemplate=File: [1])
MSI (s) (8C:84) [17:32:05:304]: Executing op: RegisterBackupFile(File=C:\Config.Msi\10d0ab8.rbf)
MSI (s) (8C:84) [17:32:05:304]: Executing op: RegisterBackupFile(File=C:\Config.Msi\10d0ab9.rbf)
MSI (s) (8C:84) [17:32:05:304]: Executing op: RegisterBackupFile(File=C:\Config.Msi\10d0aba.rbf)
MSI (s) (8C:84) [17:32:05:304]: Executing op: RegisterBackupFile(File=C:\Config.Msi\10d0abb.rbf)
MSI (s) (8C:84) [17:32:05:304]: Executing op: RegisterBackupFile(File=C:\Config.Msi\10d0abc.rbf)
MSI (s) (8C:84) [17:32:05:304]: Executing op: RegisterBackupFile(File=C:\Config.Msi\10d0abd.rbf)
MSI (s) (8C:84) [17:32:05:304]: Executing op: RegisterBackupFile(File=C:\Config.Msi\10d0abe.rbf)
MSI (s) (8C:84) [17:32:05:304]: Executing op: RegisterBackupFile(File=C:\Config.Msi\10d0abf.rbf)
MSI (s) (8C:84) [17:32:05:304]: Executing op: RegisterBackupFile(File=C:\Config.Msi\10d0ac0.rbf)
MSI (s) (8C:84) [17:32:05:304]: Executing op: RegisterBackupFile(File=C:\Config.Msi\10d0ac1.rbf)
MSI (s) (8C:84) [17:32:05:304]: Executing op: RegisterBackupFile(File=C:\Config.Msi\10d0ac2.rbf)
MSI (s) (8C:84) [17:32:05:304]: Executing op: RegisterBackupFile(File=C:\Config.Msi\10d0ac3.rbf)
MSI (s) (8C:84) [17:32:05:304]: Executing op: RegisterBackupFile(File=C:\Config.Msi\10d0ac4.rbf)
MSI (s) (8C:84) [17:32:05:304]: Executing op: RegisterBackupFile(File=C:\Config.Msi\10d0ac5.rbf)
MSI (s) (8C:84) [17:32:05:304]: Executing op: RegisterBackupFile(File=C:\Config.Msi\10d0ac6.rbf)
MSI (s) (8C:84) [17:32:05:304]: Executing op: RegisterBackupFile(File=C:\Config.Msi\10d0ac7.rbf)
MSI (s) (8C:84) [17:32:05:304]: Executing op: RegisterBackupFile(File=C:\Config.Msi\10d0ac8.rbf)
MSI (s) (8C:84) [17:32:05:304]: Executing op: RegisterBackupFile(File=C:\Config.Msi\10d0ac9.rbf)
MSI (s) (8C:84) [17:32:05:304]: Executing op: RegisterBackupFile(File=C:\Config.Msi\10d0aca.rbf)
MSI (s) (8C:84) [17:32:05:304]: Executing op: RegisterBackupFile(File=C:\Config.Msi\10d0acb.rbf)
MSI (s) (8C:84) [17:32:05:304]: Executing op: RegisterBackupFile(File=C:\Config.Msi\10d0acc.rbf)
MSI (s) (8C:84) [17:32:05:304]: Executing op: RegisterBackupFile(File=C:\Config.Msi\10d0acd.rbf)
MSI (s) (8C:84) [17:32:05:304]: Executing op: RegisterBackupFile(File=C:\Config.Msi\10d0ace.rbf)
MSI (s) (8C:84) [17:32:05:304]: Executing op: RegisterBackupFile(File=C:\Config.Msi\10d0acf.rbf)
MSI (s) (8C:84) [17:32:05:305]: Executing op: RegisterBackupFile(File=C:\Config.Msi\10d0ad0.rbf)
MSI (s) (8C:84) [17:32:05:305]: Executing op: RegisterBackupFile(File=C:\Config.Msi\10d0ad1.rbf)
MSI (s) (8C:84) [17:32:05:305]: Executing op: RegisterBackupFile(File=C:\Config.Msi\10d0ad2.rbf)
MSI (s) (8C:84) [17:32:05:305]: Executing op: RegisterBackupFile(File=C:\Config.Msi\10d0ad3.rbf)
MSI (s) (8C:84) [17:32:05:305]: Executing op: RegisterBackupFile(File=C:\Config.Msi\10d0ad6.rbf)
MSI (s) (8C:84) [17:32:05:305]: Executing op: RegisterBackupFile(File=C:\Config.Msi\10d0ad7.rbf)
MSI (s) (8C:84) [17:32:05:305]: Executing op: RegisterBackupFile(File=C:\Config.Msi\10d0ad8.rbf)
MSI (s) (8C:84) [17:32:05:307]: Executing op: ActionStart(Name=InstallFinalize,,)
MSI (s) (8C:84) [17:32:05:307]: Executing op: RegOpenKey(Root=-2147483646,Key=Software\Microsoft\Windows\CurrentVersion\Installer\TempPackages,,BinaryType=1,,)
MSI (s) (8C:84) [17:32:05:307]: Executing op: ProductInfo(ProductKey={DAD6E6AD-A02A-4F87-96AA-0378DED19CE5},ProductName=Microsoft SQL Server 2005 (64-bit),PackageName=SqlRun_SQL.msi,Language=1033,Version=150996343,Assignment=1,ObsoleteArg=0,ProductIcon=ARPIcon.ico,PackageMediaPath=\Setup\,PackageCode={812CC946-7FD1-4D98-8395-1F4F82D38B0E},AppCompatDB=BinaryData,AppCompatID=BinaryData,InstanceType=1,LUASetting=0,RemoteURTInstalls=0,ProductDeploymentFlags=3)
MSI (s) (8C:84) [17:32:05:308]: Executing op: RegRemoveValue(Name=C:\Windows\Installer\10d0aad.msp,Value=#0,)
MSI (s) (8C:84) [17:32:05:309]: Executing op: RegRemoveKey()
MSI (s) (8C:84) [17:32:05:309]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\TempPackages 3: 2
MSI (s) (8C:84) [17:32:05:310]: Executing op: ActionStart(Name=Set_CommitFlag.3EA9D9BF_D9D2_4023_B2A7_9E2137B2FB1B,Description=Completing Commit,)
MSI (s) (8C:84) [17:32:05:311]: Executing op: ActionStart(Name=CreateShortcuts,Description=Creating shortcuts,Template=Shortcut: [1])
MSI (s) (8C:84) [17:32:05:311]: Executing op: SetTargetFolder(Folder=23\Microsoft SQL Server 2005\Configuration Tools\)
MSI (s) (8C:84) [17:32:05:317]: SHELL32::SHGetFolderPath returned: C:\ProgramData\Microsoft\Windows\Start Menu\Programs
MSI (s) (8C:84) [17:32:05:318]: Executing op: FileCopy(SourceName=C:\Config.Msi\10d0ad8.rbf,,DestName=C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 2005\Configuration Tools\SQL Server Configuration Manager.lnk,Attributes=32800,FileSize=856,PerTick=0,,VerifyMedia=0,ElevateFlags=3,,,,,,,InstallMode=4194308,,,,,,,)
MSI (s) (8C:84) [17:32:05:320]: File: C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 2005\Configuration Tools\SQL Server Configuration Manager.lnk; Overwrite; Won't patch; REINSTALLMODE specifies all files to be overwritten
MSI (s) (8C:84) [17:32:05:322]: Note: 1: 2318 2:
MSI (s) (8C:84) [17:32:05:331]: Note: 1: 2318 2:
MSI (s) (8C:84) [17:32:05:332]: Executing op: FileCopy(SourceName=C:\Config.Msi\10d0ad7.rbf,,DestName=C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 2005\Configuration Tools\SQL Server Error and Usage Reporting.lnk,Attributes=32800,FileSize=1096,PerTick=0,,VerifyMedia=0,ElevateFlags=3,,,,,,,InstallMode=4194308,,,,,,,)
MSI (s) (8C:84) [17:32:05:333]: File: C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 2005\Configuration Tools\SQL Server Error and Usage Reporting.lnk; Overwrite; Won't patch; REINSTALLMODE specifies all files to be overwritten
MSI (s) (8C:84) [17:32:05:335]: Note: 1: 2318 2:
MSI (s) (8C:84) [17:32:05:344]: Note: 1: 2318 2:
MSI (s) (8C:84) [17:32:05:344]: Executing op: FileCopy(SourceName=C:\Config.Msi\10d0ad6.rbf,,DestName=C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 2005\Configuration Tools\SQL Server Surface Area Configuration.lnk,Attributes=32800,FileSize=1121,PerTick=0,,VerifyMedia=0,ElevateFlags=3,,,,,,,InstallMode=4194308,,,,,,,)
MSI (s) (8C:84) [17:32:05:346]: File: C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 2005\Configuration Tools\SQL Server Surface Area Configuration.lnk; Overwrite; Won't patch; REINSTALLMODE specifies all files to be overwritten
Господа так-то я уже почти в отчаянии :( Конфиг:
Windows Enterprise 64bit R2 2008
SQL Server 2005 Standart