Windows 2003 server running SQL 2005
Failover does not work: not manually and probably also not by shutting down the active Node
I have looked at the cluster log, although there are errors i cannot figure out what's going on.
I have filtered all the lines that contain the word 'error': During this time i first tried a manual failover and then i shut down the active node.
17:27:25.187 WARN Network Name <Cluster Name>: Unable to read ResourceData parameter, error=2
17:27:25.187 WARN Network Name <Cluster Name>: Unable to read CreatingDC parameter, error=2
17:27:25.203 WARN Network Name <SQL Network Name(sqlcluster)>: Unable to read ResourceData parameter, error=2
17:27:25.203 WARN Network Name <SQL Network Name(sqlcluster)>: Unable to read CreatingDC parameter, error=2
17:27:25.281 WARN Network Name <VDISPATCH Network Name>: Unable to read ResourceData parameter, error=2
17:27:25.281 WARN Network Name <VDISPATCH Network Name>: Unable to read CreatingDC parameter, error=2
17:33:31.029 ERR Volume Manager Disk Group <quorum_sqlcluster>: LDM_RESArbitrateThread - *** ArbitrateDg API failed - resource is not available - error: Unknown disk group
17:36:12.562 WARN Network Name <VDISPATCH Network Name>: Unable to read ResourceData parameter, error=2
17:36:12.562 WARN Network Name <VDISPATCH Network Name>: Unable to read CreatingDC parameter, error=2
17:36:12.577 WARN Network Name <SQL Network Name(sqlcluster)>: Unable to read ResourceData parameter, error=2
17:36:12.577 WARN Network Name <SQL Network Name(sqlcluster)>: Unable to read CreatingDC parameter, error=2
17:36:43.401 ERR Volume Manager Disk Group <SQL Disk S:>: LDM_RESOnlineThread: *** Unable to bring resource online Error: Unknown disk group
17:36:43.401 ERR Volume Manager Disk Group <SQL Disk S:>: GetMountVolumeInfo Error: 1.
17:36:50.915 ERR Volume Manager Disk Group <quorum_sqlcluster>: Dg-Guid is Null000008b8.000008d4::2009/06/25-17:36:58.429 ERR Volume Manager Disk Group <SQL Disk S:>: LDM_RESDoTerminate: stop res failed, error. 0 1
17:37:01.519 ERR Volume Manager Disk Group <SQL Disk S:>: LDM_RESDoTerminate: vxio stop res, error. 24
17:37:01.519 ERR Volume Manager Disk Group <SQL Disk S:>: LDM_RESDoTerminate: *** Unable to terminate resource, error 24
17:37:13.490 ERR Volume Manager Disk Group <quorum_sqlcluster>: LDM_RESArbitrateThread - *** ArbitrateDg API failed - resource is not available - error: Unknown disk group
17:37:35.599 ERR Volume Manager Disk Group <SQL Disk S:>: LDM_RESOnlineThread: *** Unable to bring resource online Error: Unknown disk group
17:37:35.599 ERR Volume Manager Disk Group <SQL Disk S:>: GetMountVolumeInfo Error: 1.
17:37:43.161 ERR Volume Manager Disk Group <SQL Disk S:>: LDM_RESDoTerminate: stop res failed, error. 0 1
17:37:46.251 ERR Volume Manager Disk Group <SQL Disk S:>: LDM_RESDoTerminate: vxio stop res, error. 24
17:37:46.251 ERR Volume Manager Disk Group <SQL Disk S:>: LDM_RESDoTerminate: *** Unable to terminate resource, error 24
17:38:01.280 ERR Volume Manager Disk Group <SQL Disk S:>: LDM_RESOnlineThread: *** Unable to bring resource online Error: Unknown disk group
17:38:01.280 ERR Volume Manager Disk Group <SQL Disk S:>: GetMountVolumeInfo Error: 1.
17:38:08.810 ERR Volume Manager Disk Group <SQL Disk S:>: LDM_RESDoTerminate: stop res failed, error. 0 1
17:38:11.899 ERR Volume Manager Disk Group <SQL Disk S:>: LDM_RESDoTerminate: vxio stop res, error. 24
17:38:11.899 ERR Volume Manager Disk Group <SQL Disk S:>: LDM_RESDoTerminate: *** Unable to terminate resource, error 24
17:38:26.960 ERR Volume Manager Disk Group <SQL Disk S:>: LDM_RESOnlineThread: *** Unable to bring resource online Error: Unknown disk group
17:38:26.960 ERR Volume Manager Disk Group <SQL Disk S:>: GetMountVolumeInfo Error: 1.
17:38:34.491 ERR Volume Manager Disk Group <SQL Disk S:>: LDM_RESDoTerminate: stop res failed, error. 0 1
17:38:37.580 ERR Volume Manager Disk Group <SQL Disk S:>: LDM_RESDoTerminate: vxio stop res, error. 24
17:38:37.580 ERR Volume Manager Disk Group <SQL Disk S:>: LDM_RESDoTerminate: *** Unable to terminate resource, error 24
17:38:37.580 INFO [FM] FmpRmOfflineResource: RmOffline() for b803a691-6e9b-4901-b6c1-a83ae79870dd returned error 997
17:38:37.580 INFO [FM] FmpRmOfflineResource: RmOffline() for 0fdef525-a65b-4d3b-96ad-dfcfead832c8 returned error 997
17:42:01.990 ERR Volume Manager Disk Group <quorum_sqlcluster>: LDM_RESArbitrateThread - *** ArbitrateDg API failed - resource is not available - error: Unknown disk group
17:42:24.188 ERR Volume Manager Disk Group <quorum_sqlcluster>: LDM_RESArbitrateThread - *** ArbitrateDg API failed - resource is not available - error: Unknown disk group
17:42:24.188 ERR [FM] Failed to arbitrate quorum resource 3e2fae0c-5fa8-424f-b8b1-ab655da215ff, error 5006.
17:42:24.188 ERR [RGP] Node 1: REGROUP ERROR: arbitration failed.
17:42:24.188 ERR [NM] Halting this node due to membership or communications error. Halt code = 1000
17:42:24.204 ERR [CS] Halting this node to prevent an inconsistency within the cluster. Error status = 5892
17:43:59.593 ERR [FM] Failed to get quorum disk signature, error 2.
17:44:21.827 ERR Volume Manager Disk Group <quorum_sqlcluster>: LDM_RESArbitrateThread - *** ArbitrateDg API failed - resource is not available - error: Unknown disk group
17:44:21.827 ERR [FM] FmGetQuorumResource failed, error 5006.
17:46:27.135 WARN Network Name <Cluster Name>: Unable to read ResourceData parameter, error=2
17:46:27.135 WARN Network Name <Cluster Name>: Unable to read CreatingDC parameter, error=2
17:46:27.151 WARN Network Name <SQL Network Name(sqlcluster)>: Unable to read ResourceData parameter, error=2
17:46:27.151 WARN Network Name <SQL Network Name(sqlcluster)>: Unable to read CreatingDC parameter, error=2
17:46:27.214 WARN Network Name <VDISPATCH Network Name>: Unable to read ResourceData parameter, error=2
17:46:27.214 WARN Network Name <VDISPATCH Network Name>: Unable to read CreatingDC parameter, error=2
Hopefully someone has an idea what's going on.
Bookmarks