November 17, 2015 at 1:40 am
I will not post the whole of the stack dump (because I don't expect you to have time enough to reead it)
But for me the interesting part is
spid140External dump process return code 0x20002001. The error information has been submitted to Watson error reporting.
spid140Fehler: 17066, Schweregrad: 16, Status: 1.
spid140SQL Server Assertion: File: <"logmgr.cpp">, line=4597 Failed Assertion = 'retLC == m_flushQueue.Tail ()'. 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.
The server was restarted and DBCC CHECKDB(<DatabaseName>) WITH ALL_ERRORMSGS, NO_INFOMSGS; returned no error.
so all is now good, but I am having some trouble with this error 17066.
I have found three articles,
1 Assertion failure or other issues occur when you run a DML query against a table or view that has two indexes in SQL Server 2008 or in SQL Server 2008 R2
https://support.microsoft.com/en-us/kb/2542225
2 Error 17066 when you replicate a table article that contains an ntext data type column in SQL Server 2008 R2 or in SQL Server 2012
https://support.microsoft.com/en-us/kb/2754800
3 "Error: 17066" occurs when you create a partitioned nonclustered index in SQL Server 2008 R2 if a parallel execution plan is used
https://support.microsoft.com/en-us/kb/2530913
but none of them apply to us and we have SP2 in place which is shown as the fix
Any further help in identifying what caused the stack dump would be much appreciated.
After the stack dump this message is logged until the server is restarted
Process 0:0:0 (0x5c4) Worker 0x00000000800021A0 appears to be non-yielding on Scheduler
Am I safe to assume this is a symptom of the stack dump and not a cause
Many Thanks in advance
Ian
November 17, 2015 at 1:47 am
With the very limited amount posted, and no other error messages, really hard to say anything useful.
If you're getting frequent stack dumps and hung schedulers, call product support (if you have extended support for SQL 2008), neither should happen.
Also, make sure you're on the latest service pack for 2008 R2 (it's not SP2)
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
November 17, 2015 at 2:03 am
Thank you Gail.
It is actually the first stack dump we have had on this hardware, which is two years old.
Hence my lack of experience dealing with it 🙂
Here is the stack dump in full
logdateprocessinfoMessage
2015-11-14 21:33:59.540spid140Using 'dbghelp.dll' version '4.0.5'
2015-11-14 21:33:59.540spid140**Dump thread - spid = 0, EC = 0x00000000DC9F64C0
2015-11-14 21:33:59.540spid140***Stack Dump being sent to D:\MSSQL\SysDataBases\MSSQL10_50.MSSQLSERVER\MSSQL\LOG\SQLDump0014.txt
2015-11-14 21:33:59.540spid140* *******************************************************************************
2015-11-14 21:33:59.540spid140*
2015-11-14 21:33:59.540spid140* BEGIN STACK DUMP:
2015-11-14 21:33:59.540spid140* 11/14/15 21:33:59 spid 140
2015-11-14 21:33:59.550spid140*
2015-11-14 21:33:59.550spid140* Location: "logmgr.cpp":4597
2015-11-14 21:33:59.550spid140* Expression: retLC == m_flushQueue.Tail ()
2015-11-14 21:33:59.550spid140* SPID: 140
2015-11-14 21:33:59.550spid140* Process ID: 1824
2015-11-14 21:33:59.550spid140*
2015-11-14 21:33:59.550spid140* Input Buffer 109 bytes -
2015-11-14 21:33:59.550spid140* 16 00 00 00 12 00 00 00 02 00 00 00 00 00 00 00 00 00
2015-11-14 21:33:59.550spid140* s p _ r e p 01 00 00 00 0b 00 73 00 70 00 5f 00 72 00 65 00 70 00
2015-11-14 21:33:59.550spid140* l c m d s & ô 6c 00 63 00 6d 00 64 00 73 00 00 00 00 00 26 04 04 f4
2015-11-14 21:33:59.550spid140* & & ÿ 01 00 00 00 00 26 04 04 00 00 00 00 00 00 26 04 04 ff
2015-11-14 21:33:59.550spid140* ÿÿÿ ¥ & ff ff ff 00 00 a5 0a 00 00 00 00 00 26 04 04 90 13 00
2015-11-14 21:33:59.550spid140* & & ¡ 00 00 00 26 04 04 00 00 00 00 00 00 26 04 04 20 a1 07
2015-11-14 21:33:59.550spid140* 00
2015-11-14 21:33:59.550spid140*
2015-11-14 21:33:59.550spid140*
2015-11-14 21:33:59.550spid140* MODULE BASE END SIZE
2015-11-14 21:33:59.550spid140* sqlservr 0000000000800000 0000000004411FFF 03c12000
2015-11-14 21:33:59.550spid140* ntdll 0000000076DF0000 0000000076F98FFF 001a9000
2015-11-14 21:33:59.550spid140* kernel32 0000000076BB0000 0000000076CCFFFF 00120000
2015-11-14 21:33:59.550spid140* KERNELBASE 000007FEFCC60000 000007FEFCCCAFFF 0006b000
2015-11-14 21:33:59.550spid140* ADVAPI32 000007FEFEBC0000 000007FEFEC9AFFF 000db000
2015-11-14 21:33:59.550spid140* msvcrt 000007FEFE160000 000007FEFE1FEFFF 0009f000
2015-11-14 21:33:59.550spid140* sechost 000007FEFE140000 000007FEFE15EFFF 0001f000
2015-11-14 21:33:59.550spid140* RPCRT4 000007FEFE000000 000007FEFE12CFFF 0012d000
2015-11-14 21:33:59.550spid140* MSVCR80 0000000074310000 00000000743D8FFF 000c9000
2015-11-14 21:33:59.550spid140* MSVCP80 00000000737A0000 00000000738A8FFF 00109000
2015-11-14 21:33:59.550spid140* sqlos 0000000074540000 0000000074546FFF 00007000
2015-11-14 21:33:59.550spid140* Secur32 000007FEFC7D0000 000007FEFC7DAFFF 0000b000
2015-11-14 21:33:59.550spid140* SSPICLI 000007FEFC9A0000 000007FEFC9C4FFF 00025000
2015-11-14 21:33:59.550spid140* pdh 000007FEF3290000 000007FEF32DDFFF 0004e000
2015-11-14 21:33:59.550spid140* SHLWAPI 000007FEFCFF0000 000007FEFD060FFF 00071000
2015-11-14 21:33:59.550spid140* GDI32 000007FEFEA80000 000007FEFEAE6FFF 00067000
2015-11-14 21:33:59.550spid140* USER32 0000000076CF0000 0000000076DE9FFF 000fa000
2015-11-14 21:33:59.550spid140* LPK 000007FEFE6D0000 000007FEFE6DDFFF 0000e000
2015-11-14 21:33:59.550spid140* USP10 000007FEFEAF0000 000007FEFEBB8FFF 000c9000
2015-11-14 21:33:59.550spid140* USERENV 000007FEFCCD0000 000007FEFCCEDFFF 0001e000
2015-11-14 21:33:59.550spid140* profapi 000007FEFCBA0000 000007FEFCBAEFFF 0000f000
2015-11-14 21:33:59.550spid140* WINMM 000007FEF3250000 000007FEF328AFFF 0003b000
2015-11-14 21:33:59.550spid140* IPHLPAPI 000007FEFACE0000 000007FEFAD06FFF 00027000
2015-11-14 21:33:59.550spid140* NSI 000007FEFE130000 000007FEFE137FFF 00008000
2015-11-14 21:33:59.550spid140* WINNSI 000007FEFACD0000 000007FEFACDAFFF 0000b000
2015-11-14 21:33:59.550spid140* opends60 0000000074530000 0000000074537FFF 00008000
2015-11-14 21:33:59.550spid140* NETAPI32 000007FEFB890000 000007FEFB8A5FFF 00016000
2015-11-14 21:33:59.550spid140* netutils 000007FEFC4F0000 000007FEFC4FBFFF 0000c000
2015-11-14 21:33:59.550spid140* srvcli 000007FEFC670000 000007FEFC692FFF 00023000
2015-11-14 21:33:59.550spid140* wkscli 000007FEFB480000 000007FEFB494FFF 00015000
2015-11-14 21:33:59.550spid140* LOGONCLI 000007FEFC320000 000007FEFC34FFFF 00030000
2015-11-14 21:33:59.550spid140* SAMCLI 000007FEF9F50000 000007FEF9F63FFF 00014000
2015-11-14 21:33:59.550spid140* BatchParser 00000000744B0000 00000000744DCFFF 0002d000
2015-11-14 21:33:59.550spid140* IMM32 000007FEFEF70000 000007FEFEF9DFFF 0002e000
2015-11-14 21:33:59.550spid140* MSCTF 000007FEFE560000 000007FEFE668FFF 00109000
2015-11-14 21:33:59.550spid140* psapi 0000000076FC0000 0000000076FC6FFF 00007000
2015-11-14 21:33:59.550spid140* instapi10 0000000073700000 000000007370CFFF 0000d000
2015-11-14 21:33:59.550spid140* cscapi 000007FEF9A80000 000007FEF9A8EFFF 0000f000
2015-11-14 21:33:59.550spid140* sqlevn70 0000000073410000 0000000073682FFF 00273000
2015-11-14 21:33:59.550spid140* sqlevn70 0000000073200000 0000000073403FFF 00204000
2015-11-14 21:33:59.550spid140* CRYPTSP 000007FEFC510000 000007FEFC526FFF 00017000
2015-11-14 21:33:59.550spid140* rsaenh 000007FEFC130000 000007FEFC176FFF 00047000
2015-11-14 21:33:59.550spid140* CRYPTBASE 000007FEFCA30000 000007FEFCA3EFFF 0000f000
2015-11-14 21:33:59.550spid140* BROWCLI 000007FEF2E20000 000007FEF2E31FFF 00012000
2015-11-14 21:33:59.550spid140* AUTHZ 000007FEFC5A0000 000007FEFC5CEFFF 0002f000
2015-11-14 21:33:59.550spid140* MSCOREE 000007FEF9450000 000007FEF94BEFFF 0006f000
2015-11-14 21:33:59.550spid140* mscoreei 000007FEF93B0000 000007FEF944CFFF 0009d000
2015-11-14 21:33:59.550spid140* ole32 000007FEFE870000 000007FEFEA72FFF 00203000
2015-11-14 21:33:59.550spid140* credssp 000007FEFBFB0000 000007FEFBFB9FFF 0000a000
2015-11-14 21:33:59.550spid140* msv1_0 000007FEFC2C0000 000007FEFC311FFF 00052000
2015-11-14 21:33:59.550spid140* cryptdll 000007FEFC650000 000007FEFC663FFF 00014000
2015-11-14 21:33:59.550spid140* kerberos 000007FEFC3B0000 000007FEFC467FFF 000b8000
2015-11-14 21:33:59.550spid140* MSASN1 000007FEFCB90000 000007FEFCB9EFFF 0000f000
2015-11-14 21:33:59.550spid140* schannel 000007FEFC200000 000007FEFC256FFF 00057000
2015-11-14 21:33:59.550spid140* CRYPT32 000007FEFCD40000 000007FEFCEACFFF 0016d000
2015-11-14 21:33:59.550spid140* security 0000000074470000 0000000074472FFF 00003000
2015-11-14 21:33:59.550spid140* WS2_32 000007FEFE510000 000007FEFE55CFFF 0004d000
2015-11-14 21:33:59.550spid140* SHELL32 000007FEFD090000 000007FEFDE19FFF 00d8a000
2015-11-14 21:33:59.550spid140* OLEAUT32 000007FEFF020000 000007FEFF0F6FFF 000d7000
2015-11-14 21:33:59.550spid140* ftimport 0000000060000000 0000000060024FFF 00025000
2015-11-14 21:33:59.550spid140* MSFTE 0000000049980000 0000000049D2DFFF 003ae000
2015-11-14 21:33:59.550spid140* VERSION 000007FEFBC60000 000007FEFBC6BFFF 0000c000
2015-11-14 21:33:59.550spid140* dbghelp 000000006DCA0000 000000006DDFDFFF 0015e000
2015-11-14 21:33:59.550spid140* WINTRUST 000007FEFCBB0000 000007FEFCBEAFFF 0003b000
2015-11-14 21:33:59.550spid140* ncrypt 000007FEFC470000 000007FEFC4BFFFF 00050000
2015-11-14 21:33:59.550spid140* bcrypt 000007FEFC570000 000007FEFC591FFF 00022000
2015-11-14 21:33:59.550spid140* ntmarta 000007FEFBC30000 000007FEFBC5CFFF 0002d000
2015-11-14 21:33:59.550spid140* WLDAP32 000007FEFE670000 000007FEFE6C1FFF 00052000
2015-11-14 21:33:59.550spid140* mswsock 000007FEFC350000 000007FEFC3A4FFF 00055000
2015-11-14 21:33:59.550spid140* wship6 000007FEFC500000 000007FEFC506FFF 00007000
2015-11-14 21:33:59.550spid140* wshtcpip 000007FEFBD30000 000007FEFBD36FFF 00007000
2015-11-14 21:33:59.550spid140* ntdsapi 000007FEFA110000 000007FEFA136FFF 00027000
2015-11-14 21:33:59.550spid140* DNSAPI 000007FEFC260000 000007FEFC2BAFFF 0005b000
2015-11-14 21:33:59.550spid140* rasadhlp 000007FEFA170000 000007FEFA177FFF 00008000
2015-11-14 21:33:59.550spid140* fwpuclnt 000007FEFAA20000 000007FEFAA72FFF 00053000
2015-11-14 21:33:59.550spid140* bcryptprimitives 000007FEFBED0000 000007FEFBF1BFFF 0004c000
2015-11-14 21:33:59.550spid140* CLBCatQ 000007FEFE200000 000007FEFE298FFF 00099000
2015-11-14 21:33:59.550spid140* sqlncli10 000000006CAB0000 000000006CD6CFFF 002bd000
2015-11-14 21:33:59.550spid140* COMCTL32 000007FEF9AD0000 000007FEF9B6FFFF 000a0000
2015-11-14 21:33:59.550spid140* COMDLG32 000007FEFCF50000 000007FEFCFE6FFF 00097000
2015-11-14 21:33:59.550spid140* SQLNCLIR10 000000006C6B0000 000000006C6EBFFF 0003c000
2015-11-14 21:33:59.550spid140* netbios 000007FEEF400000 000007FEEF409FFF 0000a000
2015-11-14 21:33:59.550spid140* xpsqlbot 000000006BA40000 000000006BA47FFF 00008000
2015-11-14 21:33:59.550spid140* xpstar 000000006B9B0000 000000006BA37FFF 00088000
2015-11-14 21:33:59.550spid140* SQLSCM 000000006CAA0000 000000006CAADFFF 0000e000
2015-11-14 21:33:59.550spid140* ODBC32 000007FEEF6F0000 000007FEEF7A0FFF 000b1000
2015-11-14 21:33:59.560spid140* ATL80 0000000073B00000 0000000073B1FFFF 00020000
2015-11-14 21:33:59.560spid140* odbcint 000000006CA20000 000000006CA57FFF 00038000
2015-11-14 21:33:59.560spid140* clusapi 000007FEF2FB0000 000007FEF2FFFFFF 00050000
2015-11-14 21:33:59.560spid140* resutils 000007FEF2F90000 000007FEF2FA8FFF 00019000
2015-11-14 21:33:59.560spid140* xpstar 000000006B960000 000000006B985FFF 00026000
2015-11-14 21:33:59.560spid140* xplog70 000000006B950000 000000006B95FFFF 00010000
2015-11-14 21:33:59.560spid140* xplog70 000000006B940000 000000006B942FFF 00003000
2015-11-14 21:33:59.560spid140* dsrole 000007FEFB880000 000007FEFB88BFFF 0000c000
2015-11-14 21:33:59.560spid140* COMRES 0000000057DE0000 0000000057F1DFFF 0013e000
2015-11-14 21:33:59.560spid140* XOLEHLP 000007FEE2930000 000007FEE2943FFF 00014000
2015-11-14 21:33:59.560spid140* MSDTCPRX 000007FEE2950000 000007FEE2A0BFFF 000bc000
2015-11-14 21:33:59.560spid140* MTXCLU 000007FEE69E0000 000007FEE6A3FFFF 00060000
2015-11-14 21:33:59.560spid140* ktmw32 000007FEFA840000 000007FEFA849FFF 0000a000
2015-11-14 21:33:59.560spid140* RpcRtRemote 000007FEFCAE0000 000007FEFCAF3FFF 00014000
2015-11-14 21:33:59.560spid140* apphelp 000007FEFC9D0000 000007FEFCA26FFF 00057000
2015-11-14 21:33:59.560spid140* msxmlsql 000000004C8C0000 000000004CA10FFF 00151000
2015-11-14 21:33:59.560spid140* oledb32 000007FEE82D0000 000007FEE83DDFFF 0010e000
2015-11-14 21:33:59.560spid140* MSDART 000007FEE82A0000 000007FEE82C7FFF 00028000
2015-11-14 21:33:59.560spid140* Comctl32 000007FEFB570000 000007FEFB763FFF 001f4000
2015-11-14 21:33:59.560spid140* OLEDB32R 000000003FC70000 000000003FC83FFF 00014000
2015-11-14 21:33:59.560spid140* msadce 000007FEEA3D0000 000007FEEA486FFF 000b7000
2015-11-14 21:33:59.560spid140* msadcer 000000006B600000 000000006B601FFF 00002000
2015-11-14 21:33:59.560spid140* mscorwks 000007FEF32E0000 000007FEF3C7DFFF 0099e000
2015-11-14 21:33:59.560spid140* mscorlib.ni 000007FEF1EE0000 000007FEF2DBDFFF 00ede000
2015-11-14 21:33:59.560spid140* mscorsec 000007FEF2E00000 000007FEF2E18FFF 00019000
2015-11-14 21:33:59.560spid140* imagehlp 000007FEFD070000 000007FEFD088FFF 00019000
2015-11-14 21:33:59.560spid140* GPAPI 000007FEFBE20000 000007FEFBE3AFFF 0001b000
2015-11-14 21:33:59.560spid140* cryptnet 000007FEF9780000 000007FEF97A6FFF 00027000
2015-11-14 21:33:59.560spid140* SensApi 000007FEF02A0000 000007FEF02A8FFF 00009000
2015-11-14 21:33:59.560spid140* mscorlib.resources 0000000073B90000 0000000073BDFFFF 00050000
2015-11-14 21:33:59.560spid140* SqlAccess 0000000042420000 0000000042483FFF 00064000
2015-11-14 21:33:59.560spid140* mscorjit 000007FEF00F0000 000007FEF0272FFF 00183000
2015-11-14 21:33:59.560spid140* System.Data 000000006D930000 000000006DC36FFF 00307000
2015-11-14 21:33:59.560spid140* System.ni 000007FEEE8E0000 000007FEEF30EFFF 00a2f000
2015-11-14 21:33:59.560spid140* System.Transactions 000000006B4A0000 000000006B4E8FFF 00049000
2015-11-14 21:33:59.560spid140* System.Security.ni 000007FEE7B10000 000007FEE7BFBFFF 000ec000
2015-11-14 21:33:59.560spid140* instapi 0000000048060000 000000004806CFFF 0000d000
2015-11-14 21:33:59.560spid140* dbghelp 000000004C5E0000 000000004C73DFFF 0015e000
2015-11-14 21:33:59.560spid140*
2015-11-14 21:33:59.560spid140* P1Home: 0044004C00510053:
2015-11-14 21:33:59.560spid140* P2Home: 00000000005302B4: 0122002501210023 0024002900230027 0126002D0025002B 012800310127002F 002A003501290033 002C0039002B0037
2015-11-14 21:33:59.560spid140* P3Home: 0000000000579F60: 00000000477D4540 00000000477D4540 0000000000000000 0000000000000000 0000000000000000 0000000000000000
2015-11-14 21:33:59.560spid140* P4Home: 0000000000000000:
2015-11-14 21:33:59.560spid140* P5Home: 00750044008E008C:
2015-11-14 21:33:59.560spid140* P6Home: 0000000000431B48: 004D005C003A0044 004C005100530053 007300790053005C 0061007400610044 0065007300610042 0053004D005C0073
2015-11-14 21:33:59.560spid140* ContextFlags: 000000000010004F: 0000010000000000 0000000000000000 0000000010FFE000 0000000010FFE000 0000000000100200 1000000000000000
2015-11-14 21:33:59.560spid140* MxCsr: 0000000000001FA0:
2015-11-14 21:33:59.560spid140* SegCs: 0000000000000033:
2015-11-14 21:33:59.560spid140* SegDs: 000000000000002B:
2015-11-14 21:33:59.560spid140* SegEs: 000000000000002B:
2015-11-14 21:33:59.560spid140* SegFs: 0000000000000053:
2015-11-14 21:33:59.560spid140* SegGs: 000000000000002B:
2015-11-14 21:33:59.560spid140* SegSs: 000000000000002B:
2015-11-14 21:33:59.560spid140* EFlags: 0000000000000206:
2015-11-14 21:33:59.560spid140* Rax: 000000003C94B2D4: 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000
2015-11-14 21:33:59.560spid140* Rcx: 000000004A66B2B0: 0044004C00510053 00000000005302B4 0000000000579F60 0000000000000000 00750044008E008C 0000000000431B48
2015-11-14 21:33:59.560spid140* Rdx: 0000000000000000:
2015-11-14 21:33:59.560spid140* Rbx: 0000000000000000:
2015-11-14 21:33:59.560spid140* Rsp: 000000004A66B8C0: 0000000000000000 00000000DC9F64C0 000000004A66BAF0 0000000000000000 00000000000042AC 0000000000000000
2015-11-14 21:33:59.560spid140* Rbp: 000000004A66D050: 00000539000011F5 0000000100000001 00000000FFFFFFFF 000000000418FA30 0000000000000065 0000000000D54F29
2015-11-14 21:33:59.560spid140* Rsi: 00000000DC9F64C0: 00000000DC9F64C0 00000000DC9F4EA0 0000000000000000 0000000000000000 00000000DC9F64E0 00000000DC9F64E0
2015-11-14 21:33:59.560spid140* Rdi: 000000004A66BAF0: 0000000000431B40 0000000000000000 0000000000000000 0000000000000000 0000000000000001 0000000000000000
2015-11-14 21:33:59.560spid140* R8: 0000000000000000:
2015-11-14 21:33:59.560spid140* R9: 0000000000000000:
2015-11-14 21:33:59.560spid140* R10: 0000000000000000:
2015-11-14 21:33:59.560spid140* R11: 000000004A66C0D0: 0044004C00510053 00000000005302B4 0000000000579F60 0000000000000000 00750044008E008C 0000000000431B48
2015-11-14 21:33:59.560spid140* R12: 0000000000000001:
2015-11-14 21:33:59.560spid140* R13: 00000000DC9F4EA0: 00000000DC9F4080 00000000DC9F43B0 00000000DC9F4AD0 00000000DC9F6450 00000000DC9F4F10 00000000D94D9DD0
2015-11-14 21:33:59.560spid140* R14: 000000004A66CF80: 00610063006F004C 006E006F00690074 002200200009003A 006D0067006F006C 0063002E00720067 003A002200700070
2015-11-14 21:33:59.560spid140* R15: 000000000000003F:
2015-11-14 21:33:59.560spid140* Rip: 000007FEFCC6ADCD: C3000000C8C48148 9090909090909090 415756F3FF909090 4857415641554154 8B4800000480EC81 C433480005621605
2015-11-14 21:33:59.560spid140* *******************************************************************************
2015-11-14 21:33:59.560spid140* -------------------------------------------------------------------------------
2015-11-14 21:33:59.560spid140* Short Stack Dump
2015-11-14 21:33:59.570spid140000007FEFCC6ADCD Module(KERNELBASE+000000000000ADCD)
2015-11-14 21:33:59.570spid14000000000028D974D Module(sqlservr+00000000020D974D)
2015-11-14 21:33:59.570spid14000000000028DDC86 Module(sqlservr+00000000020DDC86)
2015-11-14 21:33:59.570spid140000000000254CB94 Module(sqlservr+0000000001D4CB94)
2015-11-14 21:33:59.570spid1400000000001099080 Module(sqlservr+0000000000899080)
2015-11-14 21:33:59.580spid1400000000000D02DFE Module(sqlservr+0000000000502DFE)
2015-11-14 21:33:59.580spid140000000000290A955 Module(sqlservr+000000000210A955)
2015-11-14 21:33:59.580spid140000000000290A588 Module(sqlservr+000000000210A588)
2015-11-14 21:33:59.580spid140000000000290A3C2 Module(sqlservr+000000000210A3C2)
2015-11-14 21:33:59.580spid140000000000290A052 Module(sqlservr+000000000210A052)
2015-11-14 21:33:59.580spid1400000000002517826 Module(sqlservr+0000000001D17826)
2015-11-14 21:33:59.580spid14000000000025050CA Module(sqlservr+0000000001D050CA)
2015-11-14 21:33:59.580spid14000000000025012CB Module(sqlservr+0000000001D012CB)
2015-11-14 21:33:59.580spid1400000000001CDC33E Module(sqlservr+00000000014DC33E)
2015-11-14 21:33:59.580spid1400000000001CDB70F Module(sqlservr+00000000014DB70F)
2015-11-14 21:33:59.580spid1400000000000E72D3C Module(sqlservr+0000000000672D3C)
2015-11-14 21:33:59.580spid1400000000000D8C800 Module(sqlservr+000000000058C800)
2015-11-14 21:33:59.580spid1400000000000D57714 Module(sqlservr+0000000000557714)
2015-11-14 21:33:59.580spid140000000000080AB94 Module(sqlservr+000000000000AB94)
2015-11-14 21:33:59.590spid140000000000080B05E Module(sqlservr+000000000000B05E)
2015-11-14 21:33:59.590spid140000000000080AD57 Module(sqlservr+000000000000AD57)
2015-11-14 21:33:59.590spid1400000000000CE51DE Module(sqlservr+00000000004E51DE)
2015-11-14 21:33:59.590spid1400000000000CE5395 Module(sqlservr+00000000004E5395)
2015-11-14 21:33:59.590spid1400000000000CE8925 Module(sqlservr+00000000004E8925)
2015-11-14 21:33:59.600spid1400000000000CE59D6 Module(sqlservr+00000000004E59D6)
2015-11-14 21:33:59.600spid14000000000743137D7 Module(MSVCR80+00000000000037D7)
2015-11-14 21:33:59.610spid1400000000074313894 Module(MSVCR80+0000000000003894)
2015-11-14 21:33:59.620spid1400000000076BC59DD Module(kernel32+00000000000159DD)
2015-11-14 21:33:59.620spid1400000000076E1A631 Module(ntdll+000000000002A631)
2015-11-14 21:33:59.630spid140Stack Signature for the dump is 0x000000010C8CF918
2015-11-14 21:34:01.580spid140External dump process return code 0x20002001. The error information has been submitted to Watson error reporting.
2015-11-14 21:34:01.580spid140Fehler: 17066, Schweregrad: 16, Status: 1.
2015-11-14 21:34:01.580spid140SQL Server Assertion: File: <"logmgr.cpp">, line=4597 Failed Assertion = 'retLC == m_flushQueue.Tail ()'. 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.
November 17, 2015 at 2:06 am
Cool, and what other errors/messages are you seeing in the error log?
Are you seeing frequent stack dumps and/or hung schedulers?
Has anything changed recently?
Are you on the latest service pack of 2008 R2?
Did you run CheckDB as it suggested?
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
November 17, 2015 at 2:21 am
DBCC CheckDB showed no errors.
I roll the event logs over every two days and keep 7 logs (so 14 days worth of events) and other than some failed login attempts I have found nothing before the stack dump.
after the stack dump this message is apearing every couple of seconds up the restart
Message
Process 0:0:0 (0x18d8) Worker 0x000000192B6101A0 appears to be non-yielding on Scheduler 7. Thread creation time: 13092002768816. Approx Thread CPU Used: kernel 0 ms, user 93 ms. Process Utilization 2%. System Idle 97%. Interval: 1513285 ms.
or at least a variation of it.
November 17, 2015 at 2:25 am
GilaMonster (11/17/2015)
Has anything changed recently?Are you on the latest service pack of 2008 R2?
Anything since the restart?
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
November 17, 2015 at 2:40 am
Sorry, I miss read your comment.
Since the restart I only have logins and back ups in the event log plus the dbcc checkdb that I ran and the cycle error log.
So everything is currently looking good.
The server is on SP2.
I will fix that in a maintanance window on Wednesday evenning.
November 17, 2015 at 2:55 am
I have found this article
SQL Server 2012, SQL Server 2008 R2 or SQL Server 2008 stops responding and a "Non-yielding Scheduler" error is logged
https://support.microsoft.com/en-us/kb/2699013
and I am going to stop looking, as I suspect someone may have left a profiler trace open over the weekend.
Many thanks for your help Gail.
November 17, 2015 at 2:57 am
In that case, I'd suggest leave it and keep an eye on it.
If the stack dumps and hung schedulers happen again or start happening frequently, you may have a serious problem that needs addressing. However since 2008 R2 is out of support, you can't call Product Support with it, which makes debugging way harder
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
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply