LXD 4.22 Unable to create snapshots

snapshot creation and copying both fails with UNIQUE constraint failed: storage_volumes_snapshots.id
How to recover from this situation?
Kindly help.
This happens only in one of the container hosts.
Thank you
Sincerely
MohananPG, NITK Surathkal, India

$ snap list
Name Version Rev Tracking Publisher Notes
core 16-2.52.1 11993 latest/stable canonical✓ core
core18 20211215 2284 latest/stable canonical✓ base
core20 20211129 1270 latest/stable canonical✓ base
lxd 4.22 22248 latest/stable canonical✓ -

$ lxc snapshot pgmohanan
Error: Failed creating instance snapshot record “snap1”: Failed initialising instance: Failed creating storage record for snapshot: Insert volume snapshot: UNIQUE constraint failed: storage_volumes_snapshots.id
$ lxd sql global “SELECT * FROM storage_volumes_snapshots;”
±-----±------------------±------------------------------±------------±---------------------+
| id | storage_volume_id | name | description | expiry_date |
±-----±------------------±------------------------------±------------±---------------------+
| 56 | 5 | snap0 | | 0001-01-01T00:00:00Z |
| 57 | 35 | snap0 | | 0001-01-01T00:00:00Z |
| 60 | 59 | active-active | | 0001-01-01T00:00:00Z |
| 119 | 118 | just-after-copy | | 0001-01-01T00:00:00Z |
| 126 | 20 | snap0 | | 0001-01-01T00:00:00Z |
| 128 | 59 | snap0 | | 0001-01-01T00:00:00Z |
| 401 | 400 | snap0 | | 0001-01-01T00:00:00Z |
| 402 | 400 | snap1 | | 0001-01-01T00:00:00Z |
| 403 | 400 | configd-done-by-akshay | | 0001-01-01T00:00:00Z |
| 404 | 400 | akshay-final-tweaks-done | | 0001-01-01T00:00:00Z |
| 441 | 14 | snap0 | | 0001-01-01T00:00:00Z |
| 586 | 59 | LB1-at-ddos | | 0001-01-01T00:00:00Z |
| 591 | 59 | LB-withRL-1 | | 0001-01-01T00:00:00Z |
| 1587 | 1585 | snap0 | | 0001-01-01T00:00:00Z |
| 1663 | 1585 | snap1 | | 0001-01-01T00:00:00Z |
| 1664 | 1588 | snap0 | | 0001-01-01T00:00:00Z |
| 1665 | 1589 | snap0 | | 0001-01-01T00:00:00Z |
| 1718 | 1666 | snap0 | | 0001-01-01T00:00:00Z |
| 1818 | 1817 | one | | 0001-01-01T00:00:00Z |
| 1819 | 1817 | two | | 0001-01-01T00:00:00Z |
| 1820 | 1817 | three | | 0001-01-01T00:00:00Z |
| 1821 | 1817 | four | | 0001-01-01T00:00:00Z |
| 1822 | 1817 | five | | 0001-01-01T00:00:00Z |
| 1834 | 1833 | first | | 0001-01-01T00:00:00Z |
| 2493 | 572 | snap-Tuesday | | 0001-01-01T00:00:00Z |
| 2498 | 572 | snap-Wednesday | | 0001-01-01T00:00:00Z |
| 2503 | 572 | snap-Thursday | | 0001-01-01T00:00:00Z |
| 2508 | 572 | snap-Friday | | 0001-01-01T00:00:00Z |
| 2514 | 572 | snap-Saturday | | 0001-01-01T00:00:00Z |
| 2519 | 572 | snap-Sunday | | 0001-01-01T00:00:00Z |
| 2524 | 572 | snap-Monday | | 0001-01-01T00:00:00Z |
| 2526 | 59 | lxd-restart | | 0001-01-01T00:00:00Z |
| 2527 | 5 | lxd-restart | | 0001-01-01T00:00:00Z |
| 2528 | 35 | lxd-restart | | 0001-01-01T00:00:00Z |
| 2529 | 400 | lxd-restart | | 0001-01-01T00:00:00Z |
| 2530 | 118 | lxd-restart | | 0001-01-01T00:00:00Z |
| 2819 | 118 | ldap_18oct21 | | 0001-01-01T00:00:00Z |
| 3156 | 118 | emergency-rollback-dec23-2021 | | 0001-01-01T00:00:00Z |
| 3159 | 3157 | lam1 | | 0001-01-01T00:00:00Z |
| 3160 | 3157 | lam2 | | 0001-01-01T00:00:00Z |
| 3161 | 3157 | lam3 | | 0001-01-01T00:00:00Z |
| 3167 | 3157 | lam4 | | 0001-01-01T00:00:00Z |
| 3200 | 118 | ldap-30dec21 | | 0001-01-01T00:00:00Z |
| 3268 | 59 | snap-Thursday | | 0001-01-01T00:00:00Z |
| 3269 | 5 | snap-Thursday | | 0001-01-01T00:00:00Z |
| 3270 | 35 | snap-Thursday | | 0001-01-01T00:00:00Z |
| 3271 | 400 | snap-Thursday | | 0001-01-01T00:00:00Z |
| 3272 | 118 | snap-Thursday | | 0001-01-01T00:00:00Z |
| 3273 | 59 | snap-Friday | | 0001-01-01T00:00:00Z |
| 3274 | 5 | snap-Friday | | 0001-01-01T00:00:00Z |
| 3275 | 35 | snap-Friday | | 0001-01-01T00:00:00Z |
| 3276 | 400 | snap-Friday | | 0001-01-01T00:00:00Z |
| 3277 | 118 | snap-Friday | | 0001-01-01T00:00:00Z |
| 3279 | 59 | snap-Saturday | | 0001-01-01T00:00:00Z |
| 3280 | 5 | snap-Saturday | | 0001-01-01T00:00:00Z |
| 3281 | 35 | snap-Saturday | | 0001-01-01T00:00:00Z |
| 3282 | 400 | snap-Saturday | | 0001-01-01T00:00:00Z |
| 3283 | 118 | snap-Saturday | | 0001-01-01T00:00:00Z |
| 3284 | 59 | snap-Sunday | | 0001-01-01T00:00:00Z |
| 3285 | 5 | snap-Sunday | | 0001-01-01T00:00:00Z |
| 3286 | 35 | snap-Sunday | | 0001-01-01T00:00:00Z |
| 3287 | 400 | snap-Sunday | | 0001-01-01T00:00:00Z |
| 3288 | 118 | snap-Sunday | | 0001-01-01T00:00:00Z |
| 3289 | 59 | snap-Monday | | 0001-01-01T00:00:00Z |
| 3290 | 5 | snap-Monday | | 0001-01-01T00:00:00Z |
| 3291 | 35 | snap-Monday | | 0001-01-01T00:00:00Z |
| 3292 | 400 | snap-Monday | | 0001-01-01T00:00:00Z |
| 3293 | 118 | snap-Monday | | 0001-01-01T00:00:00Z |
±-----±------------------±------------------------------±------------±---------------------+

$ lxd sql global “SELECT * FROM storage_volumes_snapshots;”
±-----±------------------±------------------------------±------------±---------------------+
| id | storage_volume_id | name | description | expiry_date |
±-----±------------------±------------------------------±------------±---------------------+
| 56 | 5 | snap0 | | 0001-01-01T00:00:00Z |
| 57 | 35 | snap0 | | 0001-01-01T00:00:00Z |
| 60 | 59 | active-active | | 0001-01-01T00:00:00Z |
| 119 | 118 | just-after-copy | | 0001-01-01T00:00:00Z |
| 126 | 20 | snap0 | | 0001-01-01T00:00:00Z |
| 128 | 59 | snap0 | | 0001-01-01T00:00:00Z |
| 401 | 400 | snap0 | | 0001-01-01T00:00:00Z |
| 402 | 400 | snap1 | | 0001-01-01T00:00:00Z |
| 403 | 400 | configd-done-by-akshay | | 0001-01-01T00:00:00Z |
| 404 | 400 | akshay-final-tweaks-done | | 0001-01-01T00:00:00Z |
| 441 | 14 | snap0 | | 0001-01-01T00:00:00Z |
| 586 | 59 | LB1-at-ddos | | 0001-01-01T00:00:00Z |
| 591 | 59 | LB-withRL-1 | | 0001-01-01T00:00:00Z |
| 1587 | 1585 | snap0 | | 0001-01-01T00:00:00Z |
| 1663 | 1585 | snap1 | | 0001-01-01T00:00:00Z |
| 1664 | 1588 | snap0 | | 0001-01-01T00:00:00Z |
| 1665 | 1589 | snap0 | | 0001-01-01T00:00:00Z |
| 1718 | 1666 | snap0 | | 0001-01-01T00:00:00Z |
| 1818 | 1817 | one | | 0001-01-01T00:00:00Z |
| 1819 | 1817 | two | | 0001-01-01T00:00:00Z |
| 1820 | 1817 | three | | 0001-01-01T00:00:00Z |
| 1821 | 1817 | four | | 0001-01-01T00:00:00Z |
| 1822 | 1817 | five | | 0001-01-01T00:00:00Z |
| 1834 | 1833 | first | | 0001-01-01T00:00:00Z |
| 2493 | 572 | snap-Tuesday | | 0001-01-01T00:00:00Z |
| 2498 | 572 | snap-Wednesday | | 0001-01-01T00:00:00Z |
| 2503 | 572 | snap-Thursday | | 0001-01-01T00:00:00Z |
| 2508 | 572 | snap-Friday | | 0001-01-01T00:00:00Z |
| 2514 | 572 | snap-Saturday | | 0001-01-01T00:00:00Z |
| 2519 | 572 | snap-Sunday | | 0001-01-01T00:00:00Z |
| 2524 | 572 | snap-Monday | | 0001-01-01T00:00:00Z |
| 2526 | 59 | lxd-restart | | 0001-01-01T00:00:00Z |
| 2527 | 5 | lxd-restart | | 0001-01-01T00:00:00Z |
| 2528 | 35 | lxd-restart | | 0001-01-01T00:00:00Z |
| 2529 | 400 | lxd-restart | | 0001-01-01T00:00:00Z |
| 2530 | 118 | lxd-restart | | 0001-01-01T00:00:00Z |
| 2819 | 118 | ldap_18oct21 | | 0001-01-01T00:00:00Z |
| 3156 | 118 | emergency-rollback-dec23-2021 | | 0001-01-01T00:00:00Z |
| 3159 | 3157 | lam1 | | 0001-01-01T00:00:00Z |
| 3160 | 3157 | lam2 | | 0001-01-01T00:00:00Z |
| 3161 | 3157 | lam3 | | 0001-01-01T00:00:00Z |
| 3167 | 3157 | lam4 | | 0001-01-01T00:00:00Z |
| 3200 | 118 | ldap-30dec21 | | 0001-01-01T00:00:00Z |
| 3268 | 59 | snap-Thursday | | 0001-01-01T00:00:00Z |
| 3269 | 5 | snap-Thursday | | 0001-01-01T00:00:00Z |
| 3270 | 35 | snap-Thursday | | 0001-01-01T00:00:00Z |
| 3271 | 400 | snap-Thursday | | 0001-01-01T00:00:00Z |
| 3272 | 118 | snap-Thursday | | 0001-01-01T00:00:00Z |
| 3273 | 59 | snap-Friday | | 0001-01-01T00:00:00Z |
| 3274 | 5 | snap-Friday | | 0001-01-01T00:00:00Z |
| 3275 | 35 | snap-Friday | | 0001-01-01T00:00:00Z |
| 3276 | 400 | snap-Friday | | 0001-01-01T00:00:00Z |
| 3277 | 118 | snap-Friday | | 0001-01-01T00:00:00Z |
| 3279 | 59 | snap-Saturday | | 0001-01-01T00:00:00Z |
| 3280 | 5 | snap-Saturday | | 0001-01-01T00:00:00Z |
| 3281 | 35 | snap-Saturday | | 0001-01-01T00:00:00Z |
| 3282 | 400 | snap-Saturday | | 0001-01-01T00:00:00Z |
| 3283 | 118 | snap-Saturday | | 0001-01-01T00:00:00Z |
| 3284 | 59 | snap-Sunday | | 0001-01-01T00:00:00Z |
| 3285 | 5 | snap-Sunday | | 0001-01-01T00:00:00Z |
| 3286 | 35 | snap-Sunday | | 0001-01-01T00:00:00Z |
| 3287 | 400 | snap-Sunday | | 0001-01-01T00:00:00Z |
| 3288 | 118 | snap-Sunday | | 0001-01-01T00:00:00Z |
| 3289 | 59 | snap-Monday | | 0001-01-01T00:00:00Z |
| 3290 | 5 | snap-Monday | | 0001-01-01T00:00:00Z |
| 3291 | 35 | snap-Monday | | 0001-01-01T00:00:00Z |
| 3292 | 400 | snap-Monday | | 0001-01-01T00:00:00Z |
| 3293 | 118 | snap-Monday | | 0001-01-01T00:00:00Z |
±-----±------------------±------------------------------±------------±---------------------+

$ lxd sql global “SELECT * FROM storage_volumes_all;”
±-----±-----------------------------------------------------------------±----------------±--------±-----±------------±-----------±-------------+
| id | name | storage_pool_id | node_id | type | description | project_id | content_type |
±-----±-----------------------------------------------------------------±----------------±--------±-----±------------±-----------±-------------+
| 1 | c1 | 1 | 1 | 0 | | 1 | 0 |
| 3 | cache-fornutanix-atVaayu | 1 | 1 | 0 | | 1 | 0 |
| 5 | secondary-dhcp-live | 1 | 1 | 0 | | 1 | 0 |
| 6 | secondary-dhcp-live/after-moved | 1 | 1 | 0 | | 1 | 0 |
| 7 | c1/snap0 | 1 | 1 | 0 | | 1 | 0 |
| 8 | zammad-tickets | 1 | 1 | 0 | | 1 | 0 |
| 9 | zammad-tickets/fresh-install | 1 | 1 | 0 | | 1 | 0 |
| 10 | zammad-tickets/first-ticket | 1 | 1 | 0 | | 1 | 0 |
| 12 | it-asset | 1 | 1 | 0 | | 1 | 0 |
| 14 | zammad-new | 1 | 1 | 0 | | 1 | 0 |
| 15 | c1/snap1 | 1 | 1 | 0 | | 1 | 0 |
| 16 | ralph-test | 1 | 1 | 0 | | 1 | 0 |
| 17 | ralph-test/just-installed-with-demodata | 1 | 1 | 0 | | 1 | 0 |
| 20 | pgmohanan | 1 | 1 | 0 | | 1 | 0 |
| 33 | old-rkini-delete/snap0 | 1 | 1 | 0 | | 1 | 0 |
| 35 | Naamak-DNS-Live | 1 | 1 | 0 | | 1 | 0 |
| 40 | 9e7158fc0683d41f7f692ce8b17598716d7eee925c6a593432df59488bf4131f | 1 | 1 | 1 | | 1 | 0 |
| 41 | iet-BhawanaRudraIT | 1 | 1 | 0 | | 1 | 0 |
| 42 | imagineer-Event9march20 | 1 | 1 | 0 | | 1 | 0 |
| 43 | rameshkini-live | 1 | 1 | 0 | | 1 | 0 |
| 56 | secondary-dhcp-live/snap0 | 1 | 1 | 0 | | 1 | 0 |
| 57 | Naamak-DNS-Live/snap0 | 1 | 1 | 0 | | 1 | 0 |
| 59 | loadbalancer-live-1 | 1 | 1 | 0 | | 1 | 0 |
| 60 | loadbalancer-live-1/active-active | 1 | 1 | 0 | | 1 | 0 |
| 118 | ldap-nitk-live | 1 | 1 | 0 | | 1 | 0 |
| 119 | ldap-nitk-live/just-after-copy | 1 | 1 | 0 | | 1 | 0 |
| 126 | pgmohanan/snap0 | 1 | 1 | 0 | | 1 | 0 |
| 128 | loadbalancer-live-1/snap0 | 1 | 1 | 0 | | 1 | 0 |
| 400 | iris-authenticator-live | 1 | 1 | 0 | | 1 | 0 |
| 401 | iris-authenticator-live/snap0 | 1 | 1 | 0 | | 1 | 0 |
| 402 | iris-authenticator-live/snap1 | 1 | 1 | 0 | | 1 | 0 |
| 403 | iris-authenticator-live/configd-done-by-akshay | 1 | 1 | 0 | | 1 | 0 |
| 404 | iris-authenticator-live/akshay-final-tweaks-done | 1 | 1 | 0 | | 1 | 0 |
| 441 | zammad-new/snap0 | 1 | 1 | 0 | | 1 | 0 |
| 442 | osticket-live | 1 | 1 | 0 | | 1 | 0 |
| 572 | external-dns-b-live | 1 | 1 | 0 | | 1 | 0 |
| 586 | loadbalancer-live-1/LB1-at-ddos | 1 | 1 | 0 | | 1 | 0 |
| 591 | loadbalancer-live-1/LB-withRL-1 | 1 | 1 | 0 | | 1 | 0 |
| 1585 | veesix1 | 1 | 1 | 0 | | 1 | 0 |
| 1587 | veesix1/snap0 | 1 | 1 | 0 | | 1 | 0 |
| 1588 | veesix2 | 1 | 1 | 0 | | 1 | 0 |
| 1589 | veesix3 | 1 | 1 | 0 | | 1 | 0 |
| 1663 | veesix1/snap1 | 1 | 1 | 0 | | 1 | 0 |
| 1664 | veesix2/snap0 | 1 | 1 | 0 | | 1 | 0 |
| 1665 | veesix3/snap0 | 1 | 1 | 0 | | 1 | 0 |
| 1666 | veesix4 | 1 | 1 | 0 | | 1 | 0 |
| 1718 | veesix4/snap0 | 1 | 1 | 0 | | 1 | 0 |
| 1719 | pgm-ipt1 | 1 | 1 | 0 | | 1 | 0 |
| 1817 | idoit | 1 | 1 | 0 | | 1 | 0 |
| 1818 | idoit/one | 1 | 1 | 0 | | 1 | 0 |
| 1819 | idoit/two | 1 | 1 | 0 | | 1 | 0 |
| 1820 | idoit/three | 1 | 1 | 0 | | 1 | 0 |
| 1821 | idoit/four | 1 | 1 | 0 | | 1 | 0 |
| 1822 | idoit/five | 1 | 1 | 0 | | 1 | 0 |
| 1833 | minisipserver | 1 | 1 | 0 | | 1 | 0 |
| 1834 | minisipserver/first | 1 | 1 | 0 | | 1 | 0 |
| 2493 | external-dns-b-live/snap-Tuesday | 1 | 1 | 0 | | 1 | 0 |
| 2498 | external-dns-b-live/snap-Wednesday | 1 | 1 | 0 | | 1 | 0 |
| 2503 | external-dns-b-live/snap-Thursday | 1 | 1 | 0 | | 1 | 0 |
| 2508 | external-dns-b-live/snap-Friday | 1 | 1 | 0 | | 1 | 0 |
| 2514 | external-dns-b-live/snap-Saturday | 1 | 1 | 0 | | 1 | 0 |
| 2519 | external-dns-b-live/snap-Sunday | 1 | 1 | 0 | | 1 | 0 |
| 2524 | external-dns-b-live/snap-Monday | 1 | 1 | 0 | | 1 | 0 |
| 2526 | loadbalancer-live-1/lxd-restart | 1 | 1 | 0 | | 1 | 0 |
| 2527 | secondary-dhcp-live/lxd-restart | 1 | 1 | 0 | | 1 | 0 |
| 2528 | Naamak-DNS-Live/lxd-restart | 1 | 1 | 0 | | 1 | 0 |
| 2529 | iris-authenticator-live/lxd-restart | 1 | 1 | 0 | | 1 | 0 |
| 2530 | ldap-nitk-live/lxd-restart | 1 | 1 | 0 | | 1 | 0 |
| 2819 | ldap-nitk-live/ldap_18oct21 | 1 | 1 | 0 | | 1 | 0 |
| 2998 | mx1-le-new-certchain-22Nov21 | 1 | 1 | 0 | | 1 | 0 |
| 3014 | dlink-wifi-vc-backup25Nov21 | 1 | 1 | 0 | | 1 | 0 |
| 3156 | ldap-nitk-live/emergency-rollback-dec23-2021 | 1 | 1 | 0 | | 1 | 0 |
| 3157 | lam-ldap-testing | 1 | 1 | 0 | | 1 | 0 |
| 3159 | lam-ldap-testing/lam1 | 1 | 1 | 0 | | 1 | 0 |
| 3160 | lam-ldap-testing/lam2 | 1 | 1 | 0 | | 1 | 0 |
| 3161 | lam-ldap-testing/lam3 | 1 | 1 | 0 | | 1 | 0 |
| 3167 | lam-ldap-testing/lam4 | 1 | 1 | 0 | | 1 | 0 |
| 3200 | ldap-nitk-live/ldap-30dec21 | 1 | 1 | 0 | | 1 | 0 |
| 3268 | loadbalancer-live-1/snap-Thursday | 1 | 1 | 0 | | 1 | 0 |
| 3269 | secondary-dhcp-live/snap-Thursday | 1 | 1 | 0 | | 1 | 0 |
| 3270 | Naamak-DNS-Live/snap-Thursday | 1 | 1 | 0 | | 1 | 0 |
| 3271 | iris-authenticator-live/snap-Thursday | 1 | 1 | 0 | | 1 | 0 |
| 3272 | ldap-nitk-live/snap-Thursday | 1 | 1 | 0 | | 1 | 0 |
| 3273 | loadbalancer-live-1/snap-Friday | 1 | 1 | 0 | | 1 | 0 |
| 3274 | secondary-dhcp-live/snap-Friday | 1 | 1 | 0 | | 1 | 0 |
| 3275 | Naamak-DNS-Live/snap-Friday | 1 | 1 | 0 | | 1 | 0 |
| 3276 | iris-authenticator-live/snap-Friday | 1 | 1 | 0 | | 1 | 0 |
| 3277 | ldap-nitk-live/snap-Friday | 1 | 1 | 0 | | 1 | 0 |
| 3278 | sumam-david-website | 1 | 1 | 0 | | 1 | 0 |
| 3279 | 44650bc10c092105a5695a240307f518b9f5a6f3a6c8094f340d663331191e48 | 1 | 1 | 1 | | 1 | 0 |
| 3279 | loadbalancer-live-1/snap-Saturday | 1 | 1 | 0 | | 1 | 0 |
| 3280 | secondary-dhcp-live/snap-Saturday | 1 | 1 | 0 | | 1 | 0 |
| 3281 | Naamak-DNS-Live/snap-Saturday | 1 | 1 | 0 | | 1 | 0 |
| 3282 | iris-authenticator-live/snap-Saturday | 1 | 1 | 0 | | 1 | 0 |
| 3283 | ldap-nitk-live/snap-Saturday | 1 | 1 | 0 | | 1 | 0 |
| 3284 | loadbalancer-live-1/snap-Sunday | 1 | 1 | 0 | | 1 | 0 |
| 3285 | secondary-dhcp-live/snap-Sunday | 1 | 1 | 0 | | 1 | 0 |
| 3286 | Naamak-DNS-Live/snap-Sunday | 1 | 1 | 0 | | 1 | 0 |
| 3287 | iris-authenticator-live/snap-Sunday | 1 | 1 | 0 | | 1 | 0 |
| 3288 | ldap-nitk-live/snap-Sunday | 1 | 1 | 0 | | 1 | 0 |
| 3289 | loadbalancer-live-1/snap-Monday | 1 | 1 | 0 | | 1 | 0 |
| 3290 | secondary-dhcp-live/snap-Monday | 1 | 1 | 0 | | 1 | 0 |
| 3291 | Naamak-DNS-Live/snap-Monday | 1 | 1 | 0 | | 1 | 0 |
| 3292 | iris-authenticator-live/snap-Monday | 1 | 1 | 0 | | 1 | 0 |
| 3293 | ldap-nitk-live/snap-Monday | 1 | 1 | 0 | | 1 | 0 |
±-----±-----------------------------------------------------------------±----------------±--------±-----±------------±-----------±-------------+

$ lxd sql global “SELECT seq FROM sqlite_sequence WHERE name = ‘storage_volumes’ LIMIT 1;”
±-----+
| seq |
±-----+
| 3280 |
±-----+

$ lxd sql global “SELECT MAX(id) FROM storage_volumes_all LIMIT 1;”
±--------+
| MAX(id) |
±--------+
| 3293 |
±--------+
$ lxd sql global “UPDATE sqlite_sequence SET seq = 3293 WHERE name = ‘storage_volumes’”
Rows affected: 1
Now lxc snapshot pgmohanan works!
Just FYI
Looks like it is again related to https://github.com/lxc/lxd/issues/7024
Apparently resolved!

This should fix it

The fix will be rolling out to all users within the next 24-48h, we’re going to be doing a faster than usual phased roll out due to the impact.

If you need to manually recover before that, you can run:

lxd sql global "UPDATE sqlite_sequence SET seq = (SELECT max(max(coalesce(storage_volumes.id, 0)), max(coalesce(storage_volumes_snapshots.id, 0))) FROM storage_volumes, storage_volumes_snapshots) WHERE name='storage_volumes';" 

This is the same fix as will be run with the update we’re rolling out.

1 Like