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

[nicolas at devels.es]

El 2018-02-05 14:48, Martin Perina escribió:
> 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]
>> [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 at 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 at 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