SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Cluster: Failover not happening


SQL Cluster: Failover not happening

Author
Message
sivaprasad
sivaprasad
Mr or Mrs. 500
Mr or Mrs. 500 (585 reputation)Mr or Mrs. 500 (585 reputation)Mr or Mrs. 500 (585 reputation)Mr or Mrs. 500 (585 reputation)Mr or Mrs. 500 (585 reputation)Mr or Mrs. 500 (585 reputation)Mr or Mrs. 500 (585 reputation)Mr or Mrs. 500 (585 reputation)

Group: General Forum Members
Points: 585 Visits: 269

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/
Gopal-122691
Gopal-122691
SSC-Enthusiastic
SSC-Enthusiastic (157 reputation)SSC-Enthusiastic (157 reputation)SSC-Enthusiastic (157 reputation)SSC-Enthusiastic (157 reputation)SSC-Enthusiastic (157 reputation)SSC-Enthusiastic (157 reputation)SSC-Enthusiastic (157 reputation)SSC-Enthusiastic (157 reputation)

Group: General Forum Members
Points: 157 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


sivaprasad
sivaprasad
Mr or Mrs. 500
Mr or Mrs. 500 (585 reputation)Mr or Mrs. 500 (585 reputation)Mr or Mrs. 500 (585 reputation)Mr or Mrs. 500 (585 reputation)Mr or Mrs. 500 (585 reputation)Mr or Mrs. 500 (585 reputation)Mr or Mrs. 500 (585 reputation)Mr or Mrs. 500 (585 reputation)

Group: General Forum Members
Points: 585 Visits: 269

Gopal,

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



Sivaprasad S - [ SIVA ]http://sivasql.blogspot.com/
josegarcia
josegarcia
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
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.


cspangler
cspangler
SSC Rookie
SSC Rookie (48 reputation)SSC Rookie (48 reputation)SSC Rookie (48 reputation)SSC Rookie (48 reputation)SSC Rookie (48 reputation)SSC Rookie (48 reputation)SSC Rookie (48 reputation)SSC Rookie (48 reputation)

Group: General Forum Members
Points: 48 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...



Rich Morrissey
Rich Morrissey
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 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


Rich Morrissey
Rich Morrissey
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 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


snivas
snivas
SSC Rookie
SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)

Group: General Forum Members
Points: 43 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
snivas
snivas
SSC Rookie
SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)

Group: General Forum Members
Points: 43 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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search