[Geotools-gt2-users] SocketException being thrown after a number of consecutive PostGIS queries

[Gerson G. <ger...@gm...>]

Hi again,

I've written a portlet that needs to perform a number of PostGIS queries 
per http request. There are times when the query just wouldn't work. 
Whenever the query fails, I get this on the log file...

02:09:31,760 ERROR [jsp:154] java.net.SocketException: Socket closed
     at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:99)
     at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
     at 
java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
     at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
     at org.postgresql.core.PGStream.flush(PGStream.java:508)
     at 
org.postgresql.core.v3.QueryExecutorImpl.sendSync(QueryExecutorImpl.java:1107)
     at 
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:256)
     at 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
     at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353)
     at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:252)
     at 
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
     at 
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
     at 
org.geotools.jdbc.JDBCFeatureReader.<init>(JDBCFeatureReader.java:147)
     at 
org.geotools.jdbc.JDBCFeatureSource.getReaderInternal(JDBCFeatureSource.java:557)
     at 
org.geotools.jdbc.JDBCFeatureStore.getReaderInternal(JDBCFeatureStore.java:209)
     at 
org.geotools.data.store.ContentFeatureSource.getReader(ContentFeatureSource.java:483)
     at 
org.geotools.data.store.ContentFeatureCollection.features(ContentFeatureCollection.java:209)
     at 
org.geotools.data.store.ContentFeatureCollection.features(ContentFeatureCollection.java:62)
     at au.org.aurin.util.LocationUtil.getLGAs(LocationUtil.java:149)
     at 
au.org.aurin.portlets.LocationPickerPortlet.doView(LocationPickerPortlet.java:105)

I had a look at my postgresql logs as well and found this whenever the 
exception above is thrown..

2011-05-27 12:07:34 EST ERROR:  relation "gt_pk_metadata" does not exist 
at character 15
2011-05-27 12:07:34 EST STATEMENT:  SELECT * FROM GT_PK_METADATA
2011-05-27 12:07:42 EST ERROR:  relation "gt_pk_metadata" does not exist 
at character 15
2011-05-27 12:07:42 EST STATEMENT:  SELECT * FROM GT_PK_METADATA
2011-05-27 12:07:59 EST LOG:  unexpected EOF on client connection
2011-05-27 12:07:59 EST LOG:  unexpected EOF on client connection
2011-05-27 12:07:59 EST LOG:  unexpected EOF on client connection
2011-05-27 12:07:59 EST LOG:  unexpected EOF on client connection
2011-05-27 12:07:59 EST LOG:  unexpected EOF on client connection
2011-05-27 12:08:39 EST ERROR:  relation "gt_pk_metadata" does not exist 
at character 15
2011-05-27 12:08:39 EST STATEMENT:  SELECT * FROM GT_PK_METADATA
2011-05-27 12:08:41 EST LOG:  unexpected EOF on client connection
2011-05-27 12:09:12 EST LOG:  unexpected EOF on client connection
2011-05-27 12:09:12 EST LOG:  unexpected EOF on client connection
2011-05-27 12:10:01 EST ERROR:  relation "gt_pk_metadata" does not exist 
at character 15
2011-05-27 12:10:01 EST STATEMENT:  SELECT * FROM GT_PK_METADATA
2011-05-27 12:10:03 EST LOG:  unexpected EOF on client connection

Any ideas?

I'm not sure if I should send this message to the PostGIS mailing list 
or just geotools, but I'll try it here first.

Thanks,
Gerson