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

Fresh install: users.go:60 ERROR: duplicate key value violates unique constraint "pg_class_relname_nsp_index" (SQLSTATE 23505) #436

Open
Rodasa opened this issue Apr 15, 2024 · 1 comment
Assignees

Comments

@Rodasa
Copy link

Rodasa commented Apr 15, 2024

Hello.
Installing in Ubuntu 22.04 fresh install, i have this error in some part of the installation.
Thanks for help!


./deploy/provision.sh -m prod -t self --nginx --postgres -E -R --tls-hostname "xx.xx.xx.xx" --admin-hostname "xx.xx.xx.xx" --password "admin"

[Install]
WantedBy=multi-user.target
Created symlink /etc/systemd/system/multi-user.target.wants/osctrl-api.service → /lib/systemd/system/osctrl-api.service.
[+] Creating environment prod

2024/04/15 15:47:18 /home/xxxxxxx/osctrl/users/users.go:60 ERROR: duplicate key value violates unique constraint "pg_class_relname_nsp_index" (SQLSTATE 23505)
[74.764ms] [rows:0] CREATE INDEX IF NOT EXISTS "idx_admin_users_deleted_at" ON "admin_users" ("deleted_at")
2024/04/15 15:47:18 Failed to AutoMigrate table (admin_users): ERROR: duplicate key value violates unique constraint "pg_class_relname_nsp_index" (SQLSTATE 23505)
rsabella@s1b1osquery1:~/osctrl$ users.go:60 ERROR: duplicate key value violates unique constraint "pg_class_relname_nsp_index" (SQLSTATE 23505)

@Rodasa
Copy link
Author

Rodasa commented Apr 19, 2024

Update.
There´s a problem with 22.04. I tested multiple times with fresh install, and there´s a problem with the use of posgres user.

@javuto javuto self-assigned this May 27, 2024
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

No branches or pull requests

2 participants