Re: mysql slave crashes

[Ilya Antipov]

I have recreated the slave and invesigated crashes. The query that causes a crash on the slave is:
INSERT INTO phpbb_users_birthday (SELECT u.user_id, u.username, u.user_colour, u.user_birthday, user_avatar, user_avatar_t
ype, user_avatar_width, user_avatar_height, user_notify_type, user_email, user_jabber,user_lang
FROM phpbb_users u
LEFT JOIN phpbb_banlist b ON (u.user_id = b.ban_userid)
WHERE (b.ban_id IS NULL OR b.ban_exclude = 1)
AND u.user_birthday LIKE CONCAT(IF(LENGTH(@day)>1,'',' '),@day,'-',IF(LENGTH(@month)>1,'',' '),@month,'%')
AND u.user_type IN (0, 3))