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 Server restarts automatically Expand / Collapse
Author
Message
Posted Tuesday, April 6, 2010 4:18 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, May 31, 2010 1:05 PM
Points: 44, Visits: 245
Hi,

One of the servers gets restarted automatically. I found the below error message in error log

"The client was unable to reuse a session with SPID XX, which had been reset for connection pooling. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message."

I also see lots and lots of login failures after which the server restart. Any idea why this happens? Its a SQL Server 2008 box and has 16 CPU's with 32 GB of RAM. AWE is enabled

Any help is appreciated...



Post #897990
Posted Tuesday, April 6, 2010 4:22 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 17, 2014 4:56 AM
Points: 1,002, Visits: 884
karthik -450760 (4/6/2010)
Hi,

One of the servers gets restarted automatically. I found the below error message in error log

"The client was unable to reuse a session with SPID XX, which had been reset for connection pooling. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message."

I also see lots and lots of login failures after which the server restart. Any idea why this happens? Its a SQL Server 2008 box and has 16 CPU's with 32 GB of RAM. AWE is enabled

Any help is appreciated...





Question: Is it a 32 or 64 bit version of SQL. If it's 64, AWE is ignored. A 64 bit OS and SQL can natively address a larger memory space.

Login failures are common during startup, if the default database for the user is not ready to accept connection, the account will fail to login. You will probably notice that the login failures stop after the database has completed recovery.


/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

Post #897992
Posted Tuesday, April 6, 2010 4:24 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, May 31, 2010 1:05 PM
Points: 44, Visits: 245
thanks for the reply... Its a 32 Bit.. and the login failures happens after the database is restored.. Application users complain that their job gets disconnected in b/w and all i can see are login failures... Any ideas on the connection pooling error?
Post #897994
Posted Tuesday, April 6, 2010 4:26 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 17, 2014 4:56 AM
Points: 1,002, Visits: 884
Why does the server get restarted automatically?

/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

Post #897996
Posted Tuesday, April 6, 2010 4:54 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, November 24, 2014 3:46 AM
Points: 709, Visits: 1,442
What do the windows logs say? Are there any logs around the times before the server shuts down that can shed any light as to why the server could be rebooting?

Joie Andrew
"Since 1982"
Post #898010
Posted Tuesday, April 6, 2010 5:07 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 6:23 AM
Points: 9,928, Visits: 11,196
All these messages are perfectly normal, and just reflect the fact that the database is being recovered and brought online.



Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #898014
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse