OK, so I updated the version
. (BTW, what did that do in practice, except just changing a single value in the database?). Then upgraded gitea to :latest -> not showing in browser. Tried 1.13 -> not showing in browser. Tried 1.12 and then 1.11 -> same outcome.
Then I tried 1.10, and it worked! At least I was able to go past the 1.9.x version. Then I tried 1.11 -> worked! Then 1.12 -> worked too! Then 1.13 -> not showing in browser, although now the logs are a bit different:
Docker log:
2020-12-11 15:41:32,stdout,e[36m2020/12/11 15:41:32 e[0me[32mrouters/init.go:133:e[32mGlobalInit()e[0m e[1;36m[T]e[0m Log path: e[1m/data/gitea/loge[0m
2020-12-11 15:41:32,stdout,e[36m2020/12/11 15:41:32 e[0me[32mrouters/init.go:132:e[32mGlobalInit()e[0m e[1;36m[T]e[0m Custom path: e[1m/data/giteae[0m
2020-12-11 15:41:32,stdout,e[36m2020/12/11 15:41:32 e[0me[32mrouters/init.go:131:e[32mGlobalInit()e[0m e[1;36m[T]e[0m AppWorkPath: e[1m/app/giteae[0m
2020-12-11 15:41:32,stdout,e[36m2020/12/11 15:41:32 e[0me[32mrouters/init.go:130:e[32mGlobalInit()e[0m e[1;36m[T]e[0m AppPath: e[1m/app/gitea/giteae[0m
2020-12-11 15:41:32,stdout,"e[36m2020/12/11 15:41:32 e[0me[32m...dules/setting/git.go:91:e[32mnewGit()e[0m e[1;32m[I]e[0m Git Version: e[1m2.26.2e[0m, Wire Protocol e[1mVersion 2e[0m Enabled "
2020-12-11 15:41:32,stdout,e[36m2020/12/11 15:41:32 e[0me[32mcmd/web.go:108:e[32mrunWeb()e[0m e[1;32m[I]e[0m Starting Gitea on PID: e[1m15e[0m
2020-12-11 15:41:31,stdout,Server listening on 0.0.0.0 port 22.
2020-12-11 15:41:31,stdout,Server listening on :: port 22.
2020-12-11 15:41:31,stdout,Could not load host certificate "/data/ssh/ssh_host_dsa_cert": No such file or directory
2020-12-11 15:41:31,stdout,Could not load host certificate "/data/ssh/ssh_host_ecdsa_cert": No such file or directory
2020-12-11 15:41:31,stdout,Could not load host certificate "/data/ssh/ssh_host_rsa_cert": No such file or directory
2020-12-11 15:41:31,stdout,Could not load host certificate "/data/ssh/ssh_host_ed25519_cert": No such file or directory
2020-12-11 15:41:31,stdout,Received signal 15; terminating.
That is, in fact, correct - I do not have the “…_cert” files in my /data/ssh/ - only the “…_key” and “…_key.pub” files. Looks like these worked up to 1.12.x, but not in 1.13, right? Can I somehow convert the _key and _key.pub into _cert?
gitea.log on the other hand is filled with these:
2020/12/11 15:47:49 routers/init.go:82:initDBEngine() [I] ORM engine initialization attempt #9/10...
2020/12/11 15:47:49 ...rm/session_schema.go:25:Ping() [I] PING DATABASE sqlite3
2020/12/11 15:47:49 ...m.io/xorm/core/db.go:286:afterProcess() [I] [SQL] SELECT name FROM sqlite_master WHERE type='table' and name = ? [version] - 54.861µs
2020/12/11 15:47:49 ...m.io/xorm/core/db.go:286:afterProcess() [I] [SQL] SELECT * FROM version LIMIT 0 [] - 21.615µs
2020/12/11 15:47:49 ...m.io/xorm/core/db.go:286:afterProcess() [I] [SQL] SELECT * FROM version LIMIT 0 [] - 22.274µs
2020/12/11 15:47:49 ...m.io/xorm/core/db.go:286:afterProcess() [I] [SQL] SELECT `id`, `version` FROM `version` WHERE `id`=? LIMIT 1 [1] - 22.973µs
2020/12/11 15:47:49 ...ations/migrations.go:336:Migrate() [I] Migration[151]: set default password algorithm to Argon2
2020/12/11 15:47:49 ...m.io/xorm/core/db.go:286:afterProcess() [I] [SQL] SELECT name FROM sqlite_master WHERE type='table' [] - 24.3µs
2020/12/11 15:47:49 ...m.io/xorm/core/db.go:286:afterProcess() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [user] - 33.786µs
...
2020/12/11 15:47:49 ...m.io/xorm/core/db.go:286:afterProcess() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [repo_topic] - 27.188µs
2020/12/11 15:47:49 ...m.io/xorm/core/db.go:286:afterProcess() [I] [SQL] BEGIN TRANSACTION [] - 31.828µs
2020/12/11 15:47:49 ...m.io/xorm/core/db.go:286:afterProcess() [I] [SQL] CREATE TABLE IF NOT EXISTS `tmp_recreate__user` (`id` INTEGER PRIMARY KEY AUTOINCREMENT NULL, `lower_name` VARCHAR(255) NULL, `NOT` NULL NULL, `name` VARCHAR(255) NULL, `NOT` NULL NULL, `full_name` VARCHAR(255) NULL, `NULL` NULL, `email` VARCHAR(255) NULL, `NOT` NULL NULL, `keep_email_private` TINYINT(1) NULL, `NULL` NULL, `passwd` VARCHAR(255) NULL, `NOT` NULL NULL, `login_type` INTEGER NULL, `login_source` BIGINT(20) NULL, `DEFAULT` '' NOT NULL, `login_name` VARCHAR(255) NULL, `NULL` NULL, `type` INTEGER NULL, `location` VARCHAR(255) NULL, `NULL` NULL, `website` VARCHAR(255) NULL, `NULL` NULL, `rands` VARCHAR(10) NULL, `NULL` NULL, `salt` VARCHAR(10) NULL, `NULL` NULL, `language` VARCHAR(5) NULL, `NULL` NULL, `created_unix` BIGINT(20) NULL, `NULL` NULL, `updated_unix` BIGINT(20) NULL, `NULL` NULL, `last_login_unix` BIGINT(20) NULL, `NULL` NULL, `last_repo_visibility` TINYINT(1) NULL, `NULL` NULL, `max_repo_creation` INTEGER DEFAULT -1 NOT NULL, `is_active` TINYINT(1) NULL, `NULL` NULL, `is_admin` TINYINT(1) NULL, `NULL` NULL, `allow_git_hook` TINYINT(1) NULL, `NULL` NULL, `allow_import_local` TINYINT(1) NULL, `NULL` NULL, `allow_create_organization` TINYINT(1) NULL, `DEFAULT` '' NOT NULL, `prohibit_login` TINYINT(1) NULL, `DEFAULT` '' NOT NULL, `avatar` VARCHAR(2048) NULL, `NOT` NULL NULL, `avatar_email` VARCHAR(255) NULL, `NOT` NULL NULL, `use_custom_avatar` TINYINT(1) NULL, `NULL` NULL, `num_followers` INTEGER NULL, `num_following` INTEGER DEFAULT 0 NOT NULL, `num_stars` INTEGER NULL, `num_repos` INTEGER NULL, `description` VARCHAR(255) NULL, `NULL` NULL, `num_teams` INTEGER NULL, `num_members` INTEGER NULL, `diff_view_style` VARCHAR(255) NULL, `DEFAULT` '' NOT NULL, `must_change_password` INTEGER DEFAULT 0 NOT NULL, `theme` TEXT DEFAULT '' NOT NULL, `visibility` INTEGER DEFAULT 0 NOT NULL, `passwd_hash_algo` TEXT DEFAULT 'argon2' NOT NULL, `email_notifications_preference` TEXT DEFAULT 'enabled' NOT NULL, `repo_admin_change_team_access` INTEGER DEFAULT 0 NOT NULL, `is_restricted` INTEGER DEFAULT 0 NOT NULL, `keep_activity_private` INTEGER NULL) [] - 27.879µs
2020/12/11 15:47:49 ...s/migrations/v151.go:101:setDefaultPasswordToArgon2() [E] Unable to create table tmp_recreate__user. Error: duplicate column name: NOT
%!(EXTRA *log.ColoredValue=[CREATE TABLE IF NOT EXISTS `tmp_recreate__user` (`id` INTEGER PRIMARY KEY AUTOINCREMENT NULL, `lower_name` VARCHAR(255) NULL, `NOT` NULL NULL, `name` VARCHAR(255) NULL, `NOT` NULL NULL, `full_name` VARCHAR(255) NULL, `NULL` NULL, `email` VARCHAR(255) NULL, `NOT` NULL NULL, `keep_email_private` TINYINT(1) NULL, `NULL` NULL, `passwd` VARCHAR(255) NULL, `NOT` NULL NULL, `login_type` INTEGER NULL, `login_source` BIGINT(20) NULL, `DEFAULT` '' NOT NULL, `login_name` VARCHAR(255) NULL, `NULL` NULL, `type` INTEGER NULL, `location` VARCHAR(255) NULL, `NULL` NULL, `website` VARCHAR(255) NULL, `NULL` NULL, `rands` VARCHAR(10) NULL, `NULL` NULL, `salt` VARCHAR(10) NULL, `NULL` NULL, `language` VARCHAR(5) NULL, `NULL` NULL, `created_unix` BIGINT(20) NULL, `NULL` NULL, `updated_unix` BIGINT(20) NULL, `NULL` NULL, `last_login_unix` BIGINT(20) NULL, `NULL` NULL, `last_repo_visibility` TINYINT(1) NULL, `NULL` NULL, `max_repo_creation` INTEGER DEFAULT -1 NOT NULL, `is_active` TINYINT(1) NULL, `NULL` NULL, `is_admin` TINYINT(1) NULL, `NULL` NULL, `allow_git_hook` TINYINT(1) NULL, `NULL` NULL, `allow_import_local` TINYINT(1) NULL, `NULL` NULL, `allow_create_organization` TINYINT(1) NULL, `DEFAULT` '' NOT NULL, `prohibit_login` TINYINT(1) NULL, `DEFAULT` '' NOT NULL, `avatar` VARCHAR(2048) NULL, `NOT` NULL NULL, `avatar_email` VARCHAR(255) NULL, `NOT` NULL NULL, `use_custom_avatar` TINYINT(1) NULL, `NULL` NULL, `num_followers` INTEGER NULL, `num_following` INTEGER DEFAULT 0 NOT NULL, `num_stars` INTEGER NULL, `num_repos` INTEGER NULL, `description` VARCHAR(255) NULL, `NULL` NULL, `num_teams` INTEGER NULL, `num_members` INTEGER NULL, `diff_view_style` VARCHAR(255) NULL, `DEFAULT` '' NOT NULL, `must_change_password` INTEGER DEFAULT 0 NOT NULL, `theme` TEXT DEFAULT '' NOT NULL, `visibility` INTEGER DEFAULT 0 NOT NULL, `passwd_hash_algo` TEXT DEFAULT 'argon2' NOT NULL, `email_notifications_preference` TEXT DEFAULT 'enabled' NOT NULL, `repo_admin_change_team_access` INTEGER DEFAULT 0 NOT NULL, `is_restricted` INTEGER DEFAULT 0 NOT NULL, `keep_activity_private` INTEGER NULL)])
2020/12/11 15:47:49 ...m.io/xorm/core/db.go:286:afterProcess() [I] [SQL] ROLLBACK [] - 19.265µs
2020/12/11 15:47:49 routers/init.go:88:initDBEngine() [E] ORM engine initialization attempt #9/10 failed. Error: migrate: do migrate: duplicate column name: NOT
2020/12/11 15:47:49 routers/init.go:89:initDBEngine() [I] Backing off for 3 seconds
I removed ~100 or so of the “[I] [SQL] SELECT …” statements to save space.
Anyway, in the end it seems it is now 1.12 -> 1.13 upgrade issue.