Bug #45443 | mysql innodb error | ||
---|---|---|---|
Submitted: | 11 Jun 2009 8:55 | Modified: | 16 Jul 2009 7:01 |
Reporter: | Sunny Liu | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server: InnoDB storage engine | Severity: | S3 (Non-critical) |
Version: | 5.0.67 | OS: | Linux (RedHat AS5 X64) |
Assigned to: | CPU Architecture: | Any | |
Tags: | innodb |
[11 Jun 2009 8:55]
Sunny Liu
[11 Jun 2009 9:07]
Sveta Smirnova
Thank you for the report. But version 5.0.67 is old. Please try with current version 5.0.82 and if failure happens again provide output of SHOW CREATE TABLE receive472 and SHOW TABLE STATUS LIKE 'receive472'
[11 Jun 2009 9:08]
Valeriy Kravchuk
Thank you for the problem report. Please, send your entire error log (compressed) and the results of: show create table receive472\G show table status like 'receive472'\G
[11 Jun 2009 10:24]
Sunny Liu
mysql> show create table receive472\G *************************** 1. row *************************** Table: receive472 Create Table: CREATE TABLE `receive472` ( `id` int(11) NOT NULL default '0', `toId` int(11) NOT NULL default '0', `toName` varchar(32) NOT NULL default '', `fromId` int(11) NOT NULL default '0', `fromName` varchar(32) NOT NULL default '', `creatorTime` datetime NOT NULL, `msgState` tinyint(4) NOT NULL default '0', `msgType` int(11) NOT NULL default '0', `msgSubject` varchar(32) NOT NULL default '', `msgContent` mediumtext, `fromSource` varchar(32) NOT NULL default '', PRIMARY KEY (`id`), KEY `toId_fromId_creatorTime` (`toId`,`fromId`,`creatorTime`), KEY `toId_creatorTime` (`toId`,`creatorTime`) ) ENGINE=InnoDB DEFAULT CHARSET=gbk 1 row in set (0.00 sec) mysql> show table status like 'receive472'\G *************************** 1. row *************************** Name: receive472 Engine: InnoDB Version: 10 Row_format: Compact Rows: 30549 Avg_row_length: 292 Data_length: 8929280 Max_data_length: 0 Index_length: 3162112 Data_free: 0 Auto_increment: NULL Create_time: 2009-06-11 15:20:44 Update_time: NULL Check_time: NULL Collation: gbk_chinese_ci Checksum: NULL Create_options: Comment: InnoDB free: 4096 kB 1 row in set (0.05 sec) mysql>
[12 Jun 2009 9:46]
Sunny Liu
error log
Attachment: waptx124.waptx.com(1).rar (application/octet-stream, text), 56.64 KiB.
[16 Jun 2009 7:01]
Sveta Smirnova
Thank you for the feedback. Before error described you have in the error log file: ----<q>----- 090609 15:17:58 InnoDB: Error: trying to open a table, but could not InnoDB: open the tablespace file './tximbase/receive472.ibd'! InnoDB: Have you moved InnoDB .ibd files around without using the InnoDB: commands DISCARD TABLESPACE and IMPORT TABLESPACE? ----</q>---- Have you fixed this problem?
[16 Jul 2009 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".