[osmosis-dev] Error reading API DB with --rd

[Shaun McDonald]

Hi,

Have you updated the rails_port code to the latest version?

Shaun

On 12 Sep 2012, at 09:39, Кирилл Бестужев <bestoujev at gmail.com> wrote:

> Hi all!
> 
> I have a local rails_port installation. I used osmosis 0.39 to make dumps of data in it with --rd (or --rdcur). Today I upgraded osmosis to v. 0.41 and I have a problem to use it - I get the following output:
> 
> SEVERE: Thread for task 1-rd failed
> org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT e.node_id AS id, e.version, e.timestamp, e.visible, u.data_public, u.id AS user_id, u.display_name, e.changeset_id, e.latitude, e.longitude FROM nodes e INNER JOIN nodes t ON e.node_id = t.node_id AND e.version = t.version INNER JOIN changesets c ON e.changeset_id = c.id INNER JOIN users u ON c.user_id = u.id]; nested exception is org.postgresql.util.PSQLException: ERROR: column e.node_id does not exist
>   Position: 183
>         at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98)
>         at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
>         at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
>         at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
>         at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:602)
>         at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636)
>         at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:661)
>         at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:681)
>         at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:154)
>         at org.openstreetmap.osmosis.apidb.v0_6.impl.EntityDao.getFeaturelessEntityHistory(EntityDao.java:175)
>         at org.openstreetmap.osmosis.apidb.v0_6.impl.EntityDao.getEntityHistory(EntityDao.java:266)
>         at org.openstreetmap.osmosis.apidb.v0_6.impl.EntityDao.getChangeHistory(EntityDao.java:293)
>         at org.openstreetmap.osmosis.apidb.v0_6.impl.EntityDao.getHistory(EntityDao.java:540)
>         at org.openstreetmap.osmosis.apidb.v0_6.impl.AllEntityDao.getHistory(AllEntityDao.java:119)
>         at org.openstreetmap.osmosis.apidb.v0_6.ApidbReader.runImpl(ApidbReader.java:80)
>         at org.openstreetmap.osmosis.apidb.v0_6.ApidbReader$1.doInTransactionWithoutResult(ApidbReader.java:110)
>         at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33)
>         at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
>         at org.openstreetmap.osmosis.apidb.common.DatabaseContext2.executeWithinTransaction(DatabaseContext2.java:102)
>         at org.openstreetmap.osmosis.apidb.v0_6.ApidbReader.run(ApidbReader.java:105)
>         at java.lang.Thread.run(Thread.java:662)
> Caused by: org.postgresql.util.PSQLException: ERROR: column e.node_id does not exist
>   Position: 183
>         at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
>         at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
>         at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
>         at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
>         at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
>         at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
>         at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
>         at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
>         at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:643)
>         at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:586)
>         ... 16 more
> Sep 12, 2012 12:37:34 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 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:597)
>         at org.codehaus.plexus.classworlds.launcher.Launcher.launchStandard(Launcher.java:329)
>         at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:239)
>         at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:409)
>         at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352)
>         at org.codehaus.classworlds.Launcher.main(Launcher.java:47)
> 
> 
> As I see from http://wiki.openstreetmap.org/wiki/Rails_port/Database_schema no collumn node_id should exist im table nodes. 
> 
> v 0.39 still works fine.
> 
> What can I do with this? 
> 
> Thanx,
> Kirill
> _______________________________________________
> osmosis-dev mailing list
> osmosis-dev at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/osmosis-dev

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/osmosis-dev/attachments/20120912/15d85643/attachment-0001.html>