search

GeoNode / geonode

GeoNode is an open source platform that facilitates the creation, sharing, and collaborative use of geospatial data.
https://geonode.org/
Other
1.41k stars 1.11k forks source link

Failed import causes unrecoverable error #354

Closed ingenieroariel closed 11 years ago

ingenieroariel commented 11 years ago

The actual error is:

ubuntu@ip-10-84-250-65:~$ geonode importlayers data
[created] Layer for 'data/hti_biota_landcover_spot_cnigs_041998_polygon.shp' (1/64)
[created] Layer for 'data/hti_structure_ochasheltersites_point_022010.shp' (2/64)
[created] Layer for 'data/hti_structure_idpcamps_ocha_022010_point.shp' (3/64)
[created] Layer for 'data/hti_location_priority_areas_pap_tabarre_nathat_102011.shp' (4/64)
[created] Layer for 'data/hti_hazardclimate_monthprecipitationstation_point_052010.shp' (5/64)
[created] Layer for 'data/hti_structure_buildings_osm_20111021_polygones.shp' (6/64)
[created] Layer for 'data/hti_boundaries_communes_adm2_cnigs_polygon.shp' (7/64)
[created] Layer for 'data/hti_meteorology_rainstations_nathat_cnm_point.shp' (8/64)
[created] Layer for 'data/hti_boundaries_communes_adm2_cnigs_line.shp' (9/64)
Could not save the layer hti_hazardhydrology_exceptionalflood_westdepartment_nathat_polygon_052010, there was an upload error: java.io.IOException: Schema 'http://geonode.org/:hti_hazardhydrology_exceptionalflood_westdepartment_nathat_polygon_052010' does not exist.
[failed] Layer for 'data/hti_hazardhydrology_exceptionalflood_westdepartment_nathat_polygon_052010.shp' (10/64)
Could not save the layer hti_boundary_country_polygon_062006, there was an upload error: java.io.IOException: Schema 'http://geonode.org/:hti_hazardhydrology_exceptionalflood_westdepartment_nathat_polygon_052010' does not exist.
[failed] Layer for 'data/hti_boundary_country_polygon_062006.shp' (11/64)
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
[failed] Layer for 'data/hti_hazardgeology_landslidesdetail_point_022010.shp' (12/64)

If importlayers is cancelled and resumed, then the one of the failed layers can be properly imported:

ubuntu@ip-10-84-250-65:~$ geonode importlayers data/hti_boundary_country_polygon_062006.shp
[created] Layer for 'data/hti_boundary_country_polygon_062006.shp' (1/1)

Finished processing 1 layers in 25.0 seconds.

1 Created layers
0 Updated layers
0 Skipped layers
0 Failed layers
25.000000 seconds per layer

A second attempt to import causes the error to be repeated:

ubuntu@ip-10-84-250-65:~$ geonode importlayers data
[skipped] Layer for 'data/hti_biota_landcover_spot_cnigs_041998_polygon.shp' (1/64)
[skipped] Layer for 'data/hti_structure_ochasheltersites_point_022010.shp' (2/64)
[skipped] Layer for 'data/hti_structure_idpcamps_ocha_022010_point.shp' (3/64)
[skipped] Layer for 'data/hti_location_priority_areas_pap_tabarre_nathat_102011.shp' (4/64)
[skipped] Layer for 'data/hti_hazardclimate_monthprecipitationstation_point_052010.shp' (5/64)
[skipped] Layer for 'data/hti_structure_buildings_osm_20111021_polygones.shp' (6/64)
[skipped] Layer for 'data/hti_boundaries_communes_adm2_cnigs_polygon.shp' (7/64)
[skipped] Layer for 'data/hti_meteorology_rainstations_nathat_cnm_point.shp' (8/64)
[skipped] Layer for 'data/hti_boundaries_communes_adm2_cnigs_line.shp' (9/64)
Could not save the layer hti_hazardhydrology_exceptionalflood_westdepartment_nathat_polygon_052010, there was an upload error: java.io.IOException: Error occurred creating table
[failed] Layer for 'data/hti_hazardhydrology_exceptionalflood_westdepartment_nathat_polygon_052010.shp' (10/64)
[skipped] Layer for 'data/hti_boundary_country_polygon_062006.shp' (11/64)
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: Schema 'http://geonode.org/:hti_hazardhydrology_exceptionalflood_westdepartment_nathat_polygon_052010' does not exist.
[failed] Layer for 'data/hti_hazardgeology_landslidesdetail_point_022010.shp' (12/64)
[skipped] Layer for 'data/hti_inlandwaters_rivers_cnigs_line_062006.shp' (13/64)
Could not save the layer hti_boundaries_sections_communales_adm3_cnigs_polygon, there was an upload error: java.io.IOException: Error occurred creating table
[failed] Layer for 'data/hti_boundaries_sections_communales_adm3_cnigs_polygon.shp' (14/64)

An attempt to import only the offending one causes an error:

ubuntu@ip-10-84-250-65:~$ geonode importlayers data/hti_hazardhydrology_exceptionalflood_westdepartment_nathat_polygon_052010.shp
Could not save the layer hti_hazardhydrology_exceptionalflood_westdepartment_nathat_polygon_052010, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_hazardhydrology_exceptionalflood_westdepartment_nathat_polygon_052010.shp' (1/1)

Finished processing 1 layers in 0.0 seconds.

0 Created layers
0 Updated layers
0 Skipped layers
1 Failed layers
0.000000 seconds per layer

A second attempt causes a different error:

ubuntu@ip-10-84-250-65:~$ geonode importlayers data/hti_hazardhydrology_exceptionalflood_westdepartment_nathat_polygon_052010.shp
Error deleting PostGIS table hti_hazardhydrology_exceptionalflood_westdepartment_nathat_polygon_052010:table "hti_hazardhydrology_exceptionalflood_westdepartment_nathat_poly" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_hazardhydrology_exceptionalflood_westdepartment_nathat_polygon_052010"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_hazardhydrology_exceptionalflood_westdepartment_nathat_polygon_052010, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_hazardhydrology_exceptionalflood_westdepartment_nathat_polygon_052010.shp' (1/1)

Finished processing 1 layers in 1.0 seconds.

0 Created layers
0 Updated layers
0 Skipped layers
1 Failed layers
1.000000 seconds per layer

Restarting postgres does not fix the issue:

ubuntu@ip-10-84-250-65:~$ sudo service postgresql restart
 * Restarting PostgreSQL 9.1 database server
   ...done.

This is how the GeoServer log looks like:

2012-08-04 03:04:26,634 INFO [catalog.rest] - PUT file, mimetype: application/zip
2012-08-04 03:04:26,763 WARN [geotools.jdbc] - There is code leaving feature readers/iterators open, this is leaking statements and connections!
2012-08-04 03:04:26,768 WARN [geotools.jdbc] - There is code leaving feature readers/iterators open, this is leaking statements and connections!
2012-08-04 03:04:26,769 WARN [geotools.jdbc] - There is code leaving feature readers/iterators open, this is leaking statements and connections!
2012-08-04 03:04:26,773 INFO [catalog.rest] - Using existing datastore: postgres_imports
2012-08-04 03:04:27,907 ERROR [geoserver.rest] -
java.lang.RuntimeException: java.io.IOException: Error occured on rollback
        at org.geoserver.catalog.rest.DataStoreFileResource.handlePut(DataStoreFileResource.java:452)

The warning says there is code leaving feature readers/iterators open leaking statements and connections, let's look above in the logs to try to find out what the first exception looked like:

2012-08-04 02:29:09,576 INFO [org.geoserver] - GeoServer configuration lock is enabled
2012-08-04 02:35:38,074 INFO [org.geoserver] - Loaded store 'postgres_imports', enabled
2012-08-04 02:35:38,546 INFO [catalog.rest] - POST data store postgres_imports
2012-08-04 02:35:39,310 INFO [catalog.rest] - PUT file, mimetype: application/zip
2012-08-04 02:35:39,792 INFO [catalog.rest] - Using existing datastore: postgres_imports
2012-08-04 02:35:40,301 INFO [catalog.rest] - hti_biota_landcover_spot_cnigs_041998_polygon does not exist in data store postgres_imports. Attempting to create it
2012-08-04 02:36:10,989 WARN [geotools.jdbc] - Failed to use ST_Estimated_Extent, falling back on envelope aggregation
org.postgresql.util.PSQLException: ERROR: LWGEOM_estimated_extent: couldn't locate table within current schema
        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)
        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.data.postgis.PostGISDialect.getOptimizedBounds(PostGISDialect.java:247)
        at org.geotools.jdbc.JDBCDataStore.getBounds(JDBCDataStore.java:1109)
        at org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.java:478)
        at org.geotools.jdbc.JDBCFeatureStore.getBoundsInternal(JDBCFeatureStore.java:179)
        at org.geotools.data.store.ContentFeatureSource.getBounds(ContentFeatureSource.java:370)
        at org.geotools.data.store.ContentFeatureSource.getBounds(ContentFeatureSource.java:342)

Since there is code leaking connections, let's try restarting tomcat to see if layers can be uploaded again:

ubuntu@ip-10-84-250-65:~$ sudo service tomcat6 restart
 * Stopping Tomcat servlet engine tomcat6
   ...done.
 * Starting Tomcat servlet engine tomcat6
   ...done.

It made me wait one minute, and then it failed:

ubuntu@ip-10-84-250-65:~$ geonode importlayers data/hti_hazardgeology_landslidesdetail_point_022010.shp
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: Schema 'http://geonode.org/:hti_hazardhydrology_frequentflood_westdepartment_nathat_polygon_052010' does not exist.
[failed] Layer for 'data/hti_hazardgeology_landslidesdetail_point_022010.shp' (1/1)

Finished processing 1 layers in 69.0 seconds.

0 Created layers
0 Updated layers
0 Skipped layers
1 Failed layers
69.000000 seconds per layer

Datasets used can be downloaded from http://haitidata.org

The datasets used can be downloaded from http://haitidata.org

ingenieroariel commented 11 years ago

Tried on a second fresh instance, downloading again from haitidata.org and got this:

ubuntu@ip-10-140-128-51:~$ geonode importlayers -v2 data -i
Verifying that GeoNode is running ...
Found 64 potential layers, importing now ...
[created] Layer for 'data/hti_biota_landcover_spot_cnigs_041998_polygon.shp' (1/64)
[created] Layer for 'data/hti_structure_ochasheltersites_point_022010.shp' (2/64)
[created] Layer for 'data/hti_structure_idpcamps_ocha_022010_point.shp' (3/64)
[created] Layer for 'data/hti_location_priority_areas_pap_tabarre_nathat_102011.shp' (4/64)
[created] Layer for 'data/hti_hazardclimate_monthprecipitationstation_point_052010.shp' (5/64)
[created] Layer for 'data/hti_structure_buildings_osm_20111021_polygones.shp' (6/64)
[created] Layer for 'data/hti_boundaries_communes_adm2_cnigs_polygon.shp' (7/64)
[created] Layer for 'data/hti_meteorology_rainstations_nathat_cnm_point.shp' (8/64)
[created] Layer for 'data/hti_boundaries_communes_adm2_cnigs_line.shp' (9/64)
Could not save the layer hti_hazardhydrology_exceptionalflood_westdepartment_nathat_polygon_052010, there was an upload error: java.io.IOException: Schema 'http://geonode.org/:hti_hazardhydrology_exceptionalflood_westdepartment_nathat_polygon_052010' does not exist.
[failed] Layer for 'data/hti_hazardhydrology_exceptionalflood_westdepartment_nathat_polygon_052010.shp' (10/64)
Could not save the layer hti_boundary_country_polygon_062006, there was an upload error: java.io.IOException: Schema 'http://geonode.org/:hti_hazardhydrology_exceptionalflood_westdepartment_nathat_polygon_052010' does not exist.
[failed] Layer for 'data/hti_boundary_country_polygon_062006.shp' (11/64)
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
[failed] Layer for 'data/hti_hazardgeology_landslidesdetail_point_022010.shp' (12/64)
Error deleting PostGIS table hti_inlandwaters_rivers_cnigs_line_062006:table "hti_inlandwaters_rivers_cnigs_line_062006" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_inlandwaters_rivers_cnigs_line_062006"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_inlandwaters_rivers_cnigs_line_062006, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_inlandwaters_rivers_cnigs_line_062006.shp' (13/64)
Error deleting PostGIS table hti_boundaries_sections_communales_adm3_cnigs_polygon:table "hti_boundaries_sections_communales_adm3_cnigs_polygon" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_boundaries_sections_communales_adm3_cnigs_polygon"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_boundaries_sections_communales_adm3_cnigs_polygon, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_boundaries_sections_communales_adm3_cnigs_polygon.shp' (14/64)
Error deleting PostGIS table hti_boundaries_departements_adm1_cnigs_polygon:table "hti_boundaries_departements_adm1_cnigs_polygon" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_boundaries_departements_adm1_cnigs_polygon"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_boundaries_departements_adm1_cnigs_polygon, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_boundaries_departements_adm1_cnigs_polygon.shp' (15/64)
Error deleting PostGIS table hti_geology_geology_polygon_082005:table "hti_geology_geology_polygon_082005" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_geology_geology_polygon_082005"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_geology_geology_polygon_082005, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_geology_geology_polygon_082005.shp' (16/64)
Error deleting PostGIS table hti_structure_health_facilities_ante_2010_osm_15032011:table "hti_structure_health_facilities_ante_2010_osm_15032011" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_structure_health_facilities_ante_2010_osm_15032011"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_structure_health_facilities_ante_2010_osm_15032011, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_structure_health_facilities_ante_2010_osm_15032011.shp' (17/64)
Error deleting PostGIS table hti_hazardhydrology_frequentflood_westdepartment_nathat_polygon_052010:table "hti_hazardhydrology_frequentflood_westdepartment_nathat_polygon" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_hazardhydrology_frequentflood_westdepartment_nathat_polygon_052010"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_hazardhydrology_frequentflood_westdepartment_nathat_polygon_052010, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_hazardhydrology_frequentflood_westdepartment_nathat_polygon_052010.shp' (18/64)
Error deleting PostGIS table hti_popa_projectionseccom2009_ihsi:table "hti_popa_projectionseccom2009_ihsi" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_popa_projectionseccom2009_ihsi"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_popa_projectionseccom2009_ihsi, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_popa_projectionSecCom2009_IHSI.shp' (19/64)
Error deleting PostGIS table hti_locations_adm1_departement_centres_cnigs_062006_points:table "hti_locations_adm1_departement_centres_cnigs_062006_points" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_locations_adm1_departement_centres_cnigs_062006_points"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_locations_adm1_departement_centres_cnigs_062006_points, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_locations_adm1_departement_centres_cnigs_062006_points.shp' (20/64)
Error deleting PostGIS table hti_structure_health_ctc_ctu_osm_20111219_point:table "hti_structure_health_ctc_ctu_osm_20111219_point" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_structure_health_ctc_ctu_osm_20111219_point"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_structure_health_ctc_ctu_osm_20111219_point, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_structure_health_ctc_ctu_osm_20111219_point.shp' (21/64)
Error deleting PostGIS table hti_structure_disaster_shelters_osm_2011_04_points:table "hti_structure_disaster_shelters_osm_2011_04_points" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_structure_disaster_shelters_osm_2011_04_points"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_structure_disaster_shelters_osm_2011_04_points, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_structure_disaster_shelters_osm_2011_04_points.shp' (22/64)
Error deleting PostGIS table hti_topo_elevationnames_point_092008:table "hti_topo_elevationnames_point_092008" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_topo_elevationnames_point_092008"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_topo_elevationnames_point_092008, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_topo_elevationnames_point_092008.shp' (23/64)
Error deleting PostGIS table hti_hazardhydrology_floodzone_polygon_092008:table "hti_hazardhydrology_floodzone_polygon_092008" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_hazardhydrology_floodzone_polygon_092008"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_hazardhydrology_floodzone_polygon_092008, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_hazardhydrology_floodzone_polygon_092008.shp' (24/64)
Error deleting PostGIS table hti_society_popdensity_adm3_minustah_vector:table "hti_society_popdensity_adm3_minustah_vector" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_society_popdensity_adm3_minustah_vector"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_society_popdensity_adm3_minustah_vector, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_society_popdensity_adm3_minustah_vector.shp' (25/64)
Error deleting PostGIS table hti_geology_geomorphology_polygon_082005:table "hti_geology_geomorphology_polygon_082005" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_geology_geomorphology_polygon_082005"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_geology_geomorphology_polygon_082005, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_geology_geomorphology_polygon_082005.shp' (26/64)
Error deleting PostGIS table hti_location_priority_areas_pap_carrefourfeuilles_nathat_102011:table "hti_location_priority_areas_pap_carrefourfeuilles_nathat_102011" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_location_priority_areas_pap_carrefourfeuilles_nathat_102011"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_location_priority_areas_pap_carrefourfeuilles_nathat_102011, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_location_priority_areas_pap_CarrefourFeuilles_nathat_102011.shp' (27/64)
Error deleting PostGIS table hti_locations_adm2_communes_cnigs_points:table "hti_locations_adm2_communes_cnigs_points" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_locations_adm2_communes_cnigs_points"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_locations_adm2_communes_cnigs_points, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_locations_adm2_communes_cnigs_points.shp' (28/64)
Error deleting PostGIS table hti_locations_adm2_communes_centres_cnigs_062006_points:table "hti_locations_adm2_communes_centres_cnigs_062006_points" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_locations_adm2_communes_centres_cnigs_062006_points"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_locations_adm2_communes_centres_cnigs_062006_points, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_locations_adm2_communes_centres_cnigs_062006_points.shp' (29/64)
Error deleting PostGIS table hti_hazardhydrology_frequenflood_polygon_052010:table "hti_hazardhydrology_frequenflood_polygon_052010" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_hazardhydrology_frequenflood_polygon_052010"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_hazardhydrology_frequenflood_polygon_052010, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_hazardhydrology_frequenflood_polygon_052010.shp' (30/64)
Error deleting PostGIS table hti_topo_wetlands_polygon_092008:table "hti_topo_wetlands_polygon_092008" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_topo_wetlands_polygon_092008"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_topo_wetlands_polygon_092008, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_topo_wetlands_polygon_092008.shp' (31/64)
Error deleting PostGIS table hti_topo_contours20m_line_092008:table "hti_topo_contours20m_line_092008" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_topo_contours20m_line_092008"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_topo_contours20m_line_092008, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_topo_contours20m_line_092008.shp' (32/64)
Error deleting PostGIS table hti_hazardhydrology_propitiousfloodzone_polygon_052010:table "hti_hazardhydrology_propitiousfloodzone_polygon_052010" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_hazardhydrology_propitiousfloodzone_polygon_052010"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_hazardhydrology_propitiousfloodzone_polygon_052010, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_hazardhydrology_propitiousfloodzone_polygon_052010.shp' (33/64)
Error deleting PostGIS table hti_topo_earthquakeepicentre_point_012010:table "hti_topo_earthquakeepicentre_point_012010" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_topo_earthquakeepicentre_point_012010"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_topo_earthquakeepicentre_point_012010, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_topo_earthquakeepicentre_point_012010.shp' (34/64)
Error deleting PostGIS table hti_topo_coastlimitnoaa_polygon_092008:table "hti_topo_coastlimitnoaa_polygon_092008" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_topo_coastlimitnoaa_polygon_092008"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_topo_coastlimitnoaa_polygon_092008, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_topo_coastlimitnoaa_polygon_092008.shp' (35/64)
Error deleting PostGIS table hti_structure_idpcamps_iom_dtm_12012012_point:table "hti_structure_idpcamps_iom_dtm_12012012_point" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_structure_idpcamps_iom_dtm_12012012_point"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_structure_idpcamps_iom_dtm_12012012_point, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_structure_idpcamps_iom_dtm_12012012_point.shp' (36/64)
Could not save the layer hti_structure_sheltercamps_point_052010, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_structure_sheltercamps_point_052010.shp' (37/64)
Error deleting PostGIS table hti_boundaries_departements_adm1_cnigs_line:table "hti_boundaries_departements_adm1_cnigs_line" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_boundaries_departements_adm1_cnigs_line"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_boundaries_departements_adm1_cnigs_line, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_boundaries_departements_adm1_cnigs_line.shp' (38/64)
Error deleting PostGIS table hti_boundaries_international_cnigs_polygon:table "hti_boundaries_international_cnigs_polygon" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_boundaries_international_cnigs_polygon"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_boundaries_international_cnigs_polygon, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_boundaries_international_cnigs_polygon.shp' (39/64)
Error deleting PostGIS table hti_location_populatedplaces_cnigs_points:table "hti_location_populatedplaces_cnigs_points" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_location_populatedplaces_cnigs_points"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_location_populatedplaces_cnigs_points, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_location_populatedplaces_cnigs_points.shp' (40/64)
Could not save the layer hti_location_priority_areas_pap_simon_pele_nathat_102011, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_location_priority_areas_pap_simon_pele_nathat_102011.shp' (41/64)
Error deleting PostGIS table hti_geology_geology_pap_coxetalii_2011_polygon:table "hti_geology_geology_pap_coxetalii_2011_polygon" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_geology_geology_pap_coxetalii_2011_polygon"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_geology_geology_pap_coxetalii_2011_polygon, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_geology_geology_Pap_Coxetalii_2011_polygon.shp' (42/64)
Error deleting PostGIS table hti_location_priority_areas_pap_martissant_nathat_102011:table "hti_location_priority_areas_pap_martissant_nathat_102011" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_location_priority_areas_pap_martissant_nathat_102011"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_location_priority_areas_pap_martissant_nathat_102011, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_location_priority_areas_pap_martissant_nathat_102011.shp' (43/64)
Could not save the layer hti_hazardclimate_droughtzone_polygon_052010, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_hazardclimate_droughtzone_polygon_052010.shp' (44/64)
Error deleting PostGIS table hti_hazardgeology_liquefactionincidents_point_022010:table "hti_hazardgeology_liquefactionincidents_point_022010" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_hazardgeology_liquefactionincidents_point_022010"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_hazardgeology_liquefactionincidents_point_022010, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_hazardgeology_liquefactionincidents_point_022010.shp' (45/64)
Error deleting PostGIS table hti_topo_lakes_polygon_092008:table "hti_topo_lakes_polygon_092008" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_topo_lakes_polygon_092008"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_topo_lakes_polygon_092008, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_topo_lakes_polygon_092008.shp' (46/64)
Error deleting PostGIS table hti_hazardhydrology_probablefloodzone_polygon_052010:table "hti_hazardhydrology_probablefloodzone_polygon_052010" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_hazardhydrology_probablefloodzone_polygon_052010"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_hazardhydrology_probablefloodzone_polygon_052010, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_hazardhydrology_probablefloodzone_polygon_052010.shp' (47/64)
Error deleting PostGIS table hti_hazardhydrology_rareflood_westdepartment_nathat_polygon_052010:table "hti_hazardhydrology_rareflood_westdepartment_nathat_polygon_052" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_hazardhydrology_rareflood_westdepartment_nathat_polygon_052010"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_hazardhydrology_rareflood_westdepartment_nathat_polygon_052010, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_hazardhydrology_rareflood_westdepartment_nathat_polygon_052010.shp' (48/64)
Error deleting PostGIS table hti_location_priority_areas_pap_bel_air_nathat_102011:table "hti_location_priority_areas_pap_bel_air_nathat_102011" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_location_priority_areas_pap_bel_air_nathat_102011"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_location_priority_areas_pap_bel_air_nathat_102011, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_location_priority_areas_pap_Bel_Air_nathat_102011.shp' (49/64)
Error deleting PostGIS table hti_biota_landcoveravhrr_polygon_031995:table "hti_biota_landcoveravhrr_polygon_031995" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_biota_landcoveravhrr_polygon_031995"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_biota_landcoveravhrr_polygon_031995, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_biota_landcoveravhrr_polygon_031995.shp' (50/64)
Error deleting PostGIS table hti_environment_erosion_polygon_042008:table "hti_environment_erosion_polygon_042008" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_environment_erosion_polygon_042008"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_environment_erosion_polygon_042008, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_environment_erosion_polygon_042008.shp' (51/64)
Error deleting PostGIS table hti_location_priority_areas_pap_martin_luther_nazon_nathat_102011:table "hti_location_priority_areas_pap_martin_luther_nazon_nathat_1020" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_location_priority_areas_pap_martin_luther_nazon_nathat_102011"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_location_priority_areas_pap_martin_luther_nazon_nathat_102011, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_location_priority_areas_pap_Martin_Luther_Nazon_nathat_102011.shp' (52/64)
Error deleting PostGIS table hti_transportation_road_network_wfp_line:table "hti_transportation_road_network_wfp_line" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_transportation_road_network_wfp_line"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_transportation_road_network_wfp_line, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_transportation_road_network_wfp_line.shp' (53/64)
Error deleting PostGIS table hti_hazardhydrology_floodregions_nathat_polygon_052010:table "hti_hazardhydrology_floodregions_nathat_polygon_052010" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_hazardhydrology_floodregions_nathat_polygon_052010"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_hazardhydrology_floodregions_nathat_polygon_052010, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_hazardhydrology_floodregions_nathat_polygon_052010.shp' (54/64)
Error deleting PostGIS table hti_boundaries_sections_communales_adm3_cnigs_line:table "hti_boundaries_sections_communales_adm3_cnigs_line" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_boundaries_sections_communales_adm3_cnigs_line"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_boundaries_sections_communales_adm3_cnigs_line, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_boundaries_sections_communales_adm3_cnigs_line.shp' (55/64)
Error deleting PostGIS table hti_soil_soilcapacity_polygon_041998:table "hti_soil_soilcapacity_polygon_041998" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_soil_soilcapacity_polygon_041998"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_soil_soilcapacity_polygon_041998, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_soil_soilcapacity_polygon_041998.shp' (56/64)
Error deleting PostGIS table hti_hazardgeology_landslideincidents_point_022010:table "hti_hazardgeology_landslideincidents_point_022010" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_hazardgeology_landslideincidents_point_022010"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_hazardgeology_landslideincidents_point_022010, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_hazardgeology_landslideincidents_point_022010.shp' (57/64)
Error deleting PostGIS table hti_boundaries_international_minustah_line:table "hti_boundaries_international_minustah_line" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_boundaries_international_minustah_line"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_boundaries_international_minustah_line, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_boundaries_international_minustah_line.shp' (58/64)
Error deleting PostGIS table hti_location_priority_areas_pap_delmas32_nathat_102011:table "hti_location_priority_areas_pap_delmas32_nathat_102011" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_location_priority_areas_pap_delmas32_nathat_102011"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_location_priority_areas_pap_delmas32_nathat_102011, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_location_priority_areas_pap_delmas32_nathat_102011.shp' (59/64)
Error deleting PostGIS table hti_inlandwaters_watersheds_datpe_cnigs_polygon_092008:table "hti_inlandwaters_watersheds_datpe_cnigs_polygon_092008" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_inlandwaters_watersheds_datpe_cnigs_polygon_092008"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_inlandwaters_watersheds_datpe_cnigs_polygon_092008, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_inlandwaters_watersheds_datpe_cnigs_polygon_092008.shp' (60/64)
Error deleting PostGIS table hti_transport_roads_line_062006:table "hti_transport_roads_line_062006" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_transport_roads_line_062006"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_transport_roads_line_062006, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_transport_roads_line_062006.shp' (61/64)
Error deleting PostGIS table hti_locations_populatedplaces_osm_points:table "hti_locations_populatedplaces_osm_points" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_locations_populatedplaces_osm_points"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_locations_populatedplaces_osm_points, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_locations_populatedplaces_osm_points.shp' (62/64)
Error deleting PostGIS table hti_topo_contours50m_line_092008:table "hti_topo_contours50m_line_092008" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_topo_contours50m_line_092008"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_topo_contours50m_line_092008, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_topo_contours50m_line_092008.shp' (63/64)
Error deleting PostGIS table hti_topo_coastlimitnoaa_line_092008:table "hti_topo_coastlimitnoaa_line_092008" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_topo_coastlimitnoaa_line_092008"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_topo_coastlimitnoaa_line_092008, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_topo_coastlimitnoaa_line_092008.shp' (64/64)

Detailed report of failures:

data/hti_hazardhydrology_exceptionalflood_westdepartment_nathat_polygon_052010.shp 
================
Traceback (most recent call last):
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 635, in upload
    keywords=keywords
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 563, in file_upload
    new_layer = save(layer, filename, theuser, overwrite, keywords=keywords)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 320, in save
    store, gs_resource = create_store_and_resource(name, data, overwrite=overwrite)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 688, in _create_db_featurestore
    cat.add_data_to_store(ds, name, data, overwrite=overwrite, charset=charset)
  File "/var/lib/geonode/local/lib/python2.7/site-packages/geoserver/catalog.py", line 276, in add_data_to_store
    raise UploadError(response)
UploadError: Could not save the layer hti_hazardhydrology_exceptionalflood_westdepartment_nathat_polygon_052010, there was an upload error: java.io.IOException: Schema 'http://geonode.org/:hti_hazardhydrology_exceptionalflood_westdepartment_nathat_polygon_052010' does not exist.

data/hti_boundary_country_polygon_062006.shp 
================
Traceback (most recent call last):
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 635, in upload
    keywords=keywords
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 563, in file_upload
    new_layer = save(layer, filename, theuser, overwrite, keywords=keywords)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 320, in save
    store, gs_resource = create_store_and_resource(name, data, overwrite=overwrite)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 688, in _create_db_featurestore
    cat.add_data_to_store(ds, name, data, overwrite=overwrite, charset=charset)
  File "/var/lib/geonode/local/lib/python2.7/site-packages/geoserver/catalog.py", line 276, in add_data_to_store
    raise UploadError(response)
UploadError: Could not save the layer hti_boundary_country_polygon_062006, there was an upload error: java.io.IOException: Schema 'http://geonode.org/:hti_hazardhydrology_exceptionalflood_westdepartment_nathat_polygon_052010' does not exist.

data/hti_hazardgeology_landslidesdetail_point_022010.shp 
================
Traceback (most recent call last):
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 635, in upload
    keywords=keywords
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 563, in file_upload
    new_layer = save(layer, filename, theuser, overwrite, keywords=keywords)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 320, in save
    store, gs_resource = create_store_and_resource(name, data, overwrite=overwrite)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 688, in _create_db_featurestore
    cat.add_data_to_store(ds, name, data, overwrite=overwrite, charset=charset)
  File "/var/lib/geonode/local/lib/python2.7/site-packages/geoserver/catalog.py", line 276, in add_data_to_store
    raise UploadError(response)
UploadError: Could not save the layer hti_hazardgeology_landslidesdetail_point_022010, there was an upload error: java.io.IOException: Error occured on rollback

data/hti_inlandwaters_rivers_cnigs_line_062006.shp 
================
Traceback (most recent call last):
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 635, in upload
    keywords=keywords
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 563, in file_upload
    new_layer = save(layer, filename, theuser, overwrite, keywords=keywords)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 320, in save
    store, gs_resource = create_store_and_resource(name, data, overwrite=overwrite)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 688, in _create_db_featurestore
    cat.add_data_to_store(ds, name, data, overwrite=overwrite, charset=charset)
  File "/var/lib/geonode/local/lib/python2.7/site-packages/geoserver/catalog.py", line 276, in add_data_to_store
    raise UploadError(response)
UploadError: Could not save the layer hti_inlandwaters_rivers_cnigs_line_062006, there was an upload error: java.io.IOException: Error occured on rollback

data/hti_boundaries_sections_communales_adm3_cnigs_polygon.shp 
================
Traceback (most recent call last):
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 635, in upload
    keywords=keywords
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 563, in file_upload
    new_layer = save(layer, filename, theuser, overwrite, keywords=keywords)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 320, in save
    store, gs_resource = create_store_and_resource(name, data, overwrite=overwrite)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 688, in _create_db_featurestore
    cat.add_data_to_store(ds, name, data, overwrite=overwrite, charset=charset)
  File "/var/lib/geonode/local/lib/python2.7/site-packages/geoserver/catalog.py", line 276, in add_data_to_store
    raise UploadError(response)
UploadError: Could not save the layer hti_boundaries_sections_communales_adm3_cnigs_polygon, there was an upload error: java.io.IOException: Error occured on rollback

data/hti_boundaries_departements_adm1_cnigs_polygon.shp 
================
Traceback (most recent call last):
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 635, in upload
    keywords=keywords
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 563, in file_upload
    new_layer = save(layer, filename, theuser, overwrite, keywords=keywords)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 320, in save
    store, gs_resource = create_store_and_resource(name, data, overwrite=overwrite)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 688, in _create_db_featurestore
    cat.add_data_to_store(ds, name, data, overwrite=overwrite, charset=charset)
  File "/var/lib/geonode/local/lib/python2.7/site-packages/geoserver/catalog.py", line 276, in add_data_to_store
    raise UploadError(response)
UploadError: Could not save the layer hti_boundaries_departements_adm1_cnigs_polygon, there was an upload error: java.io.IOException: Error occured on rollback

data/hti_geology_geology_polygon_082005.shp 
================
Traceback (most recent call last):
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 635, in upload
    keywords=keywords
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 563, in file_upload
    new_layer = save(layer, filename, theuser, overwrite, keywords=keywords)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 320, in save
    store, gs_resource = create_store_and_resource(name, data, overwrite=overwrite)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 688, in _create_db_featurestore
    cat.add_data_to_store(ds, name, data, overwrite=overwrite, charset=charset)
  File "/var/lib/geonode/local/lib/python2.7/site-packages/geoserver/catalog.py", line 276, in add_data_to_store
    raise UploadError(response)
UploadError: Could not save the layer hti_geology_geology_polygon_082005, there was an upload error: java.io.IOException: Error occured on rollback

data/hti_structure_health_facilities_ante_2010_osm_15032011.shp 
================
Traceback (most recent call last):
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 635, in upload
    keywords=keywords
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 563, in file_upload
    new_layer = save(layer, filename, theuser, overwrite, keywords=keywords)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 320, in save
    store, gs_resource = create_store_and_resource(name, data, overwrite=overwrite)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 688, in _create_db_featurestore
    cat.add_data_to_store(ds, name, data, overwrite=overwrite, charset=charset)
  File "/var/lib/geonode/local/lib/python2.7/site-packages/geoserver/catalog.py", line 276, in add_data_to_store
    raise UploadError(response)
UploadError: Could not save the layer hti_structure_health_facilities_ante_2010_osm_15032011, there was an upload error: java.io.IOException: Error occured on rollback

data/hti_hazardhydrology_frequentflood_westdepartment_nathat_polygon_052010.shp 
================
Traceback (most recent call last):
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 635, in upload
    keywords=keywords
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 563, in file_upload
    new_layer = save(layer, filename, theuser, overwrite, keywords=keywords)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 320, in save
    store, gs_resource = create_store_and_resource(name, data, overwrite=overwrite)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 688, in _create_db_featurestore
    cat.add_data_to_store(ds, name, data, overwrite=overwrite, charset=charset)
  File "/var/lib/geonode/local/lib/python2.7/site-packages/geoserver/catalog.py", line 276, in add_data_to_store
    raise UploadError(response)
UploadError: Could not save the layer hti_hazardhydrology_frequentflood_westdepartment_nathat_polygon_052010, there was an upload error: java.io.IOException: Error occured on rollback

data/hti_popa_projectionSecCom2009_IHSI.shp 
================
Traceback (most recent call last):
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 635, in upload
    keywords=keywords
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 563, in file_upload
    new_layer = save(layer, filename, theuser, overwrite, keywords=keywords)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 320, in save
    store, gs_resource = create_store_and_resource(name, data, overwrite=overwrite)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 688, in _create_db_featurestore
    cat.add_data_to_store(ds, name, data, overwrite=overwrite, charset=charset)
  File "/var/lib/geonode/local/lib/python2.7/site-packages/geoserver/catalog.py", line 276, in add_data_to_store
    raise UploadError(response)
UploadError: Could not save the layer hti_popa_projectionseccom2009_ihsi, there was an upload error: java.io.IOException: Error occured on rollback

data/hti_locations_adm1_departement_centres_cnigs_062006_points.shp 
================
Traceback (most recent call last):
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 635, in upload
    keywords=keywords
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 563, in file_upload
    new_layer = save(layer, filename, theuser, overwrite, keywords=keywords)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 320, in save
    store, gs_resource = create_store_and_resource(name, data, overwrite=overwrite)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 688, in _create_db_featurestore
    cat.add_data_to_store(ds, name, data, overwrite=overwrite, charset=charset)
  File "/var/lib/geonode/local/lib/python2.7/site-packages/geoserver/catalog.py", line 276, in add_data_to_store
    raise UploadError(response)
UploadError: Could not save the layer hti_locations_adm1_departement_centres_cnigs_062006_points, there was an upload error: java.io.IOException: Error occured on rollback

data/hti_structure_health_ctc_ctu_osm_20111219_point.shp 
================
Traceback (most recent call last):
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 635, in upload
    keywords=keywords
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 563, in file_upload
    new_layer = save(layer, filename, theuser, overwrite, keywords=keywords)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 320, in save
    store, gs_resource = create_store_and_resource(name, data, overwrite=overwrite)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 688, in _create_db_featurestore
    cat.add_data_to_store(ds, name, data, overwrite=overwrite, charset=charset)
  File "/var/lib/geonode/local/lib/python2.7/site-packages/geoserver/catalog.py", line 276, in add_data_to_store
    raise UploadError(response)
UploadError: Could not save the layer hti_structure_health_ctc_ctu_osm_20111219_point, there was an upload error: java.io.IOException: Error occured on rollback

data/hti_structure_disaster_shelters_osm_2011_04_points.shp 
================
Traceback (most recent call last):
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 635, in upload
    keywords=keywords
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 563, in file_upload
    new_layer = save(layer, filename, theuser, overwrite, keywords=keywords)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 320, in save
    store, gs_resource = create_store_and_resource(name, data, overwrite=overwrite)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 688, in _create_db_featurestore
    cat.add_data_to_store(ds, name, data, overwrite=overwrite, charset=charset)
  File "/var/lib/geonode/local/lib/python2.7/site-packages/geoserver/catalog.py", line 276, in add_data_to_store
    raise UploadError(response)
UploadError: Could not save the layer hti_structure_disaster_shelters_osm_2011_04_points, there was an upload error: java.io.IOException: Error occured on rollback

data/hti_topo_elevationnames_point_092008.shp 
================
Traceback (most recent call last):
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 635, in upload
    keywords=keywords
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 563, in file_upload
    new_layer = save(layer, filename, theuser, overwrite, keywords=keywords)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 320, in save
    store, gs_resource = create_store_and_resource(name, data, overwrite=overwrite)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 688, in _create_db_featurestore
    cat.add_data_to_store(ds, name, data, overwrite=overwrite, charset=charset)
  File "/var/lib/geonode/local/lib/python2.7/site-packages/geoserver/catalog.py", line 276, in add_data_to_store
    raise UploadError(response)
UploadError: Could not save the layer hti_topo_elevationnames_point_092008, there was an upload error: java.io.IOException: Error occured on rollback

data/hti_hazardhydrology_floodzone_polygon_092008.shp 
================
Traceback (most recent call last):
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 635, in upload
    keywords=keywords
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 563, in file_upload
    new_layer = save(layer, filename, theuser, overwrite, keywords=keywords)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 320, in save
    store, gs_resource = create_store_and_resource(name, data, overwrite=overwrite)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 688, in _create_db_featurestore
    cat.add_data_to_store(ds, name, data, overwrite=overwrite, charset=charset)
  File "/var/lib/geonode/local/lib/python2.7/site-packages/geoserver/catalog.py", line 276, in add_data_to_store
    raise UploadError(response)
UploadError: Could not save the layer hti_hazardhydrology_floodzone_polygon_092008, there was an upload error: java.io.IOException: Error occured on rollback

data/hti_society_popdensity_adm3_minustah_vector.shp 
================
Traceback (most recent call last):
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 635, in upload
    keywords=keywords
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 563, in file_upload
    new_layer = save(layer, filename, theuser, overwrite, keywords=keywords)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 320, in save
    store, gs_resource = create_store_and_resource(name, data, overwrite=overwrite)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 688, in _create_db_featurestore
    cat.add_data_to_store(ds, name, data, overwrite=overwrite, charset=charset)
  File "/var/lib/geonode/local/lib/python2.7/site-packages/geoserver/catalog.py", line 276, in add_data_to_store
    raise UploadError(response)
UploadError: Could not save the layer hti_society_popdensity_adm3_minustah_vector, there was an upload error: java.io.IOException: Error occured on rollback

data/hti_geology_geomorphology_polygon_082005.shp 
================
Traceback (most recent call last):
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 635, in upload
    keywords=keywords
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 563, in file_upload
    new_layer = save(layer, filename, theuser, overwrite, keywords=keywords)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 320, in save
    store, gs_resource = create_store_and_resource(name, data, overwrite=overwrite)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 688, in _create_db_featurestore
    cat.add_data_to_store(ds, name, data, overwrite=overwrite, charset=charset)
  File "/var/lib/geonode/local/lib/python2.7/site-packages/geoserver/catalog.py", line 276, in add_data_to_store
    raise UploadError(response)
UploadError: Could not save the layer hti_geology_geomorphology_polygon_082005, there was an upload error: java.io.IOException: Error occured on rollback

data/hti_location_priority_areas_pap_CarrefourFeuilles_nathat_102011.shp 
================
Traceback (most recent call last):
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 635, in upload
    keywords=keywords
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 563, in file_upload
    new_layer = save(layer, filename, theuser, overwrite, keywords=keywords)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 320, in save
    store, gs_resource = create_store_and_resource(name, data, overwrite=overwrite)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 688, in _create_db_featurestore
    cat.add_data_to_store(ds, name, data, overwrite=overwrite, charset=charset)
  File "/var/lib/geonode/local/lib/python2.7/site-packages/geoserver/catalog.py", line 276, in add_data_to_store
    raise UploadError(response)
UploadError: Could not save the layer hti_location_priority_areas_pap_carrefourfeuilles_nathat_102011, there was an upload error: java.io.IOException: Error occured on rollback

data/hti_locations_adm2_communes_cnigs_points.shp 
================
Traceback (most recent call last):
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 635, in upload
    keywords=keywords
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 563, in file_upload
    new_layer = save(layer, filename, theuser, overwrite, keywords=keywords)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 320, in save
    store, gs_resource = create_store_and_resource(name, data, overwrite=overwrite)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 688, in _create_db_featurestore
    cat.add_data_to_store(ds, name, data, overwrite=overwrite, charset=charset)
  File "/var/lib/geonode/local/lib/python2.7/site-packages/geoserver/catalog.py", line 276, in add_data_to_store
    raise UploadError(response)
UploadError: Could not save the layer hti_locations_adm2_communes_cnigs_points, there was an upload error: java.io.IOException: Error occured on rollback

data/hti_locations_adm2_communes_centres_cnigs_062006_points.shp 
================
Traceback (most recent call last):
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 635, in upload
    keywords=keywords
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 563, in file_upload
    new_layer = save(layer, filename, theuser, overwrite, keywords=keywords)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 320, in save
    store, gs_resource = create_store_and_resource(name, data, overwrite=overwrite)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 688, in _create_db_featurestore
    cat.add_data_to_store(ds, name, data, overwrite=overwrite, charset=charset)
  File "/var/lib/geonode/local/lib/python2.7/site-packages/geoserver/catalog.py", line 276, in add_data_to_store
    raise UploadError(response)
UploadError: Could not save the layer hti_locations_adm2_communes_centres_cnigs_062006_points, there was an upload error: java.io.IOException: Error occured on rollback

data/hti_hazardhydrology_frequenflood_polygon_052010.shp 
================
Traceback (most recent call last):
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 635, in upload
    keywords=keywords
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 563, in file_upload
    new_layer = save(layer, filename, theuser, overwrite, keywords=keywords)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 320, in save
    store, gs_resource = create_store_and_resource(name, data, overwrite=overwrite)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 688, in _create_db_featurestore
    cat.add_data_to_store(ds, name, data, overwrite=overwrite, charset=charset)
  File "/var/lib/geonode/local/lib/python2.7/site-packages/geoserver/catalog.py", line 276, in add_data_to_store
    raise UploadError(response)
UploadError: Could not save the layer hti_hazardhydrology_frequenflood_polygon_052010, there was an upload error: java.io.IOException: Error occured on rollback

data/hti_topo_wetlands_polygon_092008.shp 
================
Traceback (most recent call last):
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 635, in upload
    keywords=keywords
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 563, in file_upload
    new_layer = save(layer, filename, theuser, overwrite, keywords=keywords)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 320, in save
    store, gs_resource = create_store_and_resource(name, data, overwrite=overwrite)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 688, in _create_db_featurestore
    cat.add_data_to_store(ds, name, data, overwrite=overwrite, charset=charset)
  File "/var/lib/geonode/local/lib/python2.7/site-packages/geoserver/catalog.py", line 276, in add_data_to_store
    raise UploadError(response)
UploadError: Could not save the layer hti_topo_wetlands_polygon_092008, there was an upload error: java.io.IOException: Error occured on rollback

data/hti_topo_contours20m_line_092008.shp 
================
Traceback (most recent call last):
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 635, in upload
    keywords=keywords
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 563, in file_upload
    new_layer = save(layer, filename, theuser, overwrite, keywords=keywords)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 320, in save
    store, gs_resource = create_store_and_resource(name, data, overwrite=overwrite)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 688, in _create_db_featurestore
    cat.add_data_to_store(ds, name, data, overwrite=overwrite, charset=charset)
  File "/var/lib/geonode/local/lib/python2.7/site-packages/geoserver/catalog.py", line 276, in add_data_to_store
    raise UploadError(response)
UploadError: Could not save the layer hti_topo_contours20m_line_092008, there was an upload error: java.io.IOException: Error occured on rollback

data/hti_hazardhydrology_propitiousfloodzone_polygon_052010.shp 
================
Traceback (most recent call last):
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 635, in upload
    keywords=keywords
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 563, in file_upload
    new_layer = save(layer, filename, theuser, overwrite, keywords=keywords)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 320, in save
    store, gs_resource = create_store_and_resource(name, data, overwrite=overwrite)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 688, in _create_db_featurestore
    cat.add_data_to_store(ds, name, data, overwrite=overwrite, charset=charset)
  File "/var/lib/geonode/local/lib/python2.7/site-packages/geoserver/catalog.py", line 276, in add_data_to_store
    raise UploadError(response)
UploadError: Could not save the layer hti_hazardhydrology_propitiousfloodzone_polygon_052010, there was an upload error: java.io.IOException: Error occured on rollback

data/hti_topo_earthquakeepicentre_point_012010.shp 
================
Traceback (most recent call last):
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 635, in upload
    keywords=keywords
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 563, in file_upload
    new_layer = save(layer, filename, theuser, overwrite, keywords=keywords)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 320, in save
    store, gs_resource = create_store_and_resource(name, data, overwrite=overwrite)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 688, in _create_db_featurestore
    cat.add_data_to_store(ds, name, data, overwrite=overwrite, charset=charset)
  File "/var/lib/geonode/local/lib/python2.7/site-packages/geoserver/catalog.py", line 276, in add_data_to_store
    raise UploadError(response)
UploadError: Could not save the layer hti_topo_earthquakeepicentre_point_012010, there was an upload error: java.io.IOException: Error occured on rollback

data/hti_topo_coastlimitnoaa_polygon_092008.shp 
================
Traceback (most recent call last):
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 635, in upload
    keywords=keywords
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 563, in file_upload
    new_layer = save(layer, filename, theuser, overwrite, keywords=keywords)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 320, in save
    store, gs_resource = create_store_and_resource(name, data, overwrite=overwrite)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 688, in _create_db_featurestore
    cat.add_data_to_store(ds, name, data, overwrite=overwrite, charset=charset)
  File "/var/lib/geonode/local/lib/python2.7/site-packages/geoserver/catalog.py", line 276, in add_data_to_store
    raise UploadError(response)
UploadError: Could not save the layer hti_topo_coastlimitnoaa_polygon_092008, there was an upload error: java.io.IOException: Error occured on rollback

data/hti_structure_idpcamps_iom_dtm_12012012_point.shp 
================
Traceback (most recent call last):
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 635, in upload
    keywords=keywords
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 563, in file_upload
    new_layer = save(layer, filename, theuser, overwrite, keywords=keywords)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 320, in save
    store, gs_resource = create_store_and_resource(name, data, overwrite=overwrite)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 688, in _create_db_featurestore
    cat.add_data_to_store(ds, name, data, overwrite=overwrite, charset=charset)
  File "/var/lib/geonode/local/lib/python2.7/site-packages/geoserver/catalog.py", line 276, in add_data_to_store
    raise UploadError(response)
UploadError: Could not save the layer hti_structure_idpcamps_iom_dtm_12012012_point, there was an upload error: java.io.IOException: Error occured on rollback

data/hti_structure_sheltercamps_point_052010.shp 
================
Traceback (most recent call last):
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 635, in upload
    keywords=keywords
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 563, in file_upload
    new_layer = save(layer, filename, theuser, overwrite, keywords=keywords)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 320, in save
    store, gs_resource = create_store_and_resource(name, data, overwrite=overwrite)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 688, in _create_db_featurestore
    cat.add_data_to_store(ds, name, data, overwrite=overwrite, charset=charset)
  File "/var/lib/geonode/local/lib/python2.7/site-packages/geoserver/catalog.py", line 276, in add_data_to_store
    raise UploadError(response)
UploadError: Could not save the layer hti_structure_sheltercamps_point_052010, there was an upload error: java.io.IOException: Error occured on rollback

data/hti_boundaries_departements_adm1_cnigs_line.shp 
================
Traceback (most recent call last):
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 635, in upload
    keywords=keywords
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 563, in file_upload
    new_layer = save(layer, filename, theuser, overwrite, keywords=keywords)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 320, in save
    store, gs_resource = create_store_and_resource(name, data, overwrite=overwrite)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 688, in _create_db_featurestore
    cat.add_data_to_store(ds, name, data, overwrite=overwrite, charset=charset)
  File "/var/lib/geonode/local/lib/python2.7/site-packages/geoserver/catalog.py", line 276, in add_data_to_store
    raise UploadError(response)
UploadError: Could not save the layer hti_boundaries_departements_adm1_cnigs_line, there was an upload error: java.io.IOException: Error occured on rollback

data/hti_boundaries_international_cnigs_polygon.shp 
================
Traceback (most recent call last):
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 635, in upload
    keywords=keywords
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 563, in file_upload
    new_layer = save(layer, filename, theuser, overwrite, keywords=keywords)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 320, in save
    store, gs_resource = create_store_and_resource(name, data, overwrite=overwrite)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 688, in _create_db_featurestore
    cat.add_data_to_store(ds, name, data, overwrite=overwrite, charset=charset)
  File "/var/lib/geonode/local/lib/python2.7/site-packages/geoserver/catalog.py", line 276, in add_data_to_store
    raise UploadError(response)
UploadError: Could not save the layer hti_boundaries_international_cnigs_polygon, there was an upload error: java.io.IOException: Error occured on rollback

data/hti_location_populatedplaces_cnigs_points.shp 
================
Traceback (most recent call last):
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 635, in upload
    keywords=keywords
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 563, in file_upload
    new_layer = save(layer, filename, theuser, overwrite, keywords=keywords)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 320, in save
    store, gs_resource = create_store_and_resource(name, data, overwrite=overwrite)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 688, in _create_db_featurestore
    cat.add_data_to_store(ds, name, data, overwrite=overwrite, charset=charset)
  File "/var/lib/geonode/local/lib/python2.7/site-packages/geoserver/catalog.py", line 276, in add_data_to_store
    raise UploadError(response)
UploadError: Could not save the layer hti_location_populatedplaces_cnigs_points, there was an upload error: java.io.IOException: Error occured on rollback

data/hti_location_priority_areas_pap_simon_pele_nathat_102011.shp 
================
Traceback (most recent call last):
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 635, in upload
    keywords=keywords
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 563, in file_upload
    new_layer = save(layer, filename, theuser, overwrite, keywords=keywords)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 320, in save
    store, gs_resource = create_store_and_resource(name, data, overwrite=overwrite)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 688, in _create_db_featurestore
    cat.add_data_to_store(ds, name, data, overwrite=overwrite, charset=charset)
  File "/var/lib/geonode/local/lib/python2.7/site-packages/geoserver/catalog.py", line 276, in add_data_to_store
    raise UploadError(response)
UploadError: Could not save the layer hti_location_priority_areas_pap_simon_pele_nathat_102011, there was an upload error: java.io.IOException: Error occured on rollback

data/hti_geology_geology_Pap_Coxetalii_2011_polygon.shp 
================
Traceback (most recent call last):
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 635, in upload
    keywords=keywords
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 563, in file_upload
    new_layer = save(layer, filename, theuser, overwrite, keywords=keywords)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 320, in save
    store, gs_resource = create_store_and_resource(name, data, overwrite=overwrite)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 688, in _create_db_featurestore
    cat.add_data_to_store(ds, name, data, overwrite=overwrite, charset=charset)
  File "/var/lib/geonode/local/lib/python2.7/site-packages/geoserver/catalog.py", line 276, in add_data_to_store
    raise UploadError(response)
UploadError: Could not save the layer hti_geology_geology_pap_coxetalii_2011_polygon, there was an upload error: java.io.IOException: Error occured on rollback

data/hti_location_priority_areas_pap_martissant_nathat_102011.shp 
================
Traceback (most recent call last):
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 635, in upload
    keywords=keywords
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 563, in file_upload
    new_layer = save(layer, filename, theuser, overwrite, keywords=keywords)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 320, in save
    store, gs_resource = create_store_and_resource(name, data, overwrite=overwrite)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 688, in _create_db_featurestore
    cat.add_data_to_store(ds, name, data, overwrite=overwrite, charset=charset)
  File "/var/lib/geonode/local/lib/python2.7/site-packages/geoserver/catalog.py", line 276, in add_data_to_store
    raise UploadError(response)
UploadError: Could not save the layer hti_location_priority_areas_pap_martissant_nathat_102011, there was an upload error: java.io.IOException: Error occured on rollback

data/hti_hazardclimate_droughtzone_polygon_052010.shp 
================
Traceback (most recent call last):
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 635, in upload
    keywords=keywords
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 563, in file_upload
    new_layer = save(layer, filename, theuser, overwrite, keywords=keywords)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 320, in save
    store, gs_resource = create_store_and_resource(name, data, overwrite=overwrite)
  File "/var/lib/geonode/src/GeoNodePy/geonode/maps/utils.py", line 688, in _create_db_featurestore
    cat.add_data_to_store(ds, name, data, overwrite=overwrite, charset=charset)
  File "/var/lib/geonode/local/lib/python2.7/site-packages/geoserver/catalog.py", line 276, in add_data_to_store
    raise UploadError(response)
UploadError: Could not save the layer hti_hazardclimate_droughtzone_polygon_052010, there was an upload error: java.io.IOException: Error occured on rollback

data/hti_hazardgeology_liquefactionincidents_point_022010.shp 
================
Tracebac
ingenieroariel commented 11 years ago

Ok, new approach:

1. Let's install a vanilla GeoNode but not do anything with it.

2. Let's remove geoserver from /var/lib/tomcat/webapps/geoserver

3. Let's get the latest stable release from the 2.1.x branch and put it in /var/lib/tomcat/webapps/geoserver

4. Let's put GEOSERVER_CREDENTIALS='admin','geoserver' in /etc/geonode/local_settings.py

(Security will not work, but upload should)

5. Restart apache and tomcat

6. Run importlayers again against a vanilla GeoServer - no custom builds and see what happens.

# regular installation of GeoNode 1.2beta2
sudo add-apt-repository ppa:geonode/snapshots -y
sudo apt-get update
sudo apt-get install -y geonode
sudo geonode-updateip ec2-50-19-66-173.compute-1.amazonaws.com

# Stopping tomcat and removing geoserver
sudo service tomcat6 stop
sudo rm -rf /var/lib/tomcat6/webapps/geoserver

#Getting new geoserver, putting it in tomcat, replacing default geoserver credentials and restarting services
wget http://downloads.sourceforge.net/geoserver/geoserver-2.1.4-war.zip
unzip geoserver-2.1.4-war.zip
sudo mv geoserver.war /var/lib/tomcat6/webapps/
sudo vim /etc/geonode/local_settings.py
sudo service apache2 restart
sudo service tomcat6 start

#Getting the test data from haitidata.org
sudo pip install geonode-extract
geonode-extract http://haitidata.org -i -v -d data -u ariel -p my password

After setting up the environment, let's re-try the data upload:

ubuntu@ip-10-146-144-187:~$ geonode importlayers data
[created] Layer for 'data/hti_biota_landcover_spot_cnigs_041998_polygon.shp' (1/64)
[created] Layer for 'data/hti_structure_ochasheltersites_point_022010.shp' (2/64)
[created] Layer for 'data/hti_structure_idpcamps_ocha_022010_point.shp' (3/64)
[created] Layer for 'data/hti_location_priority_areas_pap_tabarre_nathat_102011.shp' (4/64)
[created] Layer for 'data/hti_hazardclimate_monthprecipitationstation_point_052010.shp' (5/64)
[created] Layer for 'data/hti_structure_buildings_osm_20111021_polygones.shp' (6/64)
[created] Layer for 'data/hti_boundaries_communes_adm2_cnigs_polygon.shp' (7/64)
[created] Layer for 'data/hti_meteorology_rainstations_nathat_cnm_point.shp' (8/64)
[created] Layer for 'data/hti_boundaries_communes_adm2_cnigs_line.shp' (9/64)
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.
[failed] Layer for 'data/hti_hazardhydrology_exceptionalflood_westdepartment_nathat_polygon_052010.shp' (10/64)
Could not save the layer hti_boundary_country_polygon_062006, there was an upload error: java.io.IOException: Schema 'http://www.openplans.org/topp:hti_hazardhydrology_exceptionalflood_westdepartment_nathat_polygon_052010' does not exist.
[failed] Layer for 'data/hti_boundary_country_polygon_062006.shp' (11/64)
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
[failed] Layer for 'data/hti_hazardgeology_landslidesdetail_point_022010.shp' (12/64)
Error deleting PostGIS table hti_inlandwaters_rivers_cnigs_line_062006:table "hti_inlandwaters_rivers_cnigs_line_062006" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_inlandwaters_rivers_cnigs_line_062006"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_inlandwaters_rivers_cnigs_line_062006, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_inlandwaters_rivers_cnigs_line_062006.shp' (13/64)
Error deleting PostGIS table hti_boundaries_sections_communales_adm3_cnigs_polygon:table "hti_boundaries_sections_communales_adm3_cnigs_polygon" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_boundaries_sections_communales_adm3_cnigs_polygon"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_boundaries_sections_communales_adm3_cnigs_polygon, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_boundaries_sections_communales_adm3_cnigs_polygon.shp' (14/64)
Error deleting PostGIS table hti_boundaries_departements_adm1_cnigs_polygon:table "hti_boundaries_departements_adm1_cnigs_polygon" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_boundaries_departements_adm1_cnigs_polygon"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_boundaries_departements_adm1_cnigs_polygon, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_boundaries_departements_adm1_cnigs_polygon.shp' (15/64)
Error deleting PostGIS table hti_geology_geology_polygon_082005:table "hti_geology_geology_polygon_082005" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_geology_geology_polygon_082005"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_geology_geology_polygon_082005, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_geology_geology_polygon_082005.shp' (16/64)
Error deleting PostGIS table hti_structure_health_facilities_ante_2010_osm_15032011:table "hti_structure_health_facilities_ante_2010_osm_15032011" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_structure_health_facilities_ante_2010_osm_15032011"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_structure_health_facilities_ante_2010_osm_15032011, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_structure_health_facilities_ante_2010_osm_15032011.shp' (17/64)
Error deleting PostGIS table hti_hazardhydrology_frequentflood_westdepartment_nathat_polygon_052010:table "hti_hazardhydrology_frequentflood_westdepartment_nathat_polygon" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_hazardhydrology_frequentflood_westdepartment_nathat_polygon_052010"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_hazardhydrology_frequentflood_westdepartment_nathat_polygon_052010, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_hazardhydrology_frequentflood_westdepartment_nathat_polygon_052010.shp' (18/64)
Error deleting PostGIS table hti_popa_projectionseccom2009_ihsi:table "hti_popa_projectionseccom2009_ihsi" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_popa_projectionseccom2009_ihsi"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_popa_projectionseccom2009_ihsi, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_popa_projectionSecCom2009_IHSI.shp' (19/64)
Error deleting PostGIS table hti_locations_adm1_departement_centres_cnigs_062006_points:table "hti_locations_adm1_departement_centres_cnigs_062006_points" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_locations_adm1_departement_centres_cnigs_062006_points"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_locations_adm1_departement_centres_cnigs_062006_points, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_locations_adm1_departement_centres_cnigs_062006_points.shp' (20/64)
Error deleting PostGIS table hti_structure_health_ctc_ctu_osm_20111219_point:table "hti_structure_health_ctc_ctu_osm_20111219_point" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_structure_health_ctc_ctu_osm_20111219_point"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_structure_health_ctc_ctu_osm_20111219_point, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_structure_health_ctc_ctu_osm_20111219_point.shp' (21/64)
Error deleting PostGIS table hti_structure_disaster_shelters_osm_2011_04_points:table "hti_structure_disaster_shelters_osm_2011_04_points" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_structure_disaster_shelters_osm_2011_04_points"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_structure_disaster_shelters_osm_2011_04_points, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_structure_disaster_shelters_osm_2011_04_points.shp' (22/64)
Error deleting PostGIS table hti_topo_elevationnames_point_092008:table "hti_topo_elevationnames_point_092008" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_topo_elevationnames_point_092008"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_topo_elevationnames_point_092008, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_topo_elevationnames_point_092008.shp' (23/64)
Error deleting PostGIS table hti_hazardhydrology_floodzone_polygon_092008:table "hti_hazardhydrology_floodzone_polygon_092008" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_hazardhydrology_floodzone_polygon_092008"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_hazardhydrology_floodzone_polygon_092008, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_hazardhydrology_floodzone_polygon_092008.shp' (24/64)
Error deleting PostGIS table hti_society_popdensity_adm3_minustah_vector:table "hti_society_popdensity_adm3_minustah_vector" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_society_popdensity_adm3_minustah_vector"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_society_popdensity_adm3_minustah_vector, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_society_popdensity_adm3_minustah_vector.shp' (25/64)
Error deleting PostGIS table hti_geology_geomorphology_polygon_082005:table "hti_geology_geomorphology_polygon_082005" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_geology_geomorphology_polygon_082005"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_geology_geomorphology_polygon_082005, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_geology_geomorphology_polygon_082005.shp' (26/64)
Error deleting PostGIS table hti_location_priority_areas_pap_carrefourfeuilles_nathat_102011:table "hti_location_priority_areas_pap_carrefourfeuilles_nathat_102011" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_location_priority_areas_pap_carrefourfeuilles_nathat_102011"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_location_priority_areas_pap_carrefourfeuilles_nathat_102011, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_location_priority_areas_pap_CarrefourFeuilles_nathat_102011.shp' (27/64)
Error deleting PostGIS table hti_locations_adm2_communes_cnigs_points:table "hti_locations_adm2_communes_cnigs_points" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_locations_adm2_communes_cnigs_points"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_locations_adm2_communes_cnigs_points, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_locations_adm2_communes_cnigs_points.shp' (28/64)
Error deleting PostGIS table hti_locations_adm2_communes_centres_cnigs_062006_points:table "hti_locations_adm2_communes_centres_cnigs_062006_points" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_locations_adm2_communes_centres_cnigs_062006_points"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_locations_adm2_communes_centres_cnigs_062006_points, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_locations_adm2_communes_centres_cnigs_062006_points.shp' (29/64)
Error deleting PostGIS table hti_hazardhydrology_frequenflood_polygon_052010:table "hti_hazardhydrology_frequenflood_polygon_052010" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_hazardhydrology_frequenflood_polygon_052010"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_hazardhydrology_frequenflood_polygon_052010, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_hazardhydrology_frequenflood_polygon_052010.shp' (30/64)
Error deleting PostGIS table hti_topo_wetlands_polygon_092008:table "hti_topo_wetlands_polygon_092008" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_topo_wetlands_polygon_092008"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_topo_wetlands_polygon_092008, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_topo_wetlands_polygon_092008.shp' (31/64)
Error deleting PostGIS table hti_topo_contours20m_line_092008:table "hti_topo_contours20m_line_092008" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_topo_contours20m_line_092008"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_topo_contours20m_line_092008, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_topo_contours20m_line_092008.shp' (32/64)
Error deleting PostGIS table hti_hazardhydrology_propitiousfloodzone_polygon_052010:table "hti_hazardhydrology_propitiousfloodzone_polygon_052010" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_hazardhydrology_propitiousfloodzone_polygon_052010"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_hazardhydrology_propitiousfloodzone_polygon_052010, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_hazardhydrology_propitiousfloodzone_polygon_052010.shp' (33/64)
Error deleting PostGIS table hti_topo_earthquakeepicentre_point_012010:table "hti_topo_earthquakeepicentre_point_012010" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_topo_earthquakeepicentre_point_012010"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_topo_earthquakeepicentre_point_012010, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_topo_earthquakeepicentre_point_012010.shp' (34/64)
Error deleting PostGIS table hti_topo_coastlimitnoaa_polygon_092008:table "hti_topo_coastlimitnoaa_polygon_092008" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_topo_coastlimitnoaa_polygon_092008"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_topo_coastlimitnoaa_polygon_092008, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_topo_coastlimitnoaa_polygon_092008.shp' (35/64)
Error deleting PostGIS table hti_structure_idpcamps_iom_dtm_12012012_point:table "hti_structure_idpcamps_iom_dtm_12012012_point" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_structure_idpcamps_iom_dtm_12012012_point"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_structure_idpcamps_iom_dtm_12012012_point, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_structure_idpcamps_iom_dtm_12012012_point.shp' (36/64)
Could not save the layer hti_structure_sheltercamps_point_052010, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_structure_sheltercamps_point_052010.shp' (37/64)
Error deleting PostGIS table hti_boundaries_departements_adm1_cnigs_line:table "hti_boundaries_departements_adm1_cnigs_line" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_boundaries_departements_adm1_cnigs_line"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_boundaries_departements_adm1_cnigs_line, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_boundaries_departements_adm1_cnigs_line.shp' (38/64)
Error deleting PostGIS table hti_boundaries_international_cnigs_polygon:table "hti_boundaries_international_cnigs_polygon" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_boundaries_international_cnigs_polygon"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_boundaries_international_cnigs_polygon, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_boundaries_international_cnigs_polygon.shp' (39/64)
Error deleting PostGIS table hti_location_populatedplaces_cnigs_points:table "hti_location_populatedplaces_cnigs_points" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_location_populatedplaces_cnigs_points"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_location_populatedplaces_cnigs_points, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_location_populatedplaces_cnigs_points.shp' (40/64)
Could not save the layer hti_location_priority_areas_pap_simon_pele_nathat_102011, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_location_priority_areas_pap_simon_pele_nathat_102011.shp' (41/64)
Error deleting PostGIS table hti_geology_geology_pap_coxetalii_2011_polygon:table "hti_geology_geology_pap_coxetalii_2011_polygon" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_geology_geology_pap_coxetalii_2011_polygon"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_geology_geology_pap_coxetalii_2011_polygon, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_geology_geology_Pap_Coxetalii_2011_polygon.shp' (42/64)
Error deleting PostGIS table hti_location_priority_areas_pap_martissant_nathat_102011:table "hti_location_priority_areas_pap_martissant_nathat_102011" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_location_priority_areas_pap_martissant_nathat_102011"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_location_priority_areas_pap_martissant_nathat_102011, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_location_priority_areas_pap_martissant_nathat_102011.shp' (43/64)
Could not save the layer hti_hazardclimate_droughtzone_polygon_052010, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_hazardclimate_droughtzone_polygon_052010.shp' (44/64)
Error deleting PostGIS table hti_hazardgeology_liquefactionincidents_point_022010:table "hti_hazardgeology_liquefactionincidents_point_022010" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_hazardgeology_liquefactionincidents_point_022010"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_hazardgeology_liquefactionincidents_point_022010, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_hazardgeology_liquefactionincidents_point_022010.shp' (45/64)
Error deleting PostGIS table hti_topo_lakes_polygon_092008:table "hti_topo_lakes_polygon_092008" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_topo_lakes_polygon_092008"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_topo_lakes_polygon_092008, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_topo_lakes_polygon_092008.shp' (46/64)
Error deleting PostGIS table hti_hazardhydrology_probablefloodzone_polygon_052010:table "hti_hazardhydrology_probablefloodzone_polygon_052010" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_hazardhydrology_probablefloodzone_polygon_052010"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_hazardhydrology_probablefloodzone_polygon_052010, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_hazardhydrology_probablefloodzone_polygon_052010.shp' (47/64)
Error deleting PostGIS table hti_hazardhydrology_rareflood_westdepartment_nathat_polygon_052010:table "hti_hazardhydrology_rareflood_westdepartment_nathat_polygon_052" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_hazardhydrology_rareflood_westdepartment_nathat_polygon_052010"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_hazardhydrology_rareflood_westdepartment_nathat_polygon_052010, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_hazardhydrology_rareflood_westdepartment_nathat_polygon_052010.shp' (48/64)
Error deleting PostGIS table hti_location_priority_areas_pap_bel_air_nathat_102011:table "hti_location_priority_areas_pap_bel_air_nathat_102011" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_location_priority_areas_pap_bel_air_nathat_102011"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_location_priority_areas_pap_bel_air_nathat_102011, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_location_priority_areas_pap_Bel_Air_nathat_102011.shp' (49/64)
Error deleting PostGIS table hti_biota_landcoveravhrr_polygon_031995:table "hti_biota_landcoveravhrr_polygon_031995" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_biota_landcoveravhrr_polygon_031995"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_biota_landcoveravhrr_polygon_031995, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_biota_landcoveravhrr_polygon_031995.shp' (50/64)
Error deleting PostGIS table hti_environment_erosion_polygon_042008:table "hti_environment_erosion_polygon_042008" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_environment_erosion_polygon_042008"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_environment_erosion_polygon_042008, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_environment_erosion_polygon_042008.shp' (51/64)
Error deleting PostGIS table hti_location_priority_areas_pap_martin_luther_nazon_nathat_102011:table "hti_location_priority_areas_pap_martin_luther_nazon_nathat_1020" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_location_priority_areas_pap_martin_luther_nazon_nathat_102011"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_location_priority_areas_pap_martin_luther_nazon_nathat_102011, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_location_priority_areas_pap_Martin_Luther_Nazon_nathat_102011.shp' (52/64)
Error deleting PostGIS table hti_transportation_road_network_wfp_line:table "hti_transportation_road_network_wfp_line" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_transportation_road_network_wfp_line"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_transportation_road_network_wfp_line, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_transportation_road_network_wfp_line.shp' (53/64)
Error deleting PostGIS table hti_hazardhydrology_floodregions_nathat_polygon_052010:table "hti_hazardhydrology_floodregions_nathat_polygon_052010" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_hazardhydrology_floodregions_nathat_polygon_052010"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_hazardhydrology_floodregions_nathat_polygon_052010, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_hazardhydrology_floodregions_nathat_polygon_052010.shp' (54/64)
Error deleting PostGIS table hti_boundaries_sections_communales_adm3_cnigs_line:table "hti_boundaries_sections_communales_adm3_cnigs_line" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_boundaries_sections_communales_adm3_cnigs_line"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_boundaries_sections_communales_adm3_cnigs_line, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_boundaries_sections_communales_adm3_cnigs_line.shp' (55/64)
Error deleting PostGIS table hti_soil_soilcapacity_polygon_041998:table "hti_soil_soilcapacity_polygon_041998" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_soil_soilcapacity_polygon_041998"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_soil_soilcapacity_polygon_041998, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_soil_soilcapacity_polygon_041998.shp' (56/64)
Error deleting PostGIS table hti_hazardgeology_landslideincidents_point_022010:table "hti_hazardgeology_landslideincidents_point_022010" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_hazardgeology_landslideincidents_point_022010"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_hazardgeology_landslideincidents_point_022010, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_hazardgeology_landslideincidents_point_022010.shp' (57/64)
Error deleting PostGIS table hti_boundaries_international_minustah_line:table "hti_boundaries_international_minustah_line" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_boundaries_international_minustah_line"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_boundaries_international_minustah_line, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_boundaries_international_minustah_line.shp' (58/64)
Error deleting PostGIS table hti_location_priority_areas_pap_delmas32_nathat_102011:table "hti_location_priority_areas_pap_delmas32_nathat_102011" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_location_priority_areas_pap_delmas32_nathat_102011"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_location_priority_areas_pap_delmas32_nathat_102011, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_location_priority_areas_pap_delmas32_nathat_102011.shp' (59/64)
Error deleting PostGIS table hti_inlandwaters_watersheds_datpe_cnigs_polygon_092008:table "hti_inlandwaters_watersheds_datpe_cnigs_polygon_092008" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_inlandwaters_watersheds_datpe_cnigs_polygon_092008"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_inlandwaters_watersheds_datpe_cnigs_polygon_092008, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_inlandwaters_watersheds_datpe_cnigs_polygon_092008.shp' (60/64)
Error deleting PostGIS table hti_transport_roads_line_062006:table "hti_transport_roads_line_062006" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_transport_roads_line_062006"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_transport_roads_line_062006, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_transport_roads_line_062006.shp' (61/64)
Error deleting PostGIS table hti_locations_populatedplaces_osm_points:table "hti_locations_populatedplaces_osm_points" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_locations_populatedplaces_osm_points"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_locations_populatedplaces_osm_points, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_locations_populatedplaces_osm_points.shp' (62/64)
Error deleting PostGIS table hti_topo_contours50m_line_092008:table "hti_topo_contours50m_line_092008" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_topo_contours50m_line_092008"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_topo_contours50m_line_092008, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_topo_contours50m_line_092008.shp' (63/64)
Error deleting PostGIS table hti_topo_coastlimitnoaa_line_092008:table "hti_topo_coastlimitnoaa_line_092008" does not exist
CONTEXT:  SQL statement "DROP TABLE public.hti_topo_coastlimitnoaa_line_092008"
PL/pgSQL function "dropgeometrytable" line 23 at EXECUTE statement

Could not save the layer hti_topo_coastlimitnoaa_line_092008, there was an upload error: java.io.IOException: Error occured on rollback
[failed] Layer for 'data/hti_topo_coastlimitnoaa_line_092008.shp' (64/64)

Finished processing 64 layers in 114.0 seconds.

9 Created layers
0 Updated layers
0 Skipped layers
55 Failed layers
1.781250 seconds per layer

Same problem with vanilla geoserver-2.1.4:

version

ingenieroariel commented 11 years ago

Full geoserver log is available at:

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

ingenieroariel commented 11 years ago

I reported this in the GeoServer tracker, this issue is a blocker for the 1.2 release.

http://jira.codehaus.org/browse/GEOS-5250

dwins commented 11 years ago

This is unlikely to get fixed in GeoServer any time soon. Postgres has a built-in limit on the size of table names. You can change it at compile time (of Postgres) but it defaults to 64. GeoServer doesn't handle well the error when you ask it to create a table with an invalid name, but it probably makes sense to munge on the GeoNode side rather than try and get Postgres to allow unlimited-length table names.

ingenieroariel commented 11 years ago

Thanks @dwins for your comment. I'd say the issue is not getting Postgres to allow unlimited-length table names, but rather that in this case, the result of a failed action in geoserver, makes subsequent actions fail.

My post to the geoserver list did not get any comments in the last two months and my attempts to use different (non-community) channels to direct attention from geoserver developers to that report did not yield any results either. Examples like this of places where geonode usage hits obscure geoserver behavior, and our lack of ability to get the geoserver community interested in solving it is a liability to the geonode project and perhaps a good reason to consider multiple backends for the WMS / WCS / WFS, like we did with CSW.

I will take your advice and implement the workaround you suggest on the python side.