1275
MySQLerrordatahigh confidence
Uncompressed data size too large
Production Risk
Low — function call fails; no data is modified.
What this means
UNCOMPRESS() received data whose declared uncompressed size exceeds the server limit, or the size field in the compressed data is corrupt.
Why it happens
- 1Corrupted compressed data stored in a BLOB column
- 2Data compressed by a non-MySQL tool with a mismatched header
How to reproduce
trigger — this will error
trigger — this will error
SELECT UNCOMPRESS(corrupted_blob_col) FROM t;
expected output
ERROR 1275 (HY000): Uncompressed data size too large
Fix
Validate compressed data
Validate compressed data
SELECT UNCOMPRESSED_LENGTH(col) FROM t;
Why this works
Shows the declared uncompressed size so you can detect corruption.
What not to do
✕
Sources
Official documentation ↗
MySQL 8.0 — 1275 ER_TOO_BIG_FOR_UNCOMPRESS
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev