[Tile-serving] [openstreetmap/osm2pgsql] Long import of Europe data file (#676)

[Marcos Dione]

On Tue, Jan 31, 2017 at 02:31:04PM -0800, Koles500 wrote:

> It looks like the process has stopped, because it is using 0% of
> processor (and ~3,3 GB RAM).

    check the I/O, indexing does not take much CPU but the IO you can
give it. As I said previously, CPU and RAM are not the only resources
this tool uses. at least is not using network...

>  Could you please say something more about
> these messages : ?

> Reading in file: C:\OSM\Data\europe-latest.osm.pbf
> Using PBF parser.
> Processing: Node(1827652k 131.7k/s) Way(223763k 0.78k/s) Relation(3148140 15.84/s)
> Standard exception processing relation id=6540291: TopologyException: side location conflict at -85245.029999999999 6666
> 499.7699999996
> Processing: Node(1827652k 131.7k/s) Way(223763k 0.78k/s) Relation(3254340 15.98/s)
> Standard exception processing relation id=6752256: TopologyException: side location conflict at 538047.93000000005 56717
> 07.1900000004
> Processing: Node(1827652k 131.7k/s) Way(223763k 0.78k/s) Relation(3316870 16.07/s)  parse time: 507324s

    These exceptions we already talked about, I have no idea, sorry.

> Committing transaction for osm_point
> WARNING:  there is no transaction in progress
> Committing transaction for osm_line
> WARNING:  there is no transaction in progress
> Committing transaction for osm_polygon
> WARNING:  there is no transaction in progress
> Committing transaction for osm_roads
> WARNING:  there is no transaction in progress
> Committing transaction for osm_point
> WARNING:  there is no transaction in progress
> Committing transaction for osm_line
> WARNING:  there is no transaction in progress
> Committing transaction for osm_polygon
> WARNING:  there is no transaction in progress
> Committing transaction for osm_roads
> WARNING:  there is no transaction in progress
> Committing transaction for osm_point
> WARNING:  there is no transaction in progress
> Committing transaction for osm_line
> WARNING:  there is no transaction in progress
> Committing transaction for osm_polygon
> WARNING:  there is no transaction in progress
> Committing transaction for osm_roads
> WARNING:  there is no transaction in progress
> Committing transaction for osm_point
> WARNING:  there is no transaction in progress
> Committing transaction for osm_line
> WARNING:  there is no transaction in progress
> Committing transaction for osm_polygon
> WARNING:  there is no transaction in progress
> Committing transaction for osm_roads
> WARNING:  there is no transaction in progress
> Committing transaction for osm_point
> WARNING:  there is no transaction in progress
> Committing transaction for osm_line
> WARNING:  there is no transaction in progress
> Committing transaction for osm_polygon
> WARNING:  there is no transaction in progress
> Committing transaction for osm_roads
> WARNING:  there is no transaction in progress
> Committing transaction for osm_point
> WARNING:  there is no transaction in progress
> Committing transaction for osm_line
> WARNING:  there is no transaction in progress
> Committing transaction for osm_polygon
> WARNING:  there is no transaction in progress
> Committing transaction for osm_roads
> WARNING:  there is no transaction in progress
> Committing transaction for osm_point
> WARNING:  there is no transaction in progress
> Committing transaction for osm_line
> WARNING:  there is no transaction in progress
> Committing transaction for osm_polygon
> WARNING:  there is no transaction in progress
> Committing transaction for osm_roads
> WARNING:  there is no transaction in progress
> Committing transaction for osm_point
> WARNING:  there is no transaction in progress
> Committing transaction for osm_line
> WARNING:  there is no transaction in progress
> Committing transaction for osm_polygon
> WARNING:  there is no transaction in progress
> Committing transaction for osm_roads
> WARNING:  there is no transaction in progress

    This is "normal", it just means it did nothing in this step (although
I agree it shouldn't eve try to commit an empty/non existant transaction).

-- 
(Not so) Random fortune:
Terrorism isn't a crime against people or property. It's a crime against
our minds, using the death of innocents and destruction of property to
make us fearful.
	    -- Bruce Schneier