From: | DrakoRod <drakoflames(at)hotmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: postgres: dbname dbuser 9.9.9.9[2222] PARSE waiting |
Date: | 2017-06-30 15:36:31 |
Message-ID: | 1498836991420-5969552.post@n3.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Melvin Davidson | 2017-06-30 16:19:32 | Re: postgres: dbname dbuser 9.9.9.9[2222] PARSE waiting |
Previous Message | Timokhin Maxim | 2017-06-30 14:33:42 | Re: duplicate key value violates unique constraint and duplicated records |