search

CartoDB / cartodb

Location Intelligence & Data Visualization tool
http://carto.com
BSD 3-Clause "New" or "Revised" License
2.75k stars 649 forks source link

Geocoding error in long tables (and unexpected size growth) #973

Closed rafatower closed 9 years ago

rafatower commented 10 years ago

[from jira: https://cartodb.atlassian.net/browse/CDB-3599]

A user (and me) is not able to georeference his table with 127K rows. A copy of the table is here: https://team.cartodb.com/u/iriberri/tables/carto_20_281_29

  1. Georeference by Countries using country column
  2. Georeferenciation error. Table was 13 MBs initially. It grows 10x times without being georeferenced at all. After a vacuum full it returns to its original size. This is not a problem of the values of the column itself. I have made a distinct(country) in the table and I get all the values georeferenced. The problem comes when I try to geocode the full table. I have tried splitting the table into pieces. Up to 1K rows more or less it geocodes correctly. Another sets of 10K and 50K rows fail, and it also does another set of 100K rows. There are no errors in the console. cartodb_georef_status column is created after the error and set to null. We have had two cases in SupportBee about this today.
rafatower commented 9 years ago

fixed with batching