Unable to migrate from version 1.7.1 to version 1.8.0-rc1 Docker #3071

Closed
opened 2025-11-02 04:59:47 -06:00 by GiteaMirror · 3 comments
Owner

Originally created by @theobolo on GitHub (Mar 19, 2019).

  • 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
    • SQLite
  • Can you reproduce the bug at https://try.gitea.io:
    • Yes (provide example URL)
    • 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

Originally created by @theobolo on GitHub (Mar 19, 2019). - 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
GiteaMirror added the type/bug label 2025-11-02 04:59:47 -06:00
Author
Owner

@lunny commented on GitHub (Mar 20, 2019):

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.

@lunny commented on GitHub (Mar 20, 2019): 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.
Author
Owner

@jolheiser commented on GitHub (Mar 26, 2019):

Should this be closed per #6387?

@jolheiser commented on GitHub (Mar 26, 2019): Should this be closed per #6387?
Author
Owner

@zeripath commented on GitHub (Mar 26, 2019):

Yes I think this is fixed.

@zeripath commented on GitHub (Mar 26, 2019): Yes I think this is fixed.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/gitea#3071