search

powa-team / powa

PostgreSQL Workload Analyzer
http://powa.readthedocs.io/
PostgreSQL License
768 stars 57 forks source link

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

Closed banlex73 closed 3 years ago

banlex73 commented 3 years ago

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 commented 3 years ago

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 commented 3 years ago

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 notifications@github.com пише:

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 https://github.com/powa-team/powa/issues/142#issuecomment-709701579, or unsubscribe https://github.com/notifications/unsubscribe-auth/AIHWEYCF656FMJMSUTRVCJLSK6ZPJANCNFSM4SSQ6DWQ .

rjuju commented 3 years ago

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

rjuju commented 3 years ago

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