Page 1 of 1

Vertica crashes after upgrade to 7 :(

Posted: Fri Dec 13, 2013 4:49 pm
by janice
Hi,

Anyone else having an issue with Vertica 7? I upgraded our DB from 6.1.3 to 7.0.0.

So far the DB has crashed twice while querying the vs_system_table.

I couldn't even restart the DB easily. I had to rollback to a previous epoch!

Re: Vertica crashes after upgrade to 7 :(

Posted: Sat Dec 14, 2013 12:28 pm
by JimKnicely
Hi Janice,

How are you querying the table?

Re: Vertica crashes after upgrade to 7 :(

Posted: Thu Dec 19, 2013 2:04 am
by janice
Hi Jim,

I created some tables based on Vertica DC tables and then tried copying data from the DC table into my local tables. But when querying the vs_system_internal table to get the names of the DC tables Vertica crashes! Very weird. I did the same thing in 6.1.3 and it worked fine :x

Re: Vertica crashes after upgrade to 7 :(

Posted: Thu Dec 19, 2013 1:11 pm
by JimKnicely
Janice,

When you rollback is it always to the same epoch? If so, try shutting down the DB cleanly and restarting. Then try querying the vs_system_tables table.