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

[OSGeo]

#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>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.