Xtrabackup decompression error -- cat write error: broken pipe

MySQL & MariaDB Percona Distribution for MySQL
, ,
1

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)

1 Like
2

Hello Rahul
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.

# 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.

1 Like