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

[Fabrice Bacchella]

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