Hi,
I am suffering the typical "too many connections" to PostgreSQL while using Geoserver. Seems that for every new request for a featureType in a PostGIS data store a new connection to the database is stablished... Therefore the list of postmasters running in the system start growing until it reach the 300 limit I have in my PostgreSQL configuration file...
I have the impression that this was not happening to me before, strange...
Is Geoserver closing the connections after each request?
Thanks.
Javier.
JTorre.vcf (278 Bytes)
Yeah, it normally sets up a nice pool and shares all the connections. If it's going up on every request then something's going wrong. What operation are you doing? And what version of GeoServer? In the past a few minor changes have lead to connection pool mess ups, though generally in the less used operations.
Chris
Javier de la Torre wrote:
Hi,
I am suffering the typical "too many connections" to PostgreSQL while using Geoserver. Seems that for every new request for a featureType in a PostGIS data store a new connection to the database is stablished... Therefore the list of postmasters running in the system start growing until it reach the 300 limit I have in my PostgreSQL configuration file...
I have the impression that this was not happening to me before, strange...
Is Geoserver closing the connections after each request?
Thanks.
Javier.
------------------------------------------------------------------------
begin:vcard
fn:Javier de la Torre
n:de la Torre;Javier
org:Museo Nacional de Ciencias Naturales (CSIC)
adr:;;C/Jose Gutierrez Abascal, 2;Madrid;Madrid;28006;Spain
email;internet:jatorre@anonymised.com
title:Scientist
url:http://www.biogeografia.com/edit/
version:2.1
end:vcard
------------------------------------------------------------------------
--
Chris Holmes
The Open Planning Project
http://topp.openplans.org
Hi Chris,
I am using 1.3.1 Beta. I am doing just simple WMS getMap requests for a Google Maps mashup. When viewing a map maybe 20 request are sent to Geoserver one for each tile to be overlapped in Google maps.
I did not try with the stable 1.3.0 version sorry.
More info. I am running it on Red Hat 9 with PostgreSQL 8.1.3 and Postgis 1.1.2
Javier.
On 12/05/2006, at 16:51, Chris Holmes wrote:
Yeah, it normally sets up a nice pool and shares all the connections. If it's going up on every request then something's going wrong. What operation are you doing? And what version of GeoServer? In the past a few minor changes have lead to connection pool mess ups, though generally in the less used operations.
Chris
Javier de la Torre wrote:
Hi,
I am suffering the typical "too many connections" to PostgreSQL while using Geoserver. Seems that for every new request for a featureType in a PostGIS data store a new connection to the database is stablished... Therefore the list of postmasters running in the system start growing until it reach the 300 limit I have in my PostgreSQL configuration file...
I have the impression that this was not happening to me before, strange...
Is Geoserver closing the connections after each request?
Thanks.
Javier.
------------------------------------------------------------------------
begin:vcard
fn:Javier de la Torre
n:de la Torre;Javier
org:Museo Nacional de Ciencias Naturales (CSIC)
adr:;;C/Jose Gutierrez Abascal, 2;Madrid;Madrid;28006;Spain
email;internet:jatorre@anonymised.com
title:Scientist
url:http://www.biogeografia.com/edit/
version:2.1
end:vcard
------------------------------------------------------------------------
--
Chris Holmes
The Open Planning Project
http://topp.openplans.org
<cholmes.vcf>
JTorre.vcf (278 Bytes)
Could I convince you to maybe try 1.3.0? If it works fine then there's definitely a bug in GeoTools 2.2.x that we should fix before 1.3.1 official.
thanks!
Chris
Javier de la Torre wrote:
Hi Chris,
I am using 1.3.1 Beta. I am doing just simple WMS getMap requests for a Google Maps mashup. When viewing a map maybe 20 request are sent to Geoserver one for each tile to be overlapped in Google maps.
I did not try with the stable 1.3.0 version sorry.
More info. I am running it on Red Hat 9 with PostgreSQL 8.1.3 and Postgis 1.1.2
Javier.
On 12/05/2006, at 16:51, Chris Holmes wrote:
Yeah, it normally sets up a nice pool and shares all the connections. If it's going up on every request then something's going wrong. What operation are you doing? And what version of GeoServer? In the past a few minor changes have lead to connection pool mess ups, though generally in the less used operations.
Chris
Javier de la Torre wrote:
Hi,
I am suffering the typical "too many connections" to PostgreSQL while using Geoserver. Seems that for every new request for a featureType in a PostGIS data store a new connection to the database is stablished... Therefore the list of postmasters running in the system start growing until it reach the 300 limit I have in my PostgreSQL configuration file...
I have the impression that this was not happening to me before, strange...
Is Geoserver closing the connections after each request?
Thanks.
Javier.
--------------------------------------------------------------------- ---
begin:vcard
fn:Javier de la Torre
n:de la Torre;Javier
org:Museo Nacional de Ciencias Naturales (CSIC)
adr:;;C/Jose Gutierrez Abascal, 2;Madrid;Madrid;28006;Spain
email;internet:jatorre@anonymised.com
title:Scientist
url:http://www.biogeografia.com/edit/
version:2.1
end:vcard
--------------------------------------------------------------------- ---
--
Chris Holmes
The Open Planning Project
http://topp.openplans.org
<cholmes.vcf>
------------------------------------------------------------------------
begin:vcard
fn:Javier de la Torre
n:de la Torre;Javier
org:Museo Nacional de Ciencias Naturales (CSIC)
adr:;;C/Jose Gutierrez Abascal, 2;Madrid;Madrid;28006;Spain
email;internet:jatorre@anonymised.com
title:Scientist
url:http://www.biogeografia.com/edit/
version:2.1
end:vcard
------------------------------------------------------------------------
--
Chris Holmes
The Open Planning Project
http://topp.openplans.org
Right...
It does not happened in 1.3.0...
I stay with the stable 
Thanks.
Javier.
On 13/05/2006, at 1:03, Chris Holmes wrote:
Could I convince you to maybe try 1.3.0? If it works fine then there's definitely a bug in GeoTools 2.2.x that we should fix before 1.3.1 official.
thanks!
Chris
Javier de la Torre wrote:
Hi Chris,
I am using 1.3.1 Beta. I am doing just simple WMS getMap requests for a Google Maps mashup. When viewing a map maybe 20 request are sent to Geoserver one for each tile to be overlapped in Google maps.
I did not try with the stable 1.3.0 version sorry.
More info. I am running it on Red Hat 9 with PostgreSQL 8.1.3 and Postgis 1.1.2
Javier.
On 12/05/2006, at 16:51, Chris Holmes wrote:
Yeah, it normally sets up a nice pool and shares all the connections. If it's going up on every request then something's going wrong. What operation are you doing? And what version of GeoServer? In the past a few minor changes have lead to connection pool mess ups, though generally in the less used operations.
Chris
Javier de la Torre wrote:
Hi,
I am suffering the typical "too many connections" to PostgreSQL while using Geoserver. Seems that for every new request for a featureType in a PostGIS data store a new connection to the database is stablished... Therefore the list of postmasters running in the system start growing until it reach the 300 limit I have in my PostgreSQL configuration file...
I have the impression that this was not happening to me before, strange...
Is Geoserver closing the connections after each request?
Thanks.
Javier.
--------------------------------------------------------------------- ---
begin:vcard
fn:Javier de la Torre
n:de la Torre;Javier
org:Museo Nacional de Ciencias Naturales (CSIC)
adr:;;C/Jose Gutierrez Abascal, 2;Madrid;Madrid;28006;Spain
email;internet:jatorre@anonymised.com
title:Scientist
url:http://www.biogeografia.com/edit/
version:2.1
end:vcard
--------------------------------------------------------------------- ---
--
Chris Holmes
The Open Planning Project
http://topp.openplans.org
<cholmes.vcf>
------------------------------------------------------------------------
begin:vcard
fn:Javier de la Torre
n:de la Torre;Javier
org:Museo Nacional de Ciencias Naturales (CSIC)
adr:;;C/Jose Gutierrez Abascal, 2;Madrid;Madrid;28006;Spain
email;internet:jatorre@anonymised.com
title:Scientist
url:http://www.biogeografia.com/edit/
version:2.1
end:vcard
------------------------------------------------------------------------
--
Chris Holmes
The Open Planning Project
http://topp.openplans.org
<cholmes.vcf>
JTorre.vcf (278 Bytes)
Cool, thanks so much for the feedback, we'll definitely get that fixed before it goes 1.3.1 final. If I can't replicate it I may bug you again, but it sounds like an easy to reproduce problem.
Chris
Javier de la Torre wrote:
Right...
It does not happened in 1.3.0...
I stay with the stable
Thanks.
Javier.
On 13/05/2006, at 1:03, Chris Holmes wrote:
Could I convince you to maybe try 1.3.0? If it works fine then there's definitely a bug in GeoTools 2.2.x that we should fix before 1.3.1 official.
thanks!
Chris
Javier de la Torre wrote:
Hi Chris,
I am using 1.3.1 Beta. I am doing just simple WMS getMap requests for a Google Maps mashup. When viewing a map maybe 20 request are sent to Geoserver one for each tile to be overlapped in Google maps.
I did not try with the stable 1.3.0 version sorry.
More info. I am running it on Red Hat 9 with PostgreSQL 8.1.3 and Postgis 1.1.2
Javier.
On 12/05/2006, at 16:51, Chris Holmes wrote:
Yeah, it normally sets up a nice pool and shares all the connections. If it's going up on every request then something's going wrong. What operation are you doing? And what version of GeoServer? In the past a few minor changes have lead to connection pool mess ups, though generally in the less used operations.
Chris
Javier de la Torre wrote:
Hi,
I am suffering the typical "too many connections" to PostgreSQL while using Geoserver. Seems that for every new request for a featureType in a PostGIS data store a new connection to the database is stablished... Therefore the list of postmasters running in the system start growing until it reach the 300 limit I have in my PostgreSQL configuration file...
I have the impression that this was not happening to me before, strange...
Is Geoserver closing the connections after each request?
Thanks.
Javier.
------------------------------------------------------------------- -- ---
begin:vcard
fn:Javier de la Torre
n:de la Torre;Javier
org:Museo Nacional de Ciencias Naturales (CSIC)
adr:;;C/Jose Gutierrez Abascal, 2;Madrid;Madrid;28006;Spain
email;internet:jatorre@anonymised.com
title:Scientist
url:http://www.biogeografia.com/edit/
version:2.1
end:vcard
------------------------------------------------------------------- -- ---
--
Chris Holmes
The Open Planning Project
http://topp.openplans.org
<cholmes.vcf>
--------------------------------------------------------------------- ---
begin:vcard
fn:Javier de la Torre
n:de la Torre;Javier
org:Museo Nacional de Ciencias Naturales (CSIC)
adr:;;C/Jose Gutierrez Abascal, 2;Madrid;Madrid;28006;Spain
email;internet:jatorre@anonymised.com
title:Scientist
url:http://www.biogeografia.com/edit/
version:2.1
end:vcard
--------------------------------------------------------------------- ---
--
Chris Holmes
The Open Planning Project
http://topp.openplans.org
<cholmes.vcf>
------------------------------------------------------------------------
begin:vcard
fn:Javier de la Torre
n:de la Torre;Javier
org:Museo Nacional de Ciencias Naturales (CSIC)
adr:;;C/Jose Gutierrez Abascal, 2;Madrid;Madrid;28006;Spain
email;internet:jatorre@anonymised.com
title:Scientist
url:http://www.biogeografia.com/edit/
version:2.1
end:vcard
------------------------------------------------------------------------
--
Chris Holmes
The Open Planning Project
http://topp.openplans.org