[ovirt-users] after upgrade from 4.0.4 to 4.1.1, no more gettagsbyparent_id

[Fabrice Bacchella]

> Le 25 avr. 2017 à 13:28, Yedidyah Bar David <didi at redhat.com> a écrit :
> 
> On Tue, Apr 25, 2017 at 1:28 PM, Fabrice Bacchella
> <fabrice.bacchella at orange.fr> wrote:
>> I activated pg query log and got that:
>> 
>> grep gettagsbyparent_id /data/pgsql/9.4/data/pg_log/postgresql-Tue.log
>> < 2017-04-25 12:21:29.770 CEST >LOG:  execute <unnamed>: SELECT NULL AS PROCEDURE_CAT, n.nspname AS PROCEDURE_SCHEM, p.proname AS PROCEDURE_NAME, NULL, NULL, NULL, d.description AS REMARKS, 2 AS PROCEDURE_TYPE,  p.proname || '_' || p.oid AS SPECIFIC_NAME  FROM pg_catalog.pg_namespace n, pg_catalog.pg_proc p  LEFT JOIN pg_catalog.pg_description d ON (p.oid=d.objoid)  LEFT JOIN pg_catalog.pg_class c ON (d.classoid=c.oid AND c.relname='pg_proc')  LEFT JOIN pg_catalog.pg_namespace pn ON (c.relnamespace=pn.oid AND pn.nspname='pg_catalog')  WHERE p.pronamespace=n.oid  AND n.nspname LIKE 'public' AND p.proname LIKE 'gettagsbyparent_id' ORDER BY PROCEDURE_SCHEM, PROCEDURE_NAME, p.oid::text
> 
> This query does not seem to be originated by oVirt, but by
> postgresql-jdbc [1]. Can you try downgrading that one as well, and
> then restart the engine? Thanks.
> 
> [1] https://github.com/pgjdbc/pgjdbc/blob/master/pgjdbc/src/main/java/org/postgresql/jdbc/PgDatabaseMetaData.java#L959

You nailed it !

There is two versionning approch in postgres:

- For the database and library, the first two level are part of the version name, so you install postgresql-92 or postgresql-94 and yum update don't break it.
- For the jdbc drivers, they do continuous upgrade:

yum update postgresql-jdbc
Loaded plugins: etckeeper, fastestmirror, versionlock
Loading mirror speeds from cached hostfile
Resolving Dependencies
--> Running transaction check
---> Package postgresql-jdbc.noarch 0:9.2.1002-5.el7 will be updated
---> Package postgresql-jdbc.noarch 0:42.0.0-1.rhel7 will be an update
--> Finished Dependency Resolution

Dependencies Resolved

========================================================================================================================================================================================================================================================
 Package                                                          Arch                                                    Version                                                         Repository                                               Size
========================================================================================================================================================================================================================================================
Updating:
 postgresql-jdbc                                                  noarch                                                  42.0.0-1.rhel7                                                  pgdg94                                                  508 k


But I need pgdg94 install on my ovirt server, to have pg_dump/pg_restore matching the one from the server. For now I will prevent upgrade from yum configuration.