<div dir="ltr"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Feb 5, 2018 at 3:08 PM, <span dir="ltr"><<a href="mailto:nicolas@devels.es" target="_blank">nicolas@devels.es</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">El 2018-02-05 14:03, Simone Tiraboschi escribió:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
On Mon, Feb 5, 2018 at 2:46 PM, <<a href="mailto:nicolas@devels.es" target="_blank">nicolas@devels.es</a>> wrote:<br>
<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
Hi,<br>
<br>
We're trying to upgrade from 4.1.9 to 4.2.x and we're bumping into<br>
an error we don't know how to solve. As per [1] we run the<br>
'engine-setup' command and it fails with:<br>
<br>
[ INFO ] Rolling back to the previous PostgreSQL instance<br>
(postgresql).<br>
[ ERROR ] Failed to execute stage 'Misc configuration': Command<br>
'/opt/rh/rh-postgresql95/root/<wbr>usr/bin/postgresql-setup' failed to<br>
execute<br>
[ INFO ] Yum Performing yum transaction rollback<br>
[ INFO ] Stage: Clean up<br>
Log file is located at<br>
<br>
</blockquote>
/var/log/ovirt-engine/setup/ov<wbr>irt-engine-setup-2018020513311<wbr>6-sm2xd1.log<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
[ INFO ] Generating answer file<br>
'/var/lib/ovirt-engine/setup/a<wbr>nswers/<a href="http://20180205133354-setup.co" rel="noreferrer" target="_blank">20180205133354-setup.co</a> [1]nf'<br>
[ INFO ] Stage: Pre-termination<br>
[ INFO ] Stage: Termination<br>
[ ERROR ] Execution of setup failed<br>
<br>
As of the<br>
<br>
</blockquote>
/var/log/ovirt-engine/setup/ov<wbr>irt-engine-setup-2018020513311<wbr>6-sm2xd1.log<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
file I could see this:<br>
<br>
* upgrading from 'postgresql.service' to<br>
'<a href="http://rh-postgresql95-postgresql.se" rel="noreferrer" target="_blank">rh-postgresql95-postgresql.se</a> [2]rvice'<br>
* Upgrading database.<br>
ERROR: pg_upgrade tool failed<br>
ERROR: Upgrade failed.<br>
* See /var/lib/pgsql/upgrade_rh-post<wbr>gresql95-postgresql.log for<br>
details.<br>
<br>
And this file contains this information:<br>
<br>
Performing Consistency Checks<br>
-----------------------------<br>
Checking cluster versions <br>
ok<br>
Checking database user is the install user <br>
ok<br>
Checking database connection settings <br>
ok<br>
Checking for prepared transactions <br>
ok<br>
Checking for reg* system OID user data types <br>
ok<br>
Checking for contrib/isn with bigint-passing mismatch <br>
ok<br>
Checking for invalid "line" user columns <br>
ok<br>
Creating dump of global objects <br>
ok<br>
Creating dump of database schemas<br>
django<br>
engine<br>
ovirt_engine_history<br>
postgres<br>
template1<br>
<br>
ok<br>
Checking for presence of required libraries <br>
fatal<br>
<br>
Your installation references loadable libraries that are missing<br>
from the<br>
new installation. You can add these libraries to the new<br>
installation,<br>
or remove the functions using them from the old installation. <br>
A list of<br>
problem libraries is in the file:<br>
loadable_libraries.txt<br>
<br>
Failure, exiting<br>
<br>
I'm attaching full logs FWIW. Also, I'd like to mention that we<br>
created two custom triggers on the engine's 'users' table, but as I<br>
understand from the error this is not the issue (We upgraded several<br>
times within the same minor and we had no issues with that).<br>
<br>
Could someone shed some light on this error and how to debug it?<br>
</blockquote>
<br>
Hi,<br>
can you please attach also loadable_libraries.txt ?<br>
<br>
</blockquote>
<br>
Could not load library "$libdir/plpython2"<br>
ERROR: could not access file "$libdir/plpython2": No such file or directory<br></blockquote><div><br><div style="font-family:arial,helvetica,sans-serif;display:inline" class="gmail_default">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<br></div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<br>
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?<br>
<br>
Thanks.<br>
<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
Thanks.<br>
<br>
[1]: <a href="https://www.ovirt.org/release/4.2.0/" rel="noreferrer" target="_blank">https://www.ovirt.org/release/<wbr>4.2.0/</a> [3]<br>
______________________________<wbr>_________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/mailman<wbr>/listinfo/users</a> [4]<br>
</blockquote>
<br>
<br>
<br>
Links:<br>
------<br>
[1] <a href="http://20180205133354-setup.co" rel="noreferrer" target="_blank">http://20180205133354-setup.co</a><br>
[2] <a href="http://rh-postgresql95-postgresql.se" rel="noreferrer" target="_blank">http://rh-postgresql95-postgre<wbr>sql.se</a><br>
[3] <a href="https://www.ovirt.org/release/4.2.0/" rel="noreferrer" target="_blank">https://www.ovirt.org/release/<wbr>4.2.0/</a><br>
[4] <a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/mailman<wbr>/listinfo/users</a><br>
</blockquote>
______________________________<wbr>_________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/mailman<wbr>/listinfo/users</a><br>
</blockquote></div><br><br clear="all"><br>-- <br><div class="gmail_signature"><div dir="ltr"><font size="1">Martin Perina<br>Associate Manager, Software Engineering<br>Red Hat Czech s.r.o.<br></font></div></div>
</div></div>