[SAC] [OSGeo] #2976: Fix up Gitea database
OSGeo
trac_osgeo at osgeo.org
Tue Aug 29 06:20:46 PDT 2023
#2976: Fix up Gitea database
---------------------------+-----------------------
Reporter: strk | Owner: sac@…
Type: task | Status: new
Priority: normal | Milestone: Unplanned
Component: Systems Admin | Keywords:
---------------------------+-----------------------
Looking at /var/log/gitea/gitea.log we seem to have some out-of-date
database structure.
Examples:
```
2023/08/29 06:12:10 cmd/web.go:175:serveInstalled() [W] Table webhook
Column is_system_webhook db nullable is false, struct nullable is true
2023/08/29 06:12:10 cmd/web.go:175:serveInstalled() [W] Table hook_task
column id db type is SERIAL, struct type is BIGSERIAL
2023/08/29 06:12:10 cmd/web.go:175:serveInstalled() [W] Table hook_task
has column repo_id but struct has not related field
2023/08/29 06:12:10 cmd/web.go:175:serveInstalled() [W] Table review
column type db type is VARCHAR(255), struct type is INTEGER
```
There might be a missing upgrade procedure step to be performed (maybe on
staging first)
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2976>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.
More information about the Sac
mailing list