CODEWITHSUNDEEP
singlestore
AngryHacker
AngryHacker

Reputation: 61646

Getting errors creating MemSQL database

I installed MemSQL per video instructions on the download page. During installation it told me that port 3306 was unavailable to use with Master Aggregator, so changed it to 4000. And I can connect to it via MySQL Workbench.

I attempt to create a database:

CREATE DATABASE EnterpriseCopy

It returns an error: Error Code: 1748. You must add at least one leaf to the system to run CREATE DATABASE. Ok, so I go into Web UI and I see that none of the nodes (master aggregator on port 4000 or leaf on port 3307) are running.

enter image description here

I tried ATTACH LEAF '10.82.60.43':3307, but it came back with Error Code: 1802. Leaf '10.82.60.43':3307 is currently 'offline' and cannot be attached back into the cluster until it is reachable and in the 'detached' state.

So can I fix this and bring the master and leaf online and reachable?

Upvotes: 2

Views: 1289

Answers (2)

Shailesh
Shailesh

Reputation: 2286

I faced the same problem, here's what worked for me:

  1. Delete the nodes using: memsql-ops memsql-delete --all
  2. Re-deploy them : memsql-ops memsql-deploy -r master -P 3307 memsql-ops memsql-deploy -r leaf -P 3308

You can change the port number as you'd want.

Upvotes: 2

Douglas
Douglas

Reputation: 21

From the description provided it appears that your MemSQL Ops agents are running but the nodes themselves are not. You can start the nodes using:

memsql-ops memsql-start --all

Be sure to run this on the master aggregator host.

Upvotes: 1

Related Questions