Bug #69513 InnoDB: Assertion failure in thread 5616 in file ut0lst.h line 271
| Submitted: | 19 Jun 2013 14:22 | Modified: | 18 Aug 2013 13:56 |
|---|---|---|---|
| Reporter: | Ed Segall | Email Updates: | |
| Status: | No Feedback | Impact on me: | |
| Category: | MySQL Server: InnoDB storage engine | Severity: | S3 (Non-critical) |
| Version: | 5.6 | OS: | Windows (Windows 7 Ultimate 64-bit) |
| Assigned to: | CPU Architecture: | Any |
[19 Jun 2013 14:22]
Ed Segall
[19 Jun 2013 14:44]
Shane Bester
Hi! Can you please compress+upload the entire mysql error log?
[20 Jun 2013 19:02]
Sveta Smirnova
Thank you for the feedback. Do you have backup? If yes, please send us output of SHOW CREATE TABLE weightclass_cat and SHOW CREATE TABLE cardb as well as SHOW TABLE STATUS for both tables.
[20 Jun 2013 21:05]
Ed Segall
Are you asking whether I backed up the database? Unfortunately, I did not. I'm in a design phase and the database had little or no data in it, so I just followed some recovery procedures that I found until it appeared to be in a useable state. In fact, I believe that at one point I dropped the schema.
[20 Jun 2013 23:12]
Sveta Smirnova
Thank you for the feedback. Actually what I want to know is table structure for both tables and how many rows they had prior crash. Do you have this information? Since you are "in a design phase" I was hoping you do.
[21 Jun 2013 21:09]
Ed Segall
I believe that neither table had any rows prior to the crash. I don't have a database backup from before the crash, so I can only do `show create table' and `show table status' using the recovered database. (I'll do that in a subsequent comment.) I do have sql exported from the Workbench that I believe was used to create the tables before the problem occurred. I'll include it here: -- ----------------------------------------------------- -- Table `ClassYard`.`weightclass_cat` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `ClassYard`.`weightclass_cat` ( `WeightClass` VARCHAR(1) NULL , `WeightDescription` VARCHAR(50) NULL DEFAULT NULL ) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8; -- ----------------------------------------------------- -- Table `ClassYard`.`cardb` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `ClassYard`.`cardb` ( `CrestTimeStamp` DOUBLE NOT NULL , `CutId` INT(11) NOT NULL , `car_id` VARCHAR(10) NOT NULL , `timeStampStr` DATETIME NULL DEFAULT NULL , `UserLineNum` INT(11) NULL DEFAULT NULL , `NotHump` VARCHAR(1) NULL DEFAULT NULL COMMENT 'EJS: Should this be CHAR?\nShould it relate to a _cat table?' , `CarInfoIndex` INT(11) NULL DEFAULT NULL , `handling_code` VARCHAR(1) NULL COMMENT 'EJS: Should this reference a _cat table?\nHow is this different from yard_handling_code?\nThis column is always empty in NPW database sample. ' , `Commodity` VARCHAR(7) NULL DEFAULT NULL , `IsLoaded` VARCHAR(1) NULL COMMENT 'EJS: Should always be \'T\' or \'F\'' , `CarType` INT(11) NULL DEFAULT NULL , `MIS_Weight` INT(11) NULL DEFAULT NULL , `hump_time` DATETIME NULL COMMENT 'EJS: How is this different from CrestTimeStamp (originally timeStamp)?' , `MovedTF` VARCHAR(1) NULL DEFAULT NULL , `AEIMatchTF` VARCHAR(1) NULL DEFAULT NULL , `WeightCode` VARCHAR(1) NULL COMMENT 'EJS: Should always be \' \' or \'’W’ (for UP)\nNOTE: UP-specific behavior' , `OverWgtValue` INT(11) NULL DEFAULT NULL , `TrainID` INT(11) NULL , `Axles` INT(11) NULL DEFAULT NULL , `MISAxles` INT(11) NULL DEFAULT NULL , `Length` DOUBLE NULL DEFAULT NULL , `MISLength` DOUBLE NULL DEFAULT NULL , `WBTruck` DOUBLE NULL DEFAULT NULL , `WeightClass` INT(11) NULL DEFAULT NULL , `AARCarType` VARCHAR(5) NULL DEFAULT NULL , `CarCode` VARCHAR(5) NULL DEFAULT NULL , `YardHandlingCode` VARCHAR(1) NULL DEFAULT NULL COMMENT 'EJS: How is this different from handlingCode?\nSteve is looking into this. ' , `BearingType` INT(11) NULL DEFAULT NULL , `ArticulatedCount` INT(11) NULL DEFAULT NULL , `OverHand` INT(11) NULL DEFAULT NULL , `SpecialHandling` VARCHAR(7) NULL DEFAULT NULL , `AEIStat` INT(11) NULL DEFAULT NULL , `CarNumInCut` INT(11) NULL DEFAULT -1 , INDEX `car_id` (`car_id` ASC) , INDEX `CarCode` (`CarCode` ASC) , INDEX `timeStamp` (`CrestTimeStamp` ASC) , INDEX `TrainID` (`TrainID` ASC) , INDEX `YardHandlingCode` (`YardHandlingCode` ASC) , PRIMARY KEY (`CrestTimeStamp`, `CutId`) , INDEX `timeStamp_carId` (`CrestTimeStamp` ASC, `car_id` ASC) , INDEX `fk_cardb_cartype_cat1_idx` (`CarType` ASC) , INDEX `fk_cardb_aeistat_cat1_idx` (`AEIStat` ASC) , INDEX `fk_cardb_weightclass_cat1_idx` (`WeightClass` ASC) , INDEX `fk_cardb_cutdb1_idx` (`CrestTimeStamp` ASC, `CutId` ASC) ) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8 COMMENT = 'EJS: Primary key previously used car_id, now uses CutId.';
[21 Jun 2013 21:16]
Ed Segall
mysql> show create table weightclass_cat\G
*************************** 1. row ***************************
Table: weightclass_cat
Create Table: CREATE TABLE `weightclass_cat` (
`WeightClass` varchar(1) NOT NULL,
`WeightDescription` varchar(50) DEFAULT NULL,
PRIMARY KEY (`WeightClass`),
KEY `WeightClass_idx` (`WeightClass`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
1 row in set (0.00 sec)
mysql> show create table cardb\G
*************************** 1. row ***************************
Table: cardb
Create Table: CREATE TABLE `cardb` (
`CrestTimeStamp` double NOT NULL,
`CutId` int(11) NOT NULL,
`car_id` varchar(10) NOT NULL,
`timeStampStr` datetime DEFAULT NULL,
`UserLineNum` int(11) DEFAULT NULL,
`NotHump` varchar(1) DEFAULT NULL COMMENT 'EJS: Should this be CHAR?\nShould it relate to a _cat table?',
`CarInfoIndex` int(11) DEFAULT NULL,
`handling_code` varchar(1) DEFAULT NULL COMMENT 'EJS: Should this reference a _cat table?\nHow is this different from yard_handling_code?\nThis column is always empty in NPW database sample. ',
`Commodity` varchar(7) DEFAULT NULL,
`IsLoaded` varchar(1) DEFAULT NULL COMMENT 'EJS: Should always be ''T'' or ''F''',
`CarType` int(11) DEFAULT NULL,
`MIS_Weight` int(11) DEFAULT NULL,
`hump_time` datetime DEFAULT NULL COMMENT 'EJS: How is this different from CrestTimeStamp (originally timeStamp)?',
`MovedTF` varchar(1) DEFAULT NULL,
`AEIMatchTF` varchar(1) DEFAULT NULL,
`WeightCode` varchar(1) DEFAULT NULL COMMENT 'EJS: Should always be '' '' or ''’W’ (for UP)\nNOTE: UP-specific behavior',
`OverWgtValue` int(11) DEFAULT NULL,
`TrainID` int(11) DEFAULT NULL,
`Axles` int(11) DEFAULT NULL,
`MISAxles` int(11) DEFAULT NULL,
`Length` double DEFAULT NULL,
`MISLength` double DEFAULT NULL,
`WBTruck` double DEFAULT NULL,
`WeightClass` varchar(1) DEFAULT NULL COMMENT 'EJS: Type changed to satisfy MySQL',
`AARCarType` varchar(5) DEFAULT NULL,
`CarCode` varchar(5) DEFAULT NULL,
`YardHandlingCode` varchar(1) DEFAULT NULL COMMENT 'EJS: How is this different from handlingCode?\nSteve is looking into this. ',
`BearingType` int(11) DEFAULT NULL,
`ArticulatedCount` int(11) DEFAULT NULL,
`OverHand` int(11) DEFAULT NULL,
`SpecialHandling` varchar(7) DEFAULT NULL,
`AEIStat` int(11) DEFAULT NULL,
`CarNumInCut` int(11) DEFAULT '-1',
PRIMARY KEY (`CrestTimeStamp`,`CutId`),
KEY `car_id` (`car_id`),
KEY `CarCode` (`CarCode`),
KEY `timeStamp` (`CrestTimeStamp`),
KEY `TrainID` (`TrainID`),
KEY `YardHandlingCode` (`YardHandlingCode`),
KEY `timeStamp_carId` (`CrestTimeStamp`,`car_id`),
KEY `fk_cardb_cartype_cat1_idx` (`CarType`),
KEY `fk_cardb_aeistat_cat1_idx` (`AEIStat`),
KEY `fk_cardb_weightclass_cat1_idx` (`WeightClass`),
KEY `fk_cardb_cutdb1_idx` (`CrestTimeStamp`,`CutId`),
CONSTRAINT `fk_cardb_aeistat_cat1` FOREIGN KEY (`AEIStat`) REFERENCES `aeistat_cat` (`AEIStat`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_cardb_cutdb1` FOREIGN KEY (`CrestTimeStamp`, `CutId`) REFERENCES `cutdb` (`CrestTimeStamp`, `CutId`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_cardb_cartype_cat1` FOREIGN KEY (`CarType`) REFERENCES `cartype_cat` (`CarType_Id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_cardb_weightclass_cat1` FOREIGN KEY (`WeightClass`) REFERENCES `weightclass_cat` (`WeightClass`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='EJS: Primary key previously used car_id, now uses CutId.'
1 row in set (0.00 sec)
mysql> show table status like 'weightclass_cat'\G
*************************** 1. row ***************************
Name: weightclass_cat
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 0
Avg_row_length: 0
Data_length: 16384
Max_data_length: 0
Index_length: 16384
Data_free: 0
Auto_increment: NULL
Create_time: 2013-06-19 14:33:56
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment:
1 row in set (0.00 sec)
mysql> show table status like 'cardb'\G
*************************** 1. row ***************************
Name: cardb
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 0
Avg_row_length: 0
Data_length: 16384
Max_data_length: 0
Index_length: 163840
Data_free: 0
Auto_increment: NULL
Create_time: 2013-06-19 11:51:52
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: EJS: Primary key previously used car_id, now uses CutId.
1 row in set (0.00 sec)
[18 Jul 2013 13:56]
Sveta Smirnova
Thank you for the feedback. Looks like we need also output of SHOW CREATE TABLE cutdb and SHOW CREATE TABLE of all tables, referenced by foreign key constraints.
[19 Aug 2013 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".
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.048 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
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.