[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