search

sverhoeven / docker-cartodb

Dockerized CartoDB
BSD 3-Clause "New" or "Revised" License
147 stars 117 forks source link

Import error with shapefiles #89

Open Baschdl opened 4 years ago

Baschdl commented 4 years ago

Imports with the dockerhub py3pg12postgis3 as well as locally built py3pg12postgis3 fail with a file which works with the master branch as well as the verions running on carto.com. Not sure how to debug this further.

{
   "user":"dev",
   "state":"pending",
   "tables":0,
   "imported_tables":0,
   "failed_tables":0,
   "error_code":null,
   "import_timestamp":"2020-05-31T19:44:29.624+00:00",
   "queue_server":"37637a0f9d2e",
   "database_host":"localhost",
   "service_name":"public_url",
   "data_type":"url",
   "is_sync_import":false,
   "import_time":0.003973,
   "file_stats":{

},
   "resque_ppid":null,
   "user_timeout":1398101,
   "error_source":null,
   "id":"35985fce-ed3d-45df-a6c9-56ae5e13a781",
   "total_size":0,
   "cartodbfy_time":0.0,
   "import_throughput":0.0,
   "cartodbfy_throughtput":null,
   "cartodbfy_import_ratio":0.0,
   "extra_options":{
      "column_sanitization_version":2

},
   "retrieved_items":0
}
{
   "user":"dev",
   "state":"failure",
   "tables":1,
   "imported_tables":0,
   "failed_tables":1,
   "error_code":99999,
   "import_timestamp":"2020-05-31T19:44:34.647+00:00",
   "queue_server":"37637a0f9d2e",
   "database_host":"localhost",
   "service_name":"public_url",
   "data_type":"url",
   "is_sync_import":false,
   "import_time":5.0179428,
   "file_stats":[
      {
         "filename":"sentinel2b_20200519-103804-416_l2b-snow_t32tls_c_v1-7_snw_r2.shp",
         "type":".shp",
         "size":16905072,
         "file_rows":null,
         "imported_rows":null,
         "error_percent":null,
         "fallback_executed":null

}

],
   "resque_ppid":172,
   "user_timeout":1398101,
   "error_source":"cartodb",
   "id":"35985fce-ed3d-45df-a6c9-56ae5e13a781",
   "total_size":16905072,
   "cartodbfy_time":0.0,
   "import_throughput":3368924.811179593,
   "cartodbfy_throughtput":null,
   "cartodbfy_import_ratio":0.0,
   "extra_options":{
      "column_sanitization_version":2

},
   "retrieved_items":0
}