El 2018-02-05 14:48, Martin Perina escribió:
On Mon, Feb 5, 2018 at 3:08 PM, <nico...@devels.es> wrote:
El 2018-02-05 14:03, Simone Tiraboschi escribió:
On Mon, Feb 5, 2018 at 2:46 PM, <nico...@devels.es> wrote:
Hi,
We're trying to upgrade from 4.1.9 to 4.2.x and we're bumping into
an error we don't know how to solve. As per [1] we run the
'engine-setup' command and it fails with:
[ INFO ] Rolling back to the previous PostgreSQL instance
(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 ] Stage: Clean up
Log file is located at
/var/log/ovirt-engine/setup/ovirt-engine-setup-20180205133116-sm2xd1.log
[ INFO ] Generating answer file
'/var/lib/ovirt-engine/setup/answers/20180205133354-setup.co [1]
[1]nf'
[ INFO ] Stage: Pre-termination
[ INFO ] Stage: Termination
[ ERROR ] Execution of setup failed
As of the
/var/log/ovirt-engine/setup/ovirt-engine-setup-20180205133116-sm2xd1.log
file I could see this:
* upgrading from 'postgresql.service' to
'rh-postgresql95-postgresql.se [2] [2]rvice'
* Upgrading database.
ERROR: pg_upgrade tool failed
ERROR: Upgrade failed.
* See /var/lib/pgsql/upgrade_rh-postgresql95-postgresql.log for
details.
And this file contains this information:
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
django
engine
ovirt_engine_history
postgres
template1
ok
Checking for presence of required libraries
fatal
Your installation references loadable libraries that are missing
from the
new installation. You can add these libraries to the new
installation,
or remove the functions using them from the old installation.
A list of
problem libraries is in the file:
loadable_libraries.txt
Failure, exiting
I'm attaching full logs FWIW. Also, I'd like to mention that we
created two custom triggers on the engine's 'users' table, but as I
understand from the error this is not the issue (We upgraded
several
times within the same minor and we had no issues with that).
Could someone shed some light on this error and how to debug it?
Hi,
can you please attach also loadable_libraries.txt ?
Could not load library "$libdir/plpython2"
ERROR: could not access file "$libdir/plpython2": No such file or
directory
Hmm, you probably need to install
rh-postgresql95-postgresql-plpython package. This is not installed by
default with oVirt as we don't use it
Indeed, this made it. Thank you very much.
Well, definitely it has to do with the triggers... The trigger uses
plpython2u to replicate some entries in a different database. Is
there a way I can get rid of this error other than disabling
plpython2 before upgrading and re-enabling it after the upgrade?
Thanks.
Thanks.
[1]: https://www.ovirt.org/release/4.2.0/ [3] [3]
_______________________________________________
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users [4] [4]
Links:
------
[1] http://20180205133354-setup.co [1]
[2] http://rh-postgresql95-postgresql.se [2]
[3] https://www.ovirt.org/release/4.2.0/ [3]
[4] http://lists.ovirt.org/mailman/listinfo/users [4]
_______________________________________________
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users [4]
--
Martin Perina
Associate Manager, Software Engineering
Red Hat Czech s.r.o.
Links:
------
[1] http://20180205133354-setup.co
[2] http://rh-postgresql95-postgresql.se
[3] https://www.ovirt.org/release/4.2.0/
[4] http://lists.ovirt.org/mailman/listinfo/users
_______________________________________________
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users