blob: 1c976ac975bf75f1d465b0668487777ed824ce9b (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
---
tags:
- groupvps
- datacorruption
- volume-connector
---
```mysql
select volume_id, count(*) as con from volume_attachment where deleted_at is null group by volume_id having con > 1 ;
```
and to find the ones in use
```mysql
select * from volume_attachment where deleted_at is NULL and volume_id = "e9ee5691-a3cd-4696-9db9-bda17c2cf664" \G
```
Take care that the server is not **MIGRATING** because it will have 2 active attachments then.
|
