Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Received-SPF: neutral (athena.apache.org: local policy)
Message-ID: <1D047656994E45CF9351FABB5C6D33DD@JSR2006>
From: "Steve Ryder" <sryder@jsrsys.com>
To: <users@tomcat.apache.org>
Subject: Tomcat5.5 MySQL14.12 java.net.SocketException: Broken pipe
Date: Wed, 6 Oct 2010 22:18:51 -0500
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=original
Content-Transfer-Encoding: 7bit

I am getting this during mysql connection (about once a week).
I have read the thread on MySQL forum, which has a "solution", but the link 
to the solution is broken and points back to the same page.
Suggestions have been use autoconnect=true
Another was that the server timeout was shorter than the connection 
time-out.
I have the following:
In server.xml:
<Connector port="80" maxHttpHeaderSize="8192"
               maxThreads="192" minSpareThreads="32" maxSpareThreads="128"
               enableLookups="false" redirectPort="8443" acceptCount="128"
               connectionTimeout="20000" disableUploadTimeout="true" />
In context.xml
<Resource name="jdbc/MySql" auth="Container" type="javax.sql.DataSource"
  url="jdbc:mysql://localhost.localdomain/rsa?autoReconnect=true"
     factory="org.apache.commons.dbcp.BasicDataSourceFactory"
  driverClassName="com.mysql.jdbc.Driver"
  password="jsrsys" username="jsrsys"
     maxWait="10000"   maxActive="200"  maxIdle="5"
   removeAbandoned="true" removeAbandonedTimeout="300" logAbandoned="true"
 />
Note that maxWait is 1/2 of connectionTimeout and I have autoReconnect=true.
Any ideas.   This is low priority as users are able to reconnect by just 
pressing Refresh, but I would like this to go away. 


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org