Last active
August 29, 2015 14:07
-
-
Save caged/0c701eddfaa4b93ee172 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
osm-building-import┋ master⚡ ᴥ osmosis --read-xml osm/features.osm --truncate-pgsql database=osm_test port=15432 --wp database=osm_test port=15432 | |
Oct 10, 2014 11:56:59 AM org.openstreetmap.osmosis.core.Osmosis run | |
INFO: Osmosis Version 0.42-6-gf39a160-dirty | |
Oct 10, 2014 11:56:59 AM org.openstreetmap.osmosis.core.Osmosis run | |
INFO: Preparing pipeline. | |
Oct 10, 2014 11:56:59 AM org.openstreetmap.osmosis.core.Osmosis main | |
SEVERE: Execution aborted. | |
org.openstreetmap.osmosis.core.OsmosisRuntimeException: Argument port for task 2-truncate-pgsql was not recognised. | |
at org.openstreetmap.osmosis.core.pipeline.common.TaskManagerFactory.createTaskManager(TaskManagerFactory.java:64) | |
at org.openstreetmap.osmosis.core.pipeline.common.Pipeline.buildTasks(Pipeline.java:50) | |
at org.openstreetmap.osmosis.core.pipeline.common.Pipeline.prepare(Pipeline.java:112) | |
at org.openstreetmap.osmosis.core.Osmosis.run(Osmosis.java:86) | |
at org.openstreetmap.osmosis.core.Osmosis.main(Osmosis.java:37) | |
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:606) | |
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) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
osm-building-import┋ master⚡ ᴥ osmosis --read-xml osm/features.osm --truncate-pgsql database=osm_test --wp database=osm_test | |
Oct 10, 2014 11:54:28 AM org.openstreetmap.osmosis.core.Osmosis run | |
INFO: Osmosis Version 0.42-6-gf39a160-dirty | |
Oct 10, 2014 11:54:28 AM org.openstreetmap.osmosis.core.Osmosis run | |
INFO: Preparing pipeline. | |
Oct 10, 2014 11:54:28 AM org.openstreetmap.osmosis.core.Osmosis run | |
INFO: Launching pipeline execution. | |
Oct 10, 2014 11:54:28 AM org.openstreetmap.osmosis.core.Osmosis run | |
INFO: Pipeline executing, waiting for completion. | |
Oct 10, 2014 11:54:28 AM org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager waitForCompletion | |
SEVERE: Thread for task 1-read-xml failed | |
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.) | |
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80) | |
at org.openstreetmap.osmosis.pgsnapshot.common.DatabaseContext.doesTableExist(DatabaseContext.java:202) | |
at org.openstreetmap.osmosis.pgsnapshot.v0_6.impl.DatabaseCapabilityChecker.initialize(DatabaseCapabilityChecker.java:34) | |
at org.openstreetmap.osmosis.pgsnapshot.v0_6.impl.DatabaseCapabilityChecker.isWayBboxSupported(DatabaseCapabilityChecker.java:61) | |
at org.openstreetmap.osmosis.pgsnapshot.v0_6.PostgreSqlCopyWriter.initialize(PostgreSqlCopyWriter.java:78) | |
at org.openstreetmap.osmosis.pgsnapshot.v0_6.PostgreSqlCopyWriter.process(PostgreSqlCopyWriter.java:108) | |
at org.openstreetmap.osmosis.xml.v0_6.impl.NodeElementProcessor.end(NodeElementProcessor.java:139) | |
at org.openstreetmap.osmosis.xml.v0_6.impl.OsmHandler.endElement(OsmHandler.java:107) | |
at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source) | |
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source) | |
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) | |
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) | |
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) | |
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) | |
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) | |
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) | |
at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source) | |
at org.apache.xerces.jaxp.SAXParserImpl.parse(Unknown Source) | |
at javax.xml.parsers.SAXParser.parse(SAXParser.java:195) | |
at org.openstreetmap.osmosis.xml.v0_6.XmlReader.run(XmlReader.java:111) | |
at java.lang.Thread.run(Thread.java:745) | |
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.) | |
at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) | |
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) | |
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) | |
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111) | |
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77) | |
... 20 more | |
Caused by: org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. | |
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:138) | |
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66) | |
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125) | |
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30) | |
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:22) | |
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:32) | |
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24) | |
at org.postgresql.Driver.makeConnection(Driver.java:393) | |
at org.postgresql.Driver.connect(Driver.java:267) | |
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) | |
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) | |
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) | |
at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) | |
... 24 more | |
Caused by: java.net.ConnectException: errno: 61, error: Connection refused | |
at java.net.PlainSocketImpl.socketConnect(Native Method) | |
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339) | |
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200) | |
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182) | |
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) | |
at java.net.Socket.connect(Socket.java:579) | |
at java.net.Socket.connect(Socket.java:528) | |
at java.net.Socket.<init>(Socket.java:425) | |
at java.net.Socket.<init>(Socket.java:208) | |
at org.postgresql.core.PGStream.<init>(PGStream.java:62) | |
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:76) | |
... 36 more | |
Oct 10, 2014 11:54:28 AM org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager waitForCompletion | |
SEVERE: Thread for task 2-truncate-pgsql failed | |
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.) | |
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80) | |
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:382) | |
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456) | |
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:464) | |
at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:472) | |
at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:477) | |
at org.springframework.jdbc.core.JdbcTemplate.queryForInt(JdbcTemplate.java:486) | |
at org.openstreetmap.osmosis.pgsnapshot.common.SchemaVersionValidator.validateDBVersion(SchemaVersionValidator.java:64) | |
at org.openstreetmap.osmosis.pgsnapshot.common.SchemaVersionValidator.validateVersion(SchemaVersionValidator.java:47) | |
at org.openstreetmap.osmosis.pgsnapshot.v0_6.PostgreSqlTruncator.run(PostgreSqlTruncator.java:58) | |
at java.lang.Thread.run(Thread.java:745) | |
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.) | |
at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) | |
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) | |
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) | |
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111) | |
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77) | |
... 10 more | |
Caused by: org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. | |
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:138) | |
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66) | |
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125) | |
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30) | |
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:22) | |
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:32) | |
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24) | |
at org.postgresql.Driver.makeConnection(Driver.java:393) | |
at org.postgresql.Driver.connect(Driver.java:267) | |
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) | |
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) | |
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) | |
at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) | |
... 14 more | |
Caused by: java.net.ConnectException: Connection refused | |
at java.net.PlainSocketImpl.socketConnect(Native Method) | |
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339) | |
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200) | |
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182) | |
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) | |
at java.net.Socket.connect(Socket.java:579) | |
at java.net.Socket.connect(Socket.java:528) | |
at java.net.Socket.<init>(Socket.java:425) | |
at java.net.Socket.<init>(Socket.java:208) | |
at org.postgresql.core.PGStream.<init>(PGStream.java:62) | |
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:76) | |
... 26 more | |
Oct 10, 2014 11:54:28 AM 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:57) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:606) | |
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) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment