<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.apple-tab-span
{mso-style-name:apple-tab-span;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-GB link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>But does current_way_nodes have a node_id column? It looks to me
like the foreign key constraint is making sure that the nodes in the
current_way_nodes table actually exist in current_nodes <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Ed<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div style='border:none;border-left:solid blue 1.5pt;padding:0cm 0cm 0cm 4.0pt'>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'> dev-bounces@openstreetmap.org
[mailto:dev-bounces@openstreetmap.org] <b>On Behalf Of </b>Jeffrey Warren<br>
<b>Sent:</b> 05 June 2009 19:59<br>
<b>To:</b> Joachim Zobel<br>
<b>Cc:</b> dev Openstreetmap; Josh Levinger<br>
<b>Subject:</b> Re: [OSM-dev] Osmosis error, duplicate<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<div>
<p class=MsoNormal>Thanks, I was tracing the original foreign key constraint
error (reproduced in full below) and this line caught my eye:<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<div>
<p class=MsoNormal> Detail: Key (node_id)=(395051992) is not present
in table "current_nodes".<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal>current_nodes has no node_id column!<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<div>
<p class=MsoNormal>The constraint is created in the latest pgsql schema, here:<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal>(apidb06-pgsql-latest.sql:2132)<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>--<o:p></o:p></p>
</div>
<div>
<div>
<p class=MsoNormal>-- TOC entry 2018 (class 2606 OID 35690)<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>-- Dependencies: 1579 1961 1589<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>-- Name: current_way_nodes_node_id_fkey; Type: FK
CONSTRAINT; Schema: public; Owner: osm<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>--<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal>ALTER TABLE ONLY current_way_nodes<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> ADD CONSTRAINT
current_way_nodes_node_id_fkey FOREIGN KEY (node_id) REFERENCES
current_nodes(id);<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</div>
<div>
<p class=MsoNormal>I changed line 2139 to:<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<div>
<p class=MsoNormal> ADD CONSTRAINT
current_way_nodes_node_id_fkey FOREIGN KEY (id) REFERENCES current_nodes(id);<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal>I'm going to run it now to see what happens.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal>Best,<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>Jeff<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</div>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal>###############################################<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<div>
<p class=MsoNormal>motel:bin eco$ cd ../motel:osmosis-0.31 eco$ bin/osmosis
--read-xml-0.6 file="/Volumes/Planet/planet.osm" --write-apidb-0.6
populateCurrentTables=yes host="localhost"
database="osm-planet" user="eco"
password="poopies" validateSchemaVersion=no<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>May 26, 2009 8:59:51 PM
org.openstreetmap.osmosis.core.Osmosis run<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>INFO: Osmosis Version 0.31<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>May 26, 2009 8:59:51 PM org.openstreetmap.osmosis.core.Osmosis
run<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>INFO: Preparing pipeline.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>May 26, 2009 8:59:51 PM
org.openstreetmap.osmosis.core.Osmosis run<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>INFO: Launching pipeline execution.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>May 26, 2009 8:59:51 PM
org.openstreetmap.osmosis.core.Osmosis run<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>INFO: Pipeline executing, waiting for completion.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>Jun 1, 2009 6:50:20 PM
org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager
waitForCompletion<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>SEVERE: Thread for task 1-read-xml-0.6 failed<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>org.openstreetmap.osmosis.core.OsmosisRuntimeException:
Unable to load current way nodes.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span class=apple-tab-span> </span>at org.openstreetmap.osmosis.core.apidb.v0_6.ApidbWriter.complete(ApidbWriter.java:980)<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span class=apple-tab-span> </span>at
org.openstreetmap.osmosis.core.xml.v0_6.XmlReader.run(XmlReader.java:110)<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span class=apple-tab-span> </span>at
java.lang.Thread.run(Thread.java:637)<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>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"<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> Detail: Key (node_id)=(395051992) is not present
in table "current_nodes".<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span class=apple-tab-span> </span>at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span class=apple-tab-span> </span>at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span class=apple-tab-span> </span>at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span class=apple-tab-span> </span>at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span class=apple-tab-span> </span>at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span class=apple-tab-span> </span>at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343)<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span class=apple-tab-span> </span>at
org.openstreetmap.osmosis.core.apidb.v0_6.ApidbWriter.complete(ApidbWriter.java:977)<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span class=apple-tab-span> </span>... 2 more<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>Jun 1, 2009 6:50:20 PM
org.openstreetmap.osmosis.core.Osmosis main<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>SEVERE: Execution aborted.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>org.openstreetmap.osmosis.core.OsmosisRuntimeException: One
or more tasks failed.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span class=apple-tab-span> </span>at
org.openstreetmap.osmosis.core.pipeline.common.Pipeline.waitForCompletion(Pipeline.java:146)<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span class=apple-tab-span> </span>at
org.openstreetmap.osmosis.core.Osmosis.run(Osmosis.java:85)<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span class=apple-tab-span> </span>at
org.openstreetmap.osmosis.core.Osmosis.main(Osmosis.java:30)<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><o:p> </o:p></p>
<div>
<p class=MsoNormal>On Fri, Jun 5, 2009 at 1:29 PM, Joachim Zobel <<a
href="mailto:jz-2008@heute-morgen.de">jz-2008@heute-morgen.de</a>> wrote:<o:p></o:p></p>
<p class=MsoNormal>Am Freitag, den 05.06.2009, 12:40 -0400 schrieb Jeffrey
Warren:<o:p></o:p></p>
<div>
<p class=MsoNormal style='margin-bottom:12.0pt'>> and it's been running the
following query for about 24 hours:<br>
><br>
> SELECT Count(*) AS changesetCount FROM changesets WHERE id=$1<o:p></o:p></p>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'>Take a look on Brets
pgsql-latest.sql script (after the COPYs) and add<br>
the index on id:<br>
<br>
ALTER TABLE ONLY changesets<br>
ADD CONSTRAINT pk_changesets PRIMARY KEY (id);<br>
<br>
Sincerely,<br>
<span style='color:#888888'>Joachim<br>
<br>
<br>
</span><o:p></o:p></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</div>
</body>
</html>