MySQL Forums
Forum List  »  Quality Assurance

Re: mysql slave crashes
Posted by: Ilya Antipov
Date: June 21, 2012 12:49PM

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))

Options: ReplyQuote

Written By
June 21, 2012 04:28AM
Re: mysql slave crashes
June 21, 2012 12:49PM
July 05, 2012 02:07AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.