Skip to content

PostgreSQL Error in email_hash table: "doppelter Schlüsselwert verletzt Unique-Constraint" #12937

Closed
@somera

Description

@somera
  • Gitea version (or commit ref): 1.12.4
  • Git version: 2.25.1
  • Operating system: Ubuntu 20.04
  • 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:

Description

I'm mirroring a lot of GitHub projects. And in PostgreSQL logs I see this error:

2020-09-24 19:45:52.473 CEST [53703] gitea@giteadb DETAIL: Schlüssel »(hash)=(e3df20cd7a67969c41a65f03bea54961)« existiert bereits. 2020-09-24 19:45:52.473 CEST [53703] gitea@giteadb ANWEISUNG: INSERT INTO "email_hash" ("hash","email") VALUES ($1, $2) 2020-09-24 19:45:52.481 CEST [34263] gitea@giteadb LOG: Ausführen <unnamed>: INSERT INTO "email_hash" ("hash","email") VALUES ($1, $2) 2020-09-24 19:45:52.481 CEST [34263] gitea@giteadb DETAIL: Parameter: $1 = '5286ca631fff30960bfc2b337144556f', $2 = 'xx@xxxxxxx' 2020-09-24 19:45:52.481 CEST [34263] gitea@giteadb FEHLER: doppelter Schlüsselwert verletzt Unique-Constraint »email_hash_pkey«

Screenshots

Metadata

Metadata

Assignees

No one assigned

    Labels

    issue/duplicateThe issue has already been reported.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions