SQL Server Home
Logreader failed after upgrade.
as By Design
4/23/2008 12:00:27 AM
User(s) can reproduce this bug
encountered an issue with replication on JANA after upgrade. The replication log reader agent for database PANSALES is failing with these error:
2008-04-17 06:28:42.53 spid86 Error: 5243, Severity: 22, State: 4.
2008-04-17 06:28:42.53 spid86 An inconsistency was detected during an internal operation. Please contact technical support.
2008-04-17 06:28:42.55 spid85 Error: 14151, Severity: 18, State: 1.
2008-04-17 06:28:42.55 spid85 Replication-Replication Transaction-Log Reader Subsystem: agent JANA-PanSales-1 failed. The process could not execute 'sp_replcmds' on 'JANA'.
A note from Maria Balsamo
Ensure customer knows run logreader until it processes all pending logs before upgrade – or do it for them
SQL Server 2008 February CTP
Windows Server 2003 (all x64 editions)
Operating System Language
Steps to Reproduce
Upgraded server from YUKON to CTP6
Upgrade completed log reader started to fail for one db that is set to publish (other db's that were set to publish were ok).
upgrade to complete and replication to carry on working.
to post a comment.
Please enter a comment.
on 11/4/2008 at 3:41 PM
Will add documentation for this in next release.
on 4/24/2008 at 3:01 PM
Thanks for letting us know, we will make sure this requirement (drain log before upgrade) is reflected in BOL.
on 4/24/2008 at 11:06 AM
It is required to drain the log before upgrade, We are trying to make this a rule in the upgrade advisor to mitigate chances of other customers running into the issue.
to post a workaround.
Please enter a workaround.
© 2013 Microsoft