{"action":"created","issue":{"url":"https://api.github.com/repos/CartoDB/cartodb/issues/6133","labels_url":"https://api.github.com/repos/CartoDB/cartodb/issues/6133/labels{/name}","comments_url":"https://api.github.com/repos/CartoDB/cartodb/issues/6133/comments","events_url":"https://api.github.com/repos/CartoDB/cartodb/issues/6133/events","html_url":"https://github.com/CartoDB/cartodb/issues/6133","id":116820813,"number":6133,"title":"Ghost tables might be generating two tables with the same name and dropping incorrect vizs","user":{"login":"iriberri","id":1730320,"avatar_url":"https://avatars.githubusercontent.com/u/1730320?v=3","gravatar_id":"","url":"https://api.github.com/users/iriberri","html_url":"https://github.com/iriberri","followers_url":"https://api.github.com/users/iriberri/followers","following_url":"https://api.github.com/users/iriberri/following{/other_user}","gists_url":"https://api.github.com/users/iriberri/gists{/gist_id}","starred_url":"https://api.github.com/users/iriberri/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/iriberri/subscriptions","organizations_url":"https://api.github.com/users/iriberri/orgs","repos_url":"https://api.github.com/users/iriberri/repos","events_url":"https://api.github.com/users/iriberri/events{/privacy}","received_events_url":"https://api.github.com/users/iriberri/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"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},"milestone":null,"comments":1,"created_at":"2015-11-13T18:16:37Z","updated_at":"2015-11-13T19:34:24Z","closed_at":null,"body":"SB/7301378\r\n\r\n**Scenario**:\r\n* Two tables with the same name were listed in the dashboard\r\n* When trying to delete one of them, it said it had X attached maps. When trying to delete the other, it didn't mention any attached map.\r\n* User deletes the one with apparently \"no attached maps\"\r\n* Both tables get removed of the account\r\n* All maps related to them get removed\r\n\r\nI have found a single \"dropping table\" event (occurrence # 8931111338) in Rollbar and a table with that name is not right now in the user database."},"comment":{"url":"https://api.github.com/repos/CartoDB/cartodb/issues/comments/156536431","html_url":"https://github.com/CartoDB/cartodb/issues/6133#issuecomment-156536431","issue_url":"https://api.github.com/repos/CartoDB/cartodb/issues/6133","id":156536431,"user":{"login":"anderser","id":88008,"avatar_url":"https://avatars.githubusercontent.com/u/88008?v=3","gravatar_id":"","url":"https://api.github.com/users/anderser","html_url":"https://github.com/anderser","followers_url":"https://api.github.com/users/anderser/followers","following_url":"https://api.github.com/users/anderser/following{/other_user}","gists_url":"https://api.github.com/users/anderser/gists{/gist_id}","starred_url":"https://api.github.com/users/anderser/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/anderser/subscriptions","organizations_url":"https://api.github.com/users/anderser/orgs","repos_url":"https://api.github.com/users/anderser/repos","events_url":"https://api.github.com/users/anderser/events{/privacy}","received_events_url":"https://api.github.com/users/anderser/received_events","type":"User","site_admin":false},"created_at":"2015-11-13T19:34:24Z","updated_at":"2015-11-13T19:34:24Z","body":"Hi. I can elaborate on this since I reported the issue with CartoDB. The table(s) was created using the API via this small script I created: https://gist.github.com/anderser/4d20691122f8582eb3cd \r\nIt first creates the tables and then \"cartodbfy\" (according to this: https://github.com/CartoDB/cartodb/wiki/creating-tables-though-the-SQL-API) them to make them visible in CartoDB. \r\n\r\nI had some trouble getting the tables created via the API to display in the list on cartodb.com - at least there was a significant delay. But in the end it worked out well. The table was updated pretty regularily on election night with new data every minute. I am afraid I am not quite sure when I saw that there were two tables with identical name/api-url in the list of tables. "}}