# XtraBackup-8 restoration fails

**URL:** <https://forums.percona.com/t/xtrabackup-8-restoration-fails/6940>\
**Category:** Percona XtraBackup\
**Created:** [April 2, 2019, 1:06am UTC](https://forums.percona.com/t/xtrabackup-8-restoration-fails/6940 "2019-04-02T01:06:15Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![jtsunne](https://avatars.discourse-cdn.com/v4/letter/j/c68b51/32.png) [@jtsunne](https://forums.percona.com/u/jtsunne)\
**Post date:** [April 2, 2019, 1:06am UTC](https://forums.percona.com/t/xtrabackup-8-restoration-fails/6940/1 "2019-04-02T01:06:15Z")

</div>

I have MySQL-8 server

[01:21 root@mysql-103 ~]$ rpm -qa |grep percona  
percona-server-shared-8.0.15-5.1.el7.x86\_64  
percona-toolkit-3.0.13-1.el7.x86\_64  
percona-server-client-8.0.15-5.1.el7.x86\_64  
percona-server-server-8.0.15-5.1.el7.x86\_64  
percona-server-shared-compat-8.0.15-5.1.el7.x86\_64  
percona-xtrabackup-80-8.0.5-1.el7.x86\_64

[01:21 root@mysql-103 ~]$ cat /etc/centos-release  
CentOS Linux release 7.4.1708 (Core)

[01:21 root@ecore-cart-mysql-103 ~]$ cat /etc/my.cnf

### MANAGED BY PUPPET

[client]  
default-character-set = utf8  
port = 3306  
socket = /var/lib/mysql/mysql.sock

[isamchk]  
key\_buffer\_size = 16M

[mysqld]  
basedir = /usr  
bind-address = 0.0.0.0  
binlog\_format = ROW  
character-set-server = utf8  
collation-server = utf8\_unicode\_ci  
datadir = /var/lib/mysql/  
default-authentication-plugin = mysql\_native\_password  
default-storage-engine = InnoDB  
enforce-gtid-consistency = ON  
expire\_logs\_days = 2  
group\_concat\_max\_len = 99999999999  
gtid-mode = ON  
innodb-flush-method = O\_DIRECT  
innodb\_buffer\_pool\_size = 16G  
innodb\_flush\_log\_at\_trx\_commit = 1  
innodb\_lock\_wait\_timeout = 3600  
join\_buffer\_size = 2M  
key\_buffer\_size = 128M  
log-error = /var/log/mysqld.log  
log\_bin = /var/lib/mysql/mysql-bin.log  
log\_bin\_trust\_function\_creators = 1  
log\_slave\_updates = 1  
master-info-repository = TABLE  
max\_allowed\_packet = 128M  
max\_binlog\_size = 1G  
max\_connect\_errors = 1000000  
max\_connections = 1536  
max\_digest\_length = 4096  
max\_heap\_table\_size = 1G  
open-files-limit = 655350  
performance\_schema\_max\_digest\_length = 4096  
pid-file = /var/run/mysqld/mysqld.pid  
port = 3306  
read\_rnd\_buffer\_size = 4M  
relay-log = /var/lib/mysql/mysql-relay-bin  
relay-log-info-repository = TABLE  
replicate-ignore-db = sys  
replicate-ignore-db = performance\_schema  
replicate-wild-ignore-table = sabio.statistics\_urows\_%  
server-id = 103  
skip-external-locking  
skip-federated = true  
slave\_compressed\_protocol = 1  
slow-query-log = 1  
slow-query-log-file = /var/lib/mysql/mysql-slow.log  
socket = /var/lib/mysql/mysql.sock  
sort\_buffer\_size = 4M  
sql\_mode = “”  
ssl = false  
ssl-ca = /etc/mysql/cacert.pem  
ssl-cert = /etc/mysql/server-cert.pem  
ssl-key = /etc/mysql/server-key.pem  
sync\_binlog = 1  
sysdate-is-now = 1  
table\_definition\_cache = 8192  
table\_open\_cache = 8192  
thread\_cache\_size = 1024  
thread\_stack = 256K  
tmp\_table\_size = 1G  
tmpdir = /tmp  
user = mysql

I tried to create full backup:

xtrabackup --backup --stream=xbstream --compress-threads=8 --compress --target-dir=$BACKUP\_DIRECTORY \> $BACKUP\_DIRECTORY/${SERVER}-${DATE}.xbstream

after that, I tried to restore the full backup on another server

xbstream -x \< $BACKUP\_DIRECTORY/${SERVER}-${DATE}.xbstream  
xtrabackup --decompress --parallel=8 --remove-original --target-dir=/var/lib/mysql/.tmp

…CUT…  
Doing recovery: scanned up to log sequence number 16347816786432  
Doing recovery: scanned up to log sequence number 16347822029312  
my\_realpath(.//tmp\_route.ibd) failed!  
Creating the tablespace : .//tmp\_route.ibd, space\_id : 166458  
my\_realpath(.//tmp\_redirect\_auto.ibd) failed!  
…CUT…  
Creating the tablespace : .//tmp\_page\_data\_product\_to\_category\_page.ibd, space\_id : 166468  
Applying a batch of 10026 redo log records …

and the restoration process was stuck

what was wrong with this process?  
free spaces are OK  
resources is enough

original and target MySQL servers are identical (created via one puppet manifest), the differences are only one - Server\_id

maybe something wrong with backup?