Hello,
This issue is comming from the fact that you are probably using more than the
100 connections of the postgres due
to an high number of Stores defined.
The solution is:
- augment the number of connections in your database
- or go to define the connection pool on tomcat level. (the better solution)
http://docs.geoserver.org/stable/en/user/tutorials/tomcat-jndi/tomcat-jndi.html
Regards,
Eric Smets
Op 21/02/2014 17:01, Simone Giannecchini schreef:
Ciao,
please, keep the discussion on the ml.
See my comments inline below...
Regards,
Simone Giannecchini
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.
==
Ing. Simone Giannecchini
@simogeo
Founder/Director
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 333 8128928
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
-------------------------------------------------------
On Fri, Feb 21, 2014 at 4:39 PM, tam tran <[email protected]
<mailto:[email protected]>> wrote:
Hi Simone,
Thanks for your response. I know the log is clear that the connection
pool is full. But what is the cause? Does it mean the max_connection =
100 that I allocated to the datastores in GeoServer is too high? In order
words, I need to know what causes it and how do I fix the problem. Is it
in datastores configuration, Tomcat configuration, or postgresql.conf?
Any help is greatly appreciated.
By default postgresql won't allow more than 100 connections so 100 as Max in
geoserver pool config is just as much as pg can handle without changes to the
config.
That said, I believe your problem is that somehow you are using more than 100
concurrent connection and the thread handling the N-th request is dying
waiting for a new connection
which is not being made available.
Regards,
Tam
On Fri, Feb 21, 2014 at 4:48 AM, Simone Giannecchini
<[email protected]
<mailto:[email protected]>> wrote:
Ciao,
the log is clear:
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a
connection, pool error Timeout waiting for idle object
you are running out of connections from the pool.
Regards,
Simone Giannecchini
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for
more information.
==
Ing. Simone Giannecchini
@simogeo
Founder/Director
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313 <tel:%2B39%200584%20962313>
fax: +39 0584 1660272 <tel:%2B39%200584%201660272>
mob: +39 333 8128928 <tel:%2B39%20%C2%A0333%208128928>
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
-------------------------------------------------------
------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Eric Smets [email protected]
FKS bvba - Formal and Knowledge Systems http://www.fks.be/
Schampbergstraat 32 Tel: ++32-(0)11-21 49 11
B-3511 Hasselt Fax: ++32-(0)11-22 04 19
------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
