[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:14 PM, Fabrice Bacchella
<fabrice.bacchella at orange.fr> wrote:
>
>> Le 25 avr. 2017 à 12:05, Yedidyah Bar David <didi at redhat.com> a écrit :
>>
>> On Tue, Apr 25, 2017 at 12:14 PM, Fabrice Bacchella
>> <fabrice.bacchella at orange.fr> wrote:
>>>
>>>> Le 25 avr. 2017 à 10:27, Yedidyah Bar David <didi at redhat.com> a écrit :
>>>>
>>>>
>>>
>>>> So all was good until you changed (downgraded?) your pg client? So
>>>> perhaps try to revert that. Although if you didn't change your jdbc
>>>> library, I do not think this should have affected you. But in any
>>>> case, if the failure was not caused by running 'engine-setup', it's
>>>> most likely not due to a bug in engine-setup, but elsewhere.
>>>
>>> Possible, but for the moment, I need a way to get out of this trap. My ovirt engine is broken.
>>
>> Your db dump does have gettagsbyparent_id, so that's not the problem.
>> I am not an expert in the engine side, no idea otherwise.
>
> But:
>
> su - postgres
>  $ psql ovirt_engine
> psql (9.4.11)
> Type "help" for help.
>
> ovirt_engine=# select * from  getallmacpoolrangesbymacpoolid();
> ERROR:  function getallmacpoolrangesbymacpoolid() does not exist
> LINE 1: select * from  getallmacpoolrangesbymacpoolid();
>                        ^
> HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
>

Because it requires a uuid parameter.
-- 
Didi