Postgres Pro
Downloads
Home   >   mailing lists

Debugging a backend stuck consuming CPU - Mailing list pgsql-general

From ktm@rice.edu
Subject Debugging a backend stuck consuming CPU
Date
Msg-id 20160519134615.GB32767@aart.rice.edu
Whole thread Raw
Responses Re: Debugging a backend stuck consuming CPU  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Debugging a backend stuck consuming CPU  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Debugging a backend stuck consuming CPU  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
Tree view 
Hi PostgreSQL community,

I am investigating a problem with a backend that appears to be stuck
and spinning while performing a "DISCARD ALL" command. The system is
running an older release 9.2.2. Are there any bugs that could be
causing this behavior? How can I tell what the process is actually
doing? It does not respond to either pg_cancel_backend() or to
pg_terminate_backend() so it is acting like it is not receiving the
signals. Any ideas on how to debug this would be appriciated.

Regards,
Ken

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: first_value/last_value
Next
From: Tom Lane
Date:
Subject: Re: Debugging a backend stuck consuming CPU