[OSM-dev] Osmosis cannot connect to Database

Sun Jan 4 22:41:39 GMT 2009

I installed it from Sun. You can see it in the trace below my entry:

"...at com.sun.org.apache..."

Roberto Navoni schrieb:
> 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
>>
>>   
>
>