Gitea upgrade from 1.14.1 to 1.17.1: migration broken

dachary · September 6, 2022, 10:34pm

Failed upgrade from 1.14.1 to 1.17.1 due to `Rename Task errors to message failed`

opened 06:02AM - 06 Sep 22 UTC

closed 08:36AM - 06 Sep 22 UTC

kind/bug reviewed/duplicate

### Description Hi! I have gitea 1.14.1 at Debian 10 server. I want upgrade it…, but I can't. After backup I replace the binary file of gitea 1.14.1 by file version 1.17.1. Program not crashed but webserver is not starting. In logs I see something like this: ``` routers/common/db.go:33:InitDBEngine() [E] ORM engine initialization attempt #1/10 failed. Error: migrate: migration[184]: Rename Task errors to message failed: error in table task after rename: duplicate column name: message routers/init.go:66:mustInitCtx() [F] code.gitea.io/gitea/routers/common.InitDBEngine(ctx) failed: migrate: migration[184]: Rename Task errors to message failed: error in table task after rename: duplicate column name: message ``` Few months ago I tried upgrade to 1.16.x but also some goes wrong and I restore my old 1.14.1 version. At that point in time, the update was not necessary, so I didn't pay much attention to this issue and OK. Now I see at my errors at upgrading to 1.17.1 and thinking about my old wrong try to upgrade to 1.16.x: I not prepare backup at that round, just upgraded binary file and replace it by old 1.14.1 after some issue. Database (SQLITE3) was patched by 1.16.x and for starting 1.14.1 with this I manually downgrade changed version of database. Maybe some database structures other than version was updated by 1.16.x but 1.14.1 works fine with it, but now 1.17.1 binary file can't upgrade my database file and I can't upgrade my gitea... So now it very needed because team starting using mobile app and this required latest backend version for fully experience... Please told me somethink what can help me: what I shoud do? I need upgrade with 1) saving old user accounts; 2) saving user repositories. I ready to try anything. ### Gitea Version 1.14.1 ### Can you reproduce the bug on the Gitea demo site? No ### Log Gist _No response_ ### Screenshots _No response_ ### Git Version _No response_ ### Operating System Debian ### How are you running Gitea? systemd service ### Database SQLite

dachary · September 6, 2022, 10:34pm

Solution:

github.com/go-gitea/gitea

Unable to upgrade Gitea from 1.14.7 to 1.15.2

opened 09:06PM - 10 Sep 21 UTC

closed 04:15PM - 12 Sep 21 UTC

NiklasRosenstein

- Gitea version (or commit ref): 1.14.7 - Git version: - Operating system: Debian 9 - Database (use `[x]`): - [ ] PostgreSQL - [ ] MySQL - [ ] MSSQL - [x] SQLite - Can you reproduce the bug at https://try.gitea.io: - [ ] Yes (provide example URL) - [x] No - Log gist: ## Description I want to upgrade my Gitea instance deployed via Docker to 1.15.2. But the server won't start up and actually dies after a minute or so. ``` $ docker-compose up Starting gitea_server_1 ... done Attaching to gitea_server_1 server_1 | Server listening on :: port 22. server_1 | Server listening on 0.0.0.0 port 22. server_1 | 2021/09/10 20:50:12 cmd/web.go:102:runWeb() [I] Starting Gitea on PID: 14 server_1 | 2021/09/10 20:50:12 cmd/web.go:146:runWeb() [I] Global init server_1 | 2021/09/10 20:50:12 routers/init.go:74:GlobalInit() [I] Git Version: 2.30.2, Wire Protocol Version 2 Enabledserver_1 | 2021/09/10 20:50:12 routers/init.go:77:GlobalInit() [I] AppPath: /app/gitea/gitea server_1 | 2021/09/10 20:50:12 routers/init.go:78:GlobalInit() [I] AppWorkPath: /app/gitea server_1 | 2021/09/10 20:50:12 routers/init.go:79:GlobalInit() [I] Custom path: /data/gitea server_1 | 2021/09/10 20:50:12 routers/init.go:80:GlobalInit() [I] Log path: /data/gitea/log server_1 | 2021/09/10 20:50:12 routers/init.go:81:GlobalInit() [I] Run Mode: Prod server_1 | Received signal 15; terminating. ``` My docker-compose file: ```yml version: '2' networks: gitea: external: false services: server: image: gitea/gitea:latest environment: - USER_UID=998 # git - USER_GID=1007 # git restart: always networks: - gitea volumes: - ./gitea:/data ports: - "127.0.0.1:8701:3000" - "127.0.0.1:8702:22" ``` However if I go back to `gitea/gitea:1.14.7` Gitea won't start up because the schema version has been increased. Luckily I can change the schema version back via sqlite3 and it works again. 😌 I have tried to incrementally take versions `1.15.0`, `1.15.1` and `1.15.2` but all have the same issue. What could be going wrong here?