Troubleshooting interrupted data re-balance

Nicholas_Chamma

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?

R_McKeon

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.

Thanks,
Rory

Nicholas_Chamma

Alright, that worked. Thank you.

R_McKeon

You're welcome!

Adrian_Oprea_1

Thank you Nicholas for the post! But why is this   dbd_drop_all_workspaces not documented in the official docs. 
Thx

R_McKeon

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.

Thanks,
Rory

Adrian_Oprea_1

Great !
Already wrote it down

R_McKeon

Great idea!