Bug #61894 Installation of MySQL 5.5.14 failed due to InnoDB erro

• Submitted: 18 Jul 2011 13:36
• Modified: 18 Jul 2011 14:55
• Reporter: Igor Crljenica
• Status: Not a Bug
• Category: MySQL Server: Installing
• Severity: S3 (Non-critical)
• Version: 5.5.14
• OS: Windows (Win Server 2003 32-bit)
• CPU Architecture: Any

[18 Jul 2011 13:36] Igor Crljenica

Description:
Tried to upgrade MySQL from 5.1.34 to 5.5.14. After the upgrade failed and the service would not start, I uninstalled all MySQL products and did a fresh install.
Still not able to start the service. Error log shows the following:

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

110717 22:28:16 [Note] D:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: Shutdown complete

Don't have a lot of experience installing and troubleshooting MySQL. Any ideas what might be happening?

Thanks.

How to repeat:
Install 5.1.34. Then uninstall and install version 5.5.14.

[18 Jul 2011 13:41] MySQL Verification Team

Could you please attach the my.ini file. Thanks in advance.

[18 Jul 2011 13:45] Igor Crljenica

Uploaded my.ini

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

[18 Jul 2011 14:09] Valeriy Kravchuk

Do you use 64-bit OS version and 64-bit MySQL 5.5.14 binaries?

[18 Jul 2011 14:43] Igor Crljenica

No, using 32-bit OS with 32-bit binaries.

[18 Jul 2011 14:46] Valeriy Kravchuk

On 32-bit Windows you hardly can use 2G for innodb_buffer_pool_size. Please, make it smaller in my.ini, 1600M for example (assuming that your RAM size is > 2G) and check if this will help.

[18 Jul 2011 14:53] Igor Crljenica

I reduced the size to 1600M and the service started successfully. Thank you for your help.

[2 May 2012 6:19] Dean Watson

I have a Quad-Core Dual-Xenon with 16Gb RAM running xp32, but cannot get a working innodb memory pool larger larger than 800 mb.