Error: InnoDB: Unsupported redo log format. The redo log was created with MariaDB 10.4.26. Please follow the instructions at http://dev.mysql.com/doc/refman/5.7/en/upgrading-downgrading.html

MySQL & MariaDB
1

Hello,
I’ve used Percona Xtrabackup to perform a backup but when running the script show error: InnoDB: Unsupported redo log format. The redo log was created with MariaDB 10.4.26. Please follow the instructions at http://dev.mysql.com/doc/refman/5.7/en/upgrading-downgrading.html
If anyone could help with how I could proceed to debug / any ideas on how to fix these kinds of issues it would be most appreciated.
Thanks so much!

2

Hi Leo,

Thank you for being part of the community. Please, could you provide additional information?

  • Database version
  • Percona Xtrabackup version
  • Exact command used (parameters and options, but make sure to mask credentials and hostnames)

Thanks again,

Pep

1 Like
3

Hello Pep_Pla,
My information is bellow:
Database version: MariaDB 10.4 (10.3 still error)
Percona Xtrabackup version: xtrabackup version 2.4.26
Arguments used on command:
set_agr(){
xtra_agrs=(
“–user=$mysqlUser”
“–password=$mysqlPwd”
“–backup”
“–extra-lsndir=${todays_dir}”
“–compress”
“–stream=xbstream”
“–encrypt=AES256”
“–encrypt-key-file=${keyBackup}”
“–parallel=${processors}”
“–compress-threads=${processors}”
“–encrypt-threads=${processors}”
)
type_backup=“full”
if grep -q -s “to_lsn” “${todays_dir}/xtrabackup_checkpoints”; then
type_backup=“inc”
lsn=$(cat ${todays_dir}/xtrabackup_checkpoints | grep to_lsn | cut -d’=’ -f2)
xtra_agrs+=( “–incremental-lsn=${lsn}” )
fi
}
xtrabackup “${xtra_agrs[@]}” --target-dir=“${todays_dir}”

2 Likes
4

Hi Leo,

Unfortunately, MariaDB has made some internal changes that make MariaDB not compatible with Percona XtraBackup for recent versions of MariaDB.

[Percona XtraBackup Overview - MariaDB Knowledge Base]
[Percona XtraBackup Overview - MariaDB Knowledge Base]

Luckily MariaDB provides its backup tool.
[Mariabackup - MariaDB Knowledge Base]

I hope this helps,

Pep

1 Like
5

Hey @LEO_Ti_n,
As Pep said, there are many incompatibilities between MariaDB and “the rest of the MySQL community.” MariaDB tends to pick-n-choose what they want to support/provide and they tend not to follow upstream compatibility. We recommend you move to either MySQL Community or Percona MySQL (which follows Community) for maximum compatibility and worrisome-free troubleshooting.

From the ticket referenced in the KB article:

Just to clarify, Percona XtraBackup is internally built on top of MySQL Community Edition, and therefore as MariaDB Server has further diverged from MySQL, it is no longer possible for Percona XtraBackup to support MariaDB Server. MariaDB has forked Percona XtraBackup to create MariaBackup, which Percona Support includes support for, built on top of MariaDB Server as a result of this divergence.

At this point in time, it is not intended to support any future versions of MariaDB Server in Percona XtraBackup and the current major release (PXB 8.0) drops support for MariaDB Server entirely.

1 Like
6

Hello,
Thanks for your information on this case.
I will take a look at this.
Thanks!

1 Like