Skip to content

ERROR: duplicate key value violates unique constraint \"allocation_connections_pkey\" #218

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
Closed
cnlangzi opened this issue Jun 21, 2021 · 1 comment
Closed

ERROR: duplicate key value violates unique constraint \"allocation_connections_pkey\" #218

cnlangzi opened this issue Jun 21, 2021 · 1 comment
Assignees
@cnlangzi
Labels
ready-on-dayi/main

Comments

@cnlangzi
Copy link
Contributor

cnlangzi commented Jun 21, 2021 •
edited
Loading

Postgres blocks new connection when it was marked as DeletedConnection in workers (eg CleanupTempFiles).

it is caused by #219

{"code":"connection_write_error","error":"connection_write_error: ERROR: duplicate key value violates unique constraint \"allocation_connections_pkey\" (SQLSTATE 23505)"

blobber/code/go/0chain.net/blobbercore/allocation/allocationchange.go

Line 110 in 251c354

if errors.Is(err, gorm.ErrRecordNotFound) {

@cnlangzi
Copy link
Contributor Author

cnlangzi commented Oct 2, 2021

it is fixed on #344

@cnlangzi cnlangzi closed this as completed Oct 2, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@cnlangzi cnlangzi

Labels
ready-on-dayi/main
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@cnlangzi