innobackupex doesnt remove *qp files after decompress

MySQL & MariaDB Percona XtraBackup
1

Hello everybody,

I cant get why PerconaXtraBackup doesnt delete qp-files after decompress option. Backup was made using older version of innobackupex but there is no error or warning during decompress procedure.

Backup was made on:

[root@0900lbmysql01 vlad_main_xbackup_full_last]# innobackupex --version
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved.
This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
Get the latest version of Percona XtraBackup, documentation, and help resources:
[url]Percona XtraBackup - MySQL Database Backup Software
[root@0900lbmysql01 vlad_main_xbackup_full_last]# mysqld --version
mysqld Ver 5.6.25 for Linux on x86_64 (MySQL Community Server (GPL))
[root@0900lbmysql01 vlad_main_xbackup_full_last]# cat /etc/redhat-release
CentOS release 6.6 (Final)

Backup is being used on:

[root@testforlab-lin2 /]# innobackupex --version
innobackupex version 2.4.4 Linux (x86_64) (revision id: df58cf2)
[root@testforlab-lin2 /]# mysqld --version
mysqld Ver 5.6.32 for Linux on x86_64 (MySQL Community Server (GPL))
[root@testforlab-lin2 /]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.2 (Maipo)

Before decompress:
[root@testforlab-lin2 /]# du -sh /mysql/vlad_main_xbackup_full_last/billing/.ibd --total
du: cannot access «/mysql/vlad_main_xbackup_full_last/billing/.ibd»: No such file or directory
0 total
[root@testforlab-lin2 /]# du -sh /mysql/vlad_main_xbackup_full_last/billing/.qp --total
3.8G total
[root@testforlab-lin2 /]# ls -l /mysql/vlad_main_xbackup_full_last/billing/accountsibd*
.
-rw-r----- 1 root root 2345 Авг 3 13:04 /mysql/vlad_main_xbackup_full_last/billing/accounts_addons_staff.ibd.qp
-rw-r----- 1 root root 5400996 Авг 3 13:04 /mysql/vlad_main_xbackup_full_last/billing/accounts_addons_vals.ibd.qp
-rw-r----- 1 root root 5626664 Авг 3 13:04 /mysql/vlad_main_xbackup_full_last/billing/accounts_addr.ibd.qp
-rw-r----- 1 root root 17667926 Авг 3 13:04 /mysql/vlad_main_xbackup_full_last/billing/accounts_backup.ibd.qp
-rw-r----- 1 root root 4335460 Авг 3 13:04 /mysql/vlad_main_xbackup_full_last/billing/accounts.ibd.qp
.

During decompression:
[root@testforlab-lin2 /]# innobackupex --decompress $PERBAK
160803 12:41:00 innobackupex: Starting the decrypt and decompress operation
IMPORTANT: Please check that the decrypt and decompress run completes successfully.
At the end of a successful decrypt and decompress run innobackupex
prints “completed OK!”.
innobackupex version 2.4.4 based on MySQL server 5.7.13 Linux (x86_64) (revision id: df58cf2)
.
160803 12:41:59 [01] decompressing ./billing/accounts_backup.ibd.qp
160803 12:42:00 [01] decompressing ./billing/accounts.ibd.qp
.
160803 12:43:52 completed OK!

After decompress:
[root@testforlab-lin2 /]# du -sh /mysql/vlad_main_xbackup_full_last/billing/.ibd --total
13G total
[root@testforlab-lin2 /]# du -sh /mysql/vlad_main_xbackup_full_last/billing/.qp --total
3.8G total
[root@testforlab-lin2 /]# ls -l /mysql/vlad_main_xbackup_full_last/billing/accountsibd
.
-rw-r–r-- 1 root root 114688 Aug 3 12:41 /mysql/vlad_main_xbackup_full_last/billing/accounts_addons_staff.ibd
-rw-r–r-- 1 mygolenk reguser 2345 Aug 3 10:21 /mysql/vlad_main_xbackup_full_last/billing/accounts_addons_staff.ibd.qp
-rw-r–r-- 1 root root 37748736 Aug 3 12:42 /mysql/vlad_main_xbackup_full_last/billing/accounts_addons_vals.ibd
-rw-r–r-- 1 mygolenk reguser 5400996 Aug 3 10:20 /mysql/vlad_main_xbackup_full_last/billing/accounts_addons_vals.ibd.qp
-rw-r–r-- 1 root root 37748736 Aug 3 12:41 /mysql/vlad_main_xbackup_full_last/billing/accounts_addr.ibd
-rw-r–r-- 1 mygolenk reguser 5626664 Aug 3 10:22 /mysql/vlad_main_xbackup_full_last/billing/accounts_addr.ibd.qp
-rw-r–r-- 1 root root 100663296 Aug 3 12:42 /mysql/vlad_main_xbackup_full_last/billing/accounts_backup.ibd
-rw-r–r-- 1 mygolenk reguser 17667926 Aug 3 10:21 /mysql/vlad_main_xbackup_full_last/billing/accounts_backup.ibd.qp
-rw-r–r-- 1 root root 25165824 Aug 3 12:42 /mysql/vlad_main_xbackup_full_last/billing/accounts.ibd
-rw-r–r-- 1 mygolenk reguser 4335460 Aug 3 10:21 /mysql/vlad_main_xbackup_full_last/billing/accounts.ibd.qp
.

Best regards,
Mikhail

2

Ok, Ive found:

[url]The innobackupex Option Reference
–decompress Decompresses all files with the .qp extension in a backup previously made with the –compress option. The innobackupex --parallel option will allow multiple files to be decrypted and/or decompressed simultaneously. In order to decompress, the qpress utility MUST be installed and accessible within the path. This process will remove the original compressed/encrypted files and leave the results in the same location. NOTE: After version 2.2.10 Percona XtraBackup doesn’t automatically remove the compressed files. In order to clean up the backup directory users should remove the*.qp files manually.