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
