Xtrabackup 8.0.35-31 Failure : [MY-012541] [Xtrabackup] An undo ddl truncation (could be automatic) operation has been performed

MySQL & MariaDB Percona XtraBackup
1

Hello Percona Community, help please ! -
our version of xtrabackup : xtrabackup version 8.0.35-31
our version of mysql8 : mysql Ver 8.0.32-24

We are randomly getting backup failures with the follow error. The error code seems consistent on each failure, across different databases, at random times.

2024-08-12T18:08:01.991597-04:00 1 [Note] [MY-011825] [Xtrabackup] Last flushed lsn: 306812453231104 undo_delete lsn 306817828617742
2024-08-12T18:08:01.991657-04:00 1 [ERROR] [MY-012541] [Xtrabackup] An undo ddl truncation (could be automatic) operation has been performed.   PXB will not be able to take a consistent backup. Retry the backup operation later or with --lock-ddl

Our backup command uses --lock-ddl , even though its failing with that error :

root      60987  60835 99 12:01 ?        09:05:26 xtrabackup --backup --no-lock --slave-info --safe-slave-backup --lock-ddl --compress --user=xxx --password=x xxxxxxxxxxxxxx --compress-threads=8 --use-memory=12G --parallel=8 --encrypt-threads=8 --encrypt=AES128 --encrypt-key=x xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx --stream=xbstream --register-redo-log-consumer --extra-lsndir=/var/log/mysql/bkup_info/full/2024-08-13-16-01-52 --target-dir=/var/log/mysql/bkup_info/full/2024-08-13-16-01-52

It is odd since we are not doing and DDL commands, this was also double confirmed by going through the binlogs.

I was not able to see others with the same error code thrown by xtrabackup.

Any suggestions or help ?

2

Hello @MSmith,
Do you have undo log truncation enabled? Is this on a replica? If this is a replica, trying removing the --no-lock option and give it a try.

3

following back up here.

We ended up extending out our undo log size , (innodb_max_undo_log_size) , which has solved the problem.

thanks again for your help in pinpointing this.