{"name":"service-template-node","hostname":"kartotherian1","pid":11347,"level":50,"message":"500: internal_error","stack":"Error: Postgis Plugin: ERROR: Operation on two geometries with different SRIDs in executeQuery Full sql was: 'SELECT ST_AsBinary(\"way\") AS geom,\"osm_id\" FROM ( SELECT osm_id, way FROM planet_osm_polygon WHERE ( \"natural\" IN ('water', 'bay') OR waterway IS NOT NULL OR landuse = 'reservoir' OR landuse = 'pond' ) AND ( mb_z(68247.3) >= 14 OR way_area >= 5000000000 / 2.3^mb_z(68247.3) ) AND way && 'BOX3D(523287.8956403165 5743019.683178433,528485.6135637086 5748217.401101825)'::box3d UNION ALL SELECT 0 AS osm_id, way FROM water_polygons WHERE way && 'BOX3D(523287.8956403165 5743019.683178433,528485.6135637086 5748217.401101825)'::box3d ) water' at Error (native)","status":500,"type":"internal_error","detail":"Postgis Plugin: ERROR: Operation on two geometries with different SRIDs in executeQuery Full sql was: 'SELECT ST_AsBinary(\"way\") AS geom,\"osm_id\" FROM ( SELECT osm_id, way FROM planet_osm_polygon WHERE ( \"natural\" IN ('water', 'bay') OR waterway IS NOT NULL OR landuse = 'reservoir' OR landuse = 'pond' ) AND ( mb_z(68247.3) >= 14 OR way_area >= 5000000000 / 2.3^mb_z(68247.3) ) AND way && 'BOX3D(523287.8956403165 5743019.683178433,528485.6135637086 5748217.401101825)'::box3d UNION ALL SELECT 0 AS osm_id, way FROM water_polygons WHERE way && 'BOX3D(523287.8956403165 5743019.683178433,528485.6135637086 5748217.401101825)'::box3d ) water' ","levelPath":"error/500","request_id":"01e87e8f1cc5485c9b1b8aef84d71623","msg":"","time":"2015-06-02T20:31:24.821Z","v":0}
Description
Event Timeline
This is because labsdb1004 has Postgres 9.1 and PostGIS 1.5 which are not compatible with the current Mapbox stack. So either you are not able to import coastlines because latest shp2pgsql uses a SRID not supported by PostGIS 1.5 or, if you've imported with an older shp2pgsql you get this error. I tried using spatial_ref_sys from PostGIS 2.1 and it didn't help, so my only idea left is that newer versions are needed. Whatever comes with Debian Jessie works for us in VMs so an OS update on this machine should do it. Not sure if a DB reimport would be needed afterwards though.
Have you seen http://gis.stackexchange.com/questions/22150/projecting-openstreetmap-data-in-postgis -- it mentions that you can eassily transform stuff with ST_Transform, e.g.
UPDATE osm.roads SET geom_new = ST_Transform(the_geom), 4269);