[OSM-dev] osm2pgsql not appending changeset?

Ákos Maróy akos at maroy.hu
Thu Dec 8 07:41:13 GMT 2011


On 08/12/11 08:23, Andre Joost wrote:
> Am 08.12.2011 02:00, schrieb Á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
> 
> ...
> 
>>
>> I wonder what I'm doing wrong..
>>
> 
> outdated osmosis version?
> current is 0.40

same error with 0.40.1:

$ ../osmosis-0.40.1/bin/osmosis --rri $(pwd) --sc --wpc user="osm"
database="osm" password="osm"
Dec 08, 2011 8:38:45 AM org.openstreetmap.osmosis.core.Osmosis run
INFO: Osmosis Version 0.40.1
Dec 08, 2011 8:38:45 AM org.openstreetmap.osmosis.core.Osmosis run
INFO: Preparing pipeline.
Dec 08, 2011 8:38:45 AM org.openstreetmap.osmosis.core.Osmosis run
INFO: Launching pipeline execution.
Dec 08, 2011 8:38:45 AM org.openstreetmap.osmosis.core.Osmosis run
INFO: Pipeline executing, waiting for completion.
Dec 08, 2011 8:39:19 AM
org.springframework.beans.factory.xml.XmlBeanDefinitionReader
loadBeanDefinitions
INFO: Loading XML bean definitions from class path resource
[org/springframework/jdbc/support/sql-error-codes.xml]
Dec 08, 2011 8:39:19 AM
org.springframework.jdbc.support.SQLErrorCodesFactory <init>
INFO: SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL,
MySQL, Oracle, PostgreSQL, Sybase]
Dec 08, 2011 8:39:19 AM
org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager
waitForCompletion
SEVERE: Thread for task 1-rri failed
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad
SQL grammar [SELECT version FROM schema_info]; nested exception is
org.postgresql.util.PSQLException: ERROR: relation "schema_info" does
not exist
  Position: 21
        at
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:233)
        at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
        at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406)
        at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:455)
        at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:463)
        at
org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:471)
...




More information about the dev mailing list