[OSM-dev] Importing planet file with osmosis into PostgreSQL

[Frank Bielig]

Hallo,

I want to setup up an own OSM server as a mirror. Therefore I downloaded 
the planet file (2009/12/02) and used osmosis for import with following 
command line:

    bzcat '/data/osm/all/20091202/planet-latest.osm.bz2' | osmosis
    --read-xml-0.6 file='-' --log-progress --write-apidb host=pg
    database=xxx user=xxx password=xxx dbType=postgresql
    validateSchemaVersion=no


Everything worked will except the completion steps. Here are the last lines:

    11.12.2009 21:16:16
    org.openstreetmap.osmosis.core.progress.v0_6.EntityProgressLogger
    process
    INFO: Processing Relation 342896, 950.3044588489491 objects/second.
    11.12.2009 21:16:21
    org.openstreetmap.osmosis.core.progress.v0_6.EntityProgressLogger
    process
    INFO: Processing Relation 347363, 847.8304339132173 objects/second.
    11.12.2009 21:16:24
    org.openstreetmap.osmosis.core.progress.v0_6.EntityProgressLogger
    complete
    INFO: Processing completion steps.


Following exception was printed out:

    SCHWERWIEGEND: Thread for task 1-read-xml-0.6 failed
    org.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to
    load current way nodes.
            at
    org.openstreetmap.osmosis.core.apidb.v0_6.ApidbWriter.complete(ApidbWriter.java:980)
            at
    org.openstreetmap.osmosis.core.progress.v0_6.EntityProgressLogger.complete(EntityProgressLogger.java:61)
            at
    org.openstreetmap.osmosis.core.xml.v0_6.XmlReader.run(XmlReader.java:110)
            at java.lang.Thread.run(Thread.java:619)
    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)=(577470689) is not present in table
    "current_nodes".
            at
    org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
            at
    org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
            at
    org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
            at
    org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
            at
    org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
            at
    org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343)
            at
    org.openstreetmap.osmosis.core.apidb.v0_6.ApidbWriter.complete(ApidbWriter.java:977)
            ... 3 more
    13.12.2009 06:13:56 org.openstreetmap.osmosis.core.Osmosis main
    SCHWERWIEGEND: Execution aborted.
    org.openstreetmap.osmosis.core.OsmosisRuntimeException: One or more
    tasks failed.
            at
    org.openstreetmap.osmosis.core.pipeline.common.Pipeline.waitForCompletion(Pipeline.java:146)
            at org.openstreetmap.osmosis.core.Osmosis.run(Osmosis.java:85)
            at org.openstreetmap.osmosis.core.Osmosis.main(Osmosis.java:30)

Where does the inconsistency come from? How can I fix the problem?

Thank for help
Frank


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20091213/a3e889d2/attachment.html>