1276
MySQLerrorserverhigh confidence

ZLIB: Not enough memory

Production Risk

Medium — indicates the server is low on memory, which may affect other queries.

What this means

A COMPRESS() or UNCOMPRESS() call failed because the zlib library could not allocate enough memory.

Why it happens
  1. 1Server is under memory pressure
  2. 2Very large compression/decompression operation on a low-memory system
How to reproduce
trigger — this will error
trigger — this will error
SELECT COMPRESS(REPEAT('x', 1000000));

expected output

ERROR 1276 (HY000): ZLIB: Not enough memory

Fix 1

Increase available memory

Why this works

Reduce concurrent workload or increase server RAM.

Fix 2

Process data in smaller chunks

Why this works

Split large BLOB operations into smaller batches.

What not to do

Sources
Official documentation ↗

MySQL 8.0 — 1276 ER_ZLIB_Z_MEM_ERROR

Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev

← All MySQL errors