BUG: AutoClose Database Option May Cause a Stack Dump and Cause SQL Server to Shut Down (309255)

MORE INFORMATION

There are two slightly different stack dumps that can represent this particular problem:

Dump thread - spid = 121, PSS = 0x5036d0f4, EC = 0x5036d2a4
Stack Dump being sent to C:\MSSQL7\log\SQL00004.dmp
*************************************************************************
* BEGIN STACK DUMP:
*   06/08/01 09:16:18 spid 121
*
* Input Buffer 18 bytes -
*  u s e   [ C P D ] 
* 
*************************************************************************
-------------------------------------------------------------------------
Short Stack Dump
0x77f67a6b Module(ntdll+7a6b) (ZwGetContextThread+b)
0x0058f98f Module(sqlservr+18f98f) (ex_raise2+35c)
0x0044f41f Module(sqlservr+4f41f) (ex_raise+5f)
0x00573592 Module(sqlservr+173592) (usedb+c0)
0x0040441a Module(sqlservr+441a) (CAutoDb::FUse+31)
0x00402c9f Module(sqlservr+2c9f) (opentabid+77)
0x00406052 Module(sqlservr+6052) (CSysScan::OpenScan+b4)
0x00405da8 Module(sqlservr+5da8) (CSysScan::StartScan+93)
0x005bef1c Module(sqlservr+1bef1c) (CColumnScan::FFindById+3f)
0x006919c9 Module(sqlservr+2919c9) (CIdentity::VFlush+7f)
0x00690f24 Module(sqlservr+290f24) (CIdentity::VFlushForCheckpoint+190)
0x0057bcbf Module(sqlservr+17bcbf) (FlushIdentityValuesForCheckpoint+1b1)
0x006d2952 Module(sqlservr+2d2952) (HardCheckpoint+12)
0x0057a9f6 Module(sqlservr+17a9f6) (DBMgr::CleanShutdownDB+b2)
0x0057a799 Module(sqlservr+17a799) (DBMgr::TryToClose+20a)
0x00409475 Module(sqlservr+9475) (XDES::Close+1ab)
0x00409603 Module(sqlservr+9603) (XDES::Commit+150)
0x00409162 Module(sqlservr+9162) (XCB::MinimizeLocks+a4)
0x0044ed60 Module(sqlservr+4ed60) (clean_process+11b)
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)
0x7800bee4 Module(MSVCRT+bee4) (beginthread+ce)
0x77f04ede Module(KERNEL32+4ede) (lstrcmpiW+be)
0x00000000 Module(sqlservr+ffc00000)
				

The other stack dump looks like this:

Dump thread - spid = 38, PSS = 0x3961911c, EC = 0x396192cc
Stack Dump being sent to C:\MSSQL7\log\SQL00001.dmp
************************************************************************
*
* BEGIN STACK DUMP:
*   05/29/01 10:18:34 spid 38
*
* Input Buffer 194 bytes -
*  s e l e c t   n a m e   f r o m   [ C P D ] . . s y s u s e r s   w h e 
*  r e   s i d   =   0 x 2 1 6 F E E 6 2 7 2 E E D 4 1 1 A B 7 8 0 0 5 0 8 
*  B A E 0 F 5 7   a n d   i s a l i a s e d   =   0 
* 
************************************************************************
------------------------------------------------------------------------
Short Stack Dump
0x77f67a6b Module(ntdll+7a6b) (ZwGetContextThread+b)
0x0058f98f Module(sqlservr+18f98f) (ex_raise2+35c)
0x0044f41f Module(sqlservr+4f41f) (ex_raise+5f)
0x00573592 Module(sqlservr+173592) (usedb+c0)
0x0040441a Module(sqlservr+441a) (CAutoDb::FUse+31)
0x00402c9f Module(sqlservr+2c9f) (opentabid+77)
0x00406052 Module(sqlservr+6052) (CSysScan::OpenScan+b4)
0x00405da8 Module(sqlservr+5da8) (CSysScan::StartScan+93)
0x005bef1c Module(sqlservr+1bef1c) (CColumnScan::FFindById+3f)
0x006919c9 Module(sqlservr+2919c9) (CIdentity::VFlush+7f)
0x00690f24 Module(sqlservr+290f24) (CIdentity::VFlushForCheckpoint+190)
0x0057bcbf Module(sqlservr+17bcbf) (FlushIdentityValuesForCheckpoint+1b1)
0x006d2952 Module(sqlservr+2d2952) (HardCheckpoint+12)
0x0057a9f6 Module(sqlservr+17a9f6) (DBMgr::CleanShutdownDB+b2)
0x0057a799 Module(sqlservr+17a799) (DBMgr::TryToClose+20a)
0x00409475 Module(sqlservr+9475) (XDES::Close+1ab)
0x00409603 Module(sqlservr+9603) (XDES::Commit+150)
0x00409162 Module(sqlservr+9162) (XCB::MinimizeLocks+a4)
0x0044ed60 Module(sqlservr+4ed60) (clean_process+11b)
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)
0x7800bee4 Module(MSVCRT+bee4) (beginthread+ce)
0x77f04ede Module(KERNEL32+4ede) (lstrcmpiW+be)
0x00000000 Module(sqlservr+ffc00000)