From 80ccf68f55dbb70d7e5ed52ee95b3c9d1b6ce264 Mon Sep 17 00:00:00 2001 From: Jasper Ras Date: Thu, 20 Mar 2025 11:07:49 +0100 Subject: vault backup: 2025-03-20 11:07:48 --- .../VPS platform/Query duplicate volume connectors.md | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 2 Areas/Werk/VPS platform/Query duplicate volume connectors.md (limited to '2 Areas/Werk/VPS platform/Query duplicate volume connectors.md') 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 -- cgit v1.2.3