Re: [OSM-dev] Osmosis error - node not present in table "current_nodes" - no bbox

2013-01-04 Thread Jeff Meyer
Ok... still trying to solve this one. My primary machine is visiting the "Genius" Saloon, so I'm a little dead in the water right now. Couple of quick updates: - The two.pbf file from above failed its import, as well... : / -- The diff.osc of the two files yielded about 8300 objects, ~8000 relat

Re: [OSM-dev] Osmosis error - node not present in table "current_nodes" - no bbox

2013-01-03 Thread marqqs
Hi, Frederik is right: > It seems that you somehow managed to drop a node that is referenced by > something. I would suspect the --drop option of osmfilter to be responsible for this: --drop="natural=wood waterway=drain or waterway=ditch or waterway=stream or leisure=park" Maybe replacing --d

Re: [OSM-dev] Osmosis error - node not present in table "current_nodes" - no bbox

2013-01-03 Thread Jeff Meyer
I just ran them separately & sure enough, there's a difference: $ ls -l one.pbf two.pbf -rw-r--r-- 1 jeffme staff 2078657534 Jan 3 18:37 one.pbf -rw-r--r-- 1 jeffme staff 2078574282 Jan 3 18:46 two.pbf $ mv two.pbf planet-natural.pbf I'm currently expanding the files for a diff & also try

Re: [OSM-dev] Osmosis error - node not present in table "current_nodes" - no bbox

2013-01-03 Thread Jeff Meyer
Thanks - I really appreciate the help! : ) Unfortunately, I tried that & osmosis complained again. I'm going to try to generate the data using strictly osmosis (instead of osmconvert & osmfilter) & see what happens. $ osmosis --read-pbf planet-natural.pbf --tee 2 --write-pbf one.pbf --bb left=-18

Re: [OSM-dev] Osmosis error - node not present in table "current_nodes" - no bbox

2013-01-03 Thread Frederik Ramm
Hi, On 03.01.2013 21:02, Jeff Meyer wrote: Most of what I can find about this on the intrawebs indicates that this is typically a bbox-related issue, but I haven't used any bboxes to create my planet-natural file. (see steps below) It seems that you somehow managed to drop a node that is refer

[OSM-dev] Osmosis error - node not present in table "current_nodes" - no bbox

2013-01-03 Thread Jeff Meyer
After executing: $ osmosis --rb file="/home/historic/data/planet-natural.pbf" --wd user="openstreetmap" password="openstreetmap" database="osm" validateSchemaVersion=no I'm running into the following error: (full excerpt below) Caused by: org.postgresql.util.PSQLException: ERROR: insert or update

Re: [OSM-dev] osmosis error

2011-09-09 Thread BG
this error comes with the command "freelock" after the import is done. i wrote "#freelock" and dont get the rm error and hoped the expiry error would disappear. but, i still have the tile_expiry_error and dont get any hint at the expiry.log, because it is empty. On 09.09.2011 20:25, BG wrote:

[OSM-dev] osmosis error

2011-09-09 Thread BG
Hej. I use the load-next script from "how to minutely hstore" Tutorial. Everything works fine until i enable the expire option. I get an error: rm: cannot remove 'load-next.pid': No such file or directory I dont unterstand this. I looked in the script files, there is no command, which says re

Re: [OSM-dev] Osmosis error

2010-02-15 Thread Peter Körner
Brett Henderson schrieb: > It is used by the main launcher which automatically determines all the > required jars and adds them to the classpath. I'll need to take a look > at why it isn't being included. It's just not in the .tar.gz [1] or .zip [2] download, linked to from the wiki [3]. I fix

Re: [OSM-dev] Osmosis error

2010-02-14 Thread Brett Henderson
It is used by the main launcher which automatically determines all the required jars and adds them to the classpath. I'll need to take a look at why it isn't being included. Brett On Sun, Feb 14, 2010 at 11:20 PM, Andreas Kalsch wrote: > Error occurs in Osmosis 0.33: > > /backup/projects/3rdpar

[OSM-dev] Osmosis error

2010-02-14 Thread Andreas Kalsch
Error occurs in Osmosis 0.33: /backup/projects/3rdparty/osmosis/bin/osmosis --rx file=/backup/projects/data/gos/andi/bremen.osm --wd database=b validateSchemaVersion=no ... populateCurrentTables=no java.io.FileNotFoundException: /backup/projects/3rdparty/osmosis/config/plexus.conf (No such fil

[OSM-dev] Osmosis error on constraint nodes_ibfk_1

2009-11-10 Thread Maarten Deen
I'm using osmosis 0.31.2 to insert some data (from XAPI) in a mysql database and I get the error Cannot add or update a child row: a foreign key constraint fails (`osm06/nodes`, CONSTRAINT `nodes_ibfk_1` FOREIGN KEY (`changeset_id`) REFERENCES `changesets` (`id`)) I'm trying to load two osm f

Re: [OSM-dev] osmosis error

2009-10-08 Thread Pallinger Péter
I found a workaround for the below problem that is OK for me now (for testing and programming purposes), and write it down in case it will be useful for someone else. Anyone having a good idea for the original problem is still welcome. I did further experiments with osmosis. This time I used a q

[OSM-dev] osmosis error

2009-10-07 Thread Pallinger Péter
Tom Hughes írta: > Use PostgreSQL not MySQL - the MySQL support is not really maintained > anymore so it likely to be extremely fragile as you've just discovered. Thanks for the tip, I successfully ran "rake db:migrate". However, I failed to upload some maps. I've tried to run: osmosis -

Re: [OSM-dev] Osmosis error while cutting out a special region from a planet file

2009-08-30 Thread Brett Henderson
Hi Frank, I've had a look at the failing line of code and believe it's been caused by a java collection not being initialised properly. It looks like you're using the --tee task. All data gets made read-only by the --tee task and this uses the UnmodifiableTagCollection class. It also looks l

Re: [OSM-dev] Osmosis error while cutting out a special region from a planet file

2009-08-30 Thread John Smith
2009/8/30 Frank Bielig : > Does anybody has a hint to solve this problem? Could osmosis changed, that > all open writing tasks cleanly closed in case of internal errors? Then > results will be not complete but you get still valid output. I get those sort of errors if you tell osmosis to read a cha

[OSM-dev] Osmosis error while cutting out a special region from a planet file

2009-08-30 Thread Frank Bielig
Hallo, I use Osmosis for cutting out a special region by out of the planet file by giving a bounding box. Sometimes I get following exception after many hours of conversion: SCHWERWIEGEND: Thread for task 1-read-xml failed

Re: [OSM-dev] Osmosis Error on postgis import of planet file in org.PGgeometry.getValue

2009-07-23 Thread Torge Szczepanek
Hi! > I haven't seen this particular error before. My suspicion is that it's > caused by ways referring to non-existent nodes. I thought the code was > capable of dealing with that scenario, but it looks like that isn't the > case. Ok, thanks. > I don't have time to look into this at the momen

Re: [OSM-dev] Osmosis Error on postgis import of planet file in org.PGgeometry.getValue

2009-07-22 Thread Brett Henderson
Hi Torge, I haven't seen this particular error before. My suspicion is that it's caused by ways referring to non-existent nodes. I thought the code was capable of dealing with that scenario, but it looks like that isn't the case. I don't have time to look into this at the moment, but one wor

[OSM-dev] Osmosis Error on postgis import of planet file in org.PGgeometry.getValue

2009-07-22 Thread Torge Szczepanek
Hi List! I am doing some osmosis imports for some time now with extracts from http://download.geofabrik.de/ into postgis/postgres. These imports are working fine for the extracts (same import command as below). Now I am trying to import the planet file into a postgres/postgis database with enable

Re: [OSM-dev] Osmosis error: argument dbType not recognized for --write-apidb

2009-07-14 Thread Brett Henderson
Yep, the dbType argument isn't supported in 0.31. You may be able to workaround it by specifying the authFile argument and including the dbType parameter in that file but I haven't tested it out. It is fixed in the nightly builds. It was fixed in revision 15078. Version 0.31 is revision 149

[OSM-dev] Osmosis error: argument dbType not recognized for --write-apidb

2009-07-14 Thread Gavin Towey
I'm using the latest 0.31, any ideas? ./osmosis --read-xml file=/home/prog/europe/europe.osm --write-apidb host=localhost database=osm user=root password=* dbType=mysql Jul 14, 2009 4:57:25 PM org.openstreetmap.osmosis.core.Osmosis run INFO: Osmosis Version 0.31 Jul 14, 2009 4:57:25 PM org.ope

Re: [OSM-dev] Osmosis error, duplicate

2009-06-05 Thread Ed Loach
Jeff: > OK, that makes sense. But then what is the error: > >   Detail: Key (node_id)=(395051992) is not present in > table "current_nodes". > > from? That's what crashed my import. I'm trying to find where Osmosis > requests a node_id from current_nodes; or am I misreading the error? The fo

Re: [OSM-dev] Osmosis error, duplicate

2009-06-05 Thread Jeffrey Warren
OK, that makes sense. But then what is the error: Detail: Key (node_id)=(395051992) is not present in table "current_nodes". from? That's what crashed my import. I'm trying to find where Osmosis requests a node_id from current_nodes; or am I misreading the error? Thanks, Jeff On Fri, Jun 5, 20

Re: [OSM-dev] Osmosis error, duplicate

2009-06-05 Thread Joachim Zobel
Am Freitag, den 05.06.2009, 14:58 -0400 schrieb Jeffrey Warren: > Detail: Key (node_id)=(395051992) is not present in table "current_nodes". The field that is present is actually named node_id and that is the one that is mentioned. > ALTER TABLE ONLY current_way_nodes ADD CONSTRAINT > curren

Re: [OSM-dev] Osmosis error, duplicate

2009-06-05 Thread Ed Loach
Warren Sent: 05 June 2009 19:59 To: Joachim Zobel Cc: dev Openstreetmap; Josh Levinger Subject: Re: [OSM-dev] Osmosis error, duplicate Thanks, I was tracing the original foreign key constraint error (reproduced in full below) and this line caught my eye: Detail: Key (node_id)=(395051992

Re: [OSM-dev] Osmosis error, duplicate

2009-06-05 Thread Jeffrey Warren
Thanks, I was tracing the original foreign key constraint error (reproduced in full below) and this line caught my eye: Detail: Key (node_id)=(395051992) is not present in table "current_nodes". current_nodes has no node_id column! The constraint is created in the latest pgsql schema, here: (

Re: [OSM-dev] Osmosis error, duplicate

2009-06-05 Thread Joachim Zobel
Am Freitag, den 05.06.2009, 12:40 -0400 schrieb Jeffrey Warren: > and it's been running the following query for about 24 hours: > > SELECT Count(*) AS changesetCount FROM changesets WHERE id=$1 Take a look on Brets pgsql-latest.sql script (after the COPYs) and add the index on id: ALTER TABLE

Re: [OSM-dev] Osmosis error, duplicate

2009-06-05 Thread Jeffrey Warren
I've been importing with: 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="" user="" password="" validateSchemaVersion=no and it's been running the following query for about 24 ho

Re: [OSM-dev] Osmosis error, duplicate

2009-06-02 Thread Joachim Zobel
Am Dienstag, den 02.06.2009, 11:52 -0700 schrieb Jeffrey Warren: > I was importing a planet dump to pgsql with the --write-apidb-0.6 and > got the error: > > ERROR: insert or update on table "current_way_nodes" violates foreign > key constraint "current_way_nodes_node_id_fkey" Detail: Key > (no

[OSM-dev] Osmosis error, duplicate

2009-06-02 Thread Jeffrey Warren
I was importing a planet dump to pgsql with the --write-apidb-0.6 and got the error: ERROR: insert or update on table "current_way_nodes" violates foreign key constraint "current_way_nodes_node_id_fkey" Detail: Key (node_id)=(395051992) is not present in table "current_nodes". Why would that cau

Re: [OSM-dev] Osmosis error read-xml (NullPointerException)

2009-05-31 Thread Brett Henderson
marcus.wolsc...@googlemail.com wrote: > On Thu, 28 May 2009 17:42:02 +1000, Brett Henderson > wrote: > >> Line 43 of RelationMemberWriter above deals with the relation member >> role. Your osm file above is missing all of the role attributes on >> relation members which would cause this prob

Re: [OSM-dev] Osmosis error read-xml (NullPointerException)

2009-05-28 Thread marcus.wolschon
On Thu, 28 May 2009 17:42:02 +1000, Brett Henderson wrote: > Line 43 of RelationMemberWriter above deals with the relation member > role. Your osm file above is missing all of the role attributes on > relation members which would cause this problem to occur. > > Perhaps xapi doesn't include th

Re: [OSM-dev] Osmosis error read-xml (NullPointerException)

2009-05-28 Thread Brett Henderson
JuergenL wrote: > Hi > > I try to extract a polygon out of a osm file using osmosis and I get > an error reading the osm file. I use > http://albspotter.org/osm/test-osmosis.osm but also tried other > osm-files and different versions of osmosis. > > This is the output from osmosis --read-xml file="

[OSM-dev] Osmosis error read-xml (NullPointerException)

2009-05-27 Thread JuergenL
Hi I try to extract a polygon out of a osm file using osmosis and I get an error reading the osm file. I use http://albspotter.org/osm/test-osmosis.osm but also tried other osm-files and different versions of osmosis. This is the output from osmosis --read-xml file="test-osmosis.osm" --write-xml

Re: [OSM-dev] Osmosis error "duplicate entry for key 1"

2009-02-28 Thread Brett Henderson
Maarten Deen wrote: > I have this (for me) unexplainable error "duplicate entry ... for key 1" when > trying to load some data into a database with Osmosis (latest, 0.30). > > The data is: > > xmlns:osmxapi='http://www.informationfreeway.org/osmxapi/0.5' > osmxapi:uri='/api/0.5/node[amenity=atm

[OSM-dev] Osmosis error "duplicate entry for key 1"

2009-02-28 Thread Maarten Deen
I have this (for me) unexplainable error "duplicate entry ... for key 1" when trying to load some data into a database with Osmosis (latest, 0.30). The data is: and If I put these in different files, then the second always fails to load with error "Dup

Re: [OSM-dev] Osmosis error reading osm file and writing to mysql

2008-12-06 Thread Brett Henderson
The version of the database schema gets updated every time an enhancement is made to the database schema. The latest official version is 16. Osmosis only gets released occasionally so is sometimes behind. The svn version will usually be up to date but osmosis 0.29 probably isn't, I can't rem

Re: [OSM-dev] Osmosis error reading osm file and writing to mysql

2008-12-06 Thread Shaun McDonald
On 6 Dec 2008, at 22:07, Maarten Deen wrote: > Maarten Deen wrote: > >> But now I've ran into the next error: >> com.bretth.osmosis.core.OsmosisRuntimeException: The database >> schema version of >> 16 does not match the expected version of 11. > > Okay, I've found the fix, in the database: upd

Re: [OSM-dev] Osmosis error reading osm file and writing to mysql

2008-12-06 Thread Maarten Deen
Maarten Deen wrote: > But now I've ran into the next error: > com.bretth.osmosis.core.OsmosisRuntimeException: The database schema version > of > 16 does not match the expected version of 11. Okay, I've found the fix, in the database: update schema_info set version=11; But why is osmosis expec

Re: [OSM-dev] Osmosis error reading osm file and writing to mysql

2008-12-06 Thread Maarten Deen
Frederik Ramm wrote: > Hi, > > Maarten Deen wrote: >> $ mysql -D osm -u osm >> Reading table information for completion of table and column names >> You can turn off this feature to get a quicker startup with -A >> >> Welcome to the MySQL monitor. Commands end with ; or \g. > > [...] > >> $ os

Re: [OSM-dev] Osmosis error reading osm file and writing to mysql

2008-12-06 Thread Frederik Ramm
Hi, Maarten Deen wrote: > $ mysql -D osm -u osm > Reading table information for completion of table and column names > You can turn off this feature to get a quicker startup with -A > > Welcome to the MySQL monitor. Commands end with ; or \g. [...] > $ osmosis --read-xml file="bank.osm" --writ

[OSM-dev] Osmosis error reading osm file and writing to mysql

2008-12-06 Thread Maarten Deen
I am starting with osmosis, and the first thing I try comes back with java errors. I took the latest osmosis (0.29), running on Ubuntu 8.04 with java 6. I believe I've got the database set up right, database name is osm, username is osm, no password. I've ran the osm_schema_latest.sql from Bret