Bug #16492 DD: Deleting from small to mid size table causes node failure.
Submitted: 13 Jan 2006 19:17 Modified: 4 Mar 2006 9:37
Reporter: Jonathan Miller Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S1 (Critical)
Version:5.1.6-alpha OS:Linux (Linux)
Assigned to: Jonas Oreland CPU Architecture:Any

[13 Jan 2006 19:17] Jonathan Miller
Description:
Delete from table; with table containing 80,000 + rows causes data nodes to fail.

Time: Friday 13 January 2006 - 19:50:01
Status: Temporary error, restart node
Message: Internal program error (failed ndbrequire) (Internal error, programming error or missing error message, please report a bug)
Error: 2341
Error data: DbtupCommit.cpp
Error object: DBTUP (Line: 491) 0x0000000a
Program: /home/ndbdev/jmiller/builds/libexec/ndbd
Pid: 6622
Trace: /space/run/ndb_6_trace.log.1
Version: Version 5.1.6 (alpha)
***EOM***

Time: Friday 13 January 2006 - 19:12:47
Status: Temporary error, restart node
Message: Internal program error (failed ndbrequire) (Internal error, programming error or missing error message, please report a bug)
Error: 2341
Error data: DbtupCommit.cpp
Error object: DBTUP (Line: 491) 0x0000000a
Program: /home/ndbdev/jmiller/builds/libexec/ndbd
Pid: 6619
Trace: /space/run/ndb_4_trace.log.1
Version: Version 5.1.6 (alpha)
***EOM***

Time: Friday 13 January 2006 - 19:50:01
Status: Temporary error, restart node
Message: Internal program error (failed ndbrequire) (Internal error, programming error or missing error message, please report a bug)
Error: 2341
Error data: DbtupCommit.cpp
Error object: DBTUP (Line: 491) 0x0000000a
Program: /home/ndbdev/jmiller/builds/libexec/ndbd
Pid: 2966
Trace: /space/run/ndb_5_trace.log.1
Version: Version 5.1.6 (alpha)
***EOM***

Time: Friday 13 January 2006 - 19:12:47
Status: Temporary error, restart node
Message: Internal program error (failed ndbrequire) (Internal error, programming error or missing error message, please report a bug)
Error: 2341
Error data: DbtupCommit.cpp
Error object: DBTUP (Line: 491) 0x0000000a
Program: /home/ndbdev/jmiller/builds/libexec/ndbd
Pid: 2969
Trace: /space/run/ndb_7_trace.log.1
Version: Version 5.1.6 (alpha)

--------------- Signal ----------------
r.bn: 247 "DBLQH", r.proc: 7, r.sigId: 48632295 gsn: 342 "PACKED_SIGNAL" prio: 1s.bn: 247 "DBLQH", s.proc: 6, s.sigId: -1 length: 24 trace: 1 #sec: 0 fragInf: 0Signal data: H'00006a07 H'00000bc3 H'0000000f H'00201b00 H'00006a08 H'00000bc3 H'0000000f H'00201b00 H'00006a09 H'00000bc3 H'0000000f H'00201b00 H'00006a0a H'00000bc3 H'0000000f H'00201b00 H'00006a0b H'00000bc3 H'0000000f H'00201b00 H'00006a0c H'00000bc3 H'0000000f H'00201b00
--------- Begin Packed Signals --------

How to repeat:
Setup 3 host cluster with 4 data nodes 2 replicas 1 ndb_mgmd 1 mysqld
Create a TPCB database using Cluster Disk Data
Run atomics history inserts test. 
Once complete open a mysql client connection and run DELETE FROM TPCB.history;
[23 Feb 2006 10:24] Jon Stephens
Need summary - "small to medium size" is vague and relative; also the description doesn't say anything about circumstances.

Also need changeset and version number.

Thanks.
[23 Feb 2006 12:53] Jonathan Miller
Jonas, can you attach patch link to the bug, I would like to review the fix.

Thanks
JBM
[25 Feb 2006 18:31] Jonathan Miller
Putting back to verified to get missing information added.
[4 Mar 2006 9:37] Jon Stephens
Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/

Additional info:

Documented fix in 5.1.7 changelog. Closed.