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

[Frank Bielig]

Hallo, 

I still want to setup up an own OSM server as a mirror. Therefore I downloaded the planet file (2009/12/23). 
A applied all replicate changesets till 2009/12/28 in hope of a consistend planet file. This new file I tried
to import into PostgreSQL database by calling

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

Unfortunately this try failed again but with different error:

    INFO: Processing completion steps.
    02.01.2010 18:58:41
    org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager
    waitForCompletion
    SCHWERWIEGEND: Thread for task 1-read-xml-0.6 failed
    org.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to
    load current nodes.
    at
    org.openstreetmap.osmosis.core.apidb.v0_6.ApidbWriter.complete(ApidbWriter.java:933)
    at
    org.openstreetmap.osmosis.core.progress.v0_6.EntityProgressLogger.complete(EntityProgressLogger.java02.01.2010
    18:58:41
    org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager
    waitForCompletion
    SCHWERWIEGEND: Thread for task 1-read-xml-0.6 failed
    org.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to
    load current nodes.
    at
    org.openstreetmap.osmosis.core.apidb.v0_6.ApidbWriter.complete(ApidbWriter.java:933)
    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: duplicate key
    value violates unique constraint "current_nodes_pkey1"
    at
    org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
    at
    org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
    at org.postgresql.core02.01.2010 18:58:41
    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)
    Writer.java:930)
    ... 3 more
    02.01.2010 18:58:41 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)

Now I had a problem with unique node ids. Who can give me a short introduction for creating a 1:1 mirror? I have no ideas any more. :(

Thank you in advance!
Frank


-- 
Frank Bielig               Tel:   +49 33398 687848
OneStepAhead AG            Fax:   +49 33398 687849
Research & Development     Mobil: +49 177 3339868
Leuschnerstr. 45           eMail: Frank.Bielig at OneStepAhead.de
D-70176 Stuttgart          Web:   http://www.OneStepAhead.de

Firma:                     OneStepAhead AG
Firmensitz/Amtsgericht:    Stuttgart, HRB 22686
Vorstand/Vorsitzender:     Nihat Kücük
Aufsichtsratvorsitzender:  Prof. Dr. Reinhold von Schwerin

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