Running:
lxd sql global "select * from storage_volumes_all WHERE name LIKE '%tracsvn-dev/snap%' ORDER BY name LIMIT 10"
seeing dupes:
+-------+--------------------+-----------------+---------+------+-------------+------------+--------------+----------------------+
| id | name | storage_pool_id | node_id | type | description | project_id | content_type | creation_date |
+-------+--------------------+-----------------+---------+------+-------------+------------+--------------+----------------------+
| 374 | tracsvn-dev/snap0 | 1 | 1 | 0 | | 1 | 0 | 0001-01-01T00:00:00Z |
| 14396 | tracsvn-dev/snap0 | 1 | 1 | 0 | | 1 | 0 | 0001-01-01T00:00:00Z |
| 382 | tracsvn-dev/snap1 | 1 | 1 | 0 | | 1 | 0 | 0001-01-01T00:00:00Z |
| 14430 | tracsvn-dev/snap1 | 1 | 1 | 0 | | 1 | 0 | 0001-01-01T00:00:00Z |
| 475 | tracsvn-dev/snap10 | 1 | 1 | 0 | | 1 | 0 | 0001-01-01T00:00:00Z |
| 14923 | tracsvn-dev/snap10 | 1 | 1 | 0 | | 1 | 0 | 0001-01-01T00:00:00Z |
| 484 | tracsvn-dev/snap11 | 1 | 1 | 0 | | 1 | 0 | 0001-01-01T00:00:00Z |
| 14981 | tracsvn-dev/snap11 | 1 | 1 | 0 | | 1 | 0 | 0001-01-01T00:00:00Z |
| 494 | tracsvn-dev/snap12 | 1 | 1 | 0 | | 1 | 0 | 0001-01-01T00:00:00Z |
| 15031 | tracsvn-dev/snap12 | 1 | 1 | 0 | | 1 | 0 | 0001-01-01T00:00:00Z |
+-------+--------------------+-----------------+---------+------+-------------+------------+--------------+----------------------+
running:
lxd sql global "select * from storage_volumes_all WHERE name LIKE '%tracsvn-dev/snap1%' ORDER BY name"
I start seeing some with non-crazy creation dates
| id | name | storage_pool_id | node_id | type | description | project_id | content_type | creation_date |
+-------+--------------------+-----------------+---------+------+-------------+------------+--------------+--------------------------------+
| 382 | tracsvn-dev/snap1 | 1 | 1 | 0 | | 1 | 0 | 0001-01-01T00:00:00Z |
| 14430 | tracsvn-dev/snap1 | 1 | 1 | 0 | | 1 | 0 | 0001-01-01T00:00:00Z |
| 475 | tracsvn-dev/snap10 | 1 | 1 | 0 | | 1 | 0 | 0001-01-01T00:00:00Z |
| 14923 | tracsvn-dev/snap10 | 1 | 1 | 0 | | 1 | 0 | 0001-01-01T00:00:00Z |
| 484 | tracsvn-dev/snap11 | 1 | 1 | 0 | | 1 | 0 | 0001-01-01T00:00:00Z |
| 14981 | tracsvn-dev/snap11 | 1 | 1 | 0 | | 1 | 0 | 0001-01-01T00:00:00Z |
| 494 | tracsvn-dev/snap12 | 1 | 1 | 0 | | 1 | 0 | 0001-01-01T00:00:00Z |
| 15031 | tracsvn-dev/snap12 | 1 | 1 | 0 | | 1 | 0 | 0001-01-01T00:00:00Z |
| 504 | tracsvn-dev/snap13 | 1 | 1 | 0 | | 1 | 0 | 0001-01-01T00:00:00Z |
| 15091 | tracsvn-dev/snap13 | 1 | 1 | 0 | | 1 | 0 | 0001-01-01T00:00:00Z |
| 517 | tracsvn-dev/snap14 | 1 | 1 | 0 | | 1 | 0 | 0001-01-01T00:00:00Z |
| 15147 | tracsvn-dev/snap14 | 1 | 1 | 0 | | 1 | 0 | 2022-11-26T02:01:35.078400865Z |
| 526 | tracsvn-dev/snap15 | 1 | 1 | 0 | | 1 | 0 | 0001-01-01T00:00:00Z |
| 15204 | tracsvn-dev/snap15 | 1 | 1 | 0 | | 1 | 0 | 2022-11-30T02:01:07.282444301Z |
| 527 | tracsvn-dev/snap16 | 1 | 1 | 0 | | 1 | 0 | 0001-01-01T00:00:00Z |
| 15233 | tracsvn-dev/snap16 | 1 | 1 | 0 | | 1 | 0 | 2022-12-02T02:01:50.381070563Z |
| 536 | tracsvn-dev/snap17 | 1 | 1 | 0 | | 1 | 0 | 0001-01-01T00:00:00Z |
| 15295 | tracsvn-dev/snap17 | 1 | 1 | 0 | | 1 | 0 | 2022-12-06T02:01:13.195890766Z |
| 545 | tracsvn-dev/snap18 | 1 | 1 | 0 | | 1 | 0 | 0001-01-01T00:00:00Z |
| 15353 | tracsvn-dev/snap18 | 1 | 1 | 0 | | 1 | 0 | 2022-12-10T02:01:39.091491887Z |
| 554 | tracsvn-dev/snap19 | 1 | 1 | 0 | | 1 | 0 | 0001-01-01T00:00:00Z |
| 15413 | tracsvn-dev/snap19 | 1 | 1 | 0 | | 1 | 0 | 2022-12-14T02:01:41.055669054Z |
+-------+--------------------+-----------------+---------+------+-------------+------------+--------------+--------------------------------+
For the other server in question that has same issue, both of these were upgraded to Ubuntu 22 from 20 and are now running 5.10
For the other server in question
lxc config show wordpress --expanded
architecture: x86_64
config:
environment.LANG: en_US.UTF-8
environment.LC_ALL: en_US.UTF-8
environment.LC_COLLATE: POSIX
limits.cpu: "4"
limits.cpu.allowance: 20%
limits.memory: 8GB
raw.lxc: lxc.mount.entry = none dev/shm tmpfs rw,nosuid,nodev,create=dir
snapshots.expiry: 30d
snapshots.schedule: 15 18 * * *
volatile.eth0.hwaddr: 00:16:3e:61:d7:92
volatile.idmap.base: "0"
volatile.idmap.current: '[{"Isuid":true,"Isgid":false,"Hostid":1000000,"Nsid":0,"Maprange":1000000000},{"Isuid":false,"Isgid":true,"Hostid":1000000,"Nsid":0,"Maprange":1000000000}]'
volatile.idmap.next: '[{"Isuid":true,"Isgid":false,"Hostid":1000000,"Nsid":0,"Maprange":1000000000},{"Isuid":false,"Isgid":true,"Hostid":1000000,"Nsid":0,"Maprange":1000000000}]'
volatile.last_state.idmap: '[{"Isuid":true,"Isgid":false,"Hostid":1000000,"Nsid":0,"Maprange":1000000000},{"Isuid":false,"Isgid":true,"Hostid":1000000,"Nsid":0,"Maprange":1000000000}]'
volatile.last_state.power: STOPPED
volatile.uuid: 5a204571-166d-49dc-90d9-e2cb6e9c536b
devices:
eth0:
name: eth0
nictype: bridged
parent: lxdbr0
type: nic
root:
path: /
pool: default
size: 200GB
type: disk
ephemeral: false
profiles:
- default
stateful: false
description: ""
lxc storage show default | grep wordpress/
- /1.0/instances/wordpress/snapshots/after-2018-foss4g-moved
- /1.0/instances/wordpress/snapshots/after-2018-foss4g-moved
- /1.0/instances/wordpress/snapshots/after-change-to-dhcp
- /1.0/instances/wordpress/snapshots/after-change-to-dhcp
- /1.0/instances/wordpress/snapshots/after-imagemagick-bcmath-install
- /1.0/instances/wordpress/snapshots/after-imagemagick-bcmath-install
- /1.0/instances/wordpress/snapshots/after-moving-www-over
- /1.0/instances/wordpress/snapshots/after-moving-www-over
- /1.0/instances/wordpress/snapshots/bash
Note this one I have stopped a while ago, so all the snapshots that were set to expire have since disappeared.
lxc storage volume list default | grep wordpress/
| container (snapshot) | wordpress/after-2018-foss4g-moved | | filesystem | 1 |
| container (snapshot) | wordpress/after-2018-foss4g-moved | Auto repaired | filesystem | 1 |
| container (snapshot) | wordpress/after-change-to-dhcp | | filesystem | 1 |
| container (snapshot) | wordpress/after-change-to-dhcp | Auto repaired | filesystem | 1 |
| container (snapshot) | wordpress/after-imagemagick-bcmath-install | | filesystem | 1 |
| container (snapshot) | wordpress/after-imagemagick-bcmath-install | Auto repaired | filesystem | 1 |
| container (snapshot) | wordpress/after-moving-www-over | | filesystem | 1 |
| container (snapshot) | wordpress/after-moving-www-over | Auto repaired | filesystem | 1 |
| container (snapshot) | wordpress/bash | | filesystem | 1 |
lxd sql global "select * from storage_volumes WHERE name LIKE 'wordpress/%' ORDER BY name;"
+------+--------------------------------------------+-----------------+---------+------+-------------+------------+--------------+----------------------+
| id | name | storage_pool_id | node_id | type | description | project_id | content_type | creation_date |
+------+--------------------------------------------+-----------------+---------+------+-------------+------------+--------------+----------------------+
| 1099 | wordpress/after-2018-foss4g-moved | 1 | 1 | 0 | | 1 | 0 | 0001-01-01T00:00:00Z |
| 1097 | wordpress/after-change-to-dhcp | 1 | 1 | 0 | | 1 | 0 | 0001-01-01T00:00:00Z |
| 1104 | wordpress/after-imagemagick-bcmath-install | 1 | 1 | 0 | | 1 | 0 | 0001-01-01T00:00:00Z |
| 1100 | wordpress/after-moving-www-over | 1 | 1 | 0 | | 1 | 0 | 0001-01-01T00:00:00Z |
+------+--------------------------------------------+-----------------+---------+------+-------------+------------+--------------+----------------------+
lxd sql global "select * from storage_volumes_all WHERE name LIKE 'wordpress/%' ORDER BY name;"
+-------+--------------------------------------------+-----------------+---------+------+---------------+------------+--------------+-------------------------------+
| id | name | storage_pool_id | node_id | type | description | project_id | content_type | creation_date |
+-------+--------------------------------------------+-----------------+---------+------+---------------+------------+--------------+-------------------------------+
| 1099 | wordpress/after-2018-foss4g-moved | 1 | 1 | 0 | | 1 | 0 | 0001-01-01T00:00:00Z |
| 21827 | wordpress/after-2018-foss4g-moved | 1 | 1 | 0 | Auto repaired | 1 | 0 | 0001-01-01T00:00:00Z |
| 1097 | wordpress/after-change-to-dhcp | 1 | 1 | 0 | | 1 | 0 | 0001-01-01T00:00:00Z |
| 21826 | wordpress/after-change-to-dhcp | 1 | 1 | 0 | Auto repaired | 1 | 0 | 0001-01-01T00:00:00Z |
| 1104 | wordpress/after-imagemagick-bcmath-install | 1 | 1 | 0 | | 1 | 0 | 0001-01-01T00:00:00Z |
| 21829 | wordpress/after-imagemagick-bcmath-install | 1 | 1 | 0 | Auto repaired | 1 | 0 | 0001-01-01T00:00:00Z |
| 1100 | wordpress/after-moving-www-over | 1 | 1 | 0 | | 1 | 0 | 0001-01-01T00:00:00Z |
| 21828 | wordpress/after-moving-www-over | 1 | 1 | 0 | Auto repaired | 1 | 0 | 0001-01-01T00:00:00Z |
| 26602 | wordpress/bash | 1 | 1 | 0 | | 1 | 0 | 2023-02-17T16:40:11.86741912Z |
+-------+--------------------------------------------+-----------------+---------+------+---------------+------------+--------------+-------------------------------+