Bug #59969 Test 'ndb_blob_big' times out in locking
Submitted: 5 Feb 2011 21:41
Reporter: Kent Boortz Email Updates:
Status: Verified Impact on me:
None 
Category:Tests: Cluster Severity:S3 (Non-critical)
Version:7.1.10 OS:Any
Assigned to: CPU Architecture:Any

[5 Feb 2011 21:41] Kent Boortz
Description:
The test 'ndb_blob_big' reports for a few test runs, on Solaris and Mac OS X (likely not tied to platform at all). Sometimes the restart of the test succeeds, sometimes not

  ndb.ndb_blob_big                         [ fail ]

  mysqltest: At line 68: query 'call heavy_read(100)' failed: 1205: Lock wait timeout exceeded; try restarting transaction

  The result from queries just before the failure was:
  < snip >
  call heavy_insert(10, 9*1024*1024);
  Now heavy read should fail
  call heavy_read(100);
  set ndb_blob_read_batch_bytes=100 * 1024;
  Now heavy read should succeed

  Warnings from just before the error:
  Error 1297 Got temporary error 266 'Time-out in NDB, probably caused by deadlock' from NDB
  Error 1297 Got temporary error 266 'Time-out in NDB, probably caused by deadlock' from NDB

One retry failed with

  mysqltest: At line 54: query 'call heavy_insert(10, 9*1024*1024)' failed: 1205: Lock wait timeout exceeded; try restarting transaction

How to repeat:
Run the test