Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databases
SQL 2005: CREATE CLUSTERED INDEX ON HUGE TABLE FAILSI 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 directo ry ----------------------- 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 = 0x 0 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 = <NUL L> 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 us ed 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 0x66A1B97 5 2005-07-29 16:26:19.36 spid51 Timeout waiting for external dump process 4920.
Post Follow-up to this message
Re: SQL 2005: CREATE CLUSTERED INDEX ON HUGE TABLE FAILSThis 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. > >
Post Follow-up to this message
Sponsored Links
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread
