Skip navigation links

MySQL Forums :: Connector/JDBC and Java :: MySQL java.net.SocketException: Broken pipe


Advanced Search

Re: MySQL java.net.SocketException: Broken pipe
Posted by: Jeyendran Balakrishnan ()
Date: August 31, 2009 06:33PM

Hello,

I am also getting the same kind of exception after the server has been runing for a while:

My system configuration:
* Tomcat 6.0.18
* mySQL 5.0.45
* Database connection type: Java JPA
* JPA library: Oracle TopLink Essentials - 2.0.1 (Build b09d-fcs (12/06/2007))
* No connection pooling of any kind.

Exception:
[TopLink Warning]: 2009.08.31 04:41:43.369--ClientSession(25914126)--Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.0.1 (Build b09d-fcs (12/06/2007))): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Broken pipe

STACKTRACE:

java.net.SocketException: Broken pipe
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:110)
at java.net.SocketOutputStream.write(SocketOutputStream.java:154)
at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:83)
at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:141)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2744)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:5442)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicBeginTransaction(DatabaseAccessor.java:174)
at oracle.toplink.essentials.internal.databaseaccess.DatasourceAccessor.beginTransaction(DatasourceAccessor.java:159)
at oracle.toplink.essentials.internal.sessions.AbstractSession.basicBeginTransaction(AbstractSession.java:298)
at oracle.toplink.essentials.threetier.ClientSession.basicBeginTransaction(ClientSession.java:138)
at oracle.toplink.essentials.internal.sessions.AbstractSession.beginTransaction(AbstractSession.java:393)
at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.beginTransaction(UnitOfWorkImpl.java:433)
at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1008)
at oracle.toplink.essentials.internal.ejb.cmp3.base.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:403)
at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1126)
at oracle.toplink.essentials.internal.ejb.cmp3.base.RepeatableWriteUnitOfWork.commitRootUnitOfWork(RepeatableWriteUnitOfWork.java:107)
at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitAndResume(UnitOfWorkImpl.java:856)
at oracle.toplink.essentials.internal.ejb.cmp3.transaction.base.EntityTransactionImpl.commit(EntityTransactionImpl.java:102)
at oracle.toplink.essentials.internal.ejb.cmp3.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:60)
at com.personaltube.db.impl.rdb.CResourceLocalDBManager.endTransaction(CResourceLocalDBManager.java:163)

where the last line calls:
em.getTransaction().commit()

So the exception occurs while the EntityManager is trying to commit the transaction. My transaction here is merely trying to add a row to a table.

mySQL shell seems to be working fine and I can manually do CRUD operations on the same table.

Please help, I don't know of any solutions that can help.

Thanks a lot.

Options: ReplyQuote


Subject Written By Posted
MySQL java.net.SocketException: Broken pipe Leo Chan 09/04/2005 07:54PM
Re: MySQL java.net.SocketException: Broken pipe Mark Matthews 09/04/2005 09:40PM
Re: MySQL java.net.SocketException: Broken pipe Leo Chan 09/05/2005 01:50AM
Re: MySQL java.net.SocketException: Broken pipe Simon Haldon 02/23/2006 10:48AM
Re: MySQL java.net.SocketException: Broken pipe Mark Matthews 02/23/2006 10:52AM
Re: MySQL java.net.SocketException: Broken pipe Simon Haldon 02/23/2006 10:57AM
Re: MySQL java.net.SocketException: Broken pipe vzelenko 03/02/2006 09:17AM
Re: MySQL java.net.SocketException: Broken pipe Anderson Meirelles 03/08/2006 07:41AM
Re: MySQL java.net.SocketException: Broken pipe Mark Matthews 03/08/2006 07:48AM
Re: MySQL java.net.SocketException: Broken pipe Anderson Meirelles Freitas 03/08/2006 08:37AM
Re: MySQL java.net.SocketException: Broken pipe Mark Matthews 03/08/2006 08:43AM
Re: MySQL java.net.SocketException: Broken pipe YoungSun Kim 04/30/2006 11:18PM
Re: MySQL java.net.SocketException: Broken pipe Tae Yeon Jeon 06/15/2006 01:39AM
Re: MySQL java.net.SocketException: Broken pipe lv qi 07/18/2006 08:18PM
Re: MySQL java.net.SocketException: Broken pipe Allwyn Hill 04/18/2006 01:20PM
Re: MySQL java.net.SocketException: Broken pipe Anson Parker 04/22/2006 07:19PM
Re: MySQL java.net.SocketException: Broken pipe Martin Malo 05/09/2006 01:40PM
Re: MySQL java.net.SocketException: Broken pipe Karikalan Kumaresan 10/05/2006 11:33PM
Re: MySQL java.net.SocketException: Broken pipe Mark Matthews 10/06/2006 11:45AM
Re: MySQL java.net.SocketException: Broken pipe Dmitry Kobyleha 06/16/2008 04:30AM
Re: MySQL java.net.SocketException: Broken pipe shivam shah 02/28/2006 12:46AM
Re: MySQL java.net.SocketException: Broken pipe Steve Reber 09/22/2006 08:05AM
Re: MySQL java.net.SocketException: Broken pipe Lavanya Rathnakumar 06/19/2009 06:45AM
Re: MySQL java.net.SocketException: Broken pipe Jeyendran Balakrishnan 08/31/2009 06:33PM
Re: MySQL java.net.SocketException: Broken pipe suda Murali 11/29/2009 10:18AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.