{"action":"reopened","issue":{"url":"https://api.github.com/repos/CartoDB/cartodb/issues/5009","labels_url":"https://api.github.com/repos/CartoDB/cartodb/issues/5009/labels{/name}","comments_url":"https://api.github.com/repos/CartoDB/cartodb/issues/5009/comments","events_url":"https://api.github.com/repos/CartoDB/cartodb/issues/5009/events","html_url":"https://github.com/CartoDB/cartodb/issues/5009","id":100592586,"number":5009,"title":"Seems like importer is using the user queries timeout","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":[],"state":"open","locked":false,"assignee":{"login":"Kartones","id":2085449,"avatar_url":"https://avatars.githubusercontent.com/u/2085449?v=3","gravatar_id":"","url":"https://api.github.com/users/Kartones","html_url":"https://github.com/Kartones","followers_url":"https://api.github.com/users/Kartones/followers","following_url":"https://api.github.com/users/Kartones/following{/other_user}","gists_url":"https://api.github.com/users/Kartones/gists{/gist_id}","starred_url":"https://api.github.com/users/Kartones/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Kartones/subscriptions","organizations_url":"https://api.github.com/users/Kartones/orgs","repos_url":"https://api.github.com/users/Kartones/repos","events_url":"https://api.github.com/users/Kartones/events{/privacy}","received_events_url":"https://api.github.com/users/Kartones/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/CartoDB/cartodb/milestones/47","html_url":"https://github.com/CartoDB/cartodb/milestones/Torrelodones","labels_url":"https://api.github.com/repos/CartoDB/cartodb/milestones/47/labels","id":1258206,"number":47,"title":"Torrelodones","description":"- [ ] LDAP (onpremise)\r\n- [ ] Users API \r\n- [ ] Explore Pages (@javier)\r\n- [ ] New public profile page (@javier)\r\n- [ ] Cluster renderer torque (@fdansv)\r\n- [ ] Advanced Map creation on Import (@rtorre)\r\n- [ ] Data Services Revamp (@iriberri)\r\n- [ ] Ruby 2.2 (@kartones)\r\n- [ ] Improve extension deployment (@jesusvazquez)\r\n- [ ] PostgreSQL extensions (@zenitram)","creator":{"login":"saleiva","id":132149,"avatar_url":"https://avatars.githubusercontent.com/u/132149?v=3","gravatar_id":"","url":"https://api.github.com/users/saleiva","html_url":"https://github.com/saleiva","followers_url":"https://api.github.com/users/saleiva/followers","following_url":"https://api.github.com/users/saleiva/following{/other_user}","gists_url":"https://api.github.com/users/saleiva/gists{/gist_id}","starred_url":"https://api.github.com/users/saleiva/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/saleiva/subscriptions","organizations_url":"https://api.github.com/users/saleiva/orgs","repos_url":"https://api.github.com/users/saleiva/repos","events_url":"https://api.github.com/users/saleiva/events{/privacy}","received_events_url":"https://api.github.com/users/saleiva/received_events","type":"User","site_admin":false},"open_issues":62,"closed_issues":0,"state":"open","created_at":"2015-08-17T13:11:56Z","updated_at":"2015-09-01T09:55:24Z","due_on":"2015-09-15T22:00:00Z","closed_at":null},"comments":3,"created_at":"2015-08-12T17:20:24Z","updated_at":"2015-09-01T09:55:24Z","closed_at":null,"body":"See import id `41c250a6-3d4a-49d6-a963-8130e144560b`\r\n```\r\n2015-08-12 16:33:55 UTC: Finished importing data from /tmp/imports/20150812-19901-nasszk/twitter_alfabet_alphabet_abcxyz_google.csv\r\n2015-08-12 16:33:56 UTC: Proceeding to register\r\n2015-08-12 16:33:56 UTC: Before renaming from importer_6cab8642410111e5a8420e6e1df11cbf to twitter_alfabet_alphabet_abcxyz_google\r\n2015-08-12 16:33:56 UTC: Before moving schema 'twitter_alfabet_alphabet_abcxyz_google' from cdb_importer to piensaenpixel\r\n2015-08-12 16:33:56 UTC: Before persisting metadata 'twitter_alfabet_alphabet_abcxyz_google' data_import_id: 41c250a6-3d4a-49d6-a963-8130e144560b\r\n2015-08-12 16:39:34 UTC: Exception: PG::Error: ERROR:  canceling statement due to statement timeout\r\nCONTEXT:  SQL statement \"UPDATE twitter_alfabet_alphabet_abcxyz_google SET the_geom_webmercator = cartodb.CDB_TransformToWebmercator(the_geom) \"\r\nPL/pgSQL function _cdb_populate_the_g\r\n```\r\n\r\nThe stacktrace beautified:\r\n```\r\napp/connectors/importer.rb:71:in `rescue in register'\r\napp/connectors/importer.rb:57:in `register'\r\napp/connectors/importer.rb:49:in `block in run'\r\napp/connectors/importer.rb:48:in `each'\r\napp/connectors/importer.rb:48:in `run'\r\napp/models/data_import.rb:617:in `new_importer'\r\napp/models/data_import.rb:350:in `dispatch'\r\napp/models/data_import.rb:161:in `run_import!'\r\nlib/resque/importer_jobs.rb:9:in `block in perform'\r\nlib/resque/base_job.rb:21:in `call'\r\nlib/resque/base_job.rb:21:in `run_action'\r\nlib/resque/importer_jobs.rb:9:in `perform'\r\n```\r\n\r\nThe user `piensaenpixel` had the \"Timeout for user queries\" set to `300000` which should be in ms. That roughly corresponds to 5 min before crashing with db statement timeout error."}}