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

Installer cannot proceed unless dvndb is dropped #9888

Open
Asbjoedt opened this issue Sep 7, 2023 · 1 comment
Open

Installer cannot proceed unless dvndb is dropped #9888

Asbjoedt opened this issue Sep 7, 2023 · 1 comment
Labels
Feature: Installer Type: Suggestion an idea User Role: Sysadmin Installs, upgrades, and configures the system, connects via ssh

Comments

@Asbjoedt
Copy link

Asbjoedt commented Sep 7, 2023

What steps does it take to reproduce the issue?
Reinstall Dataverse in the terminal without first dropping the dvndb database, which was created through the initial installation.

  • When does this issue occur?
    During installer phase i.e. if your Dataverse installer failed somewhere in the process in your first try but it got past creating the database. Then when having fixed the issues and running the installer again, this issue will happen.

  • What happens?
    The terminal writes, that it cannot proceed because an existing database is found.

Then you have to stop installation and manually perform the following to remove the dvndb database:

psql -U postgres
DROP DATABASE dvndb;
\q

After this you can try to reinstall Dataverse,

  • To whom does it occur (all users, curators, superusers)?
    All system administrators.

  • What did you expect to happen?
    The installer should prompt the user to accept one of following choices: Reuse the existing database, drop existing database or cancel installation.

Which version of Dataverse are you using?
5.14

Postface
Thx to @DaftPug for work on this one.

@pdurbin
Copy link
Member

pdurbin commented Sep 7, 2023

@Asbjoedt I like your suggestion of prompting to reuse, drop or cancel.

By the way, drop the database is the first thing we list here: https://guides.dataverse.org/en/5.14/installation/installation-main.html#fresh-reinstall

But again, I agree, we could improve the installer as you suggest.

@pdurbin pdurbin added Type: Suggestion an idea Feature: Installer User Role: Sysadmin Installs, upgrades, and configures the system, connects via ssh labels Oct 13, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Feature: Installer Type: Suggestion an idea User Role: Sysadmin Installs, upgrades, and configures the system, connects via ssh
Projects
None yet
Development

No branches or pull requests

2 participants