[OSM-talk] planet-090916.osm.bz2 - inconsistent dump?

[Shaun McDonald]

There is more information available on this wiki page:
http://wiki.openstreetmap.org/wiki/Planet.osm/FAQ

Shaun

On 21 Sep 2009, at 20:33, Marcin Cieslak wrote:

> I tried to import planet-090916.osm.bz2 into the postgres database
> using osmosis, using empty schema from:
>
> URL: http://svn.openstreetmap.org/applications/utils/osmosis/trunk/script/contrib/apidb_0.6.sql
> Revision: 17698
>
> The dump process:
>
> time bzip2 -dc $HOME/import/planet-090916.osm.bz2 | \
>        $HOME/osmosis/trunk/bin/osmosis \
>        --read-xml file=-\
>        --write-apidb-0.6 authFile=$HOME/import/planet-authfile.txt
>
> failed after taking 26 hours and 415GB of space with:
>
> org.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to  
> load current way nodes.
> (...)
> Caused by: org.postgresql.util.PSQLException:
> ERROR: insert or update on table "current_way_nodes" violates
> 	foreign key constraint "current_way_nodes_node_id_fkey"
> 	Detail: Key (node_id)=(497587545) is not present in table  
> "current_nodes".
>
> My current_nodes contains now 434807934 rows and current_ways 12050.
> The highest numbered node is 497541099 and way is 1999800.
>
> Is this inconsistency of the planet.osm file or am I doing something  
> wrong?
> Is there any way to recover from this or should I restart the whole  
> process from
> scratch?
>
> Which dump would you recommend?
>
> -- 
>              << Marcin Cieslak // saper at saper.info >>
>
>
> _______________________________________________
> talk mailing list
> talk at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/talk