---
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.