Details
-
Bug
-
Status: Needs Feedback (View Workflow)
-
Critical
-
Resolution: Unresolved
-
10.11.15
-
None
-
None
-
Centos stream 9
Description
Backup created on 10.11.11 and correctly always restored with 10.11.15
Now, update to 10.11.15 on the backup side, and can not restore correctly on restore side with 10.11.15
mariabackup based on MariaDB server 10.11.15-MariaDB Linux (x86_64)
[00] 2025-12-14 12:58:56 cd to /var/lib/mysql/20251214/
[00] 2025-12-14 12:58:56 open files limit requested 0, set to 1024
[00] FATAL ERROR: 2025-12-14 12:58:56 Can't open backup-my.cnf for reading
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xeu mariadb.service" for details.
ERROR 2002 (HY000): Can't connect to local server through socket '/var/lib/mysql/db/mysql.sock' (2)
ERROR 2002 (HY000): Can't connect to local server through socket '/var/lib/mysql/db/mysql.sock' (2)
2025-12-14 12:58:57 0 [Note] Starting MariaDB 10.11.15-MariaDB-log source revision cb0d6dd835023a7162ace471cd047161f205dd58 server_uid a0KDg6OAig3uIsu6hClHQ/Zfmb4= as process 115406
2025-12-14 12:58:57 0 [Warning] You need to use --log-bin to make --binlog-format work.
2025-12-14 12:58:57 0 [ERROR] mariadbd: Aria engine: log data error
last_log_page: (1,0x5a8000) is less than
checkpoint page: (1,0x5aa000)
2025-12-14 12:58:57 0 [ERROR] mariadbd: Aria engine: log initialization failed
2025-12-14 12:58:57 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2025-12-14 12:58:57 0 [Note] InnoDB: innodb_page_size=65536
2025-12-14 12:58:57 0 [Note] InnoDB: !!! innodb_force_recovery is set to 2 !!!
2025-12-14 12:58:57 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2025-12-14 12:58:57 0 [Note] InnoDB: Number of transaction pools: 1
2025-12-14 12:58:57 0 [Note] InnoDB: Using AVX512 instructions
2025-12-14 12:58:57 0 [Warning] mariadbd: io_uring_queue_init() failed with EPERM: sysctl kernel.io_uring_disabled has the value 2, or 1 and the user of the process is not a member of sysctl kernel.io_uring_group. (see man 2 io_uring_setup).
create_uring failed: falling back to libaio
2025-12-14 12:58:57 0 [Note] InnoDB: Using Linux native AIO
2025-12-14 12:58:57 0 [Note] InnoDB: innodb_buffer_pool_size_max=1024m, innodb_buffer_pool_size=1024m
2025-12-14 12:58:57 0 [Note] InnoDB: Completed initialization of buffer pool
2025-12-14 12:58:57 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
2025-12-14 12:58:58 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=133560890432425
2025-12-14 12:58:58 0 [Note] InnoDB: At LSN: 133560891200692: unable to open file ./rawdata/z_565.ibd for tablespace 24690259
2025-12-14 12:58:58 0 [ERROR] InnoDB: Not applying DELETE_ROW_FORMAT_DYNAMIC due to corruption on [page id: space=22788774, page number=264]
2025-12-14 12:58:58 0 [ERROR] InnoDB: Not applying DELETE_ROW_FORMAT_DYNAMIC due to corruption on [page id: space=22788774, page number=264]
2025-12-14 12:58:58 0 [ERROR] InnoDB: Not applying DELETE_ROW_FORMAT_DYNAMIC due to corruption on [page id: space=22788774, page number=264]
2025-12-14 12:58:58 0 [ERROR] InnoDB: Not applying DELETE_ROW_FORMAT_DYNAMIC due to corruption on [page id: space=22788774, page number=264]
2025-12-14 12:58:58 0 [ERROR] InnoDB: Not applying DELETE_ROW_FORMAT_DYNAMIC due to corruption on [page id: space=22788774, page number=264]
2025-12-14 12:59:20 0 [ERROR] InnoDB: Page [page id: space=0, page number=53376] log sequence number 133561104170750 is in the future! Current system log sequence number 133560995876495.
2025-12-14 12:59:20 0 [ERROR] InnoDB: Page [page id: space=0, page number=193681] log sequence number 133561109252027 is in the future! Current system log sequence number 133560995876495.
2025-12-14 12:59:20 0 [Note] InnoDB: Setting file '/var/lib/mysql/db/ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2025-12-14 12:59:20 0 [Note] InnoDB: File '/var/lib/mysql/db/ibtmp1' size is now 12.000MiB.
2025-12-14 12:59:20 0 [Note] InnoDB: log sequence number 133560995876495; transaction id 10589504796
2025-12-14 12:59:20 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/db/ib_buffer_pool
2025-12-14 12:59:20 0 [Note] InnoDB: Cannot open '/var/lib/mysql/db/ib_buffer_pool' for reading: No such file or directory
2025-12-14 12:59:20 0 [Note] Plugin 'FEEDBACK' is disabled.
2025-12-14 12:59:20 0 [ERROR] Could not open mysql.plugin table: "Unknown storage engine 'Aria'". Some plugins may be not loaded
2025-12-14 12:59:20 0 [ERROR] Failed to initialize plugins.
2025-12-14 12:59:20 0 [ERROR] Aborting
2025-12-14 12:59:20 0 [Note] Starting MariaDB 10.11.15-MariaDB-log source revision cb0d6dd835023a7162ace471cd047161f205dd58 server_uid a0KDg6OAig3uIsu6hClHQ/Zfmb4= as process 115637
2025-12-14 12:59:20 0 [Warning] You need to use --log-bin to make --binlog-format work.
2025-12-14 12:59:20 0 [ERROR] mariadbd: Aria engine: log data error
last_log_page: (1,0x5a8000) is less than
checkpoint page: (1,0x5aa000)
2025-12-14 12:59:20 0 [ERROR] mariadbd: Aria engine: log initialization failed
2025-12-14 12:59:20 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2025-12-14 12:59:20 0 [Note] InnoDB: innodb_page_size=65536
2025-12-14 12:59:20 0 [Note] InnoDB: !!! innodb_force_recovery is set to 2 !!!
2025-12-14 12:59:20 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2025-12-14 12:59:20 0 [Note] InnoDB: Number of transaction pools: 1
2025-12-14 12:59:20 0 [Note] InnoDB: Using AVX512 instructions
2025-12-14 12:59:20 0 [Warning] mariadbd: io_uring_queue_init() failed with EPERM: sysctl kernel.io_uring_disabled has the value 2, or 1 and the user of the process is not a member of sysctl kernel.io_uring_group. (see man 2 io_uring_setup).
create_uring failed: falling back to libaio
2025-12-14 12:59:20 0 [Note] InnoDB: Using Linux native AIO
2025-12-14 12:59:20 0 [Note] InnoDB: innodb_buffer_pool_size_max=1024m, innodb_buffer_pool_size=1024m
2025-12-14 12:59:20 0 [Note] InnoDB: Completed initialization of buffer pool
2025-12-14 12:59:20 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
2025-12-14 12:59:20 0 [Note] InnoDB: End of log at LSN=133560995876495
2025-12-14 12:59:20 0 [ERROR] InnoDB: Page [page id: space=0, page number=53376] log sequence number 133561104170750 is in the future! Current system log sequence number 133560995876495.
2025-12-14 12:59:20 0 [ERROR] InnoDB: Page [page id: space=0, page number=193681] log sequence number 133561109252027 is in the future! Current system log sequence number 133560995876495.
2025-12-14 12:59:20 0 [Note] InnoDB: Setting file '/var/lib/mysql/db/ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2025-12-14 12:59:20 0 [Note] InnoDB: File '/var/lib/mysql/db/ibtmp1' size is now 12.000MiB.
2025-12-14 12:59:20 0 [Note] InnoDB: log sequence number 133560995876495; transaction id 10589504796
2025-12-14 12:59:20 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/db/ib_buffer_pool
2025-12-14 12:59:20 0 [Note] InnoDB: Cannot open '/var/lib/mysql/db/ib_buffer_pool' for reading: No such file or directory
2025-12-14 12:59:20 0 [Note] Plugin 'FEEDBACK' is disabled.
2025-12-14 12:59:20 0 [ERROR] Could not open mysql.plugin table: "Unknown storage engine 'Aria'". Some plugins may be not loaded
2025-12-14 12:59:20 0 [ERROR] Failed to initialize plugins.
2025-12-14 12:59:20 0 [ERROR] Aborting
I set force recovery to = 4 and do mv /var/lib/mysql/db/aria_log.* /var/lib/mysql/db/aria_log.backup_*
Worked, but a lot of new errors with 10.11.15.