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


Subject
Views
Written By
Posted
2669
June 21, 2012 04:28AM
Re: mysql slave crashes
1344
June 21, 2012 12:49PM
1254
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.