EC
1522
MySQLERRORNotablePartitioningHIGH confidence

At least one partition must be coalesced

Production Risk

Low — the ALTER TABLE fails; specify a valid count.

What this means

ER_COALESCE_PARTITION_NO_PARTITION (1522, SQLSTATE HY000) is raised when ALTER TABLE COALESCE PARTITION is executed with a count of 0.

Why it happens
  1. 1COALESCE PARTITION 0 specified, which does not reduce any partitions
How to reproduce
trigger — this will error
trigger — this will error
ALTER TABLE t COALESCE PARTITION 0;  -- Must be at least 1

expected output

ERROR 1522 (HY000): At least one partition must be coalesced

Fix

Specify a positive number of partitions to coalesce

Specify a positive number of partitions to coalesce
ALTER TABLE t COALESCE PARTITION 2;  -- Reduce by 2

Why this works

COALESCE PARTITION requires a positive integer to specify how many partitions to remove.

Sources
Official documentation ↗

MySQL 8.0 — 1522 ER_COALESCE_PARTITION_NO_PARTITION

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

← All MySQL errors