Re: Orphaned statements issue - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Orphaned statements issue
Date
Msg-id 21534.1295559410@sss.pgh.pa.us
Whole thread Raw
In response to Orphaned statements issue  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Orphaned statements issue  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
Josh Berkus <josh@agliodbs.com> writes:
> One of our clients is seeing an unusual issue with statements which are
> waiting going into sleep forever and never completing.   This first
> e-mail is for a "has anyone else seen this problem before?" while we try
> to collect additional information for a diagnosis.

> An strace on the process shows it to be in RECV, and otherwise doing
> nothing.

I would take that to mean that it's waiting on the client.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: ALTER TABLE ... REPLACE WITH
Next
From: "Simone Aiken"
Date:
Subject: Re: ToDo List Item - System Table Index Clustering