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