[Open.ogc] Response 500 error from GeoServer

[Micah Wengren]

John,

I took a quick look in the logs, and I see something about a SQL query 
maybe based on a non-existant table (probably not likely the cause though):

Caused by: java.io.IOException: Error occured calculating bounds
     at org.geotools.jdbc.JDBCDataStore.getBounds(JDBCDataStore.java:1173)
     at 
org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.java:501)
     ... 96 more
Caused by: org.postgresql.util.PSQLException: ERROR: relation 
"nmfs_st.communities_pgs20130920" does not exist
   Position: 82
     at 
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
     at 
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
     at 
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)

And also something about a database connection problem, that may be more 
likely the cause:

Caused by: java.io.IOException: Error occured on rollback
     at 
org.geotools.jdbc.JDBCTransactionState.rollback(JDBCTransactionState.java:100)
     at 
org.geotools.data.DefaultTransaction.rollback(DefaultTransaction.java:225)
     at 
org.geoserver.catalog.rest.DataStoreFileResource.handlePut(DataStoreFileResource.java:365)
     ... 87 more
Caused by: java.sql.SQLException: Connection is closed.
     at 
org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.checkOpen(PoolingDataSource.java:185)
     at 
org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:322)
     at 
org.geotools.jdbc.JDBCTransactionState.rollback(JDBCTransactionState.java:97)
     ... 89 more

Can you try the upload again?  I disabled/re-enabled the data store, 
which might help.

Micah

On 9/27/2013 10:43 AM, John Kennedy - NOAA Affiliate wrote:
> Hi Micah,
>
> I attempted to load a shape file this morning using 
> hpcc_data_request.py scritp and I'm getting a Response 500 error from 
> GeoServer. Any ideas?
>
> Cheers,
> John
>
>
>
> John F. Kennedy, PhD, CPG
> GIS Specialist
> Contractor: Caelum Corp.
> NOAA Fisheries Office of Science and Technology
> 1315 East-West Highway
> SSMC3 Rm 9518
> Silver Spring, MD 20910
> 301-427-8149
>
> Comments? Have I been of assistance? Please let my supervisors know. :~)
> Tim Haverland - NOAA Federal <Tim.Haverland at noaa.gov 
> <mailto:Tim.Haverland at noaa.gov>>
> Hussain Jabalpurwala - NOAA Affiliate <hussain.jabalpurwala at noaa.gov 
> <mailto:hussain.jabalpurwala at noaa.gov>>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://list.woc.noaa.gov/pipermail/open.ogc/attachments/20130927/bde73f0e/attachment.html>