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
- s1
- s2
- s3
- s4
- s5
- s6
- s7
- s8
- Puppet patch: https://gerrit.wikimedia.org/r/c/operations/puppet/+/1203850
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;