MySQL Forums
Forum List  »  Events (Job Scheduler)

Enabling Event scheduler gives "start: Job failed to start" error
Posted by: Brian Jasperson
Date: May 02, 2013 10:08AM

I'm using mysqld Ver 5.5.22-0ubuntu1 for debian-linux-gnu on x86_64 ((Ubuntu)) under Ubuntu 12.04.1 LTS (GNU/Linux 3.2.0-24-generic x86_64). Updates are current.

I had two events that were working fine, and then a power outage knocked the server out. Since then, mysql will not start if event_scheduler=ENABLED in /etc/mysql/my.cnf:

# service mysql restart
mysql stop/waiting
start: Job failed to start

I dropped both events from the events table, and /var/log/mysql.err is completely empty.

Setting event_scheduler=DISABLED allows mysql to start fine.

Any assistance would be greatly appreciated.

Options: ReplyQuote

Written By
Enabling Event scheduler gives "start: Job failed to start" error
May 02, 2013 10:08AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.