Re: unable to kill locked user session!

Hi,

On Thu, Feb 25, 2021 at 7:30 AM Ganesh Korde <ganeshakorde(at)gmail(dot)com> wrote:

>
>
> On Thu, 25 Feb 2021, 3:06 pm dbatoCloud Solution, <dbatocloud17(at)gmail(dot)com>
> wrote:
>
>> Hi All,
>>
>> Someone help on the killing the user session. I tried to use it but still
>> unable to kill it and no blocking session.
>>
>> pg_terminate_backend(pid)
>> pg_cancel_backend(pid)
>>
>> Is there any other way to kill session?
>>
> Interested to see what is happening based on the output of
pg_stat_activity. Is that some session that is connecting to a foreign
server using some FDW ?
Also, never attempt to kill a process using kill -9 as it may crash your
PostgreSQL cluster with the following message.

WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back
thecurrent transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.

>>
>> Thanks & Best Wishes,
>>
>> Ashok
>>
>>
>>
>>
>> ---------------------------------------------------------------------------------------------------------------------
>>
>> Ashokkumar Mani *(OCP12c/11g/10g/9i, AWS SAA, M103)*
>>
>> *Dubai** , UAE* *| BLR , INDIA*
>>
>> M: *+971 54 723 0075 *| *+91 90086 70302 | *WApp :* +91 81975 99922*
>>
>> W: https://dbatocloudsolution.blogspot.in/
>> <http://dbatocloudsolution.blogspot.in/> | E: dbatocloud17(at)gmail(dot)com
>>
> If you have OS access, kill that process from OS.
>
>

--
Regards,
Avinash Vallarapu