Re: [Geoserver-devel] Styles dropping out - resolution

2008-06-23 Thread Paul McCullough
>... unless... did you configure a >separate datastore for each of those layers??? DOH! That is exactly what I had done. I will no bump the datastore connection parms back up to 10 or 20. And I should know better. Thanks for the reply. -- View this message in context: http://www.nabble.com/Styl

Re: [Geoserver-devel] Styles dropping out - resolution

2008-06-18 Thread Andrea Aime
Paul McCullough wrote: ... > How to Fix It > - > Obviously, it is unacceptable to the dataserver to go down - so first I > lowered the postgresql.conf max connections > - max_connections = 50 > What number you use depends on a number of factors - plenty of material > about this on the

Re: [Geoserver-devel] Styles dropping out - resolution

2008-06-16 Thread Paul McCullough
Recap - I have a layer group. Sometimes, when it is rendered via WMS, some (openlayers) tiles are missing some of the styles. See image attached to this thread. Explanation --- summary: don't let geoserver ask for too many database connections - set "max connections" parameter to a r

Re: [Geoserver-devel] Styles dropping out

2008-05-29 Thread Paul McCullough
I am now studying the logs. I suspect the problem starts on this line of the pgsql log: 2008-05-28 14:00:50 LOG: server process (PID 5592) exited with exit code -1073741502 Indeed it appears to be a pqsql bug http://archives.postgresql.org/pgsql-bugs/2006-12/msg00166.php I shall patch

Re: [Geoserver-devel] Styles dropping out

2008-05-28 Thread Arne Kepp
So panning would make the requests multithreaded. I saw this in your logs: 2008-05-28 14:02:11 LOG: server process (PID 3172) exited with exit code -1073741502 That's not very helpful, but it seems to be this bug: http://archives.postgresql.org/pgsql-bugs/2007-11/msg00138.php Unfortunately I

Re: [Geoserver-devel] Styles dropping out

2008-05-28 Thread Paul McCullough
All, It is clear that the problem is not related to TileCache and GeoWebCache. I have removed cahcing from the picture. As Arne suspected, there are issues with the database connection to postgresql. So I have added some debugging to postgresQL as suggested above. Attached are zipped log files fr

Re: [Geoserver-devel] Styles dropping out

2008-05-28 Thread Paul McCullough
I neglected to mention that the previously included log files were created as follows in order to show the minimum necessary... 1) stop tomcat and postgresql 2) remove all logs files for tomcat and postgresql 3) start postgresql 4) start tomcat 5) pan and zoom until I see the bad images (it took o

Re: [Geoserver-devel] Styles dropping out

2008-05-28 Thread Arne Kepp
Andrea Aime wrote: > Arne Kepp ha scritto: >> To me that looks like the database server disappeared. >> >> Is postgresql running on the same machine? Can you see whether it has >> a log with errors? > > This mail thread: > http://www.nabble.com/org.postgresql.util.PSQLException:-An-I-O-error-occur

Re: [Geoserver-devel] Styles dropping out

2008-05-28 Thread Andrea Aime
Arne Kepp ha scritto: > To me that looks like the database server disappeared. > > Is postgresql running on the same machine? Can you see whether it has a > log with errors? This mail thread: http://www.nabble.com/org.postgresql.util.PSQLException:-An-I-O-error-occured-while-sending-to-the-backe

Re: [Geoserver-devel] Styles dropping out

2008-05-27 Thread Arne Kepp
To me that looks like the database server disappeared. Is postgresql running on the same machine? Can you see whether it has a log with errors? -Arne Paul McCullough wrote: > I just restarted tomcat/geoserver. > The server started properly and rendered the first images properly. > I was very

Re: [Geoserver-devel] Styles dropping out

2008-05-27 Thread Paul McCullough
I just restarted tomcat/geoserver. The server started properly and rendered the first images properly. I was very quickly able to reproduce the error. See log below. Here is the log file output. 27 May 16:27:04 INFO [geoserver.filters] - 0:0:0:0:0:0:0:1 "GET /geoserver/wfs?LAYERS=layer-group_map

Re: [Geoserver-devel] Styles dropping out

2008-05-27 Thread Paul McCullough
All, I was just now able to recreate this under TileCache and plain old WMS. And here is an excerpt from the log file. 27 May 16:18:06 INFO [geoserver.filters] - 0:0:0:0:0:0:0:1 "GET /geoserver/wfs?LAYERS=layer-group_map&UNITS=m&PROJECTION=EPSG%3A900913&FORMAT=image%2Fgif&SERVICE=WMS&VERSION=1.1.