Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Cluster: Failover not happening Expand / Collapse
Author
Message
Posted Monday, August 23, 2004 2:12 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 9:34 PM
Points: 284, Visits: 265

Brief on the current environment:

SQL Server 2000 Enterprise Edition

Windows 2000 Enterprise Edition

Service Pack 3a and KB 859 - Prerequisite applied.

Active/ Passive cluster

Problem:

      Automatic failover is not happening.

Errors found on SQL Error Log:

Waiting for type 0x4, current count 0xa, current owning EC 0x43D37588.

Time out occurred while waiting for buffer latch type 4,bp 0x2d9c780, page 1:41), stat 0xb, object ID 2:2:0, EC 0x54DF3570 : 0, waittime 300. Not continuing to wait.

Errors on NT Event Viewer:

Event Id: 17052

[sqsrvres] checkODBCConnectError: sqlstate = 08001; native error = b; message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.

[sqsrvres] ODBC sqldriverconnect failed

[sqsrvres] checkODBCConnectError: sqlstate = 01000; native error = 274c; message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (PreLoginHandshake()).

[sqsrvres] ODBC sqldriverconnect failed

[sqsrvres] checkODBCConnectError: sqlstate = 08001; native error = b; message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.

[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed

 

Any help on cause of the problem and resolution will be apprieciated.

 



Sivaprasad S - [ SIVA ]http://sivasql.blogspot.com/
Post #133276
Posted Monday, August 23, 2004 7:09 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 7:59 AM
Points: 151, Visits: 115

Siva,

We had the similar problem sometime back. We couldn't find out what is causing this problem.  We applied Post W2K SP4 Cluster fixes and we believe it has fixed the problem. 

Gopal

Post #133306
Posted Monday, August 23, 2004 7:27 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 9:34 PM
Points: 284, Visits: 265

Gopal,

  Sorry, the box is running on Windows 2003 Enterprise Edition without any service packs.

 

 



Sivaprasad S - [ SIVA ]http://sivasql.blogspot.com/
Post #133309
Posted Thursday, September 30, 2004 4:30 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 30, 2004 4:24 AM
Points: 1, Visits: 1

Hi Sivaprasad,

I have the same problem with a SQL2000 Cluster in Windows 2003 Enterprise Edition.

Dou you know how to solve the problem?

Thank you.

Post #139414
Posted Friday, August 4, 2006 4:59 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, January 26, 2011 11:13 PM
Points: 34, Visits: 116
hi, i came across this posting and was wondering if anyone found out the resolution. i encountered the same problem today and came across this posting...from 2004.

i have an active\passive windows 20003 enterprise sp1, sql 2000 sp4 enterprise environmnet.

i'd appreciate any input.

thank you...



Post #299774
Posted Sunday, October 15, 2006 6:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, December 7, 2009 10:39 AM
Points: 2, Visits: 3

Hi,

 

I am having the same problem now, though in my case it occured after upgrade to Windows 2003 sp 1.

Uninstalling the SP resolved the issue, but we need to get sp 1 installed

Post #315492
Posted Sunday, October 15, 2006 6:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, December 7, 2009 10:39 AM
Points: 2, Visits: 3

Hi,

 

I am having the same problem now, though in my case it occured after upgrade to Windows 2003 sp 1.

Uninstalling the SP resolved the issue, but we need to get sp 1 installed

Post #315493
Posted Monday, November 14, 2011 2:47 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, November 11, 2012 12:47 PM
Points: 27, Visits: 329
Dear all,

I also came across the same issue,can any body has solution for this issue ?

OS Name: Microsoft(R) Windows(R) Server 2003, Enterprise Edition,
OS Version: 5.2.3790 Service Pack 2 Build 3790
with
SQL Server 2000 SP4



Thanks in advance
Post #1204974
Posted Monday, November 14, 2011 2:49 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, November 11, 2012 12:47 PM
Points: 27, Visits: 329
Dear all,

I also came across the same issue every month,

SQL Server 2000 SP4
with
OS Name: Microsoft(R) Windows(R) Server 2003, Enterprise Edition,
OS Version: 5.2.3790 Service Pack 2 Build 3790


Thanks in adavance
Post #1204976
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse