[osmosis-dev] Truncate fails

Stadin, Benjamin Benjamin.Stadin at heidelberg-mobil.com
Sat Jun 11 23:44:29 UTC 2016


Hi,

I get the error below when I try to truncate the API DB. I'm using this command:

osmosis --truncate-apidb host="localhost" database="openstreetmap" user="$dbuser" password="$pw" validateSchemaVersion="no"

Ben

33:22 AM org.openstreetmap.osmosis.core.Osmosis run
INFO: Osmosis Version 0.45
Jun 12, 2016 1:33:22 AM org.openstreetmap.osmosis.core.Osmosis run
INFO: Preparing pipeline.
Jun 12, 2016 1:33:22 AM org.openstreetmap.osmosis.core.Osmosis run
INFO: Launching pipeline execution.
Jun 12, 2016 1:33:22 AM org.openstreetmap.osmosis.core.Osmosis run
INFO: Pipeline executing, waiting for completion.
Jun 12, 2016 1:33:22 AM org.openstreetmap.osmosis.core.Osmosis run
INFO: Pipeline complete.
Jun 12, 2016 1:33:22 AM org.openstreetmap.osmosis.core.Osmosis run
INFO: Total execution time: 310 milliseconds.
Jun 12, 2016 1:33:22 AM org.openstreetmap.osmosis.core.Osmosis run
INFO: Osmosis Version 0.45
Jun 12, 2016 1:33:22 AM org.openstreetmap.osmosis.core.Osmosis run
INFO: Preparing pipeline.
Jun 12, 2016 1:33:22 AM org.openstreetmap.osmosis.core.Osmosis run
INFO: Launching pipeline execution.
Jun 12, 2016 1:33:22 AM org.openstreetmap.osmosis.core.Osmosis run
INFO: Pipeline executing, waiting for completion.
Jun 12, 2016 1:33:23 AM org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager waitForCompletion
SEVERE: Thread for task 1-truncate-apidb failed
org.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to execute statement.
	at org.openstreetmap.osmosis.apidb.common.DatabaseContext.executeStatement(DatabaseContext.java:330)
	at org.openstreetmap.osmosis.apidb.common.DatabaseContext.truncateTables(DatabaseContext.java:182)
	at org.openstreetmap.osmosis.apidb.v0_6.ApidbTruncator.run(ApidbTruncator.java:58)
	at java.lang.Thread.run(Thread.java:745)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "current_relation_members" does not exist
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2182)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1911)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:173)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:616)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:452)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:444)
	at org.openstreetmap.osmosis.apidb.common.DatabaseContext.executeStatement(DatabaseContext.java:327)
	... 3 more

Jun 12, 2016 1:33:23 AM 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 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	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)



More information about the osmosis-dev mailing list