Severity 20 Error - Connection Pooling

Question

Severity 20 Error - Connection Pooling

Brandie Tarvin

SSC Guru

Points: 173108
More actions
February 15, 2011 at 7:53 am

#245479

I'm currently doing more research, but I received 4 severity 20 errors within seconds of each other yesterday on our report server. I can't seem to find anything on Google that has a consistent answer with the given error (too many different answers to make sense of). All 4 errors read like this (for 4 different SPIDs):
Error Text in Email Notification
DATE/TIME:2/5/2011 12:21:43 AM
DESCRIPTION:The client was unable to reuse a session with SPID 111, 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.
COMMENT:(None)
JOB RUN:(None)
I know for a fact that one query was running in SSMS against this server (I was running it). I don't know how many reports were running against the server at the time (I didn't think to check until it was too late to get an accurate read).
I'm not sure how to interpret this one. Other than "the SPIDs are dead, deal with it." Can someone give me some insight?
Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

Brandie Tarvin SSC Guru Points: 173108 More actions · Answer 1

Nothing in the logs happened right before these errors, except a few security audit failures in the Event Log. I've checked the SQL Server Log, SQL Agent Log, Application, Security and System logs. Everything I've found on Google seems related to something else, so I'm at a complete loss.

If anyone has ideas of other things I can check, I'd appreciate the input.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

mister.magoo SSC-Forever Points: 47174 More actions · Answer 2

Hi Brandie,

Was there a state code with that error ?

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

Brandie Tarvin SSC Guru Points: 173108 More actions · Answer 3

Nope. I can't even find these errors in the logs. It's like they happened, but didn't happen (according to the server logs). That's what's driving me nuts.

The earliest entry before my P.I.T. is 3 hours before, and it was informational only. Nothing after either.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.