MySQL Bugs: #68943: Installation Errors / MySQL56 Service

Bug #68943	Installation Errors / MySQL56 Service
Submitted:	12 Apr 2013 16:39	Modified:	16 Apr 2013 13:36
Reporter:	Jon Gauntt	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S1 (Critical)
Version:	5.6.10.1	OS:	Windows (Server 2008 Enterprise)
Assigned to:		CPU Architecture:	Any
Tags:	error 1067 the process terminated unexpectedly, unable to configure service

Description:
Attempting to install MySQL 5.6.10.1. I am seeing others with similar issues, but I cannot find a workaround that fixes it for my server.

When going through the initial install it doesn't matter if I make any changes, I can get to the Configuration section and it hangs on the Unable to configure service. I have attempted with Development and Full and I have left the default settings and modified the data path to ProgramData/MySQL/. I have tried defaults on users and adding a local user with Admin rights. All of them hang at the same place (as others have).

my-sql-server-5.6-win32:6 - Looking for valid template
my-sql-server-5.6-win32:12 - Found valid template
my-sql-server-5.6-win32:18 - Attempting to process template
my-sql-server-5.6-win32:25 - Processing template
my-sql-server-5.6-win32:31 - Attempting to configure service
my-sql-server-5.6-win32:37 - Configured service
my-sql-server-5.6-win32:43 - Attempting to start service
my-sql-server-5.6-win32:100 - Unable to configure service
my-sql-server-5.6-win32:100 - Product configuration controller finished configuration

Regardless of how I pre-configure, I always get these messages. As this server has had SQL Express on it, I uninstalled, deleted and even modified the registry so there is nothing SQL in it and then reinstalled again with the same error message. I have seen others having this message, so I moved on to the next phase - services.

The MySQL56 service is at a stopped state. If you attempt to start it you get the "Windows could not start the MySQL56 service on Local Computer. Error 1067: The process terminated unexpectedly."

I have attempted Local System Account, NETWORK SERVICES (default), a local Admin account and a Domain Admin account. There is no difference in this error and I cannot get the service to Start. Every one of these options returns the 1067 error.

On the Log On tab there is a Hardware Profile of "Undocked Profile" that is enabled. I have not modified this or disabled it. Not really sure where to go from here as most people do not continue to have an obstacle at this point.

I can go to the mysqld.exe file in C:\Program Files\MySQL\MySQL Server 5.6\bin and it will run a command prompt window. The Path to executable on the Service is: "C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld" --defaults-file="C:\ProgramData\MySQL\my.ini" MySQL56

I did not have to rename a "my.ini" file in ProgramData, there is already one there.

How to repeat:
I have not attempted on other OSs and do not have another Server 2008 Enterprise that I can test on. I can repeat successfully on the same box.

Used the same file on a Windows 7 Enterprise computer and did not have any trouble.  Looks like there may be something with the 2008 Enterprise or a problem with my box specifically.  Really trying not to rebuild the box, but I can if there is no way around it.

Thank you for the bug report. Be sure actually the service is stopped, then open a command prompt (as administrator) go to the mysql bin directory and run the below command:

mysqld --defaults-file="C:\ProgramData\MySQL\my.ini" --standalone --console

and print here the error message. Thanks.

I forgot to ask you: after you change the service to local system account did you rebooted the computer?. Thanks.

I changed the service to Log On as a Local System account, rebooted and am still getting the same error.  Moved on to your next suggestion:

Ran Command Prompt as Administrator:

C:\Program Files\MySQL\MySQL Server 5.6\bin>mysqld --defaults-file="C:\ProgramDa
ta\MySQL\my.ini" --standalone --console
2013-04-12 14:25:12 0 [Warning] TIMESTAMP with implicit DEFAULT value is depreca
ted. Please use --explicit_defaults_for_timestamp server option (see documentati
on for more details).

I do have a Windows Time Service running.  Unfortunately, I was not the one that activated it.  I'll have to double check with everyone and see if this is something still needed and I'll go from there.

Please re-open when you will have te output of the that command. Thanks.

My apologies.  I did not realize you were requesting other information.  This is from the .err log.  Is this what you wanted to see?

2013-04-12 14:25:12 3592 [Note] Plugin 'FEDERATED' is disabled.
2013-04-12 14:25:12 3592 [Warning] option 'innodb-autoextend-increment': unsigned value 67108864 adjusted to 1000
2013-04-12 14:25:12 dbc InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2013-04-12 14:25:12 3592 [Note] InnoDB: The InnoDB memory heap is disabled
2013-04-12 14:25:12 3592 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-04-12 14:25:12 3592 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-04-12 14:25:12 3592 [Note] InnoDB: CPU does not support crc32 instructions
2013-04-12 14:25:12 3592 [Note] InnoDB: Initializing buffer pool, size = 3.0G
InnoDB: VirtualAlloc(233127936 bytes) failed; Windows error 8
2013-04-12 14:25:12 3592 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2013-04-12 14:25:12 3592 [ERROR] Plugin 'InnoDB' init function returned error.
2013-04-12 14:25:12 3592 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2013-04-12 14:25:12 3592 [ERROR] Unknown/unsupported storage engine: INNODB
2013-04-12 14:25:12 3592 [ERROR] Aborting

2013-04-12 14:25:12 3592 [Note] Binlog end
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'partition'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'INNODB_FT_INSERTED'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'INNODB_METRICS'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'INNODB_CMPMEM'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'INNODB_CMP'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'INNODB_LOCKS'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'INNODB_TRX'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'BLACKHOLE'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'ARCHIVE'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'MRG_MYISAM'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'MyISAM'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'MEMORY'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'CSV'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'sha256_password'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'mysql_old_password'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'mysql_native_password'
2013-04-12 14:25:12 3592 [Note] Shutting down plugin 'binlog'
2013-04-12 14:25:12 3592 [Note] mysqld: Shutdown complete

Thank you for the feedback. According the error log your server don't has enough memory free to allocate innodb_buffer_pool_size = 3.0GB. Please check with values lower than that (change my.ini value). Thanks.

Machine 32 bits?.

That would be it.  One of the developers has a program tying up 31.9 GB of the 32 GB available to the server.  Thanks for your help.

Thank you for the feedback.