Opened 9 months ago

Last modified 9 months ago

#5479 new defect

osmosis can't append osm data into database

Reported by: fazlerabbi37@… Owned by: brett@…
Priority: major Milestone:
Component: osmosis Version:
Keywords: Cc:


at first I upload data into database using this command-
osmosis --read-pbf previous.osm.pbf --write-apidb host="localhost" database="openstreetmap" user="postgres" password="postgres" validateSchemaVersion="no"
and its working fine. Next I produce a diff.osc.gz using following command-
osmosis --read-pbf latest.osm.pbf --read-apidb host="localhost" database="openstreetmap" user="postgres" password="postgres" validateSchemaVersion=no --derive-change --write-xml-change file=diff.osc.gz
Then I use the following command to append data into database-
osmosis --read-xml-change diff.osc.gz --write-pgsql-change user="postgres" database="openstreetmap" password="postgres" validateSchemaVersion="no"
It shows me following error:
SEVERE: Thread for task 1-read-xml-change failed
org.springframework.jdbc.BadSqlGrammarException?: PreparedStatementCallback?; bad SQL grammar [SELECT id, name FROM users WHERE id = ?]; nested exception is org.postgresql.util.PSQLException: ERROR: column "name" does not exist

Am I doing something wrong? what is the right procedure?

Change History (1)

comment:1 Changed 9 months ago by fazlerabbi37@…

  • Priority changed from minor to major
Note: See TracTickets for help on using tickets.