ERROR 1114 (HY000): The table '#sql-xxx' is full Using the MEMORY Engine (Doc ID 1622425.1)

Last updated on MAY 05, 2016

Applies to:

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

Symptoms

When creating, modifying or altering the table engine to MEMORY, you get this error even if max_heap_table_size can host the data:

ERROR 1114 (HY000): The table '#sql-336e_21e' is full

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

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