Yes I have tried on two occasions to email you that it appears that the
default format has changed from MIXED to STATEMENT, however my emails did
not get through.
I am sorry if this caused extra effort on your side. I have no idea why the
default has changed.
Philip Stoev
----- Original Message -----
From: "Ann W. Harrison" <ann@stripped>
To: <falcon@stripped>
Sent: Tuesday, October 21, 2008 10:43 PM
Subject: Re: Odd new error message since today's pull from 6.0
> 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
>
> --
> Falcon Storage Engine Mailing List
> For list archives: http://lists.mysql.com/falcon
> To unsubscribe:
> http://lists.mysql.com/falcon?unsub=1
>
>
