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

[Yedidyah Bar David]

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

> < 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