Re: [Maria-developers] some bugs in dingqing parallel replication

22 Jul 2013


      nanyi607rao  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