# Xtrabackup version 8.0.32-26 can't decompress ZSTD backup **URL:** \ **Category:** Percona XtraBackup\ **Created:** [July 12, 2023, 2:31pm UTC](https://forums.percona.com/t/xtrabackup-version-8-0-32-26-cant-decompress-zstd-backup/23571 "2023-07-12T14:31:12Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Stateros](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/stateros/32/2490_2.png) [@Stateros](https://forums.percona.com/u/Stateros)\ **Post date:** [July 12, 2023, 2:31pm UTC](https://forums.percona.com/t/xtrabackup-version-8-0-32-26-cant-decompress-zstd-backup/23571/1 "2023-07-12T14:31:12Z")
Hello folks. I wanna try zstd compression in my infrastructure. I took backup, everything was ok. But when I try to restore data from this backup - it was failed on decompress stage. MySQL and xtrabackup versions: > ~ mysql --version > mysql Ver 8.0.32-24 for Linux on x86\_64 (Percona Server (GPL), Release ‘24’, Revision ‘e5c6e9d2’) > ~ xtrabackup --version > 2023-07-12T14:07:42.163137-00:00 0 [Note] [MY-011825] [Xtrabackup] recognized server arguments: --datadir=/data/mysql --tmpdir=/data/mysqltmp --innodb\_flush\_log\_at\_trx\_commit=2 --innodb\_file\_per\_table=1 --innodb\_read\_io\_threads=16 --innodb\_write\_io\_threads=16 --innodb\_flush\_method=O\_DIRECT --log\_bin=/data/mysql/mysql-bin --server-id=17221 > xtrabackup version 8.0.32-26 based on MySQL server 8.0.32 Linux (x86\_64) (revision id: 34cf2908) Here is my workflow: backup server: > ~ xtrabackup --backup --compress=zstd --parallel=16 --compress-threads=8 --stream=xbstream --target\_dir=/data/backup 2\> /data/backup/2023-07-12\_00-00-03\_Wednesday.log | pv -s 5559283712 -p -f 2\> /tmp/backup\_progress | /usr/local/bin/aws s3 cp - s3://backups/2023-07-12\_00-00-03\_Wednesday.xbstream --sse --expected-size 5559283712 On new server: > ~ /usr/local/bin/aws s3 cp s3://backups/2023-07-12\_00-00-03\_Wednesday.xbstream - | xbstream -x --parallel 10 -C /data/mysql > ~ xtrabackup --decompress --remove-original --target-dir=/data/mysql \> /data/mysql/decompress.log 2\>&1 And on this stage I have an error: > 2023-07-12T14:04:47.745000-00:00 0 [Note] [MY-011825] [Xtrabackup] recognized server arguments: --datadir=/data/mysql --tmpdir=/data/mysqltmp --innodb\_flush\_log\_at\_trx\_commit=2 --innodb\_file\_per\_table=1 --innodb\_read\_io\_threads=16 --innodb\_write\_io\_threads=16 --innodb\_flush\_method=O\_DIRECT --log\_bin=/data/mysql/mysql-bin --server-id=17221 > 2023-07-12T14:04:47.745265-00:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --port=3306 --socket=/var/run/mysqld/mysqld.sock --compress --compress-threads=4 --parallel=4 --user=backup --password=\* --decompress=1 --remove-original=1 --target-dir=/data/mysql > xtrabackup version 8.0.32-26 based on MySQL server 8.0.32 Linux (x86\_64) (revision id: 34cf2908) > 2023-07-12T14:04:47.745996-00:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./mysql.ibd.zst > 2023-07-12T14:04:47.746185-00:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./xtrabackup\_logfile.zst > 2023-07-12T14:04:47.746385-00:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./undo\_001.zst > 2023-07-12T14:04:47.746532-00:00 0 [Note] [MY-011825] [Xtrabackup] decompressing ./test/start\_recrawl\_24.ibd.zst > sh: 1: zstd: not found > sh: 1: zstd: not found > cat: write error: Broken pipe > cat: write error: Broken pipe > sh: 1: zstd: not found > sh: 1: zstd: not found > cat: write error: Broken pipe > 2023-07-12T14:04:47.847908-00:00 0 [ERROR] [MY-011825] [Xtrabackup] decrypt and decompress thread 0 failed. > 2023-07-12T14:04:47.847984-00:00 0 [ERROR] [MY-011825] [Xtrabackup] decrypt and decompress thread 1 failed. > 2023-07-12T14:04:47.848001-00:00 0 [ERROR] [MY-011825] [Xtrabackup] decrypt and decompress thread 2 failed. > 2023-07-12T14:04:47.848034-00:00 0 [ERROR] [MY-011825] [Xtrabackup] decrypt and decompress thread 3 failed. I tried less complicated implementation without streaming component: > xtrabackup --backup --compress=zstd --parallel=16 --compress-threads=8 --target\_dir=/data/backup scp to new server and decompress: > xtrabackup --decompress --remove-original --target-dir=/data/mysql \> /data/mysql/decompress.log 2\>&1 Result was the same. Any idea what I am doing wrong? ---
**Author:** ![Ivan\_Groenewold](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ivan_groenewold/32/6299_2.png) [@Ivan\_Groenewold](https://forums.percona.com/u/Ivan_Groenewold)\ **Post date:** [July 12, 2023, 2:59pm UTC](https://forums.percona.com/t/xtrabackup-version-8-0-32-26-cant-decompress-zstd-backup/23571/2 "2023-07-12T14:59:45Z")
Hi, the error seems to be that the zstd package is missing so the backup cannot be decompressed. Can you try installing that with yum or apt ? ---
**Author:** ![Stateros](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/stateros/32/2490_2.png) [@Stateros](https://forums.percona.com/u/Stateros)\ **Post date:** [July 12, 2023, 4:00pm UTC](https://forums.percona.com/t/xtrabackup-version-8-0-32-26-cant-decompress-zstd-backup/23571/3 "2023-07-12T16:00:18Z")
I knew the reason should be obvious … It’s long time I didn’t do so silly things. Thanks for help…