Ann W. Harrison wrote:
> Since I downloaded today's changes, the stress test I've been working on
> reports the following error, apparently on every statement, though the
> script may just be retrying a particular statement in a loop.
>
>
> DBD::mysql::db do failed: Binary logging not possible.
> Message: Statement-based format required for this statement, but
> not allowed by this combination of engines at gendata.pl line 327.
>
Chris suggested that the problem might be related to bug 39934, which
has a patch. Applying that patch didn't improve anything. So I traced
the problem through the code and found that there was a change in the
latest pull from mysql-6.0-falcon-team in mysqld.cc around line 4025.
Last week the code looked like this:
if (!opt_bin_log)
if (opt_binlog_format_id != BINLOG_FORMAT_UNSPEC)
{
sql_print_error("You need to use --log-bin to make "
"--binlog-format work.");
unireg_abort(1);
}
else
{
global_system_variables.binlog_format= BINLOG_FORMAT_MIXED;
}
else
if (opt_binlog_format_id == BINLOG_FORMAT_UNSPEC)
global_system_variables.binlog_format= BINLOG_FORMAT_MIXED;
This week it looks like this:
if (!opt_bin_log)
{
if (opt_binlog_format_id != BINLOG_FORMAT_UNSPEC)
{
sql_print_error("You need to use --log-bin to make "
"--binlog-format work.");
unireg_abort(1);
}
else
{
global_system_variables.binlog_format= BINLOG_FORMAT_STMT;
}
}
else
if (opt_binlog_format_id == BINLOG_FORMAT_UNSPEC)
global_system_variables.binlog_format= BINLOG_FORMAT_STMT;
else
And of course, Falcon doesn't work.
I have no idea why it worked for anyone anywhere, unless I'm
the only one who turns on the bin-log.
Cheers,
Ann
