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: | |
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
[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