MySQL Bugs: #23805: Server ignores setting from my.ini and crashes after changing event

Bug #23805	Server ignores setting from my.ini and crashes after changing event_scheduler
Submitted:	31 Oct 2006 15:31	Modified:	31 Oct 2006 16:19
Reporter:	Markus Popp	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Stored Routines	Severity:	S2 (Serious)
Version:	5.1.12-beta-community-nt-log	OS:	Windows (Windows XP)
Assigned to:		CPU Architecture:	Any

Description:
It's a fresh installation of MySQL 5.1.12 on Windows XP using the following settings in my.ini:

[mysqld]
port		= 3307
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
event-scheduler = 1
log
log-slow-queries
default-character-set=utf8
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

After server startup, event_scheduler is still at OFF (see in How to repeat section). When I try to set it to ON, the server crashes.

This bug occurs in Windows, not in Linux.

How to repeat:
E:\>mysql -u root -P 3307
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.1.12-beta-community-nt-log

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

mysql> select @@global.event_scheduler;
+--------------------------+
| @@global.event_scheduler |
+--------------------------+
| OFF                      |
+--------------------------+
1 row in set (0.00 sec)

mysql> set @@global.event_scheduler = 1;
Query OK, 0 rows affected (0.00 sec)

mysql> select @@global.event_scheduler;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
ERROR:
Can't connect to the server

mysql> select @@global.event_scheduler;
No connection. Trying to reconnect...
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
ERROR:
Can't connect to the server

Screen that shows up after 'set @@global.event_scheduler = 1;'

Attachment: server_crash.jpg (image/jpeg, text), 35.46 KiB.

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html

c:\mysql\bin>mysql -u root -P 3307
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.13-beta-nt-log Source distribution

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

mysql> select @@global.event_scheduler;
+--------------------------+
| @@global.event_scheduler |
+--------------------------+
| ON                       |
+--------------------------+
1 row in set (0.00 sec)

mysql> set @@global.event_scheduler = 1;
Query OK, 0 rows affected (0.00 sec)

mysql> select @@global.event_scheduler;
+--------------------------+
| @@global.event_scheduler |
+--------------------------+
| ON                       |
+--------------------------+
1 row in set (0.00 sec)

mysql> select version();
+--------------------+
| version()          |
+--------------------+
| 5.1.13-beta-nt-log |
+--------------------+
1 row in set (0.01 sec)

mysql> select @@sql_mode;
+----------------------------------------------------------------+
| @@sql_mode                                                     |
+----------------------------------------------------------------+
| STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+----------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> set @@global.event_scheduler = 0;
Query OK, 0 rows affected (0.02 sec)

mysql> select @@global.event_scheduler;
+--------------------------+
| @@global.event_scheduler |
+--------------------------+
| OFF                      |
+--------------------------+
1 row in set (0.00 sec)

mysql> set @@global.event_scheduler = 1;
Query OK, 0 rows affected (0.00 sec)

mysql> select @@global.event_scheduler;
+--------------------------+
| @@global.event_scheduler |
+--------------------------+
| ON                       |
+--------------------------+
1 row in set (0.00 sec)

mysql>

I am getting the same problem , when  i set  event-scheduler = 1 in my my.ini file and after I restart I can not connect.
I have myself 5.1.11
Do you know what I am doing wrong?
I would really appreciate if you can get back to me asap

Thanks
Ruth