[ZODB-Dev] Error from MySQL when attempting to run zodbconvert
Chris Withers
chris at simplistix.co.uk
Mon Jan 31 12:47:43 EST 2011
On 31/01/2011 16:30, Chris Withers wrote:
> I got the following error when trying to run zodbconvert against a
> clustered MySQL environment running RHCS:
>
> File
> "/var/buildout-eggs/MySQL_python-1.2.3-py2.6-linux-i686.egg/MySQLdb/connections.py",
> line 36, in defaulterrorhandler
> raise errorclass, errorvalue
> _mysql_exceptions.OperationalError: (1598, "Binary logging not possible.
> Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for
> binlog mode 'STATEMENT'")
I fixed this by setting binlog-format to MIXED rather than STATEMENT in
my.cnf. There don't appear to be any downsides to this, so maybe this
should go in the docs somewhere?
cheers,
Chris
--
Simplistix - Content Management, Batch Processing & Python Consulting
- http://www.simplistix.co.uk
More information about the ZODB-Dev
mailing list