Bug #34311 main.lock_multi.test fails
Submitted: 5 Feb 2008 15:57 Modified: 11 Feb 2008 17:46
Reporter: Alexander Nozdrin
Status: Closed
Category:Server Severity:S1 (Critical)
Version:5.1, 6.0 OS:Any
Assigned to: Davi Arnaut Target Version:5.1+
Triage: D1 (Critical)

[5 Feb 2008 15: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 12: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 12: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 12:54] Davi Arnaut 
Pushed in 5.1-runtime and 6.0-runtime
[11 Feb 2008 17:24] Bugs System 
Pushed into 5.1.24-rc
[11 Feb 2008 17:26] Bugs System 
Pushed into 6.0.5-alpha
[11 Feb 2008 17:46] Paul DuBois 
Test case change. No changelog entry needed.