We have cluster of three nodes with 6 shards. But on two nodes, replica shards are missing resulting in below error:
Error! SQLParseException[Couldn't create execution plan from logical plan because of: the shard 4 of table [device] is not available:
Showing CrateDB cluster health as Critical
So, in order to resolve that we tried executing this command
ALTER CLUSTER REROUTE RETRY FAILED
But, it didn’t do anything and still showing the same error.
Here is the output of
select * from sys.allocations where current_state != 'STARTED' limit 100;
Any Help would be much appreciated.