Memsql-list shows newly added leaf node in DISCONNECTED state
I added a new leaf node(10.162.140.63) using memsql-ops UI, but the node is disconnected from the cluster. Existing leaf node (10.162.141.12) works correctly.
$ memsql-ops memsql-list
ID Agent Id Process State Cluster State Role Host Port Version
DB381ED A57780e RUNNING CONNECTED MASTER 10.162.141.11 3306 7.1.2
4BB555C A20f163 RUNNING CONNECTED LEAF 10.162.141.12 3306 7.1.2
C2C2080 A9af13d RUNNING DISCONNECTED LEAF 10.162.140.63 3306 7.1.2
$ memsql-ops agent-list
ID Host Port Role State Version
A57780e 10.162.141.11 9000 PRIMARY ONLINE 6.7.8
A20f163 10.162.141.12 9000 FOLLOWER ONLINE 6.7.8
A9af13d 10.162.140.63 9000 FOLLOWER ONLINE 6.7.8
Attaching screenshot from memsql ops UI. Any help would be highly appreciated.
Solution
I’d recommend upgrading to a new engine release and also upgrading to SingleStore tools 1. Memsql-ops is not supported any longer.
- Postgres selecting from table row
- To find the next work day
- SQL Server Left Join With 'Or' Operator
- How to exclusivley select a record from different tables
- Add user to table and use users id while adding data to second table while user registration
- Selecting the earliest row where a specified date value falls between a date range (two columns) when multiple rows may match
- SQL AVG returning an int
- Using two tables. What am I doing wrong here?
- ORDER BY column, with specific notnull value LAST
- How to get the first available number in a range
- In GENERATE_SPREADSHEET SQL on IBM i there are problems if a $ character is present in qualified names
- How to return default value from SQL query
- how to sort a column which contains Semantic Version in Postgres
- Proper Case in Athena SQL
- SQL VBA Query not picking up letter characters, only fully numeric fields
- Joining two tables with a joint result in Postgresql
- Can I Query or Do I Need a Table Function?
- How to link 3 SQL tables and pass 0 value if the value is NULL
- Searching all tables in database containing specific column
- Convert VARCHAR to SMALLDATETIME as part of UPDATE statement
- WordPress - Optimize the Meta Query for 3 meta keys at a time
- How can I find the highest ancestor in a tree?
- Firebird lock and select unlocked fields
- How to pass parameters in a native query JPA
- SQL Server : query columns to JSON object with group by
- SQL Server While loop for last day of month
- Can anyone please explain this solution of hacker rank Binary Tree Nodes?
- generate DDL script from SQL Server database
- How to return name, given an ID Number from same dataset?
- Get the names of all the tables and the views in a single SQL query for SQL Server?