Xtrabackup constantly failing

We are constantly getting failed backups when the backup is run from a secondary server. How do we permanently fix this undo tablespace issue on the primary mysql server, so that the secondary doesn’t contain the undo tablespace error that is being reported.

MySQL: 8.0.28
XtraBackup: 8.0.28-21

[Note] [MY-013252] [InnoDB] Using undo tablespace '/db/logs/undo/undo_001'.
[Note] [MY-012902] [InnoDB] Undo tablespace number 2 was being truncated when mysqld quit.
[ERROR] [MY-012903] [InnoDB] Cannot recover a truncated undo tablespace in read-only mode
[ERROR] [MY-011825] [Xtrabackup] xb_load_tablespaces() failed with error code 57
1 Like

Hi @johnwcarew See this post. It should have a workaround for this problem

2 Likes