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

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.

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

	Sign In with your My Oracle Support account
	Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms