No, should I? I see no changes to DB schema on the wiki!
Kirill 2012/9/12 Shaun McDonald <[email protected]> > Hi, > > Have you updated the rails_port code to the latest version? > > Shaun > > On 12 Sep 2012, at 09:39, Кирилл Бестужев <[email protected]> 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 > [email protected] > http://lists.openstreetmap.org/listinfo/osmosis-dev > > >
_______________________________________________ osmosis-dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/osmosis-dev
