Troubleshooting interrupted data re-balance

I was running a data re-balance on a Vertica cluster using Admin Tools. Mid-operation, my SSH session was disconnected. I re-connected to the cluster and tried to run the re-balance operation again.

When I do that I see this:
    ERROR: Unable to generate re-balance script.
    Workspace rebalance_data already exists
I'm guessing that's because the first re-balance I kicked off is still running or didn't clean up properly.

How can I get past this?


  • Options
    Hello Nicholas,

    To remove all previously run (and hung) processes, you can do this from the vsql prompt:

    SELECT dbd_drop_all_workspaces();

    Once complete, please reattempt to run the rebalance script.

  • Options
    Alright, that worked. Thank you.
  • Options
    You're welcome!
  • Options
    Thank you Nicholas for the post! But why is this   dbd_drop_all_workspaces not documented in the official docs. 
  • Options
    Hello Adrian,

    A bug ticket is currently open to have this command added to our documentation. Hopefully it will be added in the near future.

  • Options
    Great !
    Already wrote it down :)
  • Options
    Great idea! :)

Leave a Comment

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