2008-09-16

SQL Server 2005: "Attempt to access expired blob handle"

FIX: Error message when you open a cursor for a very long cursor statement in SQL Server 2005: "Attempt to access expired blob handle"

SYMPTOMS
In Microsoft SQL Server 2005, you open a cursor for a very long cursor statement. For example, the cursor statement exceeds 65,536 bytes (64 kilobytes). When you perform an operation that clears the procedure cache, you may receive the following error message:
Msg 3624, Level 20, State 1, Line 2
A system assertion check has failed. Check the SQL Server error log for details. Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB. If you agreed to send dumps to Microsoft during setup, a mini dump will be sent to Microsoft. An update might be available from Microsoft in the latest Service Pack or in a QFE from Technical Support.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
Additionally, the following error message is logged in the SQL Server 2005 error log:
Date Time SPID * BEGIN STACK DUMP:
Date Time SPID * Date Time SPID
Date Time SPID *
Date Time SPID * Location: tmpilb.cpp:2628
Date Time SPID * Expression: fFalse
Date Time SPID * SPID: SPID
Date Time SPID * Process ID: ProcessID
Date Time SPID * Description: Attempt to access expired blob handle (3)
Date Time SPID *
Date Time SPID * Input Buffer 78 bytes -
Date Time SPID * dbcc freeproccache
This issue may occur if one of the following conditions is true:• You run the DBCC FREEPROCCACHE statement after you close the cursor.
• You run the DBCC FREEPROCCACHE statement, and then you close the cursor.
• You disconnect the connection without closing the cursor.

Microsoft SQL Server 2005 Standard Edition
Microsoft SQL Server 2005 Developer Edition
Microsoft SQL Server 2005 Enterprise Edition
Microsoft SQL Server 2005 Standard X64 Edition
Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems
Microsoft SQL Server 2005 Enterprise X64 Edition
Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
Microsoft SQL Server 2005 Workgroup Edition

http://support.microsoft.com/kb/955686

No comments: