August 25, 2011 at 12:48 am
Hi all,
In my production Server getting following error:- Stack Dump
we are using SQL Server 2005-64 bit
windows server- Windows Datacenter Edition
SQL Service pack:- SP2
kindly give solution for this error.................
2011-08-24 18:14:26.880 spid120 ***Stack Dump being sent to D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0011.txt
2011-08-24 18:14:26.890 spid120 SqlDumpExceptionHandler: Process 120 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
2011-08-24 18:14:26.890 spid120 * *******************************************************************************
2011-08-24 18:14:26.890 spid120 *
2011-08-24 18:14:26.890 spid120 * BEGIN STACK DUMP:
2011-08-24 18:14:26.890 spid120 * 08/24/11 18:14:26 spid 120
2011-08-24 18:14:26.890 spid120 *
2011-08-24 18:14:26.890 spid120 *
2011-08-24 18:14:26.890 spid120 * Exception Address = 00000000010E6BD0 Module(sqlservr+00000000000E6BD0)
2011-08-24 18:14:26.890 spid120 * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
2011-08-24 18:14:26.890 spid120 * Access Violation occurred writing address 0000000000000009
2011-08-24 18:14:26.890 spid120 * Input Buffer 258 bytes -
2011-08-24 18:14:26.890 spid120 * alDt = getdate(), CHQ_TPFLAG = 'NO' WHERE SRNO = 3342762
2011-08-24 18:14:26.890 spid120 *
2011-08-24 18:14:26.890 spid120 *
2011-08-24 18:14:26.890 spid120 * MODULE BASE END SIZE
2011-08-24 18:14:26.890 spid120 * sqlservr 0000000001000000 0000000005579FFF 0457a000
2011-08-24 18:14:26.890 spid120 * ntdll 0000000077B30000 0000000077CD1FFF 001a2000
2011-08-24 18:14:26.890 spid120 * kernel32 00000000759B0000 0000000075B9FFFF 001f0000
2011-08-24 18:14:26.890 spid120 * MSVCR80 0000000078130000 00000000782A7FFF 00178000
2011-08-24 18:14:26.890 spid120 * msvcrt 000006FB7EB30000 000006FB7EC25FFF 000f6000
2011-08-24 18:14:26.890 spid120 * MSVCP80 000000007C420000 000000007C57FFFF 00160000
2011-08-24 18:14:26.890 spid120 * ADVAPI32 000006FB7FAA0000 000006FB7FC19FFF 0017a000
2011-08-24 18:14:26.890 spid120 * RPCRT4 000006FAE5650000 000006FAE58BDFFF 0026e000
2011-08-24 18:14:26.890 spid120 * Secur32 000006FB7E170000 000006FB7E1A9FFF 0003a000
2011-08-24 18:14:26.890 spid120 * USER32 0000000077CE0000 0000000077E53FFF 00174000
2011-08-24 18:14:26.890 spid120 * GDI32 000006FB7FE90000 000006FB7FF79FFF 000ea000
2011-08-24 18:14:26.890 spid120 * CRYPT32 000006FB7A950000 000006FB7AB07FFF 001b8000
2011-08-24 18:14:26.890 spid120 * MSASN1 000006FB7C3C0000 000006FB7C3F9FFF 0003a000
2011-08-24 18:14:26.890 spid120 * MSWSOCK 000006FAFE8E0000 000006FAFE9ABFFF 000cc000
2011-08-24 18:14:26.890 spid120 * WS2_32 000006FB73B60000 000006FB73BA7FFF 00048000
2011-08-24 18:14:26.890 spid120 * WS2HELP 000006FB73B40000 000006FB73B59FFF 0001a000
2011-08-24 18:14:26.890 spid120 * USERENV 000006FB79F70000 000006FB7A0F9FFF 0018a000
2011-08-24 18:14:26.890 spid120 * opends60 00000000333E0000 00000000333F5FFF 00016000
2011-08-24 18:14:26.890 spid120 * NETAPI32 000006FAFEA50000 000006FAFEB39FFF 000ea000
2011-08-24 18:14:26.890 spid120 * SHELL32 000006FB7EC30000 000006FB7F8EDFFF 00cbe000
2011-08-24 18:14:26.890 spid120 * SHLWAPI 000006FB7F8F0000 000006FB7F9C1FFF 000d2000
2011-08-24 18:14:26.890 spid120 * comctl32 000006FAFA670000 000006FAFA8F7FFF 00288000
2011-08-24 18:14:26.890 spid120 * psapi 000006FB7D8B0000 000006FB7D8CDFFF 0001e000
2011-08-24 18:14:26.890 spid120 * instapi 0000000048060000 0000000048083FFF 00024000
2011-08-24 18:14:26.890 spid120 * sqlevn70 000000004F610000 000000004F7B9FFF 001aa000
2011-08-24 18:14:26.890 spid120 * SQLOS 00000000344D0000 00000000344E1FFF 00012000
2011-08-24 18:14:26.890 spid120 * rsaenh 0000000068000000 000000006807FFFF 00080000
2011-08-24 18:14:26.890 spid120 * AUTHZ 000006FB7E070000 000006FB7E0B5FFF 00046000
2011-08-24 18:14:26.890 spid120 * MSCOREE 00000642FE2E0000 00000642FE3C5FFF 000e6000
2011-08-24 18:14:26.890 spid120 * ole32 000006FAF1A80000 000006FAF1E75FFF 003f6000
2011-08-24 18:14:26.890 spid120 * msv1_0 000006FB7DD10000 000006FB7DD79FFF 0006a000
2011-08-24 18:14:26.890 spid120 * cryptdll 000006FB7CEE0000 000006FB7CEFBFFF 0001c000
2011-08-24 18:14:26.890 spid120 * iphlpapi 000006FB7DBB0000 000006FB7DBF9FFF 0004a000
2011-08-24 18:14:26.890 spid120 * kerberos 000006FAFEB40000 000006FAFEC37FFF 000f8000
2011-08-24 18:14:26.890 spid120 * schannel 000006FB7CFE0000 000006FB7D05DFFF 0007e000
2011-08-24 18:14:26.890 spid120 * COMRES 000006FB7E340000 000006FB7E40FFFF 000d0000
2011-08-24 18:14:26.890 spid120 * XOLEHLP 000006FB58470000 000006FB58481FFF 00012000
2011-08-24 18:14:26.890 spid120 * MSDTCPRX 000006FB571D0000 000006FB57329FFF 0015a000
2011-08-24 18:14:26.890 spid120 * OLEAUT32 000006FAE6330000 000006FAE6705FFF 003d6000
2011-08-24 18:14:26.890 spid120 * msvcp60 000000002D850000 000000002D965FFF 00116000
2011-08-24 18:14:26.890 spid120 * MTXCLU 000006FB7D850000 000006FB7D891FFF 00042000
2011-08-24 18:14:26.890 spid120 * VERSION 000006FB7FA80000 000006FB7FA99FFF 0001a000
2011-08-24 18:14:26.890 spid120 * WSOCK32 000006FB73AC0000 000006FB73ACFFFF 00010000
2011-08-24 18:14:26.890 spid120 * CLUSAPI 000006FB79950000 000006FB79983FFF 00034000
2011-08-24 18:14:26.890 spid120 * RESUTILS 000006FB79B50000 000006FB79B81FFF 00032000
2011-08-24 18:14:26.890 spid120 * DNSAPI 000006FB7E1F0000 000006FB7E265FFF 00076000
2011-08-24 18:14:26.890 spid120 * winrnr 000006FB7E1B0000 000006FB7E1C7FFF 00018000
2011-08-24 18:14:26.890 spid120 * WLDAP32 000006FB7E0F0000 000006FB7E16DFFF 0007e000
2011-08-24 18:14:26.890 spid120 * rasadhlp 000006FB7E1D0000 000006FB7E1E1FFF 00012000
2011-08-24 18:14:26.890 spid120 * security 000006FB740D0000 000006FB740DBFFF 0000c000
2011-08-24 18:14:26.890 spid120 * msfte 0000000049BA0000 000000004A271FFF 006d2000
2011-08-24 18:14:26.890 spid120 * dbghelp 0000000031ED0000 0000000032265FFF 00396000
2011-08-24 18:14:26.890 spid120 * WINTRUST 000006FB7D930000 000006FB7D9ADFFF 0007e000
2011-08-24 18:14:26.890 spid120 * imagehlp 000006FB7DA10000 000006FB7DA3DFFF 0002e000
2011-08-24 18:14:26.890 spid120 * dssenh 0000000068100000 0000000068167FFF 00068000
2011-08-24 18:14:26.890 spid120 * hnetcfg 000006FB54460000 000006FB54579FFF 0011a000
2011-08-24 18:14:26.890 spid120 * wshtcpip 000006FB73900000 000006FB73917FFF 00018000
2011-08-24 18:14:26.890 spid120 * NTMARTA 000006FB7DA80000 000006FB7DAE5FFF 00066000
2011-08-24 18:14:26.890 spid120 * SAMLIB 000006FB57340000 000006FB57365FFF 00026000
2011-08-24 18:14:26.890 spid120 * ntdsapi 000006FB7CF00000 000006FB7CF3DFFF 0003e000
2011-08-24 18:14:26.890 spid120 * xpsp2res 0000000005980000 0000000005C45FFF 002c6000
2011-08-24 18:14:26.890 spid120 * CLBCatQ 000006FB7E9C0000 000006FB7EB17FFF 00158000
2011-08-24 18:14:26.890 spid120 * sqlncli 0000000033A00000 0000000033F35FFF 00536000
2011-08-24 18:14:26.890 spid120 * COMCTL32 000006FAF78A0000 000006FAF7A63FFF 001c4000
2011-08-24 18:14:26.890 spid120 * comdlg32 000006FB7C400000 000006FB7C4C7FFF 000c8000
2011-08-24 18:14:26.890 spid120 * SQLNCLIR 0000000005CB0000 0000000005CE3FFF 00034000
2011-08-24 18:14:26.890 spid120 * msftepxy 0000000005CF0000 0000000005D1BFFF 0002c000
2011-08-24 18:14:26.890 spid120 * xpsqlbot 000000004A7C0000 000000004A7D5FFF 00016000
2011-08-24 18:14:26.890 spid120 * xpstar90 0000000053C30000 0000000053D21FFF 000f2000
2011-08-24 18:14:26.890 spid120 * SQLSCM90 0000000053AD0000 0000000053AEBFFF 0001c000
2011-08-24 18:14:26.890 spid120 * ODBC32 000006FAF50F0000 000006FAF51A5FFF 000b6000
2011-08-24 18:14:26.890 spid120 * BatchParser90 00000000520C0000 000000005210FFFF 00050000
2011-08-24 18:14:26.890 spid120 * ATL80 000000007C630000 000000007C67FFFF 00050000
2011-08-24 18:14:26.890 spid120 * odbcint 000000003CBC0000 000000003CBD7FFF 00018000
2011-08-24 18:14:26.890 spid120 * xpstar90 000000003CBE0000 000000003CC05FFF 00026000
2011-08-24 18:14:26.890 spid120 * xplog70 000000003CC10000 000000003CC31FFF 00022000
2011-08-24 18:14:26.890 spid120 * xplog70 000000003CC50000 000000003CC53FFF 00004000
2011-08-24 18:14:26.890 spid120 *
2011-08-24 18:14:26.890 spid120 * DbI0: CF3FFFFF0008000B:
2011-08-24 18:14:26.890 spid120 * DbI1: 0000060100000111:
2011-08-24 18:14:26.890 spid120 * DbI2: 0000000000000000:
2011-08-24 18:14:26.890 spid120 * DbI3: 0000000000000000:
2011-08-24 18:14:26.890 spid120 * DbI4: 0000000000000000:
2011-08-24 18:14:26.890 spid120 * DbI5: 00000000004000A1:
2011-08-24 18:14:26.890 spid120 * DbI6: 0000000000000000:
2011-08-24 18:14:26.890 spid120 * DbI7: 0000000000000000:
2011-08-24 18:14:26.890 spid120 * DbD0: 0000000000030001:
2011-08-24 18:14:26.890 spid120 * DbD1: 0000000078275360: 0701E02FB100E607 8101D461AEB002E4 00000000A13505C0 0014538000135688 00071A3000000002 001232B000071A60
2011-08-24 18:14:26.890 spid120 * DbD2: 0000001300000018:
2011-08-24 18:14:26.890 spid120 * DbD3: 000000DB0000005C:
2011-08-24 18:14:26.890 spid120 * DbD4: 0000000000000000:
2011-08-24 18:14:26.890 spid120 * DbD5: 0000000000000000:
2011-08-24 18:14:26.890 spid120 * DbD6: 0000000000000000:
2011-08-24 18:14:26.890 spid120 * DbD7: 0000000000000000:
2011-08-24 18:14:26.890 spid120 * StFPSR: 0009984C8A74433F:
2011-08-24 18:14:26.890 spid120 * IntGp: 0000000005124000: 0000001000000010 0000000B00000020 0000001C00000050 0000002000000009 0000000000000008 0000000000000000
2011-08-24 18:14:26.890 spid120 * IntT0: 0000000000000008:
2011-08-24 18:14:26.890 spid120 * IntT1: 0000000000000000:
2011-08-24 18:14:26.890 spid120 * IntS0: 00000006006E08F0: 0000000000000003 FFFFFFFFFFFF0000 0000000000000000 0000000000000000 00000006006E06B0 FFFF000000000000
2011-08-24 18:14:26.890 spid120 * IntS1: 0000000000000004:
2011-08-24 18:14:26.890 spid120 * IntS2: 00000006006E0790: 00000004D45C5E74 0000000000000009 0000000D00000000 0000005400000038 0000000100000003 0000000000000001
2011-08-24 18:14:26.890 spid120 * IntS3: 00000006006E06D8: 00000006006E0F70 00000006006E0618 00000006006E13A0 000000000036B4E3 000000060000003A 0000000000000000
2011-08-24 18:14:26.890 spid120 * IntV0: 000000000AB3F888: 000000002F310120 000000002F310120 0000000100000000 0000000000000000 000000000B00E1C0 000000000B00E1C0
2011-08-24 18:14:26.890 spid120 * IntT2: 0000000000000000:
2011-08-24 18:14:26.890 spid120 * IntT3: 0000000007BC4B90: 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000
2011-08-24 18:14:26.890 spid120 * IntT4: 00000001EABC44F8: 000000092B519F10 0000000000000000 000000092B518570 000000092B5190A0 0000000000000000 0000000000000000
2011-08-24 18:14:26.890 spid120 * IntSp: 0000000041CAE7E0: 0000000000000000 0000000000000000 0000000041CAE7F0 0000000041CAE7F0 0000000000000004 0000000000000000
2011-08-24 18:14:26.890 spid120 * IntTeb: 000006FBFFED6000: 0000000000000000 0000000041CB0000 0000000041C92000 0000000000000000 0000000000001E00 0000000000000000
2011-08-24 18:14:26.890 spid120 * IntT5: 0000000006B05F80: 0000000006870B00 0000000000000000 0000000000000000 000000000746AC00 0000000000000004 0000000080051138
2011-08-24 18:14:26.890 spid120 * IntT6: 00000001EABC4487: 000001EAC3605000 000000060661C000 0000000000000000 0000000000000000 0000000000000000 0000000000000000
2011-08-24 18:14:26.890 spid120 * IntT7: 0000000007BC4B5F: 0000000000000001 0000000000000000 0000000000000000 0000000000000000 00000007BC4A8000 0000001D882E7000
2011-08-24 18:14:26.890 spid120 * IntT8: 0000000000000000:
2011-08-24 18:14:26.890 spid120 * IntT9: 0000000000000002:
2011-08-24 18:14:26.890 spid120 * IntT10: 0000000000000000:
2011-08-24 18:14:26.890 spid120 * IntT11: 000000002F310080: 0000000000000000 00000000003A9C93 0000000000000000 0000000000001388 0000000000000FB1 0000000080302050
2011-08-24 18:14:26.890 spid120 * IntT12: 00000000050E2680: 000000002F310080 00000000815D1580 000000000000001C 0000000000003200 00000000024A0036 000000000B000490
2011-08-24 18:14:26.890 spid120 * IntT13: 0000000000000000:
2011-08-24 18:14:26.890 spid120 * IntT14: 0000000000000001:
2011-08-24 18:14:26.890 spid120 * IntT15: 0000000000000000:
2011-08-24 18:14:26.890 spid120 * IntT16: 0000000000400097:
2011-08-24 18:14:26.890 spid120 * IntT17: 0000000000400097:
2011-08-24 18:14:26.890 spid120 * IntT18: 0000000000000000:
2011-08-24 18:14:26.890 spid120 * IntT19: 0000000000000000:
2011-08-24 18:14:26.890 spid120 * IntT20: 0000000000000000:
2011-08-24 18:14:26.890 spid120 * IntT21: 0000000000001590:
2011-08-24 18:14:26.890 spid120 * IntT22: 000000002F310128: 000000000AB3F888 0000000000000000 000000002F310138 000000002F310138 0000000000000000 0000000000000000
2011-08-24 18:14:26.890 spid120 * IntNats: 0000000020000000: 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000
2011-08-24 18:14:26.890 spid120 * Preds: 000000000000E885:
2011-08-24 18:14:26.890 spid120 * BrRp: 000000000110CCA0: 0000000100000019 48EFE9F000000200 0210058006111001 8401000460006200 0000000100000013 58EF829000100000
2011-08-24 18:14:26.890 spid120 * BrS0: 0000000000000000:
2011-08-24 18:14:26.890 spid120 * BrS1: 0000000000000000:
2011-08-24 18:14:26.890 spid120 * BrS2: 0000000000000000:
2011-08-24 18:14:26.890 spid120 * BrS3: 0000000000000000:
2011-08-24 18:14:26.890 spid120 * BrS4: 0000000000000000:
2011-08-24 18:14:26.890 spid120 * BrT0: E0000000846C2C40:
2011-08-24 18:14:26.890 spid120 * BrT1: 00000000759E4E40: 007FC00100000004 6003D043E0000000 007FC00100000005 601BD203A0000000 01C010103E00F019 2000000000217074
2011-08-24 18:14:26.890 spid120 * ApUNAT: 0000000000000000:
2011-08-24 18:14:26.890 spid120 * ApLC: 0000000000000000:
2011-08-24 18:14:26.890 spid120 * ApEC: 0000000000000000:
2011-08-24 18:14:26.890 spid120 * ApCCV: 0000000000000000:
2011-08-24 18:14:26.890 spid120 * ApDCR: 0000000000007E05:
2011-08-24 18:14:26.890 spid120 * RsPFS: C00000000000040B:
2011-08-24 18:14:26.890 spid120 * RsBSP: 0000000041CB1B98: 000000000AB3F898 0000000000000000 0000000000000001 000000000AB3F8B0 000000000AB3F89C 0000000041CAE7F0
2011-08-24 18:14:26.890 spid120 * RsBSPSTORE: 0000000041CB1B98: 000000000AB3F898 0000000000000000 0000000000000001 000000000AB3F8B0 000000000AB3F89C 0000000041CAE7F0
2011-08-24 18:14:26.890 spid120 * RsRSC: 000000000000000F:
2011-08-24 18:14:26.890 spid120 * RsRNAT: 0000000000000000:
2011-08-24 18:14:26.890 spid120 * StIPSR: 00001013086A6018:
2011-08-24 18:14:26.890 spid120 * StIIP: 00000000010E6BD0: 01F011985EB40018 200000000020B09C 02E011384C01680A 00040000002270A8 01F011985AB80019 200000000022309C
2011-08-24 18:14:26.890 spid120 * StIFS: 8000000000000690:
2011-08-24 18:14:26.890 spid120 * StFCR: 0000000000000040:
2011-08-24 18:14:26.890 spid120 * Eflag: 0000000000000202:
2011-08-24 18:14:26.890 spid120 * SegCSD: 0000000000000000:
2011-08-24 18:14:26.890 spid120 * SegSSD: CF3FFFFF00000000:
2011-08-24 18:14:26.890 spid120 * Cflag: 0000060100000111:
2011-08-24 18:14:26.890 spid120 * StFSR: 0000000000000000:
2011-08-24 18:14:26.890 spid120 * StFIR: 0000000000000000:
2011-08-24 18:14:26.890 spid120 * StFDR: 0000000000000000:
2011-08-24 18:14:26.890 spid120 * *******************************************************************************
2011-08-24 18:14:26.890 spid120 * -------------------------------------------------------------------------------
2011-08-24 18:14:26.890 spid120 * Short Stack Dump
2011-08-24 18:14:26.990 spid120 00000000010E6BD0 Module(sqlservr+00000000000E6BD0)
2011-08-24 18:14:26.990 spid120 000000000110CCA0 Module(sqlservr+000000000010CCA0)
2011-08-24 18:14:26.990 spid120 00000000027EB900 Module(sqlservr+00000000017EB900)
2011-08-24 18:14:26.990 spid120 00000000027EC560 Module(sqlservr+00000000017EC560)
2011-08-24 18:14:26.990 spid120 0000000001D454C0 Module(sqlservr+0000000000D454C0)
2011-08-24 18:14:27.000 spid120 0000000001098820 Module(sqlservr+0000000000098820)
2011-08-24 18:14:27.000 spid120 0000000001091100 Module(sqlservr+0000000000091100)
2011-08-24 18:14:27.000 spid120 00000000032E4F80 Module(sqlservr+00000000022E4F80)
2011-08-24 18:14:27.000 spid120 00000000032E9290 Module(sqlservr+00000000022E9290)
2011-08-24 18:14:27.000 spid120 000000000400C9A0 Module(sqlservr+000000000300C9A0)
2011-08-24 18:14:27.000 spid120 0000000004022530 Module(sqlservr+0000000003022530)
2011-08-24 18:14:27.000 spid120 0000000001E7C9D0 Module(sqlservr+0000000000E7C9D0)
2011-08-24 18:14:27.000 spid120 000000000116E4C0 Module(sqlservr+000000000016E4C0)
2011-08-24 18:14:27.000 spid120 00000000011E0130 Module(sqlservr+00000000001E0130)
2011-08-24 18:14:27.000 spid120 00000000010A7E20 Module(sqlservr+00000000000A7E20)
2011-08-24 18:14:27.000 spid120 00000000010A7E80 Module(sqlservr+00000000000A7E80)
2011-08-24 18:14:27.000 spid120 000000000106B1F0 Module(sqlservr+000000000006B1F0)
2011-08-24 18:14:27.000 spid120 000000000109DB60 Module(sqlservr+000000000009DB60)
2011-08-24 18:14:27.010 spid120 00000000019A9D60 Module(sqlservr+00000000009A9D60)
2011-08-24 18:14:27.010 spid120 0000000001383E00 Module(sqlservr+0000000000383E00)
2011-08-24 18:14:27.010 spid120 0000000001386D50 Module(sqlservr+0000000000386D50)
2011-08-24 18:14:27.010 spid120 0000000001386470 Module(sqlservr+0000000000386470)
2011-08-24 18:14:27.010 spid120 0000000001058480 Module(sqlservr+0000000000058480)
2011-08-24 18:14:27.010 spid120 00000000037D6850 Module(sqlservr+00000000027D6850)
2011-08-24 18:14:27.010 spid120 00000000016BD220 Module(sqlservr+00000000006BD220)
2011-08-24 18:14:27.010 spid120 00000000010568D0 Module(sqlservr+00000000000568D0)
2011-08-24 18:14:27.010 spid120 0000000001058EF0 Module(sqlservr+0000000000058EF0)
2011-08-24 18:14:27.010 spid120 0000000001058480 Module(sqlservr+0000000000058480)
2011-08-24 18:14:27.010 spid120 000000000105DE60 Module(sqlservr+000000000005DE60)
2011-08-24 18:14:27.010 spid120 00000000015F3410 Module(sqlservr+00000000005F3410)
2011-08-24 18:14:27.010 spid120 0000000001006EF0 Module(sqlservr+0000000000006EF0)
2011-08-24 18:14:27.010 spid120 0000000001006C70 Module(sqlservr+0000000000006C70)
2011-08-24 18:14:27.020 spid120 0000000001006690 Module(sqlservr+0000000000006690)
2011-08-24 18:14:27.020 spid120 00000000014107A0 Module(sqlservr+00000000004107A0)
2011-08-24 18:14:27.020 spid120 00000000014102B0 Module(sqlservr+00000000004102B0)
2011-08-24 18:14:27.020 spid120 00000000014100B0 Module(sqlservr+00000000004100B0)
2011-08-24 18:14:27.040 spid120 000000000140FE00 Module(sqlservr+000000000040FE00)
2011-08-24 18:14:27.040 spid120 0000000078137BF0 Module(MSVCR80+0000000000007BF0)
2011-08-24 18:14:27.050 spid120 0000000078137DF0 Module(MSVCR80+0000000000007DF0)
2011-08-24 18:14:27.050 spid120 0000000075A47AE0 Module(kernel32+0000000000097AE0)
2011-08-24 18:14:27.070 spid120 Stack Signature for the dump is 0x00000000B71F8960
2011-08-24 18:14:42.470 spid120 External dump process return code 0x20000001.
External dump process returned no errors.
2011-08-24 18:14:42.500 Server Error: 17310, Severity: 20, State: 1.
2011-08-24 18:14:42.500 Server A user request from the session with SPID 120 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.
2011-08-24 18:16:41.160 Server Using 'dbghelp.dll' version '4.0.5'
2011-08-24 18:16:41.160 Server ***Unable to get thread context - no pss
2011-08-24 18:16:41.160 Server * *******************************************************************************
2011-08-24 18:16:41.160 Server *
2011-08-24 18:16:41.160 Server * BEGIN STACK DUMP:
2011-08-24 18:16:41.160 Server * 08/24/11 18:16:41 spid 0
2011-08-24 18:16:41.160 Server *
2011-08-24 18:16:41.160 Server * Non-yielding Scheduler
2011-08-24 18:16:41.160 Server *
2011-08-24 18:16:41.160 Server * *******************************************************************************
2011-08-24 18:16:41.160 Server Stack Signature for the dump is 0x00000000000002B6
2011-08-24 18:16:50.430 Server Process 79:0:0 (0x3f8) Worker 0x00000005806A21C0 appears to be non-yielding on Scheduler 11. Thread creation time: 12958652716216. Approx Thread CPU Used: kernel 0 ms, user 0 ms. Process Utilization 33%. System Idle 64%. Interval: 75000 ms.
2011-08-24 18:16:50.430 Server Process 148:0:0 (0x6e8) Worker 0x00000001EABC41C0 appears to be non-yielding on Scheduler 15. Thread creation time: 12958632433788. Approx Thread CPU Used: kernel 0 ms, user 0 ms. Process Utilization 33%. System Idle 64%. Interval: 75000 ms.
2011-08-24 18:16:57.190 Server External dump process return code 0x20000001.
External dump process returned no errors.
August 25, 2011 at 2:43 am
Check that you're on the latest service pack, if the problem persists call Microsoft's customer support.
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
August 25, 2011 at 2:53 am
no latest service pack...
currently in production server SP2 is there.we are applying SP4 in few days.
but why this error came,any severity issue
August 25, 2011 at 2:54 am
No idea. Apply SP4, if the problem persists call customer support. They have tools to read and diagnose stack dumps, we don't.
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
August 25, 2011 at 3:07 am
OK...
August 25, 2011 at 4:16 am
can you explain what is stack dump and when this occurs...........
August 25, 2011 at 4:45 am
It's an access violation
2011-08-24 18:14:26.890 spid120 * Exception Address = 00000000010E6BD0 Module(sqlservr+00000000000E6BD0)
2011-08-24 18:14:26.890 spid120 * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
2011-08-24 18:14:26.890 spid120 * Access Violation occurred writing address 0000000000000009
An access violation occurs when a windows application (like SQL Server) attempts to read or write a memory address that either belongs to the OS, belongs to another process or is restricted memory.
It can be a symptom of a buffer overrun or other memory-related coding errors (and I mean application coding, not T-SQL)
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
August 25, 2011 at 4:58 am
thanks for your information, can i get some tutorials or articles on this.......
August 25, 2011 at 5:15 am
On what?
Stack dumps are application errors (Not T-SQL errors) and they are typically memory bugs.
If you're planning on writing low-level windows applications (using C++) you'll find lots of information on how to address memory correctly, because that's the level this error is at.
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
August 25, 2011 at 5:21 am
ok..once again thanks...........
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply