Bug #13869 update primary key cause ndb node crash

• Submitted: 9 Oct 2005 10:02
• Modified: 9 Nov 2005 21:52
• Reporter: [ name withheld ]
• Status: No Feedback
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: 5.0.13
• OS: Solaris (solaris 9)
• Assigned to: Assigned Account
• CPU Architecture: Any

[9 Oct 2005 10:02] [ name withheld ]

Description:
A Mysql cluster with 2 ndb nodes and one sql node.

CREATE TABLE `test` (
  `a` varchar(21) NOT NULL default '1',
  `b` tinyint(3) unsigned NOT NULL default 0,
  UNIQUE KEY `a` (`a`,`b`)
) ENGINE=ndbcluster;

insert test(a) values('1'),('2'),('3');

Update the record:
update test set b=2 where a='1';

and got the error:
ERROR 1297 (HY000): Got temporary error 4010 'Node failure caused abort of transaction' from ndbcluster

Then, one of the data node crashed. If re-execute this sql, another node crashed too.

How to repeat:
Just do as I descript

Suggested fix:
No

[9 Oct 2005 10:11] [ name withheld ]

Aso happen in previous version (5.0.10)

[9 Oct 2005 21:52] Hartmut Holzgraefe

I couldn't reproduce this so far, can you please add
- your mysql configuration file
- your cluster configuration file
- the failing nodes error log(s)?

[10 Oct 2005 5:58] [ name withheld ]

mysql configuration file

Attachment: my.cnf (application/octet-stream, text), 5.33 KiB.

[10 Oct 2005 5:59] [ name withheld ]

cluster configuration file

Attachment: config.ini (application/octet-stream, text), 1.20 KiB.

[10 Nov 2005 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".