facing below error.
current redundancy_level value is 1.
Is it possible to change state? to online from replicating
ERROR 1730 (HY000): The database ‘test’ is in the ‘replicating’ state and is thus not available for writes. Run SHOW DATABASES EXTENDED and visit SHOW DATABASES · SingleStore Documentation for more information
memsql> show variables like '%redun%';
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| redundancy_level | 1 |
+------------------+-------+
1 row in set (0.00 sec)
Is that database a DR replica? Did you replicate it from somewhere else?
While it’s a replica, you can’t write to it. If you intend for it to no longer be a replica you can run STOP REPLICATING test, and start writing to it, but note that it will stop replicating from whatever other cluster you have. It seems that the remote cluster is down given that your test replica reports as disconnected.
Also, that your two leaves are in a Recovering state is odd, and could impact the STOP REPLICATING. Can you run show cluster status to see what’s happening there? If the replica partitions are in an invalid state, then you don’t have all the data in the replica, and will need to replicate from the remote cluster before you can stop it.
