MySQL Bugs: #48412: Incompatible option in test start triggers bug#42928

Bug #48412	Incompatible option in test start triggers bug#42928
Submitted:	29 Oct 17:05	Modified:	30 Oct 17:06
Reporter:	Joerg Bruehe
Status:	Verified
Category:	Tests: Cluster	Severity:	S3 (Non-critical)
Version:	mysql-5.1-telco-6.3	OS:	Any
Assigned to:		Target Version:
Tags:	cluster-6.3.27a
Triage:	Triaged: D2 (Serious) / R2 (Low) / E2 (Low)

Description:
This is from the build of cluster-6.3.27a:

=====
CURRENT_TEST: rpl_ndb.rpl_ndb_slave_lsu
YYMMDD HH:MM:SS [Warning] The syntax '--log' is deprecated and will be removed in MySQL
7.0. Please use '--general_log'/'--general_log_file' instead.
YYMMDD HH:MM:SS [Warning] The syntax '--log_slow_queries' is deprecated and will be
removed in MySQL 7.0. Please use '--slow_query_log'/'--slow_query_log_file' instead.
YYMMDD HH:MM:SS [ERROR] You need to use --log-bin to make --binlog-format work.
YYMMDD HH:MM:SS [ERROR] Aborting

YYMMDD HH:MM:SS [Note] /PATH/mysqld: Shutdown complete
=====

Failed to start mysqld.2.1
=====

As a consequence, all runs of test "rpl_ndb.rpl_ndb_slave_lsu" fail.

How to repeat:
Just run the test.

Suggested fix:
Either backport the fix for bug#42928,
or set the options correctly for this test.

Cluster-6.3.27a is based on server-5.1.37,
but in the server-5.1 line I haven't seen this,
it is definitely not in 5.1.40.

The test "rpl_ndb_slave_lsu" is not contained in server-5.1.40 sources.

It seems this test is specific to the CGE tree -
has it ever been run successfully?

Hi,

this is not a bug actually. This test must not be run with enforced binlog-format option.
Simply run testing without enforced binlog-format options. It will then still run all
tests multiple times with all binlog format options - but only where useful:

perl mysql-test-run.pl --timer --force --parallel=auto --comment=embedded
--vardir=var-emebbed  --embedded --experimental=collections/default.experimental
perl mysql-test-run.pl --timer --force --parallel=auto --comment=funcs_1
--vardir=var-funcs_1 --suite=funcs_1 --experimental=collections/default.experimental
perl mysql-test-run.pl --timer --force --para=auto --comment=std --vardir=var-std

It *is* a bug in the test.

You will find the sequence of MTR calls in the top Makefile,
target "test-bt".
One of these calls uses this list of options:

  ./mysql-test-run.pl  --comment=ndb+rpl_ndb+ps --force --timer \
    --ps-protocol --mysqld=--binlog-format=row --suite=ndb,rpl_ndb

The test needs to receive some guard which ensures it is skipped when its own options are
incompatible with those used for the suite.

Yes, it passes when run with different options, so I will adapt the subject line and my
assessment of the severity.