We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Troubleshooting interrupted data re-balance — Vertica Forum

Troubleshooting interrupted data re-balance

Nicholas_ChammaNicholas_Chamma
in General Discussion
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?

Comments

  • R_McKeonR_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_ChammaNicholas_Chamma
    Alright, that worked. Thank you.
  • R_McKeonR_McKeon
    You're welcome!
  • Adrian_Oprea_1Adrian_Oprea_1
    Thank you Nicholas for the post! But why is this   dbd_drop_all_workspaces not documented in the official docs. 
    Thx
  • R_McKeonR_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_1Adrian_Oprea_1
    Great !
    Already wrote it down :)
  • R_McKeonR_McKeon
    Great idea! :)

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...