1 files changed, 16 insertions, 0 deletions
diff --git a/2 Areas/Werk/VPS platform/Query duplicate volume connectors.md b/2 Areas/Werk/VPS platform/Query duplicate volume connectors.md
new file mode 100644
index 0000000..1c976ac
--- /dev/null
+++ b/2 Areas/Werk/VPS platform/Query duplicate volume connectors.md
@@ -0,0 +1,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.
+\ No newline at end of file