[MCOL-3269]  MariaDB Columnstore Cluster System Test Tool fail to Remote Nodes where mcs has to be installed for a first time Created: 2019-04-18  Updated: 2019-07-10  Resolved: 2019-07-10

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

Type: Bug Priority: Major
Reporter: Zdravelina Sokolovska (Inactive) Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: 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 ***


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