github-starred/gitea
2
0
Fork 0
mirror of https://github.com/go-gitea/gitea.git synced 2026-03-19 14:42:41 -05:00
Code Issues 2.6k Packages Projects Releases 100 Wiki Activity

Error 1118: Row size too large when update from 1.11.7 to 1.12.x #5747

New Issue
Closed
opened 2025-11-02 06:34:49 -06:00 by GiteaMirror · 2 comments
GiteaMirror commented 2025-11-02 06:34:49 -06:00
Owner
Copy Link

Originally created by @flomine on GitHub (Jul 16, 2020).

  • Gitea version (or commit ref): 1.12.0
  • Git version:
  • Operating system: debian 10
  • Database (use [x]):
    • PostgreSQL
    • [x ] MySQL
    • MSSQL
    • SQLite
  • Can you reproduce the bug at https://try.gitea.io:
    • Yes (provide example URL)
    • No
    • [ X] Not relevant
  • Log gist:

Description

I cannot update from gitea 1.11.7 to 1.12.x. It seems that there is a problem with the database.
Error: migrate: do migrate: Error 1118: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
Please find the log below
...

2020/07/16 09:18:41 routers/init.go:64:initDBEngine() [I] Beginning ORM engine initialization.
2020/07/16 09:18:41 routers/init.go:71:initDBEngine() [I] ORM engine initialization attempt #1/10...
2020/07/16 09:18:41 ...rm/session_schema.go:25:Ping() [I] PING DATABASE mysql
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`=? and `TABLE_NAME`=? [forge_prod version] - 8.48423ms
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? AND `COLUMN_NAME` = ? [forge_prod version id] - 2.874793ms
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? AND `COLUMN_NAME` = ? [forge_prod version version] - 746.896µs
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `id`, `version` FROM `version` WHERE `id`=? LIMIT 1 [1] - 2.776779ms
2020/07/16 09:18:41 ...ations/migrations.go:300:Migrate() [I] Migration[118]: Add commit id and stale to reviews
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `TABLE_NAME`, `ENGINE`, `AUTO_INCREMENT`, `TABLE_COMMENT` from `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`=? AND (`ENGINE`='MyISAM' OR `ENGINE` = 'InnoDB' OR `ENGINE` = 'TokuDB') [forge_prod] - 87.933188ms
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `COLUMN_NAME`, `IS_NULLABLE`, `COLUMN_DEFAULT`, `COLUMN_TYPE`, `COLUMN_KEY`, `EXTRA`,`COLUMN_COMMENT` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? [forge_prod review] - 3.257022ms
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `INDEX_NAME`, `NON_UNIQUE`, `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`STATISTICS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? [forge_prod review] - 1.073538ms
2020/07/16 09:18:41 ...rm/session_schema.go:360:Sync2() [W] Table review Column commit_id db default is 'NULL', struct default is 
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `IDX_review_updated_unix` ON `review` [] - 51.554788ms
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `IDX_review_reviewer_id` ON `review` [] - 44.125606ms
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `IDX_review_issue_id` ON `review` [] - 10.72571ms
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `IDX_review_created_unix` ON `review` [] - 15.697348ms
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table review has column id but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table review has column type but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table review has column reviewer_id but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table review has column issue_id but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table review has column content but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table review has column created_unix but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table review has column updated_unix but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table review has column official but struct has not related field
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `TABLE_NAME`, `ENGINE`, `AUTO_INCREMENT`, `TABLE_COMMENT` from `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`=? AND (`ENGINE`='MyISAM' OR `ENGINE` = 'InnoDB' OR `ENGINE` = 'TokuDB') [forge_prod] - 2.611366ms
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `COLUMN_NAME`, `IS_NULLABLE`, `COLUMN_DEFAULT`, `COLUMN_TYPE`, `COLUMN_KEY`, `EXTRA`,`COLUMN_COMMENT` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? [forge_prod protected_branch] - 2.121334ms
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `INDEX_NAME`, `NON_UNIQUE`, `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`STATISTICS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? [forge_prod protected_branch] - 757.718µs
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `UQE_protected_branch_s` ON `protected_branch` [] - 28.238298ms
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column id but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column repo_id but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column branch_name but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column created_unix but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column updated_unix but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column enable_whitelist but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column whitelist_user_i_ds but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column whitelist_team_i_ds but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column can_push but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column enable_merge_whitelist but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column merge_whitelist_user_i_ds but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column merge_whitelist_team_i_ds but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column approvals_whitelist_user_i_ds but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column approvals_whitelist_team_i_ds but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column required_approvals but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column enable_status_check but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column status_check_contexts but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column whitelist_deploy_keys but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column enable_approvals_whitelist but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column block_on_rejected_reviews but struct has not related field
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] UPDATE `version` SET `version` = ? WHERE `id`=? [119 1] - 4.681459ms
2020/07/16 09:18:41 ...ations/migrations.go:300:Migrate() [I] Migration[119]: Fix migrated repositories' git service type
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] UPDATE repository SET original_service_type = ? WHERE original_url LIKE 'https://github.com/%' [2] - 902.935µs
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] UPDATE `version` SET `version` = ? WHERE `id`=? [120 1] - 4.389668ms
2020/07/16 09:18:41 ...ations/migrations.go:300:Migrate() [I] Migration[120]: Add owner_name on table repository
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `TABLE_NAME`, `ENGINE`, `AUTO_INCREMENT`, `TABLE_COMMENT` from `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`=? AND (`ENGINE`='MyISAM' OR `ENGINE` = 'InnoDB' OR `ENGINE` = 'TokuDB') [forge_prod] - 3.042137ms
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `COLUMN_NAME`, `IS_NULLABLE`, `COLUMN_DEFAULT`, `COLUMN_TYPE`, `COLUMN_KEY`, `EXTRA`,`COLUMN_COMMENT` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? [forge_prod repository] - 11.901334ms
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `INDEX_NAME`, `NON_UNIQUE`, `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`STATISTICS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? [forge_prod repository] - 766.383µs
2020/07/16 09:18:41 ...rm/session_schema.go:360:Sync2() [W] Table repository Column owner_name db default is 'NULL', struct default is 
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `IDX_repository_original_service_type` ON `repository` [] - 25.476523ms
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `IDX_repository_is_template` ON `repository` [] - 14.342926ms
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `UQE_repository_s` ON `repository` [] - 19.629071ms
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `IDX_repository_updated_unix` ON `repository` [] - 14.942814ms
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `IDX_repository_created_unix` ON `repository` [] - 16.750403ms
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `IDX_repository_fork_id` ON `repository` [] - 8.543229ms
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `IDX_repository_template_id` ON `repository` [] - 11.573369ms
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `IDX_repository_is_private` ON `repository` [] - 27.271191ms
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `IDX_repository_is_mirror` ON `repository` [] - 18.811794ms
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `IDX_repository_name` ON `repository` [] - 17.530544ms
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `IDX_repository_is_fork` ON `repository` [] - 12.084827ms
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `IDX_repository_is_empty` ON `repository` [] - 8.36164ms
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `IDX_repository_lower_name` ON `repository` [] - 5.4651ms
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `IDX_repository_is_archived` ON `repository` [] - 15.737783ms
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `IDX_repository_owner_id` ON `repository` [] - 67.56816ms
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column id but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column owner_id but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column lower_name but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column name but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column description but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column website but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column default_branch but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column num_watches but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column num_stars but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column num_forks but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column num_issues but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column num_closed_issues but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column num_pulls but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column num_closed_pulls but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column num_milestones but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column num_closed_milestones but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column is_private but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column is_mirror but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column is_fork but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column fork_id but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column created but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column updated but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column enable_wiki but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column enable_external_wiki but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column external_wiki_url but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column enable_issues but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column enable_external_tracker but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column external_tracker_format but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column enable_pulls but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column created_unix but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column updated_unix but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column external_tracker_style but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column external_tracker_url but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column size but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column is_fsck_enabled but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column topics but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column is_empty but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column close_issues_via_commit_in_any_branch but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column is_archived but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column avatar but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column original_url but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column status but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column original_service_type but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column is_template but struct has not related field
2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column template_id but struct has not related field
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] UPDATE repository SET owner_name = (SELECT name FROM `user` WHERE `user`.id = repository.owner_id) [] - 1.415306ms
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] UPDATE `version` SET `version` = ? WHERE `id`=? [121 1] - 7.826053ms
2020/07/16 09:18:41 ...ations/migrations.go:300:Migrate() [I] Migration[121]: add is_restricted column for users table
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `TABLE_NAME`, `ENGINE`, `AUTO_INCREMENT`, `TABLE_COMMENT` from `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`=? AND (`ENGINE`='MyISAM' OR `ENGINE` = 'InnoDB' OR `ENGINE` = 'TokuDB') [forge_prod] - 8.4918ms
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `COLUMN_NAME`, `IS_NULLABLE`, `COLUMN_DEFAULT`, `COLUMN_TYPE`, `COLUMN_KEY`, `EXTRA`,`COLUMN_COMMENT` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? [forge_prod user] - 2.436349ms
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `INDEX_NAME`, `NON_UNIQUE`, `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`STATISTICS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? [forge_prod user] - 8.351075ms
2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] ALTER TABLE `user` ADD `is_restricted` TINYINT(1) DEFAULT false NOT NULL  [] - 4.317758ms
2020/07/16 09:18:41 routers/init.go:77:initDBEngine() [E] ORM engine initialization attempt #1/10 failed. Error: migrate: do migrate: Error 1118: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
2020/07/16 09:18:41 routers/init.go:78:initDBEngine() [I] Backing off for 3 seconds
2020/07/16 09:18:44 routers/init.go:71:initDBEngine() [I] ORM engine initialization attempt #2/10...
2020/07/16 09:18:44 ...rm/session_schema.go:25:Ping() [I] PING DATABASE mysql
2020/07/16 09:18:44 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`=? and `TABLE_NAME`=? [forge_prod version] - 1.371915ms
2020/07/16 09:18:44 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? AND `COLUMN_NAME` = ? [forge_prod version id] - 549.654µs
2020/07/16 09:18:44 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? AND `COLUMN_NAME` = ? [forge_prod version version] - 459.508µs
2020/07/16 09:18:44 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `id`, `version` FROM `version` WHERE `id`=? LIMIT 1 [1] - 1.940847ms
2020/07/16 09:18:44 ...ations/migrations.go:300:Migrate() [I] Migration[121]: add is_restricted column for users table
2020/07/16 09:18:44 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `TABLE_NAME`, `ENGINE`, `AUTO_INCREMENT`, `TABLE_COMMENT` from `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`=? AND (`ENGINE`='MyISAM' OR `ENGINE` = 'InnoDB' OR `ENGINE` = 'TokuDB') [forge_prod] - 2.902907ms
2020/07/16 09:18:44 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `COLUMN_NAME`, `IS_NULLABLE`, `COLUMN_DEFAULT`, `COLUMN_TYPE`, `COLUMN_KEY`, `EXTRA`,`COLUMN_COMMENT` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? [forge_prod user] - 2.117323ms
2020/07/16 09:18:44 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `INDEX_NAME`, `NON_UNIQUE`, `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`STATISTICS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? [forge_prod user] - 608.29µs
2020/07/16 09:18:44 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] ALTER TABLE `user` ADD `is_restricted` TINYINT(1) DEFAULT false NOT NULL  [] - 1.745646ms
2020/07/16 09:18:44 routers/init.go:77:initDBEngine() [E] ORM engine initialization attempt #2/10 failed. Error: migrate: do migrate: Error 1118: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
2020/07/16 09:18:44 routers/init.go:78:initDBEngine() [I] Backing off for 3 seconds
2020/07/16 09:18:47 routers/init.go:71:initDBEngine() [I] ORM engine initialization attempt #3/10...
2020/07/16 09:18:47 ...rm/session_schema.go:25:Ping() [I] PING DATABASE mysql
2020/07/16 09:18:47 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`=? and `TABLE_NAME`=? [forge_prod version] - 863.817µs
2020/07/16 09:18:47 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? AND `COLUMN_NAME` = ? [forge_prod version id] - 531.829µs
2020/07/16 09:18:47 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? AND `COLUMN_NAME` = ? [forge_prod version version] - 451.114µs
2020/07/16 09:18:47 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `id`, `version` FROM `version` WHERE `id`=? LIMIT 1 [1] - 311.375µs
2020/07/16 09:18:47 ...ations/migrations.go:300:Migrate() [I] Migration[121]: add is_restricted column for users table
2020/07/16 09:18:47 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `TABLE_NAME`, `ENGINE`, `AUTO_INCREMENT`, `TABLE_COMMENT` from `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`=? AND (`ENGINE`='MyISAM' OR `ENGINE` = 'InnoDB' OR `ENGINE` = 'TokuDB') [forge_prod] - 2.359043ms
2020/07/16 09:18:47 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `COLUMN_NAME`, `IS_NULLABLE`, `COLUMN_DEFAULT`, `COLUMN_TYPE`, `COLUMN_KEY`, `EXTRA`,`COLUMN_COMMENT` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? [forge_prod user] - 1.450735ms
2020/07/16 09:18:47 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `INDEX_NAME`, `NON_UNIQUE`, `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`STATISTICS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? [forge_prod user] - 510.834µs
2020/07/16 09:18:47 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] ALTER TABLE `user` ADD `is_restricted` TINYINT(1) DEFAULT false NOT NULL  [] - 1.373876ms
2020/07/16 09:18:47 routers/init.go:77:initDBEngine() [E] ORM engine initialization attempt #3/10 failed. Error: migrate: do migrate: Error 1118: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
2020/07/16 09:18:47 routers/init.go:78:initDBEngine() [I] Backing off for 3 seconds
2020/07/16 09:18:50 routers/init.go:71:initDBEngine() [I] ORM engine initialization attempt #4/10...
2020/07/16 09:18:50 ...rm/session_schema.go:25:Ping() [I] PING DATABASE mysql
2020/07/16 09:18:50 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`=? and `TABLE_NAME`=? [forge_prod version] - 851.871µs
2020/07/16 09:18:50 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? AND `COLUMN_NAME` = ? [forge_prod version id] - 597.545µs
2020/07/16 09:18:50 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? AND `COLUMN_NAME` = ? [forge_prod version version] - 496.161µs
2020/07/16 09:18:50 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `id`, `version` FROM `version` WHERE `id`=? LIMIT 1 [1] - 356.061µs
2020/07/16 09:18:50 ...ations/migrations.go:300:Migrate() [I] Migration[121]: add is_restricted column for users table
2020/07/16 09:18:50 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `TABLE_NAME`, `ENGINE`, `AUTO_INCREMENT`, `TABLE_COMMENT` from `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`=? AND (`ENGINE`='MyISAM' OR `ENGINE` = 'InnoDB' OR `ENGINE` = 'TokuDB') [forge_prod] - 2.975932ms
2020/07/16 09:18:50 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `COLUMN_NAME`, `IS_NULLABLE`, `COLUMN_DEFAULT`, `COLUMN_TYPE`, `COLUMN_KEY`, `EXTRA`,`COLUMN_COMMENT` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? [forge_prod user] - 2.263759ms
2020/07/16 09:18:50 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `INDEX_NAME`, `NON_UNIQUE`, `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`STATISTICS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? [forge_prod user] - 673.924µs
2020/07/16 09:18:50 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] ALTER TABLE `user` ADD `is_restricted` TINYINT(1) DEFAULT false NOT NULL  [] - 1.477108ms
2020/07/16 09:18:50 routers/init.go:77:initDBEngine() [E] ORM engine initialization attempt #4/10 failed. Error: migrate: do migrate: Error 1118: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
2020/07/16 09:18:50 routers/init.go:78:initDBEngine() [I] Backing off for 3 seconds
2020/07/16 09:18:53 routers/init.go:71:initDBEngine() [I] ORM engine initialization attempt #5/10...
2020/07/16 09:18:53 ...rm/session_schema.go:25:Ping() [I] PING DATABASE mysql
2020/07/16 09:18:53 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`=? and `TABLE_NAME`=? [forge_prod version] - 1.143746ms
2020/07/16 09:18:53 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? AND `COLUMN_NAME` = ? [forge_prod version id] - 851.81µs
2020/07/16 09:18:53 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? AND `COLUMN_NAME` = ? [forge_prod version version] - 573.243µs
2020/07/16 09:18:53 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `id`, `version` FROM `version` WHERE `id`=? LIMIT 1 [1] - 794.502µs
2020/07/16 09:18:53 ...ations/migrations.go:300:Migrate() [I] Migration[121]: add is_restricted column for users table
2020/07/16 09:18:53 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `TABLE_NAME`, `ENGINE`, `AUTO_INCREMENT`, `TABLE_COMMENT` from `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`=? AND (`ENGINE`='MyISAM' OR `ENGINE` = 'InnoDB' OR `ENGINE` = 'TokuDB') [forge_prod] - 4.18696ms
2020/07/16 09:18:53 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `COLUMN_NAME`, `IS_NULLABLE`, `COLUMN_DEFAULT`, `COLUMN_TYPE`, `COLUMN_KEY`, `EXTRA`,`COLUMN_COMMENT` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? [forge_prod user] - 2.541978ms
2020/07/16 09:18:53 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `INDEX_NAME`, `NON_UNIQUE`, `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`STATISTICS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? [forge_prod user] - 726.836µs
2020/07/16 09:18:53 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] ALTER TABLE `user` ADD `is_restricted` TINYINT(1) DEFAULT false NOT NULL  [] - 2.114418ms
2020/07/16 09:18:53 routers/init.go:77:initDBEngine() [E] ORM engine initialization attempt #5/10 failed. Error: migrate: do migrate: Error 1118: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
2020/07/16 09:18:53 routers/init.go:78:initDBEngine() [I] Backing off for 3 seconds
Originally created by @flomine on GitHub (Jul 16, 2020). - Gitea version (or commit ref): 1.12.0 - Git version: - Operating system: debian 10 - Database (use `[x]`): - [ ] PostgreSQL - [x ] MySQL - [ ] MSSQL - [ ] SQLite - Can you reproduce the bug at https://try.gitea.io: - [ ] Yes (provide example URL) - [ ] No - [ X] Not relevant - Log gist: ## Description I cannot update from gitea 1.11.7 to 1.12.x. It seems that there is a problem with the database. `Error: migrate: do migrate: Error 1118: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs` Please find the log below ... ``` 2020/07/16 09:18:41 routers/init.go:64:initDBEngine() [I] Beginning ORM engine initialization. 2020/07/16 09:18:41 routers/init.go:71:initDBEngine() [I] ORM engine initialization attempt #1/10... 2020/07/16 09:18:41 ...rm/session_schema.go:25:Ping() [I] PING DATABASE mysql 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`=? and `TABLE_NAME`=? [forge_prod version] - 8.48423ms 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? AND `COLUMN_NAME` = ? [forge_prod version id] - 2.874793ms 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? AND `COLUMN_NAME` = ? [forge_prod version version] - 746.896µs 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `id`, `version` FROM `version` WHERE `id`=? LIMIT 1 [1] - 2.776779ms 2020/07/16 09:18:41 ...ations/migrations.go:300:Migrate() [I] Migration[118]: Add commit id and stale to reviews 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `TABLE_NAME`, `ENGINE`, `AUTO_INCREMENT`, `TABLE_COMMENT` from `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`=? AND (`ENGINE`='MyISAM' OR `ENGINE` = 'InnoDB' OR `ENGINE` = 'TokuDB') [forge_prod] - 87.933188ms 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `COLUMN_NAME`, `IS_NULLABLE`, `COLUMN_DEFAULT`, `COLUMN_TYPE`, `COLUMN_KEY`, `EXTRA`,`COLUMN_COMMENT` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? [forge_prod review] - 3.257022ms 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `INDEX_NAME`, `NON_UNIQUE`, `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`STATISTICS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? [forge_prod review] - 1.073538ms 2020/07/16 09:18:41 ...rm/session_schema.go:360:Sync2() [W] Table review Column commit_id db default is 'NULL', struct default is 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `IDX_review_updated_unix` ON `review` [] - 51.554788ms 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `IDX_review_reviewer_id` ON `review` [] - 44.125606ms 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `IDX_review_issue_id` ON `review` [] - 10.72571ms 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `IDX_review_created_unix` ON `review` [] - 15.697348ms 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table review has column id but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table review has column type but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table review has column reviewer_id but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table review has column issue_id but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table review has column content but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table review has column created_unix but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table review has column updated_unix but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table review has column official but struct has not related field 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `TABLE_NAME`, `ENGINE`, `AUTO_INCREMENT`, `TABLE_COMMENT` from `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`=? AND (`ENGINE`='MyISAM' OR `ENGINE` = 'InnoDB' OR `ENGINE` = 'TokuDB') [forge_prod] - 2.611366ms 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `COLUMN_NAME`, `IS_NULLABLE`, `COLUMN_DEFAULT`, `COLUMN_TYPE`, `COLUMN_KEY`, `EXTRA`,`COLUMN_COMMENT` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? [forge_prod protected_branch] - 2.121334ms 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `INDEX_NAME`, `NON_UNIQUE`, `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`STATISTICS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? [forge_prod protected_branch] - 757.718µs 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `UQE_protected_branch_s` ON `protected_branch` [] - 28.238298ms 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column id but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column repo_id but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column branch_name but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column created_unix but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column updated_unix but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column enable_whitelist but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column whitelist_user_i_ds but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column whitelist_team_i_ds but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column can_push but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column enable_merge_whitelist but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column merge_whitelist_user_i_ds but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column merge_whitelist_team_i_ds but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column approvals_whitelist_user_i_ds but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column approvals_whitelist_team_i_ds but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column required_approvals but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column enable_status_check but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column status_check_contexts but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column whitelist_deploy_keys but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column enable_approvals_whitelist but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table protected_branch has column block_on_rejected_reviews but struct has not related field 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] UPDATE `version` SET `version` = ? WHERE `id`=? [119 1] - 4.681459ms 2020/07/16 09:18:41 ...ations/migrations.go:300:Migrate() [I] Migration[119]: Fix migrated repositories' git service type 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] UPDATE repository SET original_service_type = ? WHERE original_url LIKE 'https://github.com/%' [2] - 902.935µs 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] UPDATE `version` SET `version` = ? WHERE `id`=? [120 1] - 4.389668ms 2020/07/16 09:18:41 ...ations/migrations.go:300:Migrate() [I] Migration[120]: Add owner_name on table repository 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `TABLE_NAME`, `ENGINE`, `AUTO_INCREMENT`, `TABLE_COMMENT` from `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`=? AND (`ENGINE`='MyISAM' OR `ENGINE` = 'InnoDB' OR `ENGINE` = 'TokuDB') [forge_prod] - 3.042137ms 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `COLUMN_NAME`, `IS_NULLABLE`, `COLUMN_DEFAULT`, `COLUMN_TYPE`, `COLUMN_KEY`, `EXTRA`,`COLUMN_COMMENT` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? [forge_prod repository] - 11.901334ms 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `INDEX_NAME`, `NON_UNIQUE`, `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`STATISTICS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? [forge_prod repository] - 766.383µs 2020/07/16 09:18:41 ...rm/session_schema.go:360:Sync2() [W] Table repository Column owner_name db default is 'NULL', struct default is 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `IDX_repository_original_service_type` ON `repository` [] - 25.476523ms 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `IDX_repository_is_template` ON `repository` [] - 14.342926ms 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `UQE_repository_s` ON `repository` [] - 19.629071ms 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `IDX_repository_updated_unix` ON `repository` [] - 14.942814ms 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `IDX_repository_created_unix` ON `repository` [] - 16.750403ms 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `IDX_repository_fork_id` ON `repository` [] - 8.543229ms 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `IDX_repository_template_id` ON `repository` [] - 11.573369ms 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `IDX_repository_is_private` ON `repository` [] - 27.271191ms 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `IDX_repository_is_mirror` ON `repository` [] - 18.811794ms 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `IDX_repository_name` ON `repository` [] - 17.530544ms 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `IDX_repository_is_fork` ON `repository` [] - 12.084827ms 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `IDX_repository_is_empty` ON `repository` [] - 8.36164ms 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `IDX_repository_lower_name` ON `repository` [] - 5.4651ms 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `IDX_repository_is_archived` ON `repository` [] - 15.737783ms 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DROP INDEX `IDX_repository_owner_id` ON `repository` [] - 67.56816ms 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column id but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column owner_id but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column lower_name but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column name but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column description but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column website but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column default_branch but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column num_watches but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column num_stars but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column num_forks but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column num_issues but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column num_closed_issues but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column num_pulls but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column num_closed_pulls but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column num_milestones but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column num_closed_milestones but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column is_private but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column is_mirror but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column is_fork but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column fork_id but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column created but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column updated but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column enable_wiki but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column enable_external_wiki but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column external_wiki_url but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column enable_issues but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column enable_external_tracker but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column external_tracker_format but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column enable_pulls but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column created_unix but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column updated_unix but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column external_tracker_style but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column external_tracker_url but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column size but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column is_fsck_enabled but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column topics but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column is_empty but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column close_issues_via_commit_in_any_branch but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column is_archived but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column avatar but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column original_url but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column status but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column original_service_type but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column is_template but struct has not related field 2020/07/16 09:18:41 ...rm/session_schema.go:431:Sync2() [W] Table repository has column template_id but struct has not related field 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] UPDATE repository SET owner_name = (SELECT name FROM `user` WHERE `user`.id = repository.owner_id) [] - 1.415306ms 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] UPDATE `version` SET `version` = ? WHERE `id`=? [121 1] - 7.826053ms 2020/07/16 09:18:41 ...ations/migrations.go:300:Migrate() [I] Migration[121]: add is_restricted column for users table 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `TABLE_NAME`, `ENGINE`, `AUTO_INCREMENT`, `TABLE_COMMENT` from `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`=? AND (`ENGINE`='MyISAM' OR `ENGINE` = 'InnoDB' OR `ENGINE` = 'TokuDB') [forge_prod] - 8.4918ms 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `COLUMN_NAME`, `IS_NULLABLE`, `COLUMN_DEFAULT`, `COLUMN_TYPE`, `COLUMN_KEY`, `EXTRA`,`COLUMN_COMMENT` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? [forge_prod user] - 2.436349ms 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `INDEX_NAME`, `NON_UNIQUE`, `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`STATISTICS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? [forge_prod user] - 8.351075ms 2020/07/16 09:18:41 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] ALTER TABLE `user` ADD `is_restricted` TINYINT(1) DEFAULT false NOT NULL [] - 4.317758ms 2020/07/16 09:18:41 routers/init.go:77:initDBEngine() [E] ORM engine initialization attempt #1/10 failed. Error: migrate: do migrate: Error 1118: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs 2020/07/16 09:18:41 routers/init.go:78:initDBEngine() [I] Backing off for 3 seconds 2020/07/16 09:18:44 routers/init.go:71:initDBEngine() [I] ORM engine initialization attempt #2/10... 2020/07/16 09:18:44 ...rm/session_schema.go:25:Ping() [I] PING DATABASE mysql 2020/07/16 09:18:44 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`=? and `TABLE_NAME`=? [forge_prod version] - 1.371915ms 2020/07/16 09:18:44 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? AND `COLUMN_NAME` = ? [forge_prod version id] - 549.654µs 2020/07/16 09:18:44 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? AND `COLUMN_NAME` = ? [forge_prod version version] - 459.508µs 2020/07/16 09:18:44 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `id`, `version` FROM `version` WHERE `id`=? LIMIT 1 [1] - 1.940847ms 2020/07/16 09:18:44 ...ations/migrations.go:300:Migrate() [I] Migration[121]: add is_restricted column for users table 2020/07/16 09:18:44 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `TABLE_NAME`, `ENGINE`, `AUTO_INCREMENT`, `TABLE_COMMENT` from `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`=? AND (`ENGINE`='MyISAM' OR `ENGINE` = 'InnoDB' OR `ENGINE` = 'TokuDB') [forge_prod] - 2.902907ms 2020/07/16 09:18:44 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `COLUMN_NAME`, `IS_NULLABLE`, `COLUMN_DEFAULT`, `COLUMN_TYPE`, `COLUMN_KEY`, `EXTRA`,`COLUMN_COMMENT` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? [forge_prod user] - 2.117323ms 2020/07/16 09:18:44 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `INDEX_NAME`, `NON_UNIQUE`, `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`STATISTICS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? [forge_prod user] - 608.29µs 2020/07/16 09:18:44 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] ALTER TABLE `user` ADD `is_restricted` TINYINT(1) DEFAULT false NOT NULL [] - 1.745646ms 2020/07/16 09:18:44 routers/init.go:77:initDBEngine() [E] ORM engine initialization attempt #2/10 failed. Error: migrate: do migrate: Error 1118: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs 2020/07/16 09:18:44 routers/init.go:78:initDBEngine() [I] Backing off for 3 seconds 2020/07/16 09:18:47 routers/init.go:71:initDBEngine() [I] ORM engine initialization attempt #3/10... 2020/07/16 09:18:47 ...rm/session_schema.go:25:Ping() [I] PING DATABASE mysql 2020/07/16 09:18:47 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`=? and `TABLE_NAME`=? [forge_prod version] - 863.817µs 2020/07/16 09:18:47 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? AND `COLUMN_NAME` = ? [forge_prod version id] - 531.829µs 2020/07/16 09:18:47 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? AND `COLUMN_NAME` = ? [forge_prod version version] - 451.114µs 2020/07/16 09:18:47 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `id`, `version` FROM `version` WHERE `id`=? LIMIT 1 [1] - 311.375µs 2020/07/16 09:18:47 ...ations/migrations.go:300:Migrate() [I] Migration[121]: add is_restricted column for users table 2020/07/16 09:18:47 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `TABLE_NAME`, `ENGINE`, `AUTO_INCREMENT`, `TABLE_COMMENT` from `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`=? AND (`ENGINE`='MyISAM' OR `ENGINE` = 'InnoDB' OR `ENGINE` = 'TokuDB') [forge_prod] - 2.359043ms 2020/07/16 09:18:47 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `COLUMN_NAME`, `IS_NULLABLE`, `COLUMN_DEFAULT`, `COLUMN_TYPE`, `COLUMN_KEY`, `EXTRA`,`COLUMN_COMMENT` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? [forge_prod user] - 1.450735ms 2020/07/16 09:18:47 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `INDEX_NAME`, `NON_UNIQUE`, `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`STATISTICS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? [forge_prod user] - 510.834µs 2020/07/16 09:18:47 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] ALTER TABLE `user` ADD `is_restricted` TINYINT(1) DEFAULT false NOT NULL [] - 1.373876ms 2020/07/16 09:18:47 routers/init.go:77:initDBEngine() [E] ORM engine initialization attempt #3/10 failed. Error: migrate: do migrate: Error 1118: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs 2020/07/16 09:18:47 routers/init.go:78:initDBEngine() [I] Backing off for 3 seconds 2020/07/16 09:18:50 routers/init.go:71:initDBEngine() [I] ORM engine initialization attempt #4/10... 2020/07/16 09:18:50 ...rm/session_schema.go:25:Ping() [I] PING DATABASE mysql 2020/07/16 09:18:50 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`=? and `TABLE_NAME`=? [forge_prod version] - 851.871µs 2020/07/16 09:18:50 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? AND `COLUMN_NAME` = ? [forge_prod version id] - 597.545µs 2020/07/16 09:18:50 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? AND `COLUMN_NAME` = ? [forge_prod version version] - 496.161µs 2020/07/16 09:18:50 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `id`, `version` FROM `version` WHERE `id`=? LIMIT 1 [1] - 356.061µs 2020/07/16 09:18:50 ...ations/migrations.go:300:Migrate() [I] Migration[121]: add is_restricted column for users table 2020/07/16 09:18:50 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `TABLE_NAME`, `ENGINE`, `AUTO_INCREMENT`, `TABLE_COMMENT` from `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`=? AND (`ENGINE`='MyISAM' OR `ENGINE` = 'InnoDB' OR `ENGINE` = 'TokuDB') [forge_prod] - 2.975932ms 2020/07/16 09:18:50 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `COLUMN_NAME`, `IS_NULLABLE`, `COLUMN_DEFAULT`, `COLUMN_TYPE`, `COLUMN_KEY`, `EXTRA`,`COLUMN_COMMENT` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? [forge_prod user] - 2.263759ms 2020/07/16 09:18:50 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `INDEX_NAME`, `NON_UNIQUE`, `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`STATISTICS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? [forge_prod user] - 673.924µs 2020/07/16 09:18:50 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] ALTER TABLE `user` ADD `is_restricted` TINYINT(1) DEFAULT false NOT NULL [] - 1.477108ms 2020/07/16 09:18:50 routers/init.go:77:initDBEngine() [E] ORM engine initialization attempt #4/10 failed. Error: migrate: do migrate: Error 1118: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs 2020/07/16 09:18:50 routers/init.go:78:initDBEngine() [I] Backing off for 3 seconds 2020/07/16 09:18:53 routers/init.go:71:initDBEngine() [I] ORM engine initialization attempt #5/10... 2020/07/16 09:18:53 ...rm/session_schema.go:25:Ping() [I] PING DATABASE mysql 2020/07/16 09:18:53 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`=? and `TABLE_NAME`=? [forge_prod version] - 1.143746ms 2020/07/16 09:18:53 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? AND `COLUMN_NAME` = ? [forge_prod version id] - 851.81µs 2020/07/16 09:18:53 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? AND `COLUMN_NAME` = ? [forge_prod version version] - 573.243µs 2020/07/16 09:18:53 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `id`, `version` FROM `version` WHERE `id`=? LIMIT 1 [1] - 794.502µs 2020/07/16 09:18:53 ...ations/migrations.go:300:Migrate() [I] Migration[121]: add is_restricted column for users table 2020/07/16 09:18:53 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `TABLE_NAME`, `ENGINE`, `AUTO_INCREMENT`, `TABLE_COMMENT` from `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`=? AND (`ENGINE`='MyISAM' OR `ENGINE` = 'InnoDB' OR `ENGINE` = 'TokuDB') [forge_prod] - 4.18696ms 2020/07/16 09:18:53 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `COLUMN_NAME`, `IS_NULLABLE`, `COLUMN_DEFAULT`, `COLUMN_TYPE`, `COLUMN_KEY`, `EXTRA`,`COLUMN_COMMENT` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? [forge_prod user] - 2.541978ms 2020/07/16 09:18:53 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `INDEX_NAME`, `NON_UNIQUE`, `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`STATISTICS` WHERE `TABLE_SCHEMA` = ? AND `TABLE_NAME` = ? [forge_prod user] - 726.836µs 2020/07/16 09:18:53 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] ALTER TABLE `user` ADD `is_restricted` TINYINT(1) DEFAULT false NOT NULL [] - 2.114418ms 2020/07/16 09:18:53 routers/init.go:77:initDBEngine() [E] ORM engine initialization attempt #5/10 failed. Error: migrate: do migrate: Error 1118: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs 2020/07/16 09:18:53 routers/init.go:78:initDBEngine() [I] Backing off for 3 seconds ```
GiteaMirror commented 2025-11-02 06:34:49 -06:00
Author
Owner
Copy Link

@zeripath commented on GitHub (Jul 16, 2020):

Have you tried gitea convert?

@zeripath commented on GitHub (Jul 16, 2020): Have you tried `gitea convert`?
GiteaMirror commented 2025-11-02 06:34:50 -06:00
Author
Owner
Copy Link

@flomine commented on GitHub (Jul 17, 2020):

Yes it works. I didn't know about this feature. What is it supposed to do ? Thanks for pointing me in this direction.

@flomine commented on GitHub (Jul 17, 2020): Yes it works. I didn't know about this feature. What is it supposed to do ? Thanks for pointing me in this direction.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
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
Mirrored from GitHub 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
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
GiteaMirror ninjasurge
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/gitea#5747
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?