6:34 a.m.
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.
6:38 a.m.
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(a)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(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
6:41 a.m.
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(a)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(a)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(a)ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
6:49 a.m.
Show this information:
1 - su - postgresql
2 - psql
3 - \l
Thanks,
2018-04-26 7:38 GMT-03:00 Marcelo Leandro <marceloltmm(a)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(a)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(a)ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
6:54 a.m.
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(a)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(a)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(a)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(a)ovirt.org
>> http://lists.ovirt.org/mailman/listinfo/users
>>
>
7:15 a.m.
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(a)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(a)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(a)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(a)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(a)ovirt.org
>>> http://lists.ovirt.org/mailman/listinfo/users
>>>
>>
>
7:23 a.m.
New subject: Failed to upgrade from 4.1 to 4.2 - Postgre version required
--_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(a)ovirt.org <users-bounces(a)ovirt.org> on behalf of Aziz <=
azizgstest(a)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(a)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(a)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(a)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(a)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&q...
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 &lt;users-bounces(a)ovirt.org&gt; 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"&...
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(a)gmail.com</a>&gt;</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(a)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_--
7:49 a.m.
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(a)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(a)ovirt.org <users-bounces(a)ovirt.org> on behalf of
Aziz <azizgstest(a)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(a)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(a)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(a)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(a)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(a)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
8 a.m.
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(a)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(a)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(a)ovirt.org <users-bounces(a)ovirt.org> on behalf of
> Aziz <azizgstest(a)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(a)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(a)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(a)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(a)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(a)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
>
>
8:12 a.m.
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(a)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(a)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(a)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(a)ovirt.org <users-bounces(a)ovirt.org> on behalf of
> Aziz <azizgstest(a)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(a)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(a)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(a)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(a)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(a)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
>
>
10:50 a.m.
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(a)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(a)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(a)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(a)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(a)ovirt.org <users-bounces(a)ovirt.org> on behalf of
>> Aziz <azizgstest(a)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(a)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(a)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(a)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(a)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(a)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
>>
>>
>
5:14 a.m.
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(a)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(a)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(a)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(a)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(a)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(a)ovirt.org <users-bounces(a)ovirt.org> on behalf of
>>> Aziz <azizgstest(a)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(a)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(a)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(a)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(a)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(a)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
>>>
>>>
>>
>
>
5:01 a.m.
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(a)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(a)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(a)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(a)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(a)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(a)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(a)ovirt.org <users-bounces(a)ovirt.org> on behalf
of
>>>> Aziz <azizgstest(a)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(a)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(a)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(a)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(a)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(a)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(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
--
Didi
2416
days inactive
2435
days old
12 comments
4 participants
participants (4)
-
Aziz -
Marcelo Leandro -
Staniforth, Paul -
Yedidyah Bar David