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