On Mon, Feb 5, 2018 at 3:08 PM, <[email protected]> wrote: > El 2018-02-05 14:03, Simone Tiraboschi escribió: > >> On Mon, Feb 5, 2018 at 2:46 PM, <[email protected]> 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]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]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 > > 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] >>> _______________________________________________ >>> Users mailing list >>> [email protected] >>> http://lists.ovirt.org/mailman/listinfo/users [4] >>> >> >> >> >> 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 > [email protected] > http://lists.ovirt.org/mailman/listinfo/users > -- Martin Perina Associate Manager, Software Engineering Red Hat Czech s.r.o.
_______________________________________________ Users mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/users
