MySQL error 1114: The table is full
MySQL couldn't add rows to a table: the disk or tablespace is full, or an in-memory or temporary table hit its size limit.
- Error number
1114- Name
ER_RECORD_FILE_FULL- SQLSTATE
HY000- Category
- Server limits and settings
What it means
1114 means the storage behind the table can't grow. For InnoDB that's usually the disk or a fixed-size tablespace; for MEMORY tables it's max_heap_table_size; and for internal temporary tables built during big GROUP BY or ORDER BY queries it can be the temporary storage limit. The server error log usually says which.
Common causes
- The disk holding the data directory (or
tmpdir) is full. - An InnoDB system or shared tablespace with a maximum size (
innodb_data_file_pathwithoutautoextend, or withmax). - A
MEMORYtable larger thanmax_heap_table_size. - A large query whose internal temporary table exceeds its limit, such as
temptable_max_ramandtemptable_max_mmapin MySQL 8.0.
How to fix it
-
Check free disk space on the data and temporary directories, and the server error log.
-
Check the settings that cap table sizes.
SHOW VARIABLES WHERE Variable_name IN ('innodb_data_file_path', 'max_heap_table_size', 'tmp_table_size', 'tmpdir'); -
Free or add disk space, and let the tablespace autoextend. For
MEMORYtables, raise the limit for the session and recreate the table.SET SESSION max_heap_table_size = 512 * 1024 * 1024;
Related errors
1206Locks exceed the lock table size1105SQL Server: Filegroup is full, cannot allocate1101SQL Server: Could not allocate a new page53100PostgreSQL: disk full
More server limits and settings errors
1040Too many connections1203User has more than max_user_connections1153Got a packet bigger than max_allowed_packet1175Safe update mode blocked the statement1290Server option prevents this statement
The code and message text are from the MySQL 8.4 Error Message Reference. Browse the full MySQL error list or search every database error.
Work on MySQL in SQLly
A native SQL client for macOS, Windows and Linux with schema-aware IntelliSense, guardrails for risky statements and clear error messages, for MySQL and the other databases you use.