tomp
(Thomas Parrott)
November 16, 2022, 8:25am
21
OK I’m quite confused how your database got into this state.
Anyway please show the output of lxd sql global 'select * from storage_volumes'
and then we’ll manually delete the offending image volume record that is holding up the cluster member delete.
avml
(Adrean)
November 16, 2022, 5:48pm
22
haha!!! I dunno bud I’m just here using the greatness you guys are creating.
lxd sql global 'select * from storage_volumes'
+-----+------------------------------------------------------------------+-----------------+---------+------+-------------+------------+--------------+
| id | name | storage_pool_id | node_id | type | description | project_id | content_type |
+-----+------------------------------------------------------------------+-----------------+---------+------+-------------+------------+--------------+
| 1 | pi-hole | 1 | 1 | 0 | | 1 | 0 |
| 3 | nds | 1 | 3 | 0 | | 1 | 0 |
| 15 | vpn-server | 1 | 1 | 0 | | 5 | 0 |
| 30 | grafana | 1 | 1 | 0 | | 7 | 0 |
| 31 | prometheus | 1 | 1 | 0 | | 7 | 0 |
| 32 | uptime-kuma | 1 | 3 | 0 | | 7 | 0 |
| 38 | nzbget | 1 | 1 | 0 | | 8 | 0 |
| 39 | plex | 1 | 3 | 0 | | 8 | 0 |
| 41 | radarr | 1 | 3 | 0 | | 8 | 0 |
| 46 | ef5e9bfe1a9c1d5018b6560c39b0e21cf18048b73959d7d88c896ef64513e661 | 1 | 2 | 1 | | 1 | 0 |
| 48 | dcdf86f2a6d848c6e46777835be6ea15f2950bc7905ca326687b52c99e2fb510 | 1 | 3 | 1 | | 1 | 0 |
| 52 | 6d15e60d2685df886f2030244070aa6f84d26739474f2f03eb2cf541e9424cc4 | 1 | 3 | 1 | | 1 | 0 |
| 77 | 2d673c8f8755651deaea70a6973335ba2d9239695d41878c1ffd1def30e8dceb | 1 | 3 | 1 | | 1 | 0 |
| 78 | prowlarr | 1 | 4 | 0 | | 8 | 0 |
| 90 | tech-dns | 1 | 4 | 0 | | 1 | 0 |
| 92 | sonarr | 1 | 4 | 0 | | 8 | 0 |
| 93 | pi-hole2 | 1 | 1 | 0 | | 1 | 0 |
| 95 | 5dc7c9e6974565f5908155b89296daea0d863eccd44b67ea919120fb87a486c7 | 1 | 2 | 1 | | 1 | 0 |
| 97 | gotosocial | 1 | 4 | 0 | | 5 | 0 |
| 98 | 5dc7c9e6974565f5908155b89296daea0d863eccd44b67ea919120fb87a486c7 | 1 | 4 | 1 | | 1 | 0 |
| 99 | underated-postgres | 1 | 3 | 0 | | 7 | 0 |
| 100 | 5dc7c9e6974565f5908155b89296daea0d863eccd44b67ea919120fb87a486c7 | 1 | 3 | 1 | | 1 | 0 |
+-----+------------------------------------------------------------------+-----------------+---------+------+-------------+------------+--------------+
tomp
(Thomas Parrott)
November 17, 2022, 8:16am
23
OK can you now do:
sudo lxd sql global 'DELETE FROM storage_volumes where name = "ef5e9bfe1a9c1d5018b6560c39b0e21cf18048b73959d7d88c896ef64513e661"'
avml
(Adrean)
November 17, 2022, 3:58pm
24
Aye!!! Finally that let me remove anuke! Thank you for sticking with me!
1 Like