The information in this article applies to:
BUG #: 18354 (SQLBUG_65) SYMPTOMS
A stored procedure may enter a loop with deadlock handling routines, and
may cause a stack overflow unhandled exception error if both of the
following conditions are true:
WORKAROUND
To work around this problem, do either of the following:
STATUSMicrosoft has confirmed this to be a problem in SQL Server
version 6.5. This problem has been corrected in U.S. Service Pack 5a
for Microsoft SQL Server version 6.5. For information about
downloading and installing the latest SQL Server Service Pack, see
http://support.microsoft.com/support/sql/.
MORE INFORMATION
If you have not enabled trace flags 1204 and 3605, all you will see in the
error log is an "EXCEPTION_STACK_OVERFLOW" message (an example of this
error message is provided at the end of this article). There may be no
indication of deadlocking unless the client application raises an error to
the user.
If the checkpoint process starts, you may encounter error 602:
Another message encountered during testing the scenario for this bug was:
The following is a sample of the errors in a customer's error log after experiencing this problem (with trace flags 1204 and 3605 switched on): 98/08/20 16:58:17.54 spid39 *** DEADLOCK DETECTED with spid 67 *** spid 39 requesting UP_PAGE (waittype 0x8007), blocked by: EX_PAGE: spid 67, dbid 2, page 0x13d, table 0x3, indid 0 pcurcmd DEALLOCATE CURSOR(0x2c), input buffer: EA_MOM_TotalPremie_SP spid 67 waiting for EX_PAGE (waittype 0x8005), blocked by: EX_PAGE: spid 39, dbid 2, page 0x1a, table sysindexes, indid 0 pcurcmd CREATE TABLE(0xc6), input buffer: EA_MOM_TotalPremie_SP VICTIM: spid 39, pstat 0x0080 , cputime 82014 98/08/20 16:58:17.54 spid39 *** DEADLOCK DETECTED with spid 67 *** spid 39 requesting UP_PAGE (waittype 0x8007), blocked by: EX_PAGE: spid 67, dbid 2, page 0x13d, table 0x3, indid 0 pcurcmd DEALLOCATE CURSOR(0x2c), input buffer: EA_MOM_TotalPremie_SP spid 67 waiting for EX_PAGE (waittype 0x8005), blocked by: EX_PAGE: spid 39, dbid 2, page 0x1a, table sysindexes, indid 0 pcurcmd CREATE TABLE(0xc6), input buffer: EA_MOM_TotalPremie_SP VICTIM: spid 39, pstat 0x0080 , cputime 82014 98/08/20 16:58:17.54 spid39 *** DEADLOCK DETECTED with spid 67 *** spid 39 requesting UP_PAGE (waittype 0x8007), blocked by: EX_PAGE: spid 67, dbid 2, page 0x13d, table 0x3, indid 0 pcurcmd DEALLOCATE CURSOR(0x2c), input buffer: EA_MOM_TotalPremie_SP spid 67 waiting for EX_PAGE (waittype 0x8005), blocked by: EX_PAGE: spid 39, dbid 2, page 0x1a, table sysindexes, indid 0 pcurcmd CREATE TABLE(0xc6), input buffer: EA_MOM_TotalPremie_SP VICTIM: spid 39, pstat 0x0080 , cputime 82014 98/08/20 16:58:17.54 spid39 *** DEADLOCK DETECTED with spid 67 *** spid 39 requesting UP_PAGE (waittype 0x8007), blocked by: EX_PAGE: spid 67, dbid 2, page 0x13d, table 0x3, indid 0 pcurcmd DEALLOCATE CURSOR(0x2c), input buffer: EA_MOM_TotalPremie_SP spid 67 waiting for EX_PAGE (waittype 0x8005), blocked by: EX_PAGE: spid 39, dbid 2, page 0x1a, table sysindexes, indid 0 pcurcmd CREATE TABLE(0xc6), input buffer: EA_MOM_TotalPremie_SP VICTIM: spid 39, pstat 0x0080 , cputime 82014 98/08/20 16:58:17.54 spid39 *** DEADLOCK DETECTED with spid 67 *** spid 39 requesting UP_PAGE (waittype 0x8007), blocked by: EX_PAGE: spid 67, dbid 2, page 0x13d, table 0x3, indid 0 pcurcmd DEALLOCATE CURSOR(0x2c), input buffer: EA_MOM_TotalPremie_SP spid 67 waiting for EX_PAGE (waittype 0x8005), blocked by: EX_PAGE: spid 39, dbid 2, page 0x1a, table sysindexes, indid 0 pcurcmd CREATE TABLE(0xc6), input buffer: EA_MOM_TotalPremie_SP VICTIM: spid 39, pstat 0x0080 , cputime 82014 98/08/20 16:58:17.54 spid39 *** DEADLOCK DETECTED with spid 67 *** spid 39 requesting UP_PAGE (waittype 0x8007), blocked by: EX_PAGE: spid 67, dbid 2, page 0x13d, table 0x3, indid 0 pcurcmd DEALLOCATE CURSOR(0x2c), input buffer: EA_MOM_TotalPremie_SP spid 67 waiting for EX_PAGE (waittype 0x8005), blocked by: EX_PAGE: spid 39, dbid 2, page 0x1a, table sysindexes, indid 0 pcurcmd CREATE TABLE(0xc6), input buffer: EA_MOM_TotalPremie_SP VICTIM: spid 39, pstat 0x0080 , cputime 82029 98/08/20 16:58:17.54 spid39 *** DEADLOCK DETECTED with spid 67 *** spid 39 requesting UP_PAGE (waittype 0x8007), blocked by: EX_PAGE: spid 67, dbid 2, page 0x13d, table 0x3, indid 0 pcurcmd DEALLOCATE CURSOR(0x2c), input buffer: EA_MOM_TotalPremie_SP spid 67 waiting for EX_PAGE (waittype 0x8005), blocked by: EX_PAGE: spid 39, dbid 2, page 0x1a, table sysindexes, indid 0 pcurcmd CREATE TABLE(0xc6), input buffer: EA_MOM_TotalPremie_SP VICTIM: spid 39, pstat 0x0080 , cputime 82029 98/08/20 16:58:17.54 spid39 *** DEADLOCK DETECTED with spid 67 *** spid 39 requesting UP_PAGE (waittype 0x8007), blocked by: 98/08/20 16:58:17.54 spid39 EXCEPTION_STACK_OVERFLOW raised, attempting to create symptom dump 98/08/20 16:58:17.54 spid39 Initializing symptom dump and stack dump facilities Additional query words: errorlog err msg st proc stproc sproc
Keywords : kbbug6.50 kbfix6.50.SP5 |
Last Reviewed: November 17, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |