[Tile-serving] [osm2pgsql] spatial indexes haven't been built (#526)
TobWen
notifications at github.com
Fri Jan 8 18:09:00 UTC 2016
Sure:
```
1452217001 2016-01-08 01:36:41 osm2pgsql SVN version 0.89.0-dev (64 bit id space)
1452217001 2016-01-08 01:36:41
1452217001 2016-01-08 01:36:41 Using built-in tag processing pipeline
1452217001 2016-01-08 01:36:41 Using projection SRS 4326 (Latlong)
1452217001 2016-01-08 01:36:41 Setting up table: planet_osm_point
1452217002 2016-01-08 01:36:42 Setting up table: planet_osm_line
1452217002 2016-01-08 01:36:42 Setting up table: planet_osm_polygon
1452217002 2016-01-08 01:36:42 Setting up table: planet_osm_roads
1452217002 2016-01-08 01:36:42 Allocating memory for dense node cache
1452217002 2016-01-08 01:36:42 Allocating dense node cache in one big chunk
1452217002 2016-01-08 01:36:42 Allocating memory for sparse node cache
1452217002 2016-01-08 01:36:42 Sharing dense sparse
1452217002 2016-01-08 01:36:42 Node-cache: cache=14000MB, maxblocks=224000*65536, allocation method=11
1452217002 2016-01-08 01:36:42 Mid: loading persistent node cache from /mnt/ssd02/flatnodes
1452217002 2016-01-08 01:36:42 Allocated space for persistent node cache file
1452217002 2016-01-08 01:36:42 Maximum node in persistent node cache: 0
1452217002 2016-01-08 01:36:42 Mid: pgsql, scale=10000000 cache=14000
1452217002 2016-01-08 01:36:42 Setting up table: planet_osm_nodes
1452217002 2016-01-08 01:36:42 Setting up table: planet_osm_ways
1452217002 2016-01-08 01:36:42 Setting up table: planet_osm_rels
1452217002 2016-01-08 01:36:42
1452217002 2016-01-08 01:36:42 Reading in file: europe_2016-01-07.o5m
1452217002 2016-01-08 01:36:42 Using O5M parser.
1452235852 2016-01-08 06:50:52 Standard exception processing relation id=5734740: TopologyException: side location conflict at 6.1431180000000003 49.095793
1452235920 2016-01-08 06:52:00 Node stats: total(617893403), max(3908589760) in 2485s
1452235920 2016-01-08 06:52:00 Way stats: total(87427546), max(387594329) in 940s
1452235920 2016-01-08 06:52:00 Relation stats: total(1108631), max(5768382) in 15493s
1452235922 2016-01-08 06:52:02 Maximum node in persistent node cache: 3909091327
1452235923 2016-01-08 06:52:03 Committing transaction for planet_osm_point
1452235923 2016-01-08 06:52:03 Committing transaction for planet_osm_line
1452235923 2016-01-08 06:52:03 Committing transaction for planet_osm_polygon
1452235923 2016-01-08 06:52:03 Committing transaction for planet_osm_roads
1452235923 2016-01-08 06:52:03 Mid: loading persistent node cache from /mnt/ssd02/flatnodes
1452235923 2016-01-08 06:52:03 Maximum node in persistent node cache: 3909091327
1452235923 2016-01-08 06:52:03 Setting up table: planet_osm_nodes
1452235923 2016-01-08 06:52:03 Setting up table: planet_osm_ways
1452235923 2016-01-08 06:52:03 Setting up table: planet_osm_rels
1452235923 2016-01-08 06:52:03 Using built-in tag processing pipeline
1452235924 2016-01-08 06:52:04 Mid: loading persistent node cache from /mnt/ssd02/flatnodes
1452235924 2016-01-08 06:52:04 Maximum node in persistent node cache: 3909091327
1452235924 2016-01-08 06:52:04 Setting up table: planet_osm_nodes
1452235924 2016-01-08 06:52:04 Setting up table: planet_osm_ways
1452235924 2016-01-08 06:52:04 Setting up table: planet_osm_rels
1452235924 2016-01-08 06:52:04 Using built-in tag processing pipeline
1452235924 2016-01-08 06:52:04 Mid: loading persistent node cache from /mnt/ssd02/flatnodes
1452235924 2016-01-08 06:52:04 Maximum node in persistent node cache: 3909091327
1452235924 2016-01-08 06:52:04 Setting up table: planet_osm_nodes
1452235924 2016-01-08 06:52:04 Setting up table: planet_osm_ways
1452235924 2016-01-08 06:52:04 Setting up table: planet_osm_rels
1452235924 2016-01-08 06:52:04 Using built-in tag processing pipeline
1452235924 2016-01-08 06:52:04 Mid: loading persistent node cache from /mnt/ssd02/flatnodes
1452235924 2016-01-08 06:52:04 Maximum node in persistent node cache: 3909091327
1452235924 2016-01-08 06:52:04 Setting up table: planet_osm_nodes
1452235924 2016-01-08 06:52:04 Setting up table: planet_osm_ways
1452235924 2016-01-08 06:52:04 Setting up table: planet_osm_rels
1452235924 2016-01-08 06:52:04 Using built-in tag processing pipeline
1452235926 2016-01-08 06:52:06
1452235926 2016-01-08 06:52:06 Going over pending ways...
1452235926 2016-01-08 06:52:06 67928778 ways are pending
1452235926 2016-01-08 06:52:06
1452235926 2016-01-08 06:52:06 Using 4 helper-processes
1452242163 2016-01-08 08:36:03
Finished processing 67928778 ways in 6237 sec
1452242163 2016-01-08 08:36:03
1452242163 2016-01-08 08:36:03 67928778 Pending ways took 6237s at a rate of 10891.26/s
1452242163 2016-01-08 08:36:03 Committing transaction for planet_osm_point
1452242163 2016-01-08 08:36:03 Committing transaction for planet_osm_line
1452242163 2016-01-08 08:36:03 Committing transaction for planet_osm_polygon
1452242163 2016-01-08 08:36:03 Committing transaction for planet_osm_roads
1452242163 2016-01-08 08:36:03 Committing transaction for planet_osm_point
1452242163 2016-01-08 08:36:03 Committing transaction for planet_osm_line
1452242163 2016-01-08 08:36:03 Committing transaction for planet_osm_polygon
1452242163 2016-01-08 08:36:03 Committing transaction for planet_osm_roads
1452242163 2016-01-08 08:36:03 Committing transaction for planet_osm_point
1452242163 2016-01-08 08:36:03 Committing transaction for planet_osm_line
1452242163 2016-01-08 08:36:03 Committing transaction for planet_osm_polygon
1452242163 2016-01-08 08:36:03 Committing transaction for planet_osm_roads
1452242163 2016-01-08 08:36:03 Committing transaction for planet_osm_point
1452242163 2016-01-08 08:36:03 Committing transaction for planet_osm_line
1452242163 2016-01-08 08:36:03 Committing transaction for planet_osm_polygon
1452242163 2016-01-08 08:36:03 Committing transaction for planet_osm_roads
1452242163 2016-01-08 08:36:03
1452242163 2016-01-08 08:36:03 Going over pending relations...
1452242163 2016-01-08 08:36:03 0 relations are pending
1452242163 2016-01-08 08:36:03
1452242163 2016-01-08 08:36:03 Using 4 helper-processes
1452242163 2016-01-08 08:36:03
Finished processing 0 relations in 0 sec
1452242163 2016-01-08 08:36:03
1452242163 2016-01-08 08:36:03 Committing transaction for planet_osm_point
1452242163 2016-01-08 08:36:03 WARNUNG: keine Transaktion offen
1452242163 2016-01-08 08:36:03 Committing transaction for planet_osm_line
1452242163 2016-01-08 08:36:03 WARNUNG: keine Transaktion offen
1452242163 2016-01-08 08:36:03 Committing transaction for planet_osm_polygon
1452242163 2016-01-08 08:36:03 WARNUNG: keine Transaktion offen
1452242163 2016-01-08 08:36:03 Committing transaction for planet_osm_roads
1452242163 2016-01-08 08:36:03 WARNUNG: keine Transaktion offen
1452242163 2016-01-08 08:36:03 Committing transaction for planet_osm_point
1452242163 2016-01-08 08:36:03 WARNUNG: keine Transaktion offen
1452242163 2016-01-08 08:36:03 Committing transaction for planet_osm_line
1452242163 2016-01-08 08:36:03 WARNUNG: keine Transaktion offen
1452242163 2016-01-08 08:36:03 Committing transaction for planet_osm_polygon
1452242163 2016-01-08 08:36:03 WARNUNG: keine Transaktion offen
1452242163 2016-01-08 08:36:03 Committing transaction for planet_osm_roads
1452242163 2016-01-08 08:36:03 WARNUNG: keine Transaktion offen
1452242163 2016-01-08 08:36:03 Committing transaction for planet_osm_point
1452242163 2016-01-08 08:36:03 WARNUNG: keine Transaktion offen
1452242163 2016-01-08 08:36:03 Committing transaction for planet_osm_line
1452242163 2016-01-08 08:36:03 WARNUNG: keine Transaktion offen
1452242163 2016-01-08 08:36:03 Committing transaction for planet_osm_polygon
1452242163 2016-01-08 08:36:03 WARNUNG: keine Transaktion offen
1452242163 2016-01-08 08:36:03 Committing transaction for planet_osm_roads
1452242163 2016-01-08 08:36:03 WARNUNG: keine Transaktion offen
1452242163 2016-01-08 08:36:03 Committing transaction for planet_osm_point
1452242163 2016-01-08 08:36:03 WARNUNG: keine Transaktion offen
1452242163 2016-01-08 08:36:03 Committing transaction for planet_osm_line
1452242163 2016-01-08 08:36:03 WARNUNG: keine Transaktion offen
1452242163 2016-01-08 08:36:03 Committing transaction for planet_osm_polygon
1452242163 2016-01-08 08:36:03 WARNUNG: keine Transaktion offen
1452242163 2016-01-08 08:36:03 Committing transaction for planet_osm_roads
1452242163 2016-01-08 08:36:03 WARNUNG: keine Transaktion offen
1452242163 2016-01-08 08:36:03 Completed planet_osm_line
1452242163 2016-01-08 08:36:03 Completed planet_osm_point
1452242163 2016-01-08 08:36:03 Completed planet_osm_polygon
1452242163 2016-01-08 08:36:03 Completed planet_osm_roads
1452242163 2016-01-08 08:36:03 Stopping table: planet_osm_nodes
1452242163 2016-01-08 08:36:03 Stopped table: planet_osm_nodes in 0s
1452242163 2016-01-08 08:36:03 Stopping table: planet_osm_ways
1452242163 2016-01-08 08:36:03 Building index on table: planet_osm_ways
1452247589 2016-01-08 10:06:29 Stopped table: planet_osm_ways in 5426s
1452247589 2016-01-08 10:06:29 Stopping table: planet_osm_rels
1452247589 2016-01-08 10:06:29 Building index on table: planet_osm_rels
1452247658 2016-01-08 10:07:38 Stopped table: planet_osm_rels in 69s
1452247659 2016-01-08 10:07:39 Maximum node in persistent node cache: 3909091327
1452247660 2016-01-08 10:07:40 Maximum node in persistent node cache: 3909091327
1452247661 2016-01-08 10:07:41 Maximum node in persistent node cache: 3909091327
1452247662 2016-01-08 10:07:42 Maximum node in persistent node cache: 3909091327
1452247662 2016-01-08 10:07:42 node cache: stored: 617893403(100.00%), storage efficiency: 53.08% (dense blocks: 28103, sparse nodes: 466937819), hit rate: 99.92%
1452247662 2016-01-08 10:07:42
1452247662 2016-01-08 10:07:42 Osm2pgsql took 30661s overall
```
---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/526#issuecomment-170077047
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20160108/02837f65/attachment-0001.html>
More information about the Tile-serving
mailing list