1153 MySQL Origin: Data OSI layer 7 · Application Last updated 12 Oct 2026

MySQL ERROR 1153 (08S01): Got a packet bigger than 'max_allowed_packet' bytes

A single statement or row exceeded max_allowed_packet — big BLOBs, huge INSERTs or large dump lines.

Exact message you may see Got a packet bigger than 'max_allowed_packet' bytes
Seen on: MySQL

Meaning

Both server and client have max_allowed_packet. Imports with extended inserts or large BLOB/TEXT values exceed defaults (64 MB in 8.0, 4 MB in older versions).

Common causes

  • Large BLOB/TEXT values
  • Huge multi-row INSERT statements in dumps
  • Low server or client limit

⚡ Quick fix

  1. Raise max_allowed_packet on the server (and client for imports)
  2. Split large inserts
  3. Store large files outside the database

Detailed fix by platform

MySQL

  1. SET GLOBAL max_allowed_packet = 268435456; -- and in my.cnf [mysqld]

How to diagnose

  1. Size — How big is the statement/row?
  2. Limits — Server and client values

🔧 Still not fixed?

Many errors look alike. If the steps above didn’t solve it, one of these is probably what you’re facing:

Where this error sits

Origin: Data. Errors that are often confused with or caused by this one (click to open):

1000 — Cloudflare Error 1000: DNS points to prohibited IP (Cloudflare)10001046 — MySQL ERROR 1046 (3D000): No database selected (MySQL)10461049 — MySQL ERROR 1049 (42000): Unknown database 'x' (MySQL)10491227 — MySQL ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER privilege(s) for this operation (MySQL)12272006 — MySQL ERROR 2006 (HY000): MySQL server has gone away (MySQL)200622021 — ERROR: invalid byte sequence for encoding "UTF8": 0x00 (PostgreSQL)22021AADSTS90002 — AADSTS90002: Tenant 'x' not found (Azure)AADSTS90002AH00558 — Apache: AH00558: apache2: Could not reliably determine the server's fully qualified domain name (Nginx / Apache)AH005581153

Explore the map of this error Full error map →

🧠 Still stuck? Analyze your error

Paste the full message, response headers or stack trace — we'll detect the platform and point to the most likely cause.

💬 What worked for others

No tips yet — did something else fix this for you?

Share what worked for you

Tips are checked by an editor before they appear. Links are removed.