Hi, i just found a future bug when postgis 2.0 will be used more - osmosis 0.39 uses legacy functions e.h. MakeLine which should be replaces with ST_MakeLine:
Jul 8, 2011 4:07:16 PM org.openstreetmap.osmosis.core.Osmosis run
INFO: Osmosis Version 0.39
Jul 8, 2011 4:07:16 PM org.openstreetmap.osmosis.core.Osmosis run
INFO: Preparing pipeline.
Jul 8, 2011 4:07:16 PM org.openstreetmap.osmosis.core.Osmosis run
INFO: Launching pipeline execution.
Jul 8, 2011 4:07:16 PM org.openstreetmap.osmosis.core.Osmosis run
INFO: Pipeline executing, waiting for completion.
Jul 8, 2011 4:07:25 PM
org.springframework.beans.factory.xml.XmlBeanDefinitionReader
loadBeanDefinitions
INFO: Loading XML bean definitions from class path resource
[org/springframework/jdbc/support/sql-error-codes.xml]
Jul 8, 2011 4:07:25 PM org.springframework.jdbc.support.SQLErrorCodesFactory
<init>
INFO: SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL,
Oracle, PostgreSQL, Sybase]
Jul 8, 2011 4:07:25 PM
org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager
waitForCompletion
SEVERE: Thread for task 1-rri failed
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad
SQL grammar [UPDATE ways w SET linestring = ( SELECT MakeLine(c.geom) AS
way_line FROM ( SELECT n.geom AS geom FROM nodes n INNER JOIN way_nodes wn ON
n.id = wn.node_id WHERE (wn.way_id = w.id) ORDER BY wn.sequence_id ) c ) WHERE
w.id IN ( SELECT w.id FROM ways w INNER JOIN way_nodes wn ON w.id = wn.way_id
WHERE wn.node_id = ? GROUP BY w.id )]; nested exception is
org.postgresql.util.PSQLException: ERROR: function makeline(geometry) does not
exist
Hint: No function matches the given name and argument types. You might need
to add explicit type casts.
Position: 41
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.update(JdbcTemplate.java:811)
at
org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:867)
at
org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:875)
at
org.springframework.jdbc.core.simple.SimpleJdbcTemplate.update(SimpleJdbcTemplate.java:249)
at
org.openstreetmap.osmosis.pgsnapshot.v0_6.impl.NodeDao.modifyEntity(NodeDao.java:72)
at
org.openstreetmap.osmosis.pgsnapshot.v0_6.impl.ChangeWriter.write(ChangeWriter.java:126)
at
org.openstreetmap.osmosis.pgsnapshot.v0_6.impl.ActionChangeWriter.process(ActionChangeWriter.java:48)
at
org.openstreetmap.osmosis.core.container.v0_6.NodeContainer.process(NodeContainer.java:58)
at
org.openstreetmap.osmosis.pgsnapshot.v0_6.PostgreSqlChangeWriter.process(PostgreSqlChangeWriter.java:85)
at
org.openstreetmap.osmosis.core.sort.v0_6.ChangeSorter.complete(ChangeSorter.java:64)
at
org.openstreetmap.osmosis.replication.v0_6.ReplicationDownloader.processComplete(ReplicationDownloader.java:93)
at
org.openstreetmap.osmosis.replication.v0_6.BaseReplicationDownloader.runImpl(BaseReplicationDownloader.java:284)
at
org.openstreetmap.osmosis.replication.v0_6.BaseReplicationDownloader.run(BaseReplicationDownloader.java:345)
at java.lang.Thread.run(Thread.java:636)
Caused by: org.postgresql.util.PSQLException: ERROR: function
makeline(geometry) does not exist
Hint: No function matches the given name and argument types. You might need
to add explicit type casts.
Position: 41
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at
org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:817)
at
org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:1)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:586)
... 14 more
--
Florian Lohoff [email protected]
„Für eine ausgewogene Energiepolitik über das Jahr 2020 hinaus ist die
Nutzung von Atomenergie eine Brückentechnologie und unverzichtbar. Ein
Ausstieg in zehn Jahren, wie noch unter der rot-grünen Regierung
beschlossen, kommt für die nationale Energieversorgung zu abrupt.“
Angela Merkel CDU 30.8.2009
signature.asc
Description: Digital signature
_______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
