Skip to main content

Database designer will not cancel thru MC

  • October 15, 2014
  • 5 replies
  • 10 views

RCasey
Forum|alt.badge.img+1
  • Participating Frequently
I have a designer running thru MC 7.0 and am unable to cancel the designer and delete the schemas. When I run the select dbd_drop_all_workspaces() It returns a 0. I was able to run another designer thru admintools and it completed with no issue but the MC dbd seems hung up.

5 replies

Nimmi_gupta
Forum|alt.badge.img
  • Participating Frequently
  • October 16, 2014
Can you check the MC log and share the error message. Or share the MC log. And what's  the vertica version are you running and how many nodes in the cluster? I will check in my lab too.

RCasey
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • October 16, 2014
I am on 7.01 and I have the 1 node community with this problem. Actually I have done a reset on MC thinking it would cure this to no avail. The V_ schemas are in the DB and MC (even after a reset) shows the status of DBD as "Building". I do have the selection of the cancel and delete buttons but when I select them nothing happens. I was able to use admintools and complete another build on the same DB even as MC shows the other one building.My DB is KSAFE=0.
I may have to open a support ticket on this.
Suggestions are greatly appreciated!
RCasey


Raul_1
Forum|alt.badge.img
  • Participating Frequently
  • October 16, 2014

RCasey
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • October 16, 2014
Raul, I was not aware of those commands as I am new to Vertica and have not yet been thru a lot of the documentation. I was able to finally get rid of that design by user the "SELECT DESIGNER_DROP_ALL_DESIGNS();" command. I appreciate your help on this!!
RCasey

RCasey
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • October 17, 2014
This has been resolved.