InnoDB "The Table is Full" error

Question

I have a MySQL InnoDB table on a RedHat Enterprise Linux 4 server, and after trying to import a database previously backed up using mysqldump I got a "the table is full" error.

The table currently has 463,062 rows in it, and the ibdata1 file on disk is currently 3.37Gb. A quick "SHOW VARIABLES;" shows that the innodb_data_file_path is set to ibdata1:10M:autoextend, and the filesystem is ext3, so I'd expect it to have plenty of room left to grow.

Any ideas how I can go about establishing exactly what the problem is?

D'oh! Really obvious answer is that the disk was full... It wasn't stored on the partition that I expected it to be — andygeers, Apr 24 '09 at 08:01
possible duplicate of [ERROR 1114 (HY000): The table is full](http://stackoverflow.com/questions/730579/error-1114-hy000-the-table-is-full) — tripleee, Mar 05 '15 at 05:45

score 16 · Accepted Answer · answered Mar 26 '10 at 11:26

16

Check that the disk the InnoDB data file is stored on isn't full

answered Mar 26 '10 at 11:26

andygeers

6,909
9
49
63

score 3 · Answer 2 · answered Sep 23 '11 at 21:24

3

We fixed the exact same issue on CentOS on AWS. Contray to what most of the posts indicate, this can be fixed by adding right below the [mysqld] section in your my.cnf file:

innodb_data_file_path=ibdata1:10G:autoextend

answered Sep 23 '11 at 21:24

Tudip Technologies

39
3

score 3 · Answer 3 · answered Apr 23 '09 at 16:22

If I was you I would try actually setting the last part of the innodb_data_file_path command i.e. innodb_data_file_path ibdata1:10M:autoextend:max:3999M

Not specifying the large number can sometimes have it default to unpredicatable numbers.

Not to be too obvious but ensure you restart after making the config change!

InnoDB "The Table is Full" error

3 Answers3

Linked