[osmosis-dev] Classpath in Osmosis 0.31 again

Alexander Chmyr achmyr at cloudmade.com
Mon Nov 16 02:46:36 GMT 2009 

Hello Markus,

hope that this error required to be wrapped in something verbose (not an
exception thrown). If you want to load data into database, you need to know
what schema version hard-coded in osmosis for your bundle. To avoid db
validation, simply add *validateSchemaVers**ion=no *to db task and run. If
no way to proceed, just create required table.


Alexander Chmyr
Software Engineer
Cogniance, Inc
--------------------------
mobile: +38 097 358 0550
skype: alex.smudgy
-------------------------
http://cloudmade.com


On Sun, Nov 15, 2009 at 3:44 PM, Marcus Wolschon <Marcus at wolschon.biz>wrote:

> Okay, OpenJDK worked.
>
> Now I´m stuck with some postgres-stuff.
> it did create the table schema_info and it did insert 1 row
> into it.
>
>
> postgres at bbs:/root/osmosis-0.31$ cat
> script/pgsql_simple_schema_0.6.sql | psql osm
> HINWEIS:  Tabelle »actions« existiert nicht, wird Ìbersprungen
> DROP TABLE
> HINWEIS:  Tabelle »users« existiert nicht, wird Ìbersprungen
> DROP TABLE
> HINWEIS:  Tabelle »nodes« existiert nicht, wird Ìbersprungen
> DROP TABLE
> HINWEIS:  Tabelle »node_tags« existiert nicht, wird Ìbersprungen
> DROP TABLE
> HINWEIS:  Tabelle »ways« existiert nicht, wird Ìbersprungen
> DROP TABLE
> HINWEIS:  Tabelle »way_nodes« existiert nicht, wird Ìbersprungen
> DROP TABLE
> HINWEIS:  Tabelle »way_tags« existiert nicht, wird Ìbersprungen
> DROP TABLE
> HINWEIS:  Tabelle »relations« existiert nicht, wird Ìbersprungen
> DROP TABLE
> HINWEIS:  Tabelle »relation_members« existiert nicht, wird Ìbersprungen
> DROP TABLE
> HINWEIS:  Tabelle »relation_tags« existiert nicht, wird Ìbersprungen
> DROP TABLE
> HINWEIS:  Tabelle »schema_info« existiert nicht, wird Ìbersprungen
> DROP TABLE
> HINWEIS:  Funktion osmosisupdate() existiert nicht, wird ÃŒbersprungen
> DROP FUNCTION
> CREATE TABLE
> CREATE TABLE
> CREATE TABLE
>               addgeometrycolumn
> -----------------------------------------------
>  public.nodes.geom SRID:4326 TYPE:POINT DIMS:2
>
> (1 Zeile)
>
> CREATE TABLE
> CREATE TABLE
> CREATE TABLE
> CREATE TABLE
> CREATE TABLE
> CREATE TABLE
> CREATE TABLE
> INSERT 0 1
> HINWEIS:  ALTER TABLE / ADD PRIMARY KEY erstellt implizit einen Index
> »pk_schema_info« fÌr Tabelle »schema_info«
> ALTER TABLE
> HINWEIS:  ALTER TABLE / ADD PRIMARY KEY erstellt implizit einen Index
> »pk_users« fÌr Tabelle »users«
> ALTER TABLE
> HINWEIS:  ALTER TABLE / ADD PRIMARY KEY erstellt implizit einen Index
> »pk_nodes« fÌr Tabelle »nodes«
> ALTER TABLE
> HINWEIS:  ALTER TABLE / ADD PRIMARY KEY erstellt implizit einen Index
> »pk_ways« fÌr Tabelle »ways«
> ALTER TABLE
> HINWEIS:  ALTER TABLE / ADD PRIMARY KEY erstellt implizit einen Index
> »pk_way_nodes« fÌr Tabelle »way_nodes«
> ALTER TABLE
> HINWEIS:  ALTER TABLE / ADD PRIMARY KEY erstellt implizit einen Index
> »pk_relations« fÌr Tabelle »relations«
> ALTER TABLE
> CREATE INDEX
> CREATE INDEX
> CREATE INDEX
> CREATE INDEX
> CREATE INDEX
> CREATE FUNCTION
> postgres at bbs:/root/osmosis-0.31$ cat ../
> apidb06-pgsql-latest.sql    .aptitude/                  .bashrc
>             germany.osm.bz2             .lesshst
> osmosis-0.31/               .profile                    .Xauthority
> apidb06-pgsql-latest.sql.1  .bash_history               .debtags/
>             import_germany              .mc/
> osmosis-latest-bin.tar.gz   .ssh/
> postgres at bbs:/root/osmosis-0.31$ cat ../import_germany
> ./bin/osmosis --read-xml file=../germany.osm.bz2 --write-pgsql
> postgres at bbs:/root/osmosis-0.31$ ./bin/osmosis --read-xml
> file=../germany.osm.bz2 --write-pgsql user=osm password=osm
> database=osm
> 15.11.2009 15:16:26 org.openstreetmap.osmosis.core.Osmosis run
> INFO: Osmosis Version 0.31
> 15.11.2009 15:16:26 org.openstreetmap.osmosis.core.Osmosis run
> INFO: Preparing pipeline.
> 15.11.2009 15:16:27 org.openstreetmap.osmosis.core.Osmosis run
> INFO: Launching pipeline execution.
> 15.11.2009 15:16:27 org.openstreetmap.osmosis.core.Osmosis run
> INFO: Pipeline executing, waiting for completion.
> 15.11.2009 15:16:27
> org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager
> waitForCompletion
> SCHWERWIEGEND: Thread for task 1-read-xml failed
> org.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to read
> the schema version from the schema info table.
>        at
> org.openstreetmap.osmosis.core.pgsql.common.SchemaVersionValidator.validateDBVersion(SchemaVersionValidator.java:92)
>         at
> org.openstreetmap.osmosis.core.pgsql.common.SchemaVersionValidator.validateVersion(SchemaVersionValidator.java:52)
>        at
> org.openstreetmap.osmosis.core.pgsql.v0_6.PostgreSqlWriter.initialize(PostgreSqlWriter.java:242)
>        at
> org.openstreetmap.osmosis.core.pgsql.v0_6.PostgreSqlWriter.process(PostgreSqlWriter.java:902)
>        at
> org.openstreetmap.osmosis.core.xml.v0_6.impl.BoundElementProcessor.end(BoundElementProcessor.java:85)
>        at
> org.openstreetmap.osmosis.core.xml.v0_6.impl.OsmHandler.endElement(OsmHandler.java:108)
>         at
> com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(Unknown
> Source)
>        at
> com.sun.org.apache.xerces.internal.parsers.AbstractXMLDocumentParser.emptyElement(Unknown
> Source)
>        at
> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown
> Source)
>        at
> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(Unknown
> Source)
>        at
> com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown
> Source)
>        at
> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown
> Source)
>        at
> com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown
> Source)
>        at
> com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown
> Source)
>        at
> com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown
> Source)
>        at
> com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown
> Source)
>        at
> com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown
> Source)
>        at javax.xml.parsers.SAXParser.parse(Unknown Source)
>        at javax.xml.parsers.SAXParser.parse(Unknown Source)
>         at
> org.openstreetmap.osmosis.core.xml.v0_6.XmlReader.run(XmlReader.java:108)
>         at java.lang.Thread.run(Thread.java:636)
> Caused by: org.postgresql.util.PSQLException: FEHLER: keine
> Berechtigung fÃŒr Relation schema_info
>        at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
>        at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
>        at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
>        at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
>        at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:336)
>        at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:235)
>        at
> org.openstreetmap.osmosis.core.pgsql.common.SchemaVersionValidator.validateDBVersion(SchemaVersionValidator.java:73)
>        ... 20 more
> 15.11.2009 15:16:27 org.openstreetmap.osmosis.core.Osmosis main
> SCHWERWIEGEND: 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:85)
>        at org.openstreetmap.osmosis.core.Osmosis.main(Osmosis.java:30)
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/osmosis-dev/attachments/20091116/31de6379/attachment.html>

More information about the osmosis-dev mailing list