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


Error deleting DBD design schema v_dbd — Vertica Forum

Error deleting DBD design schema v_dbd

I a cleaning up designs over the past 6 months.

SELECT DESIGNER_DROP_DESIGN ('jim091814'); 

gives me the error >> ERROR 6110:  A design/deployment process is currently executing in this design space

Trying to cancel the design does nothing - I suspect because the underlying schema is gone

SELECT DESIGNER_CANCEL_POPULATE_DESIGN ('jim091814');

select * from v_dbd_jim091814_jim091814.vs_output_event_history order by time_stamp desc limit 10

Last row says >> Design in progress and  User requested to cancel design

How can I delete this design ?

jim

Comments

  • Hi!

    Try
    • dbd_drop_deployment_design
    • dbd_cancel_populate_design
    I bet on a last one:

    ****
    select dbd_cancel_populate_design('<workspace name>','<design name>');
    select dbd_cancel_populate_design('<workspace name>','<design name>', '<force>');
    ****
    or
    ***
    select dbd_drop_deployment_design('<workspace name>','<design name>', 'default');
    ***
    (not sure)

    Regards.

  • SELECT DESIGNER_DROP_DESIGN ('<design name>',true); did the trick - thank you

Leave a Comment

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