MySQL Bugs: #64735: Service not starting during install

Bug #64735	Service not starting during install
Submitted:	22 Mar 2012 12:18	Modified:	23 Mar 2012 9:33
Reporter:	David Wheelen	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S3 (Non-critical)
Version:	5.5.21.0	OS:	Windows (2003 SP2 32-bit)
Assigned to:		CPU Architecture:	Any
Tags:	1067, error, install, service

Description:
I'm attempting to get mysql 5.5 running on my 2003 SP1 server (fresh install) and I'm running into the issue of the service not wanting to start. After trying to manually start the service I get an error 1067.

I have poured over the bugs forum and found many other posts with similar issues but none of the fixes seem to work. I'm at a complete loss at this point.

Here is my error log:

120322  7:47:03 [Note] Plugin 'FEDERATED' is disabled.
120322  7:47:03 InnoDB: The InnoDB memory heap is disabled
120322  7:47:03 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120322  7:47:03 InnoDB: Compressed tables use zlib 1.2.3
120322  7:47:04 InnoDB: Initializing buffer pool, size = 2.0G
InnoDB: VirtualAlloc(2175795200 bytes) failed; Windows error 87
120322  7:47:04 InnoDB: Completed initialization of buffer pool
120322  7:47:04 InnoDB: Fatal error: cannot allocate memory for the buffer pool
120322  7:47:04 [ERROR] Plugin 'InnoDB' init function returned error.
120322  7:47:04 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
120322  7:47:04 [ERROR] Unknown/unsupported storage engine: INNODB
120322  7:47:04 [ERROR] Aborting

120322  7:47:04 [Note] D:\MySQL\MySQL Server 5.5\bin\mysqld: Shutdown complete

120322  7:47:33 [Note] Plugin 'FEDERATED' is disabled.
120322  7:47:34 InnoDB: The InnoDB memory heap is disabled
120322  7:47:34 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120322  7:47:34 InnoDB: Compressed tables use zlib 1.2.3
120322  7:47:34 InnoDB: Initializing buffer pool, size = 2.0G
InnoDB: VirtualAlloc(2175795200 bytes) failed; Windows error 87
120322  7:47:34 InnoDB: Completed initialization of buffer pool
120322  7:47:34 InnoDB: Fatal error: cannot allocate memory for the buffer pool
120322  7:47:34 [ERROR] Plugin 'InnoDB' init function returned error.
120322  7:47:34 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
120322  7:47:34 [ERROR] Unknown/unsupported storage engine: INNODB
120322  7:47:34 [ERROR] Aborting

120322  7:47:35 [Note] D:\MySQL\MySQL Server 5.5\bin\mysqld: Shutdown complete

120322  7:53:27 [Note] Plugin 'FEDERATED' is disabled.
120322  7:53:27 InnoDB: The InnoDB memory heap is disabled
120322  7:53:27 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120322  7:53:27 InnoDB: Compressed tables use zlib 1.2.3
120322  7:53:27 InnoDB: Initializing buffer pool, size = 2.0G
InnoDB: VirtualAlloc(2175795200 bytes) failed; Windows error 87
120322  7:53:27 InnoDB: Completed initialization of buffer pool
120322  7:53:27 InnoDB: Fatal error: cannot allocate memory for the buffer pool
120322  7:53:27 [ERROR] Plugin 'InnoDB' init function returned error.
120322  7:53:27 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
120322  7:53:27 [ERROR] Unknown/unsupported storage engine: INNODB
120322  7:53:27 [ERROR] Aborting

120322  7:53:27 [Note] D:\MySQL\MySQL Server 5.5\bin\mysqld: Shutdown complete

120322  7:55:21 [Note] Plugin 'FEDERATED' is disabled.
120322  7:55:21 InnoDB: The InnoDB memory heap is disabled
120322  7:55:21 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120322  7:55:21 InnoDB: Compressed tables use zlib 1.2.3
120322  7:55:22 InnoDB: Initializing buffer pool, size = 2.0G
InnoDB: VirtualAlloc(2175795200 bytes) failed; Windows error 87
120322  7:55:22 InnoDB: Completed initialization of buffer pool
120322  7:55:22 InnoDB: Fatal error: cannot allocate memory for the buffer pool
120322  7:55:22 [ERROR] Plugin 'InnoDB' init function returned error.
120322  7:55:22 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
120322  7:55:22 [ERROR] Unknown/unsupported storage engine: INNODB
120322  7:55:22 [ERROR] Aborting

120322  7:55:22 [Note] D:\MySQL\MySQL Server 5.5\bin\mysqld: Shutdown complete

120322  7:56:44 [Note] Plugin 'FEDERATED' is disabled.
120322  7:56:44 InnoDB: The InnoDB memory heap is disabled
120322  7:56:44 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120322  7:56:44 InnoDB: Compressed tables use zlib 1.2.3
120322  7:56:44 InnoDB: Initializing buffer pool, size = 2.0G
InnoDB: VirtualAlloc(2175795200 bytes) failed; Windows error 87
120322  7:56:44 InnoDB: Completed initialization of buffer pool
120322  7:56:44 InnoDB: Fatal error: cannot allocate memory for the buffer pool
120322  7:56:44 [ERROR] Plugin 'InnoDB' init function returned error.
120322  7:56:44 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
120322  7:56:44 [ERROR] Unknown/unsupported storage engine: INNODB
120322  7:56:44 [ERROR] Aborting

120322  7:56:44 [Note] D:\MySQL\MySQL Server 5.5\bin\mysqld: Shutdown complete

120322  8:08:07 [Note] Plugin 'FEDERATED' is disabled.
120322  8:08:07 InnoDB: The InnoDB memory heap is disabled
120322  8:08:07 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120322  8:08:07 InnoDB: Compressed tables use zlib 1.2.3
120322  8:08:07 InnoDB: Initializing buffer pool, size = 2.0G
InnoDB: VirtualAlloc(2175795200 bytes) failed; Windows error 87
120322  8:08:07 InnoDB: Completed initialization of buffer pool
120322  8:08:07 InnoDB: Fatal error: cannot allocate memory for the buffer pool
120322  8:08:07 [ERROR] Plugin 'InnoDB' init function returned error.
120322  8:08:07 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
120322  8:08:07 [ERROR] Unknown/unsupported storage engine: INNODB
120322  8:08:07 [ERROR] Aborting

120322  8:08:07 [Note] D:\MySQL\MySQL Server 5.5\bin\mysqld: Shutdown complete

To me it looks like the issue starts and ends here:

InnoDB: VirtualAlloc(2175795200 bytes) failed; Windows error 87
120322  8:08:07 InnoDB: Completed initialization of buffer pool
120322  8:08:07 InnoDB: Fatal error: cannot allocate memory for the buffer pool
120322  8:08:07 [ERROR] Plugin 'InnoDB' init function returned error.
120322  8:08:07 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
120322  8:08:07 [ERROR] Unknown/unsupported storage engine: INNODB
120322  8:08:07 [ERROR] Aborting

I haven't the slightest clue how InnoDB works so ANY help would be appreciated!

How to repeat:
1. Download mysql-installer-5.5.21.0.msi
2. start mysql-installer-5.5.21.0.msi
3. Server only install
4. error occurs during config portion

Error Log

Attachment: dc1.err (application/octet-stream, text), 5.08 KiB.

Windows Server 2003 SP2 not SP1. My mistake.

Could you please provide the my.ini file created by installer. Thanks.

my.ini

Attachment: my.ini (application/octet-stream, text), 8.98 KiB.

Is this a 32-bit Windows or 32-bit MySQL server version?

yes, 32bit Windowa, 32bit Mysql.

Try to decrease innodb_buffer_pool_size in my.ini file then. Set it to 1G and check if this will allow service to start.

That seems to have don the trick. I ended up setting the size to 500M since I will  not have a need for a huge amount.

Thank you,

Cheers!

So, just wrong configuration. Not a bug.

This is at the least poor or incorrect exception handling.  If there is a catastrophic halt due to a default configuration, I would at least expect something that says "unable to allocate memory for ..." in the logs.  Declaring this "not a bug" is a missed opportunity.

Oh, duh... Ignore.  Just read the log snippet.  Sigh.

my.ini for MySQL 5.6.2

Attachment: my.ini (application/octet-stream, text), 8.91 KiB.