When I do that I see this:
ERROR: Unable to generate re-balance script.I'm guessing that's because the first re-balance I kicked off is still running or didn't clean up properly.
Workspace rebalance_data already exists
How can I get past this?
Troubleshooting interrupted data re-balance
+1I 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:
How can I get past this?
When I do that I see this:
How can I get past this?
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
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
+1Alright, that worked. Thank you.
You're welcome!
+1Thank you Nicholas for the post! But why is this dbd_drop_all_workspaces not documented in the official docs.
Thx
Thx
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
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
+1Great !
Already wrote it down
Already wrote it down
Great idea!
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
