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

Error when creating pull request or sending test email #567

New Issue
Closed
opened 2025-11-02 03:28:22 -06:00 by GiteaMirror · 7 comments
GiteaMirror commented 2025-11-02 03:28:22 -06:00
Owner
Copy Link

Originally created by @plessbd on GitHub (Mar 22, 2017).

  • Gitea version (or commit ref): master
  • Git version:
  • Operating system: centos
  • Database (use [x]):
    • PostgreSQL
    • MySQL
    • MSSQL
    • SQLite
  • Can you reproduce the bug at https://try.gitea.io:
    • Yes (provide example URL)
    • No
    • Not relevant
  • Log :
    gitea.log
    2017/03/22 15:37:42 [...gitea/models/repo.go:2041 CheckRepoStats()] [E] Update repository count 'num_watches'[22]: database table is locked: repository
    2017/03/22 15:37:42 [...gitea/models/repo.go:2041 CheckRepoStats()] [E] Update repository count 'num_watches'[27]: database table is locked: repository
    2017/03/22 15:37:42 [...gitea/models/repo.go:2041 CheckRepoStats()] [E] Update repository count 'num_watches'[28]: database table is locked: repository
    2017/03/22 15:37:42 [...gitea/models/repo.go:2041 CheckRepoStats()] [E] Update repository count 'num_watches'[33]: database table is locked: repository
    2017/03/22 15:37:42 [...gitea/models/repo.go:2041 CheckRepoStats()] [E] Update repository count 'num_watches'[41]: database table is locked: repository
    2017/03/22 15:37:42 [...gitea/models/repo.go:2041 CheckRepoStats()] [E] Update repository count 'num_watches'[44]: database table is locked: repository

xorm.log
2017/03/22 15:37:42 [W] Table user Column allow_create_organization db default is , struct default is 1
2017/03/22 15:37:42 [W] Table user Column diff_view_style db default is '''', struct default is ''
2017/03/22 15:37:42 [W] Table repository has column enable_wiki but struct has not related field
2017/03/22 15:37:42 [W] Table repository has column enable_external_wiki but struct has not related field
2017/03/22 15:37:42 [W] Table repository has column external_wiki_url but struct has not related field
2017/03/22 15:37:42 [W] Table repository has column enable_issues but struct has not related field
2017/03/22 15:37:42 [W] Table repository has column enable_external_tracker but struct has not related field
2017/03/22 15:37:42 [W] Table repository has column external_tracker_format but struct has not related field
2017/03/22 15:37:42 [W] Table repository has column external_tracker_style but struct has not related field
2017/03/22 15:37:42 [W] Table repository has column enable_pulls but struct has not related field
2017/03/22 15:37:42 [W] Table repository has column external_tracker_url but struct has not related field
2017/03/22 15:37:42 [W] Table issue_user has column repo_id but struct has not related field
2017/03/22 15:37:42 [W] Table issue_user has column milestone_id but struct has not related field
2017/03/22 15:37:42 [W] Table issue_user has column is_poster but struct has not related field
2017/03/22 15:37:42 [W] Table issue_user has column is_closed but struct has not related field

nginx.log
2017/03/22 15:37:42 [error] 10276#10276: *6981 upstream prematurely closed connection while reading response header from upstream, client: 128.205.40.197, server: domain.fqdn, request: "POST /git/ORG/REPO/compare/master...USER:BRANCH HTTP/1.1", upstream: "http://127.0.0.1:3000/ORG/REPO/compare/master...USER:BRANCH", host: "tas-tools-int-01.ccr.xdmod.org"

Description

When I create a pull request I end up getting a 503 from the nginx proxy I have in front of gitea

Not sure if something didnt work with my migration but the database errors seem wrong, and the pull request is still created and works

Originally created by @plessbd on GitHub (Mar 22, 2017). - Gitea version (or commit ref): master - Git version: - Operating system: centos - Database (use `[x]`): - [ ] PostgreSQL - [ ] MySQL - [ ] MSSQL - [X] SQLite - Can you reproduce the bug at https://try.gitea.io: - [ ] Yes (provide example URL) - [x] No - [ ] Not relevant - Log : gitea.log 2017/03/22 15:37:42 [...gitea/models/repo.go:2041 CheckRepoStats()] [E] Update repository count 'num_watches'[22]: database table is locked: repository 2017/03/22 15:37:42 [...gitea/models/repo.go:2041 CheckRepoStats()] [E] Update repository count 'num_watches'[27]: database table is locked: repository 2017/03/22 15:37:42 [...gitea/models/repo.go:2041 CheckRepoStats()] [E] Update repository count 'num_watches'[28]: database table is locked: repository 2017/03/22 15:37:42 [...gitea/models/repo.go:2041 CheckRepoStats()] [E] Update repository count 'num_watches'[33]: database table is locked: repository 2017/03/22 15:37:42 [...gitea/models/repo.go:2041 CheckRepoStats()] [E] Update repository count 'num_watches'[41]: database table is locked: repository 2017/03/22 15:37:42 [...gitea/models/repo.go:2041 CheckRepoStats()] [E] Update repository count 'num_watches'[44]: database table is locked: repository xorm.log 2017/03/22 15:37:42 [W] Table user Column allow_create_organization db default is , struct default is 1 2017/03/22 15:37:42 [W] Table user Column diff_view_style db default is '''', struct default is '' 2017/03/22 15:37:42 [W] Table repository has column enable_wiki but struct has not related field 2017/03/22 15:37:42 [W] Table repository has column enable_external_wiki but struct has not related field 2017/03/22 15:37:42 [W] Table repository has column external_wiki_url but struct has not related field 2017/03/22 15:37:42 [W] Table repository has column enable_issues but struct has not related field 2017/03/22 15:37:42 [W] Table repository has column enable_external_tracker but struct has not related field 2017/03/22 15:37:42 [W] Table repository has column external_tracker_format but struct has not related field 2017/03/22 15:37:42 [W] Table repository has column external_tracker_style but struct has not related field 2017/03/22 15:37:42 [W] Table repository has column enable_pulls but struct has not related field 2017/03/22 15:37:42 [W] Table repository has column external_tracker_url but struct has not related field 2017/03/22 15:37:42 [W] Table issue_user has column repo_id but struct has not related field 2017/03/22 15:37:42 [W] Table issue_user has column milestone_id but struct has not related field 2017/03/22 15:37:42 [W] Table issue_user has column is_poster but struct has not related field 2017/03/22 15:37:42 [W] Table issue_user has column is_closed but struct has not related field nginx.log 2017/03/22 15:37:42 [error] 10276#10276: *6981 upstream prematurely closed connection while reading response header from upstream, client: 128.205.40.197, server: domain.fqdn, request: "POST /git/ORG/REPO/compare/master...USER:BRANCH HTTP/1.1", upstream: "http://127.0.0.1:3000/ORG/REPO/compare/master...USER:BRANCH", host: "tas-tools-int-01.ccr.xdmod.org" ## Description When I create a pull request I end up getting a 503 from the nginx proxy I have in front of gitea Not sure if something didnt work with my migration but the database errors seem wrong, and the pull request is still created and works
GiteaMirror added the type/bug label 2025-11-02 03:28:22 -06:00
GiteaMirror commented 2025-11-02 03:28:23 -06:00
Author
Owner
Copy Link

@strk commented on GitHub (Mar 22, 2017):

@lunny sounds like another of those missing transactions ?

@strk commented on GitHub (Mar 22, 2017): @lunny sounds like another of those missing transactions ?
GiteaMirror commented 2025-11-02 03:28:23 -06:00
Author
Owner
Copy Link

@plessbd commented on GitHub (Mar 23, 2017):

So this has started to happen with sending a test email as well
A bit different in that if you do it once it fails, then the second time it works

==> gitea.log <==
2017/03/23 14:05:32 [...gitea/models/repo.go:2041 CheckRepoStats()] [E] Update repository count 'num_watches'[22]: database table is locked: repository
2017/03/23 14:05:32 [...gitea/models/repo.go:2041 CheckRepoStats()] [E] Update repository count 'num_watches'[27]: database table is locked: repository
2017/03/23 14:05:32 [...gitea/models/repo.go:2041 CheckRepoStats()] [E] Update repository count 'num_watches'[28]: database table is locked: repository
2017/03/23 14:05:32 [...gitea/models/repo.go:2041 CheckRepoStats()] [E] Update repository count 'num_watches'[33]: database table is locked: repository
2017/03/23 14:05:32 [...gitea/models/repo.go:2041 CheckRepoStats()] [E] Update repository count 'num_watches'[41]: database table is locked: repository
2017/03/23 14:05:32 [...gitea/models/repo.go:2041 CheckRepoStats()] [E] Update repository count 'num_watches'[44]: database table is locked: repository

==> xorm.log <==
2017/03/23 14:05:32 [W] Table user Column allow_create_organization db default is , struct default is 1
2017/03/23 14:05:32 [W] Table user Column diff_view_style db default is '''', struct default is ''
2017/03/23 14:05:32 [W] Table repository has column enable_wiki but struct has not related field
2017/03/23 14:05:32 [W] Table repository has column enable_external_wiki but struct has not related field
2017/03/23 14:05:32 [W] Table repository has column external_wiki_url but struct has not related field
2017/03/23 14:05:32 [W] Table repository has column enable_issues but struct has not related field
2017/03/23 14:05:32 [W] Table repository has column enable_external_tracker but struct has not related field
2017/03/23 14:05:32 [W] Table repository has column external_tracker_format but struct has not related field
2017/03/23 14:05:32 [W] Table repository has column external_tracker_style but struct has not related field
2017/03/23 14:05:32 [W] Table repository has column enable_pulls but struct has not related field
2017/03/23 14:05:32 [W] Table repository has column external_tracker_url but struct has not related field
2017/03/23 14:05:32 [W] Table issue_user has column repo_id but struct has not related field
2017/03/23 14:05:32 [W] Table issue_user has column milestone_id but struct has not related field
2017/03/23 14:05:32 [W] Table issue_user has column is_poster but struct has not related field
2017/03/23 14:05:32 [W] Table issue_user has column is_closed but struct has not related field

==> nginx.log <==
2017/03/23 14:05:32 [error] 10276#10276: *7245 upstream prematurely closed connection while reading response header from upstream, client: 128.205.40.197, server: DOMAIN, request: "POST /git/admin/config/test_mail HTTP/1.1", upstream: "http://127.0.0.1:3000/admin/config/test_mail", host: "DOMAIN"
@plessbd commented on GitHub (Mar 23, 2017): So this has started to happen with sending a test email as well A bit different in that if you do it once it fails, then the second time it works ``` ==> gitea.log <== 2017/03/23 14:05:32 [...gitea/models/repo.go:2041 CheckRepoStats()] [E] Update repository count 'num_watches'[22]: database table is locked: repository 2017/03/23 14:05:32 [...gitea/models/repo.go:2041 CheckRepoStats()] [E] Update repository count 'num_watches'[27]: database table is locked: repository 2017/03/23 14:05:32 [...gitea/models/repo.go:2041 CheckRepoStats()] [E] Update repository count 'num_watches'[28]: database table is locked: repository 2017/03/23 14:05:32 [...gitea/models/repo.go:2041 CheckRepoStats()] [E] Update repository count 'num_watches'[33]: database table is locked: repository 2017/03/23 14:05:32 [...gitea/models/repo.go:2041 CheckRepoStats()] [E] Update repository count 'num_watches'[41]: database table is locked: repository 2017/03/23 14:05:32 [...gitea/models/repo.go:2041 CheckRepoStats()] [E] Update repository count 'num_watches'[44]: database table is locked: repository ==> xorm.log <== 2017/03/23 14:05:32 [W] Table user Column allow_create_organization db default is , struct default is 1 2017/03/23 14:05:32 [W] Table user Column diff_view_style db default is '''', struct default is '' 2017/03/23 14:05:32 [W] Table repository has column enable_wiki but struct has not related field 2017/03/23 14:05:32 [W] Table repository has column enable_external_wiki but struct has not related field 2017/03/23 14:05:32 [W] Table repository has column external_wiki_url but struct has not related field 2017/03/23 14:05:32 [W] Table repository has column enable_issues but struct has not related field 2017/03/23 14:05:32 [W] Table repository has column enable_external_tracker but struct has not related field 2017/03/23 14:05:32 [W] Table repository has column external_tracker_format but struct has not related field 2017/03/23 14:05:32 [W] Table repository has column external_tracker_style but struct has not related field 2017/03/23 14:05:32 [W] Table repository has column enable_pulls but struct has not related field 2017/03/23 14:05:32 [W] Table repository has column external_tracker_url but struct has not related field 2017/03/23 14:05:32 [W] Table issue_user has column repo_id but struct has not related field 2017/03/23 14:05:32 [W] Table issue_user has column milestone_id but struct has not related field 2017/03/23 14:05:32 [W] Table issue_user has column is_poster but struct has not related field 2017/03/23 14:05:32 [W] Table issue_user has column is_closed but struct has not related field ==> nginx.log <== 2017/03/23 14:05:32 [error] 10276#10276: *7245 upstream prematurely closed connection while reading response header from upstream, client: 128.205.40.197, server: DOMAIN, request: "POST /git/admin/config/test_mail HTTP/1.1", upstream: "http://127.0.0.1:3000/admin/config/test_mail", host: "DOMAIN" ```
GiteaMirror commented 2025-11-02 03:28:23 -06:00
Author
Owner
Copy Link

@lunny commented on GitHub (Mar 24, 2017):

@strk this is not a transaction thing. It seems because there are two goroutines to operate sqlite database.

@lunny commented on GitHub (Mar 24, 2017): @strk this is not a transaction thing. It seems because there are two goroutines to operate sqlite database.
GiteaMirror commented 2025-11-02 03:28:23 -06:00
Author
Owner
Copy Link

@bkcsoft commented on GitHub (Jun 15, 2017):

Could you test if this fixes the issue? #1961 (applying the diff and building on v1.1.2 should be straight forward)

@bkcsoft commented on GitHub (Jun 15, 2017): Could you test if this fixes the issue? #1961 (applying the diff and building on v1.1.2 should be straight forward)
GiteaMirror commented 2025-11-02 03:28:23 -06:00
Author
Owner
Copy Link

@bkcsoft commented on GitHub (Jun 15, 2017):

Could you test if this fixes the issue? #1961

@bkcsoft commented on GitHub (Jun 15, 2017): Could you test if this fixes the issue? #1961
GiteaMirror commented 2025-11-02 03:28:23 -06:00
Author
Owner
Copy Link

@plessbd commented on GitHub (Jun 20, 2017):

@bkcsoft I will wait since @lunny said in #1434 that this might not be fixed.

I am also going to try to migrate to mysql instead as I now have a reason to. This will be interesting...

@plessbd commented on GitHub (Jun 20, 2017): @bkcsoft I will wait since @lunny said in #1434 that this might not be fixed. I am also going to try to migrate to mysql instead as I now have a reason to. This will be interesting...
GiteaMirror commented 2025-11-02 03:28:24 -06:00
Author
Owner
Copy Link

@lunny commented on GitHub (Jun 23, 2017):

continue via #2040

@lunny commented on GitHub (Jun 23, 2017): continue via #2040
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 type/bug
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#567
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?