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
