Xtrabackup 8.0 is not working with MySQL 8.0.23?

Can you suggest Xtrabackup(8.0.) having issue with MySQL (8.0.23) with Backup prepare?

1 Like

Logs:

xtrabackup: [Warning] World-writable config file '/mysql_backup/xtrabackup/Daily/FULL/backup-my.cnf' is ignored.

xtrabackup: [Warning] World-writable config file '/mysql_backup/xtrabackup/Daily/FULL/backup-my.cnf' is ignored.

xtrabackup: recognized client arguments: --user=monitor --password=* --prepare=1 --apply-log-only=1 --target-dir=/mysql_backup/xtrabackup/Daily/FULL

xtrabackup version 8.0.22-15 based on MySQL server 8.0.22 Linux (x86_64) (revision id: fea8a0e)

xtrabackup: cd to /mysql_backup/xtrabackup/Daily/FULL/

xtrabackup: This target seems to be not prepared yet.

Number of pools: 1

xtrabackup: xtrabackup_logfile detected: size=8388608, start_lsn=(6691162815)

xtrabackup: using the following InnoDB configuration for recovery:

xtrabackup: innodb_data_home_dir = .

xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend

xtrabackup: innodb_log_group_home_dir = .

xtrabackup: innodb_log_files_in_group = 1

xtrabackup: innodb_log_file_size = 8388608

xtrabackup: [Warning] World-writable config file './backup-my.cnf' is ignored.

xtrabackup: using the following InnoDB configuration for recovery:

xtrabackup: innodb_data_home_dir = .

xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend

xtrabackup: innodb_log_group_home_dir = .

xtrabackup: innodb_log_files_in_group = 1

xtrabackup: innodb_log_file_size = 8388608

xtrabackup: Starting InnoDB instance for recovery.

xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter) PUNCH HOLE support available Mutexes and rw_locks use GCC atomic builtins Uses event mutexes GCC builtin __atomic_thread_fence() is used for memory barrier Compressed tables use zlib 1.2.11 Number of pools: 1 Using CPU crc32 instructions Directories to scan './'

Scanning β€˜./’

Completed space ID check of 369 files.

Initializing buffer pool, total size = 128.000000M, instances = 1, chunk size =128.000000M Completed initialization of buffer pool page_cleaner coordinator priority: -20 page_cleaner worker priority: -20 page_cleaner worker priority: -20 page_cleaner worker priority: -20 The log sequence number 5516409101 in the system tablespace does not match the log sequence number 6691162815 in the ib_logfiles!

Database was not shutdown normally!

Starting crash recovery.

Starting to parse redo log at lsn = 6691162692, whereas checkpoint_lsn = 6691162815 Doing recovery: scanned up to log sequence number 6691163715 Log background threads are being started…

Applying a batch of 7 redo log records …

100%

Apply batch completed!

Using undo tablespace β€˜./undo_001’.

Using undo tablespace β€˜./undo_002’.

Opened 2 existing undo tablespaces.

GTID recovery trx_no: 914983

Creating shared tablespace for temporary tables Setting file β€˜./ibtmp1’ size to 12 MB. Physically writing the file full; Please wait …

File β€˜./ibtmp1’ size is now 12 MB.

Scanning temp tablespace dir:’./#innodb_temp/’

Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.

8.0.22 started; log sequence number 6691163715 Allocated tablespace ID 75 for client_db/transaction_type, old maximum was 0 Cannot read first page of β€˜./mysql.ibd’ I/O error Cannot read first page in datafile: ./mysql.ibd, Space ID:4294967295, Flags: 0. Please refer to http://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html for how to resolve the issue.

Cannot read first page of β€˜./payee_db/crm_api_running_status.ibd’ I/O error Cannot read first page in datafile: ./payee_db/crm_api_running_status.ibd, Space ID:4294967295, Flags: 0. Please refer to http://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html for how to resolve the issue.

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611

xtrabackup: Unknown error 3611
06:53:42 UTC - mysqld got signal 11 ;

Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.

Thread pointer: 0x0

Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong…

stack_bottom = 0 thread_stack 0x46000

xtrabackup(my_print_stacktrace(unsigned char const*, unsigned long)+0x3d) [0x55ea3d7f7cfd]

xtrabackup(handle_fatal_signal+0x2fb) [0x55ea3c62c7db]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x12980) [0x7f47db46b980]

xtrabackup(dd::get_dd_client(THD*)+0x1) [0x55ea3cb74e01] xtrabackup(dd_table_open_on_name(THD*, MDL_ticket**, char const*, bool, unsigned long, int*)+0x5ae) [0x55ea3c7fa40e]

xtrabackup(+0xdc6f33) [0x55ea3c0f2f33]

xtrabackup(+0xdcad70) [0x55ea3c0f6d70]

xtrabackup(main+0xd37) [0x55ea3c0b68b7]

/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xe7) [0x7f47d96c8bf7]

xtrabackup(_start+0x2a) [0x55ea3c0e4caa]

Please report a bug at https://jira.percona.com/projects/PXB

1 Like

TL;DR if you are relying on Percona XtraBackup, you should not upgrade your server version until you have first upgraded Percona XtraBackup, which typically will lag Oracle MySQL 8.x releases by 4-6 weeks.

– George O. Lorch III
Director of Server Engineering, Percona Server for MySQL, Percona XtraDB Cluster, and Percona XtraBackup

1 Like