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

From DrakoRod
Subject Re: [GENERAL] postgres: dbname dbuser 9.9.9.9[2222] PARSE waiting
Date
Msg-id 1498836991420-5969552.post@n3.nabble.com
Whole thread Raw
In response to Re: [GENERAL] postgres: dbname dbuser 9.9.9.9[2222] PARSE waiting  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: [GENERAL] postgres: dbname dbuser 9.9.9.9[2222] PARSE waiting
List pgsql-general
> Do you control the app?

Nop Just I know how it's developed.

> The app has a pooling component and you still are having problems, have
> you looked at what the pooler is actually doing?

As far as I know, the wildfly's jdbc pool. No really I don't know what are
doing. I suspect that problem is that in DAO's not are closing the sessions
or not beginning transactions properly. I going to ask them send me the
logfile or I'll could verify the pool behavior.

> Not sure what the above means. Are you saying the application you refer
> to above has a history of not correctly closing connections or are you
> talking in general terms about applications interacting with databases.

Sorry, it's not like that, just was a comment, The problem I have is with a
specific application.

> I've attached two files that may be helpful to you.

Melvin , Thanks for the scripts! I owe one!

I have another question, I've was reading about the lock_timeout, Somehow
this parameter will help or could affect all the behaviour?

Thanks!






-----
Dame un poco de fe, eso me bastará.
Rozvo Ware Solutions
--
View this message in context:
http://www.postgresql-archive.org/postgres-dbname-dbuser-9-9-9-9-2222-PARSE-waiting-tp5968923p5969552.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Timokhin Maxim
Date:
Subject: Re: [GENERAL] duplicate key value violates unique constraint and duplicated records
Next
From: Melvin Davidson
Date:
Subject: Re: [GENERAL] postgres: dbname dbuser 9.9.9.9[2222] PARSE waiting