Re: [ovirt-users] Problem to upgrade ovirt

Hello, Sorry, I did not have to chance anything else. It simply worked after my SELinux solution. Good Luck. Robert O'Kane On 04/23/2018 01:21 PM, Marcelo Leandro wrote: > 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(a)khm.de <mailto: > okane(a)khm.de&gt;&gt;: > > > 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(a)ovirt.org <mailto:Users@ovirt.org> > http://lists.ovirt.org/mailman/listinfo/users > <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(a)ovirt.org <mailto:Users@ovirt.org> > http://lists.ovirt.org/mailman/listinfo/users > <http://lists.ovirt.org/mailman/listinfo/users> > > > -- Robert O'Kane Systems Administrator Kunsthochschule für Medien Köln Peter-Welter-Platz 2 50676 Köln fon: +49(221)20189-223 fax: +49(221)20189-49223