MS SQL Server - SQL 2005: CREATE CLUSTERED INDEX ON HUGE TABLE FAILS

Author

SQL 2005: CREATE CLUSTERED INDEX ON HUGE TABLE FAILS

2005-07-30, 11:23 am

I have several tables containing 150+ million rows. SQL 2005 June CTP is
failing on the create clustered index with the following messages. Anyone
seen this before?

CREATE UNIQUE CLUSTERED INDEX c_c ON
PREMI60SOURCE.DBO. XSTAGING_EN(ID,FDATE
,EDATE,PROD_TYPE)

Location: fgcb.cpp:409
Expression: mostFreeFile && propExt == 1
SPID: 51
Process ID: 2040
Msg 3624, Level 20, State 1, Line 1
A system assertion check has failed. Check the SQL Server error log for
details
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should
be discarded.

I also get a dump file and several other error files in the ERRORLOG directory

-----------------------
07/29/05 16:24:48, ACTION, SQLDUMPER_UNKNOWN_AP
P.EXE, Input parameters: 4
supplied
07/29/05 16:24:48, ACTION, SQLDUMPER_UNKNOWN_AP
P.EXE, ProcessID = 2040
07/29/05 16:24:48, ACTION, SQLDUMPER_UNKNOWN_AP
P.EXE, ThreadId = 0
07/29/05 16:24:48, ACTION, SQLDUMPER_UNKNOWN_AP
P.EXE, Flags = 0x0
07/29/05 16:24:48, ACTION, SQLDUMPER_UNKNOWN_AP
P.EXE, MiniDumpFlags = 0x0
07/29/05 16:24:48, ACTION, SQLDUMPER_UNKNOWN_AP
P.EXE, SqlInfoPtr =
0x01CA9E58
07/29/05 16:24:48, ACTION, SQLDUMPER_UNKNOWN_AP
P.EXE, DumpDir = <NULL>
07/29/05 16:24:48, ACTION, SQLDUMPER_UNKNOWN_AP
P.EXE, ExceptionRecordPtr
= 0x00000000
07/29/05 16:24:48, ACTION, SQLDUMPER_UNKNOWN_AP
P.EXE, ContextPtr =
0x00000000
07/29/05 16:24:48, ACTION, SQLDUMPER_UNKNOWN_AP
P.EXE, ExtraFile = <NULL>
07/29/05 16:24:48, ACTION, SQLDUMPER_UNKNOWN_AP
P.EXE, InstanceName =
<NULL>
07/29/05 16:24:48, ACTION, SQLDUMPER_UNKNOWN_AP
P.EXE, ServiceName = <NULL>
07/29/05 16:24:48, ACTION, SQLDUMPER_UNKNOWN_AP
P.EXE, Dump is associated
with file C:\Program Files\Microsoft SQL
Server\MSSQL. 1\MSSQL\LOG\SQLDump0
005.txt
07/29/05 16:26:19, ACTION, SQLDUMPER_UNKNOWN_AP
P.EXE, Callback type 7 not used
07/29/05 16:26:19, ACTION, SQLDUMPER_UNKNOWN_AP
P.EXE, MiniDump completed:
C:\Program Files\Microsoft SQL Server\MSSQL. 1\MSSQL\LOG\SQLDump0
005.mdmp
07/29/05 16:26:19, ACTION, sqlservr.exe, Watson Invoke: Yes
07/29/05 16:26:19, ACTION, sqlservr.exe, Watson Invoked:
C:\PROGRA~1\COMMON~1
\MICROS~1\DW\DW20.EXE dw20.exe -d "C:\Program
Files\Microsoft SQL Server\MSSQL. 1\MSSQL\LOG\SQLDump0
005.mft"
---------------------------------------

Version=131072
General_AppName=sqls
ervr.exe
UI LCID=1033
EventType=SQL90Excep
tion
P1=sqlservr.exe
P2=2000.90.1187.0
P3=4293F834
P4=sqlservr.exe
P5=2000.90.1187.0
P6=4293F834
P7=0
P8=01103357
P9=66A1B975
FilesToKeep=C:\Progr
am Files\Microsoft SQL
Server\MSSQL. 1\MSSQL\LOG\SQLDump0
005.mft|C:\Program Files\Microsoft SQL
Server\MSSQL. 1\MSSQL\LOG\SQLDump0
005.mdmp|C:\Program Files\Microsoft SQL
Server\MSSQL. 1\MSSQL\LOG\SQLDump0
005.txt|C:\Program Files\Microsoft SQL
Server\MSSQL. 1\MSSQL\LOG\SQLDump0
005.log
ReportingFlags=370
UIFlags=1
LoggingFlags=4
EventLogSource=SQLDU
MPER

-------------------------------

2005-07-29 16:24:40.35 spid51 Using 'dbghelp.dll' version '4.0.5'
2005-07-29 16:24:40.36 spid51 **Dump thread - spid = 51, PSS =
0x92359338, EC = 0x94C2C0D8
2005-07-29 16:24:40.36 spid51 ***Stack Dump being sent to C:\Program
Files\Microsoft SQL Server\MSSQL. 1\MSSQL\LOG\SQLDump0
005.txt
2005-07-29 16:24:40.36 spid51 *
********************
********************
********************
*******************
2005-07-29 16:24:40.36 spid51 *
2005-07-29 16:24:40.36 spid51 * BEGIN STACK DUMP:
2005-07-29 16:24:40.36 spid51 * 07/29/05 16:24:40 spid 51
2005-07-29 16:24:40.36 spid51 *
2005-07-29 16:24:40.36 spid51 * Location: fgcb.cpp:409
2005-07-29 16:24:40.36 spid51 * Expression: mostFreeFile && propExt == 1
2005-07-29 16:24:40.36 spid51 * SPID: 51
2005-07-29 16:24:40.36 spid51 * Process ID: 2040
2005-07-29 16:24:40.36 spid51 *
2005-07-29 16:24:40.38 spid51 *
2005-07-29 16:24:40.38 spid51 *
2005-07-29 16:24:40.38 spid51 * MODULE BASE
END SIZE
2005-07-29 16:24:40.38 spid51 * sqlservr 00400000
01E66FFF 01a67000
2005-07-29 16:24:40.38 spid51 * ntdll 7C800000
7C8BFFFF 000c0000
2005-07-29 16:24:40.38 spid51 * kernel32 77E40000
77F41FFF 00102000
2005-07-29 16:24:40.38 spid51 * ADVAPI32 77F50000
77FEBFFF 0009c000
2005-07-29 16:24:40.38 spid51 * RPCRT4 77C50000
77CEEFFF 0009f000
2005-07-29 16:24:40.38 spid51 * CRYPT32 761B0000
76242FFF 00093000
2005-07-29 16:24:40.38 spid51 * MSASN1 76190000
761A1FFF 00012000
2005-07-29 16:24:40.38 spid51 * msvcrt 77BA0000
77BF9FFF 0005a000
2005-07-29 16:24:40.38 spid51 * USER32 77380000
77411FFF 00092000
2005-07-29 16:24:40.38 spid51 * GDI32 77C00000
77C47FFF 00048000
2005-07-29 16:24:40.38 spid51 * MSVCP80 7C420000
7C4A4FFF 00085000
2005-07-29 16:24:40.38 spid51 * MSVCR80 7C370000
7C408FFF 00099000
2005-07-29 16:24:40.38 spid51 * MSWSOCK 71B20000
71B60FFF 00041000
2005-07-29 16:24:40.38 spid51 * WS2_32 71C00000
71C16FFF 00017000
2005-07-29 16:24:40.38 spid51 * WS2HELP 71BF0000
71BF7FFF 00008000
2005-07-29 16:24:40.38 spid51 * NETAPI32 71C40000
71C97FFF 00058000
2005-07-29 16:24:40.38 spid51 * opends60 333E0000
333E5FFF 00006000
2005-07-29 16:24:40.38 spid51 * Secur32 76F50000
76F62FFF 00013000
2005-07-29 16:24:40.38 spid51 * SHLWAPI 77DA0000
77DF1FFF 00052000
2005-07-29 16:24:40.38 spid51 * USERENV 76920000
769E3FFF 000c4000
2005-07-29 16:24:40.38 spid51 * psapi 76B70000
76B7AFFF 0000b000
2005-07-29 16:24:40.38 spid51 * instapi 02140000
02149FFF 0000a000
2005-07-29 16:24:40.38 spid51 * sqlevn70 02160000
022E9FFF 0018a000
2005-07-29 16:24:40.38 spid51 * SQLOS 344D0000
344D4FFF 00005000
2005-07-29 16:24:40.38 spid51 * rsaenh 084E0000
0850EFFF 0002f000
2005-07-29 16:24:40.38 spid51 * AUTHZ 76C40000
76C53FFF 00014000
2005-07-29 16:24:40.38 spid51 * MSCOREE 08F50000
08F8FFFF 00040000
2005-07-29 16:24:40.38 spid51 * ole32 08FC0000
090F3FFF 00134000
2005-07-29 16:24:40.38 spid51 * msv1_0 76C90000
76CB6FFF 00027000
2005-07-29 16:24:40.38 spid51 * iphlpapi 76CF0000
76D09FFF 0001a000
2005-07-29 16:24:40.38 spid51 * kerberos 09120000
09177FFF 00058000
2005-07-29 16:24:40.38 spid51 * cryptdll 766E0000
766EBFFF 0000c000
2005-07-29 16:24:40.38 spid51 * schannel 76750000
76776FFF 00027000
2005-07-29 16:24:40.38 spid51 * COMRES 091D0000
09295FFF 000c6000
2005-07-29 16:24:40.38 spid51 * XOLEHLP 092A0000
092A5FFF 00006000
2005-07-29 16:24:40.38 spid51 * MSDTCPRX 092B0000
09327FFF 00078000
2005-07-29 16:24:40.38 spid51 * msvcp60 09330000
09390FFF 00061000
2005-07-29 16:24:40.38 spid51 * MTXCLU 093A0000
093B8FFF 00019000
2005-07-29 16:24:40.38 spid51 * VERSION 77B90000
77B97FFF 00008000
2005-07-29 16:24:40.38 spid51 * WSOCK32 71BB0000
71BB8FFF 00009000
2005-07-29 16:24:40.38 spid51 * OLEAUT32 77D00000
77D8BFFF 0008c000
2005-07-29 16:24:40.38 spid51 * CLUSAPI 093C0000
093D1FFF 00012000
2005-07-29 16:24:40.38 spid51 * RESUTILS 093E0000
093F2FFF 00013000
2005-07-29 16:24:40.38 spid51 * DNSAPI 76ED0000
76EF8FFF 00029000
2005-07-29 16:24:40.39 spid51 * winrnr 09450000
09456FFF 00007000
2005-07-29 16:24:40.39 spid51 * WLDAP32 76F10000
76F3DFFF 0002e000
2005-07-29 16:24:40.39 spid51 * rasadhlp 09480000
09484FFF 00005000
2005-07-29 16:24:40.39 spid51 * security 09850000
09853FFF 00004000
2005-07-29 16:24:40.39 spid51 * msfte 0A180000
0A3D3FFF 00254000
2005-07-29 16:24:40.39 spid51 * dbghelp 0A3E0000
0A4E9FFF 0010a000
2005-07-29 16:24:40.39 spid51 * WINTRUST 76BB0000
76BDAFFF 0002b000
2005-07-29 16:24:40.39 spid51 * imagehlp 76C10000
76C38FFF 00029000
2005-07-29 16:24:40.39 spid51 * dssenh 0A740000
0A763FFF 00024000
2005-07-29 16:24:40.39 spid51 * hnetcfg 0A800000
0A858FFF 00059000
2005-07-29 16:24:40.39 spid51 * wshtcpip 71AE0000
71AE7FFF 00008000
2005-07-29 16:24:40.39 spid51 * ntdsapi 766F0000
76704FFF 00015000
2005-07-29 16:24:40.39 spid51 * xpsp2res 10000000
102C4FFF 002c5000
2005-07-29 16:24:40.39 spid51 * CLBCatQ 0A9A0000
0AA22FFF 00083000
2005-07-29 16:24:40.39 spid51 * sqlncli 0AA30000
0AC57FFF 00228000
2005-07-29 16:24:40.39 spid51 * COMCTL32 0AC60000
0ACF6FFF 00097000
2005-07-29 16:24:40.39 spid51 * comdlg32 023A0000
023E9FFF 0004a000
2005-07-29 16:24:40.39 spid51 * SHELL32 0AD00000
0B502FFF 00803000
2005-07-29 16:24:40.39 spid51 * comctl32 0B510000
0B612FFF 00103000
2005-07-29 16:24:40.39 spid51 * SQLNCLIR 0B640000
0B672FFF 00033000
2005-07-29 16:24:40.39 spid51 * msftepxy 0B620000
0B62DFFF 0000e000
2005-07-29 16:24:40.39 spid51 * NTMARTA 77E00000
77E21FFF 00022000
2005-07-29 16:24:40.39 spid51 * SAMLIB 0B950000
0B95EFFF 0000f000
2005-07-29 16:24:40.39 spid51 * xpsqlbot 0BF20000
0BF25FFF 00006000
2005-07-29 16:24:40.39 spid51 * xpstar90 0BF40000
0BF85FFF 00046000
2005-07-29 16:24:40.39 spid51 * SQLSCM90 0BFA0000
0BFA8FFF 00009000
2005-07-29 16:24:40.39 spid51 * ODBC32 0BFC0000
0BFFCFFF 0003d000
2005-07-29 16:24:40.39 spid51 * BatchParser90 0C000000
0C01EFFF 0001f000
2005-07-29 16:24:40.39 spid51 * SQLSVC90 0C030000
0C049FFF 0001a000
2005-07-29 16:24:40.39 spid51 * SqlResourceLoader 0C060000
0C065FFF 00006000
2005-07-29 16:24:40.39 spid51 * odbcint 0C340000
0C356FFF 00017000
2005-07-29 16:24:40.39 spid51 * SQLSVC90 0C360000
0C362FFF 00003000
2005-07-29 16:24:40.39 spid51 * xpstar90 0C470000
0C495FFF 00026000
2005-07-29 16:24:40.39 spid51 * odsole70 33380000
3338EFFF 0000f000
2005-07-29 16:24:40.39 spid51 * SQLDMO90 0D0B0000
0D3F9FFF 0034a000
2005-07-29 16:24:40.39 spid51 * SQLDMO90 0C9E0000
0CA6EFFF 0008f000
2005-07-29 16:24:40.39 spid51 * SXS 0CA70000
0CB2BFFF 000bc000
2005-07-29 16:24:40.39 spid51 * sqlevn70 0DB60000
0DCE9FFF 0018a000
2005-07-29 16:24:40.39 spid51 * dbghelp 0D600000
0D709FFF 0010a000
2005-07-29 16:24:40.39 spid51 *
2005-07-29 16:24:40.39 spid51 * Edi: 00000000:
2005-07-29 16:24:40.39 spid51 * Esi: 00000000:
2005-07-29 16:24:40.39 spid51 * Eax: 0CEAB378: 000042AC
00000000 00000000 77E55DEA 00000000 7C821B34
2005-07-29 16:24:40.39 spid51 * Ebx: 0CEAB494: 00155EB8
02A20040 00000006 8CD751B4 00000000 03939830
2005-07-29 16:24:40.39 spid51 * Ecx: 0CEAB9E8: 00000000
00010007 7C830DE8 00000000 0090008E 00155EBC
2005-07-29 16:24:40.39 spid51 * Edx: 0000003D:
2005-07-29 16:24:40.39 spid51 * Eip: 77E55DEA: 10C2C95E
90909000 A1649090 00000018 C334408B 891C428B
2005-07-29 16:24:40.39 spid51 * Ebp: 0CEAB3C8: 0CEAB40C
014F7704 000042AC 00000000 00000000 00000000
2005-07-29 16:24:40.39 spid51 * SegCs: 014F001B: 8B5974C9
003D0C46 C7000002 0000FC45 48730000 C083046A
2005-07-29 16:24:40.39 spid51 * EFlags: 00000246:
2005-07-29 16:24:40.39 spid51 * Esp: 0CEAB374: 92359338
000042AC 00000000 00000000 77E55DEA 00000000
2005-07-29 16:24:40.39 spid51 * SegSs: 0CEA0023: 00000000
00000000 00000000 00000000 00000000 00000000
2005-07-29 16:24:40.39 spid51 *
********************
********************
********************
*******************
2005-07-29 16:24:40.39 spid51 *
-------------------------------------------------------------------------------
2005-07-29 16:24:40.39 spid51 * Short Stack Dump
2005-07-29 16:24:40.41 spid51 77E55DEA Module(kernel32+0001
5DEA)
2005-07-29 16:24:40.41 spid51 014F7704 Module(sqlservr+010F
7704)
2005-07-29 16:24:40.41 spid51 014FB237 Module(sqlservr+010F
B237)
2005-07-29 16:24:40.41 spid51 013A5ED4 Module(sqlservr+00FA
5ED4)
2005-07-29 16:24:40.41 spid51 0095A673 Module(sqlservr+0055
A673)
2005-07-29 16:24:40.41 spid51 004D7E94 Module(sqlservr+000D
7E94)
2005-07-29 16:24:40.41 spid51 00494787 Module(sqlservr+0009
4787)
2005-07-29 16:24:40.41 spid51 014C5F1E Module(sqlservr+010C
5F1E)
2005-07-29 16:24:40.41 spid51 014C618A Module(sqlservr+010C
618A)
2005-07-29 16:24:40.41 spid51 014C268D Module(sqlservr+010C
268D)
2005-07-29 16:24:40.41 spid51 00964EE7 Module(sqlservr+0056
4EE7)
2005-07-29 16:24:40.41 spid51 007E9707 Module(sqlservr+003E
9707)
2005-07-29 16:24:40.41 spid51 004E8B7A Module(sqlservr+000E
8B7A)
2005-07-29 16:24:40.41 spid51 004E88DE Module(sqlservr+000E
88DE)
2005-07-29 16:24:40.41 spid51 0118B5CA Module(sqlservr+00D8
B5CA)
2005-07-29 16:24:40.41 spid51 00442CF4 Module(sqlservr+0004
2CF4)
2005-07-29 16:24:40.41 spid51 011A6E8F Module(sqlservr+00DA
6E8F)
2005-07-29 16:24:40.41 spid51 011A69EB Module(sqlservr+00DA
69EB)
2005-07-29 16:24:40.41 spid51 011A5BF5 Module(sqlservr+00DA
5BF5)
2005-07-29 16:24:40.41 spid51 004563B9 Module(sqlservr+0005
63B9)
2005-07-29 16:24:40.41 spid51 011A3551 Module(sqlservr+00DA
3551)
2005-07-29 16:24:40.43 spid51 004563B9 Module(sqlservr+0005
63B9)
2005-07-29 16:24:40.43 spid51 006A569A Module(sqlservr+002A
569A)
2005-07-29 16:24:40.43 spid51 006A5779 Module(sqlservr+002A
5779)
2005-07-29 16:24:40.43 spid51 006A4CE8 Module(sqlservr+002A
4CE8)
2005-07-29 16:24:40.43 spid51 006A529C Module(sqlservr+002A
529C)
2005-07-29 16:24:40.43 spid51 004078E4 Module(sqlservr+0000
78E4)
2005-07-29 16:24:40.43 spid51 00407A04 Module(sqlservr+0000
7A04)
2005-07-29 16:24:40.43 spid51 00407BE2 Module(sqlservr+0000
7BE2)
2005-07-29 16:24:40.43 spid51 004DEE69 Module(sqlservr+000D
EE69)
2005-07-29 16:24:40.43 spid51 004DED73 Module(sqlservr+000D
ED73)
2005-07-29 16:24:40.43 spid51 004DEA47 Module(sqlservr+000D
EA47)
2005-07-29 16:24:40.44 spid51 004DEBD0 Module(sqlservr+000D
EBD0)
2005-07-29 16:24:40.44 spid51 7C372603 Module(MSVCR80+00002
603)
2005-07-29 16:24:40.46 spid51 7C372691 Module(MSVCR80+00002
691)
2005-07-29 16:24:40.49 spid51 Stack Signature for the dump is 0x66A1B975
2005-07-29 16:26:19.36 spid51 Timeout waiting for external dump process
4920.

Paul S Randal [MS]

2005-07-30, 11:23 am

This is a known issue in CTP-15 (June CTP) that has already been fixed. The
fix will be available in CTP-16. Try adding and dropping a file to trigger
proprtional fill recalculation before issuing the create index statement -
that may allow you to workaround this.

Thanks

--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine

This posting is provided "AS IS" with no warranties, and confers no rights.

"RC" <RC@discussions.microsoft.com> wrote in message
news:160344DC-0D55-4F54-88E4- E96458C78D93@microso
ft.com...
>I have several tables containing 150+ million rows. SQL 2005 June CTP is
> failing on the create clustered index with the following messages. Anyone
> seen this before?
>
> CREATE UNIQUE CLUSTERED INDEX c_c ON
> PREMI60SOURCE.DBO. XSTAGING_EN(ID,FDATE
,EDATE,PROD_TYPE)
>
> Location: fgcb.cpp:409
> Expression: mostFreeFile && propExt == 1
> SPID: 51
> Process ID: 2040
> Msg 3624, Level 20, State 1, Line 1
> A system assertion check has failed. Check the SQL Server error log for
> details
> Msg 0, Level 20, State 0, Line 0
> A severe error occurred on the current command. The results, if any,
> should
> be discarded.
>
> I also get a dump file and several other error files in the ERRORLOG
> directory
>
> -----------------------
> 07/29/05 16:24:48, ACTION, SQLDUMPER_UNKNOWN_AP
P.EXE, Input parameters: 4
> supplied
> 07/29/05 16:24:48, ACTION, SQLDUMPER_UNKNOWN_AP
P.EXE, ProcessID = 2040
> 07/29/05 16:24:48, ACTION, SQLDUMPER_UNKNOWN_AP
P.EXE, ThreadId = 0
> 07/29/05 16:24:48, ACTION, SQLDUMPER_UNKNOWN_AP
P.EXE, Flags = 0x0
> 07/29/05 16:24:48, ACTION, SQLDUMPER_UNKNOWN_AP
P.EXE, MiniDumpFlags =
> 0x0
> 07/29/05 16:24:48, ACTION, SQLDUMPER_UNKNOWN_AP
P.EXE, SqlInfoPtr =
> 0x01CA9E58
> 07/29/05 16:24:48, ACTION, SQLDUMPER_UNKNOWN_AP
P.EXE, DumpDir = <NULL>
> 07/29/05 16:24:48, ACTION, SQLDUMPER_UNKNOWN_AP
P.EXE,
> ExceptionRecordPtr
> = 0x00000000
> 07/29/05 16:24:48, ACTION, SQLDUMPER_UNKNOWN_AP
P.EXE, ContextPtr =
> 0x00000000
> 07/29/05 16:24:48, ACTION, SQLDUMPER_UNKNOWN_AP
P.EXE, ExtraFile =
> <NULL>
> 07/29/05 16:24:48, ACTION, SQLDUMPER_UNKNOWN_AP
P.EXE, InstanceName =
> <NULL>
> 07/29/05 16:24:48, ACTION, SQLDUMPER_UNKNOWN_AP
P.EXE, ServiceName =
> <NULL>
> 07/29/05 16:24:48, ACTION, SQLDUMPER_UNKNOWN_AP
P.EXE, Dump is associated
> with file C:\Program Files\Microsoft SQL
> Server\MSSQL. 1\MSSQL\LOG\SQLDump0
005.txt
> 07/29/05 16:26:19, ACTION, SQLDUMPER_UNKNOWN_AP
P.EXE, Callback type 7 not
> used
> 07/29/05 16:26:19, ACTION, SQLDUMPER_UNKNOWN_AP
P.EXE, MiniDump completed:
> C:\Program Files\Microsoft SQL Server\MSSQL. 1\MSSQL\LOG\SQLDump0
005.mdmp
> 07/29/05 16:26:19, ACTION, sqlservr.exe, Watson Invoke: Yes
> 07/29/05 16:26:19, ACTION, sqlservr.exe, Watson Invoked:
> C:\PROGRA~1\COMMON~1
\MICROS~1\DW\DW20.EXE dw20.exe -d "C:\Program
> Files\Microsoft SQL Server\MSSQL. 1\MSSQL\LOG\SQLDump0
005.mft"
> ---------------------------------------
>
>
> Version=131072
> General_AppName=sqls
ervr.exe
> UI LCID=1033
> EventType=SQL90Excep
tion
> P1=sqlservr.exe
> P2=2000.90.1187.0
> P3=4293F834
> P4=sqlservr.exe
> P5=2000.90.1187.0
> P6=4293F834
> P7=0
> P8=01103357
> P9=66A1B975
> FilesToKeep=C:\Progr
am Files\Microsoft SQL
> Server\MSSQL. 1\MSSQL\LOG\SQLDump0
005.mft|C:\Program Files\Microsoft SQL
> Server\MSSQL. 1\MSSQL\LOG\SQLDump0
005.mdmp|C:\Program Files\Microsoft SQL
> Server\MSSQL. 1\MSSQL\LOG\SQLDump0
005.txt|C:\Program Files\Microsoft SQL
> Server\MSSQL. 1\MSSQL\LOG\SQLDump0
005.log
> ReportingFlags=370
> UIFlags=1
> LoggingFlags=4
> EventLogSource=SQLDU
MPER
>
> -------------------------------
>
> 2005-07-29 16:24:40.35 spid51 Using 'dbghelp.dll' version '4.0.5'
> 2005-07-29 16:24:40.36 spid51 **Dump thread - spid = 51, PSS =
> 0x92359338, EC = 0x94C2C0D8
> 2005-07-29 16:24:40.36 spid51 ***Stack Dump being sent to C:\Program
> Files\Microsoft SQL Server\MSSQL. 1\MSSQL\LOG\SQLDump0
005.txt
> 2005-07-29 16:24:40.36 spid51 *
> ********************
********************
********************
*******************
> 2005-07-29 16:24:40.36 spid51 *
> 2005-07-29 16:24:40.36 spid51 * BEGIN STACK DUMP:
> 2005-07-29 16:24:40.36 spid51 * 07/29/05 16:24:40 spid 51
> 2005-07-29 16:24:40.36 spid51 *
> 2005-07-29 16:24:40.36 spid51 * Location: fgcb.cpp:409
> 2005-07-29 16:24:40.36 spid51 * Expression: mostFreeFile && propExt
> == 1
> 2005-07-29 16:24:40.36 spid51 * SPID: 51
> 2005-07-29 16:24:40.36 spid51 * Process ID: 2040
> 2005-07-29 16:24:40.36 spid51 *
> 2005-07-29 16:24:40.38 spid51 *
> 2005-07-29 16:24:40.38 spid51 *
> 2005-07-29 16:24:40.38 spid51 * MODULE BASE
> END SIZE
> 2005-07-29 16:24:40.38 spid51 * sqlservr
> 00400000
> 01E66FFF 01a67000
> 2005-07-29 16:24:40.38 spid51 * ntdll
> 7C800000
> 7C8BFFFF 000c0000
> 2005-07-29 16:24:40.38 spid51 * kernel32
> 77E40000
> 77F41FFF 00102000
> 2005-07-29 16:24:40.38 spid51 * ADVAPI32
> 77F50000
> 77FEBFFF 0009c000
> 2005-07-29 16:24:40.38 spid51 * RPCRT4
> 77C50000
> 77CEEFFF 0009f000
> 2005-07-29 16:24:40.38 spid51 * CRYPT32
> 761B0000
> 76242FFF 00093000
> 2005-07-29 16:24:40.38 spid51 * MSASN1
> 76190000
> 761A1FFF 00012000
> 2005-07-29 16:24:40.38 spid51 * msvcrt
> 77BA0000
> 77BF9FFF 0005a000
> 2005-07-29 16:24:40.38 spid51 * USER32
> 77380000
> 77411FFF 00092000
> 2005-07-29 16:24:40.38 spid51 * GDI32
> 77C00000
> 77C47FFF 00048000
> 2005-07-29 16:24:40.38 spid51 * MSVCP80
> 7C420000
> 7C4A4FFF 00085000
> 2005-07-29 16:24:40.38 spid51 * MSVCR80
> 7C370000
> 7C408FFF 00099000
> 2005-07-29 16:24:40.38 spid51 * MSWSOCK
> 71B20000
> 71B60FFF 00041000
> 2005-07-29 16:24:40.38 spid51 * WS2_32
> 71C00000
> 71C16FFF 00017000
> 2005-07-29 16:24:40.38 spid51 * WS2HELP
> 71BF0000
> 71BF7FFF 00008000
> 2005-07-29 16:24:40.38 spid51 * NETAPI32
> 71C40000
> 71C97FFF 00058000
> 2005-07-29 16:24:40.38 spid51 * opends60
> 333E0000
> 333E5FFF 00006000
> 2005-07-29 16:24:40.38 spid51 * Secur32
> 76F50000
> 76F62FFF 00013000
> 2005-07-29 16:24:40.38 spid51 * SHLWAPI
> 77DA0000
> 77DF1FFF 00052000
> 2005-07-29 16:24:40.38 spid51 * USERENV
> 76920000
> 769E3FFF 000c4000
> 2005-07-29 16:24:40.38 spid51 * psapi
> 76B70000
> 76B7AFFF 0000b000
> 2005-07-29 16:24:40.38 spid51 * instapi
> 02140000
> 02149FFF 0000a000
> 2005-07-29 16:24:40.38 spid51 * sqlevn70
> 02160000
> 022E9FFF 0018a000
> 2005-07-29 16:24:40.38 spid51 * SQLOS
> 344D0000
> 344D4FFF 00005000
> 2005-07-29 16:24:40.38 spid51 * rsaenh
> 084E0000
> 0850EFFF 0002f000
> 2005-07-29 16:24:40.38 spid51 * AUTHZ
> 76C40000
> 76C53FFF 00014000
> 2005-07-29 16:24:40.38 spid51 * MSCOREE
> 08F50000
> 08F8FFFF 00040000
> 2005-07-29 16:24:40.38 spid51 * ole32
> 08FC0000
> 090F3FFF 00134000
> 2005-07-29 16:24:40.38 spid51 * msv1_0
> 76C90000
> 76CB6FFF 00027000
> 2005-07-29 16:24:40.38 spid51 * iphlpapi
> 76CF0000
> 76D09FFF 0001a000
> 2005-07-29 16:24:40.38 spid51 * kerberos
> 09120000
> 09177FFF 00058000
> 2005-07-29 16:24:40.38 spid51 * cryptdll
> 766E0000
> 766EBFFF 0000c000
> 2005-07-29 16:24:40.38 spid51 * schannel
> 76750000
> 76776FFF 00027000
> 2005-07-29 16:24:40.38 spid51 * COMRES
> 091D0000
> 09295FFF 000c6000
> 2005-07-29 16:24:40.38 spid51 * XOLEHLP
> 092A0000
> 092A5FFF 00006000
> 2005-07-29 16:24:40.38 spid51 * MSDTCPRX
> 092B0000
> 09327FFF 00078000
> 2005-07-29 16:24:40.38 spid51 * msvcp60
> 09330000
> 09390FFF 00061000
> 2005-07-29 16:24:40.38 spid51 * MTXCLU
> 093A0000
> 093B8FFF 00019000
> 2005-07-29 16:24:40.38 spid51 * VERSION
> 77B90000
> 77B97FFF 00008000
> 2005-07-29 16:24:40.38 spid51 * WSOCK32
> 71BB0000
> 71BB8FFF 00009000
> 2005-07-29 16:24:40.38 spid51 * OLEAUT32
> 77D00000
> 77D8BFFF 0008c000
> 2005-07-29 16:24:40.38 spid51 * CLUSAPI
> 093C0000
> 093D1FFF 00012000
> 2005-07-29 16:24:40.38 spid51 * RESUTILS
> 093E0000
> 093F2FFF 00013000
> 2005-07-29 16:24:40.38 spid51 * DNSAPI
> 76ED0000
> 76EF8FFF 00029000
> 2005-07-29 16:24:40.39 spid51 * winrnr
> 09450000
> 09456FFF 00007000
> 2005-07-29 16:24:40.39 spid51 * WLDAP32
> 76F10000
> 76F3DFFF 0002e000
> 2005-07-29 16:24:40.39 spid51 * rasadhlp
> 09480000
> 09484FFF 00005000
> 2005-07-29 16:24:40.39 spid51 * security
> 09850000
> 09853FFF 00004000
> 2005-07-29 16:24:40.39 spid51 * msfte
> 0A180000
> 0A3D3FFF 00254000
> 2005-07-29 16:24:40.39 spid51 * dbghelp
> 0A3E0000
> 0A4E9FFF 0010a000
> 2005-07-29 16:24:40.39 spid51 * WINTRUST
> 76BB0000
> 76BDAFFF 0002b000
> 2005-07-29 16:24:40.39 spid51 * imagehlp
> 76C10000
> 76C38FFF 00029000
> 2005-07-29 16:24:40.39 spid51 * dssenh
> 0A740000
> 0A763FFF 00024000
> 2005-07-29 16:24:40.39 spid51 * hnetcfg
> 0A800000
> 0A858FFF 00059000
> 2005-07-29 16:24:40.39 spid51 * wshtcpip
> 71AE0000
> 71AE7FFF 00008000
> 2005-07-29 16:24:40.39 spid51 * ntdsapi
> 766F0000
> 76704FFF 00015000
> 2005-07-29 16:24:40.39 spid51 * xpsp2res
> 10000000
> 102C4FFF 002c5000
> 2005-07-29 16:24:40.39 spid51 * CLBCatQ
> 0A9A0000
> 0AA22FFF 00083000
> 2005-07-29 16:24:40.39 spid51 * sqlncli
> 0AA30000
> 0AC57FFF 00228000
> 2005-07-29 16:24:40.39 spid51 * COMCTL32
> 0AC60000
> 0ACF6FFF 00097000
> 2005-07-29 16:24:40.39 spid51 * comdlg32
> 023A0000
> 023E9FFF 0004a000
> 2005-07-29 16:24:40.39 spid51 * SHELL32
> 0AD00000
> 0B502FFF 00803000
> 2005-07-29 16:24:40.39 spid51 * comctl32
> 0B510000
> 0B612FFF 00103000
> 2005-07-29 16:24:40.39 spid51 * SQLNCLIR
> 0B640000
> 0B672FFF 00033000
> 2005-07-29 16:24:40.39 spid51 * msftepxy
> 0B620000
> 0B62DFFF 0000e000
> 2005-07-29 16:24:40.39 spid51 * NTMARTA
> 77E00000
> 77E21FFF 00022000
> 2005-07-29 16:24:40.39 spid51 * SAMLIB
> 0B950000
> 0B95EFFF 0000f000
> 2005-07-29 16:24:40.39 spid51 * xpsqlbot
> 0BF20000
> 0BF25FFF 00006000
> 2005-07-29 16:24:40.39 spid51 * xpstar90
> 0BF40000
> 0BF85FFF 00046000
> 2005-07-29 16:24:40.39 spid51 * SQLSCM90
> 0BFA0000
> 0BFA8FFF 00009000
> 2005-07-29 16:24:40.39 spid51 * ODBC32
> 0BFC0000
> 0BFFCFFF 0003d000
> 2005-07-29 16:24:40.39 spid51 * BatchParser90
> 0C000000
> 0C01EFFF 0001f000
> 2005-07-29 16:24:40.39 spid51 * SQLSVC90
> 0C030000
> 0C049FFF 0001a000
> 2005-07-29 16:24:40.39 spid51 * SqlResourceLoader
> 0C060000
> 0C065FFF 00006000
> 2005-07-29 16:24:40.39 spid51 * odbcint
> 0C340000
> 0C356FFF 00017000
> 2005-07-29 16:24:40.39 spid51 * SQLSVC90
> 0C360000
> 0C362FFF 00003000
> 2005-07-29 16:24:40.39 spid51 * xpstar90
> 0C470000
> 0C495FFF 00026000
> 2005-07-29 16:24:40.39 spid51 * odsole70
> 33380000
> 3338EFFF 0000f000
> 2005-07-29 16:24:40.39 spid51 * SQLDMO90
> 0D0B0000
> 0D3F9FFF 0034a000
> 2005-07-29 16:24:40.39 spid51 * SQLDMO90
> 0C9E0000
> 0CA6EFFF 0008f000
> 2005-07-29 16:24:40.39 spid51 * SXS
> 0CA70000
> 0CB2BFFF 000bc000
> 2005-07-29 16:24:40.39 spid51 * sqlevn70
> 0DB60000
> 0DCE9FFF 0018a000
> 2005-07-29 16:24:40.39 spid51 * dbghelp
> 0D600000
> 0D709FFF 0010a000
> 2005-07-29 16:24:40.39 spid51 *
> 2005-07-29 16:24:40.39 spid51 * Edi: 00000000:
> 2005-07-29 16:24:40.39 spid51 * Esi: 00000000:
> 2005-07-29 16:24:40.39 spid51 * Eax: 0CEAB378: 000042AC
> 00000000 00000000 77E55DEA 00000000 7C821B34
> 2005-07-29 16:24:40.39 spid51 * Ebx: 0CEAB494: 00155EB8
> 02A20040 00000006 8CD751B4 00000000 03939830
> 2005-07-29 16:24:40.39 spid51 * Ecx: 0CEAB9E8: 00000000
> 00010007 7C830DE8 00000000 0090008E 00155EBC
> 2005-07-29 16:24:40.39 spid51 * Edx: 0000003D:
> 2005-07-29 16:24:40.39 spid51 * Eip: 77E55DEA: 10C2C95E
> 90909000 A1649090 00000018 C334408B 891C428B
> 2005-07-29 16:24:40.39 spid51 * Ebp: 0CEAB3C8: 0CEAB40C
> 014F7704 000042AC 00000000 00000000 00000000
> 2005-07-29 16:24:40.39 spid51 * SegCs: 014F001B: 8B5974C9
> 003D0C46 C7000002 0000FC45 48730000 C083046A
> 2005-07-29 16:24:40.39 spid51 * EFlags: 00000246:
> 2005-07-29 16:24:40.39 spid51 * Esp: 0CEAB374: 92359338
> 000042AC 00000000 00000000 77E55DEA 00000000
> 2005-07-29 16:24:40.39 spid51 * SegSs: 0CEA0023: 00000000
> 00000000 00000000 00000000 00000000 00000000
> 2005-07-29 16:24:40.39 spid51 *
> ********************
********************
********************
*******************
> 2005-07-29 16:24:40.39 spid51 *
> -------------------------------------------------------------------------------
> 2005-07-29 16:24:40.39 spid51 * Short Stack Dump
> 2005-07-29 16:24:40.41 spid51 77E55DEA Module(kernel32+0001
5DEA)
> 2005-07-29 16:24:40.41 spid51 014F7704 Module(sqlservr+010F
7704)
> 2005-07-29 16:24:40.41 spid51 014FB237 Module(sqlservr+010F
B237)
> 2005-07-29 16:24:40.41 spid51 013A5ED4 Module(sqlservr+00FA
5ED4)
> 2005-07-29 16:24:40.41 spid51 0095A673 Module(sqlservr+0055
A673)
> 2005-07-29 16:24:40.41 spid51 004D7E94 Module(sqlservr+000D
7E94)
> 2005-07-29 16:24:40.41 spid51 00494787 Module(sqlservr+0009
4787)
> 2005-07-29 16:24:40.41 spid51 014C5F1E Module(sqlservr+010C
5F1E)
> 2005-07-29 16:24:40.41 spid51 014C618A Module(sqlservr+010C
618A)
> 2005-07-29 16:24:40.41 spid51 014C268D Module(sqlservr+010C
268D)
> 2005-07-29 16:24:40.41 spid51 00964EE7 Module(sqlservr+0056
4EE7)
> 2005-07-29 16:24:40.41 spid51 007E9707 Module(sqlservr+003E
9707)
> 2005-07-29 16:24:40.41 spid51 004E8B7A Module(sqlservr+000E
8B7A)
> 2005-07-29 16:24:40.41 spid51 004E88DE Module(sqlservr+000E
88DE)
> 2005-07-29 16:24:40.41 spid51 0118B5CA Module(sqlservr+00D8
B5CA)
> 2005-07-29 16:24:40.41 spid51 00442CF4 Module(sqlservr+0004
2CF4)
> 2005-07-29 16:24:40.41 spid51 011A6E8F Module(sqlservr+00DA
6E8F)
> 2005-07-29 16:24:40.41 spid51 011A69EB Module(sqlservr+00DA
69EB)
> 2005-07-29 16:24:40.41 spid51 011A5BF5 Module(sqlservr+00DA
5BF5)
> 2005-07-29 16:24:40.41 spid51 004563B9 Module(sqlservr+0005
63B9)
> 2005-07-29 16:24:40.41 spid51 011A3551 Module(sqlservr+00DA
3551)
> 2005-07-29 16:24:40.43 spid51 004563B9 Module(sqlservr+0005
63B9)
> 2005-07-29 16:24:40.43 spid51 006A569A Module(sqlservr+002A
569A)
> 2005-07-29 16:24:40.43 spid51 006A5779 Module(sqlservr+002A
5779)
> 2005-07-29 16:24:40.43 spid51 006A4CE8 Module(sqlservr+002A
4CE8)
> 2005-07-29 16:24:40.43 spid51 006A529C Module(sqlservr+002A
529C)
> 2005-07-29 16:24:40.43 spid51 004078E4 Module(sqlservr+0000
78E4)
> 2005-07-29 16:24:40.43 spid51 00407A04 Module(sqlservr+0000
7A04)
> 2005-07-29 16:24:40.43 spid51 00407BE2 Module(sqlservr+0000
7BE2)
> 2005-07-29 16:24:40.43 spid51 004DEE69 Module(sqlservr+000D
EE69)
> 2005-07-29 16:24:40.43 spid51 004DED73 Module(sqlservr+000D
ED73)
> 2005-07-29 16:24:40.43 spid51 004DEA47 Module(sqlservr+000D
EA47)
> 2005-07-29 16:24:40.44 spid51 004DEBD0 Module(sqlservr+000D
EBD0)
> 2005-07-29 16:24:40.44 spid51 7C372603 Module(MSVCR80+00002
603)
> 2005-07-29 16:24:40.46 spid51 7C372691 Module(MSVCR80+00002
691)
> 2005-07-29 16:24:40.49 spid51 Stack Signature for the dump is
> 0x66A1B975
> 2005-07-29 16:26:19.36 spid51 Timeout waiting for external dump
> process
> 4920.
>
>

Sponsored Links