1479
MySQLERRORNotableConnection / SessionHIGH confidence
Got a packet bigger than max_allowed_packet bytes
Production Risk
Medium — the query fails; increase max_allowed_packet or reduce payload size.
What this means
ER_OVERSIZE_PACKET (1479, SQLSTATE HY000) is raised when a network packet received by MySQL exceeds the max_allowed_packet limit.
Why it happens
- 1Client sending a very large query or BLOB data that exceeds max_allowed_packet
- 2Replication binlog event larger than max_allowed_packet on the replica
- 3max_allowed_packet configured too small for the application workload
How to reproduce
trigger — this will error
trigger — this will error
-- Inserting data larger than max_allowed_packet:
INSERT INTO blob_table (data) VALUES (REPEAT('x', 20000000));
-- If max_allowed_packet < 20MBexpected output
ERROR 1479 (HY000): Got a packet bigger than 'max_allowed_packet' bytes
Fix
Increase max_allowed_packet
Increase max_allowed_packet
-- Increase dynamically: SET GLOBAL max_allowed_packet = 67108864; -- 64MB -- Or in my.cnf: -- max_allowed_packet = 64M
Why this works
Raising max_allowed_packet allows larger queries and data packets to be processed.
Sources
Official documentation ↗
MySQL 8.0 — 1479 ER_OVERSIZE_PACKET
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev