mirror of
https://github.com/go-gitea/gitea.git
synced 2026-03-22 06:24:14 -05:00
Upgrade Failure from v1.13.6 to v1.14.1 #7293
Closed
opened 2025-11-02 07:22:15 -06:00 by GiteaMirror
·
4 comments
No Branch/Tag Specified
main
release/v1.25
release/v1.24
release/v1.23
release/v1.22
release/v1.21
release/v1.20
release/v1.19
release/v1.18
release/v1.17
release/v1.16
release/v1.15
release/v1.14
release/v1.13
release/v1.12
release/v1.11
release/v1.10
release/v1.9
release/v1.8
v1.25.3
v1.25.2
v1.25.1
v1.25.0
v1.24.7
v1.25.0-rc0
v1.26.0-dev
v1.24.6
v1.24.5
v1.24.4
v1.24.3
v1.24.2
v1.24.1
v1.24.0
v1.23.8
v1.24.0-rc0
v1.25.0-dev
v1.23.7
v1.23.6
v1.23.5
v1.23.4
v1.23.3
v1.23.2
v1.23.1
v1.23.0
v1.23.0-rc0
v1.24.0-dev
v1.22.6
v1.22.5
v1.22.4
v1.22.3
v1.22.2
v1.22.1
v1.22.0
v1.23.0-dev
v1.22.0-rc1
v1.21.11
v1.22.0-rc0
v1.21.10
v1.21.9
v1.21.8
v1.21.7
v1.21.6
v1.21.5
v1.21.4
v1.21.3
v1.21.2
v1.20.6
v1.21.1
v1.21.0
v1.21.0-rc2
v1.21.0-rc1
v1.20.5
v1.22.0-dev
v1.21.0-rc0
v1.20.4
v1.20.3
v1.20.2
v1.20.1
v1.20.0
v1.19.4
v1.21.0-dev
v1.20.0-rc2
v1.20.0-rc1
v1.20.0-rc0
v1.19.3
v1.19.2
v1.19.1
v1.19.0
v1.19.0-rc1
v1.20.0-dev
v1.19.0-rc0
v1.18.5
v1.18.4
v1.18.3
v1.18.2
v1.18.1
v1.18.0
v1.17.4
v1.18.0-rc1
v1.19.0-dev
v1.18.0-rc0
v1.17.3
v1.17.2
v1.17.1
v1.17.0
v1.17.0-rc2
v1.16.9
v1.17.0-rc1
v1.18.0-dev
v1.16.8
v1.16.7
v1.16.6
v1.16.5
v1.16.4
v1.16.3
v1.16.2
v1.16.1
v1.16.0
v1.15.11
v1.17.0-dev
v1.16.0-rc1
v1.15.10
v1.15.9
v1.15.8
v1.15.7
v1.15.6
v1.15.5
v1.15.4
v1.15.3
v1.15.2
v1.15.1
v1.14.7
v1.15.0
v1.15.0-rc3
v1.14.6
v1.15.0-rc2
v1.14.5
v1.16.0-dev
v1.15.0-rc1
v1.14.4
v1.14.3
v1.14.2
v1.14.1
v1.14.0
v1.13.7
v1.14.0-rc2
v1.13.6
v1.13.5
v1.14.0-rc1
v1.15.0-dev
v1.13.4
v1.13.3
v1.13.2
v1.13.1
v1.13.0
v1.12.6
v1.13.0-rc2
v1.14.0-dev
v1.13.0-rc1
v1.12.5
v1.12.4
v1.12.3
v1.12.2
v1.12.1
v1.11.8
v1.12.0
v1.11.7
v1.12.0-rc2
v1.11.6
v1.12.0-rc1
v1.13.0-dev
v1.11.5
v1.11.4
v1.11.3
v1.10.6
v1.12.0-dev
v1.11.2
v1.10.5
v1.11.1
v1.10.4
v1.11.0
v1.11.0-rc2
v1.10.3
v1.11.0-rc1
v1.10.2
v1.10.1
v1.10.0
v1.9.6
v1.9.5
v1.10.0-rc2
v1.11.0-dev
v1.10.0-rc1
v1.9.4
v1.9.3
v1.9.2
v1.9.1
v1.9.0
v1.9.0-rc2
v1.10.0-dev
v1.9.0-rc1
v1.8.3
v1.8.2
v1.8.1
v1.8.0
v1.8.0-rc3
v1.7.6
v1.8.0-rc2
v1.7.5
v1.8.0-rc1
v1.9.0-dev
v1.7.4
v1.7.3
v1.7.2
v1.7.1
v1.7.0
v1.7.0-rc3
v1.6.4
v1.7.0-rc2
v1.6.3
v1.7.0-rc1
v1.7.0-dev
v1.6.2
v1.6.1
v1.6.0
v1.6.0-rc2
v1.5.3
v1.6.0-rc1
v1.6.0-dev
v1.5.2
v1.5.1
v1.5.0
v1.5.0-rc2
v1.5.0-rc1
v1.5.0-dev
v1.4.3
v1.4.2
v1.4.1
v1.4.0
v1.4.0-rc3
v1.4.0-rc2
v1.3.3
v1.4.0-rc1
v1.3.2
v1.3.1
v1.3.0
v1.3.0-rc2
v1.3.0-rc1
v1.2.3
v1.2.2
v1.2.1
v1.2.0
v1.2.0-rc3
v1.2.0-rc2
v1.1.4
v1.2.0-rc1
v1.1.3
v1.1.2
v1.1.1
v1.1.0
v1.0.2
v1.0.1
v1.0.0
v0.9.99
Labels
Clear labels
$20
$250
$50
$500
backport/done
💎 Bounty
docs-update-needed
good first issue
hacktoberfest
issue/bounty
issue/confirmed
issue/critical
issue/duplicate
issue/needs-feedback
issue/not-a-bug
issue/regression
issue/stale
issue/workaround
lgtm/need 2
modifies/api
modifies/translation
outdated/backport/v1.18
outdated/theme/markdown
outdated/theme/timetracker
performance/bigrepo
performance/cpu
performance/memory
performance/speed
pr/breaking
proposal/accepted
proposal/rejected
pr/wip
pull-request
reviewed/wontfix
💰 Rewarded
skip-changelog
status/blocked
topic/accessibility
topic/api
topic/authentication
topic/build
topic/code-linting
topic/commit-signing
topic/content-rendering
topic/deployment
topic/distribution
topic/federation
topic/gitea-actions
topic/issues
topic/lfs
topic/mobile
topic/moderation
topic/packages
topic/pr
topic/projects
topic/repo
topic/repo-migration
topic/security
topic/theme
topic/ui
topic/ui-interaction
topic/ux
topic/webhooks
topic/wiki
type/bug
type/deprecation
type/docs
type/enhancement
type/feature
type/miscellaneous
type/proposal
type/question
type/refactoring
type/summary
type/testing
type/upstream
Mirrored from GitHub Pull Request
No Label
issue/duplicate
Milestone
No items
No Milestone
Projects
Clear projects
No project
No Assignees
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: github-starred/gitea#7293
Reference in New Issue
Block a user
Blocking a user prevents them from interacting with repositories, such as opening or commenting on pull requests or issues. Learn more about blocking a user.
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @2ral on GitHub (May 4, 2021).
Hello I am suffering from update failure after replacing the gitea binary v1.13.6 with v1.14.1.
Seems like the new binary had messed up with database somehow.
2021/05/04 21:44:08 ...dules/setting/log.go:333:newLogService() [I] Gitea Log Mode: File(File:info)
2021/05/04 21:44:08 ...dules/setting/log.go:250:generateNamedLogger() [I] Router Log: Console(console:info)
2021/05/04 21:44:08 ...les/setting/cache.go:73:newCacheService() [I] Cache Service Enabled
2021/05/04 21:44:08 ...les/setting/cache.go:88:newCacheService() [I] Last Commit Cache Service Enabled
2021/05/04 21:44:08 ...s/setting/session.go:77:newSessionService() [I] Session Service Enabled
2021/05/04 21:44:08 ...s/storage/storage.go:158:initAttachments() [I] Initialising Attachment storage with type:
2021/05/04 21:44:08 ...les/storage/local.go:47:NewLocalStorage() [I] Creating new Local Storage at /var/lib/l2gitea/data/attachments
2021/05/04 21:44:08 ...s/storage/storage.go:152:initAvatars() [I] Initialising Avatar storage with type:
2021/05/04 21:44:08 ...les/storage/local.go:47:NewLocalStorage() [I] Creating new Local Storage at /var/lib/l2gitea/data/avatars
2021/05/04 21:44:08 ...s/storage/storage.go:170:initRepoAvatars() [I] Initialising Repository Avatar storage with type:
2021/05/04 21:44:08 ...les/storage/local.go:47:NewLocalStorage() [I] Creating new Local Storage at /var/lib/l2gitea/data/repo-avatars
2021/05/04 21:44:08 ...s/storage/storage.go:164:initLFS() [I] Initialising LFS storage with type:
2021/05/04 21:44:08 ...les/storage/local.go:47:NewLocalStorage() [I] Creating new Local Storage at /var/lib/l2gitea/data/lfs
2021/05/04 21:44:08 routers/init.go:150:GlobalInit() [I] SQLite3 Supported
2021/05/04 21:44:08 routers/init.go:68:initDBEngine() [I] Beginning ORM engine initialization.
2021/05/04 21:44:08 routers/init.go:75:initDBEngine() [I] ORM engine initialization attempt #1/10...
2021/05/04 21:44:08 ...om/urfave/cli/app.go:524:HandleAction() [I] PING DATABASE mysql
2021/05/04 21:44:08 ...ations/migrations.go:357:Migrate() [I] [SQL] SELECT
TABLE_NAMEfromINFORMATION_SCHEMA.TABLESWHERETABLE_SCHEMA=? andTABLE_NAME=? [l2gitea version] - 4.010939ms2021/05/04 21:44:08 models/models.go:220:NewEngine() [I] [SQL] SELECT
COLUMN_NAMEFROMINFORMATION_SCHEMA.COLUMNSWHERETABLE_SCHEMA= ? ANDTABLE_NAME= ? ANDCOLUMN_NAME= ? [l2gitea version id] - 3.18519ms2021/05/04 21:44:08 models/models.go:220:NewEngine() [I] [SQL] SELECT
COLUMN_NAMEFROMINFORMATION_SCHEMA.COLUMNSWHERETABLE_SCHEMA= ? ANDTABLE_NAME= ? ANDCOLUMN_NAME= ? [l2gitea version version] - 4.638688ms2021/05/04 21:44:08 ...rm.io/xorm/engine.go:1130:Get() [I] [SQL] SELECT
id,versionFROMversionWHEREid=? LIMIT 1 [1] - 767.624µs2021/05/04 21:44:08 ...ations/migrations.go:394:Migrate() [I] Migration[159]: update reactions constraint
2021/05/04 21:44:08 models/models.go:220:NewEngine() [I] [SQL] BEGIN TRANSACTION [] - 250.468µs
2021/05/04 21:44:08 ...s/migrations/v159.go:33:updateReactionConstraint() [I] [SQL] CREATE TABLE IF NOT EXISTS
tmp_recreate__reaction(idBIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL,typeVARCHAR(255) NOT NULL,issue_idBIGINT(20) NOT NULL,comment_idBIGINT(20) NULL,user_idBIGINT(20) NOT NULL,original_author_idBIGINT(20) DEFAULT 0 NOT NULL,original_authorVARCHAR(255) NULL,created_unixBIGINT(20) NULL) DEFAULT CHARSET utf8mb4 ROW_FORMAT=DYNAMIC [] - 2.971163ms2021/05/04 21:44:08 ...s/migrations/v159.go:33:updateReactionConstraint() [I] [SQL] CREATE UNIQUE INDEX
UQE_tmp_recreate__reaction_sONtmp_recreate__reaction(type,issue_id,comment_id,user_id,original_author_id,original_author) [] - 249.455µs2021/05/04 21:44:08 ...ations/migrations.go:447:recreateTable() [E] Unable to create uniques for table tmp_recreate__reaction. Error: Error 1071: Specified key was too long; max key length is 767 bytes
2021/05/04 21:44:08 ...ations/migrations.go:397:Migrate() [I] [SQL] ROLLBACK [] - 170.11µs
2021/05/04 21:44:08 routers/init.go:81:initDBEngine() [E] ORM engine initialization attempt #1/10 failed. Error: migrate: do migrate: Error 1071: Specified key was too long; max key length is 767 bytes
2021/05/04 21:44:08 routers/init.go:82:initDBEngine() [I] Backing off for 3 seconds
2021/05/04 21:44:11 ...eful/manager_unix.go:127:handleSignals() [W] PID 13686. Received SIGTERM. Shutting down...
2021/05/04 21:44:11 .../graceful/manager.go:217:doHammerTime() [W] Setting Hammer condition
2021/05/04 21:44:11 routers/init.go:157:GlobalInit() [F] ORM engine initialization failed: Aborted due to shutdown:
in retry ORM engine initialization
2021/05/04 21:45:27 ...dules/setting/log.go:333:newLogService() [I] Gitea Log Mode: File(File:info)
2021/05/04 21:45:27 ...dules/setting/log.go:250:generateNamedLogger() [I] Router Log: Console(console:info)
2021/05/04 21:45:27 ...les/setting/cache.go:73:newCacheService() [I] Cache Service Enabled
2021/05/04 21:45:27 ...les/setting/cache.go:88:newCacheService() [I] Last Commit Cache Service Enabled
2021/05/04 21:45:27 ...s/setting/session.go:77:newSessionService() [I] Session Service Enabled
2021/05/04 21:45:27 ...s/storage/storage.go:158:initAttachments() [I] Initialising Attachment storage with type:
2021/05/04 21:45:27 ...les/storage/local.go:47:NewLocalStorage() [I] Creating new Local Storage at /var/lib/l2gitea/data/attachments
2021/05/04 21:45:27 ...s/storage/storage.go:152:initAvatars() [I] Initialising Avatar storage with type:
2021/05/04 21:45:27 ...les/storage/local.go:47:NewLocalStorage() [I] Creating new Local Storage at /var/lib/l2gitea/data/avatars
2021/05/04 21:45:27 ...s/storage/storage.go:170:initRepoAvatars() [I] Initialising Repository Avatar storage with type:
2021/05/04 21:45:27 ...les/storage/local.go:47:NewLocalStorage() [I] Creating new Local Storage at /var/lib/l2gitea/data/repo-avatars
2021/05/04 21:45:27 ...s/storage/storage.go:164:initLFS() [I] Initialising LFS storage with type:
2021/05/04 21:45:27 ...les/storage/local.go:47:NewLocalStorage() [I] Creating new Local Storage at /var/lib/l2gitea/data/lfs
2021/05/04 21:45:28 routers/init.go:150:GlobalInit() [I] SQLite3 Supported
2021/05/04 21:45:28 routers/init.go:68:initDBEngine() [I] Beginning ORM engine initialization.
2021/05/04 21:45:28 routers/init.go:75:initDBEngine() [I] ORM engine initialization attempt #1/10...
2021/05/04 21:45:28 ...om/urfave/cli/app.go:524:HandleAction() [I] PING DATABASE mysql
2021/05/04 21:45:28 ...ations/migrations.go:357:Migrate() [I] [SQL] SELECT
TABLE_NAMEfromINFORMATION_SCHEMA.TABLESWHERETABLE_SCHEMA=? andTABLE_NAME=? [l2gitea version] - 90.338347ms2021/05/04 21:45:28 models/models.go:220:NewEngine() [I] [SQL] SELECT
COLUMN_NAMEFROMINFORMATION_SCHEMA.COLUMNSWHERETABLE_SCHEMA= ? ANDTABLE_NAME= ? ANDCOLUMN_NAME= ? [l2gitea version id] - 7.089183ms2021/05/04 21:45:28 models/models.go:220:NewEngine() [I] [SQL] SELECT
COLUMN_NAMEFROMINFORMATION_SCHEMA.COLUMNSWHERETABLE_SCHEMA= ? ANDTABLE_NAME= ? ANDCOLUMN_NAME= ? [l2gitea version version] - 2.741804ms2021/05/04 21:45:28 ...rm.io/xorm/engine.go:1130:Get() [I] [SQL] SELECT
id,versionFROMversionWHEREid=? LIMIT 1 [1] - 9.82632ms2021/05/04 21:45:28 ...ations/migrations.go:394:Migrate() [I] Migration[159]: update reactions constraint
2021/05/04 21:45:28 models/models.go:220:NewEngine() [I] [SQL] BEGIN TRANSACTION [] - 1.793286ms
2021/05/04 21:45:28 ...s/migrations/v159.go:33:updateReactionConstraint() [I] [SQL] CREATE TABLE IF NOT EXISTS
tmp_recreate__reaction(idBIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL,typeVARCHAR(255) NOT NULL,issue_idBIGINT(20) NOT NULL,comment_idBIGINT(20) NULL,user_idBIGINT(20) NOT NULL,original_author_idBIGINT(20) DEFAULT 0 NOT NULL,original_authorVARCHAR(255) NULL,created_unixBIGINT(20) NULL) DEFAULT CHARSET utf8mb4 ROW_FORMAT=DYNAMIC [] - 13.994248ms2021/05/04 21:45:28 ...s/migrations/v159.go:33:updateReactionConstraint() [I] [SQL] CREATE UNIQUE INDEX
UQE_tmp_recreate__reaction_sONtmp_recreate__reaction(type,issue_id,comment_id,user_id,original_author_id,original_author) [] - 1.744552ms2021/05/04 21:45:28 ...ations/migrations.go:447:recreateTable() [E] Unable to create uniques for table tmp_recreate__reaction. Error: Error 1071: Specified key was too long; max key length is 767 bytes
2021/05/04 21:45:28 ...ations/migrations.go:397:Migrate() [I] [SQL] ROLLBACK [] - 162.766µs
2021/05/04 21:45:28 routers/init.go:81:initDBEngine() [E] ORM engine initialization attempt #1/10 failed. Error: migrate: do migrate: Error 1071: Specified key was too long; max key length is 767 bytes
2021/05/04 21:45:28 routers/init.go:82:initDBEngine() [I] Backing off for 3 seconds
2021/05/04 21:45:31 routers/init.go:75:initDBEngine() [I] ORM engine initialization attempt #2/10...
Then the log is repeated. Any advices how to fix it? Sadly I have no backup of gitea instance so installing from scratch is not an option for me :(
@zeripath commented on GitHub (May 4, 2021):
Error 1071: Specified key was too long; max key length is 767 bytes
@zeripath commented on GitHub (May 4, 2021):
https://docs.gitea.io/en-us/faq/#upgrade-errors-with-mysql
@zeripath commented on GitHub (May 4, 2021):
https://github.com/go-gitea/gitea/issues/15540#issuecomment-822761650 Shows the solution
@2ral commented on GitHub (May 4, 2021):
Thanks for the reply. I have followed your recommendations and seems like conversion is going on. And gitea instance is alive :) Thanks for helping me out.