From: Ann W. Harrison
Date: October 20 2008 9:52pm
Subject: Binary logging not possible
List-Archive: http://lists.mysql.com/falcon/64
Message-Id: <48FCFD9C.2000900@mysql.com>
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset=ISO-8859-1
Content-Transfer-Encoding: 7BIT

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