Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] postgres: dbname dbuser 9.9.9.9[2222] PARSE waiting - Mailing list pgsql-general

From David G. Johnston
Subject Re: [GENERAL] postgres: dbname dbuser 9.9.9.9[2222] PARSE waiting
Date
Msg-id CAKFQuwaiOc_5YNSKexKG3ScsGomA4eC0O0ZOqTNyOskKhV8bSA@mail.gmail.com
Whole thread Raw
In response to [GENERAL] postgres: dbname dbuser 9.9.9.9[2222] PARSE waiting  (DrakoRod <drakoflames@hotmail.com>)
List pgsql-general
Tree view
On Tue, Jun 27, 2017 at 1:10 PM, DrakoRod <drakoflames@hotmail.com> wrote:
postgres  9741 23340  9 14:55 ?        00:00:47 postgres: dbname user
8.8.8.8[54286] idle in transaction

Any suggestions?

​There is a serious lack of information provided here but "idle in transaction" sessions are generally problematic (in particular they continue to hold locks) and can only be fixed at the source - by fixing code or user behavior.

David J.

pgsql-general by date:

Previous
From: armand pirvu
Date:
Subject: Re: [GENERAL] insert on conflict
Next
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] postgres: dbname dbuser 9.9.9.9[2222] PARSE waiting