Microsoft KB Archive/153079

= FIX: Unhandled Access Violation with Temporary Procedure =

Article ID: 153079

Article Last Modified on 11/14/2003

-

APPLIES TO


 * Microsoft SQL Server 4.21a Standard Edition
 * Microsoft SQL Server 6.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q153079





SYMPTOMS
When a temporary stored procedure is created and executed within a user- defined transaction and the client (DBLIB or ODBC) disconnects without either committing or rolling back the transaction, SQL Server stops running. The SQL Service manager shows a red light.

An attempt to kill the process that initiated the transaction also causes an Unhandled Access Violation error.



WORKAROUND
Use a permanent stored procedure instead of a temporary stored procedure within a transaction.

You can also commit or roll back the transaction before the client disconnects.



MORE INFORMATION
The SQL Server errorlog (under SQL..\LOG directory on the server) would look like:

Error : 631, Severity: 21, State: 1

spid12 The length of 116 passed to delete row routine for the row at

offset 32 is incorrect on the following page: Page pointer = 0xa8b000,

pageno = 104, status = 0x101, objectid = 6, indexid = 0

kernel WARNING: Process being freed while holding Dataserver semaphore

Error : 631, Severity: 21, State: 1

The length of 116 passed to delete row routine for the row at offset 32 is

incorrect on the following page: Page pointer = 0xa8b000, pageno = 104,

status = 0x101, objectid = 6, indexid = 0

kernel udread: Operating system error 6(The handle is invalid.) on device

'C:\SQL60\DATA\MASTER.DAT' (virtpage 0x000002fb).

Buffer 8d8700 from database 'master' has page number 0 in the page header

and page number 759 in the buffer header

Recursive error 822 in ex_print

kernel mirrorproc: i/o error on primary device 'C:\SQL60\DATA\MASTER.DAT'



STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. This problem has been corrected in U.S. Service Pack 1 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.

Additional query words: sp1

Keywords: kbbug kbfix kbnetwork KB153079

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.