[ovirt-users] Re: Failed to upgrade from 4.1 to 4.2 - Postgre version required

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&gt; 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&gt;: >> >> 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&gt; 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&gt; >> 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&gt;: >>>> >>>> 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&gt; on behalf of >>>> Aziz <azizgstest(a)gmail.com&gt; >>>> 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&gt; 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&gt; 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&gt;: >>>>>>> >>>>>>> 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&gt; >>>>>>> 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