Bug #48683 mysql-stress-test fails with "Value ... invalid for option abort-on-error"
Submitted: 11 Nov 2009 11:26 Modified: 17 Jun 2010 19:36
Reporter: Olav Sandstå Email Updates:
Status: Closed Impact on me:
None 
Category:Tools: MTR / mysql-test-run Severity:S3 (Non-critical)
Version:6.0.14 OS:Any
Assigned to: Bjørn Munch CPU Architecture:Any
Tags: regression

[11 Nov 2009 11:26] Olav Sandstå
Description:
When starting mysql-stress-test like this:

% setenv MTR_VERSION 1
% perl ./mysql-test-run.pl --stress --stress-init-file=bug35080_init.txt --stress-test-file=bug35080_run.txt --stress-test-duration=60000 --stress-threads=10 --skip-ndb --mysqld=--innodb

it fails to start and writes the following error message:

Value "--stress-init-file=/home/os136802/mysql/develop/repo/opt-bug35080-lin/mysql-test/bug35080_init.txt" invalid for option abort-on-error (number expected)

Note that this example uses the test files found in Bug#35080

How to repeat:
1. Download the zip file containing an mysql-stress-test from Bug#35080
2. Unzip the file an place the test files as described in Bug#35080
3. Set MTR_VERSION to 1 (e.g for tcsh: setenv MTR_VERSION 1)
4. Start the test:

    perl ./mysql-test-run.pl --stress --stress-init-file=bug35080_init.txt --stress-test-file=bug35080_run.txt --stress-test-duration=60000 --stress-threads=10 --skip-ndb --mysqld=--innodb

Suggested fix:
Update the following script files:

  ./mysql-test/lib/v1/mtr_stress.pl
  ./mysql-test/lib/mtr_stress.pl

with a proper value for the --abort-on-error argument. --abort-on-error did not take a value earlier but this seems to have been changed.
[11 Nov 2009 11:47] Olav Sandstå
This problem is likely introduced in the following change set:

  revision-id: omer@mysql.com-20090925152755-y8l93yw64z2psa0f
  committer: Omer BarNir <omer@mysql.com>
  branch nick: src-bugteam
  timestamp: Fri 2009-09-25 08:27:55 -0700
  message:
    Checking in new version of 'mysql-stress-test.pl that was used for the last few month
    from test-extra tree.
                  
    Changes include improvements to error handling and are based on WL#4685

where the --abort-on-error now is required to take a value.
[11 Nov 2009 17:55] Valeriy Kravchuk
Verified just as described:

77-52-7-73:mysql-test openxs$ perl ./mysql-test-run.pl --stress --stress-init-file=bug35080_init.txt --stress-test-file=bug35080_run.txt --stress-test-duration=60000 --stress-threads=10 --skip-ndb --mysqld=--innodb
=======================================================
  WARNING: Using mysql-test-run.pl version 1!  
=======================================================
Logging: lib/v1/mysql-test-run.pl --stress --stress-init-file=bug35080_init.txt --stress-test-file=bug35080_run.txt --stress-test-duration=60000 --stress-threads=10 --skip-ndb --mysqld=--innodb
091111 19:53:17 [ERROR] An old style --language value with language specific part detected: /Users/openxs/dbs/6.0-codebase/share/mysql/english/
091111 19:53:17 [ERROR] Use --lc-messages-dir without language specific part instead.
091111 19:53:17 [Warning] Setting lower_case_table_names=2 because file system for /var/folders/dX/dXCzvuSlHX4Op1g-o1jIWk+++TI/-Tmp-/l0R9BlZ9us/ is case insensitive
091111 19:53:17 [Note] Plugin 'FEDERATED' is disabled.
091111 19:53:17 [Note] Plugin 'ndbcluster' is disabled.
MySQL Version 6.0.14
Using dynamic switching of binlog format
Skipping ndbcluster
Setting mysqld to support SSL connections
Binaries are debug compiled
mysql-test-run: WARNING: Could not find all required instance manager binaries, all im tests will fail, use --skip-im to continue without instance manager
Use of uninitialized value in scalar assignment at lib/v1/mysql-test-run.pl line 1956.
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               = 9313
Using IM_MYSQLD1_PORT       = 9314
Using IM_MYSQLD2_PORT       = 9315
Killing Possible Leftover Processes
Removing Stale Files
Creating Directories
Installing Master Database
Creating IM password file (/Users/openxs/dbs/6.0-codebase/mysql-test/var/im.passwd)
Installing Im_mysqld_1 Database
Installing Im_mysqld_2 Database
Starting stress testing

Value "--stress-init-file=/Users/openxs/dbs/6.0-codebase/mysql-test/bug35080_init.txt" invalid for option abort-on-error (number expected)

The MySQL Stress suite Ver 1.0

...
[18 Nov 2009 20:06] Omer Barnir
value of 'abort-on-error' in 'mtr_stress.pl' in lib and lib/v1 
needs to be set to 1
[19 Nov 2009 12: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/90958

2861 Bjorn Munch	2009-11-19
      Bug #48683 mysql-stress-test fails with "Value ... invalid for option abort-on-error"
      Add =1 to --abort-on-error argument
[24 Nov 2009 13:02] Bjørn Munch
Pushed to 5.1-mtr, trunk-mtr, next-mr-mtr, 6.0-codebase-mtr
[20 Feb 2010 9:31] Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20100220092844-jh07ayojyxn8uh9p) (version source revid:bjorn.munch@sun.com-20091124125609-1yzq2dlkedgj34wr) (merge vers: 6.0.14-alpha) (pib:16)
[20 Feb 2010 9:33] Bugs System
Pushed into 5.5.3-m2 (revid:alik@sun.com-20100220092622-wvhh1vfy5tjq4mhu) (version source revid:bjorn.munch@sun.com-20091124112606-seetky6u168kxmgk) (merge vers: 5.5.0-beta) (pib:16)
[20 Feb 2010 9:36] Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100220092730-paoo5t9gcajs5dq8) (version source revid:bjorn.munch@sun.com-20091124112719-cn314iyf7ngc6wr1) (pib:16)
[23 Feb 2010 2:09] Paul DuBois
Changes to test suite. No changelog entry needed.

Setting report to Need Merge pending push to 5.1.x, Celosia.
[1 Mar 2010 8:42] Bugs System
Pushed into 5.1.45 (revid:joro@sun.com-20100301083827-xnimmrjg6bh33o1o) (version source revid:azundris@mysql.com-20100222175719-viuh0f3gdsrkgv0r) (merge vers: 5.1.45) (pib:16)
[1 Mar 2010 16:22] Paul DuBois
No changelog entry needed.
[17 Jun 2010 11:45] Bugs System
Pushed into 5.1.47-ndb-7.0.16 (revid:martin.skold@mysql.com-20100617114014-bva0dy24yyd67697) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[17 Jun 2010 12:23] Bugs System
Pushed into 5.1.47-ndb-6.2.19 (revid:martin.skold@mysql.com-20100617115448-idrbic6gbki37h1c) (version source revid:martin.skold@mysql.com-20100609140708-52rvuyq4q500sxkq) (merge vers: 5.1.45-ndb-6.2.19) (pib:16)
[17 Jun 2010 13:10] Bugs System
Pushed into 5.1.47-ndb-6.3.35 (revid:martin.skold@mysql.com-20100617114611-61aqbb52j752y116) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)