# 2021-10-11-16:41:21+1300 clean hanging clusters in prod

- Cause: https://jira.tidbcloud.com/browse/TCOC-170
- Operation: execute the follwing sql on metadb
1. Check the clusters' status, the following clusters should be 'Deleted', or 'DeleteComplete' or 'Cleared'
```sql
select id,status,tenant_id from clusters where id in (1379661944580074069,1379661944580554068,1379661944580104065,1379661944580284068);
```
2.Check the the teanants' status, the following tenants should be 'Deleted'
```sql
select id,name,status from tenants where id in (select tenant_id from clusters where id in (1379661944580074069,1379661944580554068,1379661944580104065,1379661944580284068));
```
3. If the tenants are marked as 'Deleted', mark the clusters as 'Cleared'
```sql
update clusters set status='cleared' where id in (1379661944580074069,1379661944580554068,1379661944580104065,1379661944580284068);
```
- Impact: some clusters' status will be set as cleared
- Recovery operation: N/A
- Time window: 11:20~12:00 CST 2021/10/11