October 10, 2007 at 5:52 am
Hi,
I noted some strange errors on my server log (SQL 2005):
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
Date,Source,Severity,Message
10/02/2007 09:15:24,Server,Unknown,A user request from the session with SPID 191 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.
10/02/2007 09:15:24,Server,Unknown,Error: 17310 State: 1.
10/02/2007 09:15:24,spid191,Unknown,External dump process return code 0x20000001. External dump process returned no errors.
10/02/2007 09:15:23,spid191,Unknown,Stack Signature for the dump is 0x724D13B0
10/02/2007 09:15:23,spid191,Unknown,78132A36 Module(MSVCR80+00002A36)
10/02/2007 09:15:23,spid191,Unknown,781329AA Module(MSVCR80+000029AA)
10/02/2007 09:15:23,spid191,Unknown,010D83F0 Module(sqlservr+000D83F0)
10/02/2007 09:15:23,spid191,Unknown,010D746E Module(sqlservr+000D746E)
10/02/2007 09:15:23,spid191,Unknown,010D7B71 Module(sqlservr+000D7B71)
10/02/2007 09:15:23,spid191,Unknown,010D764A Module(sqlservr+000D764A)
10/02/2007 09:15:23,spid191,Unknown,010086E7 Module(sqlservr+000086E7)
10/02/2007 09:15:23,spid191,Unknown,010089C5 Module(sqlservr+000089C5)
10/02/2007 09:15:23,spid191,Unknown,0100889F Module(sqlservr+0000889F)
10/02/2007 09:15:23,spid191,Unknown,01041C35 Module(sqlservr+00041C35)
10/02/2007 09:15:23,spid191,Unknown,010438E5 Module(sqlservr+000438E5)
10/02/2007 09:15:23,spid191,Unknown,0102C5F8 Module(sqlservr+0002C5F8)
10/02/2007 09:15:23,spid191,Unknown,011D37E7 Module(sqlservr+001D37E7)
10/02/2007 09:15:23,spid191,Unknown,01BDBEB6 Module(sqlservr+00BDBEB6)
10/02/2007 09:15:23,spid191,Unknown,013C6DB8 Module(sqlservr+003C6DB8)
10/02/2007 09:15:23,spid191,Unknown,01C11D65 Module(sqlservr+00C11D65)
10/02/2007 09:15:23,spid191,Unknown,0102C5F8 Module(sqlservr+0002C5F8)
10/02/2007 09:15:23,spid191,Unknown,011D37E7 Module(sqlservr+001D37E7)
10/02/2007 09:15:23,spid191,Unknown,01BDBEB6 Module(sqlservr+00BDBEB6)
10/02/2007 09:15:23,spid191,Unknown,0103D0C6 Module(sqlservr+0003D0C6)
10/02/2007 09:15:23,spid191,Unknown,0103D23D Module(sqlservr+0003D23D)
10/02/2007 09:15:23,spid191,Unknown,0103D2FE Module(sqlservr+0003D2FE)
10/02/2007 09:15:23,spid191,Unknown,0103D441 Module(sqlservr+0003D441)
10/02/2007 09:15:23,spid191,Unknown,010784B4 Module(sqlservr+000784B4)
10/02/2007 09:15:23,spid191,Unknown,01E22809 Module(sqlservr+00E22809)
10/02/2007 09:15:23,spid191,Unknown,01E28713 Module(sqlservr+00E28713)
10/02/2007 09:15:23,spid191,Unknown,01E15AA8 Module(sqlservr+00E15AA8)
10/02/2007 09:15:23,spid191,Unknown,01E15B68 Module(sqlservr+00E15B68)
10/02/2007 09:15:23,spid191,Unknown,0102E827 Module(sqlservr+0002E827)
10/02/2007 09:15:23,spid191,Unknown,019E9DEB Module(sqlservr+009E9DEB)
10/02/2007 09:15:23,spid191,Unknown,01DA687B Module(sqlservr+00DA687B)
10/02/2007 09:15:23,spid191,Unknown,01DA9914 Module(sqlservr+00DA9914)
10/02/2007 09:15:23,spid191,Unknown,010D3CAC Module(sqlservr+000D3CAC)
10/02/2007 09:15:23,spid191,Unknown,010040C2 Module(sqlservr+000040C2)
10/02/2007 09:15:23,spid191,Unknown,01002C90 Module(sqlservr+00002C90)
10/02/2007 09:15:23,spid191,Unknown,* Short Stack Dump
10/02/2007 09:15:23,spid191,Unknown,* -------------------------------------------------------------------------------
10/02/2007 09:15:23,spid191,Unknown,* *******************************************************************************
10/02/2007 09:15:23,spid191,Unknown,* SegSs: 0000002B:
10/02/2007 09:15:23,spid191,Unknown,* Esp: 1054EBAC: 00000038 C02280E8 00000001 00000000 00000000 1054EBE4
10/02/2007 09:15:23,spid191,Unknown,* EFlags: 00010246: 0057005C 004E0049 004F0044 00530057 0073005C 00730079
10/02/2007 09:15:23,spid191,Unknown,* SegCs: 00000023:
10/02/2007 09:15:23,spid191,Unknown,* Ebp: 1054EBC0: 1054EBE4 010040C2 0000096C FFFFFFFF 1054EC10 00000000
10/02/2007 09:15:23,spid191,Unknown,* Eip: 01002C90: 0AB10FF0 850FC085 0005BAD0 0F003B83 0013C685 0C7D8300
10/02/2007 09:15:23,spid191,Unknown,* Edx: 00000028:
10/02/2007 09:15:23,spid191,Unknown,* Ecx: 0000096C:
10/02/2007 09:15:23,spid191,Unknown,* Ebx: 00000020:
10/02/2007 09:15:23,spid191,Unknown,* Eax: 00000000:
10/02/2007 09:15:23,spid191,Unknown,* Esi: C02280E8: 00000000 00000000 BAA660F0 CF2BC0F0 00000001 009C61F0
10/02/2007 09:15:23,spid191,Unknown,* Edi: 00000028:
10/02/2007 09:15:23,spid191,Unknown,*
10/02/2007 09:15:23,spid191,Unknown,* dbghelp 0D190000 0D2A7FFF 00118000
10/02/2007 09:15:23,spid191,Unknown,* MSVCR71 7C340000 7C395FFF 00056000
10/02/2007 09:15:23,spid191,Unknown,* XPMetaphone 0DD00000 0DD07FFF 00008000
10/02/2007 09:15:23,spid191,Unknown,* xplog70 0DE00000 0DE02FFF 00003000
10/02/2007 09:15:23,spid191,Unknown,* xplog70 0DD20000 0DD2BFFF 0000c000
10/02/2007 09:15:23,spid191,Unknown,* xpsqlbot 0EA50000 0EA55FFF 00006000
10/02/2007 09:15:23,spid191,Unknown,* xpstar90 0DC00000 0DC25FFF 00026000
10/02/2007 09:15:23,spid191,Unknown,* SQLSVC90 0DBF0000 0DBF2FFF 00003000
10/02/2007 09:15:23,spid191,Unknown,* odbcint 0DBD0000 0DBE6FFF 00017000
10/02/2007 09:15:23,spid191,Unknown,* ATL80 7C630000 7C64AFFF 0001b000
10/02/2007 09:15:23,spid191,Unknown,* SqlResourceLoader 0D8F0000 0D8F5FFF 00006000
10/02/2007 09:15:23,spid191,Unknown,* SQLSVC90 0D8C0000 0D8D9FFF 0001a000
10/02/2007 09:15:23,spid191,Unknown,* BatchParser90 0D890000 0D8ADFFF 0001e000
10/02/2007 09:15:23,spid191,Unknown,* ODBC32 0D850000 0D88CFFF 0003d000
10/02/2007 09:15:23,spid191,Unknown,* SQLSCM90 0D830000 0D838FFF 00009000
10/02/2007 09:15:23,spid191,Unknown,* xpstar90 0D7D0000 0D814FFF 00045000
10/02/2007 09:15:23,spid191,Unknown,* msxml3 72E50000 72F61FFF 00112000
10/02/2007 09:15:23,spid191,Unknown,* msxml2 0B7E0000 0B88EFFF 000af000
10/02/2007 09:15:23,spid191,Unknown,* msxmlsql 78800000 788DEFFF 000df000
10/02/2007 09:15:23,spid191,Unknown,* msftepxy 09790000 097A4FFF 00015000
10/02/2007 09:15:23,spid191,Unknown,* SQLNCLIR 095D0000 09602FFF 00033000
10/02/2007 09:15:23,spid191,Unknown,* comdlg32 762B0000 762F9FFF 0004a000
10/02/2007 09:15:23,spid191,Unknown,* COMCTL32 77530000 775C6FFF 00097000
10/02/2007 09:15:23,spid191,Unknown,* sqlncli 337A0000 339BDFFF 0021e000
10/02/2007 09:15:23,spid191,Unknown,* CLBCatQ 777B0000 77832FFF 00083000
10/02/2007 09:15:23,spid191,Unknown,* xpsp2res 10000000 102C4FFF 002c5000
10/02/2007 09:15:23,spid191,Unknown,* ntdsapi 766F0000 76704FFF 00015000
10/02/2007 09:15:23,spid191,Unknown,* SAMLIB 094A0000 094AEFFF 0000f000
10/02/2007 09:15:23,spid191,Unknown,* NTMARTA 77E00000 77E21FFF 00022000
10/02/2007 09:15:23,spid191,Unknown,* dssenh 094B0000 094D3FFF 00024000
10/02/2007 09:15:23,spid191,Unknown,* imagehlp 76C10000 76C38FFF 00029000
10/02/2007 09:15:23,spid191,Unknown,* WINTRUST 76BB0000 76BDAFFF 0002b000
10/02/2007 09:15:23,spid191,Unknown,* dbghelp 09130000 09247FFF 00118000
10/02/2007 09:15:23,spid191,Unknown,* msfte 08ED0000 09127FFF 00258000
10/02/2007 09:15:23,spid191,Unknown,* security 71F60000 71F63FFF 00004000
10/02/2007 09:15:23,spid191,Unknown,* rasadhlp 76F80000 76F84FFF 00005000
10/02/2007 09:15:23,spid191,Unknown,* wshtcpip 07DB0000 07DB7FFF 00008000
10/02/2007 09:15:23,spid191,Unknown,* hnetcfg 07D10000 07D68FFF 00059000
10/02/2007 09:15:23,spid191,Unknown,* WLDAP32 76F10000 76F3DFFF 0002e000
10/02/2007 09:15:23,spid191,Unknown,* winrnr 76F70000 76F76FFF 00007000
10/02/2007 09:15:23,spid191,Unknown,* DNSAPI 76ED0000 76EF8FFF 00029000
10/02/2007 09:15:23,spid191,Unknown,* WSOCK32 07AD0000 07AD8FFF 00009000
10/02/2007 09:15:23,spid191,Unknown,* VERSION 77B90000 77B97FFF 00008000
10/02/2007 09:15:23,spid191,Unknown,* MTXCLU 74F40000 74F58FFF 00019000
10/02/2007 09:15:23,spid191,Unknown,* msvcp60 07A60000 07AC4FFF 00065000
10/02/2007 09:15:23,spid191,Unknown,* MSDTCPRX 079E0000 07A57FFF 00078000
10/02/2007 09:15:23,spid191,Unknown,* XOLEHLP 079D0000 079D5FFF 00006000
10/02/2007 09:15:23,spid191,Unknown,* COMRES 77010000 770D5FFF 000c6000
10/02/2007 09:15:23,spid191,Unknown,* schannel 76750000 76776FFF 00027000
10/02/2007 09:15:23,spid191,Unknown,* cryptdll 766E0000 766EBFFF 0000c000
10/02/2007 09:15:23,spid191,Unknown,* Kerberos 71CA0000 71CF7FFF 00058000
10/02/2007 09:15:23,spid191,Unknown,* iphlpapi 76CF0000 76D09FFF 0001a000
10/02/2007 09:15:23,spid191,Unknown,* msv1_0 76C90000 76CB6FFF 00027000
10/02/2007 09:15:23,spid191,Unknown,* msnsspc 71E20000 71E6FFFF 00050000
10/02/2007 09:15:23,spid191,Unknown,* MSVCRT40 78080000 78090FFF 00011000
10/02/2007 09:15:23,spid191,Unknown,* msapsspc 71E00000 71E13FFF 00014000
10/02/2007 09:15:23,spid191,Unknown,* MSCOREE 79000000 79044FFF 00045000
10/02/2007 09:15:23,spid191,Unknown,* AUTHZ 76C40000 76C53FFF 00014000
10/02/2007 09:15:23,spid191,Unknown,* rsaenh 06450000 0647EFFF 0002f000
10/02/2007 09:15:23,spid191,Unknown,* SQLOS 344D0000 344D4FFF 00005000
10/02/2007 09:15:23,spid191,Unknown,* sqlevn70 4F610000 4F7A0FFF 00191000
10/02/2007 09:15:23,spid191,Unknown,* RESUTILS 74EF0000 74F02FFF 00013000
10/02/2007 09:15:23,spid191,Unknown,* OLEAUT32 77D00000 77D8BFFF 0008c000
10/02/2007 09:15:23,spid191,Unknown,* ole32 77670000 777A3FFF 00134000
10/02/2007 09:15:23,spid191,Unknown,* CLUSAPI 74DE0000 74DF1FFF 00012000
10/02/2007 09:15:23,spid191,Unknown,* instapi 48060000 48069FFF 0000a000
10/02/2007 09:15:23,spid191,Unknown,* psapi 76B70000 76B7AFFF 0000b000
10/02/2007 09:15:23,spid191,Unknown,* comctl32 7DBD0000 7DCD2FFF 00103000
10/02/2007 09:15:23,spid191,Unknown,* SHLWAPI 77DA0000 77DF1FFF 00052000
10/02/2007 09:15:23,spid191,Unknown,* SHELL32 7C8D0000 7D0D2FFF 00803000
10/02/2007 09:15:23,spid191,Unknown,* NETAPI32 71C40000 71C97FFF 00058000
10/02/2007 09:15:23,spid191,Unknown,* opends60 333E0000 333E6FFF 00007000
10/02/2007 09:15:23,spid191,Unknown,* USERENV 76920000 769E3FFF 000c4000
10/02/2007 09:15:23,spid191,Unknown,* WS2HELP 71BF0000 71BF7FFF 00008000
10/02/2007 09:15:23,spid191,Unknown,* WS2_32 71C00000 71C16FFF 00017000
10/02/2007 09:15:23,spid191,Unknown,* MSWSOCK 7DB30000 7DBAFFFF 00080000
10/02/2007 09:15:23,spid191,Unknown,* Secur32 7D8D0000 7D91FFFF 00050000
10/02/2007 09:15:23,spid191,Unknown,* MSASN1 76190000 761A1FFF 00012000
10/02/2007 09:15:23,spid191,Unknown,* CRYPT32 761B0000 76242FFF 00093000
10/02/2007 09:15:23,spid191,Unknown,* GDI32 7D800000 7D88FFFF 00090000
10/02/2007 09:15:23,spid191,Unknown,* USER32 7D930000 7D9FFFFF 000d0000
10/02/2007 09:15:23,spid191,Unknown,* RPCRT4 7DA20000 7DAFFFFF 000e0000
10/02/2007 09:15:23,spid191,Unknown,* ADVAPI32 77F50000 77FEBFFF 0009c000
10/02/2007 09:15:23,spid191,Unknown,* MSVCP80 7C420000 7C4A6FFF 00087000
10/02/2007 09:15:23,spid191,Unknown,* msvcrt 77BA0000 77BF9FFF 0005a000
10/02/2007 09:15:23,spid191,Unknown,* MSVCR80 78130000 781CAFFF 0009b000
10/02/2007 09:15:23,spid191,Unknown,* kernel32 7D4C0000 7D5EFFFF 00130000
10/02/2007 09:15:23,spid191,Unknown,* ntdll 7D600000 7D6EFFFF 000f0000
10/02/2007 09:15:23,spid191,Unknown,* sqlservr 01000000 02BA7FFF 01ba8000
10/02/2007 09:15:23,spid191,Unknown,* MODULE BASE END SIZE
10/02/2007 09:15:23,spid191,Unknown,*
10/02/2007 09:15:23,spid191,Unknown,*
10/02/2007 09:15:23,spid191,Unknown,* TableConfig where number = 186
10/02/2007 09:15:23,spid191,Unknown,* 4240-8be7-b3e5e3a0398e";Local Database="db_name"select val from dbo.Tab
10/02/2007 09:15:23,spid191,Unknown,* c8faa7889b9e53cd3d8bÆService="SqlQueryNotificationService-70595aa0-5133-
10/02/2007 09:15:23,spid191,Unknown,* Ū š180f615b-9449-472b-bea0-64a372ffd178;c39a6e91984467e28bf6
10/02/2007 09:15:23,spid191,Unknown,* Input Buffer 496 bytes -
10/02/2007 09:15:23,spid191,Unknown,* Access Violation occurred writing address 00000028
10/02/2007 09:15:23,spid191,Unknown,* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
10/02/2007 09:15:23,spid191,Unknown,* Exception Address = 01002C90 Module(sqlservr+00002C90)
10/02/2007 09:15:23,spid191,Unknown,*
10/02/2007 09:15:23,spid191,Unknown,*
10/02/2007 09:15:23,spid191,Unknown,* 10/02/07 09:15:23 spid 191
10/02/2007 09:15:23,spid191,Unknown,* BEGIN STACK DUMP:
10/02/2007 09:15:23,spid191,Unknown,*
10/02/2007 09:15:23,spid191,Unknown,* *******************************************************************************
10/02/2007 09:15:23,spid191,Unknown,SqlDumpExceptionHandler: Process 191 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
10/02/2007 09:15:23,spid191,Unknown,***Stack Dump being sent to d:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump2875.txt
10/02/2007 09:15:22,spid191,Unknown,Using 'dbghelp.dll' version '4.0.5'
10/02/2007 09:14:47,Server,Unknown,A user request from the session with SPID 243 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.
10/02/2007 09:14:47,Server,Unknown,Error: 17310 State: 1.
10/02/2007 09:14:47,spid243,Unknown,External dump process return code 0x20000001. External dump process returned no errors.
10/02/2007 09:14:46,spid243,Unknown,Stack Signature for the dump is 0x724D13B0
10/02/2007 09:14:46,spid243,Unknown,78132A36 Module(MSVCR80+00002A36)
10/02/2007 09:14:46,spid243,Unknown,781329AA Module(MSVCR80+000029AA)
10/02/2007 09:14:46,spid243,Unknown,010D83F0 Module(sqlservr+000D83F0)
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
Could somebody explain me what may cause this error and how repair this, please.
--
Regards,
anxcomp
October 10, 2007 at 6:18 am
the black box trace may help for the future , but you'd need some way of recording spids vs users. You could ask your users or see if the host name is in the errorlog. It's always very difficult after the event.
You could also raise an incident with microsoft.
If the user who got the error message will own up then you could ask them what they were doing - that's really your best bet I've found without going to microsoft.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
October 10, 2007 at 6:56 am
I tray DBCC CHECKDB but DBCC CHECK doesn't return any errors now, but in past was problem with one database:
------------------------------------------------------------------------------------------------------------------------------------------------------
Incorrect PFS free space information for page (1:537) in object ID 60,
index ID 1, partition ID 281474980642816, alloc unit ID 71776119065149440 (type LOB data).
Expected value 0_PCT_FULL, actual value 100_PCT_FULL.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'sys.sysobjvalues' (object ID 60).
CHECKDB found 0 allocation errors and 1 consistency errors in database 'db_name'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (db_name).
------------------------------------------------------------------------------------------------------------------------------------------------------
so I run
dbcc checkdb ('db_name', repair_allow_data_loss)
with
no_infomsgs
and received:
------------------------------------------------------------------------------------------------------------------------------------------------------
Msg 8914, Level 16, State 1, Line 1
Incorrect PFS free space information for page (1:537) in object ID 60, index ID 1,
partition ID 281474980642816, alloc unit ID 71776119065149440 (type LOB data). Expected value
0_PCT_FULL, actual value 100_PCT_FULL.
The error has been repaired.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'sys.sysobjvalues' (object ID 60).
CHECKDB fixed 0 allocation errors and 1 consistency errors in table 'sys.sysobjvalues' (object ID 60).
CHECKDB found 0 allocation errors and 1 consistency errors in database 'db_nameToRepair'.
CHECKDB fixed 0 allocation errors and 1 consistency errors in database 'db_nameToRepair'.
------------------------------------------------------------------------------------------------------------------------------------------------------
Error gone but errors from first message probably appear after that dbcc checkdb ('db_name', repair_allow_data_loss), I'm not sure.
Does somebody know how resolve this problem, please?
--
Regards,
anxcomp
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply