MySQL Bugs: #60277: MySql services stuck at starting

Bug #60277	MySql services stuck at starting
Submitted:	28 Feb 2011 9:35	Modified:	4 Mar 2011 6:54
Reporter:	Alex Woo	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.1	OS:	Windows (server 2008R2)
Assigned to:		CPU Architecture:	Any
Tags:	services

Description:
I got a serious issue. Mysql in server 2008 R2 is currently stuck at staring at services. I tried to stop the process and restart the service. It doesn't solve the problem. It happen when I did a windows update for this. 

How to repeat:
Do I need to reinstall mysql in order to fix this???

What exact version of MySQL server, 5.1.x, do you use? Please, send the entire error log of MySQL server (this is usually a <hostname>.err file in the datadir).

Maybe you have just to unblock mysqld.exe at the firewall level...

@Alex: You probably got Servicepack 1 installed (it was released for 2008-R2 and Win7 around a week ago). I have no such problem with SP1 for Win7.

Peter
(not a MySQL person).

It manages to start up again after another reboot I then ended the services then start it again. Does it have to do with the firewall? This issue happen after I started up the firewall in the server, but is there any method of adding an exception for mySQL in server2008R2?

I checked the error and found out I got this error.

"110228 16:36:33 [Note] Plugin 'FEDERATED' is disabled.
110228 16:36:34  InnoDB: Started; log sequence number 0 2434689
110228 16:40:53 [Note] Plugin 'FEDERATED' is disabled.
110228 16:40:55  InnoDB: Started; log sequence number 0 2434689
110228 17:06:57 [Note] Plugin 'FEDERATED' is disabled.
110228 17:06:58  InnoDB: Started; log sequence number 0 2434689
110228 17:36:12 [Note] Event Scheduler: Loaded 0 events
110228 17:36:12 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections.
Version: '5.1.49-community'  socket: ''  port: 3306  MySQL Community Server (GPL)
110228 17:36:25 [Note] Plugin 'FEDERATED' is disabled.
110228 17:36:26  InnoDB: Started; log sequence number 0 2434689
110228 17:36:33 [Note] Event Scheduler: Loaded 0 events
110228 17:36:33 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections.
Version: '5.1.49-community'  socket: ''  port: 3306  MySQL Community Server (GPL)"

Is this a big issue for this kind of OS?

Sorry there is more, ignored the one ontop.

"
110228 16:30:10 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Normal shutdown

110228 16:30:10 [Note] Event Scheduler: Purging the queue. 0 events
110228 16:30:10  InnoDB: Starting shutdown...
110228 16:30:15  InnoDB: Shutdown completed; log sequence number 0 2434689
110228 16:30:15 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete

110228 16:36:33 [Note] Plugin 'FEDERATED' is disabled.
110228 16:36:34  InnoDB: Started; log sequence number 0 2434689
110228 16:40:53 [Note] Plugin 'FEDERATED' is disabled.
110228 16:40:55  InnoDB: Started; log sequence number 0 2434689
110228 17:06:57 [Note] Plugin 'FEDERATED' is disabled.
110228 17:06:58  InnoDB: Started; log sequence number 0 2434689
110228 17:36:12 [Note] Event Scheduler: Loaded 0 events
110228 17:36:12 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections.
Version: '5.1.49-community'  socket: ''  port: 3306  MySQL Community Server (GPL)
110228 17:36:25 [Note] Plugin 'FEDERATED' is disabled.
110228 17:36:26  InnoDB: Started; log sequence number 0 2434689
110228 17:36:33 [Note] Event Scheduler: Loaded 0 events
110228 17:36:33 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections.
Version: '5.1.49-community'  socket: ''  port: 3306  MySQL Community Server (GPL)
"

Will giving MySql access to the firewall fix this? I don't want to depend on luck to make MySql work.

Yes, you should allow MySQL server (mysqld.exe) to start and allow access to port 3306.

For port 3306 is it better to either use TCP or UDP or both of them?

MySQL server uses TCP.

Thanks the bug is gone. Can't believe a firewall exception actually fixed this.

So, this problem was not a result of any bug in MySQL code.

Guys i want one help with MySQL i make all install for MySQL and stuck in Start Service..No with Error Just stuck :/..I want help ty.!