From: Philip Stoev
Date: October 20 2008 9:53pm
Subject: Re: Binary logging not possible
List-Archive: http://lists.mysql.com/falcon/80
Message-Id: <8BEC1873EDD245F2993E500EE1F6C022@Philips>
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=response
Content-Transfer-Encoding: 7bit


You have --log-bin=C:/MySQL/team/sql/data/bin_log  which means binary 
logging is enabled The default binary log format has been changed from MIXED 
to STATEMENT (I do not know if this is on purpose or not).

To work around this, please use

--binlog-format=ROW

And yes, please either file the bug or contact the replication team -- maybe 
the change in the default value was not intentional, I did not see it 
dicussed anywhere.

Philip Stoev

----- Original Message ----- 
From: "Ann W. Harrison" <ann@stripped>
To: <falcon@stripped>
Sent: Monday, October 20, 2008 11:52 PM
Subject: Binary logging not possible


> Well, I finally got a clean new copy of Falcon Team and still
> see the problem that all insert/update/delete statement fail
> with the error:
>
>   ERROR 1598 (HY000): Binary logging not possible.
>   Message: Statement-based format  required for this statement,
>   but not allowed by this combination of engines
>
> This appears to happen only on windows, and continues to happen
> after the patch described in bug 39934 is applied.
>
> My startup parameters are:
>
> --no-defaults --console --basedir=C:/MySQL/team/sql/data --character-sets-dir=C:/MySQL/team/sql/share/charsets 
>  --secure-file-priv=C:/MySQL/team/mysql-test/var --log-bin-trust-function-creators 
>  --default-character-set=latin1 --language=C:/MySQL/team/sql/share/english 
>  --tmpdir=C:/MySQL/team/mysql-test/var/tmp --pid-file=C:/MySQL/team/mysql-test/var/run/master.pid 
>  --port=3306 --socket=C:/MySQL/team/mysql-test/var/tmp/master.sock --datadir=C:/MySQL/team/mysql-test/var/master-data 
>  --log-output=table,file --general_log=C:/MySQL/team/mysql-test/var/log/master.log 
>  --slow_query_log=C:/MySQL/team/mysql-test/var/log/master-slow.log --server-id=1 
>  --loose-innodb_data_file_path=ibdata1:10M:autoextend --local-infile --key_buffer_size=1M 
>  --sort_buffer=256K --max_heap_table_size=1M --ssl-ca=C:/MySQL/team/mysql-test/std_data/cacert.pem 
>  --ssl-cert=C:/MySQL/team/mysql-test/std_data/server-cert.pem --ssl-key=C:/MySQL/team/mysql-test/std_data/server-key.pem 
>  --core-file --open-files-limit=1024 --log-bin=C:/MySQL/team/sql/data/bin_log 
>  --falcon_debug_mask=8191
>
> to use them locally you'll have to substitute your system root for
>  /MySQL/team throughout and fix the extra new lines introduced by
> mail programs.
>
> I guess I should file a server bug.
>
>
> Best regards,
>
> Ann
>
> -- 
> Falcon Storage Engine Mailing List
> For list archives: http://lists.mysql.com/falcon
> To unsubscribe: 
> http://lists.mysql.com/falcon?unsub=philip.stoev@stripped
>
>