[MDEV-15069] mariabackup --decompress breaks due to qpress not found Created: 2018-01-25  Updated: 2023-05-25  Resolved: 2018-01-25

Status: Closed
Project: MariaDB Server
Component/s: Backup, Documentation
Affects Version/s: 10.2.12
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Zdravelina Sokolovska (Inactive) Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: None


 Description   

mariabackup --decompress breaks due to qpress not found

expected
qpress is either prerequeted to be installed in MariaDB Backup user guide
or it's included in the MariaDB-Backup package

how to repeat:
1. perform mariabackup with option --compress
2. issue the mariabackup --decompress step – it's fails – qpress not found

1.
mariabackup --backup --compress --compress-threads=2 --compress-chunk-size=512K --target-dir /var/mariadb/backupcr2
180125 15:56:38 Connecting to MySQL server host: localhost, user: not set, password: not set, port: not set, socket: not set
Using server version 10.2.12-MariaDB
mariabackup based on MariaDB server 10.2.12-MariaDB Linux (x86_64)
~~~~~

[root@t4w3 mysql]# ls /var/mariadb/backupcr1
aria_log.00000001.qp backup-my.cnf.qp ib_buffer_pool.qp ib_logfile0 mysql test xtrabackup_info.qp
aria_log_control.qp boxoffice_mdb ibdata1.qp ib_logfile0.qp performance_schema xtrabackup_checkpoints

2.
[root@t4w3 mysql]# mariabackup --decompress --remove-original --target-dir /var/mariadb/backupcr1
mariabackup based on MariaDB server 10.2.12-MariaDB Linux (x86_64)
180125 16:03:34 [01] decompressing ./ib_logfile0.qp
sh: qpress: command not found
cat: write error: Broken pipe
Error: thread 0 failed.

 Comments   
Comment by Vladislav Vaintroub [ 2018-01-25 ]
  1. compress this option is deprecated, in favor of 3rd party tools https://mariadb.com/kb/en/library/mariabackup-options/#-compress
  2. decompress - documentation of decompress lists qpress is prerequisite already https://mariadb.com/kb/en/library/mariabackup-options/#-decompress .
    "This option requires that you have the qpress utility installed on your system."
    Feel free to change the wording to stress the importance of qpress even more than it currently is.
Comment by Richard Stracke [ 2018-03-14 ]

For Debian/Ubuntu:

wget http://www.quicklz.com/qpress-11-linux-x64.tar
 
 
 
tar xf qpress-11-linux-x64.tar
 
 
 
sudo cp qpress  /usr/bin/qpress
 
sudo chmod 755  /usr/bin/qpress
 
sudo chown root:root /usr/bin/qpress

Comment by Edward Stoever [ 2023-05-25 ] 

wget https://repo.percona.com/apt/pool/main/q/qpress/qpress_11-3.bullseye_amd64.deb
 
dpkg -i qpress_11-3.bullseye_amd64.deb

Generated at Thu Feb 08 08:18:27 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.