[OSM-dev] Osmosis cannot connect to Database

Roberto Navoni r.navoni at radionav.it
Sun Jan 4 21:28:40 GMT 2009 

One week ago,
I had the same problem . Check if you are using sun java virtual machine 
... don't use other kind of java machine because you can have some 
problem with db .
Best Regards
Roberto Navoni
> Hi,
>
> suddenly Osmosis does not connect any more to my database. The first 
> time this happend was while I was updating a database with a changefile. 
> When I tried to repeat the update the problem was there from the beginning.
>
> - Connection data is correct (PHP connects successfully)
> - Both initializing and updating does not work any more
> - Reinstalling Osmosis 0.29 does not work, too.
>
> The possible cause is that I apt-get upgraded my system and I use MySQL 
> 5.0.75-1-log (Debian) now. The mailing list shows one thread for this 
> issue, but there is no real solution ( 
> http://lists.openstreetmap.org/pipermail/dev/2007-August/006068.html )
>
> Andi
>
>
> Output:
>
> Jan 4, 2009 9:42:58 PM com.bretth.osmosis.core.Osmosis main
> INFO: Osmosis Version 0.29
> Jan 4, 2009 9:42:58 PM com.bretth.osmosis.core.Osmosis main
> INFO: Preparing pipeline.
> Jan 4, 2009 9:42:58 PM com.bretth.osmosis.core.Osmosis main
> INFO: Launching pipeline execution.
> Jan 4, 2009 9:42:58 PM com.bretth.osmosis.core.Osmosis main
> INFO: Pipeline executing, waiting for completion.
> Jan 4, 2009 9:42:59 PM 
> com.bretth.osmosis.core.pipeline.common.ActiveTaskManager waitForCompletion
> SEVERE: Thread for task 1-read-xml failed
> com.bretth.osmosis.core.OsmosisRuntimeException: Unable to establish a 
> database connection.
>         at 
> com.bretth.osmosis.core.mysql.common.DatabaseContext.getConnection(DatabaseContext.java:92)
>         at 
> com.bretth.osmosis.core.mysql.common.DatabaseContext.prepareStatement(DatabaseContext.java:131)
>         at 
> com.bretth.osmosis.core.mysql.v0_5.MysqlWriter.initialize(MysqlWriter.java:319)
>         at 
> com.bretth.osmosis.core.mysql.v0_5.MysqlWriter.process(MysqlWriter.java:1004)
>         at 
> com.bretth.osmosis.core.xml.v0_5.impl.NodeElementProcessor.end(NodeElementProcessor.java:99)
>         at 
> com.bretth.osmosis.core.xml.v0_5.impl.OsmHandler.endElement(OsmHandler.java:109)
>         at 
> com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(AbstractSAXParser.java:601)
>         at 
> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanEndElement(XMLDocumentFragmentScannerImpl.java:1774)
>         at 
> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2930)
>         at 
> com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:648)
>         at 
> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:510)
>         at 
> com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:807)
>         at 
> com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:737)
>         at 
> com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:107)
>         at 
> com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1205)
>         at 
> com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:522)
>         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.CommunicationsException: Communications link 
> failure due to underlying exception:
>
> ** BEGIN NESTED EXCEPTION **
>
> com.mysql.jdbc.CommunicationsException
> MESSAGE: Communications link failure due to underlying exception:
>
> ** BEGIN NESTED EXCEPTION **
>
> java.io.EOFException
> MESSAGE: Can not read response from server. Expected to read 4 bytes, 
> read 0 bytes before connection was unexpectedly lost.
>
> STACKTRACE:
>
> java.io.EOFException: Can not read response from server. Expected to 
> read 4 bytes, read 0 bytes before connection was unexpectedly lost.
>         at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1997)
>         at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:573)
>         at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1044)
>         at com.mysql.jdbc.Connection.createNewIO(Connection.java:2748)
>         at com.mysql.jdbc.Connection.<init>(Connection.java:1553)
>         at 
> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
>         at java.sql.DriverManager.getConnection(DriverManager.java:582)
>         at java.sql.DriverManager.getConnection(DriverManager.java:207)
>         at 
> com.bretth.osmosis.core.mysql.common.DatabaseContext.getConnection(DatabaseContext.java:81)
>         at 
> com.bretth.osmosis.core.mysql.common.DatabaseContext.prepareStatement(DatabaseContext.java:131)
>         at 
> com.bretth.osmosis.core.mysql.v0_5.MysqlWriter.initialize(MysqlWriter.java:319)
>         at 
> com.bretth.osmosis.core.mysql.v0_5.MysqlWriter.process(MysqlWriter.java:1004)
>         at 
> com.bretth.osmosis.core.xml.v0_5.impl.NodeElementProcessor.end(NodeElementProcessor.java:99)
>         at 
> com.bretth.osmosis.core.xml.v0_5.impl.OsmHandler.endElement(OsmHandler.java:109)
>         at 
> com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(AbstractSAXParser.java:601)
>         at 
> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanEndElement(XMLDocumentFragmentScannerImpl.java:1774)
>         at 
> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2930)
>         at 
> com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:648)
>         at 
> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:510)
>         at 
> com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:807)
>         at 
> com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:737)
>         at 
> com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:107)
>         at 
> com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1205)
>         at 
> com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:522)
>         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)
>
>
> ** END NESTED EXCEPTION **
>
>
>
> Last packet sent to the server was 3 ms ago.
>
> STACKTRACE:
>
> com.mysql.jdbc.CommunicationsException: Communications link failure due 
> to underlying exception:
>
> ** BEGIN NESTED EXCEPTION **
>
> java.io.EOFException
> MESSAGE: Can not read response from server. Expected to read 4 bytes, 
> read 0 bytes before connection was unexpectedly lost.
>
> STACKTRACE:
>
> java.io.EOFException: Can not read response from server. Expected to 
> read 4 bytes, read 0 bytes before connection was unexpectedly lost.
>         at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1997)
>         at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:573)
>         at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1044)
>         at com.mysql.jdbc.Connection.createNewIO(Connection.java:2748)
>         at com.mysql.jdbc.Connection.<init>(Connection.java:1553)
>         at 
> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
>         at java.sql.DriverManager.getConnection(DriverManager.java:582)
>         at java.sql.DriverManager.getConnection(DriverManager.java:207)
>         at 
> com.bretth.osmosis.core.mysql.common.DatabaseContext.getConnection(DatabaseContext.java:81)
>         at 
> com.bretth.osmosis.core.mysql.common.DatabaseContext.prepareStatement(DatabaseContext.java:131)
>         at 
> com.bretth.osmosis.core.mysql.v0_5.MysqlWriter.initialize(MysqlWriter.java:319)
>         at 
> com.bretth.osmosis.core.mysql.v0_5.MysqlWriter.process(MysqlWriter.java:1004)
>         at 
> com.bretth.osmosis.core.xml.v0_5.impl.NodeElementProcessor.end(NodeElementProcessor.java:99)
>         at 
> com.bretth.osmosis.core.xml.v0_5.impl.OsmHandler.endElement(OsmHandler.java:109)
>         at 
> com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(AbstractSAXParser.java:601)
>         at 
> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanEndElement(XMLDocumentFragmentScannerImpl.java:1774)
>         at 
> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2930)
>         at 
> com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:648)
>         at 
> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:510)
>         at 
> com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:807)
>         at 
> com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:737)
>         at 
> com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:107)
>         at 
> com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1205)
>         at 
> com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:522)
>         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)
>
>
> ** END NESTED EXCEPTION **
>
>
>
> Last packet sent to the server was 3 ms ago.
>         at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:641)
>         at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1044)
>         at com.mysql.jdbc.Connection.createNewIO(Connection.java:2748)
>         at com.mysql.jdbc.Connection.<init>(Connection.java:1553)
>         at 
> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
>         at java.sql.DriverManager.getConnection(DriverManager.java:582)
>         at java.sql.DriverManager.getConnection(DriverManager.java:207)
>         at 
> com.bretth.osmosis.core.mysql.common.DatabaseContext.getConnection(DatabaseContext.java:81)
>         at 
> com.bretth.osmosis.core.mysql.common.DatabaseContext.prepareStatement(DatabaseContext.java:131)
>         at 
> com.bretth.osmosis.core.mysql.v0_5.MysqlWriter.initialize(MysqlWriter.java:319)
>         at 
> com.bretth.osmosis.core.mysql.v0_5.MysqlWriter.process(MysqlWriter.java:1004)
>         at 
> com.bretth.osmosis.core.xml.v0_5.impl.NodeElementProcessor.end(NodeElementProcessor.java:99)
>         at 
> com.bretth.osmosis.core.xml.v0_5.impl.OsmHandler.endElement(OsmHandler.java:109)
>         at 
> com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(AbstractSAXParser.java:601)
>         at 
> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanEndElement(XMLDocumentFragmentScannerImpl.java:1774)
>         at 
> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2930)
>         at 
> com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:648)
>         at 
> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:510)
>         at 
> com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:807)
>         at 
> com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:737)
>         at 
> com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:107)
>         at 
> com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1205)
>         at 
> com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:522)
>         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)
>
>
> ** END NESTED EXCEPTION **
>
>
>
> Last packet sent to the server was 0 ms ago.
>         at com.mysql.jdbc.Connection.createNewIO(Connection.java:2820)
>         at com.mysql.jdbc.Connection.<init>(Connection.java:1553)
>         at 
> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
>         at java.sql.DriverManager.getConnection(DriverManager.java:582)
>         at java.sql.DriverManager.getConnection(DriverManager.java:207)
>         at 
> com.bretth.osmosis.core.mysql.common.DatabaseContext.getConnection(DatabaseContext.java:81)
>         ... 19 more
> Jan 4, 2009 9:42:59 PM com.bretth.osmosis.core.Osmosis main
> SEVERE: Execution aborted.
> com.bretth.osmosis.core.OsmosisRuntimeException: One or more tasks failed.
>         at 
> com.bretth.osmosis.core.pipeline.common.Pipeline.waitForCompletion(Pipeline.java:141)
>         at com.bretth.osmosis.core.Osmosis.main(Osmosis.java:55)
>
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/dev
> ------------------------------------------------------------------------
>
>
> Nessun virus nel messaggio in arrivo.
> Controllato da AVG - http://www.avg.com 
> Versione: 8.0.176 / Database dei virus: 270.10.2/1874 -  Data di rilascio: 04/01/2009 16.32
>
>

More information about the dev mailing list