MySQL Bugs: #26493: Multiple failures when inserting ndbrequire in NDB data node

Bug #26493	Multiple failures when inserting ndbrequire in NDB data node
Submitted:	20 Feb 2007 11:46	Modified:	3 Feb 2008 13:04
Reporter:	Mikael Ronström	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S3 (Non-critical)
Version:	5.1-wl3686	OS:	Any
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
When looking for another bug I inserted an ndbrequire in the NDB data node
in DbdihMain.cpp when finding the error code ZUNDEFINED_FRAGMENT_ERROR.

When the ndbrequire occurred the following happened.
1) The other node crashed with Send buffer full.
2) The MySQL Server also crashed

How to repeat:
Clone mysql-5.1-wl3686 at bk-internal /home/bk/mysql-5.1-wl3686
Insert ndbrequire as described above.
Run ndb_blob_partition test case.
Voila, all kinds of failures happening.

The actual reason for coming to ZUNDEFINED_FRAGMENT_ERROR is irrelevant
for this bug, this is part of a new feature developed, the problem is the crashes
caused by the ndbrequire.

Created a clone mysql-5.1-bug26493 at bk-internal usual place that one
can simply clone, build and run ndb_blob_partition to recreate this bug.

ndb_blob_partition             [ fail ]

Errors are (from /home/hartmut/projects/mysql/dev/mysql-5.1-bug26493/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 74: query 'update t1 set b = @v4, d = @v5 where c = 103' failed: 2013: Lost connection to MySQL server during query
(the last lines may be the most important ones)
Result from queries before failure can be found in /home/hartmut/projects/mysql/dev/mysql-5.1-bug26493/mysql-test/var/log/ndb_blob_partition.log

Aborting: ndb_blob_partition failed in default mode. To continue, re-run with '--force'.
Stopping All Servers
Shutting-down Instance Manager
make: *** [test-ns] Error 1

(will attach logs)

mysql-test logs

Attachment: bug26493-logs.tar.gz (application/x-gunzip, text), 199.98 KiB.