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
- 1Extremely large SQL body in a CREATE EVENT or ALTER EVENT statement.
- 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