Обсуждение: Quit currently running query

2023年2月28日(火) 22:30 Albert Cornelius <albert1.cornelius@gmail.com>:
>
> How can I quit a currently running query? I've issued a query and my server does not respond anymore. Is there
anothersolution than using kill -9? 

See here:

  https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL

Regards

Ian Barwick

On 2/28/23 04:53, Albert Cornelius wrote:

How can I quit a currently running query? I've issued a query and my server does not respond anymore. Is there another solution than using kill -9?

What specifically do you mean by "my server does not respond anymore"?  Because if "the server" really doesn't respond anymore, you can't even issue "kill -9".

I'd first try "select pg_cancel_backend(<pid>);".  If that doesn't work, try "select pg_terminate_backend(<pid>);", which is the Postgresql-aproved version of "kill -9".

How can I quit a currently running query? I've issued a query and my server does not respond anymore. Is there another solution than using kill -9?

can you open another psql session to your server?

On 2023-02-28 07:42:08 -0600, Ron wrote:
> On 2/28/23 04:53, Albert Cornelius wrote:
>
>     How can I quit a currently running query? I've issued a query and
>     my server does not respond anymore. Is there another solution than
>     using kill -9?
>
>
> What specifically do you mean by "my server does not respond
> anymore"?  Because if "the server" really doesn't respond anymore, you
> can't even issue "kill -9".

The term "server" can mean different things:

1) A role in an interaction between two programs. The "client" is the one
   which issues requests, and the "server" is the one which fullfills
   them.

2) A program which is intended for the server role. Note that a program
   can be a server for one protocol and a client for another (e.g., a
   database server can be a DNS or LDAP client). (And some programs are
   even server and client for the same protocol)

3) A machine intended for running server programs.

You are thinking of the 3rd meaning. My guess is that Albert meant the
first.

        hp


--
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"

On 2/28/23 11:31, Peter J. Holzer wrote:
> On 2023-02-28 07:42:08 -0600, Ron wrote:
>> On 2/28/23 04:53, Albert Cornelius wrote:
>>
>>      How can I quit a currently running query? I've issued a query and
>>      my server does not respond anymore. Is there another solution than
>>      using kill -9?
>>
>>
>> What specifically do you mean by "my server does not respond
>> anymore"?  Because if "the server" really doesn't respond anymore, you
>> can't even issue "kill -9".
> The term "server" can mean different things:
>
> 1) A role in an interaction between two programs. The "client" is the one
>     which issues requests, and the "server" is the one which fullfills
>     them.
>
> 2) A program which is intended for the server role. Note that a program
>     can be a server for one protocol and a client for another (e.g., a
>     database server can be a DNS or LDAP client). (And some programs are
>     even server and client for the same protocol)
>
> 3) A machine intended for running server programs.
>
> You are thinking of the 3rd meaning. My guess is that Albert meant the
> first.

And maybe he's referring to his client software... That's why I asked him 
for clarification.

-- 
Born in Arizona, moved to Babylonia.