[Talk-us] Weird Osmosis/ROMA/pgsql issue

Milenko milenko at king-nerd.com
Thu Nov 6 19:24:58 GMT 2008


 

 

From: talk-us-bounces at openstreetmap.org
[mailto:talk-us-bounces at openstreetmap.org] On Behalf Of Karl Newman
Sent: Thursday, November 06, 2008 2:10 PM
To: Milenko
Cc: talk-us at openstreetmap.org
Subject: Re: [Talk-us] Weird Osmosis/ROMA/pgsql issue

 

On Thu, Nov 6, 2008 at 10:42 AM, Milenko <milenko at king-nerd.com> wrote:

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.

 

-Jeremy

 

 

From: talk-us-bounces at openstreetmap.org
[mailto:talk-us-bounces at openstreetmap.org] On Behalf Of Karl Newman
Sent: Thursday, November 06, 2008 1:16 PM
To: Milenko
Cc: talk-us at openstreetmap.org
Subject: Re: [Talk-us] Weird Osmosis/ROMA/pgsql issue

 

On Thu, Nov 6, 2008 at 10:15 AM, Milenko <milenko at king-nerd.com> wrote:

Hey all,

 

        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
(http://wiki.openstreetmap.org/index.php/Read_Only_Map_API), 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 = nodes.id WHERE way_nodes.way_id
= ways.id)", 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.
 
        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.
 
 
Any help would be greatly appreciated.
 
-Jeremy

Are you sure you're actually executing your patched version and not an
unpatched version that's somewhere on your path? 

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).

Karl

 

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.

 

-Jeremy

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk-us/attachments/20081106/78ed7408/attachment.html>


More information about the Talk-us mailing list