Skip to content
This repository was archived by the owner on Apr 26, 2024. It is now read-only.
This repository was archived by the owner on Apr 26, 2024. It is now read-only.

Lots of psql duplicate key errors for device_uniqueness and users_name_key #5961

@richvdh

Description

@richvdh

We get thousands of these a day:

2019-09-02 00:00:03.009 UTC [matrix main] ERROR:  duplicate key value violates unique constraint "device_uniqueness"
2019-09-02 00:00:04.622 UTC [matrix main] ERROR:  duplicate key value violates unique constraint "users_name_key"

They are due (I think) to our poor man's upsert impl, which we should replace with a proper upsert.

Metadata

Metadata

Assignees

No one assigned

    Labels

    A-LoggingSynapse's logs (structured or otherwise). Not metrics.T-TaskRefactoring, removal, replacement, enabling or disabling functionality, other engineering tasks.z-p2(Deprecated Label)

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions