{"action":"created","issue":{"url":"https://api.github.com/repos/CartoDB/Windshaft-cartodb/issues/571","repository_url":"https://api.github.com/repos/CartoDB/Windshaft-cartodb","labels_url":"https://api.github.com/repos/CartoDB/Windshaft-cartodb/issues/571/labels{/name}","comments_url":"https://api.github.com/repos/CartoDB/Windshaft-cartodb/issues/571/comments","events_url":"https://api.github.com/repos/CartoDB/Windshaft-cartodb/issues/571/events","html_url":"https://github.com/CartoDB/Windshaft-cartodb/issues/571","id":176604925,"number":571,"title":"Better error messages","user":{"login":"alonsogarciapablo","id":390398,"avatar_url":"https://avatars.githubusercontent.com/u/390398?v=3","gravatar_id":"","url":"https://api.github.com/users/alonsogarciapablo","html_url":"https://github.com/alonsogarciapablo","followers_url":"https://api.github.com/users/alonsogarciapablo/followers","following_url":"https://api.github.com/users/alonsogarciapablo/following{/other_user}","gists_url":"https://api.github.com/users/alonsogarciapablo/gists{/gist_id}","starred_url":"https://api.github.com/users/alonsogarciapablo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/alonsogarciapablo/subscriptions","organizations_url":"https://api.github.com/users/alonsogarciapablo/orgs","repos_url":"https://api.github.com/users/alonsogarciapablo/repos","events_url":"https://api.github.com/users/alonsogarciapablo/events{/privacy}","received_events_url":"https://api.github.com/users/alonsogarciapablo/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-09-13T10:28:43Z","updated_at":"2016-09-13T12:51:02Z","closed_at":null,"body":"Some unknown errors are including a not very readable error message (coming from mapnik?). Example:\r\n\r\n```\r\n{\r\n  \"errors\": [\r\n    \"Postgis Plugin: ERROR:  column \\\"the_geom_webmercator\\\" does not exist\\nLINE 1: ...ECT ST_AsTWKB(ST_Simplify(ST_RemoveRepeatedPoints(\\\"the_geom_...\\n                                                             ^\\n\\nin executeQuery Full sql was: 'SELECT ST_AsTWKB(ST_Simplify(ST_RemoveRepeatedPoints(\\\"the_geom_webmercator\\\",1e-05),1e-05,true),5) AS geom FROM (SELECT nomdis FROM barrios) as cdbq WHERE \\\"the_geom_webmercator\\\" && ST_MakeEnvelope(-20037508.3,20037508.25881302,-20037508.25881302,20037508.3,3857)'\\n\"\r\n  ],\r\n  \"errors_with_context\": [\r\n    {\r\n      \"type\": \"unknown\",\r\n      \"message\": \"Postgis Plugin: ERROR:  column \\\"the_geom_webmercator\\\" does not exist\\nLINE 1: ...ECT ST_AsTWKB(ST_Simplify(ST_RemoveRepeatedPoints(\\\"the_geom_...\\n                                                             ^\\n\\nin executeQuery Full sql was: 'SELECT ST_AsTWKB(ST_Simplify(ST_RemoveRepeatedPoints(\\\"the_geom_webmercator\\\",1e-05),1e-05,true),5) AS geom FROM (SELECT nomdis FROM barrios) as cdbq WHERE \\\"the_geom_webmercator\\\" && ST_MakeEnvelope(-20037508.3,20037508.25881302,-20037508.25881302,20037508.3,3857)'\\n\"\r\n    }\r\n  ]\r\n}\r\n```\r\n\r\nInstead of \"spitting out\" this whole thing:\r\n\r\n```\r\n\"Postgis Plugin: ERROR:  column \\\"the_geom_webmercator\\\" does not exist\\nLINE 1: ...ECT ST_AsTWKB(ST_Simplify(ST_RemoveRepeatedPoints(\\\"the_geom_...\\n                                                             ^\\n\\nin executeQuery Full sql was: 'SELECT ST_AsTWKB(ST_Simplify(ST_RemoveRepeatedPoints(\\\"the_geom_webmercator\\\",1e-05),1e-05,true),5) AS geom FROM (SELECT nomdis FROM barrios) as cdbq WHERE \\\"the_geom_webmercator\\\" && ST_MakeEnvelope(-20037508.3,20037508.25881302,-20037508.25881302,20037508.3,3857)'\\n\"\r\n```\r\n\r\nWe could split that message by \"\\n\" and only return the first \"line\" of the error, which is a bit more readable:\r\n\r\n```\r\nPostgis Plugin: ERROR:  column \\\"the_geom_webmercator\\\" does not exist\r\n```\r\n\r\ncc: @rochoa "},"comment":{"url":"https://api.github.com/repos/CartoDB/Windshaft-cartodb/issues/comments/246670882","html_url":"https://github.com/CartoDB/Windshaft-cartodb/issues/571#issuecomment-246670882","issue_url":"https://api.github.com/repos/CartoDB/Windshaft-cartodb/issues/571","id":246670882,"user":{"login":"alonsogarciapablo","id":390398,"avatar_url":"https://avatars.githubusercontent.com/u/390398?v=3","gravatar_id":"","url":"https://api.github.com/users/alonsogarciapablo","html_url":"https://github.com/alonsogarciapablo","followers_url":"https://api.github.com/users/alonsogarciapablo/followers","following_url":"https://api.github.com/users/alonsogarciapablo/following{/other_user}","gists_url":"https://api.github.com/users/alonsogarciapablo/gists{/gist_id}","starred_url":"https://api.github.com/users/alonsogarciapablo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/alonsogarciapablo/subscriptions","organizations_url":"https://api.github.com/users/alonsogarciapablo/orgs","repos_url":"https://api.github.com/users/alonsogarciapablo/repos","events_url":"https://api.github.com/users/alonsogarciapablo/events{/privacy}","received_events_url":"https://api.github.com/users/alonsogarciapablo/received_events","type":"User","site_admin":false},"created_at":"2016-09-13T12:51:02Z","updated_at":"2016-09-13T12:51:02Z","body":"BTW, it'd be even better if the error that I used as an example here could be categorised as a `layer` type error..."}}
{"actor":{"display_login":"alonsogarciapablo"}}