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?



Simplistix - Content Management, Batch Processing & Python Consulting
            - http://www.simplistix.co.uk
For more information about ZODB, see the ZODB Wiki:

ZODB-Dev mailing list  -  ZODB-Dev@zope.org

Reply via email to