July 8, 2008 at 3:02 pm
The database is a template that we use for many different companies and has been working fine for a long time on many different servers running sql2000 sp4 on Windows server 2003.
We've upgraded to new servers running Windows Server 2003 and SQL Server 2005 Standard. I'm running on build 3239.
Restored a database from backup off of a SQL2000 machine onto the SQL2k5 box but keeping it in Compatibility mode 80. There is a web app that hits this database and since the move i'm getting these errors:
SQL ERRORS:
Date7/8/2008 9:39:49 AM
LogSQL Server (Current - 7/8/2008 10:50:00 AM)
Sourcespid57
Message
A system assertion check has failed. Check the SQL Server error log for details. Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB. If you agreed to send dumps to Microsoft during setup, a mini dump will be sent to Microsoft. An update might be available from Microsoft in the latest Service Pack or in a QFE from Technical Support.
Date7/8/2008 9:39:49 AM
LogSQL Server (Current - 7/8/2008 10:50:00 AM)
Sourcespid57
Message
Error: 3624, Severity: 20, State: 1.
Date7/8/2008 9:39:49 AM
LogSQL Server (Current - 7/8/2008 10:50:00 AM)
Sourcespid57
Message
SQL Server Assertion: File: m_pxteFetch'. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check the database for structural integrity, or restart the server to ensure in-memory data structures are not corrupted.
Date7/8/2008 9:39:49 AM
LogSQL Server (Current - 7/8/2008 10:50:00 AM)
Sourcespid57
Message
Error: 17066, Severity: 16, State: 1.
Date7/8/2008 9:39:49 AM
LogSQL Server (Current - 7/8/2008 10:50:00 AM)
Sourcespid57
Message
External dump process return code 0x20002001.
The error information has been submitted to Watson error reporting.
EventViewer: (I know its a lot but it might have something that you see and I missed)
07/08/2008 09:39:49,spid57,Unknown,A system assertion check has failed. Check the SQL Server error log for details. Typically a mini dump will be sent to Microsoft. An update might be available from Microsoft in the latest Service Pack or in a QFE from Technical Support.
07/08/2008 09:39:49,spid57,Unknown,Error: 3624 State: 1.
07/08/2008 09:39:49,spid57,Unknown,SQL Server Assertion: File: or restart the server to ensure in-memory data structures are not corrupted.
07/08/2008 09:39:49,spid57,Unknown,Error: 17066 State: 1.
07/08/2008 09:39:49,spid57,Unknown,External dump process return code 0x20002001. The error information has been submitted to Watson error reporting.
07/08/2008 09:39:47,spid57,Unknown,Stack Signature for the dump is 0x00000001BF6A6F74
07/08/2008 09:39:47,spid57,Unknown,0000000077D6B6DA Module(kernel32+000000000002B6DA)
07/08/2008 09:39:47,spid57,Unknown,0000000078133894 Module(MSVCR80+0000000000003894)
07/08/2008 09:39:47,spid57,Unknown,00000000781337D7 Module(MSVCR80+00000000000037D7)
07/08/2008 09:39:47,spid57,Unknown,00000000014FCD48 Module(sqlservr+00000000004FCD48)
07/08/2008 09:39:47,spid57,Unknown,0000000001542D10 Module(sqlservr+0000000000542D10)
07/08/2008 09:39:47,spid57,Unknown,0000000001820839 Module(sqlservr+0000000000820839)
07/08/2008 09:39:47,spid57,Unknown,000000000154AE17 Module(sqlservr+000000000054AE17)
07/08/2008 09:39:47,spid57,Unknown,000000000171E914 Module(sqlservr+000000000071E914)
07/08/2008 09:39:47,spid57,Unknown,0000000001717E89 Module(sqlservr+0000000000717E89)
07/08/2008 09:39:47,spid57,Unknown,000000000171813E Module(sqlservr+000000000071813E)
07/08/2008 09:39:47,spid57,Unknown,00000000016C7728 Module(sqlservr+00000000006C7728)
07/08/2008 09:39:47,spid57,Unknown,00000000016C6C81 Module(sqlservr+00000000006C6C81)
07/08/2008 09:39:47,spid57,Unknown,0000000001713F6A Module(sqlservr+0000000000713F6A)
07/08/2008 09:39:47,spid57,Unknown,000000000171FDE7 Module(sqlservr+000000000071FDE7)
07/08/2008 09:39:47,spid57,Unknown,00000000017FCE61 Module(sqlservr+00000000007FCE61)
07/08/2008 09:39:47,spid57,Unknown,000000000176005B Module(sqlservr+000000000076005B)
07/08/2008 09:39:47,spid57,Unknown,000000000178F12D Module(sqlservr+000000000078F12D)
07/08/2008 09:39:47,spid57,Unknown,00000000015426D1 Module(sqlservr+00000000005426D1)
07/08/2008 09:39:47,spid57,Unknown,00000000017DC248 Module(sqlservr+00000000007DC248)
07/08/2008 09:39:47,spid57,Unknown,00000000017DC077 Module(sqlservr+00000000007DC077)
07/08/2008 09:39:47,spid57,Unknown,000000000177730A Module(sqlservr+000000000077730A)
07/08/2008 09:39:47,spid57,Unknown,00000000015A8B0A Module(sqlservr+00000000005A8B0A)
07/08/2008 09:39:47,spid57,Unknown,00000000015B6074 Module(sqlservr+00000000005B6074)
07/08/2008 09:39:47,spid57,Unknown,00000000015B6074 Module(sqlservr+00000000005B6074)
07/08/2008 09:39:47,spid57,Unknown,00000000015B6074 Module(sqlservr+00000000005B6074)
07/08/2008 09:39:47,spid57,Unknown,00000000015B6074 Module(sqlservr+00000000005B6074)
07/08/2008 09:39:47,spid57,Unknown,00000000015B6074 Module(sqlservr+00000000005B6074)
07/08/2008 09:39:47,spid57,Unknown,00000000015B6074 Module(sqlservr+00000000005B6074)
07/08/2008 09:39:47,spid57,Unknown,00000000015B6074 Module(sqlservr+00000000005B6074)
07/08/2008 09:39:47,spid57,Unknown,00000000015B6074 Module(sqlservr+00000000005B6074)
07/08/2008 09:39:47,spid57,Unknown,00000000015B6074 Module(sqlservr+00000000005B6074)
07/08/2008 09:39:47,spid57,Unknown,00000000015B615D Module(sqlservr+00000000005B615D)
07/08/2008 09:39:47,spid57,Unknown,0000000001A33EED Module(sqlservr+0000000000A33EED)
07/08/2008 09:39:47,spid57,Unknown,00000000026D75BB Module(sqlservr+00000000016D75BB)
07/08/2008 09:39:47,spid57,Unknown,0000000001FA8F99 Module(sqlservr+0000000000FA8F99)
07/08/2008 09:39:47,spid57,Unknown,0000000001FA538E Module(sqlservr+0000000000FA538E)
07/08/2008 09:39:47,spid57,Unknown,0000000077D67D8D Module(kernel32+0000000000027D8D)
07/08/2008 09:39:47,spid57,Unknown,* Short Stack Dump
07/08/2008 09:39:47,spid57,Unknown,* -------------------------------------------------------------------------------
07/08/2008 09:39:47,spid57,Unknown,* *******************************************************************************
07/08/2008 09:39:47,spid57,Unknown,* Rip: 0000000077D67D8D: C3000000C8C48148 15FF984B8D49D233 8699E990FFFD96DF 9090909090900000 834853C08B909090 0C0CEA158B4830EC
07/08/2008 09:39:47,spid57,Unknown,* R15: 0000000000000001:
07/08/2008 09:39:47,spid57,Unknown,* R14: 00000000123FD9C0: 00610063006F004C 006E006F00690074 002200200009003A 006E006100720078 0063002E00650067 003A002200700070
07/08/2008 09:39:47,spid57,Unknown,* R13: 000000011CF41F10: 000000011CF41F00 0000000000000000 0000000000000000 000000011CF41F28 000000011CF41F28 000000011CF41F38
07/08/2008 09:39:47,spid57,Unknown,* R12: 000000000000003F:
07/08/2008 09:39:47,spid57,Unknown,* R11: 00000000123FCB10: 0000000000000001 00000000123FC290 0000000000000000 0000000077EF40C2 0000000000001FA0 0000000000000000
07/08/2008 09:39:47,spid57,Unknown,* R10: 0000000000000000:
07/08/2008 09:39:47,spid57,Unknown,* R9: 0000000000000000:
07/08/2008 09:39:47,spid57,Unknown,* R8: 0000000000000000:
07/08/2008 09:39:47,spid57,Unknown,* Rdi: 000000011CF41F00: 000000011CF40B00 0000000000000000 000000011CF41F00 0000000000000000 0000000000000000 000000011CF41F28
07/08/2008 09:39:47,spid57,Unknown,* Rsi: 00000000123FC5D0: 00000000002BD850 0000000000000010 0000000000000000 0000000000000000 0000000000000000 0000000000000007
07/08/2008 09:39:47,spid57,Unknown,* Rbp: 00000000123FDA90: 000000000000018F 00000000DFD600F0 000003E500000001 0000000000000001 000000000000000A 0000000000000000
07/08/2008 09:39:47,spid57,Unknown,* Rsp: 00000000123FC320: 00000000002BD850 0000000000000000 00000000123FC5D0 000000011CF41F00 00000000000042AC 0000000000000000
07/08/2008 09:39:47,spid57,Unknown,* Rbx: 0000000000000000:
07/08/2008 09:39:47,spid57,Unknown,* Rdx: 0000000000000000:
07/08/2008 09:39:47,spid57,Unknown,* Rcx: 00000000123FBE40: 0000000000000001 00000000123FC290 0000000000000000 0000000077EF40C2 0000000000001FA0 0000000000000000
07/08/2008 09:39:47,spid57,Unknown,* Rax: 00000000123FC318: 0000000077D67D8D 00000000002BD850 0000000000000000 00000000123FC5D0 000000011CF41F00 00000000000042AC
07/08/2008 09:39:47,spid57,Unknown,* EFlags: 0000000000000202:
07/08/2008 09:39:47,spid57,Unknown,* SegSs: 000000000000002B:
07/08/2008 09:39:47,spid57,Unknown,* SegGs: 000000000000002B:
07/08/2008 09:39:47,spid57,Unknown,* SegFs: 0000000000000053:
07/08/2008 09:39:47,spid57,Unknown,* SegEs: 000000000000002B:
07/08/2008 09:39:47,spid57,Unknown,* SegDs: 000000000000002B:
07/08/2008 09:39:47,spid57,Unknown,* SegCs: 0000000000000033:
07/08/2008 09:39:47,spid57,Unknown,* MxCsr: 0000000000001FA0:
07/08/2008 09:39:47,spid57,Unknown,* ContextFlags: 000000000010000F:
07/08/2008 09:39:47,spid57,Unknown,* P6Home: 0000000000000000:
07/08/2008 09:39:47,spid57,Unknown,* P5Home: 0000000000001FA0:
07/08/2008 09:39:47,spid57,Unknown,* P4Home: 0000000077EF40C2: 00000320249C8B48 0000031824B48B48 0000031024BC8B48 0000030824A48B4C 0000030024AC8B4C 000002F824B48B4C
07/08/2008 09:39:47,spid57,Unknown,* P3Home: 0000000000000000:
07/08/2008 09:39:47,spid57,Unknown,* P2Home: 00000000123FC290: 0030003100460031 000000000000000A 0000000000000000 0000000000000000 FFFFFFFF00000030 0000000000000000
07/08/2008 09:39:47,spid57,Unknown,* P1Home: 0000000000000001:
07/08/2008 09:39:47,spid57,Unknown,*
07/08/2008 09:39:47,spid57,Unknown,* xplog70 0000000015220000 0000000015222FFF 00003000
07/08/2008 09:39:47,spid57,Unknown,* xplog70 0000000034730000 000000003473FFFF 00010000
07/08/2008 09:39:47,spid57,Unknown,* xpstar90 00000000151E0000 0000000015205FFF 00026000
07/08/2008 09:39:47,spid57,Unknown,* odbcint 000007FF63DC0000 000007FF63DD7FFF 00018000
07/08/2008 09:39:47,spid57,Unknown,* ATL80 000000007C630000 000000007C64EFFF 0001f000
07/08/2008 09:39:47,spid57,Unknown,* BatchParser90 00000000520C0000 00000000520ECFFF 0002d000
07/08/2008 09:39:47,spid57,Unknown,* ODBC32 000007FF63F00000 000007FF63F66FFF 00067000
07/08/2008 09:39:47,spid57,Unknown,* SQLSCM90 0000000053AD0000 0000000053ADBFFF 0000c000
07/08/2008 09:39:47,spid57,Unknown,* xpstar90 0000000053C30000 0000000053CB7FFF 00088000
07/08/2008 09:39:47,spid57,Unknown,* xpsqlbot 000000004A7C0000 000000004A7C7FFF 00008000
07/08/2008 09:39:47,spid57,Unknown,* msftepxy 0000000003790000 00000000037B0FFF 00021000
07/08/2008 09:39:47,spid57,Unknown,* SQLNCLIR 0000000035000000 0000000035032FFF 00033000
07/08/2008 09:39:47,spid57,Unknown,* comdlg32 000007FF7D540000 000007FF7D5B6FFF 00077000
07/08/2008 09:39:47,spid57,Unknown,* COMCTL32 000007FF76200000 000007FF762EEFFF 000ef000
07/08/2008 09:39:47,spid57,Unknown,* sqlncli 00000000337A0000 0000000033A5FFFF 002c0000
07/08/2008 09:39:47,spid57,Unknown,* CLBCatQ 000007FF7EA10000 000007FF7EAEDFFF 000de000
07/08/2008 09:39:47,spid57,Unknown,* xpsp2res 0000000010930000 0000000010BF6FFF 002c7000
07/08/2008 09:39:47,spid57,Unknown,* ntdsapi 000007FF7DCB0000 000007FF7DCD3FFF 00024000
07/08/2008 09:39:47,spid57,Unknown,* SAMLIB 000007FF77150000 000007FF77165FFF 00016000
07/08/2008 09:39:47,spid57,Unknown,* NTMARTA 000007FF7E4C0000 000007FF7E4FBFFF 0003c000
07/08/2008 09:39:47,spid57,Unknown,* wshtcpip 000007FF77170000 000007FF7717AFFF 0000b000
07/08/2008 09:39:47,spid57,Unknown,* hnetcfg 000007FF6D200000 000007FF6D292FFF 00093000
07/08/2008 09:39:47,spid57,Unknown,* dssenh 0000000068100000 000000006813EFFF 0003f000
07/08/2008 09:39:47,spid57,Unknown,* imagehlp 000007FF7E470000 000007FF7E482FFF 00013000
07/08/2008 09:39:47,spid57,Unknown,* WINTRUST 000007FF7E3E0000 000007FF7E42DFFF 0004e000
07/08/2008 09:39:47,spid57,Unknown,* dbghelp 000000000FE50000 000000000FFACFFF 0015d000
07/08/2008 09:39:47,spid57,Unknown,* msfte 0000000049980000 0000000049D2DFFF 003ae000
07/08/2008 09:39:47,spid57,Unknown,* security 000007FF77530000 000007FF77534FFF 00005000
07/08/2008 09:39:47,spid57,Unknown,* rasadhlp 000007FF7EA00000 000007FF7EA06FFF 00007000
07/08/2008 09:39:47,spid57,Unknown,* WLDAP32 000007FF7E950000 000007FF7E9B5FFF 00066000
07/08/2008 09:39:47,spid57,Unknown,* winrnr 000007FF7E9F0000 000007FF7E9FAFFF 0000b000
07/08/2008 09:39:47,spid57,Unknown,* DNSAPI 000007FF7E8F0000 000007FF7E93DFFF 0004e000
07/08/2008 09:39:47,spid57,Unknown,* RESUTILS 000007FF7B310000 000007FF7B32BFFF 0001c000
07/08/2008 09:39:47,spid57,Unknown,* CLUSAPI 000007FF7B3A0000 000007FF7B3C3FFF 00024000
07/08/2008 09:39:47,spid57,Unknown,* WSOCK32 000007FF770F0000 000007FF770F9FFF 0000a000
07/08/2008 09:39:47,spid57,Unknown,* VERSION 000007FF7FBF0000 000007FF7FBFAFFF 0000b000
07/08/2008 09:39:47,spid57,Unknown,* MTXCLU 000007FF7B540000 000007FF7B569FFF 0002a000
07/08/2008 09:39:47,spid57,Unknown,* msvcp60 000000000D980000 000000000DA69FFF 000ea000
07/08/2008 09:39:47,spid57,Unknown,* OLEAUT32 000007FF7EBC0000 000007FF7ECD5FFF 00116000
07/08/2008 09:39:47,spid57,Unknown,* MSDTCPRX 000007FF67140000 000007FF67213FFF 000d4000
07/08/2008 09:39:47,spid57,Unknown,* XOLEHLP 000007FF5C5B0000 000007FF5C5B6FFF 00007000
07/08/2008 09:39:47,spid57,Unknown,* COMRES 000007FF7EAF0000 000007FF7EBB5FFF 000c6000
07/08/2008 09:39:47,spid57,Unknown,* schannel 000007FF7DD50000 000007FF7DD90FFF 00041000
07/08/2008 09:39:47,spid57,Unknown,* cryptdll 000007FF7DC90000 000007FF7DC9EFFF 0000f000
07/08/2008 09:39:47,spid57,Unknown,* kerberos 000007FF77410000 000007FF774C3FFF 000b4000
07/08/2008 09:39:47,spid57,Unknown,* iphlpapi 000007FF57040000 000007FF57070FFF 00031000
07/08/2008 09:39:47,spid57,Unknown,* msv1_0 000007FF7E500000 000007FF7E543FFF 00044000
07/08/2008 09:39:47,spid57,Unknown,* ole32 000007FF57140000 000007FF573C4FFF 00285000
07/08/2008 09:39:47,spid57,Unknown,* MSCOREE 000006427EE60000 000006427EED3FFF 00074000
07/08/2008 09:39:47,spid57,Unknown,* AUTHZ 000007FF7E490000 000007FF7E4BDFFF 0002e000
07/08/2008 09:39:47,spid57,Unknown,* rsaenh 0000000068000000 000000006804BFFF 0004c000
07/08/2008 09:39:47,spid57,Unknown,* SQLOS 00000000344D0000 00000000344D5FFF 00006000
07/08/2008 09:39:47,spid57,Unknown,* sqlevn70 000000004F610000 000000004F7B8FFF 001a9000
07/08/2008 09:39:47,spid57,Unknown,* instapi 0000000048060000 000000004806CFFF 0000d000
07/08/2008 09:39:47,spid57,Unknown,* psapi 000007FF7E380000 000007FF7E38FFFF 00010000
07/08/2008 09:39:47,spid57,Unknown,* comctl32 000007FF7F000000 000007FF7F186FFF 00187000
07/08/2008 09:39:47,spid57,Unknown,* IMM32 000007FF7D500000 000007FF7D538FFF 00039000
07/08/2008 09:39:47,spid57,Unknown,* SHLWAPI 000007FF7EF60000 000007FF7EFFAFFF 0009b000
07/08/2008 09:39:47,spid57,Unknown,* SHELL32 000007FF7F190000 000007FF7FB9AFFF 00a0b000
07/08/2008 09:39:47,spid57,Unknown,* NETAPI32 000007FF77370000 000007FF77407FFF 00098000
07/08/2008 09:39:47,spid57,Unknown,* opends60 00000000333E0000 00000000333E7FFF 00008000
07/08/2008 09:39:47,spid57,Unknown,* USERENV 000007FF7C680000 000007FF7C789FFF 0010a000
07/08/2008 09:39:47,spid57,Unknown,* WS2HELP 000007FF77140000 000007FF7714BFFF 0000c000
07/08/2008 09:39:47,spid57,Unknown,* WS2_32 000007FF77310000 000007FF7733FFFF 00030000
07/08/2008 09:39:47,spid57,Unknown,* MSWSOCK 000007FF771B0000 000007FF7722CFFF 0007d000
07/08/2008 09:39:47,spid57,Unknown,* MSASN1 000007FF7D340000 000007FF7D369FFF 0002a000
07/08/2008 09:39:47,spid57,Unknown,* CRYPT32 000007FF7D370000 000007FF7D4CEFFF 0015f000
07/08/2008 09:39:47,spid57,Unknown,* GDI32 000007FF7FC90000 000007FF7FD2BFFF 0009c000
07/08/2008 09:39:47,spid57,Unknown,* USER32 0000000077C20000 0000000077D2BFFF 0010c000
07/08/2008 09:39:47,spid57,Unknown,* Secur32 000007FF7E9C0000 000007FF7E9E1FFF 00022000
07/08/2008 09:39:47,spid57,Unknown,* RPCRT4 000007FF7FD30000 000007FF7FEC8FFF 00199000
07/08/2008 09:39:47,spid57,Unknown,* ADVAPI32 000007FF7FEE0000 000007FF7FFE4FFF 00105000
07/08/2008 09:39:47,spid57,Unknown,* MSVCP80 000000007C420000 000000007C528FFF 00109000
07/08/2008 09:39:47,spid57,Unknown,* msvcrt 000007FF7FC00000 000007FF7FC85FFF 00086000
07/08/2008 09:39:47,spid57,Unknown,* MSVCR80 0000000078130000 00000000781F8FFF 000c9000
07/08/2008 09:39:47,spid57,Unknown,* kernel32 0000000077D40000 0000000077EB2FFF 00173000
07/08/2008 09:39:47,spid57,Unknown,* ntdll 0000000077EC0000 0000000077FF8FFF 00139000
07/08/2008 09:39:47,spid57,Unknown,* sqlservr 0000000001000000 0000000003645FFF 02646000
07/08/2008 09:39:47,spid57,Unknown,* MODULE BASE END SIZE
07/08/2008 09:39:47,spid57,Unknown,*
07/08/2008 09:39:47,spid57,Unknown,*
07/08/2008 09:39:47,spid57,Unknown,* [CO].[BI__ID] ASC
07/08/2008 09:39:47,spid57,Unknown,* idt.[CO_GID_ID] = [CO].[GID_ID] ORDER BY [CO].[TXT_CompanyName] DESC
07/08/2008 09:39:47,spid57,Unknown,* yName' [CO].[BI__ID] AS 'BI__ID' FROM [CO] JOIN @tIDTable idt ON
07/08/2008 09:39:47,spid57,Unknown,* LECT [CO].[GID_ID] AS 'GID_ID' [CO].[TXT_CompanyName] AS 'TXT_Compan
07/08/2008 09:39:47,spid57,Unknown,* roquip')) ORDER BY [CO].[TXT_CompanyName] DESC [CO].[BI__ID] ASC SE
07/08/2008 09:39:47,spid57,Unknown,* = 'Groquip' AND [CO].[BI__ID] >= 19322) OR ([CO].[TXT_CompanyName] < 'G
07/08/2008 09:39:47,spid57,Unknown,* = 'ebdd848a-3c95-4d6e-5553-9a8d01271063'))) AND (([CO].[TXT_CompanyName]
07/08/2008 09:39:47,spid57,Unknown,* hareState] < 2 OR [CO].[SI__ShareState] IS NULL) AND [US00001].[GID_ID]
07/08/2008 09:39:47,spid57,Unknown,* mpanyName] >= 'Groquip') AND ([CO].[SI__ShareState] = 2 OR (([CO].[SI__S
07/08/2008 09:39:47,spid57,Unknown,* 1] ON [US00001].[GID_ID] = [CO].[GID_CreatedBy_US] WHERE (([CO].[TXT_Co
07/08/2008 09:39:47,spid57,Unknown,* CO].[TXT_CompanyName] [CO].[BI__ID] FROM [CO] LEFT JOIN [US] [US0000
07/08/2008 09:39:47,spid57,Unknown,* ] [
07/08/2008 09:39:47,spid57,Unknown,* INSERT INTO @tIDTable([CO_GID_ID] [CO_TXT_CompanyName
07/08/2008 09:39:47,spid57,Unknown,* har(300) [CO_BI__ID] bigint)
07/08/2008 09:39:47,spid57,Unknown,* @tIDTable TABLE( [CO_GID_ID] uniqueidentifier [CO_SYS_NAME] nvarc
07/08/2008 09:39:47,spid57,Unknown,* DECLARE @tManyLinkList TABLE(LinkName nvarchar(100)) DECLARE
07/08/2008 09:39:47,spid57,Unknown,* Input Buffer 510 bytes -
07/08/2008 09:39:47,spid57,Unknown,*
07/08/2008 09:39:47,spid57,Unknown,* Process ID: 1528
07/08/2008 09:39:47,spid57,Unknown,* SPID: 57
07/08/2008 09:39:47,spid57,Unknown,* Expression: 0 == pxteRangeHrow->m_pxteFetch
07/08/2008 09:39:47,spid57,Unknown,* Location: "xrange.cpp":399
07/08/2008 09:39:47,spid57,Unknown,*
07/08/2008 09:39:47,spid57,Unknown,* 07/08/08 09:39:47 spid 57
07/08/2008 09:39:47,spid57,Unknown,* BEGIN STACK DUMP:
07/08/2008 09:39:47,spid57,Unknown,*
07/08/2008 09:39:47,spid57,Unknown,* *******************************************************************************
07/08/2008 09:39:47,spid57,Unknown,***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0080.txt
07/08/2008 09:39:47,spid57,Unknown,**Dump thread - spid = 57 EC = 0x000000011CF41F10
07/08/2008 09:39:47,spid57,Unknown,Using 'dbghelp.dll' version '4.0.5'
and finally here is the error the application throws:
DTT_CREATIONTIMETXT_MODULETXT_MESSAGE
2008-07-08|09:39clRowset::GetDataProceedure: clRowset::GetData Number: 45100 Message: Unable to process data request. Exception info: System.Data.SqlClient.SqlException: A system assertion check has failed. Check the SQL Server error log for details. Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB. If you agreed to send dumps to Microsoft during setup, a mini dump will be sent to Microsoft. An update might be available from Microsoft in the latest Service Pack or in a QFE from Technical Support. A severe error occurred on the current command. The results, if any, should be discarded. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at clRowSet.GetData(String SelectStatement)
I cannot figure out what is going on, its an intermittent error on the web application. Is it the application or sql? Why would it start now when moving to a new server and in 80 compatibility mode.
'nix
July 9, 2008 at 8:37 am
Have you run DBCC CHECKDB to see what it reports? Did you run the upgrade advisor to see if it could identify any potential problems? Do you have any *= or =* joins in your old code?
July 9, 2008 at 11:12 am
DBCC CheckDb comes back clean and as far as I know there are no non ansi joins in the code. The difficutly is that the entire app consists of dynamically created sql statements thus making debugging near impossible. Profiler does not pick up the SQL code that errors out which I dont understand at all.
Even though DBCC Checkdb came back clean I rebuilt all of the indexes last night and the error has not reoccured since. Its WAY to early to call it fixed as I stated previously its an intermittent error. I've gone an entire day without being able to recreate it. Everyone I've had test it in the office today reports it working so it might have been some corruption in an index that checkdb did not report.
I have another question for you though as it relates to the sql upgrade advisor. I did get an advisory regarding aliases that I dont understand in the context of the stored proc it referenced. Take a look at this:
BEGIN
-- Return all global records, with local values if equivalent local records exist
SELECT
g.TXT_Property,
COALESCE(u.TXT_Value, g.TXT_Value) AS TXT_Value
FROM XP g
LEFT JOIN XP u ON u.TXT_Page = g.TXT_Page AND u.TXT_Property = g.TXT_Property AND u.GID_Section = @uSection
WHERE g.GID_Section IS NULL AND g.TXT_Page = @sPage
UNION
-- Merge all local records and remove duplicates
SELECT
g.TXT_Property,
g.TXT_Value
FROM XP g
WHERE g.GID_Section = @uSection AND g.TXT_Page = @sPage
ORDER BY g.TXT_Property, g.TXT_Value
END
END
This looks to me like its aliasing the same table inside the union. How can you do a union to the same table using the same alias? I would think you would have to use different aliases to reference the same table in a union. This portion of code exists inside several stored procs in the database but the upgrade advisor only references this one with the "error"
Column prefixes in the order by clause cannot be prefixed by table aliases.
I dont see column prefixes prefixed by table aliases here but dont know how this code could be working though it does. Could you explain?
'nix
July 9, 2008 at 11:20 am
After upgrading the Databases:
1. Change the Compatiility Level to 90
2. DBCC UPDATEUSAGE
3. DBCC CHECKDB (DatabaseName)
4. Copy all the logins associated with the Database OR ALL using this Scripts from MICROSOFT. http://support.microsoft.com/kb/246133
5. use databasename
sp_change_users_login 'Report'
which will give you the list of all orphaned users in the database. if you find any...
sp_change_users_login 'update_one','loginname','loginname' to correct the Login mapping
If the CHECKDb Doesnot Throw any errors:
DBCC CHECKDB (databasename) WITH NO_INFOMSGS, ALL_ERRORMSGS
Maninder
www.dbanation.com
July 9, 2008 at 11:30 am
I would suggest calling MS's customer support people. This kind of error is very hard for us to help you with. (details here - http://support.microsoft.com/kb/295539)
Logging a call does cost, but I believe the fee is waived if the cause is a SQL bug.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 9, 2008 at 11:47 am
You should run UPDATE STATISTICS tblname WITH FULLSCAN on all your tables and try to rebuild all indexes.
* Noel
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply