Error while calling public.powa_wait_sampling_src: canceling statement due to lock timeout

[banlex73]

Getting Error while calling public.powa_wait_sampling_src: canceling statement due to lock timeout CONTEXT: PL/pgSQL function powa_wait_sampling_src(integer) line 4 at RETURN QUERYon.
Root cause: powa_wait_sampling extension on server blocks SELECT <>, * FROM public.powa_wait_sampling_src(0)
Cluster restart helps.

[rjuju]

Hello,

powa_wait_sampling extension on server blocks SELECT <>, * FROM public.powa_wait_sampling_src(0)

Do you mean pg_wait_sampling extension or something specific to powa_wait_sampling table?

This is likely a problem with pg_wait_sampling extension. I think I already saw a similar problem using older versions of pg_wait_sampling extension. Which version are you using?

If the problems reappears, could you show the full content of pg_stat_activity and pg_locks on the underlying remote server?

[banlex73]

Hi Julien I agree with you that it's rather *pg_wait_sampling *issue. I am on the 1.1 version. Last January they released version 1.1.1 *, *So, I have upgraded my dev environment today, hope it will fix the problem. <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Virus-free. www.avast.com <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> чт, 15 жовт. 2020 о 20:01 Julien Rouhaud <[email protected]> пише:

…

Hello, powa_wait_sampling extension on server blocks SELECT <>, * FROM public.powa_wait_sampling_src(0) Do you mean pg_wait_sampling extension or something specific to powa_wait_sampling table? This is likely a problem with pg_wait_sampling extension. I think I already saw a similar problem using older versions of pg_wait_sampling extension. Which version are you using? If the problems reappears, could you show the full content of pg_stat_activity and pg_locks on the underlying remote server? — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#142 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AIHWEYCF656FMJMSUTRVCJLSK6ZPJANCNFSM4SSQ6DWQ> .

[rjuju]

Hello @banlex73. For the record the problem is likely due to postgrespro/pg_wait_sampling#29 (and postgrespro/pg_wait_sampling#18 There's a PR to fix that at postgrespro/pg_wait_sampling#31, so at we just have to wait to it to be merged and released.

[rjuju]

As far as I can see this has been merged and released, so I'm closing this issue!