From: Tor Didriksen Date: February 3 2012 3:16pm Subject: bzr push into mysql-trunk branch (tor.didriksen:3838 to 3839) List-Archive: http://lists.mysql.com/commits/142749 Message-Id: <201202031517.q13FH0Qw016185@acsmt356.oracle.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 3839 Tor Didriksen 2012-02-03 All the subquery_sj_xxx tests can get thread stack overrun on solaris modified: mysql-test/collections/default.experimental 3838 Ashish Agarwal 2012-02-03 BUG#11748748 - 37280: CHECK AND REPAIR TABLE REPORT TABLE CORRUPTED WHEN RUN CONCURRENTLY WITH ISSUE: Concurrent queries in archive causes table corruption. Running repair and check query concurrently with insert query causes table corruption. Improper locking. SOLUTION: Locks are properly aquired. Initial lock is aquired and number of rows are remembered. Inserting remembered rows to new file. Locks are again aquired to process the remaining rows. Concurrent optimization on a same table not allowed. modified: storage/archive/ha_archive.cc storage/archive/ha_archive.h === modified file 'mysql-test/collections/default.experimental' --- a/mysql-test/collections/default.experimental 2012-02-03 14:30:11 +0000 +++ b/mysql-test/collections/default.experimental 2012-02-03 15:16:35 +0000 @@ -9,39 +9,41 @@ main.func_math @freebsd main.mysqlslap @windows # Bug#11761520 2010-08-10 alik mysqlslap fails sporadically starting from Dahlia main.signal_demo3 @solaris # Bug#11753919 2010-01-20 alik Several test cases fail on Solaris with error Thread stack overrun main.sp @solaris # Bug#11753919 2010-01-20 alik Several test cases fail on Solaris with error Thread stack overrun -main.subquery_sj_all_bka_nixbnl @solaris -main.subquery_sj_all_bka @solaris -main.subquery_sj_all_bkaunique @solaris -main.subquery_sj_all @solaris -main.subquery_sj_dupsweed_bka_nixbnl @solaris -main.subquery_sj_dupsweed_bka @solaris -main.subquery_sj_dupsweed_bkaunique @solaris -main.subquery_sj_dupsweed @solaris -main.subquery_sj_firstmatch_bka_nixbnl @solaris -main.subquery_sj_firstmatch_bka @solaris -main.subquery_sj_firstmatch_bkaunique @solaris -main.subquery_sj_firstmatch @solaris -main.subquery_sj_innodb_all_bka_nixbnl @solaris -main.subquery_sj_innodb_all_bka @solaris -main.subquery_sj_innodb_all_bkaunique @solaris -main.subquery_sj_innodb_all @solaris -main.subquery_sj_innodb_none_bka_nixbnl @solaris -main.subquery_sj_innodb_none_bka @solaris -main.subquery_sj_innodb_none_bkaunique @solaris -main.subquery_sj_innodb_none @solaris -main.subquery_sj_loosescan_bka_nixbnl @solaris -main.subquery_sj_loosescan_bka @solaris -main.subquery_sj_loosescan_bkaunique @solaris -main.subquery_sj_loosescan @solaris -main.subquery_sj_mat_bka_nixbnl @solaris -main.subquery_sj_mat_bka @solaris -main.subquery_sj_mat_bkaunique @solaris -main.subquery_sj_mat_nosj @solaris -main.subquery_sj_mat @solaris -main.subquery_sj_none_bka_nixbnl @solaris -main.subquery_sj_none_bka @solaris -main.subquery_sj_none_bkaunique @solaris -main.subquery_sj_none @solaris + +main.subquery_sj_all_bka_nixbnl @solaris # Bug#11753919 2012-02-03 didrik Several test cases fail on Solaris with error Thread stack overrun +main.subquery_sj_all_bka @solaris # Bug#11753919 2012-02-03 didrik Several test cases fail on Solaris with error Thread stack overrun +main.subquery_sj_all_bkaunique @solaris # Bug#11753919 2012-02-03 didrik Several test cases fail on Solaris with error Thread stack overrun +main.subquery_sj_all @solaris # Bug#11753919 2012-02-03 didrik Several test cases fail on Solaris with error Thread stack overrun +main.subquery_sj_dupsweed_bka_nixbnl @solaris # Bug#11753919 2012-02-03 didrik Several test cases fail on Solaris with error Thread stack overrun +main.subquery_sj_dupsweed_bka @solaris # Bug#11753919 2012-02-03 didrik Several test cases fail on Solaris with error Thread stack overrun +main.subquery_sj_dupsweed_bkaunique @solaris # Bug#11753919 2012-02-03 didrik Several test cases fail on Solaris with error Thread stack overrun +main.subquery_sj_dupsweed @solaris # Bug#11753919 2012-02-03 didrik Several test cases fail on Solaris with error Thread stack overrun +main.subquery_sj_firstmatch_bka_nixbnl @solaris # Bug#11753919 2012-02-03 didrik Several test cases fail on Solaris with error Thread stack overrun +main.subquery_sj_firstmatch_bka @solaris # Bug#11753919 2012-02-03 didrik Several test cases fail on Solaris with error Thread stack overrun +main.subquery_sj_firstmatch_bkaunique @solaris # Bug#11753919 2012-02-03 didrik Several test cases fail on Solaris with error Thread stack overrun +main.subquery_sj_firstmatch @solaris # Bug#11753919 2012-02-03 didrik Several test cases fail on Solaris with error Thread stack overrun +main.subquery_sj_innodb_all_bka_nixbnl @solaris # Bug#11753919 2012-02-03 didrik Several test cases fail on Solaris with error Thread stack overrun +main.subquery_sj_innodb_all_bka @solaris # Bug#11753919 2012-02-03 didrik Several test cases fail on Solaris with error Thread stack overrun +main.subquery_sj_innodb_all_bkaunique @solaris # Bug#11753919 2012-02-03 didrik Several test cases fail on Solaris with error Thread stack overrun +main.subquery_sj_innodb_all @solaris # Bug#11753919 2012-02-03 didrik Several test cases fail on Solaris with error Thread stack overrun +main.subquery_sj_innodb_none_bka_nixbnl @solaris # Bug#11753919 2012-02-03 didrik Several test cases fail on Solaris with error Thread stack overrun +main.subquery_sj_innodb_none_bka @solaris # Bug#11753919 2012-02-03 didrik Several test cases fail on Solaris with error Thread stack overrun +main.subquery_sj_innodb_none_bkaunique @solaris # Bug#11753919 2012-02-03 didrik Several test cases fail on Solaris with error Thread stack overrun +main.subquery_sj_innodb_none @solaris # Bug#11753919 2012-02-03 didrik Several test cases fail on Solaris with error Thread stack overrun +main.subquery_sj_loosescan_bka_nixbnl @solaris # Bug#11753919 2012-02-03 didrik Several test cases fail on Solaris with error Thread stack overrun +main.subquery_sj_loosescan_bka @solaris # Bug#11753919 2012-02-03 didrik Several test cases fail on Solaris with error Thread stack overrun +main.subquery_sj_loosescan_bkaunique @solaris # Bug#11753919 2012-02-03 didrik Several test cases fail on Solaris with error Thread stack overrun +main.subquery_sj_loosescan @solaris # Bug#11753919 2012-02-03 didrik Several test cases fail on Solaris with error Thread stack overrun +main.subquery_sj_mat_bka_nixbnl @solaris # Bug#11753919 2012-02-03 didrik Several test cases fail on Solaris with error Thread stack overrun +main.subquery_sj_mat_bka @solaris # Bug#11753919 2012-02-03 didrik Several test cases fail on Solaris with error Thread stack overrun +main.subquery_sj_mat_bkaunique @solaris # Bug#11753919 2012-02-03 didrik Several test cases fail on Solaris with error Thread stack overrun +main.subquery_sj_mat_nosj @solaris # Bug#11753919 2012-02-03 didrik Several test cases fail on Solaris with error Thread stack overrun +main.subquery_sj_mat @solaris # Bug#11753919 2012-02-03 didrik Several test cases fail on Solaris with error Thread stack overrun +main.subquery_sj_none_bka_nixbnl @solaris # Bug#11753919 2012-02-03 didrik Several test cases fail on Solaris with error Thread stack overrun +main.subquery_sj_none_bka @solaris # Bug#11753919 2012-02-03 didrik Several test cases fail on Solaris with error Thread stack overrun +main.subquery_sj_none_bkaunique @solaris # Bug#11753919 2012-02-03 didrik Several test cases fail on Solaris with error Thread stack overrun +main.subquery_sj_none @solaris # Bug#11753919 2012-02-03 didrik Several test cases fail on Solaris with error Thread stack overrun + main.kill @freebsd # Bug#12619719 2011-08-04 Occasional failure in PB2 innodb.innodb_monitor # Bug#12320827 2011-08-04 Occasional failure in PB2 No bundle (reason: useless for push emails).