there's someone who knows this error " Sorry too many clients are already logged" ,even if i increase number of connection pool size in my persistence like that.i still have it Any help please this error blocks my progress !!!
Asked
Active
Viewed 771 times
-4
-
this question already have answers http://stackoverflow.com/questions/2757549/org-postgresql-util-psqlexception-fatal-sorry-too-many-clients-already – lakshman May 23 '15 at 10:35
-
1i solve it i forgot to close my session :) – fatima zahra zacraoui May 23 '15 at 13:39
-
i saw it my friend but i had an other problem anyway thank you – fatima zahra zacraoui May 23 '15 at 13:43
1 Answers
0
That error points at a connection leak. If you create new connections without releasing all of them, you'll eventually run out!
Have a look at pg_activity. It's a "top" for Postgres and can often quickly identify the source of the leak. Another option is to set Postgres to more verbose logging and analyse the log file.
Andomar
- 232,371
- 49
- 380
- 404
-
thank you i solve it , i forgot to close my session i'm using Hibernate :) – fatima zahra zacraoui May 23 '15 at 16:49