pg.ddx.io pgsql-pkg-debian@postgresql.org mailing list archive
help / color / mirror / Atom feedIssue with postgres 11beta2 and powa on debian stretch amd64
3+ messages / 2 participants
[nested] [flat]
* Issue with postgres 11beta2 and powa on debian stretch amd64
@ 2018-07-22 12:40 Adrien Nayrat <adrien.nayrat@anayrat.info>
0 siblings, 1 reply; 3+ messages in thread
From: Adrien Nayrat @ 2018-07-22 12:40 UTC (permalink / raw)
To: pgsql-pkg-debian@lists.postgresql.org
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
Attachments:
signature.asc (application/pgp-signature, 487B) download
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Issue with postgres 11beta2 and powa on debian stretch amd64
@ 2018-07-22 18:31 Christoph Berg <myon@debian.org>
parent: Adrien Nayrat <adrien.nayrat@anayrat.info>
0 siblings, 1 reply; 3+ messages in thread
From: Christoph Berg @ 2018-07-22 18:31 UTC (permalink / raw)
To: Adrien Nayrat <adrien.nayrat@anayrat.info>; +Cc: pgsql-pkg-debian@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Issue with postgres 11beta2 and powa on debian stretch amd64
@ 2018-07-23 06:40 Adrien Nayrat <adrien.nayrat@anayrat.info>
parent: Christoph Berg <myon@debian.org>
0 siblings, 0 replies; 3+ messages in thread
From: Adrien Nayrat @ 2018-07-23 06:40 UTC (permalink / raw)
To: Christoph Berg <myon@debian.org>; +Cc: pgsql-pkg-debian@lists.postgresql.org
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
>
Attachments:
signature.asc (application/pgp-signature, 487B) download
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2018-07-23 06:40 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-07-22 12:40 Issue with postgres 11beta2 and powa on debian stretch amd64 Adrien Nayrat <adrien.nayrat@anayrat.info>
2018-07-22 18:31 ` Christoph Berg <myon@debian.org>
2018-07-23 06:40 ` Adrien Nayrat <adrien.nayrat@anayrat.info>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox