#3381: Upgrade woodie to 3.6.0
-----------------------------+-----------------------
Reporter: robe | Owner: robe
Type: task | Status: new
Priority: normal | Milestone: Unplanned
Component: SysAdmin/Woodie | Keywords:
-----------------------------+-----------------------
Currently at 2.8.0 which is EOL
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/3381>
OSGeo <Gter - OSGeo;
OSGeo committee and general foundation issue tracker.
#3381: Upgrade woodie to 3.6.0
-----------------------------+------------------------
Reporter: robe | Owner: robe
Type: task | Status: new
Priority: normal | Milestone: Unplanned
Component: SysAdmin/Woodie | Resolution:
Keywords: |
-----------------------------+------------------------
Comment (by robe):
I tried installing 3.6.0 but ran into issues becuase of the permissioning
changes in woodpecker to rootless images - https://woodpecker-
ci.org/migrations#rootless-images.
get this error:
{{{
error running server error="can't setup store: could not migrate datastor
}}}
I did change the permissions as discussed but that didn't help. It only
behaves correctly if I let it create the file.
I'm thinking of just moving it to postgres from sqlite, probably about
time anyway. the db is already 9GB in size.
and setting permissions of the sqlite db to what is mentioned here
--
Ticket URL: <#3381 (Upgrade woodie to 3.6.0) – OSGeo;
OSGeo <Gter - OSGeo;
OSGeo committee and general foundation issue tracker.
#3381: Upgrade woodie to 3.6.0
-----------------------------+------------------------
Reporter: robe | Owner: robe
Type: task | Status: closed
Priority: normal | Milestone: Unplanned
Component: SysAdmin/Woodie | Resolution: fixed
Keywords: |
-----------------------------+------------------------
Changes (by robe):
* resolution: => fixed
* status: new => closed
Comment:
Okay I couldn't figure out the permissions, but I flipped it from sqlite
to PostgreSQL 17.
I had to use pgloader to first copy the sqlite to postgresql db and then
allowed woodpecker to populate an empty database with 2.8.3 structure, and
then a load script. I'll record these scripts in ansible, and then maybe
strk can work on it later to fully make it ansiblish.
I am thinking of not running the server under docker, as it seems like
kinda pointless since it's just a go executable. But will deal with that
later once I've confirmed everything is working fine.
As a side note part of the issues we were having with the log files being
missing I think was because the SQLite db was corrupt. I did use the
corrupt version of the db in pgloader, and pgloader seemed to just skip
over the corrupt parts when loading.
--
Ticket URL: <#3381 (Upgrade woodie to 3.6.0) – OSGeo;
OSGeo <Gter - OSGeo;
OSGeo committee and general foundation issue tracker.