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