Microsoft KB Archive/309255

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

Article ID: 309255

Article Last Modified on 9/4/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q309255



BUG #: 101793 (SQLBUG_70)



SYMPTOMS
In some unique situations, the AutoClose database option may cause a stack dump that shuts down SQL Server 7.0 service.



CAUSE
The SQL Server service shuts down when SQL Server 7.0 simultaneously tries to close the database and perform a Checkpoint.



WORKAROUND
Turn off the AutoClose database option for all the databases.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.



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 - 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)
 * BEGIN STACK DUMP:
 * 06/08/01 09:16:18 spid 121
 * Input Buffer 18 bytes -
 * u s e  [ C P D ]
 * Input Buffer 18 bytes -
 * u s e  [ C P D ]

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
 * 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)

Additional query words: auto close autoclose

Keywords: kbbug kbpending KB309255

-

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

© Microsoft Corporation. All rights reserved.