Advertisement
Guest User

Untitled

a guest
Jul 22nd, 2017
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.01 KB | None | 0 0
  1. osmosis --read-pgsql host="localhost" database="X" user="X" password="X" outPipe.0=pg --dd inPipe.0=pg outPipe.0=dd --write-pbf inPipe.0=dd file=myfile.osm.pbf
  2.  
  3. Jul 22, 2017 9:49:14 AM org.openstreetmap.osmosis.core.Osmosis run
  4. INFO: Osmosis Version 0.44.1
  5. Jul 22, 2017 9:49:15 AM org.openstreetmap.osmosis.core.Osmosis run
  6. INFO: Preparing pipeline.
  7. Jul 22, 2017 9:49:15 AM org.openstreetmap.osmosis.core.Osmosis run
  8. INFO: Launching pipeline execution.
  9. Jul 22, 2017 9:49:15 AM org.openstreetmap.osmosis.core.Osmosis run
  10. INFO: Pipeline executing, waiting for completion.
  11. Jul 22, 2017 9:49:15 AM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
  12. INFO: Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
  13. Jul 22, 2017 9:49:15 AM org.springframework.jdbc.support.SQLErrorCodesFactory <init>
  14. INFO: SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
  15. Jul 22, 2017 9:49:15 AM org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager waitForCompletion
  16. SEVERE: Thread for task 1-read-pgsql failed
  17. org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT version FROM schema_info]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "schema_info" does not exist
  18. Position: 21
  19. at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:237)
  20. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
  21. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
  22. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
  23. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:464)
  24. at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:472)
  25. at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:477)
  26. at org.openstreetmap.osmosis.pgsnapshot.common.SchemaVersionValidator.validateDBVersion(SchemaVersionValidator.java:64)
  27. at org.openstreetmap.osmosis.pgsnapshot.common.SchemaVersionValidator.validateVersion(SchemaVersionValidator.java:47)
  28. at org.openstreetmap.osmosis.pgsnapshot.v0_6.impl.PostgreSqlDatasetContext.initialize(PostgreSqlDatasetContext.java:99)
  29. at org.openstreetmap.osmosis.pgsnapshot.v0_6.impl.PostgreSqlDatasetContext.iterate(PostgreSqlDatasetContext.java:197)
  30. at org.openstreetmap.osmosis.dataset.v0_6.DumpDataset.process(DumpDataset.java:48)
  31. at org.openstreetmap.osmosis.pgsnapshot.v0_6.PostgreSqlDatasetReader.run(PostgreSqlDatasetReader.java:53)
  32. at java.lang.Thread.run(Thread.java:748)
  33. Caused by: org.postgresql.util.PSQLException: ERROR: relation "schema_info" does not exist
  34. Position: 21
  35. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
  36. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
  37. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
  38. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
  39. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
  40. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:283)
  41. at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:209)
  42. at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:209)
  43. at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441)
  44. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
  45. ... 11 more
  46.  
  47. Jul 22, 2017 9:49:15 AM org.openstreetmap.osmosis.core.Osmosis main
  48. SEVERE: Execution aborted.
  49. org.openstreetmap.osmosis.core.OsmosisRuntimeException: One or more tasks failed.
  50. at org.openstreetmap.osmosis.core.pipeline.common.Pipeline.waitForCompletion(Pipeline.java:146)
  51. at org.openstreetmap.osmosis.core.Osmosis.run(Osmosis.java:92)
  52. at org.openstreetmap.osmosis.core.Osmosis.main(Osmosis.java:37)
  53. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  54. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  55. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  56. at java.lang.reflect.Method.invoke(Method.java:498)
  57. at org.codehaus.plexus.classworlds.launcher.Launcher.launchStandard(Launcher.java:328)
  58. at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:238)
  59. at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:408)
  60. at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:351)
  61. at org.codehaus.classworlds.Launcher.main(Launcher.java:31)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement