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.log [ 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] Ian.Fraser(a)asm.org.uk 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 -- users(a)ovirt.org To unsubscribe send an email to users-leave(a)ovirt.org

Hello, I had the same error, but for me only worked when I created a new instalation , run engine-setup for create a new database , after I runed engine-cleanup to clear the instalation and restore a full backup , all the language of SO is english. Marcelo Leandro Em qui, 17 de mai de 2018 06:14, Yedidyah Bar David <didi(a)redhat.com&gt; escreveu: > > On Thu, May 17, 2018 at 1:32 AM, Ian Fraser <Ian.Fraser(a)asm.org.uk&gt; 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.log > > > > [ 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" > > Sounds again like: > > https://bugzilla.redhat.com/1528371 > > That's really weird. > > Can you please check/share engine-setup log, so we can see that we > actually passed the correct options to postgresql-setup? > > Also, if at all possible, please provide complete reproduction steps. > > See this for what I personally used to verify the fix for above bug, > at the time: > > > https://gerrit.ovirt.org/#/c/88234/2/common/upgrade-suites/test-scenarios... > > But can't be sure it reproduces the original bug (although the error > was the same), nor if your case is different and how. > > Thanks! > > > > > 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] > > Ian.Fraser(a)asm.org.uk > > > > 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 -- users(a)ovirt.org > > To unsubscribe send an email to users-leave(a)ovirt.org > > > > > > -- > Didi > _______________________________________________ > Users mailing list -- users(a)ovirt.org > To unsubscribe send an email to users-leave(a)ovirt.org

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] Ian.Fraser(a)asm.org.uk 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 -- users(a)ovirt.org To unsubscribe send an email to users-leave(a)ovirt.org