<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=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@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;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
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;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
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-US link=blue vlink=purple>
<div class=Section1>
<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'><o:p> </o:p></span></p>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
talk-us-bounces@openstreetmap.org [mailto:talk-us-bounces@openstreetmap.org] <b>On
Behalf Of </b>Karl Newman<br>
<b>Sent:</b> Thursday, November 06, 2008 2:10 PM<br>
<b>To:</b> Milenko<br>
<b>Cc:</b> talk-us@openstreetmap.org<br>
<b>Subject:</b> Re: [Talk-us] Weird Osmosis/ROMA/pgsql issue<o:p></o:p></span></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>On Thu, Nov 6, 2008 at 10:42 AM, Milenko <<a
href="mailto:milenko@king-nerd.com">milenko@king-nerd.com</a>> wrote:<o:p></o:p></p>
<div>
<blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;
margin-left:4.8pt;margin-right:0in'>
<div>
<div>
<p><span style='font-size:11.0pt;color:#1F497D'>I thought able that, but this
is a freshly loaded machine and I've only ever downloaded this one copy of
osmosis. Just for fun, I just did a file search for osmosis-0.29 and
found only the one directory that I've been working in.</span><o:p></o:p></p>
<p><span style='font-size:11.0pt;color:#1F497D'> </span><o:p></o:p></p>
<p><span style='font-size:11.0pt;color:#1F497D'>-Jeremy</span><o:p></o:p></p>
<p><span style='font-size:11.0pt;color:#1F497D'> </span><o:p></o:p></p>
<p><span style='font-size:11.0pt;color:#1F497D'> </span><o:p></o:p></p>
<div style='border:none;border-top:solid windowtext 1.0pt;padding:3.0pt 0in 0in 0in;
border-color:-moz-use-text-color -moz-use-text-color'>
<p><b><span style='font-size:10.0pt'>From:</span></b><span style='font-size:
10.0pt'> <a href="mailto:talk-us-bounces@openstreetmap.org" target="_blank">talk-us-bounces@openstreetmap.org</a>
[mailto:<a href="mailto:talk-us-bounces@openstreetmap.org" target="_blank">talk-us-bounces@openstreetmap.org</a>]
<b>On Behalf Of </b>Karl Newman<br>
<b>Sent:</b> Thursday, November 06, 2008 1:16 PM<br>
<b>To:</b> Milenko<br>
<b>Cc:</b> <a href="mailto:talk-us@openstreetmap.org" target="_blank">talk-us@openstreetmap.org</a><br>
<b>Subject:</b> Re: [Talk-us] Weird Osmosis/ROMA/pgsql issue</span><o:p></o:p></p>
</div>
<div>
<div>
<p> <o:p></o:p></p>
<p>On Thu, Nov 6, 2008 at 10:15 AM, Milenko <<a
href="mailto:milenko@king-nerd.com" target="_blank">milenko@king-nerd.com</a>>
wrote:<o:p></o:p></p>
<div>
<blockquote style='border:none;border-left:solid windowtext 1.0pt;padding:0in 0in 0in 6.0pt;
margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt;
border-color:-moz-use-text-color -moz-use-text-color -moz-use-text-color rgb(204, 204, 204)'>
<div>
<div>
<p>Hey all,<o:p></o:p></p>
<p> <o:p></o:p></p>
<pre> I've been trying to get a local ROMA server working and I've run into an issue with getting osmosis working. I've patched osmosis as per the instructions on the wiki (<a
href="http://wiki.openstreetmap.org/index.php/Read_Only_Map_API" target="_blank">http://wiki.openstreetmap.org/index.php/Read_Only_Map_API</a>), but when I import data into the pgsql database, I'm still seeing statements in the db log files that reference commands taken out by the patch. One specific command is "UPDATE ways SET bbox = (SELECT Envelope(Collect(geom)) FROM nodes JOIN way_nodes ON way_nodes.node_id = <a
href="http://nodes.id" target="_blank">nodes.id</a> WHERE way_nodes.way_id = <a
href="http://ways.id" target="_blank">ways.id</a>)", seen in PostgreSqlWriter.java. I've verified that it's removed from that file but it still runs when I try to import data. This command takes days when trying to import the full planet.<o:p></o:p></pre><pre> <o:p></o:p></pre><pre> Anyone have any idea how this is happening? I've searched every file in the osmosis directory and can't find that command, and yet it still somehow gets run during the import.<o:p></o:p></pre><pre> <o:p></o:p></pre><pre> <o:p></o:p></pre><pre>Any help would be greatly appreciated.<o:p></o:p></pre><pre> <o:p></o:p></pre><pre>-Jeremy<o:p></o:p></pre></div>
</div>
</blockquote>
</div>
<p>Are you sure you're actually executing your patched version and not an
unpatched version that's somewhere on your path? <o:p></o:p></p>
</div>
</div>
</div>
</div>
</blockquote>
</div>
<p class=MsoNormal>I don't know anything about the patch, but did you look in
the script directory, at the pgsql_simple_load_0.5.sql file? That command is in
there (spread over multiple lines, which is why a grep may not have found it).<br>
<br>
Karl<o:p></o:p></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'>Yes, I found it there also. I believe that file is used for
loading txt files from a db dump and shouldn’t be called during normal osmosis
usage. To be safe, I removed the statements from that file also and they still
are run when I import data.<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'>-Jeremy<o:p></o:p></span></p>
</div>
</body>
</html>