# Failed upgrade from 1.20.5 -\> 1.21.0

**URL:** <https://forum.gitea.com/t/failed-upgrade-from-1-20-5-1-21-0/8151>\
**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:** 1\
**Showing post:** 4

<div class="post-metadata">

**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")

</div>

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 …

---

_[View the full topic](https://forum.gitea.com/t/failed-upgrade-from-1-20-5-1-21-0/8151)._