maria-developers team mailing list archive

[Stewart Smith <stewart@xxxxxxxxxxxxxxxx>]

nanyi607rao <nanyi607rao@xxxxxxxxx> 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

Attachment: pgpd37CPRKmAV.pgp
Description: PGP signature