Upgrade from 4.1.9 to 4.2.3 fails to upgrade postgresql
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@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<https://twitter.com/asmukltd>
On Thu, May 17, 2018 at 1:32 AM, Ian Fraser <Ian.Fraser@asm.org.uk> 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-be... 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@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-leave@ovirt.org
-- Didi
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@redhat.com> escreveu:
On Thu, May 17, 2018 at 1:32 AM, Ian Fraser <Ian.Fraser@asm.org.uk> 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-be...
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@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-leave@ovirt.org
-- Didi _______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@ovirt.org
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 <marceloltmm@gmail.com> 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 <didi@redhat.com> escreveu:
On Thu, May 17, 2018 at 1:32 AM, Ian Fraser <Ian.Fraser@asm.org.uk> 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-be...
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@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-leave@ovirt.org
-- Didi _______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@ovirt.org
-- Didi
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.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@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-leave@ovirt.org
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 <Alessandro.DeSalvo@roma1.infn.it> Sent: 17 May 2018 14:04 To: Ian Fraser <Ian.Fraser@asm.org.uk> 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 +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] Ian.Fraser@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-leave@ovirt.org
______________________________________________________________________ This email has been scanned by the Symantec Email Security.cloud service. For more information please visit http://www.symanteccloud.com ______________________________________________________________________
participants (4)
-
Alessandro De Salvo -
Ian Fraser -
Marcelo Leandro -
Yedidyah Bar David