[osmosis-dev] Classpath in Osmosis 0.31 again

[Marcus Wolschon]

On Mon, Nov 16, 2009 at 3:46 AM, Alexander Chmyr <achmyr at cloudmade.com> wrote:
> 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 validateSchemaVersion=no to db task and run. If no
> way to proceed, just create required table.


That is strange because it happened 2 seconds after I just created that database
using the script "script/pgsql_simple_schema_0.6.sql" supplied with the same
osmosis-0.31 -version.

With validateSchemaVersion=no I get
" Berechtigung nur für Eigentümer der Relation users"
As I said, I created that database so the current user is the owner of
all tables in it.

Marcus


postgres at bbs:/root/osmosis-0.31$ ./bin/osmosis --read-xml
file=../germany.osm.bz2 --write-pgsql user=osm password=osm
database=osm validateSchemaVersion=no
16.11.2009 07:54:42 org.openstreetmap.osmosis.core.Osmosis run
INFO: Osmosis Version 0.31
16.11.2009 07:54:42 org.openstreetmap.osmosis.core.Osmosis run
INFO: Preparing pipeline.
16.11.2009 07:54:43 org.openstreetmap.osmosis.core.Osmosis run
INFO: Launching pipeline execution.
16.11.2009 07:54:43 org.openstreetmap.osmosis.core.Osmosis run
INFO: Pipeline executing, waiting for completion.
16.11.2009 07:54:43
org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager
waitForCompletion
SCHWERWIEGEND: Thread for task 1-read-xml failed
org.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to
execute statement.
        at org.openstreetmap.osmosis.core.pgsql.common.DatabaseContext.executeStatement(DatabaseContext.java:106)
        at org.openstreetmap.osmosis.core.pgsql.v0_6.PostgreSqlWriter.initialize(PostgreSqlWriter.java:281)
        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: Berechtigung nur
fÃŒr EigentÃŒmer der Relation users
        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.execute(AbstractJdbc2Statement.java:328)
        at org.openstreetmap.osmosis.core.pgsql.common.DatabaseContext.executeStatement(DatabaseContext.java:103)
        ... 19 more