Using mysql version 8.0.32 and xtrabackup version 8.0.32-26, backups still appear
[ERROR] [MY-011825] [Xtrabackup] recv_find_max_checkpoint() failed. This mistake
Hi Icy,
If you are using the same version for the MySQL instance and PXB then is the right thing to do.
Can you please send the output of the complete error?
Complete output：
2023-06-08T09:58:32.661181+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized server arguments: --datadir=/var/lib/mysql --innodb_force_recovery=6 --log_bin=0 --datadir=/var/lib/docker/volumes/44d24688fa39dd1aedb547d36c66816d4e45d44fd664990f220de8c9598d4e6e/_data
2023-06-08T09:58:32.661296+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --host=192.168.0.118 --port=14566 --user=root --password=* --backup=1 --target-dir=/var/xtrabackup/fullbf --databases=wxamp_location_202304
xtrabackup version 8.0.32-26 based on MySQL server 8.0.32 Linux (x86_64) (revision id: 34cf2908)
230608 09:58:32 version_check Connecting to MySQL server with DSN ‘dbi:mysql:;mysql_read_default_group=xtrabackup;host=192.168.0.118;port=14566’ as ‘root’ (using password: YES).
230608 09:58:32 version_check Connected to MySQL server
230608 09:58:32 version_check Executing a version check against the server…
230608 09:58:32 version_check Done.
2023-06-08T09:58:32.715721+08:00 0 [Note] [MY-011825] [Xtrabackup] Connecting to MySQL server host: 192.168.0.118, user: root, password: set, port: 14566, socket: not set
2023-06-08T09:58:32.728361+08:00 0 [Note] [MY-011825] [Xtrabackup] Using server version 8.0.32
2023-06-08T09:58:32.732645+08:00 0 [Warning] [MY-011825] [Xtrabackup] MySQL variable ‘datadir’ points to nonexistent directory ‘/var/lib/mysql/’
2023-06-08T09:58:32.732679+08:00 0 [Warning] [MY-011825] [Xtrabackup] option ‘datadir’ has different values: ‘/var/lib/docker/volumes/44d24688fa39dd1aedb547d36c66816d4e45d44fd664990f220de8c9598d4e6e/_data’ in defaults file ‘/var/lib/mysql/’ in SHOW VARIABLES
2023-06-08T09:58:32.732991+08:00 0 [Note] [MY-011825] [Xtrabackup] Executing LOCK INSTANCE FOR BACKUP …
2023-06-08T09:58:32.733689+08:00 0 [Note] [MY-011825] [Xtrabackup] uses posix_fadvise().
2023-06-08T09:58:32.733722+08:00 0 [Note] [MY-011825] [Xtrabackup] cd to /var/lib/docker/volumes/44d24688fa39dd1aedb547d36c66816d4e45d44fd664990f220de8c9598d4e6e/_data
2023-06-08T09:58:32.733737+08:00 0 [Note] [MY-011825] [Xtrabackup] open files limit requested 0, set to 65535
2023-06-08T09:58:32.746604+08:00 0 [Note] [MY-011825] [Xtrabackup] using the following InnoDB configuration:
2023-06-08T09:58:32.746632+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_home_dir = .
2023-06-08T09:58:32.746639+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_file_path = ibdata1:12M:autoextend
2023-06-08T09:58:32.746674+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_group_home_dir = ./
2023-06-08T09:58:32.746681+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_files_in_group = 2
2023-06-08T09:58:32.746691+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_file_size = 50331648
2023-06-08T09:58:32.748012+08:00 0 [Note] [MY-011825] [Xtrabackup] inititialize_service_handles suceeded
2023-06-08T09:58:32.851737+08:00 0 [ERROR] [MY-011825] [Xtrabackup] recv_find_max_checkpoint() failed.
Hi again,
I noticed that you are currently using “–innodb_force_recovery=6” as part of the parameter options. Why are you using that?
I tested from my side with that parameters and I get the same error.
Note that flag innodb_force_recovery is meant only for when the database has crashed or has corruption, and using force recovery with a value larger than 3 can cause permanent data corruption https://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
Regards
Thank you very much, it has been solved. --datadir pointed to a path of MySQL that is not in use. I pointed to the path mapped by mysql in docker through my.cnf file, and the backup was successful.