Search found 118 matches

by becky
Wed Aug 14, 2013 4:26 pm
Forum: Vertica Database Administration
Topic: Complete List of Data Collector Tables
Replies: 5
Views: 11762

Complete List of Data Collector Tables

Hello,

Does anyone have a complete list of the available DC tables?
by becky
Fri Jul 19, 2013 7:13 pm
Forum: Vertica Database Administration
Topic: Vertica Nodes Randomly Fail
Replies: 23
Views: 117727

Re: Vertica Nodes Randomly Fail

Hi Scutter, I totally agree that CentOS work's with Vertica. I've set it up many times with out incident. Maybe it was the VM template I was using. It was not provided to me from the IT department. Anyway, I used Jim's query (http://www.vertica-forums.com/viewtopic.php?f=5&t=1194#p3818) to find out ...
by becky
Fri Jul 19, 2013 6:52 pm
Forum: Vertica Analytics
Topic: Vertica analytics
Replies: 4
Views: 22516

Re: Vertica analytics

Wow! That was a great post, BoMBaY! Thanks for sharing!
by becky
Fri Jul 19, 2013 6:51 pm
Forum: Vertica Database Administration
Topic: Vertica Nodes Randomly Fail
Replies: 23
Views: 117727

Re: Vertica Nodes Randomly Fail

Scutter,

Thanks a bunch for you help in this thread. I decided to drop all the nodes and use Red Hat as opposed to CentOS.

This time when I did the install I used the -T -S default options.

So far, the cluster has stayed up longer than ever on CentOS.

I'll keep you posted!
by becky
Wed Jul 17, 2013 4:02 pm
Forum: Vertica Database Administration
Topic: Vertica Nodes Randomly Fail
Replies: 23
Views: 117727

Re: Vertica Nodes Randomly Fail

Hi Scutter,

I renamed the /opt/vertica/config/vspread.conf to vspread.conf_old. Then I reinstalled Vertica. After the install, I checked the new vspread.conf file and it looks exactly the same as the old one.

Bummer...
by becky
Wed Jul 17, 2013 12:20 pm
Forum: Vertica Database Administration
Topic: Vertica Nodes Randomly Fail
Replies: 23
Views: 117727

Re: Vertica Nodes Randomly Fail

Hi,

Bad news... woke up this morning and all three nodes were down :( Seems like one failed, then later another failed bringing down the whole database.

This is baffling!
by becky
Wed Jul 17, 2013 3:59 am
Forum: Vertica Database Administration
Topic: Vertica Nodes Randomly Fail
Replies: 23
Views: 117727

Re: Vertica Nodes Randomly Fail

Hi Scutter, Sorry, I messed up on the first attempt at reconfiguring the spread. I re-ran the vertical_install like this: /opt/vertica/sbin/install_vertica -T -S default -s vertica01,vertica02,vertica03 -r vertica-6.1.2-0.x86_64.RHEL5.rpm Although, after running the above command, the /opt/vertica/c...

Go to advanced search