EC
1555
MySQLERRORCommonEventsHIGH confidence

Cannot load from mysql.event — table is probably corrupt

Production Risk

Critical — scheduled events will not run until this is resolved.

What this means

ER_CANNOT_LOAD_FROM_TABLE_V2 (1555, SQLSTATE HY000) is raised when MySQL cannot read event definitions from mysql.event due to corruption or schema mismatch.

Why it happens
  1. 1mysql.event is corrupt or has an unexpected format
  2. 2MySQL server started without running mysql_upgrade after a version upgrade
How to reproduce
trigger — this will error
trigger — this will error
-- Occurs at event scheduler startup or when SHOW EVENTS is run:
SHOW EVENTS;

expected output

ERROR 1555 (HY000): Cannot load from mysql.event. The table is probably corrupted

Fix

Run mysql_upgrade to fix the mysql schema

Run mysql_upgrade to fix the mysql schema
-- From command line:
mysql_upgrade -u root -p

-- After upgrade, check:
SHOW EVENTS;

Why this works

mysql_upgrade repairs and upgrades all system tables including mysql.event.

Sources
Official documentation ↗

MySQL 8.0 — 1555 ER_CANNOT_LOAD_FROM_TABLE_V2

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

← All MySQL errors