MySQL Bugs: #61360: init_file sytem variable prevents startup of mysql

Bug #61360	init_file sytem variable prevents startup of mysql
Submitted:	31 May 2011 8:18	Modified:	2 Jul 2011 3:35
Reporter:	Greg Rossel	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: General	Severity:	S2 (Serious)
Version:	5.1.41-3	OS:	Linux (ubuntu12.10)
Assigned to:		CPU Architecture:	Any
Tags:	init_file hangs mysql

Description:
when init_file is set in my.cnf mysql will not start up. Even if I put a blank init file it will not work.

In init.sql I have tried a variety of queries and a empty file.

I made sure to have single line queries with no ';'.

I have made sure that the init.sql permissions were wide open.

When I start up mysql it hangs. This is an important problem since memory tables cannot be automatically loaded on reboot. Perhaps someone could suggest a workaround. This may relate to some of the system variable problems I have seen from other users.

Thanks

How to repeat:
in my.cnf add the following line in the [mysqld] section: 

init_file = /etc/mysql/init.sql

Make a file init.sql and add a query without ';' or simply leave the file empty.

Start mysql and it will not start.

Just tested agains current GA release mysql 5.1.57  and was not able to reproduce it.

Greg, could you please to check if this bug still persists in your environment if you use mysql 5.1.57.

Version 5.1.43 is little bit outdated (especially if count you are writting from the future -- "ubuntu 12.10").

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".