[MCOL-3775] columnstoreBackup and columnstoreRestore are not installed with columnstore 1.4 Created: 2020-02-10  Updated: 2020-02-12  Resolved: 2020-02-11

Status: Closed
Project: MariaDB ColumnStore
Component/s: installation
Affects Version/s: 1.4.2
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Geoff Montee (Inactive) Assignee: Todd Stoffel (Inactive)
Resolution: Not a Bug Votes: 0
Labels: None

Issue Links:
Relates
relates to MCOL-3667 Update Columnstore Backup / Restore t... Closed
relates to MCOL-3728 1.4.2 upgrade guide issues Closed

 Description   

In previous versions of MariaDB Columnstore, columnstoreBackup and columnstoreRestore were apparently installed by the mariadb-columnstore-tools package:

https://mariadb.com/kb/en/backup-and-restore-for-mariadb-columnstore-110-onwards/#installing-mariadb-columnstore-tools-package

In MariaDB Columnstore 1.4, this package does not appear to exist at all:

$ sudo yum search MariaDB-columnstore
 
Loaded plugins: amazon-id, search-disabled-repos
 
===================================================================================================== N/S matched: MariaDB-columnstore ======================================================================================================
 
MariaDB-columnstore-engine-debuginfo.x86_64 : Debug information for package MariaDB-columnstore-engine
 
MariaDB-columnstore-libs-debuginfo.x86_64 : Debug information for package MariaDB-columnstore-libs
 
MariaDB-columnstore-platform-debuginfo.x86_64 : Debug information for package MariaDB-columnstore-platform
 
MariaDB-columnstore-engine.x86_64 : MariaDB: a very fast and robust SQL database server
 
MariaDB-columnstore-libs.x86_64 : MariaDB: a very fast and robust SQL database server
 
MariaDB-columnstore-platform.x86_64 : MariaDB: a very fast and robust SQL database server

As you can see from above, only the MariaDB-columnstore-engine, MariaDB-columnstore-libs, and MariaDB-columnstore-platform packages exist. None of these pckages contain columnstoreBackup and columnstoreRestore:

$ sudo rpm -ql MariaDB-columnstore-engine | grep -i -e "backup" -e "restore"
 
$ sudo rpm -ql MariaDB-columnstore-libs | grep -i -e "backup" -e "restore"
 
$ sudo rpm -ql MariaDB-columnstore-platform | grep -i -e "backup" -e "restore"



 Comments   
Comment by Todd Stoffel (Inactive) [ 2020-02-11 ]

ColumnStore tools is not part of the server distribution. It is available via download from our website.

Comment by Geoff Montee (Inactive) [ 2020-02-11 ]

I was able to install it on RHEL 7 using the following process:

wget https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
 
sudo yum localinstall epel-release-latest-7.noarch.rpm
 
sudo yum install libuv libxml2 snappy python36
 
wget https://downloads.mariadb.com/MariaDB/mariadb-columnstore-api/1.4.2/centos/x86_64/7/mariadb-columnstore-api-1.4.2-1-x86_64-centos7-cpp.rpm
 
wget https://downloads.mariadb.com/ColumnStore-Tools/1.4.2/centos/x86_64/7/mariadb-columnstore-tools-1.4.2-1-amd64-centos7.rpm
 
sudo yum localinstall mariadb-columnstore-api-1.4.2-1-x86_64-centos7-cpp.rpm mariadb-columnstore-tools-1.4.2-1-amd64-centos7.rpm

Comment by Geoff Montee (Inactive) [ 2020-02-12 ]

After I did get it installed with 1.4.2, I ran into MCOL-3786. It looks like columnstoreRestore is broken in 1.4.2.

Generated at Thu Feb 08 02:45:21 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.