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

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:

• Any version of MySQL 4.0 and 4.1
• 5.0.84 and earlier
• For MySQL 5.1 without the InnoDB Plugin: 5.1.37 and earlier
• For MySQL 5.1 with the InnoDB Plugin: 5.1.40 and earlier

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

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