XtraBackup 8.0.32-26 (MySQL 8.0.30) prepare fails on NFS drive (NFS located on Windows Server). This db was upgraded from 5.7.40 to 8.0.30.
2023-04-25T13:27:33.207118+02:00 0 [Note] [MY-013883] [InnoDB] The latest found checkpoint is at lsn = 458221935013 in redo log file ./#innodb_redo/#ib_redo0.
2023-04-25T13:27:33.208315+02:00 0 [Note] [MY-012560] [InnoDB] The log sequence number 374957330444 in the system tablespace does not match the log sequence number 458221935013 in the redo log files!
2023-04-25T13:27:33.208339+02:00 0 [Note] [MY-012551] [InnoDB] Database was not shutdown normally!
2023-04-25T13:27:33.208350+02:00 0 [Note] [MY-012552] [InnoDB] Starting crash recovery.
2023-04-25T13:27:33.210387+02:00 0 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 458221934739, whereas checkpoint_lsn = 458221935013 and start_lsn = 458221934592
2023-04-25T13:27:33.210413+02:00 0 [Note] [MY-012550] [InnoDB] Doing recovery: scanned up to log sequence number 458221940575
2023-04-24T20:32:51.321567+02:00 0 [ERROR] [MY-012574] [InnoDB] Unable to lock ./#innodb_redo/#ib_redo0 error: 5
2023-04-24T20:32:51.321891+02:00 0 [ERROR] [MY-012894] [InnoDB] Unable to open ‘./#innodb_redo/#ib_redo0’ (error: 11).
2023-04-24T20:32:51.321910+02:00 0 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Cannot open a file.
2023-04-24T20:32:51.416707+02:00 0 [ERROR] [MY-011825] [Xtrabackup] innodb_init(): Error occured
I tried the following and worked:
- Same DB (XtraBackup 8.0.32-26 - MySQL 8.0.30) to NFS on linux
- Same DB (XtraBackup 8.0.32-26 - MySQL 8.0.30) to local disk
- Another DB (XtraBackup 8.0.25-17 - MySQL 8.0.25) to NFS on Windows Server
- Another DB (XtraBackup 2.4.26 - MySQL 5.7.40) to NFS on Windows Server
Any idea? Thx.