# Xtrabackup backup fails, \[MY-011825\] \[Xtrabackup\] recv\_find\_max\_checkpoint ()

**URL:** <https://forums.percona.com/t/xtrabackup-backup-fails-my-011825-xtrabackup-recv-find-max-checkpoint/22667>\
**Category:** Percona XtraBackup\
**Tags:** mysql, percona\
**Created:** [June 8, 2023, 9:27am UTC](https://forums.percona.com/t/xtrabackup-backup-fails-my-011825-xtrabackup-recv-find-max-checkpoint/22667 "2023-06-08T09:27:03Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![lcy](https://avatars.discourse-cdn.com/v4/letter/l/ecccb3/32.png) [@lcy](https://forums.percona.com/u/lcy)\
**Post date:** [June 8, 2023, 9:27am UTC](https://forums.percona.com/t/xtrabackup-backup-fails-my-011825-xtrabackup-recv-find-max-checkpoint/22667/1 "2023-06-08T09:27:03Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![CTutte](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ctutte/32/1341_2.png) [@CTutte](https://forums.percona.com/u/CTutte)\
**Post date:** [June 8, 2023, 12:15pm UTC](https://forums.percona.com/t/xtrabackup-backup-fails-my-011825-xtrabackup-recv-find-max-checkpoint/22667/2 "2023-06-08T12:15:59Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![lcy](https://avatars.discourse-cdn.com/v4/letter/l/ecccb3/32.png) [@lcy](https://forums.percona.com/u/lcy)\
**Post date:** [June 9, 2023, 12:34am UTC](https://forums.percona.com/t/xtrabackup-backup-fails-my-011825-xtrabackup-recv-find-max-checkpoint/22667/3 "2023-06-09T00:34:25Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![CTutte](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ctutte/32/1341_2.png) [@CTutte](https://forums.percona.com/u/CTutte)\
**Post date:** [June 9, 2023, 12:34pm UTC](https://forums.percona.com/t/xtrabackup-backup-fails-my-011825-xtrabackup-recv-find-max-checkpoint/22667/4 "2023-06-09T12:34:31Z")

</div>

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](https://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html)

Regards

---

<div class="post-metadata">

**Author:** ![lcy](https://avatars.discourse-cdn.com/v4/letter/l/ecccb3/32.png) [@lcy](https://forums.percona.com/u/lcy)\
**Post date:** [June 13, 2023, 2:38am UTC](https://forums.percona.com/t/xtrabackup-backup-fails-my-011825-xtrabackup-recv-find-max-checkpoint/22667/5 "2023-06-13T02:38:24Z")

</div>

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.
