Options

Issue with starting vertica DB

vaishnavav99vaishnavav99 Community Edition User

Issue : Could not start vertica db. The db fails with error message host report: Database path already in use: /data/vertica//

Scenario : We created a new ubuntu linux vm and configured and installed vertica.Database configured. We then try to detach the disk and reattach the disk from the previous vm and then try to start the database.

Any hint on figuring this out would be helpful

Tagged:

Answers

  • Options
    Bryan_HBryan_H Vertica Employee Administrator

    DId you also copy the admintools config from /opt/vertica/config on the old VM? That is necessary to point to the data, catalog, and other paths as well as define IP's. You may also need to re-IP with admintools if the node IP's changed.

  • Options
    vaishnavav99vaishnavav99 Community Edition User

    @Bryan_H As suggested we copied the configs corresponding to admintools and the db was up, however i am now unable to connect to the database. While trying to connect we now get Unable to connect to DB client on any host. We are unable to stop the database through admintools and commandline. Nor can i run the re-IP with admintools since the cluster and db is up.

  • Options
    SruthiASruthiA Vertica Employee Administrator

    could you please share the output of the following. does it show the right IP's for the corresponding vm's?

    admintools -t list_allnodes

  • Options
    vaishnavav99vaishnavav99 Community Edition User

    @SruthiA It gives IP of the old VM

  • Options
    SruthiASruthiA Vertica Employee Administrator

    it means that reip was not successful. we may need to review the issue via call. please open a support case.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file