[ovirt-users] Re: Upgrade from 4.1.9 to 4.2.3 fails to upgrade postgresql
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 Sent: 17 May 2018 14:04 To: Ian Fraser Cc: users@ovirt.org 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 +, 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 typesok > > Checking for contrib/isn with bigint-passing mismatch ok > > Checking for invalid "line" user columnsok > > 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.fra...@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@ovirt.org > To unsubscribe send an email to users-le...@ovirt.org __ This email has been scanned by the Symantec Email Security.cloud service. For more information please visit http://www.symanteccloud.com __ ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@ovirt.org
[ovirt-users] Re: 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 +, 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.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 typesok > > Checking for contrib/isn with bigint-passing mismatch ok > > Checking for invalid "line" user columnsok > > 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.fra...@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@ovirt.org > To unsubscribe send an email to users-le...@ovirt.org ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@ovirt.org
[ovirt-users] Re: Upgrade from 4.1.9 to 4.2.3 fails to upgrade postgresql
Thanks, Marcelo and Ian, I already got a setup log: https://bugzilla.redhat.com/show_bug.cgi?id=1579268 Will fix soon. Sorry. On Thu, May 17, 2018 at 12:50 PM, Marcelo Leandro wrote: > 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 > escreveu: >> >> On Thu, May 17, 2018 at 1:32 AM, 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.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 typesok >> > >> > Checking for contrib/isn with bigint-passing mismatch ok >> > >> > Checking for invalid "line" user columnsok >> > >> > 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-before-upgrade/001_initialize_engine.py >> >> 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.fra...@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@ovirt.org >> > To unsubscribe send an email to users-le...@ovirt.org >> > >> >> >> >> -- >> Didi >> ___ >> Users mailing list -- users@ovirt.org >> To unsubscribe send an email to users-le...@ovirt.org -- Didi ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@ovirt.org
[ovirt-users] Re: Upgrade from 4.1.9 to 4.2.3 fails to upgrade postgresql
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 escreveu: > On Thu, May 17, 2018 at 1:32 AM, 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.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 typesok > > > > Checking for contrib/isn with bigint-passing mismatch ok > > > > Checking for invalid "line" user columnsok > > > > 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-before-upgrade/001_initialize_engine.py > > 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.fra...@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@ovirt.org > > To unsubscribe send an email to users-le...@ovirt.org > > > > > > -- > Didi > ___ > Users mailing list -- users@ovirt.org > To unsubscribe send an email to users-le...@ovirt.org > ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@ovirt.org
[ovirt-users] Re: Upgrade from 4.1.9 to 4.2.3 fails to upgrade postgresql
On Thu, May 17, 2018 at 1:32 AM, 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.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 typesok > > Checking for contrib/isn with bigint-passing mismatch ok > > Checking for invalid "line" user columnsok > > 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-before-upgrade/001_initialize_engine.py 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.fra...@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@ovirt.org > To unsubscribe send an email to users-le...@ovirt.org > -- Didi ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@ovirt.org