My Oracle Support Banner

When Using InnoDB Temporary Table (ibtmp1): "ERROR 1114 (HY000): The table '...' is full" (Doc ID 2307659.1)

Last updated on NOVEMBER 05, 2017

Applies to:

MySQL Server - Version 5.7 and later
Information in this document applies to any platform.

Symptoms

When using internal or explicit temporary tables with the InnoDB storage engine (see also the default_tmp_storage_engine and internal_tmp_disk_storage_engine options), the table is reported even if there is free disk available.

For example for an internal temporary table:

 

Changes

The issue may start after changing innodb_temp_data_file_path to use set a maximum size of the InnoDB temporary table tablespace (ibtmp1), but may also occur without any changes.

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
Changes
Cause
Solution
References

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