Bug #18538 | Graceful node stop can abort transactions | ||
---|---|---|---|
Submitted: | 27 Mar 2006 10:56 | Modified: | 27 Aug 2010 7:59 |
Reporter: | Serge Kozlov | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Cluster: Cluster (NDB) storage engine | Severity: | S2 (Serious) |
Version: | mysql-4.1 | OS: | Linux (FC4) |
Assigned to: | Jonas Oreland | CPU Architecture: | Any |
[27 Mar 2006 10:56]
Serge Kozlov
[28 Mar 2006 16:18]
Jonas Oreland
Getting aborted transaction when a node fails is expected. However "X restart" from ndb_mgm should _not_ give any aborted transactions. There is a know bug here, that you sometimes get 4028, but I never seen 286. Did you do "X restart" or did you kill nodes by some other means?
[28 Mar 2006 16:47]
Serge Kozlov
1. I did 'X restart' 2. Is it correct behaviour for 2 replicas?
[24 Apr 2006 19:39]
Tomas Ulin
can you turn on the 'slow log'? To see if the application has long running transactions. if transactions are running for a long time they will be aborted even if you are running a "graceful shutdown"
[21 May 2006 17:24]
Jonas Oreland
Nobody has complained about this. (that transaction can be aborted even if graceful shutdown)
[22 Jan 2007 22:19]
Jonathan Miller
Serge, Tomas is asking for some feedback. See above. /jeb
[23 Feb 2007 0:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
[26 Aug 2010 9:03]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/116837 3264 Jonas Oreland 2010-08-26 ndb - bug#55641 - fix suma wrt. graceful shutdown, bug#18538 graceful shutdown can abort transactions
[26 Aug 2010 12:46]
Bugs System
Pushed into mysql-5.1-telco-6.3 5.1.47-ndb-6.3.37 (revid:jonas@mysql.com-20100826123701-s6etvy71vidlaxme) (version source revid:jonas@mysql.com-20100826090051-denyt588wm3stmoh) (merge vers: 5.1.47-ndb-6.3.37) (pib:21)
[26 Aug 2010 12:46]
Bugs System
Pushed into mysql-5.1-telco-7.0 5.1.47-ndb-7.0.18 (revid:jonas@mysql.com-20100826124130-kuw81qy5le9lpl7o) (version source revid:jonas@mysql.com-20100826123333-adf4ctppycqvjgg4) (merge vers: 5.1.47-ndb-7.0.18) (pib:21)
[26 Aug 2010 12:56]
Jonas Oreland
pushed into 6.3.37, 7.0.18 and 7.1.7
[27 Aug 2010 7:59]
Jon Stephens
Documented bugfix in the NDB-6.3.37, 7.0.18, and 7.1.7 changelogs, as follows: The planned shutdown of a data node could sometimes cause transactions to be aborted unnecessarily. Closed.