[ZODB-Dev] Error from MySQL when attempting to run zodbconvert

[Chris Withers]

On 01/02/2011 04:03, Shane Hathaway wrote:
> On 01/31/2011 06:30 PM, Chris Withers wrote:
>> Hi Shane,
>>
>> 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'")
>
> That's why you have to use row-based replication instead of
> statement-based replication.

Is this in the RelStorage docs anywhere? If so, I missed it, but if not, 
I guess it probably should be...

cheers,

Chris

-- 
Simplistix - Content Management, Batch Processing & Python Consulting
            - http://www.simplistix.co.uk