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 > [email protected] > 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 > >
_______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
