Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
1.2.4
-
None
Description
MariaDB Columnstore Cluster System Test Tool fail to Remote Nodes where mcs has to be installed for a first time
Tool fails with Error about missing file /tmp/columnstore_tmp_files/remote_scp_put_check
on the Remote Mode
note : ssh passwordless login was ensured between nodes;
how to repeat:
Prepare the Nodes for columnstore installation
On the Local Node unpack and install mariadb-columnstore packages
Before performing the distributed install, run the columnstoreClusterTester.sh with target
Remote Nodes where mariadb columnstore has to be installed
|
|
[root@cps ~]# rpm -ivh mariadb-columnstore-1.2.4-1*rpm
|
Preparing... ################################# [100%]
|
Updating / installing...
|
1:mariadb-columnstore-common-1.2.4-################################# [ 10%]
|
2:mariadb-columnstore-libs-1.2.4-1 ################################# [ 20%]
|
3:mariadb-columnstore-client-1.2.4-################################# [ 30%]
|
4:mariadb-columnstore-server-1.2.4-################################# [ 40%]
|
5:mariadb-columnstore-shared-1.2.4-################################# [ 50%]
|
6:mariadb-columnstore-platform-1.2.################################# [ 60%]
|
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
|
|
|
|
|
7:mariadb-columnstore-gssapi-server################################# [ 70%]
|
8:mariadb-columnstore-rocksdb-engin################################# [ 80%]
|
9:mariadb-columnstore-tokudb-engine################################# [ 90%]
|
10:mariadb-columnstore-storage-engin################################# [100%]
|
|
# /usr/local/mariadb/columnstore/bin/columnstoreClusterTester.sh --ipaddr=172.20.3.25,172.20.3.24
|
|
|
*** This is the MariaDB Columnstore Cluster System Test Tool ***
|
|
|
** Validate local OS is supported
|
|
|
Local Node OS System Name : CentOS Linux 7 (Core)
|
|
|
** Run Local UMASK check
|
|
|
UMASK local setting test passed
|
|
|
** Run Local SELINUX check
|
|
|
Local Node SELINUX setting is Not Enabled
|
|
|
** Run Ping access Test to remote nodes
|
|
|
172.20.3.25 Node Passed ping test
|
172.20.3.24 Node Passed ping test
|
|
|
** Run SSH Login access Test to remote nodes
|
|
|
172.20.3.25 Node Passed SSH login test using ssh-keys
|
172.20.3.24 Node Passed SSH login test using ssh-keys
|
|
|
** Run OS check - OS version needs to be the same on all nodes
|
|
|
Local Node OS Version : CentOS Linux 7 (Core)
|
|
|
Error running remote_scp_put.sh to 172.20.3.25 Node, check /tmp/columnstore_tmp_files/remote_scp_put_check
|
|
Workaround :
ssh root@172.20.3.25 'mkdir -p /tmp/columnstore_tmp_files/'
|
scp /tmp/columnstore_tmp_files/remote_scp_put_check root@172.20.3.25:/tmp/columnstore_tmp_files/remote_scp_put_check
|
remote_scp_put_check 100% 4534 270.7KB/s 00:00
|
and rerun the tool in order to perform the checks needed for mcs installation
/usr/local/mariadb/columnstore/bin/columnstoreClusterTester.sh --ipaddr=172.20.3.25,172.20.3.24
|
|
|
*** This is the MariaDB Columnstore Cluster System Test Tool ***
|
|
|
** Validate local OS is supported
|
|
|
Local Node OS System Name : CentOS Linux 7 (Core)
|
|
|
** Run Local UMASK check
|
|
|
UMASK local setting test passed
|
|
|
** Run Local SELINUX check
|
|
|
Local Node SELINUX setting is Not Enabled
|
|
|
** Run Ping access Test to remote nodes
|
|
|
172.20.3.25 Node Passed ping test
|
172.20.3.24 Node Passed ping test
|
|
|
** Run SSH Login access Test to remote nodes
|
|
|
172.20.3.25 Node Passed SSH login test using ssh-keys
|
172.20.3.24 Node Passed SSH login test using ssh-keys
|
|
|
** Run OS check - OS version needs to be the same on all nodes
|
|
|
Local Node OS Version : CentOS Linux 7 (Core)
|
|
|
172.20.3.25 Node OS Version : CentOS Linux 7 (Core)
|
172.20.3.24 Node OS Version : CentOS Linux 7 (Core)
|
|
|
** Run Locale check - Locale needs to be the same on all nodes
|
|
|
Local Node Locale : LANG=en_US.UTF-8
|
172.20.3.25 Node Locale : LANG=en_US.UTF-8
|
172.20.3.24 Node Locale : LANG=en_US.UTF-8
|
|
|
** Run UMASK check
|
|
|
172.20.3.25 Node UMASK setting test passed
|
172.20.3.24 Node UMASK setting test passed
|
|
|
** Run SELINUX check
|
|
|
172.20.3.25 Node SELINUX setting is Not Enabled
|
172.20.3.24 Node SELINUX setting is Not Enabled
|
|
|
** Run Firewall Services check
|
|
|
Local Node iptables service is Not Active
|
Local Node ufw service is Not Active
|
Local Node firewalld service is Not Active
|
Local Node firewall service is Not Active
|
|
|
172.20.3.25 Node iptables service is Not Enabled
|
172.20.3.25 Node ufw service is Not Enabled
|
172.20.3.25 Node firewalld service is Not Enabled
|
172.20.3.25 Node firewall service is Not Enabled
|
|
|
172.20.3.24 Node iptables service is Not Enabled
|
172.20.3.24 Node ufw service is Not Enabled
|
172.20.3.24 Node firewalld service is Not Enabled
|
172.20.3.24 Node firewall service is Not Enabled
|
|
|
|
|
** Run MariaDB ColumnStore Port (8600-8630,8700,8800,3306) availability test
|
|
|
172.20.3.25 Node Passed port test
|
172.20.3.24 Node Passed port test
|
|
|
** Run Date/Time check - Date/Time should be within 10 seconds on all nodes
|
|
|
Passed: 172.20.3.25 Node date/time is within 10 seconds of local node
|
Passed: 172.20.3.24 Node date/time is within 10 seconds of local node
|
|
|
** Run MariaDB Console Password check
|
|
|
Passed, no problems detected with a MariaDB password being set without an associated /root/.my.cnf
|
|
|
** Run MariaDB ColumnStore Dependent Package Check
|
|
|
Local Node - Passed, all dependency packages are installed
|
Local Node - Passed, all packages that should not be installed aren't installed
|
|
|
172.20.3.25 Node - Passed, all dependency packages are installed
|
|
|
172.20.3.25 Node - Passed, all packages that should not be installed aren't installed
|
|
|
172.20.3.24 Node - Passed, all dependency packages are installed
|
|
|
172.20.3.24 Node - Passed, all packages that should not be installed aren't installed
|
|
|
|
|
*** Finished Validation of the Cluster, all Tests Passed ***
|