Database Designer Issue in Vertica 6

[Julie]

Hi all,

I am trying to run Database Designer in Vertica 6 for specific queries. When I get to the point where it asks me what k safe level I want it won't let me enter a value of 1. If I do enter a 1 and continue then I get the error that you see in my attachment.

Does anyone know what it means?

[jpcavanaugh]

It looks like your system is already marked with a k-safety level that is not 1. To see the current design level, run this query.

select designed_fault_tolerance from system;

[Julie]

Thanks, foo!

Code: Select all

dbadmin=> select designed_fault_tolerance from system;
 designed_fault_tolerance
--------------------------
                        0
(1 row)

Yikes! How did that happen? We have three nodes... I'm re-running a comprehensive database design now! Hopefully this will set my k-safety back to one...

[jpcavanaugh]

You may already have the projections in place to be K-Safe 1 ... an easy way to test that is to run:

Code: Select all

select mark_design_ksafe(1);

You will get one of the following messages (from doc):

If you specify a k value of one (1) or two (2), Vertica returns one of the following messages.

Success:
Marked design n-safe

Failure:
The schema does not meet requirements for K=n.
Fact table projection projection-name has insufficient "buddy" projections.

n in the message is 1 or 2 and represents the k value.

[Julie]

Hi foo (hey, your username changed all of the sudden )

Anyway, you were right!

When I ran the select mark_design_ksafe(1) command there were a bunch of projections that were not k-safe. But after re-running a full admintools database designer run, I'm back to a k safety of 1!

Code: Select all

dbadmin=> select mark_design_ksafe(1);
  mark_design_ksafe
----------------------
 Marked design 1-safe
(1 row)

Thanks for your help!

[jpcavanaugh]

Glad it worked!

I changed my username to have my real name in it for peops on here ... makes it easier for some