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]> 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]> 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
>> fax: +39 0584 1660272
>> mob: +39 333 8128928
>>
>> 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
