Re: [OSM-dev] Osmosis on OpenSuse with MySQL

[Shaun McDonald]

Do you have tables in the database as per the main site. osmosis doesn't automatically create the tables by default.

For setting up please see:
http://wiki.openstreetmap.org/index.php/Rails

Shaun

On 7 Nov 2008, at 07:43, Richard Chirgwin wrote:

Hi,

Osmosis has installed okay, and I can read-write from and to XML. But
running to a database, things fall over. The full error is below my
signature.

Environment:
- OpenSUSE 10.3 with MySQL Server 5.0.45
- Osmosis 0.29

There is a database called osm, and a user account "osmosis" with
password "osmosis" on localhost.

So the command line is:
osmosis --read-xml file="/home/richard/planet.osm" --write-mysql
host="localhost" database="osm" user="osmosis" password="osmosis"

The failure seems to occur on schema_info:
SEVERE: Thread for task 1-read-xml failed
com.bretth.osmosis.core.OsmosisRuntimeException: Unable to create
streaming resultset.
[snip]
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table
'osm.schema_info' doesn't exist

Is there something I need to do to create the schema_info table, so as
to allow Osmosis to run?

Richard

Richard
SEVERE: Thread for task 1-read-xml failed
com.bretth.osmosis.core.OsmosisRuntimeException: Unable to create
streaming resultset.
       at

       at

       at

       at

       at

       at

       at

       at

       at

       at

       at

       at

       at

       at

       at

       at

       at

       at

       at javax.xml.parsers.SAXParser.parse(SAXParser.java:395)
       at javax.xml.parsers.SAXParser.parse(SAXParser.java:198)
       at
com.bretth.osmosis.core.xml.v0_5.XmlReader.run(XmlReader.java:109)
       at java.lang.Thread.run(Thread.java:619)
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table
'osm.schema_info' doesn't exist

       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
       at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
       at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
       at com.mysql.jdbc.Connection.execSQL(Connection.java:3250)
       at com.mysql.jdbc.Connection.execSQL(Connection.java:3179)
       at com.mysql.jdbc.Statement.executeQuery(Statement.java:1207)
       at

       ... 21 more
Nov 7, 2008 6:29:10 PM com.bretth.osmosis.core.Osmosis main
SEVERE: Execution aborted.

       at

       at com.bretth.osmosis.core.Osmosis.main(Osmosis.java:55)


_______________________________________________
dev mailing list
dev@openstreetmap.org
http://lists.openstreetmap.org/listinfo/dev

com .bretth .osmosis .core .mysql .common.DatabaseContext.executeStreamingQuery(DatabaseContext.java: 209) com .bretth .osmosis .core .mysql .common .SchemaVersionValidator .validateDBVersion(SchemaVersionValidator.java:63) com .bretth .osmosis .core .mysql .common .SchemaVersionValidator.validateVersion(SchemaVersionValidator.java: 45) com .bretth .osmosis.core.mysql.v0_5.MysqlWriter.initialize(MysqlWriter.java:316) com .bretth.osmosis.core.mysql.v0_5.MysqlWriter.process(MysqlWriter.java: 1004) com .bretth .osmosis .core .xml.v0_5.impl.NodeElementProcessor.end(NodeElementProcessor.java:99) com .bretth .osmosis.core.xml.v0_5.impl.OsmHandler.endElement(OsmHandler.java:109) com .sun .org .apache .xerces .internal .parsers.AbstractSAXParser.endElement(AbstractSAXParser.java:601) com .sun .org .apache .xerces .internal .parsers .AbstractXMLDocumentParser .emptyElement(AbstractXMLDocumentParser.java:180) com .sun .org .apache .xerces .internal .impl .XMLDocumentFragmentScannerImpl .scanStartElement(XMLDocumentFragmentScannerImpl.java:1339) com .sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl $FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2747) com .sun .org .apache .xerces .internal .impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:648) com .sun .org .apache .xerces .internal .impl .XMLDocumentFragmentScannerImpl .scanDocument(XMLDocumentFragmentScannerImpl.java:510) com .sun .org .apache .xerces .internal.parsers.XML11Configuration.parse(XML11Configuration.java: 807) com .sun .org .apache .xerces .internal.parsers.XML11Configuration.parse(XML11Configuration.java: 737) com .sun .org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java: 107) com .sun .org .apache .xerces .internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1205) com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl $JAXPSAXParser.parse(SAXParserImpl.java:522) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java: 936) com .bretth .osmosis .core .mysql .common.DatabaseContext.executeStreamingQuery(DatabaseContext.java: 204) com.bretth.osmosis.core.OsmosisRuntimeException: One or more tasks failed. com .bretth .osmosis .core.pipeline.common.Pipeline.waitForCompletion(Pipeline.java:141)

smime.p7s
Description: S/MIME cryptographic signature

_______________________________________________
dev mailing list
dev@openstreetmap.org
http://lists.openstreetmap.org/listinfo/dev