MySQL Bugs: #22217: Internal scheduler error 6

Bug #22217	Internal scheduler error 6
Submitted:	10 Sep 2006 0:13	Modified:	27 Sep 2006 15:45
Reporter:	SEO 10	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server: Stored Routines	Severity:	S1 (Critical)
Version:	5.1.12-BK, 5.1.11	OS:	Linux (Linux)
Assigned to:	Andrey Hristov	CPU Architecture:	Any
Tags:	crypted error, Internal scheduler error 6, mysql eror, php

Description:
I use PHP with a SUPER mysql user with global privileges to set schedules in MySQL.

Creating the Schedules works fine, the schedule is created. But when performing the create command with the IF NOT EXISTS parameter to ensure the SCHEDULE has been created, the folowing crypted error is returned: "Internal scheduler error 6" nothing more. 

I can't find any information about this besides an old bug report from February this year. (google: "Internal scheduler error 6", first result)

This is the command I run:

CREATE EVENT IF NOT EXISTS xxx_clearips ON SCHEDULE EVERY 1 DAY DO DELETE FROM of_xxx.xxx_ip_log WHERE logtime < UNIX_TIMESTAMP()-86400

So again, creation works, but running this query again will fail.

How to repeat:
Run 

CREATE EVENT IF NOT EXISTS xxx_clearips ON SCHEDULE EVERY 1 DAY DO DELETE FROM of_xxx.xxx_ip_log WHERE logtime < UNIX_TIMESTAMP()-86400 

twice.

Suggested fix:
Unknown

Thank you for a bug report. Verified just as described with latest 5.1.12-BK on Linux:

openxs@suse:~/dbs/5.1> bin/mysql -uroot test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 5.1.12-beta-debug

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select * from test;
ERROR 1146 (42S02): Table 'test.test' doesn't exist
mysql> create table test (c1 int);
Query OK, 0 rows affected (0.02 sec)

mysql> CREATE EVENT IF NOT EXISTS xxx_clearips ON SCHEDULE EVERY 1 DAY DO DELETE FROM test;
Query OK, 1 row affected (0.02 sec)

mysql> CREATE EVENT IF NOT EXISTS xxx_clearips ON SCHEDULE EVERY 1 DAY DO DELETE FROM test;
ERROR 1558 (HY000): Internal scheduler error 6

Please try newer 5.1.12 from bk :
mysql> CREATE EVENT IF NOT EXISTS xxx_clearips ON SCHEDULE EVERY 1 DAY DO DELETE FROM
    -> of_xxx.xxx_ip_log WHERE logtime < UNIX_TIMESTAMP()-86400
    ->
    -> ;
Query OK, 0 rows affected (0.08 sec)

mysql> CREATE EVENT IF NOT EXISTS xxx_clearips ON SCHEDULE EVERY 1 DAY DO DELETE FROM of_xxx.xxx_ip_log WHERE logtime < UNIX_TIMESTAMP()-86400;
Query OK, 0 rows affected, 1 warning (0.07 sec)

mysql> show warnings;
+-------+------+-------------------------------------+
| Level | Code | Message                             |
+-------+------+-------------------------------------+
| Note  | 1524 | Event 'xxx_clearips' already exists |
+-------+------+-------------------------------------+
1 row in set (0.00 sec)