Bug #28686 Falcon: falcon_select.test regressed
Submitted: 25 May 2007 19:17 Modified: 6 Jun 2007 12:09
Reporter: Hakan Küçükyılmaz Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Falcon storage engine Severity:S2 (Serious)
Version:6.0.1-alpha OS:Any
Assigned to: Hakan Küçükyılmaz CPU Architecture:Any
Tags: regressed

[25 May 2007 19:17] Hakan Küçükyılmaz
Description:
falcon_select.test regressed.

I extracted the test in question from falcon_select.test and wrote a smaller test case for reproduction.

Running the test once shows no problem; only running it twice gives wrong result.

How to repeat:
./mysql-test-run.pl falcon_select_excerpt falcon_select_excerpt

TEST                           RESULT         TIME (ms)
-------------------------------------------------------

falcon_select_excerpt          [ pass ]            328
falcon_select_excerpt          [ fail ]

Errors are (from /home/hakan/work/mysql/mysql-5.1-falcon/mysql-test/var/log/mysqltest-time) :
mysqltest: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/falcon_select_excerpt.result      2007-05-25 21:49:17.000000000 +0300
--- r/falcon_select_excerpt.reject      2007-05-25 22:16:58.000000000 +0300
***************
*** 9,15 ****
  SELECT * FROM t1 LEFT JOIN t2 ON f1 = f3;
  f1    f2      f3      f4
   2    2        2       one
-  2    2        2       two
  SELECT count(*) FROM t1;
  count(*)
  1
--- 9,14 ----
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.
[25 May 2007 20:32] Hakan Küçükyılmaz
It looks like that sometimes we need more than two runs to see the failure.

hakan@fluffy:~/work/mysql/mysql-5.1-falcon/mysql-test> ./mysql-test-run.pl falcon_select_excerpt falcon_select_excerpt  falcon_select_excerpt  falcon_select_excerpt  falcon_select_excerpt

Logging: ./mysql-test-run.pl falcon_select_excerpt falcon_select_excerpt falcon_select_excerpt falcon_select_excerpt falcon_select_excerpt
070525 16:18:12 [Warning] Server variable data_file_path of plugin InnoDB was forced to be read-only: string variable without update_func and PLUGIN_VAR_MEMALLOC flag
070525 16:18:12 [Warning] Server variable data_home_dir of plugin InnoDB was forced to be read-only: string variable without update_func and PLUGIN_VAR_MEMALLOC flag
070525 16:18:12 [Warning] Server variable flush_method of plugin InnoDB was forced to be read-only: string variable without update_func and PLUGIN_VAR_MEMALLOC flag
070525 16:18:12 [Warning] Server variable log_arch_dir of plugin InnoDB was forced to be read-only: string variable without update_func and PLUGIN_VAR_MEMALLOC flag
070525 16:18:12 [Warning] Server variable log_group_home_dir of plugin InnoDB was forced to be read-only: string variable without update_func and PLUGIN_VAR_MEMALLOC flag
070525 16:18:12 [Note] /home/hakan/work/mysql/mysql-5.1-falcon/sql/mysqld: Shutdown complete

MySQL Version 6.0.1
Using binlog format 'mixed'
Skipping ndbcluster, mysqld not compiled with ndbcluster
Setting mysqld to support SSL connections
Binaries are debug compiled
Using MTR_BUILD_THREAD      = 0
Using MASTER_MYPORT         = 9306
Using MASTER_MYPORT1        = 9307
Using SLAVE_MYPORT          = 9308
Using SLAVE_MYPORT1         = 9309
Using SLAVE_MYPORT2         = 9310
Using IM_PORT               = 9312
Using IM_MYSQLD1_PORT       = 9313
Using IM_MYSQLD2_PORT       = 9314
Killing Possible Leftover Processes
Removing Stale Files
Creating Directories
Installing Master Database
Installing Master Database
=======================================================
Starting Tests in the 'main' suite

TEST                           RESULT         TIME (ms)
-------------------------------------------------------

falcon_select_excerpt          [ pass ]           4012
falcon_select_excerpt          [ pass ]            111
falcon_select_excerpt          [ fail ]

Errors are (from /home/hakan/work/mysql/mysql-5.1-falcon/mysql-test/var/log/mysqltest-time) :
mysqltest: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/falcon_select_excerpt.result      2007-05-25 21:54:12.000000000 +0300
--- r/falcon_select_excerpt.reject      2007-05-25 23:18:22.000000000 +0300
***************
*** 9,15 ****
  SELECT * FROM t1 LEFT JOIN t2 ON f1 = f3;
  f1    f2      f3      f4
   2    2        2       one
-  2    2        2       two
  SELECT count(*) FROM t1;
  count(*)
  1
--- 9,14 ----
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.

Result from queries before failure can be found in /home/hakan/work/mysql/mysql-5.1-falcon/mysql-test/var/log/falcon_select_excerpt.log

Aborting: falcon_select_excerpt failed in default mode. To continue, re-run with '--force'.
Stopping All Servers
hakan@fluffy:~/work/mysql/mysql-5.1-falcon/mysql-test>

If it does not fail, then start the test again.
[26 May 2007 15:20] 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/27390

ChangeSet@1.2515, 2007-05-26 17:17:31+02:00, hakank@lu0011.wdf.sap.corp +1 -0
  Temporary fix for Bug#28686.
  
  storageShare->estimateCardinality() should never return 0 for non empty table.
  We are fixing the symptom here.
[26 May 2007 19:43] 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/27396

ChangeSet@1.2516, 2007-05-26 21:42:52+02:00, hakank@lu0011.wdf.sap.corp +1 -0
  After review fix for Bug#28686
  
  On second thought, make it 2, not 1.  Let's not lead the optimizer in 
  thinking that it's a singleton table, either.
[29 May 2007 13:13] Hakan Küçükyılmaz
Missing row problem is fixed. EXPLAIN results in falcon_select.test still vary, but that's a different bug.
[6 Jun 2007 12:09] MC Brown
No documentation required.
[9 Sep 2008 12:31] John Embretsen
Test case falcon_select_excerpt is redundant (also part of falcon_select) and has thus been removed (as requested by Hakan).
http://lists.mysql.com/commits/53589