# Xtrabackup decompression error -- cat write error: broken pipe

**URL:** <https://forums.percona.com/t/xtrabackup-decompression-error-cat-write-error-broken-pipe/13710>\
**Category:** Percona Distribution for MySQL\
**Tags:** community, mysql, percona\
**Created:** [December 30, 2021, 1:25pm UTC](https://forums.percona.com/t/xtrabackup-decompression-error-cat-write-error-broken-pipe/13710 "2021-12-30T13:25:58Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rahul\_Kanaujia](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/rahul_kanaujia/32/5386_2.png) [@Rahul\_Kanaujia](https://forums.percona.com/u/Rahul_Kanaujia)\
**Post date:** [December 30, 2021, 1:25pm UTC](https://forums.percona.com/t/xtrabackup-decompression-error-cat-write-error-broken-pipe/13710/1 "2021-12-30T13:25:58Z")

</div>

Hi,

I am getting below error while performing decompression of backup database on other server.  
cat: write error: broken pipe  
sh: line 1: 55331 Done(1) cat ./mydb/table\_name.ibd.qp  
55333 File size limit exceeded| qpress -dio \> ./mydb/table\_name.ibd

decomression Command: xtrabackup --decompress --remove-original --target-dir=/db/path  
xtrabackup version: 2.4.24  
Percona MySQL version: 5.7.25-28 log  
OS version: RHEL 6.10(Santiago)

---

<div class="post-metadata">

**Author:** ![Denis\_Subbota](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/denis_subbota/32/23607_2.png) [@Denis\_Subbota](https://forums.percona.com/u/Denis_Subbota)\
**Post date:** [October 22, 2022, 5:07am UTC](https://forums.percona.com/t/xtrabackup-decompression-error-cat-write-error-broken-pipe/13710/2 "2022-10-22T05:07:51Z")

</div>

Hello [Rahul](https://forums.percona.com/u/Rahul_Kanaujia)  
In order to help you solve this issue, would you mind sharing a command which you were using to take the backup, what user you use to take this backup, and what permission for --target-dir=/db/path

Also you can use below command to decompress compressed backup.

```auto
# cd <path to compressed backup>
# for i in $(find -name "*.qp"); do qpress -vd $i $(dirname ${i}) && rm -f $i; done

```

Regards,  
Denis Subbota.  
Managed Services, Percona.
