nanyi607rao <nanyi607rao@gmail.com> writes:
1, when slave switch on table filter,this bug could lead server crash.
how to reappear: on slave set replicate-wild-ignore-table = test.t5 in config file on master do these operations CREATE TABLE test.t3 (a INT AUTO_INCREMENT PRIMARY KEY, b DECIMAL(20,20), c INT); SET INSERT_ID=1; SET @c=2; SET @@rand_seed1=10000000, @@rand_seed2=1000000; INSERT INTO t3 VALUES (NULL, RAND(), @c);
codes lead this bug: In execute_single_transaction() case RAND_EVENT: need_remove_from_trans= true; if(!rli->is_deferred_event(ev)) delete ev; break; reason: Rand Event object is deleted in execute_single_transaction(), but it's pointer would be used is slave_execute_deferred_events() later.
This sounds like a bug we fixed in Percona Server a while ago. filtered replication is kinda awful and when we started to poke at it, it pretty much never worked properly. It may be that this is not specific to this replication patch. -- Stewart Smith