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.

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

duplicate key value violates unique constraint on first start with wsgi workers/threads #249

Open
categulario opened this issue Apr 18, 2022 · 0 comments · Fixed by dathere/datapusher-plus#3

Comments

@categulario
Copy link
Contributor

If the database is not set and the first start of datapusher is done via wsgi with some workers/threads (as suggested by 'High availability setup') then just the first thread that tries to create the database succeeds and the rest fail with duplicate key value violates unique constraint.

If the number of threads and workers is reduced to 1 on first start then nothing breaks.

A possible fix for this would be to provide a command for database initialization like in CKAN

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant