Logreader failed after upgrade. by MSSales Dev

Closed

as By Design Help for as By Design

Type:	Bug
ID:	339520
Opened:	4/23/2008 12:00:27 AM
Access Restriction:	Public

Workaround(s)

view

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

Details (expand)

English

SQL Server 2008 February CTP

Replication

Windows Server 2003 (all x64 editions)

US English

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.

X64

0 attachments

Posted by Microsoft on 11/4/2008 at 3:41 PM

Will add documentation for this in next release.

Posted by Microsoft 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.

Posted by Microsoft 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.

Microsoft