| Bug #12433 | mysql-test-run.pl --suite argument seem to restart the mysqld on each test case | ||
|---|---|---|---|
| Submitted: | 8 Aug 2005 12:27 | Modified: | 8 Mar 2006 16:14 |
| Reporter: | Jonathan Miller | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Command-line Clients | Severity: | S4 (Feature request) |
| Version: | 5.0-wl1012 | OS: | Linux (Linux) |
| Assigned to: | Kent Boortz | CPU Architecture: | Any |
[8 Mar 2006 10:25]
Kent Boortz
Once you add a <testcase>-master.opt file, the server will be restarted with the options that file contains. And by design the server will restart after the test case to restore the initial state, or with a new special state. As an optimization now it is checked if the next test case would restart with the same options, then no server restart is done. This still means you have to give all tests that share options, individual .opt files with the same content. For the normal regression suite in 4.1, this change saves two restarts of the master, but with the --reorder option changed to sort on master options, it saves 9 restarts.
[8 Mar 2006 16:14]
Paul DuBois
No changelog entry needed.
[8 Mar 2006 18:16]
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/3597
Description: Jonathan, Thanks for the info. I'm afraid it is not as simple as the server is restarted with the suite command since the nist and funcs_1 are running without starting the server... so must be a combination with opt or something. Unfortunately I don't have the time to look into it now (and I believe Kent is busy as well). For now... 1) Log a bug against it (so we will not forget) 2) build the test suite as if it works but run it with two separate commands ... --args=--binlog-format=row... and ... --args=--binlog--format=statement (or nothing since the default). This is planed to be pushed to be part of the main suite anyway at the end so even if we don't get to fix the bug in time we have a solution. ==Omer Jonathan Miller wrote: Omer, It is a bug when you use the -suite option. Renamed the mysql-test/r and mysql-test/t directories Copied the r and t from my rpl suite under the mysql-test directory and removed the rpl_row_000002-master.opt. Ran the test with no suite option and it ran: rpl_row_000001.test & rpl_row_000002.test just fine. So there is something about the suite command that causes the server to get restarted after the rpl_row_000001.test and cause rpl_row_000002.test to be skipped due to it being back to statement based unless you include rpl_row_00000#-master.opt with --binlog-format=row for each test case under suite. JBM How to repeat: see above