Resently, when i set up database mirroring,the mirror side would be occur dump and the database mirror suspend. After recovery the back files from database back file once again or restart the sqlserver service in the mirror side ,the mirror would be ok. is there any incorrect exception handing in the UpdateSpecialSystemHoBtRootOrFirstIAM function or other reasons ?
the dump as follows,
0:192> .ecxr
rax=000000000000420b rbx=0000000000000100 rcx=0000001b7d721390
rdx=00000000000021b0 rsi=000000007b43c940 rdi=0000001b7d721390
rip=000007fef8967fd7 rsp=000000007b43c880 rbp=0000000000000000
r8=000000000000420b r9=0000000000000000 r10=0000000000000100
r11=000000000000410b r12=0000000d8adf3958 r13=000000007b43d090
r14=000000007b43c988 r15=000000007b43d090
iopl=0 nv up ei pl nz na pe nc
cs=0033 ss=002b ds=002b es=002b fs=0053 gs=002b efl=00010202
sqlmin!RootPageIdChanges::UpdateSpecialSystemHoBtRootOrFirstIAM+0xe77:
000007fe`f8967fd7 488b4208 mov rax,qword ptr [rdx+8] ds:00000000`000021b8=????????????????
0:192> kc
*** Stack trace for last set context - .thread/.cxr resets it
Call Site
sqlmin!RootPageIdChanges::UpdateSpecialSystemHoBtRootOrFirstIAM
error log,
2015-08-27 06:41:23.650 spid60s Error: 1454, Severity: 16, State: 1.
2015-08-27 06:41:23.650 spid60s Database mirroring will be suspended. Server instance 'XXX' encountered error 2905, state 2, severity 25 when it was acting as a mirroring partner for database 'XXX'. The database mirroring partners
might try to recover automatically from the error and resume the mirroring session. For more information, view the error log for additional error messages.
- Edited by T.Encore 13 hours 33 minutes ago