Hi Alessandro, After adding that line to /opt/rh/rh-postgresql95/root/usr/bin/postgresql-setup the upgrade completed without issues, thank you very much.
Best regards Ian Fraser -----Original Message----- From: Alessandro De Salvo <[email protected]> Sent: 17 May 2018 14:04 To: Ian Fraser <[email protected]> Cc: [email protected] Subject: Re: [ovirt-users] Upgrade from 4.1.9 to 4.2.3 fails to upgrade postgresql Hi Ian, I had the very same problem, but the upgrade was complaining for a different locale. Try to add the following line at the beginning of the file /opt/rh/rh-postgresql95/root/usr/bin/postgresql-setup, after the initial comments and before the code: export PGSETUP_INITDB_OPTIONS="--lc-collate=en_GB.UTF-8" Once done, please try again to run engine-setup, thus the upgrade. You might need to add more options to PGSETUP_INITDB_OPTIONS, in case the upgrade procedure still complains. Cheers, Alessandro On Wed, 2018-05-16 at 22:32 +0000, Ian Fraser wrote: > Hi, > > Could someone please provide advice on a production oVirt instance > that fails to upgrade to 4.2.3? > > > > Engine and hosts are all running CentOS 7 > > > > As per the upgrade instructions in the release notes I run: > > # yum install > http://resources.ovirt.org/pub/yum-repo/ovirt-release42.rpm > > # yum update "ovirt-*-setup*" > > # engine-setup > > > > Then I answer the questions and it fails with: > > … > > [ INFO ] 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-20180516231622-3giicb.l > og > > [ INFO ] Generating answer file > '/var/lib/ovirt-engine/setup/answers/20180516231735-setup.conf' > > [ INFO ] Stage: Pre-termination > > [ INFO ] Stage: Termination > > [ ERROR ] Execution of setup failed > > > > > > When I check /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 > > engine > > ovirt_engine_history > > postgres > > template1 > > ok > > > > lc_collate values for database "postgres" do not match: old > "en_GB.UTF-8", new "en_US.UTF-8" > > Failure, exiting > > > > > > I have tried running the script here: > https://gist.github.com/turboladen/6790847 and rerunning engine-setup > but it fails with the same error. > > > > Can anyone offer any other suggestions? > > > > Best regards > > > > Ian Fraser > > > > Systems Administrator | Agency Sector Management (UK) Limited | > www.asm.org.uk > > [t] +44 (0)1784 242200 | [f] +44 (0)1784 242012 | [e] > [email protected] > > Registered in England No. 2053849 | Registered address: Ashford House > 41-45 Church Road Ashford Middx TW15 2TQ > > Follow us on twitter @asmukltd > > > > > _______________________________________________ > Users mailing list -- [email protected] > To unsubscribe send an email to [email protected] ______________________________________________________________________ This email has been scanned by the Symantec Email Security.cloud service. For more information please visit http://www.symanteccloud.com ______________________________________________________________________ _______________________________________________ Users mailing list -- [email protected] To unsubscribe send an email to [email protected]
