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

Init fresh database fails #836

Closed
spwoodcock opened this issue Sep 20, 2023 · 3 comments
Closed

Init fresh database fails #836

spwoodcock opened this issue Sep 20, 2023 · 3 comments
Assignees
@nrjadkry
Labels
backend Related to backend code bug Something isn't working priority:critical Blocking current tasks or user workflow

Comments

@spwoodcock
Copy link
Member

Issue

When clearing and starting from a fresh database, I get error generating the tables:

2023-09-20 17:51:30.331 UTC [71] ERROR:  duplicate key value violates unique constraint "pg_type_typname_nsp_index"
2023-09-20 17:51:30.331 UTC [71] DETAIL:  Key (typname, typnamespace)=(userrole, 2200) already exists.
2023-09-20 17:51:30.331 UTC [71] STATEMENT:  CREATE TYPE userrole AS ENUM ('MAPPER', 'ADMIN', 'VALIDATOR', 'FIELD_ADMIN', 'ORGANIZATION_ADMIN', 'READ_ONLY')

Needs further testing.
@spwoodcock spwoodcock added bug Something isn't working backend Related to backend code labels Sep 20, 2023
@spwoodcock spwoodcock added the priority:critical Blocking current tasks or user workflow label Sep 21, 2023
@spwoodcock
Copy link
Member Author

Likely solved by #441 (or the following updated PR).

@susmina94
Copy link
Collaborator

@spwoodcock can you confirm and close this ?

@susmina94 susmina94 reopened this Oct 10, 2023
@spwoodcock
Copy link
Member Author

Yes this is solved by #878
Thanks for picking it up 👍

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@nrjadkry nrjadkry

Labels
backend Related to backend code bug Something isn't working priority:critical Blocking current tasks or user workflow
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@nrjadkry @spwoodcock @susmina94