--_000_152474180769886565leedsbeckettacuk_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I'm having this problem as well. It's suggested here to backup the databases and install new clean version o= f postgresql with the correct encoding,collation, etc and restore the datab= ases. https://www.mail-archive.com/users@ovirt.org/msg47854.html I hope to try this today or tomorrow on a test system. Regards, Paul S. ________________________________ From: users-bounces@ovirt.org <users-bounces@ovirt.org> on behalf of Aziz <= azizgstest@gmail.com> Sent: 26 April 2018 12:15 To: Marcelo Leandro Cc: users Subject: Re: [ovirt-users] Failed to upgrade from 4.1 to 4.2 - Postgre vers= ion required This is similar to the below bug : https://bugzilla.redhat.com/show_bug.cgi?id=3D1528371 Any ideas on how to fix it without losing the existing config ? Thank you. On Thu, Apr 26, 2018 at 11:54 AM, Aziz <azizgstest@gmail.com<mailto:azizgst= est@gmail.com>> wrote: There you are : [root@CTL1 tmp]# su - postgresql su: user postgresql does not exist [root@CTL1 tmp]# su - postgres Last login: Thu Apr 26 12:25:01 CEST 2018 on pts/0 nodectl must be run as root! nodectl must be run as root! nodectl must be run as root! nodectl must be run as root! -bash-4.2$ psql psql (9.2.23) Saisissez =AB help =BB pour l'aide. postgres=3D# \l Liste des bases de donn=E9es Nom | Propri=E9taire | Encodage | Collationnement= | Type caract. | Droits d'acc=E8s ----------------------+----------------------+----------+-----------------+= --------------+----------------------- dwh | postgres | UTF8 | fr_FR.UTF-8 |= fr_FR.UTF-8 | =3DTc/postgres + | | | |= | postgres=3DCTc/postgres engine | engine | UTF8 | en_US.UTF-8 |= en_US.UTF-8 | ovirt_engine_history | ovirt_engine_history | UTF8 | en_US.UTF-8 |= en_US.UTF-8 | postgres | postgres | UTF8 | fr_FR.UTF-8 |= fr_FR.UTF-8 | template0 | postgres | UTF8 | fr_FR.UTF-8 |= fr_FR.UTF-8 | =3Dc/postgres + | | | |= | postgres=3DCTc/postgres template1 | postgres | UTF8 | fr_FR.UTF-8 |= fr_FR.UTF-8 | =3Dc/postgres + | | | |= | postgres=3DCTc/postgres (6 lignes) postgres=3D# Thanks On Thu, Apr 26, 2018 at 11:49 AM, Marcelo Leandro <marceloltmm@gmail.com<ma= ilto:marceloltmm@gmail.com>> wrote: Show this information: 1 - su - postgresql 2 - psql 3 - \l Thanks, 2018-04-26 7:38 GMT-03:00 Marcelo Leandro <marceloltmm@gmail.com<mailto:mar= celoltmm@gmail.com>>: What show in the /var/lib/pgsql/upgrade_rh-postgresql95-postgresql.log ? command: cat /var/lib/pgsql/upgrade_rh-postgresql95-postgresql.log Marcelo Leandro Em qui, 26 de abr de 2018 07:34, Aziz <azizgstest@gmail.com<mailto:azizgste= st@gmail.com>> escreveu: Hi Ovirt users, I'm trying to upgrade my Ovirt from version 4.1 to 4.2, but I'm stuck when = issuing the command engine-setup which returns the following errors : Upgrading PostgreSQL [ ERROR ] Failed to execute stage 'Misc configuration': Command '/opt/rh/rh= -postgresql95/root/usr/bin/postgresql-setup' failed to execute [ INFO ] Yum Performing yum transaction rollback [ INFO ] Rolling back to the previous PostgreSQL instance (postgresql). [ INFO ] Stage: Clean up Log file is located at /var/log/ovirt-engine/setu= p/ovirt-engine-setup-20180426122630-rpkrel.log [ INFO ] Generating answer file '/var/lib/ovirt-engine/setup/answers/20180= 426122823-setup.co<http://20180426122823-setup.co>nf' [ INFO ] Stage: Pre-termination [ INFO ] Stage: Termination [ ERROR ] Execution of setup failed Can anyone help to resolve this ? Thank you in advance. BR. _______________________________________________ Users mailing list Users@ovirt.org<mailto:Users@ovirt.org> http://lists.ovirt.org/mailman/listinfo/users To view the terms under which this email is distributed, please go to:- http://disclaimer.leedsbeckett.ac.uk/disclaimer/disclaimer.html --_000_152474180769886565leedsbeckettacuk_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <html> <head> <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-= 1"> <style type=3D"text/css" style=3D"display:none"><!--P{margin-top:0;margin-b= ottom:0;} --></style> </head> <body dir=3D"ltr" style=3D"font-size:12pt;color:#000000;background-color:#F= FFFFF;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 versio= n of postgresql with the correct encoding,collation, etc and restore the da= tabases.</p> <p><br> </p> <p><a href=3D"https://www.mail-archive.com/users@ovirt.org/msg47854.html">h= ttps://www.mail-archive.com/users@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=3D"color: rgb(33, 33, 33);"> <hr tabindex=3D"-1" style=3D"display:inline-block; width:98%"> <div id=3D"divRplyFwdMsg" dir=3D"ltr"><font style=3D"font-size:11pt" face= =3D"Calibri, sans-serif" color=3D"#000000"><b>From:</b> users-bounces@ovirt= .org <users-bounces@ovirt.org> on behalf of Aziz <azizgstest@gmail= .com><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 - Postg= re version required</font> <div> </div> </div> <div> <div dir=3D"ltr"> <div> <div>This is similar to the below bug : <br> <br> <a href=3D"https://bugzilla.redhat.com/show_bug.cgi?id=3D1528371">https://b= ugzilla.redhat.com/show_bug.cgi?id=3D1528371</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=3D"gmail_extra"><br> <div class=3D"gmail_quote">On Thu, Apr 26, 2018 at 11:54 AM, Aziz <span dir= =3D"ltr"><<a href=3D"mailto:azizgstest@gmail.com" target=3D"_blank">aziz= gstest@gmail.com</a>></span> wrote:<br> <blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex; border-left:1= px #ccc solid; padding-left:1ex"> <div dir=3D"ltr"> <div>There you are : <br> <br> <br> <span style=3D"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 =AB help =BB pour l'aide.<br> <br> postgres=3D# \l<br> &nb= sp; = <wbr> &nbs= p; Liste des bases de donn=E9es<br> Nom = ; | Propri=E9taire&nb= sp; | Encodage | Collationnement | Type caract. | &n= bsp; Droits d'acc=E8s <br> ----------------------+-------<wbr>---------------+----------+-= --<wbr>--------------+--------------+<wbr>-----------------------<b= r> dwh = | postgres &nbs= p; | UTF8 = | fr_FR.UTF-8 | fr_FR.UTF-8 | =3DTc/postgres= +<br> &nb= sp; | &nbs= p; &= nbsp; | &n= bsp; | &nb= sp; | &nbs= p; | postgres=3DCTc/postgres<br> engine &nb= sp; | engine &nb= sp; | UTF8 | en= _US.UTF-8 | en_US.UTF-8 | <br> ovirt_engine_history | ovirt_engine_history | UTF8 &= nbsp; | en_US.UTF-8 | en_US.UTF-8 | <br> postgres &= nbsp; | postgres = ; | UTF8 | fr_FR.UTF-8 = ; | fr_FR.UTF-8 | <br> template0 = | postgres &nbs= p; | UTF8 | fr_FR.UTF-8 &nbs= p; | fr_FR.UTF-8 | =3Dc/postgres &= nbsp; +<br> &nb= sp; | &nbs= p; &= nbsp; | &n= bsp; | &nb= sp; | &nbs= p; | postgres=3DCTc/postgres<br> template1 = | postgres &nbs= p; | UTF8 | fr_FR.UTF-8 &nbs= p; | fr_FR.UTF-8 | =3Dc/postgres &= nbsp; +<br> &nb= sp; | &nbs= p; &= nbsp; | &n= bsp; | &nb= sp; | &nbs= p; | postgres=3DCTc/postgres<br> (6 lignes)<br> <br> postgres=3D# </span><br> <br> </div> Thanks <br> </div> <div class=3D"HOEnZb"> <div class=3D"h5"> <div class=3D"gmail_extra"><br> <div class=3D"gmail_quote">On Thu, Apr 26, 2018 at 11:49 AM, Marcelo Leandr= o <span dir=3D"ltr"> <<a href=3D"mailto:marceloltmm@gmail.com" target=3D"_blank">marceloltmm@= gmail.com</a>></span> wrote:<br> <blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex; border-left:1= px #ccc solid; padding-left:1ex"> <div dir=3D"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=3D"m_-6359113955093257735HOEnZb"> <div class=3D"m_-6359113955093257735h5"> <div class=3D"gmail_extra"><br> <div class=3D"gmail_quote">2018-04-26 7:38 GMT-03:00 Marcelo Leandro <span = dir=3D"ltr"> <<a href=3D"mailto:marceloltmm@gmail.com" target=3D"_blank">marceloltmm@= gmail.com</a>></span>:<br> <blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex; border-left:1= px #ccc solid; padding-left:1ex"> <div dir=3D"ltr"> <div dir=3D"auto">What show in the /var/lib/pgsql/upgrade_rh-<wbr>post= gresql95-postgresql.log ?</div> <div dir=3D"auto"><br> </div> <div>command:</div> <div>cat /var/lib/pgsql/upgrade_rh-post<wbr>gresql95-postgresql.log<span cl= ass=3D"m_-6359113955093257735m_-521033745458172408HOEnZb"><font color=3D"#8= 88888"><br> </font></span></div> <span class=3D"m_-6359113955093257735m_-521033745458172408HOEnZb"><font col= or=3D"#888888"> <div><br> </div> Marcelo Leandro</font></span> <div><br> <div class=3D"gmail_quote"><span> <div dir=3D"ltr">Em qui, 26 de abr de 2018 07:34, Aziz <<a href=3D"mailt= o:azizgstest@gmail.com" rel=3D"noreferrer" target=3D"_blank">azizgstest@gma= il.com</a>> escreveu:<br> </div> </span> <blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex; border= -left:1px solid rgb(204,204,204); padding-left:1ex"> <div> <div class=3D"m_-6359113955093257735m_-521033745458172408h5"> <div dir=3D"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=3D"color:rgb(7,55,99)"> &nbs= p; 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>ns= wers/<a href=3D"http://20180426122823-setup.co" target=3D"_blank">201804261= 22823-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=3D"mailto:Users@ovirt.org" rel=3D"noreferrer noreferrer" target=3D"= _blank">Users@ovirt.org</a><br> <a href=3D"http://lists.ovirt.org/mailman/listinfo/users" rel=3D"noreferrer= noreferrer noreferrer" target=3D"_blank">http://lists.ovirt.org/mailman<wb= r>/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> To view the terms under which this email is distributed, please go to:- <br=
<a href=3D"http://disclaimer.leedsbeckett.ac.uk/disclaimer/disclaimer.html"= target=3D"_blank">http://disclaimer.leedsbeckett.ac.uk/disclaimer/disclaim= er.html</a> <p></p> </body> </html> --_000_152474180769886565leedsbeckettacuk_--