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

Failed to dump database: pq: column "pin_order" does not exist #14930

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

Originally created by @michaelsovik on GitHub (Sep 6, 2025).

Description

When doing a dump in latest version 1.24.5:

2025/09/06 05:56:23 ...s/storage/storage.go:176:initAttachments() [I] Initialising Attachment storage with type: local
2025/09/06 05:56:23 ...les/storage/local.go:33:NewLocalStorage() [I] Creating new Local Storage at /data/gitea/attachments
2025/09/06 05:56:23 ...s/storage/storage.go:166:initAvatars() [I] Initialising Avatar storage with type: local
2025/09/06 05:56:23 ...les/storage/local.go:33:NewLocalStorage() [I] Creating new Local Storage at /data/gitea/avatars
2025/09/06 05:56:23 ...s/storage/storage.go:192:initRepoAvatars() [I] Initialising Repository Avatar storage with type: local
2025/09/06 05:56:23 ...les/storage/local.go:33:NewLocalStorage() [I] Creating new Local Storage at /data/gitea/repo-avatars
2025/09/06 05:56:23 ...s/storage/storage.go:186:initLFS() [I] Initialising LFS storage with type: local
2025/09/06 05:56:23 ...les/storage/local.go:33:NewLocalStorage() [I] Creating new Local Storage at /data/git/lfs
2025/09/06 05:56:23 ...s/storage/storage.go:198:initRepoArchives() [I] Initialising Repository Archive storage with type: local
2025/09/06 05:56:23 ...les/storage/local.go:33:NewLocalStorage() [I] Creating new Local Storage at /data/gitea/repo-archive
2025/09/06 05:56:23 ...s/storage/storage.go:208:initPackages() [I] Initialising Packages storage with type: local
2025/09/06 05:56:23 ...les/storage/local.go:33:NewLocalStorage() [I] Creating new Local Storage at /data/gitea/packages
2025/09/06 05:56:23 ...s/storage/storage.go:219:initActions() [I] Initialising Actions storage with type: local
2025/09/06 05:56:23 ...les/storage/local.go:33:NewLocalStorage() [I] Creating new Local Storage at /data/gitea/actions_log
2025/09/06 05:56:23 ...s/storage/storage.go:223:initActions() [I] Initialising ActionsArtifacts storage with type: local
2025/09/06 05:56:23 ...les/storage/local.go:33:NewLocalStorage() [I] Creating new Local Storage at /data/gitea/actions_artifacts
2025/09/06 05:56:23 cmd/dump.go:172:runDump() [I] Dumping local repositories... /data/git/repositories
2025/09/06 06:01:50 cmd/dump.go:217:runDump() [I] Dumping database...
2025/09/06 06:02:01 cmd/dump.go:102:fatal() [F] Failed to dump database: pq: column "pin_order" does not exist```

### Gitea Version

1.24.5

### Can you reproduce the bug on the Gitea demo site?

No

### Log Gist

_No response_

### Screenshots

_No response_

### Git Version

_No response_

### Operating System

_No response_

### How are you running Gitea?

Running in a container on Kubernetes cluster.

### Database

PostgreSQL
Originally created by @michaelsovik on GitHub (Sep 6, 2025). ### Description When doing a dump in latest version 1.24.5: ```gitea dump -c /data/gitea/conf/app.ini 2025/09/06 05:56:23 ...s/storage/storage.go:176:initAttachments() [I] Initialising Attachment storage with type: local 2025/09/06 05:56:23 ...les/storage/local.go:33:NewLocalStorage() [I] Creating new Local Storage at /data/gitea/attachments 2025/09/06 05:56:23 ...s/storage/storage.go:166:initAvatars() [I] Initialising Avatar storage with type: local 2025/09/06 05:56:23 ...les/storage/local.go:33:NewLocalStorage() [I] Creating new Local Storage at /data/gitea/avatars 2025/09/06 05:56:23 ...s/storage/storage.go:192:initRepoAvatars() [I] Initialising Repository Avatar storage with type: local 2025/09/06 05:56:23 ...les/storage/local.go:33:NewLocalStorage() [I] Creating new Local Storage at /data/gitea/repo-avatars 2025/09/06 05:56:23 ...s/storage/storage.go:186:initLFS() [I] Initialising LFS storage with type: local 2025/09/06 05:56:23 ...les/storage/local.go:33:NewLocalStorage() [I] Creating new Local Storage at /data/git/lfs 2025/09/06 05:56:23 ...s/storage/storage.go:198:initRepoArchives() [I] Initialising Repository Archive storage with type: local 2025/09/06 05:56:23 ...les/storage/local.go:33:NewLocalStorage() [I] Creating new Local Storage at /data/gitea/repo-archive 2025/09/06 05:56:23 ...s/storage/storage.go:208:initPackages() [I] Initialising Packages storage with type: local 2025/09/06 05:56:23 ...les/storage/local.go:33:NewLocalStorage() [I] Creating new Local Storage at /data/gitea/packages 2025/09/06 05:56:23 ...s/storage/storage.go:219:initActions() [I] Initialising Actions storage with type: local 2025/09/06 05:56:23 ...les/storage/local.go:33:NewLocalStorage() [I] Creating new Local Storage at /data/gitea/actions_log 2025/09/06 05:56:23 ...s/storage/storage.go:223:initActions() [I] Initialising ActionsArtifacts storage with type: local 2025/09/06 05:56:23 ...les/storage/local.go:33:NewLocalStorage() [I] Creating new Local Storage at /data/gitea/actions_artifacts 2025/09/06 05:56:23 cmd/dump.go:172:runDump() [I] Dumping local repositories... /data/git/repositories 2025/09/06 06:01:50 cmd/dump.go:217:runDump() [I] Dumping database... 2025/09/06 06:02:01 cmd/dump.go:102:fatal() [F] Failed to dump database: pq: column "pin_order" does not exist``` ### Gitea Version 1.24.5 ### Can you reproduce the bug on the Gitea demo site? No ### Log Gist _No response_ ### Screenshots _No response_ ### Git Version _No response_ ### Operating System _No response_ ### How are you running Gitea? Running in a container on Kubernetes cluster. ### Database PostgreSQL
GiteaMirror added the type/bugissue/needs-feedback labels 2025-11-02 11:26:04 -06:00
GiteaMirror commented 2025-11-02 11:26:05 -06:00
Author
Owner
Copy Link

@techknowlogick commented on GitHub (Sep 6, 2025):

Does the version in the database match the binary version?

@techknowlogick commented on GitHub (Sep 6, 2025): Does the version in the database match the binary version?
GiteaMirror commented 2025-11-02 11:26:06 -06:00
Author
Owner
Copy Link

@michaelsovik commented on GitHub (Sep 6, 2025):

Does the version in the database match the binary version?

You are right, it was not, I'm closing this issue, the backup image had a older version of the binary.. Sorry for the inconvenience

@michaelsovik commented on GitHub (Sep 6, 2025): > Does the version in the database match the binary version? You are right, it was not, I'm closing this issue, the backup image had a older version of the binary.. Sorry for the inconvenience
GiteaMirror commented 2025-11-02 11:26:06 -06:00
Author
Owner
Copy Link

@michaelsovik commented on GitHub (Sep 6, 2025):

User error

@michaelsovik commented on GitHub (Sep 6, 2025): User error
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 issue/needs-feedback 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#14930
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?