1114 MySQL Origin: Data OSI layer 7 · Application Last updated 10 Oct 2026

MySQL ERROR 1114 (HY000): The table 'x' is full

MySQL couldn’t extend the table — disk full, a size limit, or a MEMORY table hitting max_heap_table_size.

Exact message you may see The table is full
Seen on: MySQL

Meaning

Usually the disk (or the tmpdir) is out of space; for in-memory temporary tables, tmp_table_size/max_heap_table_size limits.

Common causes

  • Disk or tmpdir full
  • MEMORY table limit
  • innodb_data_file_path autoextend disabled

⚡ Quick fix

  1. Free disk space (df -h)
  2. Raise tmp_table_size/max_heap_table_size
  3. Check tmpdir location

Detailed fix by platform

Linux

  1. df -h /var/lib/mysql /tmp

How to diagnose

  1. Disk — Space left?
  2. Table — MEMORY or temp table?

🔧 Still not fixed?

Many errors look alike. If the steps above didn’t solve it, one of these is probably what you’re facing:

Where this error sits

Origin: Data. Errors that are often confused with or caused by this one (click to open):

1040 — MySQL ERROR 1040 (08004): Too many connections (MySQL)10401105 — SQL Server Error 1105: Could not allocate space for object in database because the PRIMARY filegroup is full (SQL)1105126 incorrect key file — MySQL ERROR 126 (HY000): Incorrect key file for table; try to repair it (MySQL)126 incorrect key file503 — HTTP 503 Service Unavailable (HTTP)503508 — HTTP 508 Loop Detected (Resource Limit Is Reached) (HTTP)508509 — HTTP 509 Bandwidth Limit Exceeded (HTTP)50953100 — ERROR: could not extend file "base/…": No space left on device (PostgreSQL)53100AuthenticationFailed — Azure Storage: Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature (AuthenticationFailed) (Azure)AuthenticationFailed1114

Explore the map of this error Full error map →

🧠 Still stuck? Analyze your error

Paste the full message, response headers or stack trace — we'll detect the platform and point to the most likely cause.

💬 What worked for others

No tips yet — did something else fix this for you?

Share what worked for you

Tips are checked by an editor before they appear. Links are removed.