Upgrade Vertica 7.1.2 to 7.2.1

Moderator: NorbertKrupa

chenshaulian
Intermediate
Intermediate
Posts: 51
Joined: Wed Sep 09, 2015 9:34 am

Upgrade Vertica 7.1.2 to 7.2.1

Post by chenshaulian » Mon Jan 04, 2016 12:57 pm

Hi,

I'm trying to upgrade my Vertica environment from version 7.1.2 to version 7.2.1.
After I installed the new HP Vertica Server RPM, by command:
rpm -Uvh /home/dbadmin/vertica-x86_64.RHEL6.rpm

I'm running the upgrade command:
/opt/vertica/sbin/update_vertica --rpm /home/dbadmin/vertica-7.2.1-0.x86_64.RHEL6.rpm

Than I'm getting the following error:
>> Validating software versions (rpm or deb)...

RPM must be upgraded locally, first.
Local version = 7.1.2-000
RPM version = 7.2.1-000
Installation FAILED with errors
.

Why? :(
Do I need to upgrade to 7.2.0 first?

Your help please.
Thanks
Chen

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: Upgrade Vertica 7.1.2 to 7.2.1

Post by NorbertKrupa » Mon Jan 04, 2016 3:19 pm

Did you install dialog? See this post.
Checkout vertica.tips for more Vertica resources.

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

Re: Upgrade Vertica 7.1.2 to 7.2.1

Post by JimKnicely » Mon Jan 04, 2016 3:20 pm

Hi,


According top the 7.2.x documentation, you can upgrade 7.1 to 7.2.

See:

http://my.vertica.com/docs/7.2.x/HTML/i ... ersion.htm

Try running the command rpm -qa | grep vertica to see if there are multiple rpm's installed. If so, uninstall the older one.
Jim Knicely

Image

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

chenshaulian
Intermediate
Intermediate
Posts: 51
Joined: Wed Sep 09, 2015 9:34 am

Re: Upgrade Vertica 7.1.2 to 7.2.1

Post by chenshaulian » Tue Jan 05, 2016 9:54 am

Hi,

thanks for your answers.

NorbertKrupa, yes I installed the dialog ... you can't installed the new HP Vertica Server RPM (vertica-7.2.1-0.x86_64.RHEL6.rpm)

JimKnicely, When I'm running the rpm -qa | grep vertica command, I'm getting:
vertica-7.1.2-0.x86_64 (the correct running Vertica version)
vertica-console-7.1.2-0.x86_64

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

Re: Upgrade Vertica 7.1.2 to 7.2.1

Post by JimKnicely » Tue Jan 05, 2016 6:34 pm

Hi,

How many nodes are in your cluster? If > 1, try running the "rpm -qa | grep vertica" command on each node. I bet one of them night have the older RPM.
Jim Knicely

Image

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

chenshaulian
Intermediate
Intermediate
Posts: 51
Joined: Wed Sep 09, 2015 9:34 am

Re: Upgrade Vertica 7.1.2 to 7.2.1

Post by chenshaulian » Mon Jan 11, 2016 8:59 am

Hi Jim,

I have 3 node cluster.
if I run "rpm -qa | grep vertica" I'm getting the current version of Vertica that I have on the environment "vertica-7.1.2-0.x86_64" (on each node).

Now I want to upgrade this version, so:
1. I stopped the database.
2. I installed the new HP Vertica Server RPM - "rpm -Uvh /home/dbadmin/vertica-7.2.1-0.x86_64.RHEL6.rpm"
3. Now ... When I try to run "/opt/vertica/sbin/update_vertica --rpm /home/dbadmin/vertica-7.2.1-0.x86_64.RHEL6.rpm" to upgrade the current Vertica version from 7.1.2 to 7.2.1ת I'm getting the error
"RPM must be upgraded locally, first.
Local version = 7.1.2-000
RPM version = 7.2.1-000
Installation FAILED with errors."

I don't need to uninstall the 7.1.2 version to upgrade to 7.2.1 ... right ? so why I'm getting this error??? :(

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: Upgrade Vertica 7.1.2 to 7.2.1

Post by id10t » Mon Jan 11, 2016 11:23 am

Shalom!

https://my.vertica.com/docs/7.1.x/HTML/ ... ersion.htm

[...]
3. On each host that you have an additional package installed, such as the R Language Pack, uninstall the package. For example: rpm -e vertica-R-lang.
[...]
5. As root or sudo, run update_vertica. Use the same options that you used when you last installed or upgraded the database, except for the --hosts/-s host_list parameter, as the upgrade script automatically determines the hosts in the cluster.

If you forgot the options that were last used, open /opt/vertica/config/admintools.conf in a text editor and find the line that starts with install_opts. This line details each option. It is important to use the same options that were used previously as omitting any options used previously causes them to revert to their default setting when the upgrade script runs. Also, if you use different options than originally used, then the update script reconfigures the cluster to use the new options, which can cause issues with your existing database.

**********
1. Try to stop and uninstall console, may be dependency is hard coded in RPM.
2. Please, post output of:

Code: Select all

grep 'install' /opt/vertica/config/admintools.conf
3. Please, post current version of each node.


Yom tov.

Post Reply

Return to “Vertica Database Administration”