[Geoserver-devel] [jira] (GEOS-5250) Adding a layer programmatically causes connection leak problem

GeoServer GeoServer Developer
,
1

Ariel Núñez created BugGEOS-5250
Adding a layer programmatically causes connection leak problem

Issue Type:

BugBug

Affects Versions:

2.1.4, 2.1.x

Assignee:

Andrea Aime

Created:

03/Aug/12 11:46 PM

Description:

Adding a layer via the rest api causes an error:

Could not save the layer hti_hazardhydrology_exceptionalflood_westdepartment_nathat_polygon_052010, there was an upload error: java.io.IOException: Schema ‘http://www.openplans.org/topp:hti_hazardhydrology_exceptionalflood_westdepartment_nathat_polygon_052010’ does not exist.

Causing all subsequent layers import to error with:

Error deleting PostGIS table hti_hazardgeology_landslidesdetail_point_022010:table “hti_hazardgeology_landslidesdetail_point_022010” does not exist
CONTEXT: SQL statement “DROP TABLE public.hti_hazardgeology_landslidesdetail_point_022010”
PL/pgSQL function “dropgeometrytable” line 23 at EXECUTE statement

Could not save the layer hti_hazardgeology_landslidesdetail_point_022010, there was an upload error: java.io.IOException: Error occured on rollback

This was originally found with a custom build of 2.1.x using GeoNode extensions and then verified with a vanilla 2.1.4 using gsconfig for the data upload. Full instructions and link to datasets can be found in the relevant GeoNode issue:

https://github.com/GeoNode/geonode/issues/354

Full geoserver logs are available at:

http://ingenieroariel.com/static/geoserver.log

Environment:

Ubuntu 12.04

Project:

GeoServer

Priority:

MajorMajor

Reporter:

Ariel Núñez
This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your [JIRA administrators](https://jira.codehaus.org/secure/ContactAdministrators!default.jspa). For more information on JIRA, see: [http://www.atlassian.com/software/jira](http://www.atlassian.com/software/jira)