powerdns_crashing_-_binary_logging_not_possible
This is an old revision of the document!
PowerDNS crashing - binary logging not possible
If PowerDNS is crashing with the following message
Exiting because communicator thread died with error: GSQLBackend unable to refresh domain_id 3: Failed to execute mysql_query, perhaps connection died? Err=1: Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'
You can fix this with:
mysql> SET GLOBAL binlog_format = 'ROW';
The error arises only if the binary logging option, which is required for the replication, is turned on for the MySQL server.
powerdns_crashing_-_binary_logging_not_possible.1402402613.txt.gz · Last modified: 2014/06/10 12:16 by admin