Home Ask Login Register

Developers Planet

Your answer is one click away!

Mauro Pirrone February 2016

MemSQL Partition has no master instance

Running queries on a MemSQL tables returns the following error.

Error Code: 1777. Partition db_name:0 has no master instance.

I understand MemSQL Enterprise avoids this error from coming in the first place; however, I tried dropping the table, truncating data, and restarting the cluster several times, yet I still get the same error. Any ideas how to fix this error?


Adam Prout February 2016

Does "SHOW LEAVES" show all leaf nodes as online? In redundancy 1 you need all leaves online to run queries. Run REMOVE LEAF if you want to permanently remove an offline leaf from the cluster.

Post Status

Asked in February 2016
Viewed 2,063 times
Voted 9
Answered 1 times


Leave an answer

Quote of the day: live life