Bug #28685 Suite "rowlock" fails totally: "Lock wait timeout exceeded", common include file
Submitted: 25 May 2007 19:11 Modified: 26 Feb 2009 12:43
Reporter: Joerg Bruehe Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:5.1.19 OS:Any
Assigned to: CPU Architecture:Any

[25 May 2007 19:11] Joerg Bruehe 
Description:
*All* tests of the newly used "rowlock" suite fail in the build of version 5.1.19-beta.

The typical symptom is:
=====
Errors are (from /PATH/mysqltest-time) :
mysqltest: In included file "./suite/row_lock/include/row_lock.inc": At line 31: query 'UPDATE t1,t2 SET t1.i=225,t2.i=225
WHERE t1.i=125 AND t2.i=t1.i' failed: 1205: Lock wait timeout exceeded; try restarting transaction
(the last lines may be the most important ones)
=====

How to repeat:
Run that test suite.

Suggested fix:
Maybe it is just a question of test run options ...
[25 May 2007 21:11] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/27377

ChangeSet@1.2513, 2007-05-25 23:08:31+02:00, joerg@trift2. +1 -0
  Makefile.am  :  Bypass bug#28685 and skip the "rowlock" suite in the release builds.
[25 May 2007 21:17] Joerg Bruehe 
The patch I pushed is a bypass, not a fix.
[11 Jun 2007 11:39] Bugs System 
Pushed into 5.1.20-beta