[Tile-serving] Tiles aren't rendering

[JunkMail]

It's ext4 - The total size is 250GB.

The renderd log looks fine after a service restart. Looking at the pgsql 
log, I see that pretty much all of the queries end with a "could not 
send data to client: Broken pipe". To me, that looks like renderd is 
timing out and killing the connection between itself and pgsql.

On 2019-04-23 4:04 p.m., Chris wrote:
>
>
>
>
>
>
>
>
>
>
>
> Hi Stephen,
>
> if tiles don't render it could be a problem between renderd and the 
> postgres db.
>
> I would advise to restart renderd and look into syslog (grep renderd) 
> before trying to render. If you see sth. like: "map failed to load", 
> the reason could be db or file permissions, db names, missing 
> shapefiles by openstreetmap-carto not applied to the db or even a 
> missing mapnik xml file (or access permissions).
>
> Also check the postgres log.
>
> Also remember that low zooms are really slow in rendering (use 
> render_list for those zoom <7).
>
> What's the size of your db on what kind of filesystem? My last planet 
> import had been more than 650gb on ext4.
>
> Cheers,
>
> Chris
>
>
> Am 23.04.2019 um 20:47 schrieb Stephen D:
>> Hi,
>>
>> My tile server is not rendering tiles. I had it working with 
>> Canada(imported w/o a flat file), but after dropping the database and 
>> re-importing the whole planet(with a flat file) it no longer works.
>>
>> The command I used to import was: osm2pgsql -d gis --create --slim  
>> -G --hstore --tag-transform-script 
>> ~/src/openstreetmap-carto/openstreetmap-carto.lua --flat-nodes 
>> ~/data/flatnodes.bin  -C 6000 --drop --number-processes 8 -S 
>> ~/src/openstreetmap-carto/openstreetmap-carto.style 
>> /home/stephen/planet-latest.osm.pbf
>>
>> When requesting a tile, this shows up in the log file:
>>
>> Apr 23 18:37:15 osm-tilemap renderd[1488]: DEBUG: Connection 0, fd 7 
>> closed, now 0 left
>> Apr 23 18:39:21 osm-tilemap renderd[1488]: DEBUG: Got incoming 
>> connection, fd 7, number 1
>> Apr 23 18:39:21 osm-tilemap renderd[1488]: DEBUG: Got incoming 
>> request with protocol version 2
>> Apr 23 18:39:21 osm-tilemap renderd[1488]: DEBUG: Got command 
>> RenderPrio fd(7) xml(ajt), z(1), x(1), y(1), mime(image/png), options()
>> Apr 23 18:39:51 osm-tilemap renderd[1488]: DEBUG: Connection 0, fd 7 
>> closed, now 0 left
>>
>> After 30 seconds it times out. No tiles appear in the cache 
>> directory, even after several minutes. The CPU reaches 20% per core 
>> for all cores, and disk usage is around 200MB/s read. Both the CPU 
>> and disk are used by the postgresql process.
>>
>> I am using apache2, mod_tile, mapnik, and renderd.
>>
>> Thanks,
>>
>> Stephen
>>
>>
>> _______________________________________________
>> Tile-serving mailing list
>> Tile-serving at openstreetmap.org
>> https://lists.openstreetmap.org/listinfo/tile-serving
>
> _______________________________________________
> Tile-serving mailing list
> Tile-serving at openstreetmap.org
> https://lists.openstreetmap.org/listinfo/tile-serving
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20190423/409e2e9f/attachment-0001.html>