[ovirt-users] Failed upgrade from 4.1.9 to 4.2.x

[Martin Perina]

On Mon, Feb 5, 2018 at 3:08 PM, <nicolas at devels.es> wrote:

> El 2018-02-05 14:03, Simone Tiraboschi escribió:
>
>> On Mon, Feb 5, 2018 at 2:46 PM, <nicolas at 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 at 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 at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>



-- 
Martin Perina
Associate Manager, Software Engineering
Red Hat Czech s.r.o.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20180205/a4a93c42/attachment.html>