Opened 10 months ago

Last modified 6 months ago

#2976 new task

Fix up Gitea database

Reported by: strk Owned by: strk
Priority: normal Milestone: Sysadmin Contract 2024-I
Component: SysAdmin/Gitea Keywords:
Cc:

Description (last modified by strk)

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)

Change History (7)

comment:1 by strk, 10 months ago

Component: Systems Admin → Gitea
Owner: changed from sac@… to strk

comment:3 by strk, 10 months ago

Description: modified (diff)

comment:4 by robe, 10 months ago

Milestone: Unplanned → Sysadmin Contract 2023-I

comment:5 by robe, 10 months ago

@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.

comment:6 by strk, 9 months ago

I'd wait for an upstream fix (or work on an upstream fix)

comment:7 by robe, 6 months ago

Milestone: Sysadmin Contract 2023-I → Sysadmin Contract 2024-I

Moving my prior still open items to the next proposed Milestone

Note: See TracTickets for help on using tickets.