| Event Id | 18768 |
| Source | MSSQLServer |
| Description | The specified LSN (%ls) for repldone log scan occurs before the current start of replication in the log (%ls). |
| Event Information | CAUSE: There are unreplicated transactions in the transaction log that are marked for replication, but there are no current Log Reader Agents that can read those unreplicated transactions. The Log Reader Agent delivers replicated commands and transactions to the distribution database within transactions. After each transaction commits, the Log Reader Agent calls sp_repldone in the Publisher database to mark information such as the sequence number of the last distributed transaction and the commit record of the next transaction to scan for, if any. Since sp_repldone is called on the Publisher database, after the transaction is committed at the distribution database, it is possible for the Publisher database tracking data to have incorrect tracking data. For example, after the log reader successfully commits a transaction (we will call it T1) in the distribution database, and sp_repldone was called to update the Publisher database tracking data to remember T1 has been sent and transaction T2 is the next one to scan, now the Log Reader Agent moves on to transaction T2. If the Publisher is shut down immediately after the Log Reader Agent commits transaction T2 in the distribution database but before sp_repldone is called to update the Publisher database tracking information, then when the Publisher comes back up, the tracking data still indicates that T1 was just sent and T2 is the next to scan. However, this is inconsistant with the fact that T2 has been committed in the distribution database already. The Log Reader Agent handles this situation internally. The next time the Log Reader Agent starts, it will query the distribution database to find out the sequence number of the last distributed transaction (LSN). After that it calls sp_repldone to reset the Publisher database tracking data so that the set of commands and transactions that had been delivered are not sent again. This error may be raised if the transaction sequence number the Log Reader |
| Reference Links | Microsoft product: SQL Server Version: 2000.80.760.0 Event Source: MSSQLServer Event ID: 18768 |
Catch threats immediately
We work side-by-side with you to rapidly detect cyberthreats
and thwart attacks before they cause damage.