pg.ddx.io  pgsql-pkg-debian@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Issue 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>
  2018-07-22 18:31 ` Re: Issue with postgres 11beta2 and powa on debian stretch amd64 Christoph Berg <myon@debian.org>
  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 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   ` Re: Issue with postgres 11beta2 and powa on debian stretch amd64 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-22 12:40 Issue with postgres 11beta2 and powa on debian stretch amd64 Adrien Nayrat <adrien.nayrat@anayrat.info>
  2018-07-22 18:31 ` Re: Issue with postgres 11beta2 and powa on debian stretch amd64 Christoph Berg <myon@debian.org>
@ 2018-07-23 06:40   ` Adrien Nayrat <adrien.nayrat@anayrat.info>
  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