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
Upgrade Vertica 7.1.2 to 7.2.1
Moderator: NorbertKrupa
-
- Intermediate
- Posts: 51
- Joined: Wed Sep 09, 2015 9:34 am
-
- 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
Did you install dialog? See this post.
Checkout vertica.tips for more Vertica resources.
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Upgrade Vertica 7.1.2 to 7.2.1
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.
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
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
-
- Intermediate
- Posts: 51
- Joined: Wed Sep 09, 2015 9:34 am
Re: Upgrade Vertica 7.1.2 to 7.2.1
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
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
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Upgrade Vertica 7.1.2 to 7.2.1
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.
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
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
-
- Intermediate
- Posts: 51
- Joined: Wed Sep 09, 2015 9:34 am
Re: Upgrade Vertica 7.1.2 to 7.2.1
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???
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???
Re: Upgrade Vertica 7.1.2 to 7.2.1
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:
3. Please, post current version of each node.
Yom tov.
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
Yom tov.