Re: circular wait not triggering deadlock ?

On Thu, Mar 08, 2018 at 03:05:36PM -0500, Tom Lane wrote:
> Justin Pryzby <pryzby(at)telsasoft(dot)com> writes:
> > On Thu, Mar 08, 2018 at 01:57:06PM -0500, Tom Lane wrote:
> >> PID 20488 is evidently waiting for PID 6471 to finish its transaction.
> >> What's that one doing?
>
> > Um, I thought I had kept track of all two pids but looks not..
> > query | SELECT pg_export_snapshot();
>
> pg_export_snapshot doesn't block for other transactions, though.
> Further down, you have output that confirms that:
>
> > 6471 | idle in transaction | psql | SELECT pg_export_snapshot();
>
> That SELECT is the most recently completed command, not the current one.
> So now the question is what the connected application is waiting for
> before committing.

I believe it does an idle loop around sleep(1), until all the pg_dump
--snapshot children are done.

Justin