[ovirt-users] Problem to upgrade ovirt

[Marcelo Leandro]

Hello, Robert

Thank you for reply, I tried this steps but not worked for me , I think
that I need change parameters in my postgresql but I don't know how do this.


2018-04-22 7:45 GMT-03:00 Robert O'Kane <okane at khm.de>:

> Hello,
>
> I had a similar problem with the engine update from 4.1.9 to 4.2.2.
> For me it was SELinux in Enforcing mode on the host.  You should check
> that SELinux is in "Enforcing" mode and that the audit daemon is
> complaining about postgres95. "audit2why -a"
>
>
> I set the host to "Permissive", did the upgrade and it worked for me.
> But you may have to leave it in "Permissive" mode until you can update the
> SELinux rules.
>
>
> *IF* the problem is SELinux I would suggest:
>
> 1: Clean up the auditd logs (make sure all old problems are corrected).
>    Reset the auditd logs so the following output is "cleaner".
>    The "audit2why -a" command should show nothing. Please RYFM....
>
> 2: Set SELinux to "Permissive" mode.
>
> 3: Apply the Ovirt-engine updates. Make sure everything works.
>
> 4: run "audit2why -a" and see what the warnings are
>  or go directly to 5
>
> 5: generate the new rules with:
>       audit2allow -a -M postgres95-selinux-ovirt
>
> 6: add the rules to the system:
>       semodule -i  postgres95-selinux-ovirt.pp
>
> 7: It should now be possible to set SELinux back to "Enforcing"
>
>
> Good Luck,
>
> Robert O'Kane
>
>
>
> Am 21.04.2018 um 10:26 schrieb Marcelo Leandro:
>
>> Hello,
>> I have problem when i try upgrade the ovirt to 4.2,  my version is 4.1.9,
>> I
>> have problem when engine-setup try update the postgresql.
>> Postgres version 9.2
>>
>> I had this message:
>>
>> Log install:
>>
>> ERROR: pg_upgrade tool failed
>> ERROR: Upgrade failed.
>>   * See /var/lib/pgsql/upgrade_rh-postgresql95-postgresql.log for
>> details.
>>
>> 2018-04-21 04:53:10,766-0300 DEBUG otopi.transaction
>> transaction._prepare:66 exception during prepare phase
>> Traceback (most recent call last):
>>    File "/usr/lib/python2.7/site-packages/otopi/transaction.py", line
>> 62, in
>> _prepare
>>      element.prepare()
>>    File
>> "/usr/share/ovirt-engine/setup/ovirt_engine_setup/engine_
>> common/postgres.py",
>> line 777, in prepare
>>      raiseOnError=True,
>>    File "/usr/lib/python2.7/site-packages/otopi/plugin.py", line 931, in
>> execute
>>      command=args[0],
>> RuntimeError: Command
>> '/opt/rh/rh-postgresql95/root/usr/bin/postgresql-setup' failed to execute
>> 2018-04-21 04:53:10,768-0300 DEBUG otopi.context
>> context._executeMethod:143
>> method exception
>> Traceback (most recent call last):
>>    File "/usr/lib/python2.7/site-packages/otopi/context.py", line 133, in
>> _executeMethod
>>      method['method']()
>>    File
>> "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-
>> setup/ovirt-engine/db/dbmsupgrade.py",
>> line 89, in _updateDBMS
>>      oengcommcons.ProvisioningEnv.OLD_POSTGRES_SERVICE
>>    File "/usr/lib/python2.7/site-packages/otopi/transaction.py", line
>> 106,
>> in append
>>      self._prepare(element=element)
>>    File "/usr/lib/python2.7/site-packages/otopi/transaction.py", line
>> 62, in
>> _prepare
>>      element.prepare()
>>    File
>> "/usr/share/ovirt-engine/setup/ovirt_engine_setup/engine_
>> common/postgres.py",
>> line 777, in prepare
>>      raiseOnError=True,
>>    File "/usr/lib/python2.7/site-packages/otopi/plugin.py", line 931, in
>> execute
>>      command=args[0],
>> RuntimeError: Command
>> '/opt/rh/rh-postgresql95/root/usr/bin/postgresql-setup' failed to execute
>> 2018-04-21 04:53:10,770-0300 ERROR otopi.context
>> context._executeMethod:152
>> Failed to execute stage 'Misc configuration': Command
>> '/opt/rh/rh-postgresql95/root/usr/bin/postgresql-setup' failed to execute
>>
>> Log postgres:
>> 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
>>
>> encodings for database "postgres" do not match:  old "SQL_ASCII", new
>> "UTF8"
>> Failure, exiting
>>
>>
>> I know that problem not is in oVirt , but anyone help me ?
>>
>>
>> Thank you!
>>
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at ovirt.org
>> http://lists.ovirt.org/mailman/listinfo/users
>>
>>
> --
> Systems Administrator
> Kunsthochschule für Medien Köln
> Peter-Welter-Platz 2
> 50676 Köln
> _______________________________________________
> Users mailing list
> Users at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20180423/e4103677/attachment.html>