Write failed: Broken pipe => com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException:

[Migrated From Jforum.net]

I am using JForum 2.1.8 and am finding that I am getting the following error randomly but often:

An error has occurred.

For detailed error information, please see the HTML source code, and contact the forum Administrator.

com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Communications link failure due to underlying exception: 

** BEGIN NESTED EXCEPTION ** 

java.net.SocketException
MESSAGE: Write failed: Broken pipe

STACKTRACE:

java.net.SocketException: Write failed: Broken pipe
	at jrockit.net.SocketNativeIO.writeBytesPinned(Native Method)
	at jrockit.net.SocketNativeIO.socketWrite(SocketNativeIO.java:73)
	at java.net.SocketOutputStream.socketWrite0(SocketOutputStream.java)
	at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
	at java.net.SocketOutputStream.write(SocketOutputStream.java:137)
	at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:66)
	at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:124)
	at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2637)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1554)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:3124)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1149)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1262)
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
	at net.jforum.dao.generic.GenericForumDAO.isUserSubscribed(GenericForumDAO.java:887)
	at net.jforum.view.forum.ForumAction.show(ForumAction.java:215)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at net.jforum.Command.process(Command.java:114)
	at net.jforum.JForum.processCommand(JForum.java:233)
	at net.jforum.JForum.service(JForum.java:216)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:804)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:60)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)
	at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
	at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:73)
	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
	at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:112)
	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
	at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:82)
	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
	at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:218)
	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
	at net.tootired.security.logout.CasLogoutCallbackFilter.doFilter(CasLogoutCallbackFilter.java:78)
	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
	at net.tootired.security.logout.CasLogoutFilter.doFilter(CasLogoutFilter.java:176)
	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
	at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:229)
	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
	at org.acegisecurity.securechannel.ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java:139)
	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
	at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
	at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:111)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:585)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
	at java.lang.Thread.run(Thread.java:619)


** END NESTED EXCEPTION **



Last packet sent to the server was 1 ms ago.

Query being executed when exception was thrown:

SELECT user_id FROM jforum_forums_watch WHERE forum_id = 1 AND user_id = 4

I think the error generally appears after I leave the page alone for a time (an hour or more) and then come back and try to go to another page (or hit the back button). Although this error is random, I can also reproduce it by killing the connection in MySQL Administrator by doing the following:

Go to the home page and click on the 'Test Forum' link;

Open MySQL Administrator on the 'Server Connections' pane and kill the connections to JForum;

Refresh the page in JForum and the error will occur;

Refresh the page again and JForum gets a new connection and shows the page.

The last three items are repeatable. I am using the:

database.connection.implementation = net.jforum.PooledConnection
c3p0.extra.params = checkoutTimeout=120000;debugUnreturnedConnectionStackTraces=true;unreturnedConnectionTimeout=180

I got the above debug by changing the debugUnreturnedConnectionStackTraces to true.

I would guess that once a connection times out JForum does not immediatly get a new connection on the next request but waits until the request afterwards to do so.

Any ideas please?
[originally posted on jforum.net by klogger]

[Migrated From Jforum.net]

It looks like the server is closing the TCP/IP DB connections before the C3P0 pooling agent does. So the pooling agent is supplying connections that have been closed.

A couple of quick thoughts on how to fix this are... MySQL's JDBC driver URL has an autoReconnect parameter. Check that the URL in your config file has autoReconnect=true on it (and check the docs that I remembered this right).

Another possibility is that you either need to lengthen the connection timeout on the MySQL server or shorten the C3p0 pooling time to be less than the MySQL server timeout.


[originally posted on jforum.net by monroe]

[Migrated From Jforum.net]

Thanks for the suggestion, they have given me a place to start looking into this problem.

I am really not sure what I am doing when it comes to the details of MySQL Administration or C3P0.

I assume that if I kill the threads to JForum through MySQL Administrator, then refresh the JForum page, I should actually get the page as I expect rather than the error message? My Assumption would be that if the thread has died, then C3P0 should start a new thread for this connection as it is a fresh request.

As I cannot really re-produce this error without killing the thread in MySQL Administrator, I will just need to wait and see if the changes I made had any effect. The changes I have made are:

Setting maxIdleTime=120 on the c3p0.extra.params

Setting connect_timeout to 150 (I assume it is in seconds as the default is 5) through a MySQL console

Does they look like sensible things to try?

With the above setting, if I kill the thread in MySQL Administrator, I still get the error message.


[originally posted on jforum.net by klogger]

[Migrated From Jforum.net]

I have the same issue in my website.

I have set autoReconnect=true ,but this issue still exist.
I have changed the mysql driver, but this issue still exist.
[originally posted on jforum.net by lynx286]