Kbase P143575: Replication synchronization fails after transitioning a source database to become a target database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
20/07/2010 |
|
Status: Verified
SYMPTOM(s):
Replication synchronization fails after transitioning a source database to become a target database
The source database which is being transitioned had previously crashed
The source database is in a crashed state
Target database log file shows the following errors:
SYSTEM ERROR: rlRecordGetLockManage error: encountered unexpected end logical operation for trid 862276579 recid 15811857 logicalOpId 2 (10404)
Function dsaAIApplyNote failed in rpNOT_ProcessNoteBlock with error -31010. (10428)
Block processing ended in error at block 0 in area 21. Fathom Replication cannot continue. (10495)
Unexpected error -31010 returned to function rpAGT_AgentLoop. (10504)
The Replication Server has been terminated or the Source database has been shutdown. The Agents will enter PRE-TRANSITION, waiting for re-connection from the Replication Server. (12688)
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge Replication 10.x
CAUSE:
It is not valid to transition a source database that is in a crashed state to become a target database.
When the source database is transitioned it will go through crash recovery, which means that it may apply or rollback transactions on this database that may not have been applied to the target. This in turn means that the two databases may not be identical and therefore a failure can occur when trying to synchronize them.
FIX:
The correct method for making the crashed source database become a target database is to re-create it from a copy of the new source database (the target database that had been transitioned to become a source database).