On Thu, Nov 6, 2008 at 10:42 AM, Milenko <span dir="ltr"><<a href="mailto:milenko@king-nerd.com">milenko@king-nerd.com</a>></span> wrote:<br><div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">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></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">-Jeremy</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<div style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0in 0in;">
<p><b><span style="font-size: 10pt;">From:</span></b><span style="font-size: 10pt;">
<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></p>
</div><div><div></div><div class="Wj3C7c">
<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:</p>
<div>
<blockquote style="border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color rgb(204, 204, 204); border-width: medium medium medium 1pt; padding: 0in 0in 0in 6pt; margin-left: 4.8pt; margin-right: 0in;">
<div>
<div>
<p>Hey all,</p>
<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.</pre>
<pre> </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.</pre><pre> </pre>
<pre> </pre><pre>Any help would be greatly appreciated.</pre><pre> </pre><pre>-Jeremy</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? </p>
</div></div></div>
</div>
</blockquote></div>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<br>