Search Postgresql Archives

Re: backend hangs at sendto() and can't be terminated

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Merlin Moncure <mmoncure@xxxxxxxxx> writes:
> On Mon, Jul 8, 2013 at 4:56 AM, Jov <amutu@xxxxxxxxx> wrote:
>> my first post already try the pg_terminate_backend but failed:
>> pg_terminate_backend return t but the backend still there.

> possibly a kernel problem?

The backend will keep trying to send data until the kernel informs it
the connection is lost.  (Anything else would be a bad idea.)  So the
real question here is why it's taking so long for the TCP stack to
decide that the client is gone.  I'm wondering what exactly you did
to kill the psql session.  Most ordinary ways of killing a process
should result in closure of whatever connections it had open.

If you'd lost network connectivity to the client, a TCP timeout on the
order of an hour wouldn't be surprising.  (If you feel this is too long,
you can fool with the TCP keepalive parameters.)  But it seems unlikely
that that's what's happening here.

			regards, tom lane


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux