Re: Connection problems after upgrading from 5.0.22 to 5.0.27 (connection refused)

[Brian Peter Thorsbro]

Unfortunately that is not my problem.

If I run the sql query a second time the client can reconnect and complete the query. I have looked a lot into the auto-reconnect feature of mysql java connector, but disabling nor enabling does not seem to affect the outcome. The problem is that the mysql server closes the connection prematurely (much much before the 8 hours timeout), and I have no clue why. With the same configuration it did not happen 5.0.22 (which Im now running), but I would like to be able to upgrade to newer versions!

What can it be that has been changed since 5.0.22 that has with connection closing?

my.cnf:

[mysqld]
max_connections=1000
open-files-limit=1000000
table_cache=2000
log-bin=test-bin
binlog-do-db=mydatabase

Java connector setup in context.xml:

<Resource
name="jdbc/MYDATABASE"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
initialSize="3"
maxActive="100"
maxIdle="4"
maxWait="5000"
username="*****"
password="*****"
removeAbandoned="true"
removeAbandonedTimeout="60"
logAbandoned="true"
url="jdbc:mysql://localhost/mydatabase"
/>



Edited 1 time(s). Last edit at 11/07/2006 09:59AM by Brian Peter Thorsbro.