[MDEV-14176] XtraDB files with innodb_page_size in MariaDB 5.5 are incompatible with later versions Created: 2017-10-27  Updated: 2018-05-28  Resolved: 2018-05-28

Status: Closed
Project: MariaDB Server
Component/s: Backup, Storage Engine - XtraDB
Affects Version/s: 5.5
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Andrii Nikitin (Inactive) Assignee: Marko Mäkelä
Resolution: Won't Fix Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-14936 Test MariaDB Backup 10.1 against newe... Closed

 Description   

IMPORTANT: Please check that the backup run completes successfully.
           At the end of a successful backup run innobackupex
           prints "completed OK!".
 
171027 13:56:59 Connecting to MySQL server host: localhost, user: root, password: not set, port: not set, socket: /dev/shm/__var0/tmp/mysql.sock.ONIJra
Using server version 5.5.58-MariaDB
--innobackupex based on MariaDB server 10.1.29-MariaDB Linux (x86_64) 
mariabackup: uses posix_fadvise().
mariabackup: cd to /dev/shm/__var0/var1/data/
mariabackup: open files limit requested 0, set to 1024
InnoDB: The universal page size of the database is set to 8192.
mariabackup: using the following InnoDB configuration:
mariabackup:   innodb_data_home_dir = ./
mariabackup:   innodb_data_file_path = ibdata1:10M:autoextend
mariabackup:   innodb_log_group_home_dir = ./
mariabackup:   innodb_log_files_in_group = 2
mariabackup:   innodb_log_file_size = 50331648
171027 13:56:59 >> log scanned up to (7717114)
2017-10-27 13:56:59 140589288627136 [ERROR] InnoDB: Data file "./ibdata1" uses page size 16384 ,but the start-up parameter is --innodb-page-size=8192 .
mariabackup: Could not open or create data files.
mariabackup: If you tried to add new data files, and it failed here,
mariabackup: you should now edit innodb_data_file_path in my.cnf back
mariabackup: to what it was, and remove the new ibdata files InnoDB created
mariabackup: in this failed attempt. InnoDB only wrote those files full of
mariabackup: zeros, but did not yet use them in any way. But be careful: do not
mariabackup: remove old data files which contain your precious data!
mariabackup: error: xb_load_tablespaces() failed witherror code 11

I've double checked that the Server indeed uses 8K page size, despite mariabackup claims ibdata1 is 16K



 Comments   
Comment by Marko Mäkelä [ 2018-05-28 ]

The parameter innodb_page_size was first introduced in XtraDB based on MySQL 5.5. When Oracle implemented it in MySQL 5.6, it explicitly stored the page size in the FSP_SPACE_FLAGS field in each data file. Because the XtraDB implementation in MariaDB 5.5 does not do this, files created with it using a non-default innodb_page_size will not be compatible with later releases.

I do not think that it is feasible to fix this incompatibility. Those who used innodb_page_size in MariaDB 5.5 will have to upgrade by dumping and reloading the data.

I do not think it is feasible for Mariabackup to support this old format either. Unlike Xtrabackup, Mariabackup is linked with the unmodified storage engine code.

Generated at Thu Feb 08 08:11:30 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.