FIX: Use of 25 Different Tables in a Query May Raise Error 1203

View products that this article applies to.

This article was previously published under Q238356

BUG #: 55738 (SQLBUG_70)

Expand all | Collapse all

SYMPTOMS

Executing a query that uses at least 25 different tables (for example, a UNION of 25 distinct tables) may fail and return the following errors to the client and then terminate the session:

Server: Msg 1203, Level 20, State 1, Line 1
Process ID x attempting to unlock unowned resource

The SQL Server process is terminated and the last entry found in the error log is the following stack dump:

0x0058f98f Module(sqlservr+18f98f) (ex_raise2+35c)
0x0044f41f Module(sqlservr+4f41f) (ex_raise+5f)
0x006c7972 Module(sqlservr+2c7972) (reportUnlockFailure+8f)
0x0057f85f Module(sqlservr+17f85f) (lck_unlock+d5)
0x00403660 Module(sqlservr+3660) (endscan+68)
0x00403436 Module(sqlservr+3436) (closetable+e8)
0x0058c8ab Module(sqlservr+18c8ab) (clean_process+f5)
0x0058c11f Module(sqlservr+18c11f) (language_exec+5f9)
0x4106187f Module(opends60+187f) (execute_event+659)
0x41061b5d Module(opends60+1b5d) (process_commands+f3)
0x41092be1 Module(ums+2be1) (ProcessWorkRequests+ed)
0x4109336a Module(ums+336a) (ThreadStartRoutine+139)
0x7800c0d7 Module(MSVCRT+c0d7) (beginthread+ce)
0x77f04f3e Module(KERNEL32+4f3e) (BaseThreadStart+45)

Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

254561 (http://support.microsoft.com/kb/254561/ ) INF: How to Obtain Service Pack 2 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0

For more information, contact your primary support provider.