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

[Кирилл Бестужев]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/osmosis-dev/attachments/20120912/6a07a42b/attachment.html>