SQL Cluster: Failover not happening

  • sivaprasad

    SSCertifiable

    Points: 6183

    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 ][/url]http://sivasql.blogspot.com/[/url]

  • Gopal-122691

    SSC-Addicted

    Points: 497

    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

    SSCertifiable

    Points: 6183

    Gopal,

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

     

     

    Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]

  • josegarcia

    Valued Member

    Points: 69

    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

    SSChasing Mays

    Points: 644

    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

    Valued Member

    Points: 60

    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

    Valued Member

    Points: 60

    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

    Say Hey Kid

    Points: 713

    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

    Say Hey Kid

    Points: 713

    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

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply