Logs
2019-12-03 00:01:01 GMT [8061]: [3-1] user=postgres,db=gis,app=psql,client=[local] ERROR: Relate Operation called with a LWGEOMCOLLECTION type. This is unsupported. 2019-12-03 00:01:01 GMT [8061]: [4-1] user=postgres,db=gis,app=psql,client=[local] HINT: Change argument 2: 'GEOMETRYCOLLECTION(POINT(2336431.35890444 7641045.27589611),LINESTRING(233584...' 2019-12-03 00:01:01 GMT [8061]: [5-1] user=postgres,db=gis,app=psql,client=[local] CONTEXT: PL/pgSQL function populate_admin() line 29 at IF 2019-12-03 00:01:01 GMT [8061]: [6-1] user=postgres,db=gis,app=psql,client=[local] STATEMENT: SELECT populate_admin();
Investigation
The error happens when performing ST_Intersects at https://github.com/kartotherian/osm-bright.tm2source/blob/master/sql/admin.sql#L37
Environments Observed
- maps.1004.eqiad.wmnet
How to fix it
- Check for LWGEOMCOLLECTION geometry type and extract geometries for individual check
Open questions
- Can we set an alert for populate_admin script? This seems to be happening since Nov 12 after an update on water_polygons table