Failed to upgrade from 4.1 to 4.2 - Postgre version required
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/setup/ovirt-engine-setup-20180426122630-rpkrel.log [ INFO ] Generating answer file '/var/lib/ovirt-engine/setup/answers/20180426122823-setup.conf' [ INFO ] Stage: Pre-termination [ INFO ] Stage: Termination *[ ERROR ] Execution of setup failed* Can anyone help to resolve this ? Thank you in advance. BR.
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> 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/setup/ovirt-engine-setup-20180426122630-rpkrel.log [ INFO ] Generating answer file '/var/lib/ovirt-engine/setup/ answers/20180426122823-setup.conf' [ 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 http://lists.ovirt.org/mailman/listinfo/users
Hello, Seems to be a localisation issue, here are the logs : cat /var/lib/pgsql/upgrade_rh-postgresql95-postgresql.log Performing Consistency Checks ----------------------------- Checking cluster versions ok Checking database user is the install user ok Checking database connection settings ok Checking for prepared transactions ok Checking for reg* system OID user data types ok Checking for contrib/isn with bigint-passing mismatch ok Checking for invalid "line" user columns ok Creating dump of global objects ok Creating dump of database schemas dwh engine ovirt_engine_history postgres template1 ok *lc_collate values for database "postgres" do not match: old "fr_FR.UTF-8", new "en_US.UTF-8"Failure, exiting* Any ideas how to resolve this ? Thanks On Thu, Apr 26, 2018 at 11:38 AM, Marcelo Leandro <marceloltmm@gmail.com> wrote:
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> 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/setup/ovirt-engine-setup-20180426122630-rpkrel.log [ INFO ] Generating answer file '/var/lib/ovirt-engine/setup/answers/ 20180426122823-setup.conf' [ 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 http://lists.ovirt.org/mailman/listinfo/users
Show this information: 1 - su - postgresql 2 - psql 3 - \l Thanks, 2018-04-26 7:38 GMT-03:00 Marcelo Leandro <marceloltmm@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> 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/setup/ovirt-engine-setup-20180426122630-rpkrel.log [ INFO ] Generating answer file '/var/lib/ovirt-engine/setup/answers/ 20180426122823-setup.conf' [ 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 http://lists.ovirt.org/mailman/listinfo/users
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 « help » pour l'aide. postgres=# \l Liste des bases de données Nom | Propriétaire | Encodage | Collationnement | Type caract. | Droits d'accès ----------------------+----------------------+----------+-----------------+--------------+----------------------- dwh | postgres | UTF8 | fr_FR.UTF-8 | fr_FR.UTF-8 | =Tc/postgres + | | | | | postgres=CTc/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 | =c/postgres + | | | | | postgres=CTc/postgres template1 | postgres | UTF8 | fr_FR.UTF-8 | fr_FR.UTF-8 | =c/postgres + | | | | | postgres=CTc/postgres (6 lignes) postgres=# Thanks On Thu, Apr 26, 2018 at 11:49 AM, Marcelo Leandro <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>:
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> 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/setup/ovirt-engine-setup-20180426122630-rpkrel.log [ INFO ] Generating answer file '/var/lib/ovirt-engine/setup/answers/ 20180426122823-setup.conf' [ 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 http://lists.ovirt.org/mailman/listinfo/users
This is similar to the below bug : https://bugzilla.redhat.com/show_bug.cgi?id=1528371 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> 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 « help » pour l'aide.
postgres=# \l Liste des bases de données Nom | Propriétaire | Encodage | Collationnement | Type caract. | Droits d'accès ----------------------+----------------------+----------+--- --------------+--------------+----------------------- dwh | postgres | UTF8 | fr_FR.UTF-8 | fr_FR.UTF-8 | =Tc/postgres + | | | | | postgres=CTc/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 | =c/postgres + | | | | | postgres=CTc/postgres template1 | postgres | UTF8 | fr_FR.UTF-8 | fr_FR.UTF-8 | =c/postgres + | | | | | postgres=CTc/postgres (6 lignes)
postgres=#
Thanks
On Thu, Apr 26, 2018 at 11:49 AM, Marcelo Leandro <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>:
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> 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/setup/ovirt-engine-setup-2018042612263 0-rpkrel.log [ INFO ] Generating answer file '/var/lib/ovirt-engine/setup/answers/ 20180426122823-setup.conf' [ 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 http://lists.ovirt.org/mailman/listinfo/users
--_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_--
I am had the same problem, is a problem in database structure. In my lab I followed this steps: FOLLOW THIS STEP IN A LAB FIRST: Full backup before the upgrade engine: engine-backup --scope=all --mode=backup --file=file_name --log=log_file_name after clean you engine config: engine-cleanup Change structure template 1 su - postgres psql -U postgres postgres=# update pg_database set datallowconn = TRUE where datname = 'template0'; UPDATE 1 postgres=# \c template0 You are now connected to database "template0". template0=# update pg_database set datistemplate = FALSE where datname = 'template1'; UPDATE 1 template0=# drop database template1; DROP DATABASE template0=# create database template1 with owner=postgres encoding='UTF-8' lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template0; CREATE DATABASE template0=# update pg_database set datistemplate = TRUE where datname = 'template1'; UPDATE 1 template0=# \c template1 You are now connected to database "template1". template1=# update pg_database set datallowconn = FALSE where datname = 'template0'; UPDATE 1 template1=# \q change structure template0 psql -U postgres postgres=# update pg_database set datallowconn = TRUE where datname = 'template1'; UPDATE 1 postgres=# \c template1 You are now connected to database "template0". template0=# update pg_database set datistemplate = FALSE where datname = 'template0'; UPDATE 1 template0=# drop database template0; DROP DATABASE template0=# create database template0 with owner=postgres encoding='UTF-8' lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template1; CREATE DATABASE template0=# update pg_database set datistemplate = TRUE where datname = 'template0'; UPDATE 1 template0=# \c template0 You are now connected to database "template0". template1=# update pg_database set datallowconn = FALSE where datname = 'template1'; UPDATE 1 template1=# \q change estructure postgres psql template0 1-drop database postgres; 2- create database postgres with owner=postgres encoding='UTF-8' lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template0; 3-\q restore database: engine-backup --mode=restore --file=file_name --log=log_file_name --provision-db --restore-permissions if return error in the restore : engine-backup --mode=restore --no-restore-permissions --provision-db --provision-dwh-db --provision-reports-db --file=engine-backup.tar.gz --log=engine-backup-restore.log follow the steps to upgrade now. 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. 2018-04-26 8:23 GMT-03:00 Staniforth, Paul <P.Staniforth@leedsbeckett.ac.uk> :
I'm having this problem as well.
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.
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 version required
This is similar to the below bug :
https://bugzilla.redhat.com/show_bug.cgi?id=1528371
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> 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 « help » pour l'aide.
postgres=# \l Liste des bases de données Nom | Propriétaire | Encodage | Collationnement | Type caract. | Droits d'accès ----------------------+----------------------+----------+--- --------------+--------------+----------------------- dwh | postgres | UTF8 | fr_FR.UTF-8 | fr_FR.UTF-8 | =Tc/postgres + | | | | | postgres=CTc/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 | =c/postgres + | | | | | postgres=CTc/postgres template1 | postgres | UTF8 | fr_FR.UTF-8 | fr_FR.UTF-8 | =c/postgres + | | | | | postgres=CTc/postgres (6 lignes)
postgres=#
Thanks
On Thu, Apr 26, 2018 at 11:49 AM, Marcelo Leandro <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>:
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> 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/setup/ovirt-engine-setup-2018042612263 0-rpkrel.log [ INFO ] Generating answer file '/var/lib/ovirt-engine/setup/answers/ 20180426122823-setup.conf' [ 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 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
Thanks Marcelo for the feedback, In my case some of the components are already upgraded to 4.2, including cleanup engine, therefore I got the following error : engine-cleanup [ INFO ] Stage: Initializing [ INFO ] Stage: Environment setup Configuration files: ['/etc/ovirt-engine-setup.conf.d/10-packaging-jboss.conf', '/etc/ovirt-engine-setup.conf.d/10-packaging.conf', '/etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf'] Log file: /var/log/ovirt-engine/setup/ovirt-engine-remove-20180426135555-m68ygc.log Version: otopi-1.7.7 (otopi-1.7.7-1.el7.centos) [ ERROR ] Cleanup utility and installed version mismatch 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) [ ERROR ] Failed to execute stage 'Environment setup': Cleanup utility version mismatch [ INFO ] Stage: Clean up Log file is located at /var/log/ovirt-engine/setup/ovirt-engine-remove-20180426135555-m68ygc.log [ INFO ] Generating answer file '/var/lib/ovirt-engine/setup/answers/20180426135556-cleanup.conf' [ INFO ] Stage: Pre-termination [ INFO ] Stage: Termination [ ERROR ] Execution of cleanup failed Is there a way to downgrade ? Thanks On Thu, Apr 26, 2018 at 12:49 PM, Marcelo Leandro <marceloltmm@gmail.com> wrote:
I am had the same problem, is a problem in database structure. In my lab I followed this steps:
FOLLOW THIS STEP IN A LAB FIRST:
Full backup before the upgrade engine:
engine-backup --scope=all --mode=backup --file=file_name --log=log_file_name
after clean you engine config:
engine-cleanup
Change structure template 1
su - postgres
psql -U postgres
postgres=# update pg_database set datallowconn = TRUE where datname = 'template0'; UPDATE 1 postgres=# \c template0 You are now connected to database "template0". template0=# update pg_database set datistemplate = FALSE where datname = 'template1'; UPDATE 1 template0=# drop database template1; DROP DATABASE template0=# create database template1 with owner=postgres encoding='UTF-8' lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template0; CREATE DATABASE template0=# update pg_database set datistemplate = TRUE where datname = 'template1'; UPDATE 1 template0=# \c template1 You are now connected to database "template1". template1=# update pg_database set datallowconn = FALSE where datname = 'template0'; UPDATE 1 template1=# \q
change structure template0
psql -U postgres postgres=# update pg_database set datallowconn = TRUE where datname = 'template1'; UPDATE 1 postgres=# \c template1 You are now connected to database "template0". template0=# update pg_database set datistemplate = FALSE where datname = 'template0'; UPDATE 1 template0=# drop database template0; DROP DATABASE template0=# create database template0 with owner=postgres encoding='UTF-8' lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template1; CREATE DATABASE template0=# update pg_database set datistemplate = TRUE where datname = 'template0'; UPDATE 1 template0=# \c template0 You are now connected to database "template0". template1=# update pg_database set datallowconn = FALSE where datname = 'template1'; UPDATE 1 template1=# \q
change estructure postgres
psql template0 1-drop database postgres; 2- create database postgres with owner=postgres encoding='UTF-8' lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template0; 3-\q
restore database: engine-backup --mode=restore --file=file_name --log=log_file_name --provision-db --restore-permissions
if return error in the restore :
engine-backup --mode=restore --no-restore-permissions --provision-db --provision-dwh-db --provision-reports-db --file=engine-backup.tar.gz --log=engine-backup-restore.log
follow the steps to upgrade now.
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.
2018-04-26 8:23 GMT-03:00 Staniforth, Paul <P.Staniforth@leedsbeckett.ac. uk>:
I'm having this problem as well.
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.
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 version required
This is similar to the below bug :
https://bugzilla.redhat.com/show_bug.cgi?id=1528371
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> 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 « help » pour l'aide.
postgres=# \l Liste des bases de données Nom | Propriétaire | Encodage | Collationnement | Type caract. | Droits d'accès ----------------------+----------------------+----------+--- --------------+--------------+----------------------- dwh | postgres | UTF8 | fr_FR.UTF-8 | fr_FR.UTF-8 | =Tc/postgres + | | | | | postgres=CTc/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 | =c/postgres + | | | | | postgres=CTc/postgres template1 | postgres | UTF8 | fr_FR.UTF-8 | fr_FR.UTF-8 | =c/postgres + | | | | | postgres=CTc/postgres (6 lignes)
postgres=#
Thanks
On Thu, Apr 26, 2018 at 11:49 AM, Marcelo Leandro <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>:
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> 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/setup/ovirt-engine-setup-2018042612263 0-rpkrel.log [ INFO ] Generating answer file '/var/lib/ovirt-engine/setup/a nswers/20180426122823-setup.conf' [ 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 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
Do you have a full backup ? If yes, I think if possible better configure a new Server and restore. Em 26 de abr de 2018 09:00, "Aziz" <azizgstest@gmail.com> escreveu: Thanks Marcelo for the feedback, In my case some of the components are already upgraded to 4.2, including cleanup engine, therefore I got the following error : engine-cleanup [ INFO ] Stage: Initializing [ INFO ] Stage: Environment setup Configuration files: ['/etc/ovirt-engine-setup.conf.d/10-packaging-jboss.conf', '/etc/ovirt-engine-setup.conf.d/10-packaging.conf', '/etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf'] Log file: /var/log/ovirt-engine/setup/ovirt-engine-remove-20180426135555-m68ygc.log Version: otopi-1.7.7 (otopi-1.7.7-1.el7.centos) [ ERROR ] Cleanup utility and installed version mismatch 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) [ ERROR ] Failed to execute stage 'Environment setup': Cleanup utility version mismatch [ INFO ] Stage: Clean up Log file is located at /var/log/ovirt-engine/setup/ovirt-engine-remove-20180426135555-m68ygc.log [ INFO ] Generating answer file '/var/lib/ovirt-engine/setup/answers/20180426135556-cleanup.conf' [ INFO ] Stage: Pre-termination [ INFO ] Stage: Termination [ ERROR ] Execution of cleanup failed Is there a way to downgrade ? Thanks On Thu, Apr 26, 2018 at 12:49 PM, Marcelo Leandro <marceloltmm@gmail.com> wrote:
I am had the same problem, is a problem in database structure. In my lab I followed this steps:
FOLLOW THIS STEP IN A LAB FIRST:
Full backup before the upgrade engine:
engine-backup --scope=all --mode=backup --file=file_name --log=log_file_name
after clean you engine config:
engine-cleanup
Change structure template 1
su - postgres
psql -U postgres
postgres=# update pg_database set datallowconn = TRUE where datname = 'template0'; UPDATE 1 postgres=# \c template0 You are now connected to database "template0". template0=# update pg_database set datistemplate = FALSE where datname = 'template1'; UPDATE 1 template0=# drop database template1; DROP DATABASE template0=# create database template1 with owner=postgres encoding='UTF-8' lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template0; CREATE DATABASE template0=# update pg_database set datistemplate = TRUE where datname = 'template1'; UPDATE 1 template0=# \c template1 You are now connected to database "template1". template1=# update pg_database set datallowconn = FALSE where datname = 'template0'; UPDATE 1 template1=# \q
change structure template0
psql -U postgres postgres=# update pg_database set datallowconn = TRUE where datname = 'template1'; UPDATE 1 postgres=# \c template1 You are now connected to database "template0". template0=# update pg_database set datistemplate = FALSE where datname = 'template0'; UPDATE 1 template0=# drop database template0; DROP DATABASE template0=# create database template0 with owner=postgres encoding='UTF-8' lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template1; CREATE DATABASE template0=# update pg_database set datistemplate = TRUE where datname = 'template0'; UPDATE 1 template0=# \c template0 You are now connected to database "template0". template1=# update pg_database set datallowconn = FALSE where datname = 'template1'; UPDATE 1 template1=# \q
change estructure postgres
psql template0 1-drop database postgres; 2- create database postgres with owner=postgres encoding='UTF-8' lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template0; 3-\q
restore database: engine-backup --mode=restore --file=file_name --log=log_file_name --provision-db --restore-permissions
if return error in the restore :
engine-backup --mode=restore --no-restore-permissions --provision-db --provision-dwh-db --provision-reports-db --file=engine-backup.tar.gz --log=engine-backup-restore.log
follow the steps to upgrade now.
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.
2018-04-26 8:23 GMT-03:00 Staniforth, Paul < P.Staniforth@leedsbeckett.ac.uk>:
I'm having this problem as well.
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.
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 version required
This is similar to the below bug :
https://bugzilla.redhat.com/show_bug.cgi?id=1528371
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> 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 « help » pour l'aide.
postgres=# \l Liste des bases de données Nom | Propriétaire | Encodage | Collationnement | Type caract. | Droits d'accès
----------------------+----------------------+----------+-----------------+--------------+----------------------- dwh | postgres | UTF8 | fr_FR.UTF-8 | fr_FR.UTF-8 | =Tc/postgres + | | | | | postgres=CTc/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 | =c/postgres + | | | | | postgres=CTc/postgres template1 | postgres | UTF8 | fr_FR.UTF-8 | fr_FR.UTF-8 | =c/postgres + | | | | | postgres=CTc/postgres (6 lignes)
postgres=#
Thanks
On Thu, Apr 26, 2018 at 11:49 AM, Marcelo Leandro <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>:
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> 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/setup/ovirt-engine-setup-20180426122630-rpkrel.log [ INFO ] Generating answer file '/var/lib/ovirt-engine/setup/answers/ 20180426122823-setup.conf' [ 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 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
Hello, I try only did an clean install in another server with steps: my host is a Centos 7 with LANG = LANG= english commmand: #locale LANG=en_US.UTF-8 LC_CTYPE="en_US.UTF-8" LC_NUMERIC="en_US.UTF-8" LC_TIME="en_US.UTF-8" LC_COLLATE="en_US.UTF-8" LC_MONETARY="en_US.UTF-8" LC_MESSAGES="en_US.UTF-8" LC_PAPER="en_US.UTF-8" LC_NAME="en_US.UTF-8" LC_ADDRESS="en_US.UTF-8" LC_TELEPHONE="en_US.UTF-8" LC_MEASUREMENT="en_US.UTF-8" LC_IDENTIFICATION="en_US.UTF-8" LC_ALL= 1-yum install http://resources.ovirt.org/pub/yum-repo/ovirt-release41.rpm 2-yum update 3-yum install ovirt-engine -y 4-engine-setup --accept-defaults 5-engine-cleanup 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.log and upgrade now: 1-yum install http://resources.ovirt.org/pub/yum-repo/ovirt-release42.rpm 2-yum update "ovirt-*-setup*" 3- engine-setup It`s works for me. 2018-04-26 9:12 GMT-03:00 Marcelo Leandro <marceloltmm@gmail.com>:
Do you have a full backup ?
If yes, I think if possible better configure a new Server and restore.
Em 26 de abr de 2018 09:00, "Aziz" <azizgstest@gmail.com> escreveu:
Thanks Marcelo for the feedback,
In my case some of the components are already upgraded to 4.2, including cleanup engine, therefore I got the following error :
engine-cleanup [ INFO ] Stage: Initializing [ INFO ] Stage: Environment setup Configuration files: ['/etc/ovirt-engine-setup. conf.d/10-packaging-jboss.conf', '/etc/ovirt-engine-setup.conf.d/10-packaging.conf', '/etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf'] Log file: /var/log/ovirt-engine/setup/ovirt-engine-remove- 20180426135555-m68ygc.log Version: otopi-1.7.7 (otopi-1.7.7-1.el7.centos) [ ERROR ] Cleanup utility and installed version mismatch 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) [ ERROR ] Failed to execute stage 'Environment setup': Cleanup utility version mismatch [ INFO ] Stage: Clean up Log file is located at /var/log/ovirt-engine/setup/ ovirt-engine-remove-20180426135555-m68ygc.log [ INFO ] Generating answer file '/var/lib/ovirt-engine/setup/ answers/20180426135556-cleanup.conf'
[ INFO ] Stage: Pre-termination [ INFO ] Stage: Termination [ ERROR ] Execution of cleanup failed
Is there a way to downgrade ?
Thanks
On Thu, Apr 26, 2018 at 12:49 PM, Marcelo Leandro <marceloltmm@gmail.com> wrote:
I am had the same problem, is a problem in database structure. In my lab I followed this steps:
FOLLOW THIS STEP IN A LAB FIRST:
Full backup before the upgrade engine:
engine-backup --scope=all --mode=backup --file=file_name --log=log_file_name
after clean you engine config:
engine-cleanup
Change structure template 1
su - postgres
psql -U postgres
postgres=# update pg_database set datallowconn = TRUE where datname = 'template0'; UPDATE 1 postgres=# \c template0 You are now connected to database "template0". template0=# update pg_database set datistemplate = FALSE where datname = 'template1'; UPDATE 1 template0=# drop database template1; DROP DATABASE template0=# create database template1 with owner=postgres encoding='UTF-8' lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template0; CREATE DATABASE template0=# update pg_database set datistemplate = TRUE where datname = 'template1'; UPDATE 1 template0=# \c template1 You are now connected to database "template1". template1=# update pg_database set datallowconn = FALSE where datname = 'template0'; UPDATE 1 template1=# \q
change structure template0
psql -U postgres postgres=# update pg_database set datallowconn = TRUE where datname = 'template1'; UPDATE 1 postgres=# \c template1 You are now connected to database "template0". template0=# update pg_database set datistemplate = FALSE where datname = 'template0'; UPDATE 1 template0=# drop database template0; DROP DATABASE template0=# create database template0 with owner=postgres encoding='UTF-8' lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template1; CREATE DATABASE template0=# update pg_database set datistemplate = TRUE where datname = 'template0'; UPDATE 1 template0=# \c template0 You are now connected to database "template0". template1=# update pg_database set datallowconn = FALSE where datname = 'template1'; UPDATE 1 template1=# \q
change estructure postgres
psql template0 1-drop database postgres; 2- create database postgres with owner=postgres encoding='UTF-8' lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template0; 3-\q
restore database: engine-backup --mode=restore --file=file_name --log=log_file_name --provision-db --restore-permissions
if return error in the restore :
engine-backup --mode=restore --no-restore-permissions --provision-db --provision-dwh-db --provision-reports-db --file=engine-backup.tar.gz --log=engine-backup-restore.log
follow the steps to upgrade now.
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.
2018-04-26 8:23 GMT-03:00 Staniforth, Paul <P.Staniforth@leedsbeckett.ac. uk>:
I'm having this problem as well.
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.
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 version required
This is similar to the below bug :
https://bugzilla.redhat.com/show_bug.cgi?id=1528371
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> 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 « help » pour l'aide.
postgres=# \l Liste des bases de données Nom | Propriétaire | Encodage | Collationnement | Type caract. | Droits d'accès ----------------------+----------------------+----------+--- --------------+--------------+----------------------- dwh | postgres | UTF8 | fr_FR.UTF-8 | fr_FR.UTF-8 | =Tc/postgres + | | | | | postgres=CTc/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 | =c/postgres + | | | | | postgres=CTc/postgres template1 | postgres | UTF8 | fr_FR.UTF-8 | fr_FR.UTF-8 | =c/postgres + | | | | | postgres=CTc/postgres (6 lignes)
postgres=#
Thanks
On Thu, Apr 26, 2018 at 11:49 AM, Marcelo Leandro < 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>:
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> 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/setup/ovirt-engine-setup- > 20180426122630-rpkrel.log > [ INFO ] Generating answer file '/var/lib/ovirt-engine/setup/ > answers/20180426122823-setup.conf' > [ 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 > 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
Hi Marcelo, 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 *engine-backup --mode=restore --scope=all --file=pgbackup --log=restore_log --restore-permissionsPreparing to restore:- Unpacking file 'pgbackup'FATAL: Backup was created by version '4.1' and can not be restored using the installed version 4.2* Thank you all for your help. BR On Thu, Apr 26, 2018 at 3:50 PM, Marcelo Leandro <marceloltmm@gmail.com> wrote:
Hello,
I try only did an clean install in another server with steps:
my host is a Centos 7 with LANG = LANG= english
commmand:
#locale LANG=en_US.UTF-8 LC_CTYPE="en_US.UTF-8" LC_NUMERIC="en_US.UTF-8" LC_TIME="en_US.UTF-8" LC_COLLATE="en_US.UTF-8" LC_MONETARY="en_US.UTF-8" LC_MESSAGES="en_US.UTF-8" LC_PAPER="en_US.UTF-8" LC_NAME="en_US.UTF-8" LC_ADDRESS="en_US.UTF-8" LC_TELEPHONE="en_US.UTF-8" LC_MEASUREMENT="en_US.UTF-8" LC_IDENTIFICATION="en_US.UTF-8" LC_ALL=
1-yum install http://resources.ovirt.org/pub/yum-repo/ovirt-release41.rpm 2-yum update 3-yum install ovirt-engine -y 4-engine-setup --accept-defaults 5-engine-cleanup 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.log
and upgrade now:
1-yum install http://resources.ovirt.org/pub/yum-repo/ovirt-release42.rpm 2-yum update "ovirt-*-setup*" 3- engine-setup
It`s works for me.
2018-04-26 9:12 GMT-03:00 Marcelo Leandro <marceloltmm@gmail.com>:
Do you have a full backup ?
If yes, I think if possible better configure a new Server and restore.
Em 26 de abr de 2018 09:00, "Aziz" <azizgstest@gmail.com> escreveu:
Thanks Marcelo for the feedback,
In my case some of the components are already upgraded to 4.2, including cleanup engine, therefore I got the following error :
engine-cleanup [ INFO ] Stage: Initializing [ INFO ] Stage: Environment setup Configuration files: ['/etc/ovirt-engine-setup.conf.d/10-packaging-jboss.conf', '/etc/ovirt-engine-setup.conf.d/10-packaging.conf', '/etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf'] Log file: /var/log/ovirt-engine/setup/ov irt-engine-remove-20180426135555-m68ygc.log Version: otopi-1.7.7 (otopi-1.7.7-1.el7.centos) [ ERROR ] Cleanup utility and installed version mismatch 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) [ ERROR ] Failed to execute stage 'Environment setup': Cleanup utility version mismatch [ INFO ] Stage: Clean up Log file is located at /var/log/ovirt-engine/setup/ov irt-engine-remove-20180426135555-m68ygc.log [ INFO ] Generating answer file '/var/lib/ovirt-engine/setup/a nswers/20180426135556-cleanup.conf'
[ INFO ] Stage: Pre-termination [ INFO ] Stage: Termination [ ERROR ] Execution of cleanup failed
Is there a way to downgrade ?
Thanks
On Thu, Apr 26, 2018 at 12:49 PM, Marcelo Leandro <marceloltmm@gmail.com> wrote:
I am had the same problem, is a problem in database structure. In my lab I followed this steps:
FOLLOW THIS STEP IN A LAB FIRST:
Full backup before the upgrade engine:
engine-backup --scope=all --mode=backup --file=file_name --log=log_file_name
after clean you engine config:
engine-cleanup
Change structure template 1
su - postgres
psql -U postgres
postgres=# update pg_database set datallowconn = TRUE where datname = 'template0'; UPDATE 1 postgres=# \c template0 You are now connected to database "template0". template0=# update pg_database set datistemplate = FALSE where datname = 'template1'; UPDATE 1 template0=# drop database template1; DROP DATABASE template0=# create database template1 with owner=postgres encoding='UTF-8' lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template0; CREATE DATABASE template0=# update pg_database set datistemplate = TRUE where datname = 'template1'; UPDATE 1 template0=# \c template1 You are now connected to database "template1". template1=# update pg_database set datallowconn = FALSE where datname = 'template0'; UPDATE 1 template1=# \q
change structure template0
psql -U postgres postgres=# update pg_database set datallowconn = TRUE where datname = 'template1'; UPDATE 1 postgres=# \c template1 You are now connected to database "template0". template0=# update pg_database set datistemplate = FALSE where datname = 'template0'; UPDATE 1 template0=# drop database template0; DROP DATABASE template0=# create database template0 with owner=postgres encoding='UTF-8' lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template1; CREATE DATABASE template0=# update pg_database set datistemplate = TRUE where datname = 'template0'; UPDATE 1 template0=# \c template0 You are now connected to database "template0". template1=# update pg_database set datallowconn = FALSE where datname = 'template1'; UPDATE 1 template1=# \q
change estructure postgres
psql template0 1-drop database postgres; 2- create database postgres with owner=postgres encoding='UTF-8' lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template0; 3-\q
restore database: engine-backup --mode=restore --file=file_name --log=log_file_name --provision-db --restore-permissions
if return error in the restore :
engine-backup --mode=restore --no-restore-permissions --provision-db --provision-dwh-db --provision-reports-db --file=engine-backup.tar.gz --log=engine-backup-restore.log
follow the steps to upgrade now.
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.
2018-04-26 8:23 GMT-03:00 Staniforth, Paul < P.Staniforth@leedsbeckett.ac.uk>:
I'm having this problem as well.
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.
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 version required
This is similar to the below bug :
https://bugzilla.redhat.com/show_bug.cgi?id=1528371
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> 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 « help » pour l'aide.
postgres=# \l Liste des bases de données Nom | Propriétaire | Encodage | Collationnement | Type caract. | Droits d'accès ----------------------+----------------------+----------+--- --------------+--------------+----------------------- dwh | postgres | UTF8 | fr_FR.UTF-8 | fr_FR.UTF-8 | =Tc/postgres + | | | | | postgres=CTc/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 | =c/postgres + | | | | | postgres=CTc/postgres template1 | postgres | UTF8 | fr_FR.UTF-8 | fr_FR.UTF-8 | =c/postgres + | | | | | postgres=CTc/postgres (6 lignes)
postgres=#
Thanks
On Thu, Apr 26, 2018 at 11:49 AM, Marcelo Leandro < 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>:
> 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> > 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/setup/ovirt-engine-setup-2018042612263 >> 0-rpkrel.log >> [ INFO ] Generating answer file '/var/lib/ovirt-engine/setup/a >> nswers/20180426122823-setup.conf' >> [ 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 >> 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
Hi everyone, I see that you are already deep inside trying to workaround your problem, so will not interfere. But do update if you get stuck! I'd just like to add that the failure you ran into indeed seems exactly like: https://bugzilla.redhat.com/show_bug.cgi?id=1528371 So should not happen when upgrading to 4.2.3 or later. If it does happen, to you or others, please share also engine-setup logs, so that we can see if the fix there indeed worked - which was to pass to the upgrade script locale options with values taken from the existing database. In any case, we can't fix problems if we can't reproduce them, and in that bug we fixed what we managed to reproduce. But there are many different relevant options for locales and encodings, both OS-level, PG-instance level, and specific-database level, so it's quite likely we missed some cases. Best regards, On Fri, Apr 27, 2018 at 12:14 PM, Aziz <azizgstest@gmail.com> wrote:
Hi Marcelo,
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
engine-backup --mode=restore --scope=all --file=pgbackup --log=restore_log --restore-permissions Preparing to restore: - Unpacking file 'pgbackup' FATAL: Backup was created by version '4.1' and can not be restored using the installed version 4.2
Thank you all for your help.
BR
On Thu, Apr 26, 2018 at 3:50 PM, Marcelo Leandro <marceloltmm@gmail.com> wrote:
Hello,
I try only did an clean install in another server with steps:
my host is a Centos 7 with LANG = LANG= english
commmand:
#locale LANG=en_US.UTF-8 LC_CTYPE="en_US.UTF-8" LC_NUMERIC="en_US.UTF-8" LC_TIME="en_US.UTF-8" LC_COLLATE="en_US.UTF-8" LC_MONETARY="en_US.UTF-8" LC_MESSAGES="en_US.UTF-8" LC_PAPER="en_US.UTF-8" LC_NAME="en_US.UTF-8" LC_ADDRESS="en_US.UTF-8" LC_TELEPHONE="en_US.UTF-8" LC_MEASUREMENT="en_US.UTF-8" LC_IDENTIFICATION="en_US.UTF-8" LC_ALL=
1-yum install http://resources.ovirt.org/pub/yum-repo/ovirt-release41.rpm 2-yum update 3-yum install ovirt-engine -y 4-engine-setup --accept-defaults 5-engine-cleanup 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.log
and upgrade now:
1-yum install http://resources.ovirt.org/pub/yum-repo/ovirt-release42.rpm 2-yum update "ovirt-*-setup*" 3- engine-setup
It`s works for me.
2018-04-26 9:12 GMT-03:00 Marcelo Leandro <marceloltmm@gmail.com>:
Do you have a full backup ?
If yes, I think if possible better configure a new Server and restore.
Em 26 de abr de 2018 09:00, "Aziz" <azizgstest@gmail.com> escreveu:
Thanks Marcelo for the feedback,
In my case some of the components are already upgraded to 4.2, including cleanup engine, therefore I got the following error :
engine-cleanup [ INFO ] Stage: Initializing [ INFO ] Stage: Environment setup Configuration files: ['/etc/ovirt-engine-setup.conf.d/10-packaging-jboss.conf', '/etc/ovirt-engine-setup.conf.d/10-packaging.conf', '/etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf'] Log file: /var/log/ovirt-engine/setup/ovirt-engine-remove-20180426135555-m68ygc.log Version: otopi-1.7.7 (otopi-1.7.7-1.el7.centos) [ ERROR ] Cleanup utility and installed version mismatch 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) [ ERROR ] Failed to execute stage 'Environment setup': Cleanup utility version mismatch [ INFO ] Stage: Clean up Log file is located at /var/log/ovirt-engine/setup/ovirt-engine-remove-20180426135555-m68ygc.log [ INFO ] Generating answer file '/var/lib/ovirt-engine/setup/answers/20180426135556-cleanup.conf'
[ INFO ] Stage: Pre-termination [ INFO ] Stage: Termination [ ERROR ] Execution of cleanup failed
Is there a way to downgrade ?
Thanks
On Thu, Apr 26, 2018 at 12:49 PM, Marcelo Leandro <marceloltmm@gmail.com> wrote:
I am had the same problem, is a problem in database structure. In my lab I followed this steps:
FOLLOW THIS STEP IN A LAB FIRST:
Full backup before the upgrade engine:
engine-backup --scope=all --mode=backup --file=file_name --log=log_file_name
after clean you engine config:
engine-cleanup
Change structure template 1
su - postgres
psql -U postgres
postgres=# update pg_database set datallowconn = TRUE where datname = 'template0'; UPDATE 1 postgres=# \c template0 You are now connected to database "template0". template0=# update pg_database set datistemplate = FALSE where datname = 'template1'; UPDATE 1 template0=# drop database template1; DROP DATABASE template0=# create database template1 with owner=postgres encoding='UTF-8' lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template0; CREATE DATABASE template0=# update pg_database set datistemplate = TRUE where datname = 'template1'; UPDATE 1 template0=# \c template1 You are now connected to database "template1". template1=# update pg_database set datallowconn = FALSE where datname = 'template0'; UPDATE 1 template1=# \q
change structure template0
psql -U postgres postgres=# update pg_database set datallowconn = TRUE where datname = 'template1'; UPDATE 1 postgres=# \c template1 You are now connected to database "template0". template0=# update pg_database set datistemplate = FALSE where datname = 'template0'; UPDATE 1 template0=# drop database template0; DROP DATABASE template0=# create database template0 with owner=postgres encoding='UTF-8' lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template1; CREATE DATABASE template0=# update pg_database set datistemplate = TRUE where datname = 'template0'; UPDATE 1 template0=# \c template0 You are now connected to database "template0". template1=# update pg_database set datallowconn = FALSE where datname = 'template1'; UPDATE 1 template1=# \q
change estructure postgres
psql template0 1-drop database postgres; 2- create database postgres with owner=postgres encoding='UTF-8' lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template0; 3-\q
restore database: engine-backup --mode=restore --file=file_name --log=log_file_name --provision-db --restore-permissions
if return error in the restore :
engine-backup --mode=restore --no-restore-permissions --provision-db --provision-dwh-db --provision-reports-db --file=engine-backup.tar.gz --log=engine-backup-restore.log
follow the steps to upgrade now.
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.
2018-04-26 8:23 GMT-03:00 Staniforth, Paul <P.Staniforth@leedsbeckett.ac.uk>:
I'm having this problem as well.
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.
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 version required
This is similar to the below bug :
https://bugzilla.redhat.com/show_bug.cgi?id=1528371
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> 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 « help » pour l'aide.
postgres=# \l Liste des bases de données Nom | Propriétaire | Encodage | Collationnement | Type caract. | Droits d'accès
----------------------+----------------------+----------+-----------------+--------------+----------------------- dwh | postgres | UTF8 | fr_FR.UTF-8 | fr_FR.UTF-8 | =Tc/postgres + | | | | | postgres=CTc/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 | =c/postgres + | | | | | postgres=CTc/postgres template1 | postgres | UTF8 | fr_FR.UTF-8 | fr_FR.UTF-8 | =c/postgres + | | | | | postgres=CTc/postgres (6 lignes)
postgres=#
Thanks
On Thu, Apr 26, 2018 at 11:49 AM, Marcelo Leandro <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>: >> >> 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> >> 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/setup/ovirt-engine-setup-20180426122630-rpkrel.log >>> [ INFO ] Generating answer file >>> '/var/lib/ovirt-engine/setup/answers/20180426122823-setup.conf' >>> [ 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 >>> 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
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
-- Didi
participants (4)
-
Aziz -
Marcelo Leandro -
Staniforth, Paul -
Yedidyah Bar David