Bug #4585 MySQL servers does not reconnect
Submitted: 17 Jul 2004 19:02 Modified: 15 Sep 2004 12:49
Reporter: Johan Andersson Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S2 (Serious)
Version:mysql-4.1 bk src OS:Linux (RH 9)
Assigned to: Magnus Blåudd CPU Architecture:Any

[17 Jul 2004 19:02] Johan Andersson
Description:
If entire DB cluster goes down, then the mysqld servers should retry 
connecting to the DB. The mysql servers must not give up trying to reconnect to 
DB nodes.

If the mysqld is not restarted after a cluster restart and a query is executed on that mysqld, then the mysqld will crash. Not so nice.

How to repeat:
1. restart cluster
2. issue a query on one mysqld server

Suggested fix:
Let be there be a configurable option (--ndbcluster_timeout)  for how long the mysqld should try to reconnect to the db nodes. --ndbcluster_timeout={0,0x7fffffff} and let 0 be retry forever.
[17 Jul 2004 19:03] Johan Andersson
Btw, customers expect mysqld servers to autoreconnect.
[6 Aug 2004 11:08] Magnus Blåudd
A patch for this has been commited to mysql-4.1-ndb, waiting review
[15 Sep 2004 12:49] Magnus Blåudd
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html