github-starred/gitea
2
0
Fork 0
mirror of https://github.com/go-gitea/gitea.git synced 2026-03-11 17:46:29 -05:00
Code Issues 2.6k Packages Projects Releases 100 Wiki Activity

Indexer fails to complete, Gitea restarts because Received signal 15; terminating. #6041

New Issue
Closed
opened 2025-11-02 06:43:29 -06:00 by GiteaMirror · 3 comments
GiteaMirror commented 2025-11-02 06:43:29 -06:00
Owner
Copy Link

Originally created by @sseneca on GitHub (Sep 23, 2020).

  • Gitea version (or commit ref): 1.12.4
  • Git version: n/a
  • Operating system: Arch Linux
  • Database (use [x]):
    • PostgreSQL
  • Can you reproduce the bug at https://try.gitea.io:
    • Not relevant
  • Log gist:
2020/09/23 20:36:14 ...er/issues/indexer.go:142:func2() [I] PID 17: Initializing Issue Indexer: bleve
2020/09/23 20:36:14 ...xer/stats/indexer.go:38:populateRepoIndexer() [I] Populating the repo stats indexer with existing repositories
2020/09/23 20:36:14 ...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=$1) [false] - 2.689617ms
2020/09/23 20:36:14 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT * FROM "repository"  LIMIT 1 [] - 3.09858ms
2020/09/23 20:36:14 ...er/issues/indexer.go:221:func3() [I] Issue Indexer Initialization took 355.291022ms
2020/09/23 20:36:14 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT count(*) FROM "repository" [] - 992.663µs
2020/09/23 20:36:14 ...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" ORDER BY id ASC LIMIT 64 [] - 1.508744ms
2020/09/23 20:36:14 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT "pull_request"."id" FROM "pull_request" WHERE (status=$1) [1] - 2.452402ms
2020/09/23 20:36:14 routers/init.go:162:GlobalInit() [I] SQLite3 Supported
2020/09/23 20:36:14 routers/init.go:50:checkRunMode() [I] Run Mode: Production
2020/09/23 20:36:14 cmd/web.go:161:runWeb() [I] Listen: https://0.0.0.0:3000
2020/09/23 20:36:14 ...s/graceful/server.go:55:NewServer() [I] Starting new server: tcp:0.0.0.0:3000 on PID: 17
2020/09/23 20:36:14 ...s/graceful/server.go:107:ListenAndServeTLS() [E] Failed to load https cert file  for tcp:0.0.0.0:3000: open : no such file or directory
2020/09/23 20:36:14 cmd/web.go:204:runWeb() [C] Failed to start server: open : no such file or directory
2020/09/23 20:36:14 cmd/web.go:206:runWeb() [I] HTTP Listener: 0.0.0.0:3000 Closed
2020/09/23 20:36:24 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893372 1600893382 1] - 4.243051ms
2020/09/23 20:36:34 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893382 1600893392 1] - 1.591276ms
2020/09/23 20:36:44 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893392 1600893402 1] - 2.669459ms
2020/09/23 20:36:54 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893402 1600893412 1] - 2.647897ms
2020/09/23 20:37:04 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893412 1600893422 1] - 2.511972ms
2020/09/23 20:37:14 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893422 1600893432 1] - 2.491545ms
2020/09/23 20:37:24 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893432 1600893442 1] - 2.890675ms
2020/09/23 20:37:34 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893442 1600893452 1] - 2.514742ms
2020/09/23 20:37:44 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893452 1600893462 1] - 2.561798ms
2020/09/23 20:37:54 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893462 1600893472 1] - 2.480137ms
2020/09/23 20:38:04 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893472 1600893482 1] - 2.249799ms
2020/09/23 20:38:14 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893482 1600893492 1] - 2.246995ms
2020/09/23 20:38:24 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893492 1600893502 1] - 2.674077ms
2020/09/23 20:38:34 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893502 1600893512 1] - 2.449634ms
2020/09/23 20:38:44 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893512 1600893522 1] - 2.57414ms
2020/09/23 20:38:54 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893522 1600893532 1] - 2.580861ms
2020/09/23 20:39:04 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893532 1600893542 1] - 2.253943ms
2020/09/23 20:39:14 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893542 1600893552 1] - 1.889597ms
2020/09/23 20:39:24 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893552 1600893562 1] - 2.558297ms
2020/09/23 20:39:34 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893562 1600893572 1] - 1.120665ms
2020/09/23 20:39:44 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893572 1600893582 1] - 2.498129ms
2020/09/23 20:39:54 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893582 1600893592 1] - 2.542032ms
2020/09/23 20:40:04 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893592 1600893602 1] - 2.662808ms
2020/09/23 20:40:14 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893602 1600893612 1] - 2.708734ms
2020/09/23 20:40:24 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893612 1600893622 1] - 2.580438ms
2020/09/23 20:40:34 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893622 1600893632 1] - 2.473408ms
2020/09/23 20:40:44 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893632 1600893642 1] - 2.516497ms
2020/09/23 20:40:54 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893642 1600893652 1] - 2.068148ms
2020/09/23 20:41:04 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893652 1600893662 1] - 2.552712ms
2020/09/23 20:41:06 ...eful/manager_unix.go:124:handleSignals() [W] PID 17. Received SIGTERM. Shutting down...
Received signal 15; terminating.

Description

I'm trying to install Gitea with the official Helm chart on my k8s cluster. Gitea gets to this point and then kills the indexing process, I'm guessing because it's taking too long. The cluster runs on btrfs so I thought copy-on-write may have been issue but I've put the DB on a dir with copy-on-write disabled (and tested moving Gitea's data there too), but the problem persists. So as it stands Gitea endlessly kills itself midway through indexing, restarts the pod, starts the indexing from the beginning, etc.

Originally created by @sseneca on GitHub (Sep 23, 2020). - Gitea version (or commit ref): 1.12.4 - Git version: n/a - Operating system: Arch Linux - Database (use `[x]`): - [x] PostgreSQL - Can you reproduce the bug at https://try.gitea.io: - [x] Not relevant - Log gist: ``` 2020/09/23 20:36:14 ...er/issues/indexer.go:142:func2() [I] PID 17: Initializing Issue Indexer: bleve 2020/09/23 20:36:14 ...xer/stats/indexer.go:38:populateRepoIndexer() [I] Populating the repo stats indexer with existing repositories 2020/09/23 20:36:14 ...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=$1) [false] - 2.689617ms 2020/09/23 20:36:14 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT * FROM "repository" LIMIT 1 [] - 3.09858ms 2020/09/23 20:36:14 ...er/issues/indexer.go:221:func3() [I] Issue Indexer Initialization took 355.291022ms 2020/09/23 20:36:14 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT count(*) FROM "repository" [] - 992.663µs 2020/09/23 20:36:14 ...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" ORDER BY id ASC LIMIT 64 [] - 1.508744ms 2020/09/23 20:36:14 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT "pull_request"."id" FROM "pull_request" WHERE (status=$1) [1] - 2.452402ms 2020/09/23 20:36:14 routers/init.go:162:GlobalInit() [I] SQLite3 Supported 2020/09/23 20:36:14 routers/init.go:50:checkRunMode() [I] Run Mode: Production 2020/09/23 20:36:14 cmd/web.go:161:runWeb() [I] Listen: https://0.0.0.0:3000 2020/09/23 20:36:14 ...s/graceful/server.go:55:NewServer() [I] Starting new server: tcp:0.0.0.0:3000 on PID: 17 2020/09/23 20:36:14 ...s/graceful/server.go:107:ListenAndServeTLS() [E] Failed to load https cert file for tcp:0.0.0.0:3000: open : no such file or directory 2020/09/23 20:36:14 cmd/web.go:204:runWeb() [C] Failed to start server: open : no such file or directory 2020/09/23 20:36:14 cmd/web.go:206:runWeb() [I] HTTP Listener: 0.0.0.0:3000 Closed 2020/09/23 20:36:24 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893372 1600893382 1] - 4.243051ms 2020/09/23 20:36:34 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893382 1600893392 1] - 1.591276ms 2020/09/23 20:36:44 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893392 1600893402 1] - 2.669459ms 2020/09/23 20:36:54 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893402 1600893412 1] - 2.647897ms 2020/09/23 20:37:04 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893412 1600893422 1] - 2.511972ms 2020/09/23 20:37:14 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893422 1600893432 1] - 2.491545ms 2020/09/23 20:37:24 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893432 1600893442 1] - 2.890675ms 2020/09/23 20:37:34 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893442 1600893452 1] - 2.514742ms 2020/09/23 20:37:44 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893452 1600893462 1] - 2.561798ms 2020/09/23 20:37:54 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893462 1600893472 1] - 2.480137ms 2020/09/23 20:38:04 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893472 1600893482 1] - 2.249799ms 2020/09/23 20:38:14 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893482 1600893492 1] - 2.246995ms 2020/09/23 20:38:24 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893492 1600893502 1] - 2.674077ms 2020/09/23 20:38:34 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893502 1600893512 1] - 2.449634ms 2020/09/23 20:38:44 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893512 1600893522 1] - 2.57414ms 2020/09/23 20:38:54 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893522 1600893532 1] - 2.580861ms 2020/09/23 20:39:04 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893532 1600893542 1] - 2.253943ms 2020/09/23 20:39:14 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893542 1600893552 1] - 1.889597ms 2020/09/23 20:39:24 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893552 1600893562 1] - 2.558297ms 2020/09/23 20:39:34 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893562 1600893572 1] - 1.120665ms 2020/09/23 20:39:44 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893572 1600893582 1] - 2.498129ms 2020/09/23 20:39:54 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893582 1600893592 1] - 2.542032ms 2020/09/23 20:40:04 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893592 1600893602 1] - 2.662808ms 2020/09/23 20:40:14 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893602 1600893612 1] - 2.708734ms 2020/09/23 20:40:24 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893612 1600893622 1] - 2.580438ms 2020/09/23 20:40:34 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893622 1600893632 1] - 2.473408ms 2020/09/23 20:40:44 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893632 1600893642 1] - 2.516497ms 2020/09/23 20:40:54 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893642 1600893652 1] - 2.068148ms 2020/09/23 20:41:04 ...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 >= $1 AND updated_unix < $2) AND status = $3 GROUP BY user_id [1600893652 1600893662 1] - 2.552712ms 2020/09/23 20:41:06 ...eful/manager_unix.go:124:handleSignals() [W] PID 17. Received SIGTERM. Shutting down... Received signal 15; terminating. ``` ## Description I'm trying to install Gitea with the official Helm chart on my k8s cluster. Gitea gets to this point and then kills the indexing process, I'm guessing because it's taking too long. The cluster runs on btrfs so I thought copy-on-write may have been issue but I've put the DB on a dir with copy-on-write disabled (and tested moving Gitea's data there too), but the problem persists. So as it stands Gitea endlessly kills itself midway through indexing, restarts the pod, starts the indexing from the beginning, etc.
GiteaMirror commented 2025-11-02 06:43:30 -06:00
Author
Owner
Copy Link

@techknowlogick commented on GitHub (Sep 23, 2020):

2020/09/23 20:36:14 cmd/web.go:161:runWeb() [I] Listen: https://0.0.0.0:3000
2020/09/23 20:36:14 ...s/graceful/server.go:55:NewServer() [I] Starting new server: tcp:0.0.0.0:3000 on PID: 17
2020/09/23 20:36:14 ...s/graceful/server.go:107:ListenAndServeTLS() [E] Failed to load https cert file  for tcp:0.0.0.0:3000: open : no such file or directory
2020/09/23 20:36:14 cmd/web.go:204:runWeb() [C] Failed to start server: open : no such file or directory
2020/09/23 20:36:14 cmd/web.go:206:runWeb() [I] HTTP Listener: 0.0.0.0:3000 Closed

seems important part of the above, where it is setup to use the https cert that doesn't exist. What is the content of your customized values that you are sending with helm?

I can't see any issues with the indexer (usually it fails with a specific error to indexer), how are you able to determine it was causing the failure? If you are certain it is you could try setting the indexer to use the DB instead of using bleve.

@techknowlogick commented on GitHub (Sep 23, 2020): ``` 2020/09/23 20:36:14 cmd/web.go:161:runWeb() [I] Listen: https://0.0.0.0:3000 2020/09/23 20:36:14 ...s/graceful/server.go:55:NewServer() [I] Starting new server: tcp:0.0.0.0:3000 on PID: 17 2020/09/23 20:36:14 ...s/graceful/server.go:107:ListenAndServeTLS() [E] Failed to load https cert file for tcp:0.0.0.0:3000: open : no such file or directory 2020/09/23 20:36:14 cmd/web.go:204:runWeb() [C] Failed to start server: open : no such file or directory 2020/09/23 20:36:14 cmd/web.go:206:runWeb() [I] HTTP Listener: 0.0.0.0:3000 Closed ``` seems important part of the above, where it is setup to use the https cert that doesn't exist. What is the content of your customized values that you are sending with helm? I can't see any issues with the indexer (usually it fails with a specific error to indexer), how are you able to determine it was causing the failure? If you are certain it is you could try setting the indexer to use the DB instead of using bleve.
GiteaMirror commented 2025-11-02 06:43:30 -06:00
Author
Owner
Copy Link

@sseneca commented on GitHub (Sep 23, 2020):

Here are the values I was using. I've since removed PROTOCOL: https, because https will be handled by the Ingress Controller, not by Gitea, and that actually fixed things.

I assumed it was the indexer because it was during indexing that it got the "signal 15", but obviously that was incorrect. Sorry for the noise!

@sseneca commented on GitHub (Sep 23, 2020): [Here are the values I was using](https://gitlab.com/sseneca/k8s-server/-/blob/517a19a822bbc892dc9e8ab2bbe7f1a348e331f9/releases/gitea/gitea.yaml#L14). I've since removed `PROTOCOL: https`, because https will be handled by the Ingress Controller, not by Gitea, and that actually fixed things. I assumed it was the indexer because it was during indexing that it got the "signal 15", but obviously that was incorrect. Sorry for the noise!
GiteaMirror commented 2025-11-02 06:43:30 -06:00
Author
Owner
Copy Link

@techknowlogick commented on GitHub (Sep 23, 2020):

@sseneca no worries :) glad I was able to rubber duck your debugging.

@techknowlogick commented on GitHub (Sep 23, 2020): @sseneca no worries :) glad I was able to rubber duck your debugging.
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#6041
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?