On 1/20/11 2:26 PM, Tom Lane wrote:
> Josh Berkus writes:
>>> I would take that to mean that it's waiting on the client.
>
>> You mean that the client timed out and isn't accepting data from the
>> query anymore?
>
> No, if the backend is in RECV state, it's waiting for the client to
> *send* it
Josh Berkus writes:
>> I would take that to mean that it's waiting on the client.
> You mean that the client timed out and isn't accepting data from the
> query anymore?
No, if the backend is in RECV state, it's waiting for the client to
*send* it something.
(Although if this is an SSL connecti
> I would take that to mean that it's waiting on the client.
You mean that the client timed out and isn't accepting data from the
query anymore? Shouldn't Postgres time out on that after a while? In
one case, the orphaned statement was 16 hours old before we killed it.
If it's relevant, the cl
Josh Berkus 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
> I have seen it -- on 8.1 too. On our case it was caused by an insert
> that was doing lots of toast insertions, so it needed to grab the
> extension lock frequently for the toast table; and this was slowed
> down by a largish shared_buffers setting, somehow (8.1 doesn't have lock
> partitioning
Excerpts from Josh Berkus's message of jue ene 20 18:05:15 -0300 2011:
>
> 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
Hackers,
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.
This problem only happen
