snapshots failing on osgeo7

[robe]

As mentioned in my other ticket. Other issue with osgeo7 is the lxd snapshots process is failing.

For completeness the error before the fix was

UNIQUE constraint failed: storage_volumes_snapshots.id lxc snapshot

Sounds like the same issue as described here

​https://github.com/lxc/lxd/issues/7024

So I'm going to try the fix mentioned in that thread

[robe]

okay I applied the fix as described in that ticket and seems to have fixed the snapshot error

-- returned 4360
lxd sql global "SELECT MAX(id) FROM storage_volumes_all LIMIT 1;"

lxd sql global "UPDATE sqlite_sequence SET seq = 4360 WHERE name = 'storage_volumes'"