Access violation in the sqlmin!RootPageIdChanges::UpdateSp ecialSystemHoBtRootOrFirstIAM function in SQL Server 2012

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
August 30th, 2015 1:36pm

What is output of select @@Version. What is SPID 60 did you found out ?
Free Windows Admin Tool Kit Click here and download it now
August 30th, 2015 1:40pm

hi shanky_621,

the version,

Microsoft SQL Server 2012 - 11.0.5522.0 (X64)
 Jun 17 2014 17:01:31
 Copyright (c) Microsoft Corporation
 Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

August 30th, 2015 2:25pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics