Upgrade fail: Row size too large
Hello,
I recently upgraded ynh from 3.5.8 to 4.0.8 and upgraded many apps. I have an error with my gitea installation:
Warning: Start the service gitea
Warning: ..........The service gitea didn't fully started before the timeout.
Warning: -- Logs begin at Sun 2020-11-08 23:59:24 UTC, end at Mon 2020-11-09 12:38:16 UTC. --
Warning: Nov 09 12:29:03 lstronic systemd[1]: gitea.service: Scheduled restart job, restart counter is at 12.
Warning: Nov 09 12:29:03 lstronic systemd[1]: Stopped Gitea.
Warning: Nov 09 12:29:03 lstronic systemd[1]: Started Gitea.
Warning: Nov 09 12:29:03 lstronic gitea[21061]: 2020/11/09 12:29:03 cmd/web.go:107:runWeb() [I] Starting Gitea on PID: 21061
Warning: Nov 09 12:29:03 lstronic gitea[21061]: 2020/11/09 12:29:03 ...dules/setting/git.go:93:newGit() [I] Git Version: 2.20.1, Wire Protocol Version 2 Enabled
Warning: Nov 09 12:29:03 lstronic gitea[21061]: 2020/11/09 12:29:03 routers/init.go:118:GlobalInit() [T] AppPath: /opt/gitea/gitea
Warning: Nov 09 12:29:03 lstronic gitea[21061]: 2020/11/09 12:29:03 routers/init.go:119:GlobalInit() [T] AppWorkPath: /opt/gitea
Warning: Nov 09 12:29:03 lstronic gitea[21061]: 2020/11/09 12:29:03 routers/init.go:120:GlobalInit() [T] Custom path: /opt/gitea/custom
Warning: Nov 09 12:29:03 lstronic gitea[21061]: 2020/11/09 12:29:03 routers/init.go:121:GlobalInit() [T] Log path: /var/log/gitea
Warning: Nov 09 12:29:27 lstronic systemd[1]: Stopping Gitea...
Warning: Nov 09 12:29:27 lstronic systemd[1]: gitea.service: Main process exited, code=exited, status=1/FAILURE
Warning: Nov 09 12:29:27 lstronic systemd[1]: gitea.service: Failed with result 'exit-code'.
Warning: Nov 09 12:29:27 lstronic systemd[1]: Stopped Gitea.
Warning: Nov 09 12:38:06 lstronic systemd[1]: Started Gitea.
Warning: Nov 09 12:38:06 lstronic gitea[25877]: 2020/11/09 12:38:06 cmd/web.go:107:runWeb() [I] Starting Gitea on PID: 25877
Warning: Nov 09 12:38:06 lstronic gitea[25877]: 2020/11/09 12:38:06 ...dules/setting/git.go:93:newGit() [I] Git Version: 2.20.1, Wire Protocol Version 2 Enabled
Warning: Nov 09 12:38:06 lstronic gitea[25877]: 2020/11/09 12:38:06 routers/init.go:118:GlobalInit() [T] AppPath: /opt/gitea/gitea
Warning: Nov 09 12:38:06 lstronic gitea[25877]: 2020/11/09 12:38:06 routers/init.go:119:GlobalInit() [T] AppWorkPath: /opt/gitea
Warning: Nov 09 12:38:06 lstronic gitea[25877]: 2020/11/09 12:38:06 routers/init.go:120:GlobalInit() [T] Custom path: /opt/gitea/custom
Warning: Nov 09 12:38:06 lstronic gitea[25877]: 2020/11/09 12:38:06 routers/init.go:121:GlobalInit() [T] Log path: /var/log/gitea
Warning: 2020/11/09 12:38:06 ...s/setting/session.go:63:newSessionService() [I] Session Service Enabled
Warning: 2020/11/09 12:38:06 ...es/setting/mailer.go:109:newMailService() [I] Mail Service Enabled
Warning: 2020/11/09 12:38:06 ...es/setting/mailer.go:131:newNotifyMailService() [I] Notify Mail Service Enabled
Warning: 2020/11/09 12:38:07 routers/init.go:63:initDBEngine() [I] Beginning ORM engine initialization.
Warning: 2020/11/09 12:38:07 routers/init.go:70:initDBEngine() [I] ORM engine initialization attempt #1/10...
Warning: 2020/11/09 12:38:07 ...ations/migrations.go:300:Migrate() [I] Migration[107]: Add template options to repository
Warning: 2020/11/09 12:38:07 routers/init.go:76: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
Warning: 2020/11/09 12:38:07 routers/init.go:77:initDBEngine() [I] Backing off for 3 seconds
Warning: 2020/11/09 12:38:10 routers/init.go:70:initDBEngine() [I] ORM engine initialization attempt #2/10...
Warning: 2020/11/09 12:38:10 ...ations/migrations.go:300:Migrate() [I] Migration[107]: Add template options to repository
Warning: 2020/11/09 12:38:10 routers/init.go:76: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
Warning: 2020/11/09 12:38:10 routers/init.go:77:initDBEngine() [I] Backing off for 3 seconds
Warning: 2020/11/09 12:38:13 routers/init.go:70:initDBEngine() [I] ORM engine initialization attempt #3/10...
Warning: 2020/11/09 12:38:13 ...ations/migrations.go:300:Migrate() [I] Migration[107]: Add template options to repository
Warning: 2020/11/09 12:38:13 routers/init.go:76: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
Warning: 2020/11/09 12:38:13 routers/init.go:77:initDBEngine() [I] Backing off for 3 seconds
Warning: 2020/11/09 12:38:16 routers/init.go:70:initDBEngine() [I] ORM engine initialization attempt #4/10...
Warning: 2020/11/09 12:38:16 ...ations/migrations.go:300:Migrate() [I] Migration[107]: Add template options to repository
Warning: 2020/11/09 12:38:16 routers/init.go:76: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
Warning: 2020/11/09 12:38:16 routers/init.go:77:initDBEngine() [I] Backing off for 3 seconds
Success! gitea upgraded
Even if the service starts now, I cannot access the webpage: 502 rised by the reverse proxy.
Léo