This is a static archive of our old OpenStreetMap Help Site. Please post any new questions and answers at community.osm.org.

Postgis Plugin: ERROR: COALESCE types text and integer cannot be matched

0

Hello every body,

I am installing a OSM tile server under Strech and I am in trouble : when I run service renderd status I have :

● renderd.service - LSB: Mapnik rendering daemon

Loaded: loaded (/etc/init.d/renderd; generated; vendor preset: enabled)

Active: active (running) since Thu 2018-11-22 15:21:30 +11; 3s ago

 Docs: man:systemd-sysv-generator(8)

Process: 20598 ExecStop=/etc/init.d/renderd stop (code=exited, status=0/SUCCESS)

Process: 20704 ExecStart=/etc/init.d/renderd start (code=exited, status=0/SUCCESS)

Tasks: 4 (limit: 4915)

CGroup: /system.slice/renderd.service

       └─20711 /usr/local/bin/renderd -c /usr/local/etc/renderd.conf

nov. 22 15:21:30 carto renderd[20710]: DEBUG: Loading font: /usr/share/fonts/truetype/noto/NotoSansMyanmarUI-Regular.ttf

nov. 22 15:21:30 carto renderd[20710]: DEBUG: Loading font: /usr/share/fonts/truetype/noto/NotoSerifLao-Bold.ttf

nov. 22 15:21:30 carto renderd[20710]: DEBUG: Loading font: /usr/share/fonts/truetype/noto/NotoSansMalayalamUI-Regular.ttf

nov. 22 15:21:30 carto renderd[20704]: Starting Mapnik rendering daemon: renderd.

nov. 22 15:21:30 carto systemd[1]: Started LSB: Mapnik rendering daemon.

nov. 22 15:21:30 carto renderd[20711]: Starting stats thread

nov. 22 15:21:30 carto renderd[20711]: Loading parameterization function for

nov. 22 15:21:30 carto renderd[20711]: Loading parameterization function for

nov. 22 15:21:31 carto renderd[20711]: An error occurred while loading the map layer 'default': Postgis Plugin: ERREUR: les COALESCE types text et integer ne peuvent pas correspondre

                                   LINE 18:   ORDER BY COALESCE(layer,0), way_area DESC
                                                                      ^
                                   in executeQuery Full sql was: 'SELECT * FROM (SELECT

                                       way,

                                       "natural",

                                       waterway,

                                       landuse,

                                       name,

                                       way_area/NULLIF(0::real*0::real,0) AS way_pixels,

To import the data I have tried :

osm2pgsql -d osm --hstore --slim --cache 1000 --number-processes 2 new-caledonia-latest.osm.pbf

and

osm2pgsql -d osm --hstore --slim --cache 1000 --number-processes 2 -S /home/data/osm/styles/openstreetmap-carto/openstreetmap-carto.style --tag-transform-script /home/data/osm/styles/openstreetmap-carto/openstreetmap-carto.lua /home/data/osm/dumps/new-caledonia-latest.osm.pbf

But both are not working

Any ideas ? Thank you

asked 22 Nov '18, 05:15

brunogee's gravatar image

brunogee
16223
accept rate: 0%

Source code available on GitHub .