Bug #34311 main.lock_multi.test fails
Submitted: 5 Feb 2008 14:57 Modified: 11 Feb 2008 16:46
Reporter: Alexander Nozdrin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.1, 6.0 OS:Any
Assigned to: Davi Arnaut CPU Architecture:Any

[5 Feb 2008 14:57] Alexander Nozdrin 
Description:
It seems main.lock_multy.test started to fail after a patch for Bug#30331.

Though it was detected only on 6.0, the test is disabled also in 5.1,
since the patch was for 5.1.

main.lock_multi                [ fail ]

--- /data0/pushbuild/pb/mysql-6.0-runtime/119/mysql-6.0-runtime-exp/mysql-test/r/lock_multi.result	2008-02-05 12:36:28.000000000 +0300
+++ /data0/pushbuild/pb/mysql-6.0-runtime/119/mysql-6.0-runtime-exp/mysql-test/r/lock_multi.reject	2008-02-05 12:54:56.000000000 +0300
@@ -149,6 +149,8 @@
 flush status;
 lock tables t1 read;
 insert into t1 values(1);;
+Timeout in wait_condition.inc for select count(*) = 1 from information_schema.processlist
+where state = "Locked" and info = "insert into t1 values(1)"
 unlock tables;
 drop table t1;
 select @tlwa < @tlwb;

mysqltest: Result content mismatch

How to repeat:
https://intranet.mysql.com/secure/pushbuild/xref.pl?testname=main.lock_multi
[6 Feb 2008 11:41] 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/41763

ChangeSet@1.2519, 2008-02-06 09:40:59-02:00, davi@mysql.com +2 -0
  Bug#34311 main.lock_multi.test fails
  
  Re-enable the test case for Bug 30331.
[6 Feb 2008 11:51] 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/41764

ChangeSet@1.2531, 2008-02-06 09:50:51-02:00, davi@mysql.com +1 -0
  Bug#34311 main.lock_multi.test fails
  
  Rename thread state description for waiting a table lock.
[6 Feb 2008 11:54] Davi Arnaut 
Pushed in 5.1-runtime and 6.0-runtime
[11 Feb 2008 16:24] Bugs System 
Pushed into 5.1.24-rc
[11 Feb 2008 16:26] Bugs System 
Pushed into 6.0.5-alpha
[11 Feb 2008 16:46] Paul DuBois 
Test case change. No changelog entry needed.