Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Do
-
1.2.3
-
None
-
CentOS 7
Description
I did a fresh installation of MariaDB ColumnStore on a clean CentOS 7 system through "repository installation" as described in our knowledge base [1]. During the execution of postConfigure, it stated that the netstat command is not found.
Select the type of Data Storage [1=internal, 2=external] (1) >
|
|
|
Enter the list (Nx,Ny,Nz) or range (Nx-Nz) of DBRoot IDs assigned to module 'pm1' (1) >
|
sh: netstat: command not found
|
If netstat is used by postConfigure shouldn't it be installed automatically as dependency through our repo installation process?
Installation output:
[jens@centos7 mariadb-columnstore-api]$ sudo yum --enablerepo=mariadb-columnstore clean metadata
|
Loaded plugins: fastestmirror
|
Cleaning repos: base epel extras mariadb-columnstore updates
|
18 metadata files removed
|
10 sqlite files removed
|
0 metadata files removed
|
[jens@centos7 mariadb-columnstore-api]$ sudo yum groups mark remove "MariaDB ColumnStore"
|
Loaded plugins: fastestmirror
|
There is no installed groups file.
|
Maybe run: yum groups mark convert (see man yum)
|
Loading mirror speeds from cached hostfile
|
epel/x86_64/metalink | 30 kB 00:00:00
|
* base: centosmirror.netcup.net
|
* epel: ftp.nluug.nl
|
* extras: mirror1.hs-esslingen.de
|
* updates: mirror.softaculous.com
|
base | 3.6 kB 00:00:00
|
epel | 4.7 kB 00:00:00
|
extras | 3.4 kB 00:00:00
|
mariadb-columnstore | 3.6 kB 00:00:00
|
updates | 3.4 kB 00:00:00
|
(1/9): base/7/x86_64/group_gz | 166 kB 00:00:00
|
(2/9): epel/x86_64/group_gz | 88 kB 00:00:00
|
(3/9): extras/7/x86_64/primary_db | 200 kB 00:00:00
|
(4/9): mariadb-columnstore/group_gz | 212 B 00:00:00
|
(5/9): epel/x86_64/updateinfo | 1.0 MB 00:00:00
|
(6/9): mariadb-columnstore/primary_db | 17 kB 00:00:00
|
(7/9): base/7/x86_64/primary_db | 6.0 MB 00:00:01
|
(8/9): epel/x86_64/primary_db | 6.7 MB 00:00:02
|
(9/9): updates/7/x86_64/primary_db | 5.0 MB 00:00:01
|
Marked remove: MariaDB ColumnStore
|
[jens@centos7 mariadb-columnstore-api]$ sudo yum groupinstall "MariaDB ColumnStore"
|
Loaded plugins: fastestmirror
|
There is no installed groups file.
|
Maybe run: yum groups mark convert (see man yum)
|
Loading mirror speeds from cached hostfile
|
* base: centosmirror.netcup.net
|
* epel: ams.edge.kernel.org
|
* extras: mirror1.hs-esslingen.de
|
* updates: centos.mirror.iphh.net
|
Resolving Dependencies
|
--> Running transaction check
|
---> Package mariadb-columnstore-client.x86_64 0:1.2.3-1.el7.centos will be installed
|
---> Package mariadb-columnstore-common.x86_64 0:1.2.3-1.el7.centos will be installed
|
---> Package mariadb-columnstore-gssapi-server.x86_64 0:1.2.3-1.el7.centos will be installed
|
---> Package mariadb-columnstore-libs.x86_64 0:1.2.3-1 will be installed
|
---> Package mariadb-columnstore-platform.x86_64 0:1.2.3-1 will be installed
|
--> Processing Dependency: jemalloc for package: mariadb-columnstore-platform-1.2.3-1.x86_64
|
--> Processing Dependency: expect for package: mariadb-columnstore-platform-1.2.3-1.x86_64
|
--> Processing Dependency: /usr/bin/expect for package: mariadb-columnstore-platform-1.2.3-1.x86_64
|
--> Processing Dependency: libjemalloc.so.1()(64bit) for package: mariadb-columnstore-platform-1.2.3-1.x86_64
|
---> Package mariadb-columnstore-rocksdb-engine.x86_64 0:1.2.3-1.el7.centos will be installed
|
---> Package mariadb-columnstore-server.x86_64 0:1.2.3-1.el7.centos will be installed
|
--> Processing Dependency: perl(DBI) for package: mariadb-columnstore-server-1.2.3-1.el7.centos.x86_64
|
--> Processing Dependency: libaio.so.1(LIBAIO_0.4)(64bit) for package: mariadb-columnstore-server-1.2.3-1.el7.centos.x86_64
|
--> Processing Dependency: libaio.so.1(LIBAIO_0.1)(64bit) for package: mariadb-columnstore-server-1.2.3-1.el7.centos.x86_64
|
--> Processing Dependency: libaio.so.1()(64bit) for package: mariadb-columnstore-server-1.2.3-1.el7.centos.x86_64
|
---> Package mariadb-columnstore-shared.x86_64 0:1.2.3-1.el7.centos will be installed
|
---> Package mariadb-columnstore-storage-engine.x86_64 0:1.2.3-1 will be installed
|
---> Package mariadb-columnstore-tokudb-engine.x86_64 0:1.2.3-1.el7.centos will be installed
|
--> Running transaction check
|
---> Package expect.x86_64 0:5.45-14.el7_1 will be installed
|
--> Processing Dependency: libtcl8.5.so()(64bit) for package: expect-5.45-14.el7_1.x86_64
|
---> Package jemalloc.x86_64 0:3.6.0-1.el7 will be installed
|
---> Package libaio.x86_64 0:0.3.109-13.el7 will be installed
|
---> Package perl-DBI.x86_64 0:1.627-4.el7 will be installed
|
--> Processing Dependency: perl(RPC::PlServer) >= 0.2001 for package: perl-DBI-1.627-4.el7.x86_64
|
--> Processing Dependency: perl(RPC::PlClient) >= 0.2000 for package: perl-DBI-1.627-4.el7.x86_64
|
--> Running transaction check
|
---> Package perl-PlRPC.noarch 0:0.2020-14.el7 will be installed
|
--> Processing Dependency: perl(Net::Daemon) >= 0.13 for package: perl-PlRPC-0.2020-14.el7.noarch
|
--> Processing Dependency: perl(Net::Daemon::Test) for package: perl-PlRPC-0.2020-14.el7.noarch
|
--> Processing Dependency: perl(Net::Daemon::Log) for package: perl-PlRPC-0.2020-14.el7.noarch
|
--> Processing Dependency: perl(Compress::Zlib) for package: perl-PlRPC-0.2020-14.el7.noarch
|
---> Package tcl.x86_64 1:8.5.13-8.el7 will be installed
|
--> Running transaction check
|
---> Package perl-IO-Compress.noarch 0:2.061-2.el7 will be installed
|
--> Processing Dependency: perl(Compress::Raw::Zlib) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch
|
--> Processing Dependency: perl(Compress::Raw::Bzip2) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch
|
---> Package perl-Net-Daemon.noarch 0:0.48-5.el7 will be installed
|
--> Running transaction check
|
---> Package perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7 will be installed
|
---> Package perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7 will be installed
|
--> Finished Dependency Resolution
|
|
|
Dependencies Resolved
|
|
|
=============================================================================================================================================================================================================================================
|
Package Arch Version Repository Size
|
=============================================================================================================================================================================================================================================
|
Installing for group install "MariaDB ColumnStore":
|
mariadb-columnstore-client x86_64 1.2.3-1.el7.centos mariadb-columnstore 12 M
|
mariadb-columnstore-common x86_64 1.2.3-1.el7.centos mariadb-columnstore 166 k
|
mariadb-columnstore-gssapi-server x86_64 1.2.3-1.el7.centos mariadb-columnstore 21 k
|
mariadb-columnstore-libs x86_64 1.2.3-1 mariadb-columnstore 57 M
|
mariadb-columnstore-platform x86_64 1.2.3-1 mariadb-columnstore 27 M
|
mariadb-columnstore-rocksdb-engine x86_64 1.2.3-1.el7.centos mariadb-columnstore 76 M
|
mariadb-columnstore-server x86_64 1.2.3-1.el7.centos mariadb-columnstore 79 M
|
mariadb-columnstore-shared x86_64 1.2.3-1.el7.centos mariadb-columnstore 334 k
|
mariadb-columnstore-storage-engine x86_64 1.2.3-1 mariadb-columnstore 9.2 M
|
mariadb-columnstore-tokudb-engine x86_64 1.2.3-1.el7.centos mariadb-columnstore 5.1 M
|
Installing for dependencies:
|
expect x86_64 5.45-14.el7_1 base 262 k
|
jemalloc x86_64 3.6.0-1.el7 epel 105 k
|
libaio x86_64 0.3.109-13.el7 base 24 k
|
perl-Compress-Raw-Bzip2 x86_64 2.061-3.el7 base 32 k
|
perl-Compress-Raw-Zlib x86_64 1:2.061-4.el7 base 57 k
|
perl-DBI x86_64 1.627-4.el7 base 802 k
|
perl-IO-Compress noarch 2.061-2.el7 base 260 k
|
perl-Net-Daemon noarch 0.48-5.el7 base 51 k
|
perl-PlRPC noarch 0.2020-14.el7 base 36 k
|
tcl x86_64 1:8.5.13-8.el7 base 1.9 M
|
|
|
Transaction Summary
|
=============================================================================================================================================================================================================================================
|
Install 10 Packages (+10 Dependent packages)
|
|
|
Total download size: 268 M
|
Installed size: 1.1 G
|
Is this ok [y/d/N]: y
|
Downloading packages:
|
(1/20): libaio-0.3.109-13.el7.x86_64.rpm | 24 kB 00:00:00
|
(2/20): expect-5.45-14.el7_1.x86_64.rpm | 262 kB 00:00:00
|
(3/20): jemalloc-3.6.0-1.el7.x86_64.rpm | 105 kB 00:00:00
|
warning: /var/cache/yum/x86_64/7/mariadb-columnstore/packages/mariadb-columnstore-1.2.3-1-x86_64-centos7-common.rpm: Header V4 RSA/SHA512 Signature, key ID a41f5c14: NOKEY
|
Public key for mariadb-columnstore-1.2.3-1-x86_64-centos7-common.rpm is not installed
|
(4/20): mariadb-columnstore-1.2.3-1-x86_64-centos7-common.rpm | 166 kB 00:00:00
|
(5/20): mariadb-columnstore-1.2.3-1-x86_64-centos7-gssapi-server.rpm | 21 kB 00:00:00
|
(6/20): mariadb-columnstore-1.2.3-1-x86_64-centos7-client.rpm | 12 MB 00:00:03
|
(7/20): mariadb-columnstore-1.2.3-1-x86_64-centos7-platform.rpm | 27 MB 00:00:06
|
(8/20): mariadb-columnstore-1.2.3-1-x86_64-centos7-libs.rpm | 57 MB 00:00:14
|
(9/20): mariadb-columnstore-1.2.3-1-x86_64-centos7-rocksdb-engine.rpm | 76 MB 00:00:18
|
(10/20): mariadb-columnstore-1.2.3-1-x86_64-centos7-shared.rpm | 334 kB 00:00:00
|
(11/20): mariadb-columnstore-1.2.3-1-x86_64-centos7-storage-engine.rpm | 9.2 MB 00:00:02
|
(12/20): perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64.rpm | 32 kB 00:00:00
|
(13/20): perl-Compress-Raw-Zlib-2.061-4.el7.x86_64.rpm | 57 kB 00:00:00
|
(14/20): perl-DBI-1.627-4.el7.x86_64.rpm | 802 kB 00:00:00
|
(15/20): perl-Net-Daemon-0.48-5.el7.noarch.rpm | 51 kB 00:00:00
|
(16/20): perl-PlRPC-0.2020-14.el7.noarch.rpm | 36 kB 00:00:00
|
(17/20): perl-IO-Compress-2.061-2.el7.noarch.rpm | 260 kB 00:00:00
|
(18/20): tcl-8.5.13-8.el7.x86_64.rpm | 1.9 MB 00:00:00
|
(19/20): mariadb-columnstore-1.2.3-1-x86_64-centos7-tokudb-engine.rpm | 5.1 MB 00:00:01
|
(20/20): mariadb-columnstore-1.2.3-1-x86_64-centos7-server.rpm | 79 MB 00:00:19
|
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|
Total 7.8 MB/s | 268 MB 00:00:34
|
Retrieving key from https://downloads.mariadb.com/MariaDB/mariadb-columnstore/RPM-GPG-KEY-MariaDB-ColumnStore
|
Importing GPG key 0xA41F5C14:
|
Userid : "MariaDB-ColumnStore <support@mariadb.com>"
|
Fingerprint: 397f 6899 7ab7 154d 0805 c90f ad0d eafd a41f 5c14
|
From : https://downloads.mariadb.com/MariaDB/mariadb-columnstore/RPM-GPG-KEY-MariaDB-ColumnStore
|
Is this ok [y/N]: y
|
Running transaction check
|
Running transaction test
|
Transaction test succeeded
|
Running transaction
|
Installing : mariadb-columnstore-common-1.2.3-1.el7.centos.x86_64 1/20
|
Installing : jemalloc-3.6.0-1.el7.x86_64 2/20
|
Installing : mariadb-columnstore-libs-1.2.3-1.x86_64 3/20
|
Installing : mariadb-columnstore-shared-1.2.3-1.el7.centos.x86_64 4/20
|
Installing : mariadb-columnstore-client-1.2.3-1.el7.centos.x86_64 5/20
|
Installing : perl-Net-Daemon-0.48-5.el7.noarch 6/20
|
Installing : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64 7/20
|
Installing : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64 8/20
|
Installing : perl-IO-Compress-2.061-2.el7.noarch 9/20
|
Installing : perl-PlRPC-0.2020-14.el7.noarch 10/20
|
Installing : perl-DBI-1.627-4.el7.x86_64 11/20
|
Installing : libaio-0.3.109-13.el7.x86_64 12/20
|
Installing : mariadb-columnstore-server-1.2.3-1.el7.centos.x86_64 13/20
|
Installing : 1:tcl-8.5.13-8.el7.x86_64 14/20
|
Installing : expect-5.45-14.el7_1.x86_64 15/20
|
Installing : mariadb-columnstore-platform-1.2.3-1.x86_64 16/20
|
The next step is:
|
|
|
If installing on a pm1 node using non-distributed install
|
|
|
/usr/local/mariadb/columnstore/bin/postConfigure
|
|
|
If installing on a pm1 node using distributed install
|
|
|
/usr/local/mariadb/columnstore/bin/postConfigure -d
|
|
|
If installing on a non-pm1 using the non-distributed option:
|
|
|
/usr/local/mariadb/columnstore/bin/columnstore start
|
|
|
|
|
Installing : mariadb-columnstore-gssapi-server-1.2.3-1.el7.centos.x86_64 17/20
|
Installing : mariadb-columnstore-tokudb-engine-1.2.3-1.el7.centos.x86_64 18/20
|
Installing : mariadb-columnstore-rocksdb-engine-1.2.3-1.el7.centos.x86_64 19/20
|
Installing : mariadb-columnstore-storage-engine-1.2.3-1.x86_64 20/20
|
Verifying : mariadb-columnstore-server-1.2.3-1.el7.centos.x86_64 1/20
|
Verifying : 1:tcl-8.5.13-8.el7.x86_64 2/20
|
Verifying : libaio-0.3.109-13.el7.x86_64 3/20
|
Verifying : mariadb-columnstore-gssapi-server-1.2.3-1.el7.centos.x86_64 4/20
|
Verifying : mariadb-columnstore-platform-1.2.3-1.x86_64 5/20
|
Verifying : jemalloc-3.6.0-1.el7.x86_64 6/20
|
Verifying : mariadb-columnstore-storage-engine-1.2.3-1.x86_64 7/20
|
Verifying : mariadb-columnstore-common-1.2.3-1.el7.centos.x86_64 8/20
|
Verifying : mariadb-columnstore-tokudb-engine-1.2.3-1.el7.centos.x86_64 9/20
|
Verifying : mariadb-columnstore-shared-1.2.3-1.el7.centos.x86_64 10/20
|
Verifying : expect-5.45-14.el7_1.x86_64 11/20
|
Verifying : mariadb-columnstore-rocksdb-engine-1.2.3-1.el7.centos.x86_64 12/20
|
Verifying : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64 13/20
|
Verifying : perl-PlRPC-0.2020-14.el7.noarch 14/20
|
Verifying : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64 15/20
|
Verifying : perl-Net-Daemon-0.48-5.el7.noarch 16/20
|
Verifying : perl-DBI-1.627-4.el7.x86_64 17/20
|
Verifying : mariadb-columnstore-libs-1.2.3-1.x86_64 18/20
|
Verifying : mariadb-columnstore-client-1.2.3-1.el7.centos.x86_64 19/20
|
Verifying : perl-IO-Compress-2.061-2.el7.noarch 20/20
|
|
|
Installed:
|
mariadb-columnstore-client.x86_64 0:1.2.3-1.el7.centos mariadb-columnstore-common.x86_64 0:1.2.3-1.el7.centos mariadb-columnstore-gssapi-server.x86_64 0:1.2.3-1.el7.centos mariadb-columnstore-libs.x86_64 0:1.2.3-1
|
mariadb-columnstore-platform.x86_64 0:1.2.3-1 mariadb-columnstore-rocksdb-engine.x86_64 0:1.2.3-1.el7.centos mariadb-columnstore-server.x86_64 0:1.2.3-1.el7.centos mariadb-columnstore-shared.x86_64 0:1.2.3-1.el7.centos
|
mariadb-columnstore-storage-engine.x86_64 0:1.2.3-1 mariadb-columnstore-tokudb-engine.x86_64 0:1.2.3-1.el7.centos
|
|
|
Dependency Installed:
|
expect.x86_64 0:5.45-14.el7_1 jemalloc.x86_64 0:3.6.0-1.el7 libaio.x86_64 0:0.3.109-13.el7 perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7 perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7 perl-DBI.x86_64 0:1.627-4.el7
|
perl-IO-Compress.noarch 0:2.061-2.el7 perl-Net-Daemon.noarch 0:0.48-5.el7 perl-PlRPC.noarch 0:0.2020-14.el7 tcl.x86_64 1:8.5.13-8.el7
|
|
|
Complete!
|
postConfigure output:
[jens@centos7 mariadb-columnstore-api]$ sudo su
|
[root@centos7 mariadb-columnstore-api]# /usr/local/mariadb/columnstore/bin/postConfigure
|
|
|
This is the MariaDB ColumnStore System Configuration and Installation tool.
|
It will Configure the MariaDB ColumnStore System and will perform a Package
|
Installation of all of the Servers within the System that is being configured.
|
|
|
IMPORTANT: This tool requires to run on the Performance Module #1
|
|
|
Prompting instructions:
|
|
|
Press 'enter' to accept a value in (), if available or
|
Enter one of the options within [], if available, or
|
Enter a new value
|
|
|
|
|
===== Setup System Server Type Configuration =====
|
|
|
There are 2 options when configuring the System Server Type: single and multi
|
|
|
'single' - Single-Server install is used when there will only be 1 server configured
|
on the system. It can also be used for production systems, if the plan is
|
to stay single-server.
|
|
|
'multi' - Multi-Server install is used when you want to configure multiple servers now or
|
in the future. With Multi-Server install, you can still configure just 1 server
|
now and add on addition servers/modules in the future.
|
|
|
Select the type of System Server install [1=single, 2=multi] (2) > 1
|
|
|
Performing the Single Server Install.
|
|
|
Enter System Name (columnstore-1) >
|
|
|
===== Setup Storage Configuration =====
|
|
|
|
|
----- Setup Performance Module DBRoot Data Storage Mount Configuration -----
|
|
|
There are 2 options when configuring the storage: internal or external
|
|
|
'internal' - This is specified when a local disk is used for the DBRoot storage.
|
High Availability Server Failover is not Supported in this mode
|
|
|
'external' - This is specified when the DBRoot directories are mounted.
|
High Availability Server Failover is Supported in this mode.
|
|
|
Select the type of Data Storage [1=internal, 2=external] (1) >
|
|
|
Enter the list (Nx,Ny,Nz) or range (Nx-Nz) of DBRoot IDs assigned to module 'pm1' (1) >
|
sh: netstat: command not found
|
|
|
|
|
===== Performing Configuration Setup and MariaDB ColumnStore Startup =====
|
|
|
NOTE: Setting 'NumBlocksPct' to 50%
|
Setting 'TotalUmMemory' to 25% of total memory.
|
|
|
Running the MariaDB ColumnStore setup scripts
|
|
|
post-mysqld-install Successfully Completed
|
post-mysql-install Successfully Completed
|
|
|
Starting MariaDB Columnstore Database Platform
|
|
|
Starting MariaDB ColumnStore Database Platform Starting, please wait ........ DONE
|
|
|
System Catalog Successfull Created
|
|
|
MariaDB ColumnStore Install Successfully Completed, System is Active
|
|
|
Enter the following command to define MariaDB ColumnStore Alias Commands
|
|
|
. /etc/profile.d/columnstoreAlias.sh
|
|
|
Enter 'mcsmysql' to access the MariaDB ColumnStore SQL console
|
Enter 'mcsadmin' to access the MariaDB ColumnStore Admin console
|
|
|
NOTE: The MariaDB ColumnStore Alias Commands are in /etc/profile.d/columnstoreAlias.sh
|