after upgrade from 4.0.4 to 4.1.1, no more gettagsbyparent_id

I tried to upgrade from 4.0 to 4.1, I ran engine-setup And now ovirt-engine start fails with command like: Caused by: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select * from gettagsbyparent_id()]; nested exception is org.postgresql.util.PSQLException: ERROR: function gettagsbyparent_id() does not exist In the setup log I indeed found: drop function if exists public.gettagsbyparent_id(uuid) cascade; But nothing else. This function is not recreated. Any hint about what happened ?

That's weird. Can you attach the complete setup log? I can see the function still exists in the code in 4.1.1, and during the setup we do create or replace for all stored procedures. CC-ing Eli and Didi as well. I guess you can manually run it to add it back, but they will know best. On Mon, Apr 24, 2017 at 4:32 PM, Fabrice Bacchella < fabrice.bacchella@orange.fr> wrote:
I tried to upgrade from 4.0 to 4.1, I ran engine-setup
And now ovirt-engine start fails with command like:
Caused by: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select * from gettagsbyparent_id()]; nested exception is org.postgresql.util.PSQLException: ERROR: function gettagsbyparent_id() does not exist
In the setup log I indeed found:
drop function if exists public.gettagsbyparent_id(uuid) cascade;
But nothing else. This function is not recreated. Any hint about what happened ?
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
participants (2)
-
Fabrice Bacchella
-
Oved Ourfali