The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

How do I clean up after an aborted database designer session?

During a designer session I think my connections were exhausted because I got: ERROR: Could not connect to database so I had to control C out of DBD I see that the design tables are still there and the last “phase_setup” column in select * from design reads “Design/Deployment Cancelled by user” New DBD runs fail because the DB thinks another design is actively in progress. How can I clean this up ? I think there’s a function somewhere.

Comments

  • You can clean up after the first DBD session by running this command: SELECT dbd_drop_all_workspaces();

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.