EC
1184
MySQLERRORNotableConnectionHIGH confidence

Aborted connection due to communication error

Production Risk

Medium — frequent aborted connections indicate connection management problems.

What this means

ER_NEW_ABORTING_CONNECTION (1184, SQLSTATE HY000) is logged when MySQL aborts a client connection because of a network read error. This appears in the MySQL error log and indicates dropped connections or network instability.

Why it happens
  1. 1Client application crashed or exited without closing the connection
  2. 2Network timeout or packet loss between client and server
  3. 3Firewall or load balancer terminating idle connections
  4. 4wait_timeout or interactive_timeout exceeded
How to reproduce
trigger — this will error
trigger — this will error
-- Not directly triggerable; appears in error log when client drops connection

expected output

ERROR 1184 (HY000): Aborted connection N to db: 'mydb' user: 'myuser' host: 'localhost' (Got an error reading communication packets)

Fix

Increase timeout values and use connection pooling

Increase timeout values and use connection pooling
SET GLOBAL wait_timeout = 600;
SET GLOBAL interactive_timeout = 600;
SET GLOBAL net_read_timeout = 60;

Why this works

Longer timeouts prevent premature disconnection. Connection pooling reduces connection churn.

Sources
Official documentation ↗

MySQL 8.0 — 1184 ER_NEW_ABORTING_CONNECTION

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

← All MySQL errors