gitea
gitea copied to clipboard
go-gitea
pq: table tid from new index tuple (1,147) overlaps with invalid duplicate tuple at offset 202 of block 5 in index "UQE_topic_name"
Description
I self host gitea Version 1.21.3 (also on earlier versions) on Linux with PostgreSQL.
Every package projects of mine uses, I mirror locally as well. Sometimes, when I mirror such git repo (usually from Github) I get the following error message:
pq: table tid from new index tuple (1,147) overlaps with invalid duplicate tuple at offset 202 of block 5 in index "UQE_topic_name"
When I remove the repo, and try again, after several attempts it will work.
There is no specific way to reproduce it, because it does not happens in consistent matter.
Gitea Version
1.21.3
Can you reproduce the bug on the Gitea demo site?
No
Log Gist
https://gist.github.com/ik5/41bfff2c0c037a8a2a63232682928c9a
Screenshots
No response
Git Version
2.39.3
Operating System
Rocky Linux
How are you running Gitea?
Standalone using systemd and with configuration file
Database
PostgreSQL
After migrating to PG 16, there were many duplicate topics (with the "semaphore" counting) some were with the value 1, and others with much more.
I unified them by hand, and at the moment there are no duplication errors.
Then I upgraded gitea to v1.21.5, and at the moment things looking good, but I will give it more time to see if the issue was old migration or another issue.
I think that there was an issue with the migration from old gitea to newer versions, can't reproduce it after removing duplicates by hand.