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

2013-07-11 Thread Steven Schlansker
On Jul 8, 2013, at 6:48 AM, Jov wrote: > netstat show nothing about the socket of the process,so I think the TCP > timeout took effect.so it is really wired. > > Jov > blog: http:amutu.com/blog > > > 2013/7/8 Tom Lane > Merlin Moncure writes: > > On Mon, Jul 8, 2013 at 4:56 AM, Jov wrote:

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

2013-07-11 Thread Steven Schlansker
On Jul 8, 2013, at 6:48 AM, Jov wrote: > netstat show nothing about the socket of the process,so I think the TCP > timeout took effect.so it is really wired. > > Jov > blog: http:amutu.com/blog > > > 2013/7/8 Tom Lane > Merlin Moncure writes: >> On Mon, Jul 8, 2013 at 4:56 AM, Jov wrote: >

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

2013-07-08 Thread Jov
n etstat show nothing about the socket of the process,so I think the TCP timeout took effect.so it is really wired. Jov blog: http:amutu.com/blog 2013/7/8 Tom Lane > Merlin Moncure writes: > > On Mon, Jul 8, 2013 at 4:56 AM, Jov wrote: > >> my first post already try t

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

2013-07-08 Thread Tom Lane
Merlin Moncure writes: > On Mon, Jul 8, 2013 at 4:56 AM, Jov 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

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

2013-07-08 Thread Merlin Moncure
On Mon, Jul 8, 2013 at 4:56 AM, Jov 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? merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

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

2013-07-08 Thread Jov
my first post already try the pg_terminate_backend but failed: pg_terminate_backend return t but the backend still there. Jov blog: http:amutu.com/blog 2013/7/8 Bill Mitchell > Hmm.. > In that case, I think that select pg_terminate_backend() might be in order? > > h

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

2013-07-08 Thread Bill Mitchell
Hmm.. In that case, I think that select pg_terminate_backend() might be in order? http://www.postgresql.org/docs/9.1/static/functions-admin.html regards, Bill On 7/8/13 5:46 AM, Jov wrote: > we do select pg_cancel_backend(8243) several times,but the backend > still hang there. > > Jov > blog: ht

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

2013-07-08 Thread Jov
we do select pg_cancel_backend(8243) several times,but the backend still hang there. Jov blog: http:amutu.com/blog 2013/7/8 Bill Mitchell > You can do select pg_cancel_backend(8243); > > and that should terminate that process that is sending, but still leave > your pos

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

2013-07-08 Thread Bill Mitchell
You can do select pg_cancel_backend(8243); and that should terminate that process that is sending, but still leave your postgres server healthy. regards, Bill On 7/8/13 5:31 AM, Jov wrote: > one of our pg user send a select * from 10 million table without limit > from psql,before get the return

[GENERAL] backend hangs at sendto() and can't be terminated

2013-07-08 Thread Jov
one of our pg user send a select * from 10 million table without limit from psql，before get the return data，he realize the mistake and quite from psql.but after 2 hours,the sql still alive: postgres=# SELECT * from pg_stat_activity where procpid = 8243; -[ RECORD 1 ]+--