EC
1923
MariaDBERRORNotableDDLHIGH confidence

Event data too long

Production Risk

Low — event is rejected; refactor the body.

What this means

The body of an event definition exceeds the maximum size that can be stored in the mysql.event table.

Why it happens
  1. 1Extremely large SQL body in a CREATE EVENT or ALTER EVENT statement.
  2. 2Multi-statement event body that exceeds internal column size limits.
How to reproduce
trigger — this will error
trigger — this will error
-- CREATE EVENT with a very large body exceeding storage limits

expected output

ERROR 1923 (HY000): Event data too long.

Fix

Move logic to a stored procedure and call it from the event

Move logic to a stored procedure and call it from the event
CREATE PROCEDURE my_proc() BEGIN /* large logic here */ END;
CREATE EVENT my_event ON SCHEDULE EVERY 1 HOUR DO CALL my_proc();

Why this works

Stored procedures offload the logic, keeping the event body minimal.

What not to do

✕

Sources
Official documentation ↗

MySQL 8.0 — 1923 ER_EVENT_DATA_TOO_LONG2

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

← All MariaDB errors