Hi
We are having problems with our application that uses SQL Server 2005 in a cluster environment. Sometimes the system stops answering and registers in the log viewer the following error:
=====================================================================
BugCheck Dump
=====================================================================
This file is generated by Microsoft SQL Server
version 9.00.1399.06
upon detection of fatal unexpected error. Please return this file, the query or program that produced the bugcheck, the database and the error log, and any other pertinent information with a Service Request.
Computer type is AT/AT COMPATIBLE.
Bios Version is IBM- 1001
Current time is 16:48:36 12/05/06.
2 Intel x86 level 15, 3600 Mhz processor (s).
Windows NT 5.2 Build 3790 CSD Service Pack 1.
Memory
MemoryLoad = 74%
Total Physical = 3327 MB
Available Physical = 858 MB
Total Page File = 9318 MB
Available Page File = 7058 MB
Total Virtual = 2047 MB
Available Virtual = 274 MB
**Dump thread - spid = 132, PSS = 0x71E09588, EC = 0x71E09590
***Stack Dump being sent to E:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0178.txt
* *******************************************************************************
*
* BEGIN STACK DUMP:
*12/05/06 16:48:36 spid 132
*
* Location:lckmgr.cpp:10820
* Expression:GetLocalLockPartition () == xactLockInfo->GetLocalLockPartition ()
* SPID:132
* Process ID:2436
*
* Input Buffer 255 bytes -
*?16 00 00 00 12 00 00 00 02 00 01 00 00 00 84 00 00 00
*???dD 01 00 00 00 ff ff 0a 00 02 00 00 00 e7 64 09 09 04 d0
*4dS E L E C T00 34 64 09 20 00 53 00 45 00 4c 00 45 00 43 00 54 00
*TAbleA (*) 20 00 54 00 48 00 69 00 73 00 74 00 6f 00 72 00 69 00
(*) There is a query here that I have excluded in the message
*
*MODULEBASEENDSIZE
* sqlservr0100000002BA7FFF01ba8000
* ntdll7C9100007C9D3FFF000c4000
* kernel327C8000007C90BFFF0010c000
* MSVCR8078130000781CAFFF0009b000
* msvcrt77B9000077BE9FFF0005a000
* MSVCP807C4200007C4A6FFF00087000
* ADVAPI3277D9000077E3DFFF000ae000
* RPCRT477C4000077CDEFFF0009f000
* USER3277F4000077FD1FFF00092000
* GDI3277BF000077C37FFF00048000
* CRYPT32760D000076164FFF00095000
* MSASN1760B0000760C1FFF00012000
* Secur3276E7000076E82FFF00013000
* MSWSOCK71970000719B1FFF00042000
* WS2_3271A5000071A66FFF00017000
* WS2HELP71A4000071A47FFF00008000
* USERENV7684000076904FFF000c5000
* opends60333E0000333E6FFF00007000
* NETAPI3271A9000071AE7FFF00058000
* SHELL327C9E00007D1EAFFF0080b000
* SHLWAPI77EE000077F31FFF00052000
* comctl327736000077462FFF00103000
* EntApi3700000037012FFF00013000
* PSAPI76A9000076A9AFFF0000b000
* WININET779D000077A78FFF000a9000
* OLEAUT3277CF000077D7BFFF0008c000
* ole327751000077643FFF00134000
* instapi4806000048069FFF 0000a000
* CLUSAPI74CF000074D01FFF00012000
* RESUTILS74E0000074E12FFF00013000
* sqlevn704F6100004F7A0FFF00191000
* SQLOS344D0000344D4FFF00005000
* rsaenh680000006802EFFF0002f000
* AUTHZ76B6000076B73FFF00014000
* MSCOREE340C000034104FFF00045000
* msv1_076BB000076BD6FFF00027000
* iphlpapi76C1000076C29FFF0001a000
* kerberos3433000034387FFF00058000
* cryptdll766000007660BFFF0000c000
* schannel7667000076696FFF00027000
* COMRES76F30000770BCFFF0018d000
* XOLEHLP343F0000343F5FFF00006000
* MSDTCPRX3440000034477FFF00078000
* msvcp60780C000078120FFF00061000
* MTXCLU74E5000074E68FFF00019000
* VERSION77B8000077B87FFF00008000
* WSOCK3271A0000071A09FFF0000a000
* DNSAPI76DF000076E1EFFF0002f000
* winrnr76E9000076E96FFF00007000
* WLDAP3276E3000076E5EFFF0002f000
* rasadhlp76EA000076EA7FFF00008000
* hnetcfg36190000361E8FFF00059000
* wshtcpip7193000071937FFF00008000
* security3634000036343FFF00004000
* msfte36A6000036CB7FFF00258000
* dbghelp36D0000036E17FFF00118000
* WINTRUST76AD000076AFAFFF 0002b000
* imagehlp76B3000076B58FFF00029000
* dssenh6810000068123FFF00024000
* NTMARTA777B0000777D1FFF00022000
* SAMLIB36FE000036FEEFFF0000f000
* ntdsapi7661000076624FFF00015000
* xpsp2res61BF000061EBFFFF002d0000
* CLBCatQ77650000776D2FFF00083000
* sqlncli61EC0000620E1FFF00222000
* COMCTL3277E4000077ED6FFF00097000
* comdlg32761D000076218FFF00049000
* SQLNCLIR007C0000007F2FFF00033000
* msftepxy621F000062204FFF00015000
* xpsqlbot6286000062865FFF00006000
* xpstar9062880000628C4FFF00045000
* SQLSCM90628E0000628E8FFF00009000
* ODBC32629000006293CFFF0003d000
* BatchParser90629400006295DFFF0001e000
* SQLSVC906297000062989FFF0001a000
* SqlResourceLoader629A0000629A5FFF00006000
* ATL807C6300007C64AFFF0001b000
* odbcint62B0000062B17FFF00018000
* SQLSVC9062B2000062B22FFF00003000
* xpstar9062B3000062B55FFF00026000
* xplog7062B6000062B6BFFF0000c000
* xplog7062B8000062B82FFF00003000
* oledb32631B000063228FFF00079000
* MSDART6323000063249FFF0001a000
* OLEDB32R634D0000634E1FFF00012000
* activeds76D1000076D42FFF 00033000
* adsldpc76CE000076D06FFF00027000
* credui76AA000076ACDFFF0002e000
* ATL769A0000769B7FFF00018000
* adsldp711100007113DFFF0002e000
* SXS75CB000075D6BFFF000bc000
* dbghelp65D4000065E52FFF00113000
*
*Edi: 6610BCB8:636A19003E3A604062F1A0406610D8AD0279E9003E3A63D8
*Esi: 00000000:
*Eax: 6610BB9C:000042AC00000000000000007C815E02000000007C931B34
*Ebx: 0000003F:
*Ecx: 6610C20C:00000000000100070000000000740072636A19046610BBCC
*Edx: 0000003D:
*Eip: 7C815E02:10C2C95E90909000A164909000000018C334408B891C428B
*Ebp: 6610BBEC:6610BC3002172CE4000042AC000000000000000000000000
*SegCs: 0000001B:
*EFlags: 00000246:
*Esp: 6610BB98:71E09588000042AC00000000000000007C815E0200000000
*SegSs: 78130023:000000000000000000000000000000000000000000000000
* *******************************************************************************
* -
* Short Stack Dump
7C815E02 Module(kernel32+00015E02)
02172CE4 Module(sqlservr+01172CE4)
02176BA0 Module(sqlservr+01176BA0)
02019506 Module(sqlservr+01019506)
015738EE Module(sqlservr+005738EE)
021B15B6 Module(sqlservr+011B15B6)
0163DD36 Module(sqlservr+0063DD36)
010E9FA3 Module(sqlservr+000E9FA3)
010B0F5F Module(sqlservr+000B0F5F)
0102C5F8 Module(sqlservr+0002C5F8)
01BEE12B Module(sqlservr+00BEE12B)
01BF2BCB Module(sqlservr+00BF2BCB)
01BF353D Module(sqlservr+00BF353D)
010438E5 Module(sqlservr+000438E5)
01041C35 Module(sqlservr+00041C35)
0100889F Module(sqlservr+0000889F)
010089C5 Module(sqlservr+000089C5)
010086E7 Module(sqlservr+000086E7)
010D764A Module(sqlservr+000D764A)
010D7B71 Module(sqlservr+000D7B71)
010D746E Module(sqlservr+000D746E)
010D83F0 Module(sqlservr+000D83F0)
781329AA Module(MSVCR80+000029AA)
78132A36 Module(MSVCR80+00002A36)
PSS @.0x71E09588
CSession @.0x71E08278
--
m_spid = 132m_cRef = 12m_rgcRefType[0] = 1
m_rgcRefType[1] = 1m_rgcRefType[2] = 9m_rgcRefType[3] = 1
m_rgcRefType[4] = 0m_rgcRefType[5] = 0m_pmo = 0x71E08040
m_pstackBhfPool = 0x00000000m_dwLoginFlags = 0x03e0m_fBackground = 0
m_fClientRequestConnReset = 0m_fUserProc = -1m_fConnReset = 0
m_fIsConnReset = 0m_fInLogin = 0m_fReplRelease = 0
m_fKill = 0m_ulLoginStamp = 3105683m_eclClient = 5
m_protType = 5m_hHttpToken = FFFFFFFF
m_pV7LoginRec
00000000:18010000 02000972 401f0000 00000006 400c0000 ?.......r@........@....
00000014:00000000 e0030000 00000000 00000000 5e000400 ?................^...
00000028:66000200 6a000000 7a001c00 b2000c00 ca000000 ?f...j...z...........
0000003C:ca001c00 02010000 02010b00 60f120db ad481801 ?............`. ..H..
00000050:00001801 00001801 00000000 0000???????????????..............
CPhysicalConnection @.0x71E08188
-
m_pPhyConn->m_pmo = 0x71E08040m_pPhyConn->m_pNetConn = 0x71E08788m_pPhyConn->m_pConnList = 0x71E08260
m_pPhyConn->m_pSess = 0x71E08278m_pPhyConn->m_fTracked = -1m_pPhyConn->m_cbPacketsize = 8000
m_pPhyConn->m_fMars = 0m_pPhyConn->m_fKill = 0
CBatch @.0x71E08A90
m_pSess = 0x71E08278m_pConn = 0x71E089F0m_cRef = 3
m_rgcRefType[0] = 1m_rgcRefType[1] = 1m_rgcRefType[2] = 1
m_rgcRefType[3] = 0m_rgcRefType[4] = 0m_pTask = 0x006F9D38
EXCEPT (null) @.0x6610B4AC
-
exc_number = 0exc_severity = 0exc_func = 0x023D96B0
Task @.0x006F9D38
-
CPU Ticks used (ms) = 1Task State = 2
WAITINFO_INTERNAL: WaitResource = 0x00000000WAITINFO_INTERNAL: WaitType = 0x0
WAITINFO_INTERNAL: WaitSpinlock = 0x00000000SchedulerId = 0x0
ThreadId = 0x444m_state = 0m_eAbortSev = 0
EC @.0x71E09590
--
spid = 132ecid = 0ec_stat = 0x0
ec_stat2 = 0x40ec_atomic = 0x4__fSubProc = 1
ec_dbccContext = 0x00000000__pSETLS = 0x71E08A30__pSEParams = 0x71E08CD0
__pDbLocks = 0x71E09878
SEInternalTLS @.0x71E08A30
-
m_flags = 0m_TLSstatus = 3m_owningTask = 0x006F9D38
m_activeHeapDatasetList = 0x71E08A30m_activeIndexDatasetList = 0x71E08A38
SEParams @.0x71E08CD0
--
m_lockTimeout = -1m_isoLevel = 1048576m_logDontReplicate = 0
m_neverReplicate = 0m_XactWorkspace = 0x03F78940m_pSessionLocks = 0x71E09A88
m_pDbLocks = 0x71E09878m_execStats = 0x3F867018m_pAllocFileLimit = 0x00000000
Does anybody know what’s going on?
I will be very appreciate if someone can help me to solve this problem. Thank you!
Hi,
We would like to investigate this issue. Can you please file a bug via http://connect.microsoft.com/sql. Please upload SqlDump0178.mdmp and SqlDump0178.txt there as well.
Thanks, Ron D.
|||any luck on this one. We are seeing the same error.Thanks,
Siva|||
Make sure the table being accessed have proper CLUSTERED index.
No comments:
Post a Comment