Hi All,
I am suddenly getting error in SQL 2005 and database corruption.
I just rebooted the server and when it came up, I had 3 DB's recovering (Still) and some pretty looking errors in the log file.
A summary of the error:
**Dump thread - spid = 21, PSS = 0x0456C7B0, EC = 0x0456C7B8
2006-03-09 10:06:10.89 spid21s ***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0001.txt
2006-03-09 10:06:10.89 spid21s * *******************************************************************************
2006-03-09 10:06:10.89 spid21s *
2006-03-09 10:06:10.89 spid21s * BEGIN STACK DUMP:
2006-03-09 10:06:10.89 spid21s * 03/09/06 10:06:10 spid 21
2006-03-09 10:06:10.89 spid21s *
2006-03-09 10:06:10.89 spid21s * Location: "logmgr.cpp":5334
2006-03-09 10:06:10.89 spid21s * Expression: !(minLSN.m_fSeqNo < lfcb->lfcb_fSeqNo)
2006-03-09 10:06:10.89 spid21s * SPID: 21
2006-03-09 10:06:10.89 spid21s * Process ID: 1764
2006-03-09 10:06:10.89 spid21s *
then, further down, one per minute of:
Process 21:0:0 (0xb44) Worker 0x03F3A0E8 appears to be non-yielding on Scheduler 2. Thread creation time: 12786372362265. Approx Thread CPU Used: kernel 0 ms, user 0 ms. Process Utilization 0%. System Idle 95%. Interval: 196296 ms.
What's the issue? My box or SQL?
This seems to happen every time I reboot.
Cheers,
No one got any ideas on this? Errors are continuing. Errors in logmgr.cpp
Uninstalled and reinstalled, no help.
Replaced both drives (2X36gb RAID1) Still having problems...
2006-03-10 13:13:26.74 spid16s ***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0004.txt
2006-03-10 13:13:26.74 spid16s * *******************************************************************************
2006-03-10 13:13:26.74 spid16s *
2006-03-10 13:13:26.74 spid16s * BEGIN STACK DUMP:
2006-03-10 13:13:26.74 spid16s * 03/10/06 13:13:26 spid 16
2006-03-10 13:13:26.74 spid16s *
2006-03-10 13:13:26.74 spid16s * Location: "logmgr.cpp":5334
2006-03-10 13:13:26.74 spid16s * Expression: !(minLSN.m_fSeqNo < lfcb->lfcb_fSeqNo)
2006-03-10 13:13:26.74 spid16s * SPID: 16
2006-03-10 13:13:26.74 spid16s * Process ID: 1372
2006-03-10 13:13:26.74 spid16s *
2006-03-10 13:13:26.74 spid16s *
2006-03-10 13:13:26.74 spid16s *
2006-03-10 13:13:26.74 spid16s * MODULE BASE END SIZE
2006-03-10 13:13:26.74 spid16s * sqlservr 01000000 02BA7FFF 01ba8000
2006-03-10 13:13:26.74 spid16s * ntdll 7C800000 7C8BFFFF 000c0000
2006-03-10 13:13:26.74 spid16s * kernel32 77E40000 77F41FFF 00102000
2006-03-10 13:13:26.74 spid16s * MSVCR80 78130000 781CAFFF 0009b000
2006-03-10 13:13:26.74 spid16s * msvcrt 77BA0000 77BF9FFF 0005a000
2006-03-10 13:13:26.74 spid16s * MSVCP80 7C420000 7C4A6FFF 00087000
2006-03-10 13:13:26.74 spid16s * ADVAPI32 77F50000 77FEBFFF 0009c000
2006-03-10 13:13:26.74 spid16s * RPCRT4 77C50000 77CEEFFF 0009f000
2006-03-10 13:13:26.74 spid16s * USER32 77380000 77411FFF 00092000
2006-03-10 13:13:26.74 spid16s * GDI32 77C00000 77C47FFF 00048000
2006-03-10 13:13:26.74 spid16s * CRYPT32 761B0000 76242FFF 00093000
2006-03-10 13:13:26.74 spid16s * MSASN1 76190000 761A1FFF 00012000
2006-03-10 13:13:26.74 spid16s * Secur32 76F50000 76F62FFF 00013000
2006-03-10 13:13:26.74 spid16s * MSWSOCK 71B20000 71B60FFF 00041000
2006-03-10 13:13:26.74 spid16s * WS2_32 71C00000 71C16FFF 00017000
2006-03-10 13:13:26.74 spid16s * WS2HELP 71BF0000 71BF7FFF 00008000
2006-03-10 13:13:26.74 spid16s * USERENV 76920000 769E3FFF 000c4000
2006-03-10 13:13:26.74 spid16s * opends60 333E0000 333E6FFF 00007000
2006-03-10 13:13:26.74 spid16s * NETAPI32 71C40000 71C97FFF 00058000
2006-03-10 13:13:26.74 spid16s * SHELL32 7C8D0000 7D0D2FFF 00803000
2006-03-10 13:13:26.74 spid16s * SHLWAPI 77DA0000 77DF1FFF 00052000
2006-03-10 13:13:26.74 spid16s * comctl32 77420000 77522FFF 00103000
2006-03-10 13:13:26.74 spid16s * psapi 76B70000 76B7AFFF 0000b000
2006-03-10 13:13:26.74 spid16s * instapi 48060000 48069FFF 0000a000
2006-03-10 13:13:26.74 spid16s * sqlevn70 4F610000 4F7A0FFF 00191000
2006-03-10 13:13:26.74 spid16s * SQLOS 344D0000 344D4FFF 00005000
2006-03-10 13:13:26.74 spid16s * rsaenh 68000000 6802EFFF 0002f000
2006-03-10 13:13:26.74 spid16s * AUTHZ 76C40000 76C53FFF 00014000
2006-03-10 13:13:26.74 spid16s * MSCOREE 34180000 341C4FFF 00045000
2006-03-10 13:13:26.74 spid16s * ole32 77670000 777A3FFF 00134000
2006-03-10 13:13:26.74 spid16s * msv1_0 76C90000 76CB6FFF 00027000
2006-03-10 13:13:26.74 spid16s * iphlpapi 76CF0000 76D09FFF 0001a000
2006-03-10 13:13:26.74 spid16s * kerberos 343F0000 34447FFF 00058000
2006-03-10 13:13:26.74 spid16s * cryptdll 766E0000 766EBFFF 0000c000
2006-03-10 13:13:26.74 spid16s * schannel 76750000 76776FFF 00027000
2006-03-10 13:13:26.74 spid16s * COMRES 77010000 770D5FFF 000c6000
2006-03-10 13:13:26.74 spid16s * XOLEHLP 344B0000 344B5FFF 00006000
2006-03-10 13:13:26.74 spid16s * MSDTCPRX 61B20000 61B97FFF 00078000
2006-03-10 13:13:26.74 spid16s * msvcp60 780C0000 78120FFF 00061000
2006-03-10 13:13:26.74 spid16s * MTXCLU 61BA0000 61BB8FFF 00019000
2006-03-10 13:13:26.74 spid16s * VERSION 77B90000 77B97FFF 00008000
2006-03-10 13:13:26.74 spid16s * WSOCK32 71BB0000 71BB8FFF 00009000
2006-03-10 13:13:26.74 spid16s * OLEAUT32 77D00000 77D8BFFF 0008c000
2006-03-10 13:13:26.74 spid16s * CLUSAPI 61BC0000 61BD1FFF 00012000
2006-03-10 13:13:26.74 spid16s * RESUTILS 61BE0000 61BF2FFF 00013000
2006-03-10 13:13:26.74 spid16s * DNSAPI 76ED0000 76EF8FFF 00029000
2006-03-10 13:13:26.74 spid16s * winrnr 76F70000 76F76FFF 00007000
2006-03-10 13:13:26.74 spid16s * WLDAP32 76F10000 76F3DFFF 0002e000
2006-03-10 13:13:26.74 spid16s * rasadhlp 76F80000 76F84FFF 00005000
2006-03-10 13:13:26.74 spid16s * security 62020000 62023FFF 00004000
2006-03-10 13:13:26.74 spid16s * msfte 62840000 62A97FFF 00258000
2006-03-10 13:13:26.74 spid16s * dbghelp 62AB0000 62BC7FFF 00118000
2006-03-10 13:13:26.74 spid16s * WINTRUST 76BB0000 76BDAFFF 0002b000
2006-03-10 13:13:26.74 spid16s * imagehlp 76C10000 76C38FFF 00029000
2006-03-10 13:13:26.74 spid16s * dssenh 68100000 68123FFF 00024000
2006-03-10 13:13:26.74 spid16s * hnetcfg 62F10000 62F68FFF 00059000
2006-03-10 13:13:26.74 spid16s * wshtcpip 71AE0000 71AE7FFF 00008000
2006-03-10 13:13:26.74 spid16s * NTMARTA 77E00000 77E21FFF 00022000
2006-03-10 13:13:26.74 spid16s * SAMLIB 630E0000 630EEFFF 0000f000
2006-03-10 13:13:26.74 spid16s * ntdsapi 766F0000 76704FFF 00015000
2006-03-10 13:13:26.74 spid16s * xpsp2res 630F0000 633B4FFF 002c5000
2006-03-10 13:13:26.74 spid16s * CLBCatQ 777B0000 77832FFF 00083000
2006-03-10 13:13:26.74 spid16s * sqlncli 633C0000 635DDFFF 0021e000
2006-03-10 13:13:26.74 spid16s * COMCTL32 77530000 775C6FFF 00097000
2006-03-10 13:13:26.74 spid16s * comdlg32 762B0000 762F9FFF 0004a000
2006-03-10 13:13:26.74 spid16s * SQLNCLIR 007B0000 007E2FFF 00033000
2006-03-10 13:13:26.74 spid16s * msftepxy 63760000 63774FFF 00015000
2006-03-10 13:13:26.74 spid16s * dbghelp 639E0000 63AF7FFF 00118000
2006-03-10 13:13:26.74 spid16s *
2006-03-10 13:13:26.74 spid16s * Edi: 6250CA48: 00141008 FFFF0000 7C82F9DD 77E554BE 00000000 00000000
2006-03-10 13:13:26.74 spid16s * Esi: 00000000:
2006-03-10 13:13:26.74 spid16s * Eax: 6250C92C: 000042AC 00000000 00000000 77E55DEA 00000000 7C821B34
2006-03-10 13:13:26.74 spid16s * Ebx: 0000003F:
2006-03-10 13:13:26.74 spid16s * Ecx: 6250CF9C: 00000000 00010007 00000000 0090008E 0014100C 6250C95C
2006-03-10 13:13:26.74 spid16s * Edx: 0000003D:
2006-03-10 13:13:26.74 spid16s * Eip: 77E55DEA: 10C2C95E 90909000 A1649090 00000018 C334408B 891C428B
2006-03-10 13:13:26.74 spid16s * Ebp: 6250C97C: 6250C9C0 02172CE4 000042AC 00000000 00000000 00000000
2006-03-10 13:13:26.74 spid16s * SegCs: 0030001B:
2006-03-10 13:13:26.74 spid16s * EFlags: 00000246:
2006-03-10 13:13:26.74 spid16s * Esp: 6250C928: 044A87B0 000042AC 00000000 00000000 77E55DEA 00000000
2006-03-10 13:13:26.74 spid16s * SegSs: 78130023: 00000000 00000000 00000000 00000000 00000000 00000000
2006-03-10 13:13:26.74 spid16s * *******************************************************************************
2006-03-10 13:13:26.74 spid16s * -
2006-03-10 13:13:26.74 spid16s * Short Stack Dump
2006-03-10 13:13:26.75 spid15s CHECKDB for database 'PLU' finished without errors on 2006-03-09 15:45:10.623 (local time). This is an informational message only; no user action is required.
2006-03-10 13:13:26.75 spid16s 77E55DEA Module(kernel32+00015DEA)
2006-03-10 13:13:26.75 spid16s 02172CE4 Module(sqlservr+01172CE4)
2006-03-10 13:13:26.75 spid16s 02176BA0 Module(sqlservr+01176BA0)
2006-03-10 13:13:26.75 spid16s 02019506 Module(sqlservr+01019506)
2006-03-10 13:13:26.75 spid16s 015812DC Module(sqlservr+005812DC)
2006-03-10 13:13:26.75 spid16s 010CB3C0 Module(sqlservr+000CB3C0)
2006-03-10 13:13:26.75 spid16s 02193C7A Module(sqlservr+01193C7A)
2006-03-10 13:13:26.75 spid16s 021A3AB9 Module(sqlservr+011A3AB9)
2006-03-10 13:13:26.75 spid16s 020CF21E Module(sqlservr+010CF21E)
2006-03-10 13:13:26.75 spid16s 020BB8EF Module(sqlservr+010BB8EF)
2006-03-10 13:13:26.75 spid16s 020C586C Module(sqlservr+010C586C)
2006-03-10 13:13:26.75 spid16s 020C5450 Module(sqlservr+010C5450)
2006-03-10 13:13:26.75 spid16s 0100889F Module(sqlservr+0000889F)
2006-03-10 13:13:26.75 spid16s 010089C5 Module(sqlservr+000089C5)
2006-03-10 13:13:26.75 spid16s 010086E7 Module(sqlservr+000086E7)
2006-03-10 13:13:26.75 spid16s 010D764A Module(sqlservr+000D764A)
2006-03-10 13:13:26.75 spid16s 010D7B71 Module(sqlservr+000D7B71)
2006-03-10 13:13:26.75 spid16s 010D746E Module(sqlservr+000D746E)
2006-03-10 13:13:26.77 spid16s 010D83F0 Module(sqlservr+000D83F0)
2006-03-10 13:13:26.77 spid16s 781329AA Module(MSVCR80+000029AA)
2006-03-10 13:13:26.77 spid16s 78132A36 Module(MSVCR80+00002A36)
2006-03-10 13:13:26.78 spid16s Stack Signature for the dump is 0xB0AD2456
2006-03-10 13:13:27.78 spid17s 1 transactions rolled forward in database 'POS_ETL' (7). This is an informational message only. No user action is required.
2006-03-10 13:13:27.81 spid4s 0 transactions rolled back in database 'POS_ETL' (7). This is an informational message only. No user action is required.
2006-03-10 13:13:27.81 spid4s Recovery is writing a checkpoint in database 'POS_ETL' (7). This is an informational message only. No user action is required.
2006-03-10 13:13:27.84 spid18s 1 transactions rolled forward in database 'sTlog' (8). This is an informational message only. No user action is required.
2006-03-10 13:13:27.91 spid4s 0 transactions rolled back in database 'sTlog' (8). This is an informational message only. No user action is required.
2006-03-10 13:13:27.91 spid4s Recovery is writing a checkpoint in database 'sTlog' (8). This is an informational message only. No user action is required.
2006-03-10 13:13:27.91 spid16s External dump process return code 0x20000001.
We have a (non-production) server that began exhibiting this kind of behavior last week... i.e., DB's going into recovery after a reboot and just not coming back, but then after a subsequent reboot, they appear to be just fine. I initially tried solving the problem by restoring the problem db's but have yet to discover the CAUSE or this whack-a-mole (non)recovery problem. I've almost got all db's on-line, but don't want to even think about re-booting!
Did you end up rebuilding your server?
No comments:
Post a Comment