"The log was not applied to the intended LSN", lsn for incremental is ahead of scanned LSN

Bug #1442074 reported by Nickolay Ihalainen
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Percona XtraBackup moved to https://jira.percona.com/projects/PXB
New
Undecided
Unassigned

Bug Description

The problem is related to https://bugs.launchpad.net/percona-xtrabackup/+bug/1414221

During backup:
xtrabackup: The latest check point (for incremental): '32612243417684'
xtrabackup: Stopping log copying thread.
.>> log scanned up to (32612243417600)

At apply log stage:
xtrabackup: Log applied to lsn 32612243417578
xtrabackup: The intended lsn is 32612243417600

As you can see log scanning stopped before latest checkpoint and this could break incremental backups and probably it's a symptom for the original issue with non-applied last 106 bytes of xtrabackup transaction log.

I'm not able to reproduce this issue on a staging server, but it's not something related to high load (just 350 commits per second, 250 insert per second)

Tags: i50241 i53096
Revision history for this message
Nickolay Ihalainen (ihanick) wrote :

The problem frequently happens with Xtrabackup 2.2.6 and 2.2.10 with and without LOCK TABLES FOR BACKUP.

Przemek (pmalkowski)
tags: added: i53096
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXB-1320

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.