El 2018-02-05 14:48, Martin Perina escribió:
On Mon, Feb 5, 2018 at 3:08 PM, <nicolas@devels.es> wrote:
El 2018-02-05 14:03, Simone Tiraboschi escribió: On Mon, Feb 5, 2018 at 2:46 PM, <nicolas@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