# CrateDB 3 Node Cluster: Replica Shards are missing

**URL:** <https://community.cratedb.com/t/cratedb-3-node-cluster-replica-shards-are-missing/1334>\
**Category:** CrateDB\
**Created:** [January 19, 2023, 9:32am UTC](https://community.cratedb.com/t/cratedb-3-node-cluster-replica-shards-are-missing/1334 "2023-01-19T09:32:03Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![BANDANA\_PANDEY](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/bandana_pandey/32/740_2.png) [@BANDANA\_PANDEY](https://community.cratedb.com/u/BANDANA_PANDEY)\
**Post date:** [January 19, 2023, 9:32am UTC](https://community.cratedb.com/t/cratedb-3-node-cluster-replica-shards-are-missing/1334/1 "2023-01-19T09:32:04Z")

</div>

Hi,

We have cluster of three nodes with 6 shards. But on two nodes, replica shards are missing resulting in below error:

```auto
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**

 ![Screenshot 2023-01-19 at 2.57.33 PM](https://us1.discourse-cdn.com/flex020/uploads/crate/original/1X/e8db00fafb8661e652c0cf4b17d63aa04d92217c.png)

So, in order to resolve that we tried executing this command

```auto
 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;`

 ![Screenshot 2023-01-19 at 3.01.07 PM](https://us1.discourse-cdn.com/flex020/uploads/crate/original/1X/4caff48aa814034a1a17da646abcd533d8d8e3db.png)

Any Help would be much appreciated.  
Thanks

---

<div class="post-metadata">

**Author:** ![proddata](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/proddata/32/1379_2.png) [@proddata](https://community.cratedb.com/u/proddata)\
**Post date:** [January 19, 2023, 9:35am UTC](https://community.cratedb.com/t/cratedb-3-node-cluster-replica-shards-are-missing/1334/2 "2023-01-19T09:35:18Z")

</div>

Could your share the decisions (2nd column)?

Seems like some primaries are also currently not allocated to any node.

---

<div class="post-metadata">

**Author:** ![BANDANA\_PANDEY](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/bandana_pandey/32/740_2.png) [@BANDANA\_PANDEY](https://community.cratedb.com/u/BANDANA_PANDEY)\
**Post date:** [January 19, 2023, 9:41am UTC](https://community.cratedb.com/t/cratedb-3-node-cluster-replica-shards-are-missing/1334/3 "2023-01-19T09:41:47Z")

</div>

![Screenshot 2023-01-19 at 3.10.42 PM](https://us1.discourse-cdn.com/flex020/uploads/crate/original/1X/2b82eff1797b1430503e293a2e6a70006e1888c2.jpeg)  
 ![Screenshot 2023-01-19 at 3.11.15 PM](https://us1.discourse-cdn.com/flex020/uploads/crate/original/1X/aaaf49a08b41e2819f01a9c8e554f48952bc8268.png)  
@proddata here

---

<div class="post-metadata">

**Author:** ![proddata](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/proddata/32/1379_2.png) [@proddata](https://community.cratedb.com/u/proddata)\
**Post date:** [January 19, 2023, 10:54am UTC](https://community.cratedb.com/t/cratedb-3-node-cluster-replica-shards-are-missing/1334/4 "2023-01-19T10:54:58Z")

</div>

Did one of the nodes crash or did you restart the cluster within the last 48h?  
Could you share the logs for the nodes?