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

Wed Sep 12 11:50:00 BST 2012

No, should I?

I see no changes to DB schema on the wiki!

Kirill

2012/9/12 Shaun McDonald <shaun at shaunmcdonald.me.uk>

> 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/e038bf15/attachment.html>