Le 25 avr. 2017 à 13:28, Yedidyah Bar David <didi@redhat.com> a écrit :
On Tue, Apr 25, 2017 at 1:28 PM, Fabrice Bacchella <fabrice.bacchella@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/postgr...
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.