EC
1549
MySQLERRORNotableEventsHIGH confidence

Event interval must be positive and not too large

Production Risk

Low — DDL error; the event will not be created.

What this means

ER_EVENT_INTERVAL_NOT_POSITIVE_OR_TOO_BIG (1549, SQLSTATE HY000) is raised when the EVERY interval for an event is zero, negative, or exceeds the maximum allowed value.

Why it happens
  1. 1EVERY 0 SECOND or EVERY -1 HOUR specified
  2. 2Interval value exceeds the maximum representable duration
How to reproduce
trigger — this will error
trigger — this will error
CREATE EVENT my_event
ON SCHEDULE EVERY 0 SECOND  -- Zero interval not allowed
DO SELECT 1;

expected output

ERROR 1549 (HY000): INTERVAL is either not positive or too big

Fix

Use a positive non-zero interval

Use a positive non-zero interval
CREATE EVENT my_event
ON SCHEDULE EVERY 1 MINUTE
DO SELECT 1;

Why this works

Event intervals must be positive integers representing a valid time duration.

Sources
Official documentation ↗

MySQL 8.0 — 1549 ER_EVENT_INTERVAL_NOT_POSITIVE_OR_TOO_BIG

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

← All MySQL errors