My Oracle Support Banner

Table is Full Error for InnoDB Tables (Doc ID 1356573.1)

Last updated on FEBRUARY 10, 2019

Applies to:

MySQL Server - Version 4.0 and later
Information in this document applies to any platform.
***Checked for relevance on 22-jun-2014***

Symptoms

There are two variations of this error happening:

Versions 4.x, 5.0.84 and earlier, 5.1.37 and earlier, and 5.1.40 with InnoDB plugin and earlier

When running one of the following versions of MySQL Server:


When having more than 1023 active transactions and error message "Table is Full" is returned to the client. Sometimes an assertion error is happening instead. The error log will contain a more descriptive error message:

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
 Versions 4.x, 5.0.84 and earlier, 5.1.37 and earlier, and 5.1.40 with InnoDB plugin and earlier
 All versions using fixed size InnoDB tablespace and not using innodb_file_per_table
 Reproducing the Issue:
 All versions using an autoextend InnoDB tablespace including using innodb_file_per_table
Cause
 Versions 4.x, 5.0.84 and earlier, 5.1.37 and earlier, and 5.1.40 with InnoDB plugin and earlier
 All versions using fixed size InnoDB tablespace and not using innodb_file_per_table
 All versions using an autoextend InnoDB tablespace including using innodb_file_per_table
Solution
 Versions 4.x, 5.0.84 and earlier, 5.1.37 and earlier, and 5.1.40 with InnoDB plugin and earlier
 All versions using fixed size InnoDB tablespace and not using innodb_file_per_table
 All versions using an autoextend InnoDB tablespace including using innodb_file_per_table
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.