6:28 a.m.
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...
< 2017-04-25 12:21:29.787 CEST >LOG: execute <unnamed>:
SELECT n.nspname,p.proname,p.prorettype,p.proargtypes, t.typtype,t.typrelid,
p.proargnames, p.proargmodes, p.proallargtypes, p.oid FROM pg_catalog.pg_proc p,
pg_catalog.pg_namespace n, pg_catalog.pg_type t WHERE p.pronamespace=n.oid AND
p.prorettype=t.oid AND n.nspname LIKE 'public' AND p.proname LIKE
'gettagsbyparent_id' ORDER BY n.nspname, p.proname, p.oid::text
< 2017-04-25 12:21:29.827 CEST >ERROR: function gettagsbyparent_id() does not
exist at character 16
< 2017-04-25 12:21:29.827 CEST >STATEMENT: select * from gettagsbyparent_id()
And:
grep getallmacpoolrangesbymacpoolid /data/pgsql/9.4/data/pg_log/postgresql-Tue.log
< 2017-04-25 12:13:03.519 CEST >ERROR: function getallmacpoolrangesbymacpoolid()
does not exist at character 16
< 2017-04-25 12:13:03.519 CEST >STATEMENT: select * from
getallmacpoolrangesbymacpoolid();
< 2017-04-25 12:21:29.816 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
'getallmacpoolrangesbymacpoolid' ORDER BY PROCEDURE_SCHEM, PROCEDURE_NAME,
p.oid::text
< 2017-04-25 12:21:29.821 CEST >LOG: execute <unnamed>: SELECT
n.nspname,p.proname,p.prorettype,p.proargtypes, t.typtype,t.typrelid, p.proargnames,
p.proargmodes, p.proallargtypes, p.oid FROM pg_catalog.pg_proc p, pg_catalog.pg_namespace
n, pg_catalog.pg_type t WHERE p.pronamespace=n.oid AND p.prorettype=t.oid AND n.nspname
LIKE 'public' AND p.proname LIKE 'getallmacpoolrangesbymacpoolid' ORDER BY
n.nspname, p.proname, p.oid::text
< 2017-04-25 12:21:29.865 CEST >ERROR: function getallmacpoolrangesbymacpoolid()
does not exist at character 16
< 2017-04-25 12:21:29.865 CEST >STATEMENT: select * from
getallmacpoolrangesbymacpoolid()
And for all the errors for today:
< 2017-04-25 03:23:08.098 CEST >ERROR: update or delete on table
"fact_values" violates foreign key constraint "fact_value_id_fk" on
table "facts"
< 2017-04-25 12:13:03.519 CEST >ERROR: function getallmacpoolrangesbymacpoolid()
does not exist at character 16
< 2017-04-25 12:21:29.827 CEST >ERROR: function gettagsbyparent_id() does not
exist at character 16
< 2017-04-25 12:21:29.865 CEST >ERROR: function getallmacpoolrangesbymacpoolid()
does not exist at character 16
But the first one is old:
grep fact_value_id_fk /data/pgsql/9.4/data/pg_log/postgresql-*
/data/pgsql/9.4/data/pg_log/postgresql-Mon.log:< 2017-04-24 03:38:33.212 CEST
>ERROR: update or delete on table "fact_values" violates foreign key
constraint "fact_value_id_fk" on table "facts"
/data/pgsql/9.4/data/pg_log/postgresql-Sat.log:< 2017-04-22 04:12:59.608 CEST
>ERROR: update or delete on table "fact_values" violates foreign key
constraint "fact_value_id_fk" on table "facts"
/data/pgsql/9.4/data/pg_log/postgresql-Sun.log:< 2017-04-23 03:52:01.341 CEST
>ERROR: update or delete on table "fact_values" violates foreign key
constraint "fact_value_id_fk" on table "facts"
/data/pgsql/9.4/data/pg_log/postgresql-Tue.log:< 2017-04-25 03:23:08.098 CEST
>ERROR: update or delete on table "fact_values" violates foreign key
constraint "fact_value_id_fk" on table "facts"
ovirt was working on monday morgning, I'm positive about that.
--
Didi