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!
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@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
-- Systems Administrator Kunsthochschule für Medien Köln Peter-Welter-Platz 2 50676 Köln
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@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@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@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
participants (2)
-
Marcelo Leandro -
Robert O'Kane