[Geoserver-devel] Postgres processes increase per request

GeoServer GeoServer Developer
,
1

Dear all,

I have Geoserver 1.2.0-rc1 and have both postgresql and postgis installed successfully. A couple of postgis datastores has been created and I was able to generate map via the WMS from these postgis datastores. So far so good....

The problem I am facing at the moment is after about 10 requests to the WMS to draw maps from the postgis datastore, there is an additional postgres process appear in my "ps" list. As the number of postgres processes increases per request to the WMS, the postgresql eventually crash and require a restart.

My question is how come the postgres process does not kill itself after a successful request to the WMS, instead the process remain in the process list consuming memory which may result in the crashing of the postgres itself.

The error message I got when I try to use psql in the command prompt is:
"psql: could not send startup packet: Broken pipe"

Below is a capture from top:
2633 postgres 9 0 2100 2100 1700 S 0.0 0.2 0:00 postmaster
2635 postgres 9 0 2060 2060 1664 S 0.0 0.2 0:00 postmaster
2637 postgres 9 0 2092 2092 1668 S 0.0 0.2 0:00 postmaster
3842 postgres 9 0 5072 5072 3616 S 0.0 0.4 0:00 postmaster
3844 postgres 9 0 4852 4852 3596 S 0.0 0.4 0:00 postmaster
3846 postgres 9 0 5044 5044 3596 S 0.0 0.4 0:00 postmaster
3848 postgres 9 0 4852 4852 3596 S 0.0 0.4 0:00 postmaster
3852 postgres 9 0 5048 5048 3596 S 0.0 0.4 0:00 postmaster
3854 postgres 9 0 4856 4856 3596 S 0.0 0.4 0:00 postmaster
3856 postgres 9 0 5048 5048 3596 S 0.0 0.4 0:00 postmaster
3858 postgres 9 0 4856 4856 3596 S 0.0 0.4 0:00 postmaster
3863 postgres 9 0 5048 5048 3596 S 0.0 0.4 0:00 postmaster
3865 postgres 9 0 4860 4860 3600 S 0.0 0.4 0:00 postmaster
3867 postgres 9 0 5052 5052 3600 S 0.0 0.4 0:00 postmaster
3869 postgres 9 0 4860 4860 3600 S 0.0 0.4 0:00 postmaster
3871 postgres 9 0 5052 5052 3600 S 0.0 0.4 0:00 postmaster
3873 postgres 9 0 4860 4860 3600 S 0.0 0.4 0:00 postmaster
3876 postgres 9 0 5052 5052 3600 S 0.0 0.4 0:00 postmaster
3878 postgres 9 0 4860 4860 3600 S 0.0 0.4 0:00 postmaster
3880 postgres 9 0 5052 5052 3600 S 0.0 0.4 0:00 postmaster

Would anyone can give me some help in this as I am running out of ideas. Thank you very very much.

Best regards,

Sunny Leung

2

Alle 21:17, sabato 22 maggio 2004, Sunny Leung ha scritto:

..

Would anyone can give me some help in this as I am running out of ideas.
Thank you very very much.

Well, we're not sure but it's probably the result of a bug in the LiteRenderer
module used in Geoserver... basically, it gets a feature reader but does not
closes it, thus the connection is not returned to the pool, new ones are
opened, and this makes the poor postgis crash well before any garbage
collection can free the lost connections... The bug has been fixed in the
trunk of geotools, but this happened later than the release of 1.2.0-rc1...
the fix will hopefully be included in 1.2.0 final...

Chris, can you confirm this?
Best regards
Andrea Aime