<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body text="#000000" bgcolor="#ffffff">
<p><span style="font-size: 9pt;" mce_style="font-size: 9pt;"><span
style="font-family: verdana,geneva;"
mce_style="font-family:
verdana,geneva;"><span
style="background-color: transparent;"
mce_style="background-color: transparent;"><span
style="color: rgb(0, 0, 0);" mce_style="color: #000000;"><span
style="color: rgb(0, 0, 0);" mce_style="color: #000000;"> Hi there,<br>
<br>
</span></span></span></span></span></p>
<p><span style="font-size: 9pt;" mce_style="font-size: 9pt;"><span
style="font-family: verdana,geneva;"
mce_style="font-family:
verdana,geneva;"><span
style="background-color: transparent;"
mce_style="background-color: transparent;"><span
style="color: rgb(0, 0, 0);" mce_style="color: #000000;"><span
style="color: rgb(0, 0, 0);" mce_style="color: #000000;">I've got a
problem with importing .osm files into a postgis database.</span></span></span></span></span></p>
<p><span style="font-size: 9pt;" mce_style="font-size: 9pt;"><span
style="font-family: verdana,geneva;"
mce_style="font-family:
verdana,geneva;"><span
style="background-color: transparent;"
mce_style="background-color: transparent;"><span
style="color: rgb(0, 0, 0);" mce_style="color: #000000;"><span
style="color: rgb(0, 0, 0);" mce_style="color: #000000;">I think i set
up the database correcly is</span></span></span></span></span>, I used
the pgsql_simple_schema_0.6.sql schema from osmosis.<br>
I also used the 900913.sql file. </p>
<p><br>
</p>
<p>When i try to import files like this:</p>
<p>osmosis --read-xml file="madagascar.osm" --write-apidb
host="localhost" database="osm5" user="postgres" password="12345"</p>
<p><br>
</p>
<p>I'll get the following output/Error messages:</p>
<p>#################################################</p>
<p>May 2, 2010 2:06:42 PM org.openstreetmap.osmosis.core.Osmosis run<br>
INFO: Osmosis Version 0.35<br>
May 2, 2010 2:06:42 PM org.java.plugin.ObjectFactory loadProperties<br>
FINE: no jpf.properties file found in ${java.home}/lib
(/usr/lib/jvm/java-6-openjdk/jre/lib/jpf.properties) nor in CLASSPATH,
using standard properties<br>
May 2, 2010 2:06:42 PM org.java.plugin.ObjectFactory loadProperties<br>
FINE: loaded jpf.properties from
<a class="moz-txt-link-freetext" href="jar:file:/home/alex/Desktop/osmosis-0.35/lib/default/jpf-1.5.jar!/org/java/plugin/standard/jpf.properties">jar:file:/home/alex/Desktop/osmosis-0.35/lib/default/jpf-1.5.jar!/org/java/plugin/standard/jpf.properties</a><br>
May 2, 2010 2:06:42 PM org.java.plugin.ObjectFactory findProperty<br>
FINE: property org.java.plugin.ObjectFactory found in properties file<br>
May 2, 2010 2:06:42 PM org.java.plugin.ObjectFactory newInstance<br>
FINE: object factory instance created -
org.java.plugin.standard.StandardObjectFactory@10a2d64<br>
May 2, 2010 2:06:42 PM org.java.plugin.standard.StandardObjectFactory
getImplClassName<br>
FINE: implementation class for org.java.plugin.registry.PluginRegistry
is org.java.plugin.registry.xml.PluginRegistryImpl<br>
May 2, 2010 2:06:42 PM org.java.plugin.registry.xml.ManifestParser
<init><br>
INFO: got SAX parser factory -
org.apache.xerces.jaxp.SAXParserFactoryImpl@12b7eea<br>
May 2, 2010 2:06:42 PM org.java.plugin.registry.xml.PluginRegistryImpl
configure<br>
INFO: configured, stopOnError=false, isValidating=true<br>
May 2, 2010 2:06:42 PM org.java.plugin.standard.StandardObjectFactory
createRegistry<br>
FINE: registry instance created -
org.java.plugin.registry.xml.PluginRegistryImpl@99353f<br>
May 2, 2010 2:06:42 PM org.java.plugin.standard.StandardObjectFactory
getImplClassName<br>
FINE: implementation class for org.java.plugin.PathResolver is
org.java.plugin.standard.StandardPathResolver<br>
May 2, 2010 2:06:42 PM org.java.plugin.standard.StandardObjectFactory
createPathResolver<br>
FINE: path resolver instance created -
org.java.plugin.standard.StandardPathResolver@1112783<br>
May 2, 2010 2:06:42 PM org.java.plugin.standard.StandardObjectFactory
getImplClassName<br>
FINE: implementation class for
org.java.plugin.standard.PluginLifecycleHandler is
org.java.plugin.standard.StandardPluginLifecycleHandler<br>
May 2, 2010 2:06:42 PM
org.java.plugin.standard.StandardPluginLifecycleHandler configure<br>
FINE: probeParentLoaderLast parameter value is false<br>
May 2, 2010 2:06:42 PM org.java.plugin.standard.StandardObjectFactory
createLifecycleHandler<br>
FINE: life cycle handler instance created -
org.java.plugin.standard.StandardPluginLifecycleHandler@1238bd2<br>
May 2, 2010 2:06:42 PM org.openstreetmap.osmosis.core.TaskRegistrar
loadJPFPlugins<br>
FINE: Searching for JPF plugins.<br>
May 2, 2010 2:06:42 PM org.openstreetmap.osmosis.core.TaskRegistrar
loadJPFPlugins<br>
FINE: Registering the core plugin.<br>
May 2, 2010 2:06:42 PM org.java.plugin.registry.xml.ManifestParser$1
resolveEntity<br>
FINE: entity resolved to plug-in manifest DTD, publicId=-//JPF//Java
Plug-in Manifest 1.0, systemId=<a class="moz-txt-link-freetext" href="http://jpf.sourceforge.net/plugin_1_0.dtd">http://jpf.sourceforge.net/plugin_1_0.dtd</a><br>
May 2, 2010 2:06:42 PM org.java.plugin.registry.xml.ManifestHandler
startElement<br>
FINE: startElement - []/[]/[plugin]<br>
May 2, 2010 2:06:42 PM org.java.plugin.registry.xml.ManifestHandler
startElement<br>
FINE: startElement - []/[]/[extension-point]<br>
May 2, 2010 2:06:42 PM org.java.plugin.registry.xml.ManifestHandler
startElement<br>
FINE: startElement - []/[]/[parameter-def]<br>
May 2, 2010 2:06:42 PM org.java.plugin.registry.xml.ManifestHandler
endElement<br>
FINE: endElement - []/[]/[parameter-def]<br>
May 2, 2010 2:06:42 PM org.java.plugin.registry.xml.ManifestHandler
startElement<br>
FINE: startElement - []/[]/[parameter-def]<br>
May 2, 2010 2:06:42 PM org.java.plugin.registry.xml.ManifestHandler
endElement<br>
FINE: endElement - []/[]/[parameter-def]<br>
May 2, 2010 2:06:42 PM org.java.plugin.registry.xml.ManifestHandler
endElement<br>
FINE: endElement - []/[]/[extension-point]<br>
May 2, 2010 2:06:42 PM org.java.plugin.registry.xml.ManifestHandler
endElement<br>
FINE: endElement - []/[]/[plugin]<br>
May 2, 2010 2:06:42 PM org.java.plugin.registry.xml.PluginRegistryImpl
register<br>
FINE: manifest files parsed, plugins.size=1, fragments.size=0<br>
May 2, 2010 2:06:42 PM org.java.plugin.registry.xml.PluginRegistryImpl
register<br>
FINE: plug-ins versions checked, plugins.size=1<br>
May 2, 2010 2:06:42 PM org.java.plugin.registry.xml.PluginRegistryImpl
register<br>
FINE: plug-in fragments versions checked, fragments.size=0<br>
May 2, 2010 2:06:42 PM org.java.plugin.registry.xml.PluginRegistryImpl
registerPlugin<br>
FINE: registering plug-in, URL -
<a class="moz-txt-link-freetext" href="jar:file:/home/alex/Desktop/osmosis-0.35/osmosis.jar!/org/openstreetmap/osmosis/core/plugin/plugin.xml">jar:file:/home/alex/Desktop/osmosis-0.35/osmosis.jar!/org/openstreetmap/osmosis/core/plugin/plugin.xml</a><br>
May 2, 2010 2:06:42 PM
org.java.plugin.registry.xml.ExtensionPointImpl$ParameterDefinitionImpl
<init><br>
FINE: object instantiated: {PluginExtensionPoint.ParameterDefinition:
extPointUid=org.openstreetmap.osmosis.core.plugin.Core@Task; id=class}<br>
May 2, 2010 2:06:42 PM
org.java.plugin.registry.xml.ExtensionPointImpl$ParameterDefinitionImpl
<init><br>
FINE: object instantiated: {PluginExtensionPoint.ParameterDefinition:
extPointUid=org.openstreetmap.osmosis.core.plugin.Core@Task; id=name}<br>
May 2, 2010 2:06:42 PM org.java.plugin.registry.xml.ExtensionPointImpl
<init><br>
FINE: object instantiated: {ExtensionPoint:
uid=org.openstreetmap.osmosis.core.plugin.Core@Task}<br>
May 2, 2010 2:06:42 PM
org.java.plugin.registry.xml.PluginDescriptorImpl <init><br>
FINE: object instantiated: {PluginDescriptor:
<a class="moz-txt-link-abbreviated" href="mailto:uid=org.openstreetmap.osmosis.core.plugin.Core@0.35.0">uid=org.openstreetmap.osmosis.core.plugin.Core@0.35.0</a>}<br>
May 2, 2010 2:06:42 PM org.java.plugin.registry.xml.PluginRegistryImpl
register<br>
INFO: plug-in and fragment descriptors registered - 1<br>
May 2, 2010 2:06:42 PM org.java.plugin.registry.xml.PluginRegistryImpl
dump<br>
FINE: PLUG-IN REGISTRY DUMP:<br>
-------------- DUMP BEGIN -----------------<br>
Plug-ins: 1<br>
{PluginDescriptor:
<a class="moz-txt-link-abbreviated" href="mailto:uid=org.openstreetmap.osmosis.core.plugin.Core@0.35.0">uid=org.openstreetmap.osmosis.core.plugin.Core@0.35.0</a>}<br>
Fragments: 0<br>
Memory TOTAL/FREE/MAX: 35717120/31713048/500891648<br>
-------------- DUMP END -----------------<br>
<br>
May 2, 2010 2:06:42 PM
org.java.plugin.registry.xml.PluginRegistryImpl$RegistryChangeDataImpl
dump<br>
FINE: PLUG-IN REGISTRY CHANGES DUMP:<br>
-------------- DUMP BEGIN -----------------<br>
Added plug-ins: 1<br>
org.openstreetmap.osmosis.core.plugin.Core<br>
Removed plug-ins: 0<br>
Modified plug-ins: 0<br>
Added extensions: 0<br>
Removed extensions: 0<br>
Modified extensions: 0<br>
Memory TOTAL/FREE/MAX: 35717120/31713048/500891648<br>
-------------- DUMP END -----------------<br>
<br>
May 2, 2010 2:06:42 PM org.java.plugin.registry.xml.PluginRegistryImpl
fireEvent<br>
FINE: propagating registry change event<br>
May 2, 2010 2:06:42 PM org.java.plugin.registry.xml.PluginRegistryImpl
fireEvent<br>
FINE: registry change event propagated<br>
May 2, 2010 2:06:42 PM
org.java.plugin.standard.StandardPluginClassLoader getUrls<br>
FINE: Code URL's populated for plug-in {PluginDescriptor:
<a class="moz-txt-link-abbreviated" href="mailto:uid=org.openstreetmap.osmosis.core.plugin.Core@0.35.0">uid=org.openstreetmap.osmosis.core.plugin.Core@0.35.0</a>}:<br>
<br>
May 2, 2010 2:06:42 PM org.java.plugin.standard.StandardPluginManager
activatePlugin<br>
INFO: plug-in started -
<a class="moz-txt-link-abbreviated" href="mailto:org.openstreetmap.osmosis.core.plugin.Core@0.35.0">org.openstreetmap.osmosis.core.plugin.Core@0.35.0</a><br>
May 2, 2010 2:06:42 PM org.openstreetmap.osmosis.core.TaskRegistrar
loadJPFPlugins<br>
FINE: Registering the extension plugins.<br>
May 2, 2010 2:06:42 PM org.openstreetmap.osmosis.core.Osmosis run<br>
INFO: Preparing pipeline.<br>
May 2, 2010 2:06:42 PM
org.openstreetmap.osmosis.core.pipeline.common.Pipeline prepare<br>
FINE: Building tasks.<br>
May 2, 2010 2:06:42 PM
org.openstreetmap.osmosis.core.pipeline.common.Pipeline buildTasks<br>
FINE: Created task "1-read-xml"<br>
May 2, 2010 2:06:42 PM
org.openstreetmap.osmosis.core.pipeline.common.Pipeline buildTasks<br>
FINE: Created task "2-write-apidb"<br>
May 2, 2010 2:06:42 PM
org.openstreetmap.osmosis.core.pipeline.common.Pipeline prepare<br>
FINE: Connecting tasks.<br>
May 2, 2010 2:06:42 PM
org.openstreetmap.osmosis.core.pipeline.common.PipeTasks putTask<br>
FINE: Task "1-read-xml" produced unnamed pipe stored at level 1 in the
default pipe stack.<br>
May 2, 2010 2:06:42 PM
org.openstreetmap.osmosis.core.pipeline.common.Pipeline connectTasks<br>
FINE: Connected task "1-read-xml"<br>
May 2, 2010 2:06:42 PM
org.openstreetmap.osmosis.core.pipeline.common.PipeTasks retrieveTask<br>
FINE: Task "2-write-apidb" consumed unnamed pipe stored at level 1 in
the default pipe stack.<br>
May 2, 2010 2:06:42 PM
org.openstreetmap.osmosis.core.pipeline.common.Pipeline connectTasks<br>
FINE: Connected task "2-write-apidb"<br>
May 2, 2010 2:06:42 PM org.openstreetmap.osmosis.core.Osmosis run<br>
INFO: Launching pipeline execution.<br>
May 2, 2010 2:06:42 PM
org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager execute<br>
FINE: Launching task 1-read-xml in a new thread.<br>
May 2, 2010 2:06:42 PM
org.openstreetmap.osmosis.core.pipeline.common.PassiveTaskManager
execute<br>
FINE: Task 2-write-apidb is passive, no execution required.<br>
May 2, 2010 2:06:42 PM org.openstreetmap.osmosis.core.Osmosis run<br>
INFO: Pipeline executing, waiting for completion.<br>
May 2, 2010 2:06:42 PM
org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager
waitForCompletion<br>
FINE: Waiting for task 1-read-xml to complete.<br>
May 2, 2010 2:06:42 PM
org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager
waitForCompletion<br>
SEVERE: Thread for task 1-read-xml failed<br>
org.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to
create resultset.<br>
at
org.openstreetmap.osmosis.core.apidb.common.DatabaseContext.executeQuery(DatabaseContext.java:429)<br>
at
org.openstreetmap.osmosis.core.apidb.v0_6.impl.SchemaVersionValidator.validateDBVersion(SchemaVersionValidator.java:82)<br>
at
org.openstreetmap.osmosis.core.apidb.v0_6.impl.SchemaVersionValidator.validateVersion(SchemaVersionValidator.java:55)<br>
at
org.openstreetmap.osmosis.core.apidb.v0_6.ApidbWriter.initialize(ApidbWriter.java:288)<br>
at
org.openstreetmap.osmosis.core.apidb.v0_6.ApidbWriter.process(ApidbWriter.java:1046)<br>
at
org.openstreetmap.osmosis.core.xml.v0_6.impl.BoundElementProcessor.end(BoundElementProcessor.java:85)<br>
at
org.openstreetmap.osmosis.core.xml.v0_6.impl.OsmHandler.endElement(OsmHandler.java:107)<br>
at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown
Source)<br>
at
org.apache.xerces.parsers.AbstractXMLDocumentParser.emptyElement(Unknown
Source)<br>
at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown
Source)<br>
at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown
Source)<br>
at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown
Source)<br>
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown
Source)<br>
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown
Source)<br>
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)<br>
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)<br>
at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown
Source)<br>
at org.apache.xerces.jaxp.SAXParserImpl.parse(Unknown Source)<br>
at javax.xml.parsers.SAXParser.parse(SAXParser.java:195)<br>
at
org.openstreetmap.osmosis.core.xml.v0_6.XmlReader.run(XmlReader.java:108)<br>
at java.lang.Thread.run(Thread.java:636)<br>
Caused by: org.postgresql.util.PSQLException: ERROR: relation
"schema_migrations" does not exist<br>
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)<br>
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)<br>
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)<br>
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)<br>
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:336)<br>
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:235)<br>
at
org.openstreetmap.osmosis.core.apidb.common.DatabaseContext.executeQuery(DatabaseContext.java:424)<br>
... 20 more<br>
May 2, 2010 2:06:42 PM
org.openstreetmap.osmosis.core.pipeline.common.PassiveTaskManager
waitForCompletion<br>
FINE: Task 2-write-apidb is passive, no completion wait required.<br>
May 2, 2010 2:06:42 PM org.openstreetmap.osmosis.core.Osmosis main<br>
SEVERE: Execution aborted.<br>
org.openstreetmap.osmosis.core.OsmosisRuntimeException: One or more
tasks failed.<br>
at
org.openstreetmap.osmosis.core.pipeline.common.Pipeline.waitForCompletion(Pipeline.java:146)<br>
at org.openstreetmap.osmosis.core.Osmosis.run(Osmosis.java:85)<br>
at org.openstreetmap.osmosis.core.Osmosis.main(Osmosis.java:30)<br>
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br>
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)<br>
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br>
at java.lang.reflect.Method.invoke(Method.java:616)<br>
at
org.codehaus.plexus.classworlds.launcher.Launcher.launchStandard(Launcher.java:329)<br>
at
org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:239)<br>
at
org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:409)<br>
at
org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352)<br>
at org.codehaus.classworlds.Launcher.main(Launcher.java:31)<br>
<br>
<br>
<br>
</p>
<p>#####################################################################</p>
<p><br>
</p>
<p>sorry for the long message, but im not sure which parts are
important...</p>
<p><br>
</p>
<p>OS is Ubuntu 10.04, Postgres Version 8.4, Osmosis 0.35</p>
<p><br>
</p>
<p>I hope someone has got an idea.</p>
<p>Thanks<br>
</p>
<p><br>
</p>
</body>
</html>