| Bug #66508 | Slaves continually crash | ||
|---|---|---|---|
| Submitted: | 22 Aug 2012 23:50 | Modified: | 7 Oct 2012 17:56 |
| Reporter: | Michael Finch | Email Updates: | |
| Status: | No Feedback | Impact on me: | |
| Category: | MySQL Server: Replication | Severity: | S1 (Critical) |
| Version: | 5.5.25a | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | crash, relay-log, slave | ||
[22 Aug 2012 23:50]
Michael Finch
[23 Aug 2012 5:55]
Valeriy Kravchuk
Can you try to get crashing statement from the binary log?
[27 Aug 2012 17:37]
Michael Finch
The slaves crashed here. I removed the master.info on the slaves, ran this update manually, and then pointed them to the next position in the binlog and they were fine.
# at 559560948
#120822 16:19:56 server id 1 end_log_pos 559561022 Query thread_id=39552912 exec_time=0 error_code=0
SET TIMESTAMP=1345677596/*!*/;
BEGIN
/*!*/;
# at 559561022
#120822 16:19:56 server id 1 end_log_pos 559561509 Query thread_id=39552912 exec_time=0 error_code=0
SET TIMESTAMP=1345677596/*!*/;
UPDATE weekly_keywordgroup_overview_universal SET
num_keywords_universal_across_domain='{"70": 0, "40": 0, "10": 0, "75": 0, "79": 0, "50": 5, "20": 0, "-1": 5, "60": 0, "30": 0}',
num_keywords_universal='{"70": 0, "40": 0, "10": 0, "75": 0, "79": 0, "50": 5, "20": 0, "-1": 5, "60": 0, "30": 0}',
num_keywords=7
WHERE account_id=4727 AND search_engine_id=34 AND domain_id=113 AND week=201226 AND keyword_group_id=7524
/*!*/;
# at 559561509
#120822 16:19:56 server id 1 end_log_pos 559561536 Xid = 280411802
COMMIT/*!*/;
Thanks
[6 Sep 2012 18:52]
Sveta Smirnova
Thank you for the feedback. Please provide output of SHOW CREATE TABLE weekly_keywordgroup_overview_universal
[6 Sep 2012 20:51]
Michael Finch
mysql> SHOW CREATE TABLE weekly_keywordgroup_overview_universal\G
*************************** 1. row ***************************
Table: weekly_keywordgroup_overview_universal
Create Table: CREATE TABLE `weekly_keywordgroup_overview_universal` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`account_id` int(6) unsigned NOT NULL,
`week` int(6) unsigned NOT NULL,
`search_engine_id` int(4) unsigned DEFAULT NULL,
`domain_id` int(11) unsigned NOT NULL,
`keyword_group_id` int(11) NOT NULL,
`num_keywords_universal_across_domain` varchar(200) DEFAULT NULL,
`num_keywords_universal` varchar(200) DEFAULT NULL,
`num_keywords` int(11) DEFAULT '0',
PRIMARY KEY (`id`,`week`),
UNIQUE KEY `unique_index` (`week`,`account_id`,`search_engine_id`,`domain_id`,`keyword_group_id`) USING HASH
) ENGINE=InnoDB AUTO_INCREMENT=6294348 DEFAULT CHARSET=latin1
/*!50100 PARTITION BY RANGE (week)
(PARTITION p0 VALUES LESS THAN (201122) ENGINE = InnoDB,
PARTITION p1 VALUES LESS THAN (201123) ENGINE = InnoDB,
PARTITION p2 VALUES LESS THAN (201124) ENGINE = InnoDB,
PARTITION p3 VALUES LESS THAN (201125) ENGINE = InnoDB,
PARTITION p4 VALUES LESS THAN (201126) ENGINE = InnoDB,
PARTITION p5 VALUES LESS THAN (201127) ENGINE = InnoDB,
PARTITION p6 VALUES LESS THAN (201128) ENGINE = InnoDB,
PARTITION p7 VALUES LESS THAN (201129) ENGINE = InnoDB,
PARTITION p8 VALUES LESS THAN (201130) ENGINE = InnoDB,
PARTITION p9 VALUES LESS THAN (201131) ENGINE = InnoDB,
PARTITION p10 VALUES LESS THAN (201132) ENGINE = InnoDB,
PARTITION p11 VALUES LESS THAN (201133) ENGINE = InnoDB,
PARTITION p12 VALUES LESS THAN (201134) ENGINE = InnoDB,
PARTITION p13 VALUES LESS THAN (201135) ENGINE = InnoDB,
PARTITION p14 VALUES LESS THAN (201136) ENGINE = InnoDB,
PARTITION p15 VALUES LESS THAN (201137) ENGINE = InnoDB,
PARTITION p16 VALUES LESS THAN (201138) ENGINE = InnoDB,
PARTITION p17 VALUES LESS THAN (201139) ENGINE = InnoDB,
PARTITION p18 VALUES LESS THAN (201140) ENGINE = InnoDB,
PARTITION p19 VALUES LESS THAN (201141) ENGINE = InnoDB,
PARTITION p20 VALUES LESS THAN (201142) ENGINE = InnoDB,
PARTITION p21 VALUES LESS THAN (201143) ENGINE = InnoDB,
PARTITION p22 VALUES LESS THAN (201144) ENGINE = InnoDB,
PARTITION p23 VALUES LESS THAN (201145) ENGINE = InnoDB,
PARTITION p24 VALUES LESS THAN (201146) ENGINE = InnoDB,
PARTITION p25 VALUES LESS THAN (201147) ENGINE = InnoDB,
PARTITION p26 VALUES LESS THAN (201148) ENGINE = InnoDB,
PARTITION p27 VALUES LESS THAN (201149) ENGINE = InnoDB,
PARTITION p28 VALUES LESS THAN (201150) ENGINE = InnoDB,
PARTITION p29 VALUES LESS THAN (201151) ENGINE = InnoDB,
PARTITION p30 VALUES LESS THAN (201152) ENGINE = InnoDB,
PARTITION p31 VALUES LESS THAN (201201) ENGINE = InnoDB,
PARTITION p32 VALUES LESS THAN (201202) ENGINE = InnoDB,
PARTITION p33 VALUES LESS THAN (201203) ENGINE = InnoDB,
PARTITION p34 VALUES LESS THAN (201204) ENGINE = InnoDB,
PARTITION p35 VALUES LESS THAN (201205) ENGINE = InnoDB,
PARTITION p36 VALUES LESS THAN (201206) ENGINE = InnoDB,
PARTITION p37 VALUES LESS THAN (201207) ENGINE = InnoDB,
PARTITION p38 VALUES LESS THAN (201208) ENGINE = InnoDB,
PARTITION p39 VALUES LESS THAN (201209) ENGINE = InnoDB,
PARTITION p40 VALUES LESS THAN (201210) ENGINE = InnoDB,
PARTITION p41 VALUES LESS THAN (201211) ENGINE = InnoDB,
PARTITION p42 VALUES LESS THAN (201212) ENGINE = InnoDB,
PARTITION p43 VALUES LESS THAN (201213) ENGINE = InnoDB,
PARTITION p44 VALUES LESS THAN (201214) ENGINE = InnoDB,
PARTITION p45 VALUES LESS THAN (201215) ENGINE = InnoDB,
PARTITION p46 VALUES LESS THAN (201216) ENGINE = InnoDB,
PARTITION p47 VALUES LESS THAN (201217) ENGINE = InnoDB,
PARTITION p48 VALUES LESS THAN (201218) ENGINE = InnoDB,
PARTITION p49 VALUES LESS THAN (201219) ENGINE = InnoDB,
PARTITION p50 VALUES LESS THAN (201220) ENGINE = InnoDB,
PARTITION p51 VALUES LESS THAN (201221) ENGINE = InnoDB,
PARTITION p52 VALUES LESS THAN (201222) ENGINE = InnoDB,
PARTITION p53 VALUES LESS THAN (201223) ENGINE = InnoDB,
PARTITION p54 VALUES LESS THAN (201224) ENGINE = InnoDB,
PARTITION p55 VALUES LESS THAN (201225) ENGINE = InnoDB,
PARTITION p56 VALUES LESS THAN (201226) ENGINE = InnoDB,
PARTITION p57 VALUES LESS THAN (201227) ENGINE = InnoDB,
PARTITION p58 VALUES LESS THAN (201228) ENGINE = InnoDB,
PARTITION p59 VALUES LESS THAN (201229) ENGINE = InnoDB,
PARTITION p60 VALUES LESS THAN (201230) ENGINE = InnoDB,
PARTITION p61 VALUES LESS THAN (201231) ENGINE = InnoDB,
PARTITION p62 VALUES LESS THAN (201232) ENGINE = InnoDB,
PARTITION p63 VALUES LESS THAN (201233) ENGINE = InnoDB,
PARTITION p64 VALUES LESS THAN (201234) ENGINE = InnoDB,
PARTITION p65 VALUES LESS THAN (201235) ENGINE = InnoDB,
PARTITION p66 VALUES LESS THAN (201236) ENGINE = InnoDB,
PARTITION p67 VALUES LESS THAN (201237) ENGINE = InnoDB,
PARTITION p68 VALUES LESS THAN (201238) ENGINE = InnoDB,
PARTITION p69 VALUES LESS THAN (201239) ENGINE = InnoDB,
PARTITION p70 VALUES LESS THAN (201240) ENGINE = InnoDB,
PARTITION p71 VALUES LESS THAN (201241) ENGINE = InnoDB,
PARTITION p72 VALUES LESS THAN (201242) ENGINE = InnoDB,
PARTITION p73 VALUES LESS THAN (201243) ENGINE = InnoDB,
PARTITION p74 VALUES LESS THAN (201244) ENGINE = InnoDB,
PARTITION p75 VALUES LESS THAN (201245) ENGINE = InnoDB,
PARTITION p76 VALUES LESS THAN (201246) ENGINE = InnoDB,
PARTITION p77 VALUES LESS THAN (201247) ENGINE = InnoDB,
PARTITION p78 VALUES LESS THAN (201248) ENGINE = InnoDB,
PARTITION p79 VALUES LESS THAN (201249) ENGINE = InnoDB,
PARTITION p80 VALUES LESS THAN (201250) ENGINE = InnoDB,
PARTITION p81 VALUES LESS THAN (201251) ENGINE = InnoDB,
PARTITION p82 VALUES LESS THAN (201252) ENGINE = InnoDB,
PARTITION p83 VALUES LESS THAN (201301) ENGINE = InnoDB,
PARTITION p84 VALUES LESS THAN (201302) ENGINE = InnoDB,
PARTITION p85 VALUES LESS THAN (201303) ENGINE = InnoDB,
PARTITION p86 VALUES LESS THAN (201304) ENGINE = InnoDB,
PARTITION p87 VALUES LESS THAN (201305) ENGINE = InnoDB,
PARTITION p88 VALUES LESS THAN (201306) ENGINE = InnoDB,
PARTITION p89 VALUES LESS THAN (201307) ENGINE = InnoDB,
PARTITION pmax VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */
1 row in set (0.00 sec)
[7 Sep 2012 17:56]
Sveta Smirnova
Thank you for the feedback. I can not repeat described behavior. Please try with current version 5.5.27 and inform us if problem still exists.
[8 Oct 2012 1:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
