[SAC] [OSGeo] #2425: snapshots failing on osgeo7

#2425: snapshots failing on osgeo7
---------------------------+--------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2020-I
Component: Systems Admin | Keywords:
---------------------------+--------------------------------------
As mentioned in my other ticket. Other issue with osgeo7 is the lxd
snapshots process is failing.

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

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2425&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2425: snapshots failing on osgeo7
---------------------------+---------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: closed
Priority: normal | Milestone: Sysadmin Contract 2020-I
Component: Systems Admin | Resolution: fixed
Keywords: |
---------------------------+---------------------------------------
Changes (by robe):

* status: new => closed
* resolution: => fixed

Old description:

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

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

New description:

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

--

Comment:

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'"

}}}

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2425#comment:1&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.