#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 <Gter - OSGeo;
OSGeo committee and general foundation issue tracker.
#2976: Fix up Gitea database
--------------------+------------------------
Reporter: strk | Owner: strk
Type: task | Status: new
Priority: normal | Milestone: Unplanned
Component: Gitea | Resolution:
Keywords: |
--------------------+------------------------
Changes (by strk):
* owner: sac@… => strk
* component: Systems Admin => Gitea
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2976#comment:1>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.
#2976: Fix up Gitea database
--------------------+------------------------
Reporter: strk | Owner: strk
Type: task | Status: new
Priority: normal | Milestone: Unplanned
Component: Gitea | Resolution:
Keywords: |
--------------------+------------------------
Comment (by strk):
Upstream issue: https://github.com/go-gitea/gitea/issues/22275
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2976#comment:2>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.
#2976: Fix up Gitea database
--------------------+------------------------
Reporter: strk | Owner: strk
Type: task | Status: new
Priority: normal | Milestone: Unplanned
Component: Gitea | Resolution:
Keywords: |
--------------------+------------------------
Description changed by strk:
Old description:
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)
New description:
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#comment:3>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.
#2976: Fix up Gitea database
--------------------+---------------------------------------
Reporter: strk | Owner: strk
Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2023-I
Component: Gitea | Resolution:
Keywords: |
--------------------+---------------------------------------
Changes (by robe):
* milestone: Unplanned => Sysadmin Contract 2023-I
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2976#comment:4>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.
#2976: Fix up Gitea database
--------------------+---------------------------------------
Reporter: strk | Owner: strk
Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2023-I
Component: Gitea | Resolution:
Keywords: |
--------------------+---------------------------------------
Comment (by robe):
@strk do you think we should wait for fix upstream or do a manual fix.
Seems like the issue is harmless, just annoying to see in the logs.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2976#comment:5>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.
#2976: Fix up Gitea database
--------------------+---------------------------------------
Reporter: strk | Owner: strk
Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2023-I
Component: Gitea | Resolution:
Keywords: |
--------------------+---------------------------------------
Comment (by strk):
I'd wait for an upstream fix (or work on an upstream fix)
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2976#comment:6>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.