1275
MariaDBerrordatahigh 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
  1. 1Corrupted compressed data stored in a BLOB column
  2. 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

← All MariaDB errors