Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

bug: duplicate key errors for the clients.id constraint #230

Closed
geekbrother opened this issue Oct 2, 2023 · 1 comment · Fixed by #235 or #239
Closed

bug: duplicate key errors for the clients.id constraint #230

geekbrother opened this issue Oct 2, 2023 · 1 comment · Fixed by #235 or #239
Assignees
@geekbrother
Labels
accepted The issue has been accepted into the project

Comments

@geekbrother
Copy link
Contributor

We are still getting the following error for the clients.id unique key constraint violation despite removing clients with the id on client creation:

2023-10-02T06:36:29.837436Z ERROR responding with error (Store(Database(Database(PgDatabaseError { severity: Error, code: "23505", message: "duplicate key value violates unique constraint \"clients_pkey\""...

These errors appear rarely but still should be investigated.
@geekbrother geekbrother self-assigned this Oct 2, 2023
@arein arein added the accepted The issue has been accepted into the project label Oct 2, 2023
This was referenced Oct 3, 2023
Closed
Merged
Merged
@geekbrother geekbrother mentioned this issue Oct 6, 2023
Merged
3 tasks
@geekbrother
Copy link
Contributor Author

The number of errors decreased after pushing changes from #235 but still occurs. Advisory locks from #239 should be a possible complete fix for that.

@geekbrother geekbrother reopened this Oct 6, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@geekbrother geekbrother

Labels
accepted The issue has been accepted into the project
Projects
None yet
Milestone
No milestone
2 participants
@arein @geekbrother