From: Annamalai Gurusami Date: March 16 2012 6:48am Subject: bzr push into mysql-5.1 branch (annamalai.gurusami:3710 to 3711) Bug#11766634 List-Archive: http://lists.mysql.com/commits/143221 X-Bug: 11766634 Message-Id: <201203160648.q2G6mEUN006477@acsmt357.oracle.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 3711 Annamalai Gurusami 2012-03-16 Bug #11766634 59783: INNODB DATA GROWS UNEXPECTEDLY WHEN INSERTING, TRUNCATING, INSERTING THE The test case must insert all the records using a single transaction. Otherwise the test case takes more than 15 minutes and will time out in pb2 and mtr. modified: mysql-test/suite/innodb/t/innodb_bug11766634.test mysql-test/suite/innodb_plugin/t/innodb_bug11766634.test 3710 Inaam Rana 2012-03-15 Bug#13825266 RACE IN LOCK_VALIDATE() WHEN ACCESSING PAGES DIRECTLY FROM BUFFER POOL rb://975 approved by: Marko Makela There is a race in lock_validate() where we try to access a page without ensuring that the tablespace stays valid during the operation i.e.: it is not deleted. This patch tries to fix that by using an existing flag (the flag is renamed to make it's name more generic in line with it's new use). modified: storage/innodb_plugin/ChangeLog storage/innodb_plugin/fil/fil0fil.c storage/innodb_plugin/ibuf/ibuf0ibuf.c storage/innodb_plugin/include/fil0fil.h storage/innodb_plugin/lock/lock0lock.c === modified file 'mysql-test/suite/innodb/t/innodb_bug11766634.test' --- a/mysql-test/suite/innodb/t/innodb_bug11766634.test revid:inaam.rana@stripped +++ b/mysql-test/suite/innodb/t/innodb_bug11766634.test revid:annamalai.gurusami@stripped @@ -18,11 +18,13 @@ let $recs = 36262; --disable_query_log let $c = $recs; +start transaction; while ($c) { insert into t1 values ('Hello World'); dec $c; } +commit work; --enable_query_log perl; @@ -35,11 +37,13 @@ create table t1 (f1 char(255)) engine in --disable_query_log let $c = $recs; +start transaction; while ($c) { insert into t1 values ('Hello World'); dec $c; } +commit work; --enable_query_log perl; === modified file 'mysql-test/suite/innodb_plugin/t/innodb_bug11766634.test' --- a/mysql-test/suite/innodb_plugin/t/innodb_bug11766634.test revid:inaam.rana@stripped +++ b/mysql-test/suite/innodb_plugin/t/innodb_bug11766634.test revid:annamalai.gurusami@stripped @@ -18,11 +18,13 @@ let $recs = 36262; --disable_query_log let $c = $recs; +start transaction; while ($c) { insert into t1 values ('Hello World'); dec $c; } +commit work; --enable_query_log perl; @@ -35,11 +37,13 @@ create table t1 (f1 char(255)) engine in --disable_query_log let $c = $recs; +start transaction; while ($c) { insert into t1 values ('Hello World'); dec $c; } +commit work; --enable_query_log perl; No bundle (reason: useless for push emails).