This is a static archive of our old OpenStreetMap Help Site. Please post any new questions and answers at community.osm.org.

Populating database on Rails Port - Osmosis fails

0

Hi All,

I have successfully installed the Rails Port e.g. I can see openstreetmap website from localhost. Now, I want to populate the database with my own map. To do so, I run the following comand:

osmosis --read-pbf /mnt/share/entre_rios-latest.osm.pbf
--write-apidb host="localhost" database="openstreetmap" user="osmweb" password="osmweb" validateSchemaVersion="no"

However, command fails because Osmosis is unable to insert a user into the database. Moreover, it seems that a column is missing. Looking at tables "users", "relations", and similar names; results that none of them has a field "nearby".

Here is the log:

Dec 19, 2019 3:39:22 PM org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager waitForCompletion
SEVERE: Thread for task 1-read-pbf failed
org.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to insert user with id 678132 into the database.
    at org.openstreetmap.osmosis.apidb.v0_6.impl.UserManager.insertUser(UserManager.java:115)
    at org.openstreetmap.osmosis.apidb.v0_6.impl.UserManager.addOrUpdateUser(UserManager.java:163)
    at org.openstreetmap.osmosis.apidb.v0_6.ApidbWriter.process(ApidbWriter.java:1169)
    at crosby.binary.osmosis.OsmosisBinaryParser.parseDense(OsmosisBinaryParser.java:138)
    at org.openstreetmap.osmosis.osmbinary.BinaryParser.parse(BinaryParser.java:124)
    at org.openstreetmap.osmosis.osmbinary.BinaryParser.handleBlock(BinaryParser.java:68)
    at org.openstreetmap.osmosis.osmbinary.file.FileBlock.process(FileBlock.java:135)
    at org.openstreetmap.osmosis.osmbinary.file.BlockInputStream.process(BlockInputStream.java:34)
    at crosby.binary.osmosis.OsmosisReader.run(OsmosisReader.java:45)
    at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: org.postgresql.util.PSQLException: ERROR: column "nearby" of relation "users" does not exist
  Position: 129
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
    at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
    at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
    at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:143)
    at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:120)
    at org.openstreetmap.osmosis.apidb.v0_6.impl.UserManager.insertUser(UserManager.java:112)
    ... 9 more

Dec 19, 2019 3:39:22 PM org.openstreetmap.osmosis.core.Osmosis main
SEVERE: Execution aborted.
org.openstreetmap.osmosis.core.OsmosisRuntimeException: One or more tasks failed.
    at org.openstreetmap.osmosis.core.pipeline.common.Pipeline.waitForCompletion(Pipeline.java:146)
    at org.openstreetmap.osmosis.core.Osmosis.run(Osmosis.java:92)
    at org.openstreetmap.osmosis.core.Osmosis.main(Osmosis.java:37)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at org.codehaus.plexus.classworlds.launcher.Launcher.launchStandard(Launcher.java:330)
    at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:238)
    at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:415)
    at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:356)
    at org.codehaus.classworlds.Launcher.main(Launcher.java:47)

If database is created by the Ruby script, how could a column be missing? Is it possible that there is some mistake, or a missing step? Any help would be appreciated. Thanks in advance!

asked 19 Dec '19, 16:26

JoseBLJ's gravatar image

JoseBLJ
16113
accept rate: 0%

edited 19 Dec '19, 19:19


One Answer:

3

This is a known issue see https://github.com/openstreetmap/openstreetmap-website/issues/2449 in general you should be looking in the github repo first when you have issues installing.

BTW this should be trivial to fix if you can build osmosis yourself. The larger issue is that osmosis currently has no volunteer maintainer and nobody seems to be willing to pay somebody to do the job.

answered 19 Dec '19, 20:01

SimonPoole's gravatar image

SimonPoole ♦
44.7k13326701
accept rate: 18%

edited 19 Dec '19, 22:56

Source code available on GitHub .