Обсуждение: Issue with postgres 11beta2 and powa on debian stretch amd64

Hello,

I installed postgresql-11-powa on a fresh debian stretch amd64 with
postgresql-11 beta2

I got several errors "set-valued function called in context that cannot accept a
set" which should be fixed :
2018-07-22 14:16:22.209 CEST [30135] WARNING:  powa_take_snapshot(): function
"powa_user_functions_snapshot" failed:
                      state  : 0A000
                      message: set-valued function called in context that cannot
accept a set
                      detail :
                      hint   :
                      context: SQL statement "WITH func(dbid, r) AS (
                SELECT oid,
                    powa_stat_user_functions(oid)
                FROM pg_database
            )
            INSERT INTO powa_user_functions_history_current
                SELECT dbid, (r).funcid,
                ROW(now(), (r).calls,
                    (r).total_time,
                    (r).self_time)::powa_user_functions_history_record AS record
                FROM func"
        PL/pgSQL function powa_user_functions_snapshot() line 10 at SQL statement
        SQL statement "SELECT powa_user_functions_snapshot()"
        PL/pgSQL function powa_take_snapshot() line 76 at EXECUTE
        SQL statement "SELECT powa_take_snapshot()"


FYI, I do not have this error if I build powa from github's sources. So, I seems
it is a packing issue.

Thanks

--
Adrien NAYRAT

Re: Adrien Nayrat 2018-07-22 <924f10ca-5d97-261e-8074-3763fbbe86c9@anayrat.info>
> Hello,
> 
> I installed postgresql-11-powa on a fresh debian stretch amd64 with
> postgresql-11 beta2
> 
> I got several errors "set-valued function called in context that cannot accept a
> set" which should be fixed :

Hi,

this is caused by a change between PG11 beta1 and beta2 which causes
several extensions to fail with that error message. Fixed by
recompiling the postgresql-11-powa packages.

> FYI, I do not have this error if I build powa from github's sources. So, I seems
> it is a packing issue.

Additionally, the testsuite was faulty in two ways, firstly it didn't
depend on postgresql-server-dev-all so pg_buildext was not available
which made the for-loop [1] a no-op, and secondly it didn't actually
invoke any functions, so it wouldn't have spotted this problem anyway.
(Now fixed in lines 11-14.)

[1] https://github.com/powa-team/powa-archivist/blob/master/debian/tests/create-extension#L5

Thanks for spotting and reporting!

Christoph

On 07/22/2018 08:31 PM, Christoph Berg wrote:
> Re: Adrien Nayrat 2018-07-22 <924f10ca-5d97-261e-8074-3763fbbe86c9@anayrat.info>
>> Hello,
>>
>> I installed postgresql-11-powa on a fresh debian stretch amd64 with
>> postgresql-11 beta2
>>
>> I got several errors "set-valued function called in context that cannot accept a
>> set" which should be fixed :
>
> Hi,
>
> this is caused by a change between PG11 beta1 and beta2 which causes
> several extensions to fail with that error message. Fixed by
> recompiling the postgresql-11-powa packages.
>
>> FYI, I do not have this error if I build powa from github's sources. So, I seems
>> it is a packing issue.
>
> Additionally, the testsuite was faulty in two ways, firstly it didn't
> depend on postgresql-server-dev-all so pg_buildext was not available
> which made the for-loop [1] a no-op, and secondly it didn't actually
> invoke any functions, so it wouldn't have spotted this problem anyway.
> (Now fixed in lines 11-14.)

Thanks!

>
> [1] https://github.com/powa-team/powa-archivist/blob/master/debian/tests/create-extension#L5
>
> Thanks for spotting and reporting!
>
> Christoph
>