[MCOL-1317] Columnstore Cluster Tester tool does not check the availability of all ports needed to mcs operations Created: 2018-04-02  Updated: 2023-10-26  Resolved: 2018-04-16

Status: Closed
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 1.1.2, 1.1.3
Fix Version/s: 1.1.4

Type: Bug Priority: Major
Reporter: Zdravelina Sokolovska (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Sprint: 2018-07, 2018-08

 Description   

Columnstore Cluster Tester tool does not check the availability of all ports needed to mcs operations

Columnstore Cluster Tester tool is checking the availability of ports 8600-8620 only
however in docs are pointed out that the ports 3306,8600 - 8630, 8700, and 8800 , are needed to run the MariaDB ColumnStore software.

MariaDB ColumnStore port usage

MariaDB ColumnStore port usage
 
 
 
The MariaDB ColumnStore daemon utilizes port 3306.
 
 
 
You must reserve the following ports to run the MariaDB ColumnStore software: 8600 - 8630, 8700, and 8800

below Columnstore Cluster Tester Tool pass the section checking Port availability test

[root@um1 ~]# firewall-cmd --permanent --zone=public --remove-port=8630/tcp
 
Warning: NOT_ENABLED: 8630:tcp
 
success
 



** Run MariaDB ColumnStore Port (8600-8620) availability test
 
 
 
172.20.2.205  Node Passed port test
 
172.20.2.206  Node Passed port test



 Comments   
Comment by Zdravelina Sokolovska (Inactive) [ 2018-04-02 ]

note : issue is opened in conjunction to the customer documentation related ticked ID: 18438

Comment by David Hill (Inactive) [ 2018-04-05 ]

Added additional ports

    • Run MariaDB ColumnStore Port (8600-8630,8700,8800,3306) availability test

https://github.com/mariadb-corporation/mariadb-columnstore-engine/pull/436

Comment by David Hill (Inactive) [ 2018-04-05 ]

https://github.com/mariadb-corporation/mariadb-columnstore-engine/pull/436

Comment by Daniel Lee (Inactive) [ 2018-04-16 ]

Build verified: 1.1.4-1 source

/root/columnstore/mariadb-columnstore-server
commit 5199dd1a096fd3457e8fc0508bf5fb24cedec435
Merge: fce3c5e e554e04
Author: David.Hall <david.hall@mariadb.com>
Date: Wed Apr 11 11:04:46 2018 -0500

Merge pull request #108 from mariadb-corporation/MCOL-1331

MCOL-1331 Fix CASE1.DM.sql

/root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine
[root@localhost mariadb-columnstore-engine]# git show
commit ae04b8a6877c87f3ed3566f2bf721bf285ca625f
Merge: 2ab632c dbcbd6c
Author: david hill <david.hill@mariadb.com>
Date: Tue Apr 10 10:55:56 2018 -0400

Merge pull request #438 from mariadb-corporation/MCOL-1323

MCOL-1323 cpimport Splitter has incorrect SIGPIPE mapping

diff --cc writeengine/splitter/we_splitterapp.cpp
index f52f362,0077ebd..402d2b0
mode 100755,100644..100755
— a/writeengine/splitter/we_splitterapp.cpp
+++ b/writeengine/splitter/we_splitterapp.cpp

On a 1um2pm stack, enabled firewall using port 8630 and ran test mentioned in the ticket.

Also did cold review on the columnstoreClusterTester.sh script

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