Gitea: Unable to migrate from version 1.7.1 to version 1.8.0-rc1 Docker

[theobolo]

• Gitea version (or commit ref): Docker Image : 1.8 / latest / 1.8.0-rc1
• Git version: 2.18.1
• Operating system: Kubernetes 1.12.5 / Ubuntu 18.02
• Database (use [x]):
  
  
  
  • [ ] PostgreSQL
  
  
  • [ ] MySQL
  
  
  • [ ] MSSQL
  
  
  • [x] SQLite
  
  
• Can you reproduce the bug at https://try.gitea.io:
  
  
  
  • [ ] Yes (provide example URL)
  
  
  • [x] No
  
  
  • [ ] Not relevant
  
  

Description

Hello guys, i'm trying to update my Dockerized Gitea from 1.7.1 to 1.8 and i'm facing a SQL Migration issue during startup :

2019/03/19 16:03:58 [T] AppPath: /app/gitea/gitea
2019/03/19 16:03:58 [T] AppWorkPath: /app/gitea
2019/03/19 16:03:58 [T] Custom path: /data/gitea
2019/03/19 16:03:58 [T] Log path: /data/gitea/log
2019/03/19 16:03:58 [I] Gitea v3934d9c built with go1.12.1 : bindata, sqlite, sqlite_unlock_notify
2019/03/19 16:03:58 [I] Log Mode: File(Debug)
2019/03/19 16:03:58 [I] Log Mode: Console(Debug)
2019/03/19 16:03:58 [I] XORM Log Mode: File(Debug)
2019/03/19 16:03:58 [I] XORM Log Mode: Console(Debug)
2019/03/19 16:03:58 [I] Cache Service Enabled
2019/03/19 16:03:58 [I] Session Service Enabled
2019/03/19 16:03:58 [W] Notify Mail Service: Mail Service is not enabled
2019/03/19 16:03:58 [I] Beginning ORM engine initialization.
2019/03/19 16:03:58 [I] ORM engine initialization attempt #1/10...
2019/03/19 16:03:58 [I] PING DATABASE sqlite3
2019/03/19 16:03:58 [I] [SQL] SELECT name FROM sqlite_master WHERE type='table' and name = ? []interface {}{"version"}
2019/03/19 16:03:58 [I] [SQL] SELECT name FROM sqlite_master WHERE type='table' and name = ? and ((sql like '%`id`%') or (sql like '%[id]%')) [version]
2019/03/19 16:03:58 [I] [SQL] SELECT name FROM sqlite_master WHERE type='table' and name = ? and ((sql like '%`version`%') or (sql like '%[version]%')) [version]
2019/03/19 16:03:58 [I] Migration: hot fix for wrong release sha1 on release table
2019/03/19 16:03:58 [I] [SQL] SELECT `id`, `version` FROM `version` WHERE `id`=? LIMIT 1 []interface {}{1}
2019/03/19 16:03:58 [I] [SQL] BEGIN TRANSACTION
2019/03/19 16:03:58 [I] [SQL] SELECT `id`, `repo_id`, `sha1`, `tag_name` FROM `release` WHERE (is_tag=?) ORDER BY `id` ASC LIMIT 100 []interface {}{false}
2019/03/19 16:03:58 [I] [SQL] SELECT `id`, `owner_id`, `lower_name`, `name`, `description`, `website`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `is_private`, `is_empty`, `is_archived`, `is_mirror`, `is_fork`, `fork_id`, `size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `created_unix`, `updated_unix` FROM `repository` WHERE `id`=? LIMIT 1 []interface {}{6}
2019/03/19 16:03:58 [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{2}
2019/03/19 16:03:58 [I] [SQL] UPDATE `release` SET `sha1` = ? WHERE `id`=? []interface {}{"23c53a91e836bc7e7c91bbb5c1545ceedf390938", 3}
2019/03/19 16:03:58 [I] [SQL] SELECT `id`, `owner_id`, `lower_name`, `name`, `description`, `website`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `is_private`, `is_empty`, `is_archived`, `is_mirror`, `is_fork`, `fork_id`, `size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `created_unix`, `updated_unix` FROM `repository` WHERE `id`=? LIMIT 1 []interface {}{28}
2019/03/19 16:03:58 [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{2}
2019/03/19 16:03:58 [I] [SQL] UPDATE `release` SET `sha1` = ? WHERE `id`=? []interface {}{"6c406fb2418ae8e4f5898306f0c1b1e99e5a448c", 4}
2019/03/19 16:03:58 [I] [SQL] SELECT `id`, `owner_id`, `lower_name`, `name`, `description`, `website`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `is_private`, `is_empty`, `is_archived`, `is_mirror`, `is_fork`, `fork_id`, `size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `created_unix`, `updated_unix` FROM `repository` WHERE `id`=? LIMIT 1 []interface {}{19}
2019/03/19 16:03:58 [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{2}
2019/03/19 16:03:58 [I] [SQL] UPDATE `release` SET `sha1` = ? WHERE `id`=? []interface {}{"682e67cc983d9b15def6fa098a3b3fbbbd7f592a", 6}
2019/03/19 16:03:58 [I] [SQL] SELECT `id`, `owner_id`, `lower_name`, `name`, `description`, `website`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `is_private`, `is_empty`, `is_archived`, `is_mirror`, `is_fork`, `fork_id`, `size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `created_unix`, `updated_unix` FROM `repository` WHERE `id`=? LIMIT 1 []interface {}{7}
2019/03/19 16:03:58 [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{2}
2019/03/19 16:03:58 [I] [SQL] ROLL BACK
2019/03/19 16:03:58 [D] ORM engine initialization attempt #1/10 failed. Error: migrate: do migrate: object does not exist [id: v1.4.5, rel_path: ]
2019/03/19 16:03:58 [I] Backing off for 3 seconds
2019/03/19 16:04:01 [I] ORM engine initialization attempt #2/10...
2019/03/19 16:04:01 [I] PING DATABASE sqlite3
2019/03/19 16:04:01 [I] [SQL] SELECT name FROM sqlite_master WHERE type='table' and name = ? []interface {}{"version"}
2019/03/19 16:04:01 [I] [SQL] SELECT name FROM sqlite_master WHERE type='table' and name = ? and ((sql like '%`id`%') or (sql like '%[id]%')) [version]
2019/03/19 16:04:01 [I] [SQL] SELECT name FROM sqlite_master WHERE type='table' and name = ? and ((sql like '%`version`%') or (sql like '%[version]%')) [version]
2019/03/19 16:04:01 [I] [SQL] SELECT `id`, `version` FROM `version` WHERE `id`=? LIMIT 1 []interface {}{1}
2019/03/19 16:04:01 [I] Migration: hot fix for wrong release sha1 on release table
2019/03/19 16:04:01 [I] [SQL] BEGIN TRANSACTION
2019/03/19 16:04:01 [I] [SQL] SELECT `id`, `repo_id`, `sha1`, `tag_name` FROM `release` WHERE (is_tag=?) ORDER BY `id` ASC LIMIT 100 []interface {}{false}
2019/03/19 16:04:01 [I] [SQL] SELECT `id`, `owner_id`, `lower_name`, `name`, `description`, `website`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `is_private`, `is_empty`, `is_archived`, `is_mirror`, `is_fork`, `fork_id`, `size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `created_unix`, `updated_unix` FROM `repository` WHERE `id`=? LIMIT 1 []interface {}{6}
2019/03/19 16:04:01 [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{2}
2019/03/19 16:04:01 [I] [SQL] UPDATE `release` SET `sha1` = ? WHERE `id`=? []interface {}{"23c53a91e836bc7e7c91bbb5c1545ceedf390938", 3}
2019/03/19 16:04:01 [I] [SQL] SELECT `id`, `owner_id`, `lower_name`, `name`, `description`, `website`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `is_private`, `is_empty`, `is_archived`, `is_mirror`, `is_fork`, `fork_id`, `size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `created_unix`, `updated_unix` FROM `repository` WHERE `id`=? LIMIT 1 []interface {}{28}
2019/03/19 16:04:01 [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{2}
2019/03/19 16:04:01 [I] [SQL] UPDATE `release` SET `sha1` = ? WHERE `id`=? []interface {}{"6c406fb2418ae8e4f5898306f0c1b1e99e5a448c", 4}
2019/03/19 16:04:01 [I] [SQL] SELECT `id`, `owner_id`, `lower_name`, `name`, `description`, `website`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `is_private`, `is_empty`, `is_archived`, `is_mirror`, `is_fork`, `fork_id`, `size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `created_unix`, `updated_unix` FROM `repository` WHERE `id`=? LIMIT 1 []interface {}{19}
2019/03/19 16:04:01 [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{2}
2019/03/19 16:04:01 [I] [SQL] UPDATE `release` SET `sha1` = ? WHERE `id`=? []interface {}{"682e67cc983d9b15def6fa098a3b3fbbbd7f592a", 6}
2019/03/19 16:04:01 [I] [SQL] SELECT `id`, `owner_id`, `lower_name`, `name`, `description`, `website`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `is_private`, `is_empty`, `is_archived`, `is_mirror`, `is_fork`, `fork_id`, `size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `created_unix`, `updated_unix` FROM `repository` WHERE `id`=? LIMIT 1 []interface {}{7}
2019/03/19 16:04:01 [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{2}
2019/03/19 16:04:01 [I] [SQL] ROLL BACK
2019/03/19 16:04:01 [D] ORM engine initialization attempt #2/10 failed. Error: migrate: do migrate: object does not exist [id: v1.4.5, rel_path: ]
2019/03/19 16:04:01 [I] Backing off for 3 seconds
2019/03/19 16:04:04 [I] ORM engine initialization attempt #3/10...
2019/03/19 16:04:04 [I] PING DATABASE sqlite3
2019/03/19 16:04:04 [I] [SQL] SELECT name FROM sqlite_master WHERE type='table' and name = ? []interface {}{"version"}
2019/03/19 16:04:04 [I] [SQL] SELECT name FROM sqlite_master WHERE type='table' and name = ? and ((sql like '%`id`%') or (sql like '%[id]%')) [version]
2019/03/19 16:04:04 [I] [SQL] SELECT name FROM sqlite_master WHERE type='table' and name = ? and ((sql like '%`version`%') or (sql like '%[version]%')) [version]
2019/03/19 16:04:04 [I] [SQL] SELECT `id`, `version` FROM `version` WHERE `id`=? LIMIT 1 []interface {}{1}
2019/03/19 16:04:04 [I] [SQL] BEGIN TRANSACTION
2019/03/19 16:04:04 [I] [SQL] SELECT `id`, `repo_id`, `sha1`, `tag_name` FROM `release` WHERE (is_tag=?) ORDER BY `id` ASC LIMIT 100 []interface {}{false}
2019/03/19 16:04:04 [I] Migration: hot fix for wrong release sha1 on release table
2019/03/19 16:04:04 [I] [SQL] SELECT `id`, `owner_id`, `lower_name`, `name`, `description`, `website`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `is_private`, `is_empty`, `is_archived`, `is_mirror`, `is_fork`, `fork_id`, `size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `created_unix`, `updated_unix` FROM `repository` WHERE `id`=? LIMIT 1 []interface {}{6}
2019/03/19 16:04:04 [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{2}
2019/03/19 16:04:04 [I] [SQL] UPDATE `release` SET `sha1` = ? WHERE `id`=? []interface {}{"23c53a91e836bc7e7c91bbb5c1545ceedf390938", 3}
2019/03/19 16:04:04 [I] [SQL] SELECT `id`, `owner_id`, `lower_name`, `name`, `description`, `website`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `is_private`, `is_empty`, `is_archived`, `is_mirror`, `is_fork`, `fork_id`, `size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `created_unix`, `updated_unix` FROM `repository` WHERE `id`=? LIMIT 1 []interface {}{28}
2019/03/19 16:04:04 [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{2}
2019/03/19 16:04:04 [I] [SQL] UPDATE `release` SET `sha1` = ? WHERE `id`=? []interface {}{"6c406fb2418ae8e4f5898306f0c1b1e99e5a448c", 4}
2019/03/19 16:04:04 [I] [SQL] SELECT `id`, `owner_id`, `lower_name`, `name`, `description`, `website`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `is_private`, `is_empty`, `is_archived`, `is_mirror`, `is_fork`, `fork_id`, `size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `created_unix`, `updated_unix` FROM `repository` WHERE `id`=? LIMIT 1 []interface {}{19}
2019/03/19 16:04:04 [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{2}
2019/03/19 16:04:04 [I] [SQL] UPDATE `release` SET `sha1` = ? WHERE `id`=? []interface {}{"682e67cc983d9b15def6fa098a3b3fbbbd7f592a", 6}
2019/03/19 16:04:04 [I] [SQL] SELECT `id`, `owner_id`, `lower_name`, `name`, `description`, `website`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `is_private`, `is_empty`, `is_archived`, `is_mirror`, `is_fork`, `fork_id`, `size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `created_unix`, `updated_unix` FROM `repository` WHERE `id`=? LIMIT 1 []interface {}{7}
2019/03/19 16:04:04 [I] [SQL] SELECT `name` FROM `user` WHERE `id`=? LIMIT 1 []interface {}{2}
2019/03/19 16:04:04 [I] [SQL] ROLL BACK
2019/03/19 16:04:04 [D] ORM engine initialization attempt #3/10 failed. Error: migrate: do migrate: object does not exist [id: v1.4.5, rel_path: ]
2019/03/19 16:04:04 [I] Backing off for 3 seconds

I'm running Gitea on Kubernetes using a Statefulset and a ConfigMap with official Gitea images,
Here is my config, mounted as a ConfigMap to the Pod :

kind: ConfigMap
apiVersion: v1
metadata:
  name: gitea-config
  namespace: fleeters-hosting
data:
  app.ini: |-
    APP_NAME = Gitea: Git with a cup of tea
    RUN_MODE = prod

    [repository]
    ROOT = /data/git/repositories

    [repository.upload]
    TEMP_PATH = /data/gitea/uploads

    [server]
    APP_DATA_PATH = /data/gitea
    SSH_DOMAIN    = XXXXXXXXXXXXXXXX
    HTTP_PORT     = 3000
    ROOT_URL      = XXXXXXXXXXX
    DISABLE_SSH   = false
    SSH_PORT      = 22
    OFFLINE_MODE  = false
    LFS_CONTENT_PATH = /data/git/lfs

    [database]
    HOST     = mysql:3306
    PATH     = /data/gitea/gitea.db
    DB_TYPE  = sqlite3
    NAME     = gogs
    USER     = root
    PASSWD   =
    SSL_MODE = disable

    [indexer]
    ISSUE_INDEXER_PATH = /data/gitea/indexers/issues.bleve

    [session]
    PROVIDER_CONFIG = /data/gitea/sessions
    PROVIDER        = file

    [picture]
    AVATAR_UPLOAD_PATH      = /data/gitea/avatars
    DISABLE_GRAVATAR        = false
    ENABLE_FEDERATED_AVATAR = true

    [attachment]
    PATH = /data/gitea/attachments

    [log]
    ROOT_PATH = /data/gitea/log
    MODE      = file,console
    LEVEL     = Debug

    [service]
    REGISTER_EMAIL_CONFIRM = false
    ENABLE_NOTIFY_MAIL     = true
    DISABLE_REGISTRATION   = true
    ENABLE_CAPTCHA         = false
    REQUIRE_SIGNIN_VIEW    = true

    [security]
    INSTALL_LOCK   = true
    SECRET_KEY     = XXXXXXXXXXXXXXXXX
    INTERNAL_TOKEN = XXXXXXXXXXXXXXXXXXXXXXXX

    [oauth2]
    JWT_SECRET = XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Do you have any solution or workaround ?

Thanks

[lunny]

That's because some of your repositories has unsynced tags on database and git data. The solution is to delete the records on the table release manually. And I think I will change the migrations to ignore the unsynced tags.

[jolheiser]

Should this be closed per #6387?

[zeripath]

Yes I think this is fixed.