[OSM-dev] osm2pgsql not appending changeset?

[Ákos Maróy]

On 07/12/11 01:28, Erik Johansson wrote:
> http://wiki.openstreetmap.org/wiki/Osmosis/Detailed_Usage_0.39#Replication_Tasks
> 
> Or the well written prose version:
> http://ksmapper.blogspot.com/2011/04/keeping-database-up-to-date-with.html
> or lots of links in
> http://wiki.openstreetmap.org/wiki/Osmosis/Examples

I tried the above, and I got to the following error message:

$   osmosis --rri $(pwd) --sc --wpc user="osm" database="osm" password="osm"
Dec 08, 2011 1:56:12 AM org.openstreetmap.osmosis.core.Osmosis run
INFO: Osmosis Version 0.34
log4j:WARN No appenders could be found for logger
(org.java.plugin.ObjectFactory).
log4j:WARN Please initialize the log4j system properly.
Dec 08, 2011 1:56:13 AM org.openstreetmap.osmosis.core.Osmosis run
INFO: Preparing pipeline.
Dec 08, 2011 1:56:13 AM org.openstreetmap.osmosis.core.Osmosis run
INFO: Launching pipeline execution.
Dec 08, 2011 1:56:13 AM org.openstreetmap.osmosis.core.Osmosis run
INFO: Pipeline executing, waiting for completion.
Dec 08, 2011 1:56:47 AM
org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager
waitForCompletion
SEVERE: Thread for task 1-rri failed
org.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to read
the schema version from the schema info table.
	at
org.openstreetmap.osmosis.core.pgsql.common.SchemaVersionValidator.validateDBVersion(SchemaVersionValidator.java:92)
	at
org.openstreetmap.osmosis.core.pgsql.common.SchemaVersionValidator.validateVersion(SchemaVersionValidator.java:52)
	at
org.openstreetmap.osmosis.core.pgsql.v0_6.PostgreSqlChangeWriter.process(PostgreSqlChangeWriter.java:58)
	at
org.openstreetmap.osmosis.core.sort.v0_6.ChangeSorter.complete(ChangeSorter.java:64)
	at
org.openstreetmap.osmosis.core.sort.v0_6.ChangeSorter.complete(ChangeSorter.java:67)
	at
org.openstreetmap.osmosis.core.merge.v0_6.ReplicationDownloader.processComplete(ReplicationDownloader.java:93)
	at
org.openstreetmap.osmosis.core.merge.v0_6.BaseReplicationDownloader.runImpl(BaseReplicationDownloader.java:284)
	at
org.openstreetmap.osmosis.core.merge.v0_6.BaseReplicationDownloader.run(BaseReplicationDownloader.java:345)
	at java.lang.Thread.run(Thread.java:722)
Caused by: org.postgresql.util.PSQLException: ERROR: relation
"schema_info" does not exist
  Position: 21
	at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2077)
	at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1810)
	at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
	at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:498)
	at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:372)
	at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:252)
	at
org.openstreetmap.osmosis.core.pgsql.common.SchemaVersionValidator.validateDBVersion(SchemaVersionValidator.java:73)
	... 8 more

Dec 08, 2011 1:56:47 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:85)
	at org.openstreetmap.osmosis.core.Osmosis.main(Osmosis.java:30)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:601)
	at
org.codehaus.plexus.classworlds.launcher.Launcher.launchStandard(Launcher.java:328)
	at
org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:238)
	at
org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:408)
	at
org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:351)
	at org.codehaus.classworlds.Launcher.main(Launcher.java:31)


where:
$ psql -h localhost -U osm -W osm
Password for user osm:
psql (9.1.1)
SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
Type "help" for help.

osm=> \d
              List of relations
 Schema |        Name        | Type  | Owner
--------+--------------------+-------+-------
 public | geography_columns  | view  | osm
 public | geometry_columns   | table | osm
 public | planet_osm_line    | table | osm
 public | planet_osm_nodes   | table | osm
 public | planet_osm_point   | table | osm
 public | planet_osm_polygon | table | osm
 public | planet_osm_rels    | table | osm
 public | planet_osm_roads   | table | osm
 public | planet_osm_ways    | table | osm
 public | spatial_ref_sys    | table | osm
(10 rows)


$ ls -l $(pwd)
total 8
-rw-rw-r-- 1 akos akos 250 2011-12-07 16:17 configuration.txt
-rw-rw-r-- 1 akos akos   0 2011-12-08 01:56 download.lock
-rw-rw-r-- 1 akos akos 175 2011-12-07 16:21 state.txt



I wonder what I'm doing wrong..


Akos