Skip to content

Re-run already-finished migrations after data recovery failed to start #7125

@yuukiyuuna

Description

@yuukiyuuna

Gogs version

Gogs 0.13.0+dev

Git version

bash-5.1# git --version
git version 2.32.3

Operating system

raspberry arm64

Database

mariadb:10.9-rc

Describe the bug

The webpage can be accessed without restarting the container after the data reply is successful
Once the container is restarted, the log keeps reporting errors and the webpage cannot be opened.

To reproduce

root@raspberrypi:/data/gogs/git# docker images
REPOSITORY TAG IMAGE ID CREATED SIZE
mariadb 10.9-rc 920b638c403a 2 days ago 302MB
gogs/gogs latest ff0531b8c349 3 days ago 92.2MB

Data recovery success log:
Extracting file...gogs-repositories/hanchenglin/v2rayn.wiki.git/objects/bc Extracting file...gogs-repositories/hanchenglin/v2rayn.wiki.git/objects/bc/d4508aa68e51ac8ab91ed252a8fcc25d432823 Extracting file...gogs-repositories/hanchenglin/v2rayn.wiki.git/objects/9a Extracting file...gogs-repositories/hanchenglin/v2rayn.wiki.git/objects/9a/1ad316fb45dd61a926575ae85d3fbe08261a48 Extracting file...gogs-repositories/hanchenglin/v2rayn.wiki.git/objects/9a/82250eef4550e7955dcb5d621e6c804f1a8303 Extracting file...gogs-repositories/hanchenglin/v2rayn.wiki.git/objects/32 Extracting file...gogs-repositories/hanchenglin/v2rayn.wiki.git/objects/32/a0ead7601f6032027bccb1225f47489eb3d7f6 Extracting file...gogs-repositories/hanchenglin/v2rayn.wiki.git/objects/1a Extracting file...gogs-repositories/hanchenglin/v2rayn.wiki.git/objects/1a/f4a421d871752843f6b6afe24da60c69d70285 Extracting file...gogs-repositories/hanchenglin/v2rayn.wiki.git/objects/c7 Extracting file...gogs-repositories/hanchenglin/v2rayn.wiki.git/objects/c7/9126b84bd2561d76767ee39c3537a48a3595ab Extracting file...gogs-repositories/hanchenglin/v2rayn.wiki.git/objects/17 Extracting file...gogs-repositories/hanchenglin/v2rayn.wiki.git/objects/17/76737177b8d04bc34ff438a2e6a446968266fe Extracting file...gogs-repositories/hanchenglin/v2rayn.wiki.git/objects/78 Extracting file...gogs-repositories/hanchenglin/v2rayn.wiki.git/objects/78/747ae6a232087900821880a10b84a9a151c7ce Extracting file...gogs-repositories/hanchenglin/v2rayn.wiki.git/objects/e4 Extracting file...gogs-repositories/hanchenglin/v2rayn.wiki.git/objects/e4/2dcf28f36f3cce80fe82d2affe78925cc6e720 Extracting file...gogs-repositories/hanchenglin/v2rayn.wiki.git/objects/b0 Extracting file...gogs-repositories/hanchenglin/v2rayn.wiki.git/objects/b0/7c651a1ee5b876503edf8a359bdd3bdb569b06 Extracting file...gogs-repositories/hanchenglin/v2rayn.wiki.git/objects/c1 Extracting file...gogs-repositories/hanchenglin/v2rayn.wiki.git/objects/c1/7fef2fdbf3c08c978c0a929062bf4038b1afc4 Extracting file...gogs-repositories/hanchenglin/v2rayn.wiki.git/objects/09 Extracting file...gogs-repositories/hanchenglin/v2rayn.wiki.git/objects/09/6d3f6e5353e630db1098dbde46cefeefda3a99 Extracting file...gogs-repositories/hanchenglin/v2rayn.wiki.git/objects/6b Extracting file...gogs-repositories/hanchenglin/v2rayn.wiki.git/objects/6b/721dc080ec260f403a3b851573ea7fb649a194 Extracting file...gogs-repositories/hanchenglin/v2rayn.wiki.git/objects/53 Extracting file...gogs-repositories/hanchenglin/v2rayn.wiki.git/objects/53/c86f03eb97b88370eee8a9d03d3c872a5adbfd Extracting file...gogs-repositories/hanchenglin/v2rayn.wiki.git/objects/eb Extracting file...gogs-repositories/hanchenglin/v2rayn.wiki.git/objects/eb/70e90933b1420e313f31b9d33adbfd7c10fb21 Extracting file...gogs-repositories/hanchenglin/v2rayn.wiki.git/objects/d7 Extracting file...gogs-repositories/hanchenglin/v2rayn.wiki.git/objects/d7/f28da804183d88662e77f150bec9c351a60457 Extracting file...gogs-repositories/hanchenglin/v2rayn.wiki.git/HEAD Extracting file...gogs-repositories/hanchenglin/v2rayn.wiki.git/branches 2022/08/05 16:30:57 [ INFO] Restore succeed!

After restarting the container with the command
docker restart gogs

container logs
`root@raspberrypi:~# docker logs gogs
usermod: no changes
Aug 5 16:18:39 syslogd started: BusyBox v1.33.1
2022/08/05 16:18:39 [ WARN] Custom config "/data/gogs/conf/app.ini" not found. Ignore this warning if you're running for the first time
2022/08/05 16:18:39 [TRACE] Log mode: Console (Trace)
2022/08/05 16:18:39 [ INFO] Gogs 0.13.0+dev
2022/08/05 16:18:39 [TRACE] Work directory: /app/gogs
2022/08/05 16:18:39 [TRACE] Custom path: /data/gogs
2022/08/05 16:18:39 [TRACE] Custom config: /data/gogs/conf/app.ini
2022/08/05 16:18:39 [TRACE] Log path: /app/gogs/log
2022/08/05 16:18:39 [TRACE] Build time: 2022-08-02 07:29:27 UTC
2022/08/05 16:18:39 [TRACE] Build commit: cfa5ddb
2022/08/05 16:18:39 [ INFO] Run mode: Development
2022/08/05 16:18:39 [ INFO] Available on http://localhost:3000/
Aug 5 08:18:39 sshd[61]: Server listening on :: port 22.
Aug 5 08:18:39 sshd[61]: Server listening on 0.0.0.0 port 22.
2022/08/05 16:19:32 [TRACE] Session ID: c114e45745f0b60c
2022/08/05 16:19:32 [TRACE] CSRF Token: fffjIwAJEsFNrv-_Be87FxFmySA6MTY1OTY4NzU3MjY0NDIyNzEwNw
2022/08/05 16:19:32 [TRACE] Session ID: c114e45745f0b60c
2022/08/05 16:19:32 [TRACE] CSRF Token: eIwjVZ-fgrbH6bUhzf6qWtZ4Z486MTY1OTY2OTMzOTEzODc3Njk3Nw
2022/08/05 16:19:32 [TRACE] Template: install
2022/08/05 16:20:11 [TRACE] Session ID: c114e45745f0b60c
2022/08/05 16:20:11 [TRACE] CSRF Token: eIwjVZ-fgrbH6bUhzf6qWtZ4Z486MTY1OTY2OTMzOTEzODc3Njk3Nw
2022/08/05 16:20:14 [TRACE] Log mode: File (Info)
[git-module] [timeout: 1m0s] git version
git version 2.32.3

Aug 5 08:20:31 su[141]: Successful su for git by root
Aug 5 08:20:31 su[141]: pam_unix(su:session): session opened for user git(uid=1000) by (uid=0)
Aug 5 08:31:29 su[141]: pam_unix(su:session): session closed for user git
Aug 5 16:32:02 syslogd exiting
usermod: no changes
Aug 5 16:32:05 syslogd started: BusyBox v1.33.1
Aug 5 08:32:05 sshd[29]: Server listening on :: port 22.
Aug 5 08:32:05 sshd[29]: Server listening on 0.0.0.0 port 22.
2022/08/05 16:32:05 [TRACE] Log mode: File (Info)
2022/08/05 16:32:06 [TRACE] Log mode: File (Info)
2022/08/05 16:32:07 [TRACE] Log mode: File (Info)
2022/08/05 16:32:08 [TRACE] Log mode: File (Info)
2022/08/05 16:32:09 [TRACE] Log mode: File (Info)
2022/08/05 16:32:10 [TRACE] Log mode: File (Info)
2022/08/05 16:32:11 [TRACE] Log mode: File (Info)
2022/08/05 16:32:12 [TRACE] Log mode: File (Info)
2022/08/05 16:32:13 [TRACE] Log mode: File (Info)
2022/08/05 16:32:14 [TRACE] Log mode: File (Info)
2022/08/05 16:32:15 [TRACE] Log mode: File (Info)
2022/08/05 16:32:16 [TRACE] Log mode: File (Info)
2022/08/05 16:32:17 [TRACE] Log mode: File (Info)
2022/08/05 16:32:18 [TRACE] Log mode: File (Info)
2022/08/05 16:32:19 [TRACE] Log mode: File (Info)
2022/08/05 16:32:20 [TRACE] Log mode: File (Info)
2022/08/05 16:32:21 [TRACE] Log mode: File (Info)
2022/08/05 16:32:22 [TRACE] Log mode: File (Info)
2022/08/05 16:32:23 [TRACE] Log mode: File (Info)
2022/08/05 16:32:24 [TRACE] Log mode: File (Info)
2022/08/05 16:32:25 [TRACE] Log mode: File (Info)
2022/08/05 16:32:26 [TRACE] Log mode: File (Info)
`

In-container logs
bash-5.1# tail -f gogs.log 2022/08/05 16:44:29 [FATAL] [...o/gogs/internal/route/install.go:75 GlobalInit()] Failed to initialize ORM engine: migrate: do migrate: add column: Error 1060: Duplicate column name 'sha256' 2022/08/05 16:44:30 [ INFO] Mine Git 0.13.0+dev 2022/08/05 16:44:30 [ INFO] Migration: migrate access tokens to store SHA56 2022/08/05 16:44:30 [FATAL] [...o/gogs/internal/route/install.go:75 GlobalInit()] Failed to initialize ORM engine: migrate: do migrate: add column: Error 1060: Duplicate column name 'sha256' 2022/08/05 16:44:31 [ INFO] Mine Git 0.13.0+dev 2022/08/05 16:44:31 [ INFO] Migration: migrate access tokens to store SHA56 2022/08/05 16:44:31 [FATAL] [...o/gogs/internal/route/install.go:75 GlobalInit()] Failed to initialize ORM engine: migrate: do migrate: add column: Error 1060: Duplicate column name 'sha256' 2022/08/05 16:44:32 [ INFO] Mine Git 0.13.0+dev 2022/08/05 16:44:32 [ INFO] Migration: migrate access tokens to store SHA56 2022/08/05 16:44:32 [FATAL] [...o/gogs/internal/route/install.go:75 GlobalInit()] Failed to initialize ORM engine: migrate: do migrate: add column: Error 1060: Duplicate column name 'sha256' 2022/08/05 16:44:33 [ INFO] Mine Git 0.13.0+dev 2022/08/05 16:44:33 [ INFO] Migration: migrate access tokens to store SHA56 2022/08/05 16:44:33 [FATAL] [...o/gogs/internal/route/install.go:75 GlobalInit()] Failed to initialize ORM engine: migrate: do migrate: add column: Error 1060: Duplicate column name 'sha256' 2022/08/05 16:44:34 [ INFO] Mine Git 0.13.0+dev 2022/08/05 16:44:34 [ INFO] Migration: migrate access tokens to store SHA56 2022/08/05 16:44:34 [FATAL] [...o/gogs/internal/route/install.go:75 GlobalInit()] Failed to initialize ORM engine: migrate: do migrate: add column: Error 1060: Duplicate column name 'sha256' 2022/08/05 16:44:35 [ INFO] Mine Git 0.13.0+dev 2022/08/05 16:44:35 [ INFO] Migration: migrate access tokens to store SHA56 2022/08/05 16:44:35 [FATAL] [...o/gogs/internal/route/install.go:75 GlobalInit()] Failed to initialize ORM engine: migrate: do migrate: add column: Error 1060: Duplicate column name 'sha256' 2022/08/05 16:44:36 [ INFO] Mine Git 0.13.0+dev 2022/08/05 16:44:36 [ INFO] Migration: migrate access tokens to store SHA56 2022/08/05 16:44:36 [FATAL] [...o/gogs/internal/route/install.go:75 GlobalInit()] Failed to initialize ORM engine: migrate: do migrate: add column: Error 1060: Duplicate column name 'sha256' 2022/08/05 16:44:37 [ INFO] Mine Git 0.13.0+dev 2022/08/05 16:44:37 [ INFO] Migration: migrate access tokens to store SHA56 2022/08/05 16:44:37 [FATAL] [...o/gogs/internal/route/install.go:75 GlobalInit()] Failed to initialize ORM engine: migrate: do migrate: add column: Error 1060: Duplicate column name 'sha256' 2022/08/05 16:44:38 [ INFO] Mine Git 0.13.0+dev 2022/08/05 16:44:38 [ INFO] Migration: migrate access tokens to store SHA56 2022/08/05 16:44:38 [FATAL] [...o/gogs/internal/route/install.go:75 GlobalInit()] Failed to initialize ORM engine: migrate: do migrate: add column: Error 1060: Duplicate column name 'sha256' 2022/08/05 16:44:39 [ INFO] Mine Git 0.13.0+dev 2022/08/05 16:44:39 [ INFO] Migration: migrate access tokens to store SHA56 2022/08/05 16:44:39 [FATAL] [...o/gogs/internal/route/install.go:75 GlobalInit()] Failed to initialize ORM engine: migrate: do migrate: add column: Error 1060: Duplicate column name 'sha256' 2022/08/05 16:44:40 [ INFO] Mine Git 0.13.0+dev 2022/08/05 16:44:40 [ INFO] Migration: migrate access tokens to store SHA56 2022/08/05 16:44:40 [FATAL] [...o/gogs/internal/route/install.go:75 GlobalInit()] Failed to initialize ORM engine: migrate: do migrate: add column: Error 1060: Duplicate column name 'sha256' 2022/08/05 16:44:41 [ INFO] Mine Git 0.13.0+dev 2022/08/05 16:44:41 [ INFO] Migration: migrate access tokens to store SHA56 2022/08/05 16:44:41 [FATAL] [...o/gogs/internal/route/install.go:75 GlobalInit()] Failed to initialize ORM engine: migrate: do migrate: add column: Error 1060: Duplicate column name 'sha256' 2022/08/05 16:44:42 [ INFO] Mine Git 0.13.0+dev 2022/08/05 16:44:42 [ INFO] Migration: migrate access tokens to store SHA56 2022/08/05 16:44:42 [FATAL] [...o/gogs/internal/route/install.go:75 GlobalInit()] Failed to initialize ORM engine: migrate: do migrate: add column: Error 1060: Duplicate column name 'sha256' 2022/08/05 16:44:43 [ INFO] Mine Git 0.13.0+dev 2022/08/05 16:44:43 [ INFO] Migration: migrate access tokens to store SHA56 2022/08/05 16:44:43 [FATAL] [...o/gogs/internal/route/install.go:75 GlobalInit()] Failed to initialize ORM engine: migrate: do migrate: add column: Error 1060: Duplicate column name 'sha256' 2022/08/05 16:44:44 [ INFO] Mine Git 0.13.0+dev 2022/08/05 16:44:44 [ INFO] Migration: migrate access tokens to store SHA56 2022/08/05 16:44:44 [FATAL] [...o/gogs/internal/route/install.go:75 GlobalInit()] Failed to initialize ORM engine: migrate: do migrate: add column: Error 1060: Duplicate column name 'sha256' 2022/08/05 16:44:45 [ INFO] Mine Git 0.13.0+dev 2022/08/05 16:44:45 [ INFO] Migration: migrate access tokens to store SHA56 2022/08/05 16:44:45 [FATAL] [...o/gogs/internal/route/install.go:75 GlobalInit()] Failed to initialize ORM engine: migrate: do migrate: add column: Error 1060: Duplicate column name 'sha256' 2022/08/05 16:44:46 [ INFO] Mine Git 0.13.0+dev 2022/08/05 16:44:46 [ INFO] Migration: migrate access tokens to store SHA56 2022/08/05 16:44:46 [FATAL] [...o/gogs/internal/route/install.go:75 GlobalInit()] Failed to initialize ORM engine: migrate: do migrate: add column: Error 1060: Duplicate column name 'sha256' 2022/08/05 16:44:47 [ INFO] Mine Git 0.13.0+dev 2022/08/05 16:44:47 [ INFO] Migration: migrate access tokens to store SHA56 2022/08/05 16:44:47 [FATAL] [...o/gogs/internal/route/install.go:75 GlobalInit()] Failed to initialize ORM engine: migrate: do migrate: add column: Error 1060: Duplicate column name 'sha256' 2022/08/05 16:44:48 [ INFO] Mine Git 0.13.0+dev 2022/08/05 16:44:48 [ INFO] Migration: migrate access tokens to store SHA56 2022/08/05 16:44:48 [FATAL] [...o/gogs/internal/route/install.go:75 GlobalInit()] Failed to initialize ORM engine: migrate: do migrate: add column: Error 1060: Duplicate column name 'sha256' 2022/08/05 16:44:49 [ INFO] Mine Git 0.13.0+dev 2022/08/05 16:44:49 [ INFO] Migration: migrate access tokens to store SHA56 2022/08/05 16:44:49 [FATAL] [...o/gogs/internal/route/install.go:75 GlobalInit()] Failed to initialize ORM engine: migrate: do migrate: add column: Error 1060: Duplicate column name 'sha256' 2022/08/05 16:44:50 [ INFO] Mine Git 0.13.0+dev 2022/08/05 16:44:50 [ INFO] Migration: migrate access tokens to store SHA56 2022/08/05 16:44:50 [FATAL] [...o/gogs/internal/route/install.go:75 GlobalInit()] Failed to initialize ORM engine: migrate: do migrate: add column: Error 1060: Duplicate column name 'sha256' 2022/08/05 16:44:51 [ INFO] Mine Git 0.13.0+dev 2022/08/05 16:44:51 [ INFO] Migration: migrate access tokens to store SHA56 2022/08/05 16:44:51 [FATAL] [...o/gogs/internal/route/install.go:75 GlobalInit()] Failed to initialize ORM engine: migrate: do migrate: add column: Error 1060: Duplicate column name 'sha256'

Expected behavior

anythings all right

Additional context

No response

Code of Conduct

  • I agree to follow this project's Code of Conduct

Metadata

Metadata

Assignees

Labels

💊 bugSomething isn't working

Type

No type

Projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions