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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.041 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.