Skip to content

[ARM64] finish script lifetime reached maximum value - sending it a SIGKILL #11963

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Closed
ViRb3 opened this issue Jun 18, 2020 · 19 comments
Closed

[ARM64] finish script lifetime reached maximum value - sending it a SIGKILL #11963

ViRb3 opened this issue Jun 18, 2020 · 19 comments
Labels
issue/stale

Comments

@ViRb3
Copy link

ViRb3 commented Jun 18, 2020 •
edited
Loading

Technical

  • Gitea 1.12 Docker, just upgraded from 1.11.6
  • Raspberry Pi 4 Ubuntu 20.04 (official) arm64
  • Default settings (MySQL DB, etc.)

Log

020/06/18 18:22:09 ...dules/setting/git.go:93:newGit() [I] Git Version: 2.24.3, Wire Protocol Version 2 Enabled
2020/06/18 18:22:09 routers/init.go:119:GlobalInit() [T] AppPath: /app/gitea/gitea
2020/06/18 18:22:09 routers/init.go:120:GlobalInit() [T] AppWorkPath: /app/gitea
2020/06/18 18:22:09 routers/init.go:121:GlobalInit() [T] Custom path: /data/gitea
2020/06/18 18:22:09 routers/init.go:122:GlobalInit() [T] Log path: /data/gitea/log
2020/06/18 18:22:09 routers/init.go:127:GlobalInit() [I] Delete all repository archives
s6-supervise gitea: warning: finish script lifetime reached maximum value - sending it a SIGKILL
2020/06/18 18:56:15 cmd/web.go:107:runWeb() [I] Starting Gitea on PID: 156
2020/06/18 18:56:15 ...dules/setting/git.go:93:newGit() [I] Git Version: 2.24.3, Wire Protocol Version 2 Enabled
2020/06/18 18:56:15 routers/init.go:119:GlobalInit() [T] AppPath: /app/gitea/gitea
2020/06/18 18:56:15 routers/init.go:120:GlobalInit() [T] AppWorkPath: /app/gitea
2020/06/18 18:56:15 routers/init.go:121:GlobalInit() [T] Custom path: /data/gitea
2020/06/18 18:56:15 routers/init.go:122:GlobalInit() [T] Log path: /data/gitea/log
2020/06/18 18:56:16 routers/init.go:127:GlobalInit() [I] Delete all repository archives
s6-supervise gitea: warning: finish script lifetime reached maximum value - sending it a SIGKILL
2020/06/18 19:06:00 cmd/web.go:107:runWeb() [I] Starting Gitea on PID: 188
2020/06/18 19:06:00 ...dules/setting/git.go:93:newGit() [I] Git Version: 2.24.3, Wire Protocol Version 2 Enabled
2020/06/18 19:06:00 routers/init.go:119:GlobalInit() [T] AppPath: /app/gitea/gitea
2020/06/18 19:06:00 routers/init.go:120:GlobalInit() [T] AppWorkPath: /app/gitea
2020/06/18 19:06:00 routers/init.go:121:GlobalInit() [T] Custom path: /data/gitea
2020/06/18 19:06:00 routers/init.go:122:GlobalInit() [T] Log path: /data/gitea/log
2020/06/18 19:06:01 routers/init.go:127:GlobalInit() [I] Delete all repository archives
s6-supervise gitea: warning: finish script lifetime reached maximum value - sending it a SIGKILL
...

Description

This has been repeating for about 2 hours, taking up 100% CPU in the process.
@ViRb3
Copy link
Author

ViRb3 commented Jun 18, 2020

Here is the gitea.log, which also repeats infinitely:

2020/06/18 19:06:05 cmd/web.go:161:runWeb() [I] Listen: http://0.0.0.0:3000
2020/06/18 19:06:05 cmd/web.go:164:runWeb() [I] LFS server enabled
2020/06/18 19:06:05 ...s/graceful/server.go:55:NewServer() [I] Starting new server: tcp:0.0.0.0:3000 on PID: 188
2020/06/18 19:06:13 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT user_id, count(*) AS count FROM notification WHERE user_id IN (SELECT user_id FROM notification WHERE updated_unix >= ? AND updated_unix < ?) AND status = ? GROUP BY user_id [1592507161 1592507171 1] - 354.663µs
2020/06/18 19:06:23 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT user_id, count(*) AS count FROM notification WHERE user_id IN (SELECT user_id FROM notification WHERE updated_unix >= ? AND updated_unix < ?) AND status = ? GROUP BY user_id [1592507171 1592507181 1] - 281.868µs
2020/06/18 19:06:33 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT user_id, count(*) AS count FROM notification WHERE user_id IN (SELECT user_id FROM notification WHERE updated_unix >= ? AND updated_unix < ?) AND status = ? GROUP BY user_id [1592507181 1592507191 1] - 693.623µs
2020/06/18 19:06:43 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT user_id, count(*) AS count FROM notification WHERE user_id IN (SELECT user_id FROM notification WHERE updated_unix >= ? AND updated_unix < ?) AND status = ? GROUP BY user_id [1592507191 1592507201 1] - 304.09µs
2020/06/18 19:06:53 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT user_id, count(*) AS count FROM notification WHERE user_id IN (SELECT user_id FROM notification WHERE updated_unix >= ? AND updated_unix < ?) AND status = ? GROUP BY user_id [1592507201 1592507211 1] - 277.275µs
2020/06/18 19:07:03 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT user_id, count(*) AS count FROM notification WHERE user_id IN (SELECT user_id FROM notification WHERE updated_unix >= ? AND updated_unix < ?) AND status = ? GROUP BY user_id [1592507211 1592507221 1] - 419.2µs
2020/06/18 19:07:13 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT user_id, count(*) AS count FROM notification WHERE user_id IN (SELECT user_id FROM notification WHERE updated_unix >= ? AND updated_unix < ?) AND status = ? GROUP BY user_id [1592507221 1592507231 1] - 366.349µs
2020/06/18 19:07:23 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT user_id, count(*) AS count FROM notification WHERE user_id IN (SELECT user_id FROM notification WHERE updated_unix >= ? AND updated_unix < ?) AND status = ? GROUP BY user_id [1592507231 1592507241 1] - 387.829µs
2020/06/18 19:07:33 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT user_id, count(*) AS count FROM notification WHERE user_id IN (SELECT user_id FROM notification WHERE updated_unix >= ? AND updated_unix < ?) AND status = ? GROUP BY user_id [1592507241 1592507251 1] - 313.608µs
2020/06/18 19:07:43 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT user_id, count(*) AS count FROM notification WHERE user_id IN (SELECT user_id FROM notification WHERE updated_unix >= ? AND updated_unix < ?) AND status = ? GROUP BY user_id [1592507251 1592507261 1] - 275.701µs
2020/06/18 19:07:53 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT user_id, count(*) AS count FROM notification WHERE user_id IN (SELECT user_id FROM notification WHERE updated_unix >= ? AND updated_unix < ?) AND status = ? GROUP BY user_id [1592507261 1592507271 1] - 554.921µs
2020/06/18 19:08:03 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT user_id, count(*) AS count FROM notification WHERE user_id IN (SELECT user_id FROM notification WHERE updated_unix >= ? AND updated_unix < ?) AND status = ? GROUP BY user_id [1592507271 1592507281 1] - 517.754µs
2020/06/18 19:19:55 ...dules/setting/log.go:279:newLogService() [I] Gitea Log Mode: File(File:info)
2020/06/18 19:19:55 ...les/setting/cache.go:70:newCacheService() [I] Cache Service Enabled
2020/06/18 19:19:55 ...les/setting/cache.go:81:newCacheService() [I] Last Commit Cache Service Enabled
2020/06/18 19:19:55 ...s/setting/session.go:63:newSessionService() [I] Session Service Enabled
2020/06/18 19:19:56 routers/init.go:64:initDBEngine() [I] Beginning ORM engine initialization.
2020/06/18 19:19:56 routers/init.go:71:initDBEngine() [I] ORM engine initialization attempt #1/10...
2020/06/18 19:19:56 ...rm/session_schema.go:25:Ping() [I] PING DATABASE sqlite3
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT name FROM sqlite_master WHERE type='table' and name = ? [version] - 1.823816ms
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT * FROM version LIMIT 0 [] - 140.98µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT * FROM version LIMIT 0 [] - 49.518µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `id`, `version` FROM `version` WHERE `id`=? LIMIT 1 [1] - 168.665µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT name FROM sqlite_master WHERE type='table' [] - 146.851µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [user] - 202.647µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [user] - 151.462µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [public_key] - 142.146µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [public_key] - 156.777µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [access_token] - 128.147µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [access_token] - 158.851µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [repository] - 180.628µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [repository] - 142.091µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [deploy_key] - 143.462µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [deploy_key] - 116.184µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [collaboration] - 169.11µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [collaboration] - 105.536µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [access] - 111.703µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [access] - 114.184µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [upload] - 107.795µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [upload] - 95.314µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [watch] - 180.146µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [watch] - 123.277µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [star] - 104.296µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [star] - 261.479µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [follow] - 135.739µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [follow] - 160.628µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [action] - 134.332µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [action] - 124.276µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [issue] - 147.98µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [issue] - 130.24µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [pull_request] - 188.127µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [pull_request] - 153.128µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [comment] - 175.516µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [comment] - 157.388µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [attachment] - 138.091µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [attachment] - 142.073µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [label] - 200.813µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [label] - 152.943µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [issue_label] - 174.794µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [issue_label] - 139.443µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [milestone] - 182.572µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [milestone] - 198.424µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [mirror] - 160.276µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [mirror] - 148.665µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [release] - 156.128µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [release] - 164.85µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [login_source] - 199.258µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [login_source] - 139.48µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [webhook] - 169.202µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [webhook] - 160.035µs
2020/06/18 19:19:56 ...rm/session_schema.go:360:Sync2() [W] Table webhook Column is_system_webhook db default is 0, struct default is 
2020/06/18 19:19:56 ...rm/session_schema.go:365:Sync2() [W] Table webhook Column is_system_webhook db nullable is false, struct nullable is true
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [hook_task] - 206.554µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [hook_task] - 146.35µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [team] - 163.906µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [team] - 135.295µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [org_user] - 134.091µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [org_user] - 162.517µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [team_user] - 139.369µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [team_user] - 137.332µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [team_repo] - 142.572µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [team_repo] - 123.055µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [notice] - 141.129µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [notice] - 123.332µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [email_address] - 183.405µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [email_address] - 132.98µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [notification] - 159.647µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [notification] - 132.277µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [issue_user] - 146.517µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [issue_user] - 169.462µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [lfs_meta_object] - 324.589µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [lfs_meta_object] - 161.98µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [two_factor] - 143.48µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [two_factor] - 104.387µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [gpg_key] - 309.145µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [gpg_key] - 165.295µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [gpg_key_import] - 161.924µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [gpg_key_import] - 153.332µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [repo_unit] - 194.701µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [repo_unit] - 164.573µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [repo_redirect] - 189.387µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [repo_redirect] - 269.293µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [external_login_user] - 190.869µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [external_login_user] - 153.313µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [protected_branch] - 165.203µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [protected_branch] - 160.498µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [user_open_id] - 139.999µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [user_open_id] - 151.702µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [issue_watch] - 144.147µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [issue_watch] - 175.628µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [commit_status] - 165.665µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [commit_status] - 135.85µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [stopwatch] - 146.85µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [stopwatch] - 130.314µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [tracked_time] - 142.832µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [tracked_time] - 144.202µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [deleted_branch] - 149.906µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [deleted_branch] - 134.647µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [repo_indexer_status] - 143.776µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [repo_indexer_status] - 144.332µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [issue_dependency] - 144.277µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [issue_dependency] - 145.851µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [lfs_lock] - 169.684µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [lfs_lock] - 137.795µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [reaction] - 156.85µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [reaction] - 144.813µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [issue_assignees] - 157.887µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [issue_assignees] - 155.387µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [u2f_registration] - 149.776µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [u2f_registration] - 135.591µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [team_unit] - 149.332µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [team_unit] - 131.665µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [review] - 152.591µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [review] - 145.535µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [oauth2_application] - 145.517µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [oauth2_application] - 131.277µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [oauth2_authorization_code] - 145.702µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [oauth2_authorization_code] - 140.813µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [oauth2_grant] - 135.332µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [oauth2_grant] - 156.221µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [task] - 152.443µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [task] - 137.776µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [language_stat] - 164.276µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [language_stat] - 148.128µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [email_hash] - 172.572µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [email_hash] - 134.221µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [topic] - 129.554µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [topic] - 130.869µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [repo_topic] - 144.388µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [repo_topic] - 131.666µs
2020/06/18 19:19:56 routers/init.go:136:GlobalInit() [I] ORM engine initialization successful!
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT name FROM sqlite_master WHERE type='table' [] - 118.443µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [oauth2_session] - 154.369µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [oauth2_session] - 138.128µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `id`, `type`, `name`, `is_actived`, `is_sync_enabled`, `cfg`, `created_unix`, `updated_unix` FROM `login_source` WHERE (is_actived = ? and type = ?) [true 6] - 216.294µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `external_id`, `user_id`, `login_source_id`, `raw_data`, `provider`, `email`, `name`, `first_name`, `last_name`, `nick_name`, `description`, `avatar_url`, `location`, `access_token`, `access_token_secret`, `refresh_token`, `expires_at` FROM `external_login_user` WHERE provider=? ORDER BY login_source_id ASC, external_id ASC LIMIT 100 [github] - 628.383µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `external_id`, `user_id`, `login_source_id`, `raw_data`, `provider`, `email`, `name`, `first_name`, `last_name`, `nick_name`, `description`, `avatar_url`, `location`, `access_token`, `access_token_secret`, `refresh_token`, `expires_at` FROM `external_login_user` WHERE provider=? ORDER BY login_source_id ASC, external_id ASC LIMIT 100 [gitlab] - 331.904µs
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT repo.id FROM `repository` repo WHERE repo.num_watches!=(SELECT COUNT(*) FROM `watch` WHERE repo_id=repo.id AND mode<>2) [] - 52.222627ms
2020/06/18 19:19:56 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] DELETE FROM `deleted_branch` WHERE (deleted_unix < ?) [1592421596] - 53.603539ms
2020/06/18 19:19:57 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT repo.id FROM `repository` repo WHERE repo.num_stars!=(SELECT COUNT(*) FROM `star` WHERE repo_id=repo.id) [] - 187.258µs
2020/06/18 19:19:57 ...er/issues/indexer.go:142:func2() [I] PID 222: Initializing Issue Indexer: bleve
2020/06/18 19:19:57 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `id`, `owner_id`, `owner_name`, `lower_name`, `name`, `description`, `website`, `original_service_type`, `original_url`, `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`, `status`, `is_fork`, `fork_id`, `is_template`, `template_id`, `size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `avatar`, `created_unix`, `updated_unix` FROM `repository` WHERE (id > 0) [] - 823.371386ms
2020/06/18 19:19:57 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT label.id FROM `label` WHERE label.num_issues!=(SELECT COUNT(*) FROM `issue_label` WHERE label_id=label.id) [] - 277.201µs
2020/06/18 19:19:57 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `user`.id FROM `user` WHERE `user`.num_repos!=(SELECT COUNT(*) FROM `repository` WHERE owner_id=`user`.id) [] - 207.739µs
2020/06/18 19:19:57 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] INSERT INTO `notice` (`type`,`description`,`created_unix`) VALUES (?, ?, ?) [2 Cron: Update migration poster IDs has finished 1592507996] - 1.047833761s
2020/06/18 19:19:57 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `issue`.id FROM `issue` WHERE `issue`.num_comments!=(SELECT COUNT(*) FROM `comment` WHERE issue_id=`issue`.id AND type=0) [] - 342.422µs
2020/06/18 19:19:58 ...xer/stats/indexer.go:38:populateRepoIndexer() [I] Populating the repo stats indexer with existing repositories
2020/06/18 19:19:58 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] INSERT INTO `notice` (`type`,`description`,`created_unix`) VALUES (?, ?, ?) [2 Cron: Clean-up deleted branches has finished 1592507997] - 703.719205ms
2020/06/18 19:19:58 ...er/issues/indexer.go:221:func3() [I] Issue Indexer Initialization took 1.00377376s
2020/06/18 19:19:58 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT * FROM `repository`  LIMIT 1 [] - 255.217616ms
2020/06/18 19:19:58 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT repo.id FROM `repository` repo WHERE repo.num_closed_issues!=(SELECT COUNT(*) FROM `issue` WHERE repo_id=repo.id AND is_closed=? AND is_pull=?) [true false] - 408.504085ms
2020/06/18 19:19:58 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT MAX(id) FROM `repository` LIMIT 1 [] - 159.11µs
2020/06/18 19:19:58 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `repository`.`id` FROM `repository` LEFT OUTER JOIN `repo_indexer_status` ON repository.id = repo_indexer_status.repo_id AND repo_indexer_status.indexer_type = ? WHERE repo_indexer_status.id IS NULL AND repository.is_empty=? AND repository.id<=? ORDER BY `repository`.`id` DESC LIMIT 50 [1 false 79] - 251.405µs
2020/06/18 19:19:58 ...xer/stats/indexer.go:84:populateRepoIndexer() [I] Done (re)populating the repo stats indexer with existing repositories
2020/06/18 19:19:58 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT repo.id FROM `repository` repo WHERE repo.num_closed_pulls!=(SELECT COUNT(*) FROM `issue` WHERE repo_id=repo.id AND is_closed=? AND is_pull=?) [true true] - 13.75609ms
2020/06/18 19:19:58 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT repo.id FROM `repository` repo WHERE repo.num_forks!=(SELECT COUNT(*) FROM `repository` WHERE fork_id=repo.id) [] - 264.405µs
2020/06/18 19:19:58 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `id`, `repo_id`, `hook_id`, `uuid`, `type`, `url`, `signature`, `payload_content`, `http_method`, `content_type`, `event_type`, `is_ssl`, `is_delivered`, `delivered`, `is_succeed`, `request_content`, `response_content` FROM `hook_task` WHERE (is_delivered=?) [false] - 289.612896ms
2020/06/18 19:19:59 routers/init.go:165:GlobalInit() [I] SQLite3 Supported
2020/06/18 19:19:59 routers/init.go:51:checkRunMode() [I] Run Mode: Production
2020/06/18 19:19:59 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `pull_request`.`id` FROM `pull_request` WHERE (status=?) [1] - 522.712818ms
2020/06/18 19:19:59 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] INSERT INTO `notice` (`type`,`description`,`created_unix`) VALUES (?, ?, ?) [2 Cron: Check all repository statistics has finished 1592507998] - 890.289723ms
2020/06/18 19:19:59 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `id`, `owner_id`, `owner_name`, `lower_name`, `name`, `description`, `website`, `original_service_type`, `original_url`, `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`, `status`, `is_fork`, `fork_id`, `is_template`, `template_id`, `size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `avatar`, `created_unix`, `updated_unix` FROM `repository` WHERE `id`=? LIMIT 1 [1] - 660.714156ms
2020/06/18 19:19:59 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT `id`, `repo_id`, `commit_sha`, `indexer_type` FROM `repo_indexer_status` WHERE (`indexer_type` = ?) AND `repo_id`=? LIMIT 1 [1 1] - 297.479µs
2020/06/18 19:20:00 ...m.io/xorm/core/db.go:277:ExecContext() [I] [SQL] INSERT INTO `notice` (`type`,`description`,`created_unix`) VALUES (?, ?, ?) [2 Cron: Delete old repository archives has finished 1592507999] - 254.666992ms
2020/06/18 19:20:00 cmd/web.go:161:runWeb() [I] Listen: http://0.0.0.0:3000
2020/06/18 19:20:00 cmd/web.go:164:runWeb() [I] LFS server enabled
...

@lafriks
Copy link
Member

lafriks commented Jun 18, 2020

could it be that gitea could not finish database migrations in time and gets killed by supervisor?

@ViRb3
Copy link
Author

ViRb3 commented Jun 18, 2020

That sounds plausible. How could I give it more time?

@lafriks
Copy link
Member

lafriks commented Jun 18, 2020

that should be in s6 superviser script, don't know much about it tho

@ViRb3
Copy link
Author

ViRb3 commented Jun 18, 2020

From https://github.com/just-containers/s6-overlay:

  • S6_KILL_FINISH_MAXTIME (default = 5000): The maximum time (in milliseconds) a script in /etc/cont-finish.d could take before sending a KILL signal to it. Take into account that this parameter will be used per each script execution, it's not a max time for the whole set of scripts.
  • S6_SERVICES_GRACETIME (default = 3000): How long (in milliseconds) s6 should wait services before sending a TERM signal.
  • S6_KILL_GRACETIME (default = 3000): How long (in milliseconds) s6 should wait to reap zombies before sending a KILL signal.

I will test it now and report back.

@ViRb3
Copy link
Author

ViRb3 commented Jun 18, 2020

My bad, it turns out that Gitea doesn't use s6-overlay as a Docker base image, so the above won't work. How should I change the kill times manually?

@lafriks
Copy link
Member

lafriks commented Jun 18, 2020

oh, did not notice it was in docker, sorry. Can't really comment much on this topic

@ViRb3
Copy link
Author

ViRb3 commented Jun 18, 2020

From https://skarnet.org/software/s6/servicedir.html:

An optional regular file named timeout-finish. If such a file exists, it must only contain an unsigned integer, which is the number of milliseconds after which the ./finish script, if it exists, will be killed with a SIGKILL. The default is 5000: finish scripts are killed if they're still alive after 5 seconds. A value of 0 allows finish scripts to run forever.

I have let it run now and will report back.

@ViRb3
Copy link
Author

ViRb3 commented Jun 18, 2020

So far it seems like Gitea took all of my Pi's RAM (4GB) and it has now OOM'ed, killing SSH.

@PKizzle
Copy link

PKizzle commented Jun 18, 2020 •
edited
Loading

I have the same memory issue on a RaspberryPi 3. It is not crashing the RaspberryPi, but uses almost all its RAM.
Furthermore the overall CPU usage is high (compared to 1.11)
Update: Now my RaspberryPi also gave up -> no response and 100% RAM usage

@ViRb3
Copy link
Author

ViRb3 commented Jun 18, 2020 •
edited
Loading

After hard restarting the Raspberry Pi I disabled all Docker services, leaving nearly all of the 4GB for Gitea to consume. So I started Gitea again, and to my surprise, within 30 seconds and less than 3GB usage, the migration completed, and everything is back to normal. No damage or data loss is evident. Perhaps it was nearly done when it OOM'd before the hard restart. While this worked out for me with 4GB RAM, I'm not sure people with less powerful SBCs would have the same luck. I will leave this open for discussion.

EDIT: Would using a different DB, e.g. MySQL, reduce the RAM usage?

@PKizzle
Copy link

PKizzle commented Jun 18, 2020 •
edited
Loading

I am using a memory limit now in Docker for my gitea setup. Hopefully the migration continues without issues
Update: The migration completed successfully and gitea is running just fine 🥳

@ViRb3
Copy link
Author

ViRb3 commented Jun 19, 2020

Just out of curiosity, how did you set the memory limits?

@lafriks
Copy link
Member

lafriks commented Jun 19, 2020

If it was memory issue, PR #11975 could probably resolve it

@PKizzle
Copy link

PKizzle commented Jun 19, 2020

Here a link to the docker documentation:
https://docs.docker.com/config/containers/resource_constraints/#limit-a-containers-access-to-memory

If you are using docker-compose you might want to take a look here:
https://docs.docker.com/compose/compose-file/#resources

@ViRb3
Copy link
Author

ViRb3 commented Jun 19, 2020 •
edited
Loading

Ah yes, but unfortunately these settings only work in Swarm mode as of Compose file version 3:

The options described here are specific to the deploy key and swarm mode.

I thought that you had found a different approach.

@PKizzle
Copy link

PKizzle commented Jun 19, 2020 •
edited
Loading

That's why I still use the old version of compose -> don't want to move to swarm
I am very sorry, but there is no other approach that I know of.

@stale
Copy link

stale bot commented Aug 23, 2020

This issue has been automatically marked as stale because it has not had recent activity. I am here to help clear issues left open even if solved or waiting for more insight. This issue will be closed if no further activity occurs during the next 2 weeks. If the issue is still valid just add a comment to keep it alive. Thank you for your contributions.

@stale stale bot added the issue/stale label Aug 23, 2020
@stale
Copy link

stale bot commented Sep 7, 2020

This issue has been automatically closed because of inactivity. You can re-open it if needed.

@stale stale bot closed this as completed Sep 7, 2020
@go-gitea go-gitea locked and limited conversation to collaborators Nov 24, 2020
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees
No one assigned
Labels
issue/stale
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@lafriks @ViRb3 @PKizzle