<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
Hallo,<br>
<br>
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:<br>
<br>
<blockquote><tt>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</tt><br>
</blockquote>
<br>
Everything worked will except the completion steps. Here are the last
lines:<br>
<br>
<blockquote><tt>11.12.2009 21:16:16
org.openstreetmap.osmosis.core.progress.v0_6.EntityProgressLogger
process</tt><br>
  <tt>INFO: Processing Relation 342896, 950.3044588489491
objects/second.</tt><br>
  <tt>11.12.2009 21:16:21
org.openstreetmap.osmosis.core.progress.v0_6.EntityProgressLogger
process</tt><br>
  <tt>INFO: Processing Relation 347363, 847.8304339132173
objects/second.</tt><br>
  <tt>11.12.2009 21:16:24
org.openstreetmap.osmosis.core.progress.v0_6.EntityProgressLogger
complete</tt><br>
  <tt>INFO: Processing completion steps.</tt><br>
</blockquote>
<br>
Following exception was printed out:<br>
<br>
<blockquote><tt>SCHWERWIEGEND: Thread for task 1-read-xml-0.6 failed</tt><br>
  <tt>org.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to
load current way nodes.</tt><br>
  <tt>        at
org.openstreetmap.osmosis.core.apidb.v0_6.ApidbWriter.complete(ApidbWriter.java:980)</tt><br>
  <tt>        at
org.openstreetmap.osmosis.core.progress.v0_6.EntityProgressLogger.complete(EntityProgressLogger.java:61)</tt><br>
  <tt>        at
org.openstreetmap.osmosis.core.xml.v0_6.XmlReader.run(XmlReader.java:110)</tt><br>
  <tt>        at java.lang.Thread.run(Thread.java:619)</tt><br>
  <tt>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"</tt><br>
  <tt>  Detail: Key (node_id)=(577470689) is not present in table
"current_nodes".</tt><br>
  <tt>        at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)</tt><br>
  <tt>        at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)</tt><br>
  <tt>        at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)</tt><br>
  <tt>        at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)</tt><br>
  <tt>        at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)</tt><br>
  <tt>        at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343)</tt><br>
  <tt>        at
org.openstreetmap.osmosis.core.apidb.v0_6.ApidbWriter.complete(ApidbWriter.java:977)</tt><br>
  <tt>        ... 3 more</tt><br>
  <tt>13.12.2009 06:13:56 org.openstreetmap.osmosis.core.Osmosis main</tt><br>
  <tt>SCHWERWIEGEND: Execution aborted.</tt><br>
  <tt>org.openstreetmap.osmosis.core.OsmosisRuntimeException: One or
more tasks failed.</tt><br>
  <tt>        at
org.openstreetmap.osmosis.core.pipeline.common.Pipeline.waitForCompletion(Pipeline.java:146)</tt><br>
  <tt>        at
org.openstreetmap.osmosis.core.Osmosis.run(Osmosis.java:85)</tt><br>
  <tt>        at
org.openstreetmap.osmosis.core.Osmosis.main(Osmosis.java:30)</tt><br>
</blockquote>
Where does the inconsistency come from? How can I fix the problem?<br>
<br>
Thank for help<br>
Frank<br>
<br>
<br>
</body>
</html>