# Addressing Orphans by Attaching New Partitions

Look at the results of `SHOW CLUSTER STATUS` and `SHOW PARTITIONS` from the previous section. We are missing a master for partition 1, but we have an online orphan for partition 1. Assuming this orphan contains data we need, we will want to attach the master:

```sql
ATTACH PARTITION x_test:1 on '127.0.0.1':10002;

```

```sql
SHOW CLUSTER STATUS;

```

```output

+-----------+-------+----------+-----------+-------------+----------+---------+
| Host      | Port  | Database | Role      | State       | Position | Details |
+-----------+-------+----------+-----------+-------------+----------+---------+
| 127.0.0.1 | 10001 | x_test   | Reference | replicating | 0:57     |         |
| 127.0.0.1 | 10001 | x_test_0 | Master    | online      | 0:10     |         |
| 127.0.0.1 | 10001 | x_test_1 | Replica   | replicating | 0:10     |         |
| 127.0.0.1 | 10002 | x_test   | Reference | replicating | 0:57     |         |
| 127.0.0.1 | 10002 | x_test_0 | Replica   | replicating | 0:10     |         |
| 127.0.0.1 | 10002 | x_test_1 | Master    | online      | 0:10     |         |
+-----------+-------+----------+-----------+-------------+----------+---------+

```

```sql
SHOW PARTITIONS;

```

```output

+---------+-----------+-------+---------+--------+
| Ordinal | Host      | Port  | Role    | Locked |
+---------+-----------+-------+---------+--------+
| 0       | 127.0.0.1 | 10001 | Master  | 0      |
| 0       | 127.0.0.1 | 10002 | Replica | 0      |
| 1       | 127.0.0.1 | 10001 | replica | 0      |
| 1       | 127.0.0.1 | 10002 | Master  | 0      |
+---------+-----------+-------+---------+--------+

```

> **⚠️ Warning**: Do not run high level commands (`REBALANCE PARTITIONS`, `RESTORE REDUNDANCY`, `DETACH LEAF`, etc.) to attach the orphan into the cluster. High level commands may drop the orphan.

If your cluster has many partitions, you may want to [count its partitions by role](https://docs.singlestore.com/db/v9.1/reference/troubleshooting-reference/counting-partitions-by-role.md) to help identify any orphaned partitions.

***

Modified at: April 27, 2023

Source: [/db/v9.1/reference/troubleshooting-reference/understanding-orphaned-partitions/addressing-orphans-by-attaching-new-partitions/](https://docs.singlestore.com/db/v9.1/reference/troubleshooting-reference/understanding-orphaned-partitions/addressing-orphans-by-attaching-new-partitions/)

(An index of the documentation is available at /llms.txt)
