| Bug #52132 | MySQL Server Crash | ||
|---|---|---|---|
| Submitted: | 17 Mar 2010 10:10 | Modified: | 29 Apr 2010 10:09 |
| Reporter: | Eyal Sorek | Email Updates: | |
| Status: | No Feedback | Impact on me: | |
| Category: | MySQL Server | Severity: | S1 (Critical) |
| Version: | 5.1.44-community | OS: | Linux (Centos 5.3 64 bit) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | crash recover InnoDB Assertion failure buf0flu.c | ||
[17 Mar 2010 10:10]
Eyal Sorek
[17 Mar 2010 12:32]
Valeriy Kravchuk
Looks similar to Bug #34076.
[17 Mar 2010 13:57]
Eyal Sorek
Hi, It looks like the table is corrupted. I am trying to do now again - select count(instance_id) from <table-name>; - and I get - ERROR 2013 (HY000): Lost connection to MySQL server during query. Anyway I can repair this innodb table ? Thanks, Eyal
[17 Mar 2010 14:38]
Valeriy Kravchuk
Please, try to run: check table <table-name>; and check if it reports any problems. I'd try to make a dump of this table using mysqldump or select * from table into outfile ..., just for backup. You can also try to do alter table <table-name> engine=InnoDB; to rebuild table and indexes. alter table <table-name>;
[18 Mar 2010 13:16]
Eyal Sorek
Hi, I tried all options suggested. Nothing helped. Any other idea ? It happened to me few times. Can you elaborate on the root cause of it ? Any planned fix for it ? Thanks, Eyal.
[25 Mar 2010 3:08]
MySQL Verification Team
Thank you for the feedback. Could you please provide the create table statement for the table offended?. Thanks in advance.
[25 Mar 2010 14:24]
Eyal Sorek
See below:
mysql> show create table ad_mapping\G
*************************** 1. row ***************************
Table: ad_mapping
Create Table: CREATE TABLE `tab_x` (
`instance_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`creation_date` date NOT NULL DEFAULT '0000-00-00',
`col1_id` int(11) DEFAULT NULL,
`col2_id` int(11) NOT NULL,
`col3_id` int(11) NOT NULL,
`col4_id` int(11) NOT NULL,
`col5_id` int(11) NOT NULL,
`col7` varchar(30) COLLATE utf8_bin NOT NULL,
`col8_id` int(11) NOT NULL,
`col9_id` int(11) NOT NULL,
`col10_id` int(11) NOT NULL,
`due_timestamp` datetime NOT NULL,
`col12` varchar(30) COLLATE utf8_bin DEFAULT NULL,
`col13` int(11) NOT NULL,
`col14` tinyint(1) NOT NULL,
`col15` float DEFAULT NULL,
`col16_id` int(10) unsigned DEFAULT NULL,
`col17_delta_time` int(11) DEFAULT NULL,
`col18` tinyint(1) NOT NULL,
`col19` float NOT NULL,
`col20_id` int(11) NOT NULL,
`timestamp` datetime DEFAULT NULL,
`col22_other_timestamp` datetime DEFAULT NULL,
`col23_id` int(11) DEFAULT NULL,
PRIMARY KEY (`instance_id`,`creation_date`)
) ENGINE=InnoDB AUTO_INCREMENT=13386021 DEFAULT CHARSET=utf8 COLLATE=utf8_bin
/*!50100 PARTITION BY RANGE (to_days(creation_date))
(PARTITION p_734203 VALUES LESS THAN (734203) ENGINE = InnoDB,
PARTITION p_734204 VALUES LESS THAN (734204) ENGINE = InnoDB,
PARTITION p_734205 VALUES LESS THAN (734205) ENGINE = InnoDB,
PARTITION p_734206 VALUES LESS THAN (734206) ENGINE = InnoDB,
PARTITION p_734207 VALUES LESS THAN (734207) ENGINE = InnoDB,
PARTITION p_734208 VALUES LESS THAN (734208) ENGINE = InnoDB,
PARTITION p_734209 VALUES LESS THAN (734209) ENGINE = InnoDB,
PARTITION p_734210 VALUES LESS THAN (734210) ENGINE = InnoDB,
PARTITION p_734211 VALUES LESS THAN (734211) ENGINE = InnoDB,
PARTITION p_734212 VALUES LESS THAN (734212) ENGINE = InnoDB,
PARTITION p_734213 VALUES LESS THAN (734213) ENGINE = InnoDB,
PARTITION p_734214 VALUES LESS THAN (734214) ENGINE = InnoDB,
PARTITION p_734215 VALUES LESS THAN (734215) ENGINE = InnoDB,
PARTITION p_734216 VALUES LESS THAN (734216) ENGINE = InnoDB,
PARTITION p_734217 VALUES LESS THAN (734217) ENGINE = InnoDB,
PARTITION p_734218 VALUES LESS THAN (734218) ENGINE = InnoDB,
PARTITION p_734219 VALUES LESS THAN (734219) ENGINE = InnoDB,
PARTITION p_734220 VALUES LESS THAN (734220) ENGINE = InnoDB,
PARTITION p_734221 VALUES LESS THAN (734221) ENGINE = InnoDB,
PARTITION p_734222 VALUES LESS THAN (734222) ENGINE = InnoDB,
PARTITION p_734223 VALUES LESS THAN (734223) ENGINE = InnoDB,
PARTITION p_734224 VALUES LESS THAN (734224) ENGINE = InnoDB,
PARTITION p_734225 VALUES LESS THAN (734225) ENGINE = InnoDB,
PARTITION p_734226 VALUES LESS THAN (734226) ENGINE = InnoDB,
PARTITION p_734227 VALUES LESS THAN (734227) ENGINE = InnoDB,
PARTITION p_734228 VALUES LESS THAN (734228) ENGINE = InnoDB,
PARTITION p_734229 VALUES LESS THAN (734229) ENGINE = InnoDB,
PARTITION p_734230 VALUES LESS THAN (734230) ENGINE = InnoDB,
PARTITION p_734231 VALUES LESS THAN (734231) ENGINE = InnoDB,
PARTITION p_734232 VALUES LESS THAN (734232) ENGINE = InnoDB,
PARTITION p_734233 VALUES LESS THAN (734233) ENGINE = InnoDB,
PARTITION p_734234 VALUES LESS THAN (734234) ENGINE = InnoDB,
PARTITION p_734235 VALUES LESS THAN (734235) ENGINE = InnoDB,
PARTITION p_734236 VALUES LESS THAN (734236) ENGINE = InnoDB,
PARTITION p_734237 VALUES LESS THAN (734237) ENGINE = InnoDB,
PARTITION p_734238 VALUES LESS THAN (734238) ENGINE = InnoDB,
PARTITION p_734239 VALUES LESS THAN (734239) ENGINE = InnoDB,
PARTITION p_734240 VALUES LESS THAN (734240) ENGINE = InnoDB,
PARTITION p_734241 VALUES LESS THAN (734241) ENGINE = InnoDB,
PARTITION p_734242 VALUES LESS THAN (734242) ENGINE = InnoDB,
PARTITION p_734243 VALUES LESS THAN (734243) ENGINE = InnoDB,
PARTITION p_734244 VALUES LESS THAN (734244) ENGINE = InnoDB,
PARTITION p_734245 VALUES LESS THAN (734245) ENGINE = InnoDB,
PARTITION p_734246 VALUES LESS THAN (734246) ENGINE = InnoDB,
PARTITION p_734247 VALUES LESS THAN (734247) ENGINE = InnoDB,
PARTITION p_734248 VALUES LESS THAN (734248) ENGINE = InnoDB,
PARTITION p_734249 VALUES LESS THAN (734249) ENGINE = InnoDB,
PARTITION p_734250 VALUES LESS THAN (734250) ENGINE = InnoDB,
PARTITION p_734251 VALUES LESS THAN (734251) ENGINE = InnoDB,
PARTITION p_734252 VALUES LESS THAN (734252) ENGINE = InnoDB,
PARTITION p_734253 VALUES LESS THAN (734253) ENGINE = InnoDB,
PARTITION p_734254 VALUES LESS THAN (734254) ENGINE = InnoDB,
PARTITION p_734255 VALUES LESS THAN (734255) ENGINE = InnoDB,
PARTITION p_734256 VALUES LESS THAN (734256) ENGINE = InnoDB) */
[29 Mar 2010 10:09]
Sveta Smirnova
Thank you for the feedback. I can not repeat described behavior with test data. Please provide example of INSERT and SELECT queries you are using and your configuration file. Please also indicate how much physical RAM do you have.
[29 Apr 2010 23: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".
