[MDEV-7194] galera fails to replicate DDL queries when using binlog_checksum Created: 2014-11-24  Updated: 2015-03-28  Resolved: 2015-03-28

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.0.14-galera
Fix Version/s: 5.5.43-galera, 10.0.19-galera

Type: Bug Priority: Major
Reporter: Brad Jorgensen Assignee: Nirbhay Choubey (Inactive)
Resolution: Fixed Votes: 0
Labels: galera
Environment:

CentOS 6.5


Attachments: Text File GRA_41_335743798.log     Text File GRA_66_335743799.log     Text File GRA_96_336539821.log     File my.cnf     Text File mysqld_checksum_errors.txt    

 Description   

When using binlog_checksum = 'CRC32', galera fails to replicate DDL events. I don't currently have an environment where I can test this more so I'm going off binlogs and error logs from when I had binlog_checksum set and not.

When binlog_checksum was set, I saw errors like in mysqld_checksum_errors.txt. The errors on the analyze queries aren't critical but the error when creating the table caused two of my three nodes to kill themselves since the originating node then proceeded to load data into the table. Having set binlog_checksum to 'NONE' (the default) my cluster handles DDL queries normally now. I looked in the galera cache file on the surviving node and the queries did have the extra bytes after them just as in the error log.

I also attached the GRA log files from the queries mentioned in the log file.



 Comments   
Comment by Nirbhay Choubey (Inactive) [ 2015-03-28 ]

https://github.com/MariaDB/server/commit/d7445ea6dfbd3be390792c636f755d3bb40d5fbf

Generated at Thu Feb 08 07:17:43 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.