{"action":"opened","issue":{"url":"https://api.github.com/repos/CartoDB/cartodb-postgresql/issues/123","labels_url":"https://api.github.com/repos/CartoDB/cartodb-postgresql/issues/123/labels{/name}","comments_url":"https://api.github.com/repos/CartoDB/cartodb-postgresql/issues/123/comments","events_url":"https://api.github.com/repos/CartoDB/cartodb-postgresql/issues/123/events","html_url":"https://github.com/CartoDB/cartodb-postgresql/issues/123","id":103018988,"number":123,"title":"Failure importing from ogr2ogr with -overwrite","user":{"login":"rafatower","id":1914276,"avatar_url":"https://avatars.githubusercontent.com/u/1914276?v=3","gravatar_id":"","url":"https://api.github.com/users/rafatower","html_url":"https://github.com/rafatower","followers_url":"https://api.github.com/users/rafatower/followers","following_url":"https://api.github.com/users/rafatower/following{/other_user}","gists_url":"https://api.github.com/users/rafatower/gists{/gist_id}","starred_url":"https://api.github.com/users/rafatower/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rafatower/subscriptions","organizations_url":"https://api.github.com/users/rafatower/orgs","repos_url":"https://api.github.com/users/rafatower/repos","events_url":"https://api.github.com/users/rafatower/events{/privacy}","received_events_url":"https://api.github.com/users/rafatower/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/CartoDB/cartodb-postgresql/labels/Backlog","name":"Backlog","color":"CCCCCC"},{"url":"https://api.github.com/repos/CartoDB/cartodb-postgresql/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":{"login":"rafatower","id":1914276,"avatar_url":"https://avatars.githubusercontent.com/u/1914276?v=3","gravatar_id":"","url":"https://api.github.com/users/rafatower","html_url":"https://github.com/rafatower","followers_url":"https://api.github.com/users/rafatower/followers","following_url":"https://api.github.com/users/rafatower/following{/other_user}","gists_url":"https://api.github.com/users/rafatower/gists{/gist_id}","starred_url":"https://api.github.com/users/rafatower/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rafatower/subscriptions","organizations_url":"https://api.github.com/users/rafatower/orgs","repos_url":"https://api.github.com/users/rafatower/repos","events_url":"https://api.github.com/users/rafatower/events{/privacy}","received_events_url":"https://api.github.com/users/rafatower/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/CartoDB/cartodb-postgresql/milestones/8","html_url":"https://github.com/CartoDB/cartodb-postgresql/milestones/Malpica","labels_url":"https://api.github.com/repos/CartoDB/cartodb-postgresql/milestones/8/labels","id":1258310,"number":8,"title":"Malpica","description":"","creator":{"login":"juanignaciosl","id":932968,"avatar_url":"https://avatars.githubusercontent.com/u/932968?v=3","gravatar_id":"","url":"https://api.github.com/users/juanignaciosl","html_url":"https://github.com/juanignaciosl","followers_url":"https://api.github.com/users/juanignaciosl/followers","following_url":"https://api.github.com/users/juanignaciosl/following{/other_user}","gists_url":"https://api.github.com/users/juanignaciosl/gists{/gist_id}","starred_url":"https://api.github.com/users/juanignaciosl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/juanignaciosl/subscriptions","organizations_url":"https://api.github.com/users/juanignaciosl/orgs","repos_url":"https://api.github.com/users/juanignaciosl/repos","events_url":"https://api.github.com/users/juanignaciosl/events{/privacy}","received_events_url":"https://api.github.com/users/juanignaciosl/received_events","type":"User","site_admin":false},"open_issues":4,"closed_issues":1,"state":"open","created_at":"2015-08-17T14:12:04Z","updated_at":"2015-08-25T13:13:17Z","due_on":"2015-09-01T22:00:00Z","closed_at":null},"comments":0,"created_at":"2015-08-25T13:13:17Z","updated_at":"2015-08-25T13:13:17Z","closed_at":null,"body":"```\r\nogr2ogr2 \\\r\n  --config CARTODB_API_URL https://myuser.cartodb.com/api/v2/sql \\\r\n  --config CARTODB_API_KEY 1234 \\\r\n  -s_srs EPSG:4326 \\\r\n  -t_srs EPSG:4326 \\\r\n  -f CartoDB \"CartoDB:myuser\" \\\r\n  -oo X_POSSIBLE_NAMES=lon\\* \\\r\n  -oo Y_POSSIBLE_NAMES=lat\\* \\\r\n  -overwrite \\\r\n  -dim 2 \\\r\n  country_lat_long.csv\r\n```\r\nproduces this result:\r\n```\r\nERROR 1: HTTP error code : 400\r\nERROR 1: Error returned by server : CDB(_CDB_Add_Indexes:42P07:relation \"country_lat_long_the_geom_gix\" already exists): CREATE INDEX country_lat_long_the_geom_gix ON country_lat_long USING GIST (the_geom)\r\nERROR 1: Unable to write feature 1 from layer country_lat_long.\r\n\r\nERROR 1: Terminating translation prematurely after failed\r\ntranslation of layer country_lat_long (use -skipfailures to skip errors)\r\n```"}}