[SAC] [OSGeo] #2700: Error on backup of weblate

[OSGeo]

#2700: Error on backup of weblate
---------------------------+------------------------
 Reporter:  robe           |       Owner:  robe
     Type:  task           |      Status:  closed
 Priority:  normal         |   Milestone:  Unplanned
Component:  Systems Admin  |  Resolution:  fixed
 Keywords:                 |
---------------------------+------------------------
Changes (by robe):

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


Comment:

 Fix as noted in above ticket is to increment the sequence

 First ssh into osgeo9 host

 {{{
 # fails with above error
 lxc snapshot weblate
 }}}



 {{{
 lxd sql global "SELECT max(id) FROM storage_volumes_snapshots;"

 -- last snapshot id is 390

 lxd sql global "SELECT seq FROM sqlite_sequence WHERE name =
 'storage_volumes';"

 -- last sequence is 182, change to 390 (the last snapshot id)
 lxd sql global "UPDATE sqlite_sequence SET seq = 390 WHERE name =
 'storage_volumes'"
 }}}


 Now doing a snapshot should work

 {{{
 lxc snapshot weblate
 }}}

-- 
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2700#comment:1>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.