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

On Mon, Feb 5, 2018 at 3:08 PM, <nicolas(a)devels.es&gt; wrote: > El 2018-02-05 14:03, Simone Tiraboschi escribió: > On Mon, Feb 5, 2018 at 2:46 PM, <nicolas(a)devels.es&gt; 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 ​ 

> 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(a)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(a)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