<div dir="ltr"><div><div><div><div>Hi Marcelo, <br><br></div>I already upgraded to version 4.2 in a new installation, but I couldn't restore my backup, so I will do the config from scratch <br><br></div><span style="color:rgb(7,55,99)"><i>engine-backup --mode=restore --scope=all --file=pgbackup --log=restore_log --restore-permissions<br>Preparing to restore:<br>- Unpacking file 'pgbackup'<br>FATAL: Backup was created by version '4.1' and can not be restored using the installed version 4.2</i></span><br><br><br></div>Thank you all for your help. <br><br></div>BR<br></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Apr 26, 2018 at 3:50 PM, Marcelo Leandro <span dir="ltr"><<a href="mailto:marceloltmm@gmail.com" target="_blank">marceloltmm@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hello,<div><br></div><div>I try only did an clean install in another server with steps:</div><div><br></div><div>my host is a Centos 7 with LANG = LANG= english</div><div><br></div><div>commmand:</div><div><br></div><div><div>#locale</div><div>LANG=en_US.UTF-8</div><div>LC_CTYPE="en_US.UTF-8"</div><div>LC_NUMERIC="en_US.UTF-8"</div><div>LC_TIME="en_US.UTF-8"</div><div>LC_COLLATE="en_US.UTF-8"</div><div>LC_MONETARY="en_US.UTF-8"</div><div>LC_MESSAGES="en_US.UTF-8"</div><div>LC_PAPER="en_US.UTF-8"</div><div>LC_NAME="en_US.UTF-8"</div><div>LC_ADDRESS="en_US.UTF-8"</div><div>LC_TELEPHONE="en_US.UTF-8"</div><div>LC_MEASUREMENT="en_US.UTF-8"</div><div>LC_IDENTIFICATION="en_US.UTF-<wbr>8"</div><div>LC_ALL=</div></div><div><br></div><div><br></div><div>1-yum install <a href="http://resources.ovirt.org/pub/yum-repo/ovirt-release41.rpm" target="_blank">http://resources.ovirt.org/<wbr>pub/yum-repo/ovirt-release41.<wbr>rpm</a></div><div>2-yum update</div><div>3-yum install ovirt-engine -y</div><div>4-engine-setup --accept-defaults</div><div>5-engine-cleanup</div><div>6- engine-backup --mode=restore --no-restore-permissions --provision-db --provision-dwh-db --provision-reports-db --file=engine-backup.tar.gz --log=engine-backup-restore.<wbr>log</div><div><br></div><div>and upgrade now:</div><div><br></div><div>1-yum install <a href="http://resources.ovirt.org/pub/yum-repo/ovirt-release42.rpm" target="_blank">http://resources.ovirt.org/<wbr>pub/yum-repo/ovirt-release42.<wbr>rpm</a></div><div>2-yum update "ovirt-*-setup*"</div><div>3- engine-setup</div><div><br></div><div>It`s works for me.</div><div><br></div><div><br></div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">2018-04-26 9:12 GMT-03:00 Marcelo Leandro <span dir="ltr"><<a href="mailto:marceloltmm@gmail.com" target="_blank">marceloltmm@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="auto">Do you have a full backup ?<div dir="auto"><br></div><div dir="auto">If yes, I think if possible better configure a new Server and restore.</div></div><div class="m_-1821534592475963449HOEnZb"><div class="m_-1821534592475963449h5"><div class="gmail_extra"><br><div class="gmail_quote">Em 26 de abr de 2018 09:00, "Aziz" <<a href="mailto:azizgstest@gmail.com" target="_blank">azizgstest@gmail.com</a>> escreveu:<br type="attribution"><blockquote class="m_-1821534592475963449m_-2486310531759677991quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>Thanks Marcelo for the feedback, <br><br></div><div>In my case some of the components are already upgraded to 4.2, including cleanup engine, therefore I got the following error : <br><br>engine-cleanup<br>[ INFO ] Stage: Initializing<br>[ INFO ] Stage: Environment setup<br> Configuration files: ['/etc/ovirt-engine-setup.conf<wbr>.d/10-packaging-jboss.conf', '/etc/ovirt-engine-setup.conf.<wbr>d/10-packaging.conf', '/etc/ovirt-engine-setup.conf.<wbr>d/20-setup-ovirt-post.conf']<br> Log file: /var/log/ovirt-engine/setup/ov<wbr>irt-engine-remove-201804261355<wbr>55-m68ygc.log<br> Version: otopi-1.7.7 (otopi-1.7.7-1.el7.centos)<br><span style="background-color:rgb(255,0,0)">[ ERROR ] </span>Cleanup utility and installed version mismatch<br> Please use a version of cleanup utility that matches the engine installed version (now engine-cleanup 4.2.2.6, engine 4.1.9.1)<br><span style="background-color:rgb(255,0,0)">[ ERROR ] </span>Failed to execute stage 'Environment setup': Cleanup utility version mismatch<br>[ INFO ] Stage: Clean up<br> Log file is located at /var/log/ovirt-engine/setup/ov<wbr>irt-engine-remove-201804261355<wbr>55-m68ygc.log<br>[ INFO ] Generating answer file '/var/lib/ovirt-engine/setup/a<wbr>nswers/20180426135556-cleanup.<wbr>conf'<div class="m_-1821534592475963449m_-2486310531759677991quoted-text"><br>[ INFO ] Stage: Pre-termination<br>[ INFO ] Stage: Termination<br></div><span style="background-color:rgb(255,0,0)">[ ERROR ] </span>Execution of cleanup failed<br><br><br></div><div>Is there a way to downgrade ? <br><br><br></div><div>Thanks <br></div></div><div class="m_-1821534592475963449m_-2486310531759677991elided-text"><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Apr 26, 2018 at 12:49 PM, Marcelo Leandro <span dir="ltr"><<a href="mailto:marceloltmm@gmail.com" rel="noreferrer" target="_blank">marceloltmm@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>I am had the same problem, is a problem in database structure. In my lab I followed this steps:</div><div><br></div><div>FOLLOW THIS STEP IN A LAB FIRST:</div><div><br></div><div>Full backup before the upgrade engine:</div><div><br></div><div>engine-backup --scope=all --mode=backup --file=file_name --log=log_file_name</div><div><br></div><div>after clean you engine config:</div><div><br></div><div>engine-cleanup</div><div><br></div><div><br></div><div>Change structure template 1</div><div><br></div><div>su - postgres</div><div><br></div><div>psql -U postgres</div><div><br></div><div>postgres=# update pg_database set datallowconn = TRUE where datname = 'template0';</div><div>UPDATE 1</div><div>postgres=# \c template0</div><div>You are now connected to database "template0".</div><div>template0=# update pg_database set datistemplate = FALSE where datname = 'template1';</div><div>UPDATE 1</div><div>template0=# drop database template1;</div><div>DROP DATABASE</div><div>template0=# create database template1 with owner=postgres encoding='UTF-8'</div><div> lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template0;</div><div>CREATE DATABASE</div><div>template0=# update pg_database set datistemplate = TRUE where datname = 'template1';</div><div>UPDATE 1</div><div>template0=# \c template1</div><div>You are now connected to database "template1".</div><div>template1=# update pg_database set datallowconn = FALSE where datname = 'template0';</div><div>UPDATE 1</div><div>template1=# \q</div><div><br></div><div>change structure template0</div><div><br></div><div>psql -U postgres</div><div>postgres=# update pg_database set datallowconn = TRUE where datname = 'template1';</div><div>UPDATE 1</div><div>postgres=# \c template1</div><div>You are now connected to database "template0".</div><div>template0=# update pg_database set datistemplate = FALSE where datname = 'template0';</div><div>UPDATE 1</div><div>template0=# drop database template0;</div><div>DROP DATABASE</div><div>template0=# create database template0 with owner=postgres encoding='UTF-8'</div><div> lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template1;</div><div>CREATE DATABASE</div><div>template0=# update pg_database set datistemplate = TRUE where datname = 'template0';</div><div>UPDATE 1</div><div>template0=# \c template0</div><div>You are now connected to database "template0".</div><div>template1=# update pg_database set datallowconn = FALSE where datname = 'template1';</div><div>UPDATE 1</div><div>template1=# \q</div><div><br></div><div><br></div><div>change estructure postgres</div><div><br></div><div>psql template0</div><div>1-drop database postgres;</div><div>2- create database postgres with owner=postgres encoding='UTF-8'</div><div> lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template0;</div><div>3-\q</div><div> </div><div>restore database:</div><div>engine-backup --mode=restore --file=file_name --log=log_file_name --provision-db --restore-permissions</div><div><br></div><div>if return error in the restore :</div><div><br></div><div>engine-backup --mode=restore --no-restore-permissions --provision-db --provision-dwh-db --provision-reports-db --file=engine-backup.tar.gz --log=engine-backup-restore.lo<wbr>g</div><div><br></div><div>follow the steps to upgrade now.</div><div><br></div><div><br></div><div>I dont sure if this steps is correct but works in my lab. I appreciate if anyone of red hat approve this steps to apply in my production environment.</div></div><div class="m_-1821534592475963449m_-2486310531759677991m_-6763254057718780259HOEnZb"><div class="m_-1821534592475963449m_-2486310531759677991m_-6763254057718780259h5"><div class="gmail_extra"><br><div class="gmail_quote">2018-04-26 8:23 GMT-03:00 Staniforth, Paul <span dir="ltr"><<a href="mailto:P.Staniforth@leedsbeckett.ac.uk" rel="noreferrer" target="_blank">P.Staniforth@leedsbeckett.ac.<wbr>uk</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr" style="font-size:12pt;color:#000000;background-color:#ffffff;font-family:Calibri,Arial,Helvetica,sans-serif">
<p>I'm having this problem as well.</p>
<p><br>
</p>
<p>It's suggested here to backup the databases and install new clean version of postgresql with the correct encoding,collation, etc and restore the databases.</p>
<p><br>
</p>
<p><a href="https://www.mail-archive.com/users@ovirt.org/msg47854.html" rel="noreferrer" target="_blank">https://www.mail-archive.com/u<wbr>sers@ovirt.org/msg47854.html</a><br>
</p>
<p><br>
</p>
<p>I hope to try this today or tomorrow on a test system.</p>
<p><br>
</p>
<p>Regards,</p>
<p> Paul S.<br>
</p>
<div style="color:rgb(33,33,33)">
<hr style="display:inline-block;width:98%">
<div id="m_-1821534592475963449m_-2486310531759677991m_-6763254057718780259m_-385283406091956557m_2692025684914731920divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" face="Calibri, sans-serif" color="#000000"><b>From:</b> <a href="mailto:users-bounces@ovirt.org" rel="noreferrer" target="_blank">users-bounces@ovirt.org</a> <<a href="mailto:users-bounces@ovirt.org" rel="noreferrer" target="_blank">users-bounces@ovirt.org</a>> on behalf of Aziz <<a href="mailto:azizgstest@gmail.com" rel="noreferrer" target="_blank">azizgstest@gmail.com</a>><br>
<b>Sent:</b> 26 April 2018 12:15<br>
<b>To:</b> Marcelo Leandro<br>
<b>Cc:</b> users<br>
<b>Subject:</b> Re: [ovirt-users] Failed to upgrade from 4.1 to 4.2 - Postgre version required</font>
<div> </div>
</div><div><div class="m_-1821534592475963449m_-2486310531759677991m_-6763254057718780259m_-385283406091956557h5">
<div>
<div dir="ltr">
<div>
<div>This is similar to the below bug : <br>
<br>
<a href="https://bugzilla.redhat.com/show_bug.cgi?id=1528371" rel="noreferrer" target="_blank">https://bugzilla.redhat.com/sh<wbr>ow_bug.cgi?id=1528371</a><br>
<br>
</div>
Any ideas on how to fix it without losing the existing config ?<br>
<br>
</div>
Thank you. <br>
<br>
<br>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Thu, Apr 26, 2018 at 11:54 AM, Aziz <span dir="ltr"><<a href="mailto:azizgstest@gmail.com" rel="noreferrer" target="_blank">azizgstest@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">
<div>There you are : <br>
<br>
<br>
<span style="color:rgb(7,55,99)">[root@CTL1 tmp]# su - postgresql<br>
su: user postgresql does not exist<br>
[root@CTL1 tmp]# su - postgres<br>
Last login: Thu Apr 26 12:25:01 CEST 2018 on pts/0<br>
nodectl must be run as root!<br>
nodectl must be run as root!<br>
nodectl must be run as root!<br>
nodectl must be run as root!<br>
-bash-4.2$ psql<br>
psql (9.2.23)<br>
Saisissez « help » pour l'aide.<br>
<br>
postgres=# \l<br>
<wbr> Liste des bases de données<br>
Nom | Propriétaire | Encodage | Collationnement | Type caract. | Droits d'accès
<br>
----------------------+-------<wbr>---------------+----------+---<wbr>--------------+--------------+<wbr>-----------------------<br>
dwh | postgres | UTF8 | fr_FR.UTF-8 | fr_FR.UTF-8 | =Tc/postgres +<br>
| | | | | postgres=CTc/postgres<br>
engine | engine | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
<br>
ovirt_engine_history | ovirt_engine_history | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
<br>
postgres | postgres | UTF8 | fr_FR.UTF-8 | fr_FR.UTF-8 |
<br>
template0 | postgres | UTF8 | fr_FR.UTF-8 | fr_FR.UTF-8 | =c/postgres +<br>
| | | | | postgres=CTc/postgres<br>
template1 | postgres | UTF8 | fr_FR.UTF-8 | fr_FR.UTF-8 | =c/postgres +<br>
| | | | | postgres=CTc/postgres<br>
(6 lignes)<br>
<br>
postgres=# </span><br>
<br>
</div>
Thanks <br>
</div>
<div class="m_-1821534592475963449m_-2486310531759677991m_-6763254057718780259m_-385283406091956557m_2692025684914731920HOEnZb">
<div class="m_-1821534592475963449m_-2486310531759677991m_-6763254057718780259m_-385283406091956557m_2692025684914731920h5">
<div class="gmail_extra"><br>
<div class="gmail_quote">On Thu, Apr 26, 2018 at 11:49 AM, Marcelo Leandro <span dir="ltr">
<<a href="mailto:marceloltmm@gmail.com" rel="noreferrer" target="_blank">marceloltmm@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr"><br>
<div>Show this information:</div>
<div><br>
</div>
<div>1 - su - postgresql</div>
<div>2 - psql</div>
<div>3 - \l</div>
<div><br>
</div>
<div><br>
</div>
<div>Thanks, </div>
</div>
<div class="m_-1821534592475963449m_-2486310531759677991m_-6763254057718780259m_-385283406091956557m_2692025684914731920m_-6359113955093257735HOEnZb">
<div class="m_-1821534592475963449m_-2486310531759677991m_-6763254057718780259m_-385283406091956557m_2692025684914731920m_-6359113955093257735h5">
<div class="gmail_extra"><br>
<div class="gmail_quote">2018-04-26 7:38 GMT-03:00 Marcelo Leandro <span dir="ltr">
<<a href="mailto:marceloltmm@gmail.com" rel="noreferrer" target="_blank">marceloltmm@gmail.com</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">
<div dir="auto">What show in the /var/lib/pgsql/upgrade_rh-<wbr>postgresql95-postgresql.log ?</div>
<div dir="auto"><br>
</div>
<div>command:</div>
<div>cat /var/lib/pgsql/upgrade_rh-post<wbr>gresql95-postgresql.log<span class="m_-1821534592475963449m_-2486310531759677991m_-6763254057718780259m_-385283406091956557m_2692025684914731920m_-6359113955093257735m_-521033745458172408HOEnZb"><font color="#888888"><br>
</font></span></div>
<span class="m_-1821534592475963449m_-2486310531759677991m_-6763254057718780259m_-385283406091956557m_2692025684914731920m_-6359113955093257735m_-521033745458172408HOEnZb"><font color="#888888">
<div><br>
</div>
Marcelo Leandro</font></span>
<div><br>
<div class="gmail_quote"><span>
<div dir="ltr">Em qui, 26 de abr de 2018 07:34, Aziz <<a href="mailto:azizgstest@gmail.com" rel="noreferrer noreferrer" target="_blank">azizgstest@gmail.com</a>> escreveu:<br>
</div>
</span>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<div class="m_-1821534592475963449m_-2486310531759677991m_-6763254057718780259m_-385283406091956557m_2692025684914731920m_-6359113955093257735m_-521033745458172408h5">
<div dir="ltr">
<div>
<div>
<div>
<div>Hi Ovirt users, <br>
<br>
</div>
I'm trying to upgrade my Ovirt from version 4.1 to 4.2, but I'm stuck when issuing the command
<i><b>engine-setup</b></i> which returns the following errors : <br>
<br>
<span style="color:rgb(7,55,99)"> Upgrading PostgreSQL<br>
<b>[ ERROR ] Failed to execute stage 'Misc configuration': Command '/opt/rh/rh-postgresql95/root/<wbr>usr/bin/postgresql-setup' failed to execute</b><br>
[ INFO ] Yum Performing yum transaction rollback<br>
[ INFO ] Rolling back to the previous PostgreSQL instance (postgresql).<br>
[ INFO ] Stage: Clean up Log file is located at /var/log/ovirt-engine/setup/ov<wbr>irt-engine-setup-2018042612263<wbr>0-rpkrel.log<br>
[ INFO ] Generating answer file '/var/lib/ovirt-engine/setup/a<wbr>nswers/<a href="http://20180426122823-setup.co" rel="noreferrer" target="_blank">20180426122823-setup.co</a><wbr>nf'<br>
[ INFO ] Stage: Pre-termination<br>
[ INFO ] Stage: Termination<br>
<b>[ ERROR ] Execution of setup failed</b></span><br>
<br>
<br>
</div>
Can anyone help to resolve this ? <br>
<br>
<br>
</div>
Thank you in advance. <br>
<br>
</div>
BR.<br>
</div>
</div>
</div>
<span>______________________________<wbr>_________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org" rel="noreferrer noreferrer noreferrer" target="_blank">Users@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer noreferrer noreferrer noreferrer" target="_blank">http://lists.ovirt.org/mailman<wbr>/listinfo/users</a><br>
</span></blockquote>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</div></div></div>
To view the terms under which this email is distributed, please go to:- <br>
<a href="http://disclaimer.leedsbeckett.ac.uk/disclaimer/disclaimer.html" rel="noreferrer" target="_blank">http://disclaimer.leedsbeckett<wbr>.ac.uk/disclaimer/disclaimer.<wbr>html</a>
<p></p>
</div>
</blockquote></div><br></div>
</div></div></blockquote></div><br></div>
</div></blockquote></div><br></div></div></div></blockquote></div><br></div>
</div></div></blockquote></div><br></div>