client was unable to reuse a session?

Question

Post reply

client was unable to reuse a session?

SQL Galaxy

One Orange Chip

Points: 29472
More actions
May 20, 2013 at 9:58 pm

#278092

Hi.
Error messages,
The client was unable to reuse a session with SPID 246, which had been reset for connection pooling. The failure ID is 29. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.
I have checked sp_who2 , it was showing more than 50 session not yet closed automatically also all the sessions are same select statement in particulare table..
How to close the existing connection?
1. I close the application but still apper all the session..
2. how to close connection instead of using KILL command?
3. restart service is not good method?
But I have done restart the sevice and all the connection was closed. could you suggestion me any alternative way for the same?
thanks
ananda

Viewing 8 posts - 1 through 7 (of 7 total)

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

raadee SSC Eights! Points: 871 More actions · Answer 1

There is info on connect about this issue.

http://connect.microsoft.com/SQLServer/feedback/details/468478/sql-server-2008-periodically-does-not-accept-connections

Problem solved in SQL 2008 SP2 CU1: http://support.microsoft.com/kb/2289254

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 2

In SQL SERVER 2008 R2 64 bit, I had installed SP2, Not for CU1..

should I download SP2 CU1 and apply that patch..?

thanks

ananda

raadee SSC Eights! Points: 871 More actions · Answer 3

Ok, check out this link:

http://support.microsoft.com/kb/2543687/EN-US

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 4

Thanks for reply.. could you pl.confirm which patch number should be download?

(http://support.microsoft.com/kb/2720425/ )

2720425

Cumulative Update package 1 for SQL Server 2008 R2 Service Pack 2

2703280

Cumulative Update package 14 for SQL Server 2008 R2

I thought patch number 2720425 need to be download for which already installed SP2 on SQL Server 2008 R2 64 bit...

raadee SSC Eights! Points: 871 More actions · Answer 5

You are correct 2720425 is for SQL 2008 R2 SP2, click on the resolution link in the article, there you have all the info about which patch for which edition and version.

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 6

Thanks for reply .. please confirm

I have download file name is : SQLServer2008R2-KB2720425-x86, it can apply for 32 bit not for 64 bit..

I could not able to download 64 bit patch from microsoft sites..

thanks

ananda

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 7

Hi,

Thanks for your help.. I had successfully updated CU1 on SQL2K8R2 64 bit.

File name downloaded: SQLServer2008R2-KB2720425-x64

Existing Version: SQL2K8R2 SP2 version - 10.50.4000

Current version: SQL2K8R2 SP2 CU1 version - 10.50.4260

I have noticed : during update patch at instance Database Mirror was disconnected with principal server after that mirror state is start automatically once patch was completed..

Thanks

ananda