Node failure can't install sql on new node. -
12-02-2007
, 09:26 PM
Hi,
I know this is a generic error and there is alot of info but i can't seem to
find this error anywhere. (Please look at the bottom of the sqlstp.log)
We had a blue screen on node 1 and we evicted the old node then joined a new
node to the cluster. During this procedure we dropped node 2 and bought node
1 online to add the disks. When i went onto Disk manager i was only able to
add the quarom disk without initializing it.
If i click initialize will this wipe the disks?
When we bring the cluster up it seems happy with what it can see. (Obviously
we can't fail over to SQL until we get it installed.)
I don't know if this is what is stopping the install but SQL doesn't get to
write anything other than the sqlstp.log file.
Anyone have any ideas?
Much appreciated in advance.
Dave
08:20:31 Begin Setup
08:20:31 8.00.194
08:20:31 Mode = Normal
08:20:31 ModeType = NORMAL
08:20:31 GetDefinitionEx returned: 0, Extended: 0x0
08:20:31 ValueFTS returned: 1
08:20:31 ValuePID returned: 1
08:20:31 ValueLic returned: 1
08:20:31 System: Windows NT Enterprise Server
08:20:31 SQL Server ProductType: Enterprise Edition [0x3]
08:20:31 IsNTCluster returned: 1
08:20:31 Begin Action: SetupInitialize
08:20:31 End Action SetupInitialize
08:20:31 Begin Action: SetupInstall
08:20:31 Reading Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir ...
08:20:31 CommonFilesDir=C:\Program Files\Common Files
08:20:31 Windows Directory=C:\Documents and Settings\Sqladmin\WINDOWS\
08:20:31 Program Files=C:\Program Files\
08:20:31 TEMPDIR=C:\DOCUME~1\Sqladmin\LOCALS~1\Temp\
08:20:31 Begin Action: SetupInstall
08:20:31 digpid size : 256
08:20:31 digpid size : 164
08:20:31 Begin Action: CheckFixedRequirements
08:20:31 Platform ID: 0xf00000
08:20:31 Version: 5.2.3790
08:20:31 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.3790.403
08:20:31 End Action: CheckFixedRequirements
08:20:33 Begin Action: ShowDialogs
08:20:33 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
08:20:33 Begin Action ShowDialogsHlpr: 0x1
08:20:33 Begin Action: DialogShowSdWelcome
08:20:37 End Action DialogShowSdWelcome
08:20:37 Dialog 0x1 returned: 1
08:20:37 End Action ShowDialogsHlpr
08:20:37 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
08:20:37 Begin Action ShowDialogsHlpr: 0x2
08:20:37 Begin Action: DialogShowSdMachineName
08:20:52 ShowDlgMachine returned: 1
08:20:52 Name = VSCDA, Type = 0x20000008
08:20:52 GetCDKeyForThisVS returned: 0
08:20:52 Begin Action: CheckRequirements
08:20:52 Processor Architecture: x86 (Pentium)
08:20:52 ComputerName: SN2-DA
08:20:52 User Name: sqladmin
08:20:52 IsAllAccessAllowed returned: 1
08:20:52 OS Language: 0xc09
08:20:52 End Action CheckRequirements
08:20:52 This combination of Package and Operating System allows a full
product install.
08:20:53 End Action DialogShowSdMachineName
08:20:53 begin ShowDialogsUpdateMask
08:20:53 nFullMask = 0x183000f7, nCurrent = 0x2, nDirection = 0
08:20:53 Updated Dialog Mask: 0xb73c037, Disable Back = 0x1
08:20:53 Dialog 0x2 returned: 0
08:20:53 End Action ShowDialogsHlpr
08:20:53 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
08:20:53 Begin Action ShowDialogsHlpr: 0x4
08:20:53 Begin Action: DialogShowSdInstallMode
08:20:59 ShowDlgInstallMode returned: 1
08:20:59 InstallMode : 0x20
08:20:59 End Action DialogShowSdInstallMode
08:20:59 begin ShowDialogsUpdateMask
08:20:59 nFullMask = 0xb73c037, nCurrent = 0x4, nDirection = 1
08:20:59 Updated Dialog Mask: 0xb73c03f, Disable Back = 0x1
08:20:59 Dialog 0x4 returned: 1
08:20:59 End Action ShowDialogsHlpr
08:20:59 ShowDialogsGetDialog returned: nCurrent=0x8,index=3
08:20:59 Begin Action ShowDialogsHlpr: 0x8
08:20:59 Begin Action : DialogShowSdAdvanced
08:21:07 ShowDlgAdvanced returned: 1
08:21:07 Adv Install Mode = -2147483648
08:21:07 End Action : DialogShowSdAdvanced
08:21:07 begin ShowDialogsUpdateMask
08:21:07 nFullMask = 0xb73c03f, nCurrent = 0x8, nDirection = 1
08:21:07 Updated Dialog Mask: 0x3c00f, Disable Back = 0x1
08:21:07 Dialog 0x8 returned: 1
08:21:07 End Action ShowDialogsHlpr
08:21:07 ShowDialogsGetDialog returned: nCurrent=0x4000,index=14
08:21:07 Begin Action ShowDialogsHlpr: 0x4000
08:21:07 Begin Action: DialogShowSdVirtualServer
08:21:13 ShowDlgVirtualServer returned: 0
08:21:13 Ipaddress = 192.168.2.241,255.255.255.0,G.P Network Public (Cluster
Comms)
08:21:13 szNewList =
08:21:13 szModifiedList =
08:21:13 szRemovedList =
08:21:13 End Action DialogShowSdVirtualServer
08:21:13 begin ShowDialogsUpdateMask
08:21:13 nFullMask = 0x3c00f, nCurrent = 0x4000, nDirection = 1
08:21:13 Updated Dialog Mask: 0x3c00f, Disable Back = 0x1
08:21:13 Dialog 0x4000 returned: 1
08:21:13 End Action ShowDialogsHlpr
08:21:13 ShowDialogsGetDialog returned: nCurrent=0x8000,index=15
08:21:13 Begin Action ShowDialogsHlpr: 0x8000
08:21:13 Begin Action : DialogShowSdDiskGroups
08:21:15 ShowDlgDiskGroups returned: 1
08:21:15 Disk Group = SQL Group
08:21:15 End Action : DialogShowSdDiskGroups
08:21:15 begin ShowDialogsUpdateMask
08:21:15 nFullMask = 0x3c00f, nCurrent = 0x8000, nDirection = 1
08:21:15 Updated Dialog Mask: 0x3c00f, Disable Back = 0x1
08:21:15 Dialog 0x8000 returned: 1
08:21:15 End Action ShowDialogsHlpr
08:21:15 ShowDialogsGetDialog returned: nCurrent=0x10000,index=16
08:21:15 Begin Action ShowDialogsHlpr: 0x10000
08:21:15 Begin Action: DialogShowSdClusterDef
08:21:18 ShowDlgClusterDef returned: 12
08:21:18 PrefOwners = , NumIp = 0
08:21:18 End Action DialogShowSdClusterDef
08:21:18 begin ShowDialogsUpdateMask
08:21:18 nFullMask = 0x3c00f, nCurrent = 0x10000, nDirection = 12
08:21:18 Updated Dialog Mask: 0x3400f, Disable Back = 0x1
08:21:18 Dialog 0x10000 returned: 12
08:21:18 End Action ShowDialogsHlpr
08:21:18 ShowDialogsGetDialog returned: nCurrent=0x4000,index=14
08:21:18 Begin Action ShowDialogsHlpr: 0x4000
08:21:18 Begin Action: DialogShowSdVirtualServer
08:21:34 ShowDlgVirtualServer returned: 0
08:21:34 Ipaddress = 192.168.2.241,255.255.255.0,G.P Network Public (Cluster
Comms)
08:21:34 szNewList =
08:21:34 szModifiedList =
08:21:34 szRemovedList =
08:21:34 End Action DialogShowSdVirtualServer
08:21:34 begin ShowDialogsUpdateMask
08:21:34 nFullMask = 0x3400f, nCurrent = 0x4000, nDirection = 1
08:21:34 Updated Dialog Mask: 0x3c00f, Disable Back = 0x1
08:21:34 Dialog 0x4000 returned: 1
08:21:34 End Action ShowDialogsHlpr
08:21:34 ShowDialogsGetDialog returned: nCurrent=0x8000,index=15
08:21:34 Begin Action ShowDialogsHlpr: 0x8000
08:21:34 Begin Action : DialogShowSdDiskGroups
08:21:35 ShowDlgDiskGroups returned: 1
08:21:35 Disk Group = SQL Group
08:21:35 End Action : DialogShowSdDiskGroups
08:21:35 begin ShowDialogsUpdateMask
08:21:35 nFullMask = 0x3c00f, nCurrent = 0x8000, nDirection = 1
08:21:35 Updated Dialog Mask: 0x3c00f, Disable Back = 0x1
08:21:35 Dialog 0x8000 returned: 1
08:21:35 End Action ShowDialogsHlpr
08:21:35 ShowDialogsGetDialog returned: nCurrent=0x10000,index=16
08:21:35 Begin Action ShowDialogsHlpr: 0x10000
08:21:35 Begin Action: DialogShowSdClusterDef
08:21:42 ShowDlgClusterDef returned: 1
08:21:42 PrefOwners = SN2-DA,SN1-DA, NumIp = 2
08:21:42 Begin Action : ValidateNodeActions
08:21:42 Begin Action : EnumerateInstancesForVirtualServer
08:21:42 End Action : EnumerateInstancesForVirtualServer
08:21:42 Begin Action : ValidateNodeActions
08:21:44 End Action : ValidateNodeActions
08:21:44 End Action : ValidateNodeActions
08:21:44 End Action DialogShowSdClusterDef
08:21:44 begin ShowDialogsUpdateMask
08:21:44 nFullMask = 0x3c00f, nCurrent = 0x10000, nDirection = 1
08:21:44 Updated Dialog Mask: 0x104fc00f, Disable Back = 0x1
08:21:44 Dialog 0x10000 returned: 1
08:21:44 End Action ShowDialogsHlpr
08:21:44 ShowDialogsGetDialog returned: nCurrent=0x20000,index=17
08:21:44 Begin Action ShowDialogsHlpr: 0x20000
08:21:44 Begin Action : Cluster Security - DlgAcct
08:22:03 ShowDlgAcct returned: 1
08:22:03 [DlgAccount]
08:22:03 Domain = GPNW
08:22:03 DomainAcct = gpcluster
08:22:03 DomainPwd
08:22:03 Result = 1
08:22:03 End Action : Cluster Security - DlgAcct
08:22:03 begin ShowDialogsUpdateMask
08:22:03 nFullMask = 0x104fc00f, nCurrent = 0x20000, nDirection = 1
08:22:03 Updated Dialog Mask: 0x104fc00f, Disable Back = 0x1
08:22:03 Dialog 0x20000 returned: 1
08:22:03 End Action ShowDialogsHlpr
08:22:03 ShowDialogsGetDialog returned: nCurrent=0x40000,index=18
08:22:03 Begin Action ShowDialogsHlpr: 0x40000
08:22:03 Begin Action: DialogShowSdCliSvr
08:22:03 DisplaySystemPreReq
08:22:03 ShowDlgClientServerSelect returned: 1
08:22:03 Type : 0x2
08:22:03 End Action DialogShowSdCliSvr
08:22:03 begin ShowDialogsUpdateMask
08:22:03 nFullMask = 0x104fc00f, nCurrent = 0x40000, nDirection = 1
08:22:03 Updated Dialog Mask: 0x105fc00f, Disable Back = 0x1
08:22:03 Dialog 0x40000 returned: 1
08:22:03 End Action ShowDialogsHlpr
08:22:03 ShowDialogsGetDialog returned: nCurrent=0x80000,index=19
08:22:03 Begin Action ShowDialogsHlpr: 0x80000
08:22:03 Begin Action: DialogShowSdInstanceName
08:22:03 Begin Action: Enumerate Instances for Virtual Server
08:22:03 End Action: Enumerate Instances for Virtual Server
08:22:03 Begin Action: Set Maintenance Mode Information
08:22:03 CreateSetupTopology(VSCDA), Handle : 0x11f4dd0, returned : 0
08:22:03 CreateSetupTopology returned : 0, Handle : 0x11f4dd0
08:22:03 Topology Type : 1, Return Value : 0
08:22:03 ST_GetPhysicalNode returned : 0, PNHandle : 0x11f44c8
08:22:03 PN_EnumerateEx returned : 0
08:22:03 PN_GetSQLStates returned : 0, SqlStates : 0xc0200801
08:22:03 PN_GetInstance for MSSQLSERVER [0x11f44c8] returned : 0
08:22:03 SQLI_GetSQLStates for MSSQLSERVER [0x11f4ec0] returned : 0,
SQLStates: 0x200809
08:22:03 SQLI_GetInstallPath [0x11f4ec0] returned : 0, Path = C:\Program
Files\Microsoft SQL Server\MSSQL
08:22:03 SQLI_GetDataPath [0x11f4ec0] returned : 0, DataPath = M:\Program
Files\Microsoft SQL Server\MSSQL
08:22:03 SQLI_GetVersion [0x11f4ec0] returned : 0, Version = 8.00.194
08:22:03 SQLI_GetRegKeyRoot [0x11f4ec0] returned : 0, RegKeyRoot =
Software\Microsoft\MSSQLServer
08:22:03 SQLI_GetPackageName [0x11f4ec0] returned : 0, szPackage =
Enterprise Edition
08:22:03 SQLI_GetPackageId [0x11f4ec0] returned : 0, PackageId = 0x3
08:22:03 Previous Install Path: C:\Program Files\Microsoft SQL Server\MSSQL
08:22:03 Previous Install Data: M:\Program Files\Microsoft SQL Server\MSSQL
08:22:03 Previous Install Version: 8.00.194
08:22:03 ReleaseSetupTopology
08:22:03 End Action: Set Maintenance Mode Information
08:22:03 ShowDlgInstanceName returned : 1
08:22:03 InstanceName : MSSQLSERVER
08:22:04 CreateSetupTopology(VSCDA), Handle : 0x11f4dd0, returned : 0
08:22:04 CreateSetupTopology returned : 0, Handle : 0x11f4dd0
08:22:04 Topology Type : 1, Return Value : 0
08:22:04 ST_GetPhysicalNode returned : 0, PNHandle : 0x11f44c8
08:22:04 PN_EnumerateEx returned : 0
08:22:04 PN_GetSQLStates returned : 0, SqlStates : 0xc0200801
08:22:04 PN_StartScan [0x11f44c8] returned : 0
08:22:04 PN_GetNext [0x11f44c8] returned : 0, Handle: [0x11f4ec0]
08:22:04 SQLI_GetSQLStates [0x11f4ec0] returned : 0, SQLStates: 0x200809
08:22:04 PN_GetNext [0x11f44c8] returned : 18, Handle: [0x0]
08:22:04 ReleaseSetupTopology
08:22:04 End Action DialogShowSdInstanceName
08:22:04 begin ShowDialogsUpdateMask
08:22:04 nFullMask = 0x105fc00f, nCurrent = 0x80000, nDirection = 1
08:22:04 Updated Dialog Mask: 0x105fc00f, Disable Back = 0x1
08:22:04 Dialog 0x80000 returned: 1
08:22:04 End Action ShowDialogsHlpr
08:22:04 ShowDialogsGetDialog returned: nCurrent=0x100000,index=20
08:22:04 Begin Action ShowDialogsHlpr: 0x100000
08:22:04 Begin Action: DialogShowSdSetupType
08:22:04 Begin Action: Setup Type
08:22:04 [SetupTypeSQL]
08:22:04 szDir = C:\Program Files\Microsoft SQL Server
08:22:04 szDir = C:\Program Files\Microsoft SQL Server
08:22:04 Result = 1
08:22:04 szDataDir = M:\Program Files\Microsoft SQL Server
08:22:04 szDataDir = M:\Program Files\Microsoft SQL Server
08:22:04 End Action: Setup Type
08:22:04 Setup Type: Typical (301)
08:22:04 End Action DialogShowSdSetupType
08:22:04 begin ShowDialogsUpdateMask
08:22:04 nFullMask = 0x105fc00f, nCurrent = 0x100000, nDirection = 301
08:22:04 Updated Dialog Mask: 0x105fc00f, Disable Back = 0x1
08:22:04 Dialog 0x100000 returned: 301
08:22:04 End Action ShowDialogsHlpr
08:22:04 ShowDialogsGetDialog returned: nCurrent=0x400000,index=22
08:22:04 Begin Action ShowDialogsHlpr: 0x400000
08:22:04 Begin Action: DlgServices
08:22:19 ShowDlgServices returned: 1
08:22:19 [DlgServices]
08:22:19 Local-Domain = 61680
08:22:19 AutoStart = 0
08:22:19 SQLDomain = GPNW
08:22:19 SQLDomainAcct = Sqladmin
08:22:19 SQLDomainPwd
08:22:19 AgtDomain = GPNW
08:22:19 AgtDomainAcct = Sqladmin
08:22:19 AgtDomainPwd
08:22:19 Result = 1
08:22:19 End Action DlgServices
08:22:19 begin ShowDialogsUpdateMask
08:22:19 nFullMask = 0x105fc00f, nCurrent = 0x400000, nDirection = 1
08:22:19 Updated Dialog Mask: 0x105fc00f, Disable Back = 0x1
08:22:19 Dialog 0x400000 returned: 1
08:22:19 End Action ShowDialogsHlpr
08:22:19 ShowDialogsGetDialog returned: nCurrent=0x10000000,index=28
08:22:19 Begin Action ShowDialogsHlpr: 0x10000000
08:22:19 Begin Action: DialogShowSdLicenseMode
08:22:19 ShowDlgLicense returned: 1
08:22:19 ShowDlgLicense returned: LicenseMode = 0, LicenseLimit = 150
08:22:19 End Action DialogShowSdLicenseMode
08:22:19 Dialog 0x10000000 returned: 1
08:22:19 End Action ShowDialogsHlpr
08:22:19 ShowDialogsGetDialog returned: nCurrent=0x0,index=0
08:22:19 End Action ShowDialogs
08:22:19 Setup is installing Microsoft Distributed Transaction Coordinator
(MSDTC) ...
08:22:19 C:\DOCUME~1\Sqladmin\LOCALS~1\Temp\SqlSetup\Bin\cl dtcstp.exe
-SupportDir "C:\DOCUME~1\Sqladmin\LOCALS~1\Temp\SqlSetup\B in" -DTCPkg
"D:\x86\Other\dtcsetup.exe" -LogFile "C:\Documents and
Settings\Sqladmin\WINDOWS\sqlstp.log" -CtxAcct "GPNW\gpcluster" -CtxEPwd
08:22:22 Process Exit Code: (0)
08:22:22 Begin Action : ClusterSetupHelper
08:22:22 Begin Action : CreateClustISSFiles
08:22:22 End Action : CreateClustISSFiles
08:22:22 Begin Action : ClusterWriteRemIni
08:22:22 CreateSetupTopology(VSCDA), Handle : 0x11f4dd0, returned : 0
08:22:22 CreateSetupTopology returned : 0, Handle : 0x11f4dd0
08:22:22 Topology Type : 1, Return Value : 0
08:22:22 ST_GetPhysicalNode returned : 0, PNHandle : 0x11f44c8
08:22:22 PN_EnumerateEx returned : 0
08:22:22 PN_GetSQLStates returned : 0, SqlStates : 0xc0200801
08:22:22 PN_GetInstance for MSSQLSERVER [0x11f44c8] returned : 0
08:22:22 SQLI_GetSQLStates for MSSQLSERVER [0x11f4ec0] returned : 0,
SQLStates: 0x200809
08:22:22 SQLI_GetInstallPath [0x11f4ec0] returned : 0, Path = C:\Program
Files\Microsoft SQL Server\MSSQL
08:22:22 SQLI_GetDataPath [0x11f4ec0] returned : 0, DataPath = M:\Program
Files\Microsoft SQL Server\MSSQL
08:22:22 SQLI_GetVersion [0x11f4ec0] returned : 0, Version = 8.00.194
08:22:22 SQLI_GetRegKeyRoot [0x11f4ec0] returned : 0, RegKeyRoot =
Software\Microsoft\MSSQLServer
08:22:22 SQLI_GetPackageName [0x11f4ec0] returned : 0, szPackage =
Enterprise Edition
08:22:22 SQLI_GetPackageId [0x11f4ec0] returned : 0, PackageId = 0x3
08:22:22 Previous Install Path: C:\Program Files\Microsoft SQL Server\MSSQL
08:22:22 Previous Install Data: M:\Program Files\Microsoft SQL Server\MSSQL
08:22:22 Previous Install Version: 8.00.194
08:22:22 ReleaseSetupTopology
08:22:23 End Action : ClusterWriteRemIni
08:22:23 Begin Action : Run setup on cluster nodes
[args]
NumRemoteServers=1
Server.1=SN1-DA
[Server.1]
NumRemoteServices=1
1.app=\\SN2-DA\D$\x86\setup\setupsql.exe
1.server=SN1-DA
1.script=\\SN2-DA\admin$\SN1-DA_MSSQLSERVER.iss
1.cmdlineformat=%s k=ClSec k=Rm k=Cl -SMS -s -f
"\\SN2-DA\D$\x86\setup\setup.ins" -f1 %s -f2 "\\SN1-DA\admin$\setup.log" -e
"stpsilnt._ex" -x "C:\Documents and Settings\Sqladmin\"
1.user=GPNW\gpcluster
1.password=074c8e9bb207c73d
1.name=SQLSetup1
1.sqlsetup=Y
1.copyexe=cnvsvc1.exe
08:22:23 Setup is performing required operations on cluster nodes. This may
take a few minutes...
08:22:23 C:\DOCUME~1\Sqladmin\LOCALS~1\Temp\SqlSetup\Bin\re msetup.exe
C:\Documents and Settings\Sqladmin\WINDOWS\remsetup.ini
08:22:24 Process Exit Code: (-1)
08:22:24 Begin Action : GetRemsetupRetCode
08:22:24 Installation return status on SN1-DA : -1
08:22:24 End Action : GetRemsetupRetCode
08:22:24 End Action : Run setup on cluster nodes
08:22:24 One or more errors occurred while running remote setup on the
clustered machines.
08:22:39 Setup failed to perform required operations on the cluster nodes.
08:22:39 Begin Action : ClusterErrorCleanup
08:22:39 End Action : ClusterErrorCleanup
08:22:39 End Action : ClusterSetupHelper |