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

No correct sequences after re-importing database from SQLite3 to PostgreSQL #5862

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

Originally created by @blackandred on GitHub (Aug 17, 2020).

  • Gitea version (or commit ref): 1.12.3
  • Git version: 2.24.3
  • Operating system: Alpine (Docker)
  • 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 gist:
2020/08/17 19:20:27 ...ion/action/action.go:180:NotifyCreateRepository() [E] notify watchers '1/106': insert new actioner: pq: duplicate key value violates unique constraint "action_pkey"
2020/08/17 19:20:27 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT "id", "lower_name", "name", "full_name", "email", "keep_email_private", "email_notifications_preference", "passwd", "passwd_hash_algo", "must_change_password"
, "login_type", "login_source", "login_name", "type", "location", "website", "rands", "salt", "language", "description", "created_unix", "updated_unix", "last_login_unix", "last_repo_visibility", "max_repo_creation", "is_active", "is_admi
n", "is_restricted", "allow_git_hook", "allow_import_local", "allow_create_organization", "prohibit_login", "avatar", "avatar_email", "use_custom_avatar", "num_followers", "num_following", "num_stars", "num_repos", "num_teams", "num_membe
rs", "visibility", "repo_admin_change_team_access", "diff_view_style", "theme" FROM "user" WHERE "id"=$1 LIMIT 1 [1] - 1.110404ms
2020/08/17 19:20:27 ...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", "tem
plate_id", "size", "is_fsck_enabled", "close_issues_via_commit_in_any_branch", "topics", "avatar", "created_unix", "updated_unix" FROM "repository" WHERE "owner_id"=$1 AND "lower_name"=$2 LIMIT 1 [1 testowe] - 1.134095ms
2020/08/17 19:20:27 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT "id", "repo_id", "user_id", "mode" FROM "collaboration" WHERE "repo_id"=$1 AND "user_id"=$2 LIMIT 1 [106 1] - 644.65µs
2020/08/17 19:20:27 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT "id", "repo_id", "type", "config", "created_unix" FROM "repo_unit" WHERE (repo_id = $1) [106] - 608.982µs
2020/08/17 19:20:27 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT count(*) FROM "release" WHERE repo_id=$1 AND is_draft=$2 [106 false] - 640.102µs
2020/08/17 19:20:27 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT * FROM "user" INNER JOIN "team_user" ON "team_user".org_id="user".id INNER JOIN "team" ON "team".id="team_user".team_id WHERE ("team_user".uid=$1) AND ("team"
2020/08/17 19:20:34 ...o/xorm/session_tx.go:46:Rollback() [I] [SQL] ROLL BACK [] - 250.102µs
2020/08/17 19:20:34 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT "id", "lower_name", "name", "full_name", "email", "keep_email_private", "email_notifications_preference", "passwd", "passwd_hash_algo", "must_change_password"
, "login_type", "login_source", "login_name", "type", "location", "website", "rands", "salt", "language", "description", "created_unix", "updated_unix", "last_login_unix", "last_repo_visibility", "max_repo_creation", "is_active", "is_admi
n", "is_restricted", "allow_git_hook", "allow_import_local", "allow_create_organization", "prohibit_login", "avatar", "avatar_email", "use_custom_avatar", "num_followers", "num_following", "num_stars", "num_repos", "num_teams", "num_membe
rs", "visibility", "repo_admin_change_team_access", "diff_view_style", "theme" FROM "user" WHERE "id"=$1 LIMIT 1 [1] - 1.110657ms
2020/08/17 19:20:34 ...m.io/xorm/core/tx.go:36:BeginTx() [I] [SQL] BEGIN TRANSACTION [] - 246.075µs
2020/08/17 19:20:34 ...m.io/xorm/core/tx.go:157: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", "tem
plate_id", "size", "is_fsck_enabled", "close_issues_via_commit_in_any_branch", "topics", "avatar", "created_unix", "updated_unix" FROM "repository" WHERE "id"=$1 AND "owner_id"=$2 LIMIT 1 [107 1] - 987.512µs
2020/08/17 19:20:34 ...o/xorm/session_tx.go:46:Rollback() [I] [SQL] ROLL BACK [] - 302.06µs
2020/08/17 19:20:34 ...sitory/repository.go:23:CreateRepository() [E] Rollback deleteRepository: repository does not exist [id: 107, uid: 1, owner_name: , name: ]
2020/08/17 19:20:34 routers/repo/repo.go:176:handleCreateError() [E] CreatePost: watchRepo: pq: duplicate key value violates unique constraint "watch_pkey"

Description

I upgraded from Gogs 0.9.x to Gitea 1.12.3 by creating schema in Gitea 1.0.0, then copying only data from Gogs. Then I run through upgrade process minor release-by-minor-release from Gitea 1.0.0 to 1.12.3

Now whatever I do I have 500 error caused by incorrectly set up sequences. It seems that the sequences are even not correctly set up in the schema, probably not linked to the columns as resetting sequences does not work.

Tried already:

No luck.

Originally created by @blackandred on GitHub (Aug 17, 2020). - Gitea version (or commit ref): 1.12.3 - Git version: 2.24.3 - Operating system: Alpine (Docker) - Database (use `[x]`): - [x] PostgreSQL - [ ] MySQL - [ ] MSSQL - [ ] SQLite - Can you reproduce the bug at https://try.gitea.io: - [ ] Yes (provide example URL) - [x] No - [ ] Not relevant - Log gist: ``` 2020/08/17 19:20:27 ...ion/action/action.go:180:NotifyCreateRepository() [E] notify watchers '1/106': insert new actioner: pq: duplicate key value violates unique constraint "action_pkey" 2020/08/17 19:20:27 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT "id", "lower_name", "name", "full_name", "email", "keep_email_private", "email_notifications_preference", "passwd", "passwd_hash_algo", "must_change_password" , "login_type", "login_source", "login_name", "type", "location", "website", "rands", "salt", "language", "description", "created_unix", "updated_unix", "last_login_unix", "last_repo_visibility", "max_repo_creation", "is_active", "is_admi n", "is_restricted", "allow_git_hook", "allow_import_local", "allow_create_organization", "prohibit_login", "avatar", "avatar_email", "use_custom_avatar", "num_followers", "num_following", "num_stars", "num_repos", "num_teams", "num_membe rs", "visibility", "repo_admin_change_team_access", "diff_view_style", "theme" FROM "user" WHERE "id"=$1 LIMIT 1 [1] - 1.110404ms 2020/08/17 19:20:27 ...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", "tem plate_id", "size", "is_fsck_enabled", "close_issues_via_commit_in_any_branch", "topics", "avatar", "created_unix", "updated_unix" FROM "repository" WHERE "owner_id"=$1 AND "lower_name"=$2 LIMIT 1 [1 testowe] - 1.134095ms 2020/08/17 19:20:27 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT "id", "repo_id", "user_id", "mode" FROM "collaboration" WHERE "repo_id"=$1 AND "user_id"=$2 LIMIT 1 [106 1] - 644.65µs 2020/08/17 19:20:27 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT "id", "repo_id", "type", "config", "created_unix" FROM "repo_unit" WHERE (repo_id = $1) [106] - 608.982µs 2020/08/17 19:20:27 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT count(*) FROM "release" WHERE repo_id=$1 AND is_draft=$2 [106 false] - 640.102µs 2020/08/17 19:20:27 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT * FROM "user" INNER JOIN "team_user" ON "team_user".org_id="user".id INNER JOIN "team" ON "team".id="team_user".team_id WHERE ("team_user".uid=$1) AND ("team" 2020/08/17 19:20:34 ...o/xorm/session_tx.go:46:Rollback() [I] [SQL] ROLL BACK [] - 250.102µs 2020/08/17 19:20:34 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT "id", "lower_name", "name", "full_name", "email", "keep_email_private", "email_notifications_preference", "passwd", "passwd_hash_algo", "must_change_password" , "login_type", "login_source", "login_name", "type", "location", "website", "rands", "salt", "language", "description", "created_unix", "updated_unix", "last_login_unix", "last_repo_visibility", "max_repo_creation", "is_active", "is_admi n", "is_restricted", "allow_git_hook", "allow_import_local", "allow_create_organization", "prohibit_login", "avatar", "avatar_email", "use_custom_avatar", "num_followers", "num_following", "num_stars", "num_repos", "num_teams", "num_membe rs", "visibility", "repo_admin_change_team_access", "diff_view_style", "theme" FROM "user" WHERE "id"=$1 LIMIT 1 [1] - 1.110657ms 2020/08/17 19:20:34 ...m.io/xorm/core/tx.go:36:BeginTx() [I] [SQL] BEGIN TRANSACTION [] - 246.075µs 2020/08/17 19:20:34 ...m.io/xorm/core/tx.go:157: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", "tem plate_id", "size", "is_fsck_enabled", "close_issues_via_commit_in_any_branch", "topics", "avatar", "created_unix", "updated_unix" FROM "repository" WHERE "id"=$1 AND "owner_id"=$2 LIMIT 1 [107 1] - 987.512µs 2020/08/17 19:20:34 ...o/xorm/session_tx.go:46:Rollback() [I] [SQL] ROLL BACK [] - 302.06µs 2020/08/17 19:20:34 ...sitory/repository.go:23:CreateRepository() [E] Rollback deleteRepository: repository does not exist [id: 107, uid: 1, owner_name: , name: ] 2020/08/17 19:20:34 routers/repo/repo.go:176:handleCreateError() [E] CreatePost: watchRepo: pq: duplicate key value violates unique constraint "watch_pkey" ``` ## Description I upgraded from Gogs 0.9.x to Gitea 1.12.3 by creating schema in Gitea 1.0.0, then copying only data from Gogs. Then I run through upgrade process minor release-by-minor-release from Gitea 1.0.0 to 1.12.3 Now whatever I do I have 500 error caused by incorrectly set up sequences. It seems that the sequences are even not correctly set up in the schema, probably not linked to the columns as resetting sequences does not work. Tried already: - resetdb (REINDEX table) - https://wiki.postgresql.org/wiki/Fixing_Sequences No luck.
GiteaMirror commented 2025-11-02 06:38:45 -06:00
Author
Owner
Copy Link

@blackandred commented on GitHub (Aug 17, 2020):

Finally resolved by resetting sequences with help of https://github.com/go-gitea/gitea/issues/740#issuecomment-291453637
The query from official PostgreSQL wiki didn't work. I went through tables one-by-one and reset the sequences.

@blackandred commented on GitHub (Aug 17, 2020): Finally resolved by resetting sequences with help of https://github.com/go-gitea/gitea/issues/740#issuecomment-291453637 The query from official PostgreSQL wiki didn't work. I went through tables one-by-one and reset the sequences.
GiteaMirror commented 2025-11-02 06:38:45 -06:00
Author
Owner
Copy Link

@zeripath commented on GitHub (Aug 18, 2020):

I recall another problem with Postgres Sequences in the past and had to add the below to our test_fixtures code to get postgres to sort out the sequences:

61a172900e/models/test_fixtures.go (L70-L86)

(mentioned here in case others find this issue.)

@zeripath commented on GitHub (Aug 18, 2020): I recall another problem with Postgres Sequences in the past and had to add the below to our test_fixtures code to get postgres to sort out the sequences: https://github.com/go-gitea/gitea/blob/61a172900e871e4151c804f4dc242e8c4895a4d3/models/test_fixtures.go#L70-L86 (mentioned here in case others find this issue.)
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#5862
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?