Change Details

Due to the parent task T407997 replication broke on db1155 as there are triggers on `abuse_filter_log` table which include `afl_ip` column and hence need to be dropped [x] s1 [x] s2 [x] s3 [] s4 [x] s5 [x] s6 [x] s7 [x] s8 [] Puppet patch Fix: ``` stop slave; drop trigger if exists abuse_filter_log_update; drop trigger if exists abuse_filter_log_insert; CREATE DEFINER=`root`@`localhost` TRIGGER $WIKI.abuse_filter_log_insert BEFORE INSERT ON $WIKI.abuse_filter_log FOR EACH ROW SET NEW.afl_ip_hex = '' CREATE DEFINER=`root`@`localhost` TRIGGER $WIKI.abuse_filter_log_update BEFORE UPDATE ON $WIKI.abuse_filter_log FOR EACH ROW SET NEW.afl_ip_hex = ''; start slave; ```

Due to the parent task T407997 replication broke on db1155 as there are triggers on `abuse_filter_log` table which include `afl_ip` column and hence need to be dropped [x] s1 [x] s2 [x] s3 [x] s4 [x] s5 [x] s6 [x] s7 [x] s8 [] Puppet patch Fix: ``` stop slave; drop trigger if exists abuse_filter_log_update; drop trigger if exists abuse_filter_log_insert; CREATE DEFINER=`root`@`localhost` TRIGGER $WIKI.abuse_filter_log_insert BEFORE INSERT ON $WIKI.abuse_filter_log FOR EACH ROW SET NEW.afl_ip_hex = '' CREATE DEFINER=`root`@`localhost` TRIGGER $WIKI.abuse_filter_log_update BEFORE UPDATE ON $WIKI.abuse_filter_log FOR EACH ROW SET NEW.afl_ip_hex = ''; start slave; ```

Due to the parent task T407997 replication broke on db1155 as there are triggers on `abuse_filter_log` table which include `afl_ip` column and hence need to be dropped [x] s1 [x] s2 [x] s3 [x] s4 [x] s5 [x] s6 [x] s7 [x] s8 [] Puppet patch Fix: ``` stop slave; drop trigger if exists abuse_filter_log_update; drop trigger if exists abuse_filter_log_insert; CREATE DEFINER=`root`@`localhost` TRIGGER $WIKI.abuse_filter_log_insert BEFORE INSERT ON $WIKI.abuse_filter_log FOR EACH ROW SET NEW.afl_ip_hex = '' CREATE DEFINER=`root`@`localhost` TRIGGER $WIKI.abuse_filter_log_update BEFORE UPDATE ON $WIKI.abuse_filter_log FOR EACH ROW SET NEW.afl_ip_hex = ''; start slave; ```