Xtrabckup error after update mysql to version 8.0.30: File ./ib_logfile0: 'open' returned OS error 71. Cannot continue operation

Someone from the team left the server network free and the ubuntu packages were automatically updated at dawn. Now xtrabackup 8.0.29 is not working with mysql 8.0.30 even with --no-server-version-check=1 parameter. It’s showing the error:

xtrabackup version 8.0.29-22 based on MySQL server 8.0.29 Linux (x86_64) (revision id: c31e7ddcce3)
220811 01:30:12  version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;host=localhost' as 'root'  (using password: YES).
220811 01:30:12  version_check Connected to MySQL server
220811 01:30:12  version_check Executing a version check against the server...
220811 01:30:12  version_check Done.
2022-08-11T01:30:12.895466-03:00 0 [Note] [MY-011825] [Xtrabackup] Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: not set
2022-08-11T01:30:12.899558-03:00 0 [Note] [MY-011825] [Xtrabackup] Using server version 8.0.30-0ubuntu0.20.04.2
2022-08-11T01:30:13.091979-03:00 0 [Note] [MY-011825] [Xtrabackup] Executing LOCK INSTANCE FOR BACKUP ...
2022-08-11T01:30:13.396989-03:00 0 [Note] [MY-011825] [Xtrabackup] uses posix_fadvise().
2022-08-11T01:30:13.397059-03:00 0 [Note] [MY-011825] [Xtrabackup] cd to /var/lib/mysql/
2022-08-11T01:30:13.397085-03:00 0 [Note] [MY-011825] [Xtrabackup] open files limit requested 0, set to 1024
2022-08-11T01:30:13.406288-03:00 0 [Note] [MY-011825] [Xtrabackup] using the following InnoDB configuration:
2022-08-11T01:30:13.406315-03:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_home_dir = .
2022-08-11T01:30:13.406329-03:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_file_path = ibdata1:12M:autoextend
2022-08-11T01:30:13.414681-03:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_group_home_dir = ./
2022-08-11T01:30:13.414707-03:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_files_in_group = 2
2022-08-11T01:30:13.414725-03:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_file_size = 1073741824
2022-08-11T01:30:13.425097-03:00 0 [Note] [MY-013251] [InnoDB] Number of pools: 1
2022-08-11T01:30:13.464025-03:00 0 [Note] [MY-011825] [Xtrabackup] inititialize_service_handles suceeded
2022-08-11T01:30:13.593214-03:00 0 [ERROR] [MY-012592] [InnoDB] Operating system error number 2 in a file operation.
2022-08-11T01:30:13.593285-03:00 0 [ERROR] [MY-012593] [InnoDB] The error means the system cannot find the path specified.
2022-08-11T01:30:13.593300-03:00 0 [ERROR] [MY-012594] [InnoDB] If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
2022-08-11T01:30:13.593315-03:00 0 [ERROR] [MY-012646] [InnoDB] File ./ib_logfile0: 'open' returned OS error 71. Cannot continue operation
2022-08-11T01:30:13.593330-03:00 0 [ERROR] [MY-012981] [InnoDB] Cannot continue operation.
1 Like

Oi @CESAR_MURILO_DA_SILV .

Xtrabackup 8.0.29 is not compatible with MySQL 8.0.30 . We are still working on a new release to merge 8.0.30 changes and make it compatible but we are still on the early stages of understanding those changes. For now I would suggest to rollback to 8.0.29 or using logical backup.

2 Likes