# Failed upgrade from 1.20.5 -\> 1.21.0 **URL:** \ **Category:** Install/Maintain/Configure\ **Created:** [November 17, 2023, 1:27pm UTC](https://forum.gitea.com/t/failed-upgrade-from-1-20-5-1-21-0/8151 "2023-11-17T13:27:42Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![cbrake](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.gitea.com/cbrake/32/4809_2.png) [@cbrake](https://forum.gitea.com/u/cbrake)\ **Post date:** [November 17, 2023, 1:27pm UTC](https://forum.gitea.com/t/failed-upgrade-from-1-20-5-1-21-0/8151/1 "2023-11-17T13:27:42Z")
I tried to upgrade my instance from 1.20.5 → 1.21.0 and am getting the following: ```auto 2023/11/17 13:24:16 cmd/web.go:194:serveInstalled() [I] PING DATABASE sqlite3 2023/11/17 13:24:16 ...ations/migrations.go:641:Migrate() [I] Migration[263]: Add git_size and lfs_size columns to repository table 2023/11/17 13:24:16 routers/common/db.go:36:InitDBEngine() [E] ORM engine initialization attempt #1/10 failed. Error: migrate: migration[263]: Add git_size and lfs_size columns to repository table failed: NOT NULL constraint failed: repository.git_size 2023/11/17 13:24:16 routers/common/db.go:37:InitDBEngine() [I] Backing off for 3 seconds 2023/11/17 13:24:19 routers/common/db.go:30:InitDBEngine() [I] ORM engine initialization attempt #2/10... 2023/11/17 13:24:19 cmd/web.go:194:serveInstalled() [I] PING DATABASE sqlite3 2023/11/17 13:24:19 ...ations/migrations.go:641:Migrate() [I] Migration[263]: Add git_size and lfs_size columns to repository table 2023/11/17 13:24:19 routers/common/db.go:36:InitDBEngine() [E] ORM engine initialization attempt #2/10 failed. Error: migrate: migration[263]: Add git_size and lfs_size columns to repository table failed: NOT NULL constraint failed: repository.git_size 2023/11/17 13:24:19 routers/common/db.go:37:InitDBEngine() [I] Backing off for 3 seconds 2023/11/17 13:24:22 routers/common/db.go:30:InitDBEngine() [I] ORM engine initialization attempt #3/10... 2023/11/17 13:24:22 cmd/web.go:194:serveInstalled() [I] PING DATABASE sqlite3 2023/11/17 13:24:22 ...ations/migrations.go:641:Migrate() [I] Migration[263]: Add git_size and lfs_size columns to repository table 2023/11/17 13:24:22 routers/common/db.go:36:InitDBEngine() [E] ORM engine initialization attempt #3/10 failed. Error: migrate: migration[263]: Add git_size and lfs_size columns to repository table failed: NOT NULL constraint failed: repository.git_size 2023/11/17 13:24:22 routers/common/db.go:37:InitDBEngine() [I] Backing off for 3 seconds 2023/11/17 13:24:25 routers/common/db.go:30:InitDBEngine() [I] ORM engine initialization attempt #4/10... 2023/11/17 13:24:25 cmd/web.go:194:serveInstalled() [I] PING DATABASE sqlite3 2023/11/17 13:24:25 ...ations/migrations.go:641:Migrate() [I] Migration[263]: Add git_size and lfs_size columns to repository table 2023/11/17 13:24:25 routers/common/db.go:36:InitDBEngine() [E] ORM engine initialization attempt #4/10 failed. Error: migrate: migration[263]: Add git_size and lfs_size columns to repository table failed: NOT NULL constraint failed: repository.git_size 2023/11/17 13:24:25 routers/common/db.go:37:InitDBEngine() [I] Backing off for 3 seconds 2023/11/17 13:24:26 ...eful/manager_unix.go:198:handleSignals() [W] PID 12297. Received SIGTERM. Shutting down... 2023/11/17 13:24:26 .../graceful/manager.go:168:doHammerTime() [W] Setting Hammer condition 2023/11/17 13:24:27 .../graceful/manager.go:184:doTerminate() [W] Terminating 2023/11/17 13:24:27 ...eful/manager_unix.go:208:handleSignals() [W] PID: 12297. Background context for manager closed - context canceled - Shutting down... 2023/11/17 13:24:28 routers/init.go:69:mustInitCtx() [F] code.gitea.io/gitea/routers/common.InitDBEngine(ctx) failed: Aborted due to shutdown: in retry ORM engine initialization ``` Any thoughts on this issue? ---
**Author:** ![eeyrjmr](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.gitea.com/eeyrjmr/32/1095_2.png) [@eeyrjmr](https://forum.gitea.com/u/eeyrjmr)\ **Post date:** [November 17, 2023, 5:55pm UTC](https://forum.gitea.com/t/failed-upgrade-from-1-20-5-1-21-0/8151/2 "2023-11-17T17:55:43Z")
Does 1.20.5 still run? If so my advice would be to use **gitea doctor** (1.20.5 binary) on thee setup and allow it to repair aspects of the db as well as structure **gitea doctor --all --fix** I have gotten into the habit of always running this prior to upgrade “just in case” ---
**Author:** ![cbrake](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.gitea.com/cbrake/32/4809_2.png) [@cbrake](https://forum.gitea.com/u/cbrake)\ **Post date:** [December 4, 2023, 9:02pm UTC](https://forum.gitea.com/t/failed-upgrade-from-1-20-5-1-21-0/8151/3 "2023-12-04T21:02:46Z")
Yes, I reverted back to 1.20.5, restored a snapshot of the db before upgrade, and it is running fine. Thanks for the doctor idea – will try that. ---
**Author:** ![cbrake](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.gitea.com/cbrake/32/4809_2.png) [@cbrake](https://forum.gitea.com/u/cbrake)\ **Post date:** [December 11, 2023, 5:01pm UTC](https://forum.gitea.com/t/failed-upgrade-from-1-20-5-1-21-0/8151/4 "2023-12-11T17:01:39Z")
I ran `gitea doctor --all --fix` with v1.20.5 and there is one error: ```auto [10] Check consistency of database - [E] Error: no such table: branch whilst counting Branches without existing repository ERROR ``` Then I tried to run 1.21.1: ```auto 2023/12/11 16:25:13 ...ations/migrations.go:641:Migrate() [I] Migration[260]: Drop custom_labels column of action_runner table 2023/12/11 16:25:13 ...ations/migrations.go:641:Migrate() [I] Migration[261]: Add variable table 2023/12/11 16:25:13 ...ations/migrations.go:641:Migrate() [I] Migration[262]: Add TriggerEvent to action_run table 2023/12/11 16:25:13 ...ations/migrations.go:641:Migrate() [I] Migration[263]: Add git_size and lfs_size columns to repository table 2023/12/11 16:25:13 routers/common/db.go:36:InitDBEngine() [E] ORM engine initialization attempt #1/10 failed. Error: migrate: migration[263]: Add git_size and lfs_size columns to repository table failed: NOT NULL constraint failed: repository.git_size 2023/12/11 16:25:13 routers/common/db.go:37:InitDBEngine() [I] Backing off for 3 seconds 2023/12/11 16:25:16 routers/common/db.go:30:InitDBEngine() [I] ORM engine initialization attempt #2/10... 2023/12/11 16:25:16 cmd/web.go:194:serveInstalled() [I] PING DATABASE sqlite3 2023/12/11 16:25:16 ...ations/migrations.go:641:Migrate() [I] Migration[263]: Add git_size and lfs_size columns to repository table 2023/12/11 16:25:16 routers/common/db.go:36:InitDBEngine() [E] ORM engine initialization attempt #2/10 failed. Error: migrate: migration[263]: Add git_size and lfs_size columns to repository table failed: NOT NULL constraint failed: repository.git_size 2023/12/11 16:25:16 routers/common/db.go:37:InitDBEngine() [I] Backing off for 3 seconds ``` I can’t run gitea doctor with 1.21 as the DB has not been migrated yet. So I then ran a dump and restored the db back into sqlite db and got the following during sqlite3 restore: ```auto ... Error: near line 31356: NOT NULL constraint failed: repository.size Error: near line 31358: NOT NULL constraint failed: repository.size Error: near line 31359: NOT NULL constraint failed: repository.size Error: near line 36256: Expression tree is too large (maximum depth 1000) ... (lots of above) Error: near line 36257: Expression tree is too large (maximum depth 1000) ``` (the sqlite3 restore took a long time …) 1.21.1 one now starts, but when I try to log in, I get: Failed authentication attempt for … from … user does not exist I’ve been upgrading a Gitea release pretty much every release for years with no problems. This is the first problem I’ve had … ---
**Author:** ![cbrake](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.gitea.com/cbrake/32/4809_2.png) [@cbrake](https://forum.gitea.com/u/cbrake)\ **Post date:** [December 11, 2023, 5:13pm UTC](https://forum.gitea.com/t/failed-upgrade-from-1-20-5-1-21-0/8151/5 "2023-12-11T17:13:07Z")
It is interesting that Forgejo upgraded my instance just fine … ![image](https://us1.discourse-cdn.com/flex020/uploads/gitea/original/2X/6/6788469cdb96dcb3dacd851562ad0f5821218f19.png) ---
**Author:** ![jolheiser](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.gitea.com/jolheiser/32/4807_2.png) [@jolheiser](https://forum.gitea.com/u/jolheiser)\ **Post date:** [December 11, 2023, 5:19pm UTC](https://forum.gitea.com/t/failed-upgrade-from-1-20-5-1-21-0/8151/6 "2023-12-11T17:19:50Z")
This was fixed by [handle repository.size column being NULL in migration v263 by thenaterhood · Pull Request #28336 · go-gitea/gitea · GitHub](https://github.com/go-gitea/gitea/pull/28336) The reason it is fixed in Forgejo is because they have a released version with the fix in it and we are currently waiting on a few backports. [1.21.2 changelog by techknowlogick · Pull Request #28387 · go-gitea/gitea · GitHub](https://github.com/go-gitea/gitea/pull/28387) ---
**Author:** ![cbrake](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.gitea.com/cbrake/32/4809_2.png) [@cbrake](https://forum.gitea.com/u/cbrake)\ **Post date:** [December 15, 2023, 1:08pm UTC](https://forum.gitea.com/t/failed-upgrade-from-1-20-5-1-21-0/8151/7 "2023-12-15T13:08:17Z")
Gitea upgrade to 1.21.2 worked – thanks! ---
**Author:** ![lunny](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.gitea.com/lunny/32/4701_2.png) [@lunny](https://forum.gitea.com/u/lunny)\ **Post date:** [December 18, 2023, 2:40pm UTC](https://forum.gitea.com/t/failed-upgrade-from-1-20-5-1-21-0/8151/8 "2023-12-18T14:40:13Z")