Vertica crashes after upgrade to 7 :(

Moderator: NorbertKrupa

Post Reply
User avatar
janice
Intermediate
Intermediate
Posts: 51
Joined: Wed May 30, 2012 1:14 pm

Vertica crashes after upgrade to 7 :(

Post by janice » Fri Dec 13, 2013 4:49 pm

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!
Attachments
ErrorReport.txt
(6.04 KiB) Downloaded 639 times
Everyday is an adventure!

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Vertica crashes after upgrade to 7 :(

Post by JimKnicely » Sat Dec 14, 2013 12:28 pm

Hi Janice,

How are you querying the table?
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

User avatar
janice
Intermediate
Intermediate
Posts: 51
Joined: Wed May 30, 2012 1:14 pm

Re: Vertica crashes after upgrade to 7 :(

Post by janice » Thu Dec 19, 2013 2:04 am

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
Everyday is an adventure!

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Vertica crashes after upgrade to 7 :(

Post by JimKnicely » Thu Dec 19, 2013 1:11 pm

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.
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Vertica Premium Edition”