We have installed MemSQL 6.7.11 following the latest official guide.
We have created a user “memuser” with sudo privileges and used it to launch the “memsql-deploy setup-cluster” command.
The command completed successfully and returned the following:
memsql-deploy will perform the following actions:
· Install memsql-server 6.7.11 on hosts
· Deploy a master aggregator on x.x.x.x:3306
- Enable high availability mode
· Deploy a child aggregator on x.x.x.x:3306
· Deploy leaf nodes on
· Set MemSQL root password on all nodes
Would you like to continue? [y/N]: y
Downloaded memsql-server 6.7.11
Installing MemSQL on all hosts…
Installed memsql-server6.7.11-5d2517b77a on host x.x.x.x (1/6)
Installed memsql-server6.7.11-5d2517b77a on host x.x.x.x (2/6)
Installed memsql-server6.7.11-5d2517b77a on host x.x.x.x (3/6)
Installed memsql-server6.7.11-5d2517b77a on host x.x.x.x (4/6)
Installed memsql-server6.7.11-5d2517b77a on host x.x.x.x (5/6)
Installed memsql-server6.7.11-5d2517b77a on host x.x.x.x (6/6)
Successfully installed on 6 hosts
Created master node
Successfully set license
Bootstrapped master aggregator
Enabled high availability mode
Created aggregator nodes
Added aggregators nodes to cluster
Created leaf nodes
Added leaf nodes to cluster
To view your cluster, run ‘memsql-admin list-nodes’
But, whenever we run ‘memsql-admin list-nodes’, it returns the following:
✘ Failed to list nodes on all hosts: failed to list nodes on 6 hosts: x.x.x.x, x.x.x.x, x.x.x.x, x.x.x.x, x.x.x.x, x.x.x.x
No nodes found
Running “sudo memsqlctl …” returns the data successfully and shows the cluster as up and running.
After troubleshooting the issue, it seems memsql-admin is trying to launch memsqlctl as “memuser” as memsql-report would return the following error:
✘ Failed to collect informationSchemaPipelines: error running memsqlctl: error running command:
"/usr/bin/memsqlctl" "--json" "--yes" "list-nodes" "--"Master": exit status 1
stderr: memsqlctl is configured to require that users be in the ‘memsql’ group for read access. Please rerun the command as a user in this group or theuser: open /var/lib/memsql/nodes.hcl.lock: permission denied
If we configure memsql-admin to implicitly run as root, then everything will work fine. But it’s not recommended from our side and memsql doesn’t require it.
Is the above behavior a bug? Or have we missed something?