[ovirt-users] Re: Upgrade from 4.1.9 to 4.2.3 fails to upgrade postgresql

2018-05-21 Thread Ian Fraser 
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.desa...@roma1.infn.it> 
Sent: 17 May 2018 14:04
To: Ian Fraser <ian.fra...@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 +, 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

2018-05-17 Thread Alessandro De Salvo 
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

2018-05-17 Thread Yedidyah Bar David 
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

2018-05-17 Thread Marcelo Leandro 
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

2018-05-17 Thread Yedidyah Bar David 
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