Mysql event didn't execute in a particular day but started to execute afterwards, how to find the root cause?

[oslon]

I wonder what might have happened? How do I troubleshoot it? I am a system administrator by profession so I will check logs of application server, but I think I need some tips about database to debug this issue.

[requinix]

How about some details? How was it created? On what schedule? What do you mean by "afterwards"?

[gizmola]

Off the top of my head 2 possibilities that might explain the issue:

• Event scheduler was not started in server
• Server is UTC, and event was UTC time, leading to confusion as to when the first event should have occurred.

These are just guesses, but looking at the mysql error log, looking at the events table and commands like SHOW CREATE EVENTS and SHOW EVENTS might help you.