Jump to content

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

oslon

By oslon
in MySQL Help

 Share
Go to solution Solved by gizmola,

Recommended Posts

oslon Member

oslon

Posted
Posted

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.

Link to comment
Share on other sites
  • Solution
gizmola Prolific Member

gizmola

Posted
  • Solution
Posted

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.