NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

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%

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×263
×105

question asked: 22 Nov '18, 05:15

question was seen: 4,572 times

last updated: 22 Nov '18, 05:15

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum