Bug #6581 Failure to start mysql server on Windows with AWE option enabled
Submitted: 11 Nov 2004 16:55 Modified: 17 Aug 2005 19:28
Reporter: Ross Swithenbank Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S4 (Feature request)
Version:4.1.7 OS:Microsoft Windows (Windows Server 2003 Enterprise)
Assigned to: Reggie Burnett
Triage: D5 (Feature request)

[11 Nov 2004 16:55] Ross Swithenbank
Description:
I have configured Windows with 6GB of memory and want to use the AWE option in mysql. I have set the startup parameter:

innodb_buffer_pool_awe_mem_mb=1000

When I try to start the server, it errors with the following message

InnoDB: Error: You have specified innodb_buffer_pool_awe_mem_mb
InnoDB: in my.cnf, but AWE can only be used in Windows 2000 and later.
041111 16:30:58 [ERROR] Can't init databases
041111 16:30:58 [ERROR] Aborting

We are definitely running Windows 2000 or later !
I am using the binary distribution 4.1.7 downloaded from mysql.com

How to repeat:
Follow the procedure in Description above
[11 Nov 2004 20:37] Heikki Tuuri
Hi!

The problem is that the binary was built without __WIN2000__ being defined.

I am assigning this bug to Miguel. He should check is any of the Windows binaries are built with that flag. If not, maybe we could define the flag for -max?

Regards,

Heikki

#if !defined(__WIN2000__) && !defined(UNIV_SIMULATE_AWE)
        if (srv_use_awe) {

                fprintf(stderr,
"InnoDB: Error: You have specified innodb_buffer_pool_awe_mem_mb\n"
"InnoDB: in my.cnf, but AWE can only be used in Windows 2000 and later.\n");

                return(DB_ERROR);
        }
#endif
[11 Nov 2004 22:38] Miguel Solorzano
Currently the packed Windows servers binaries are compiled without
the option of AWE support and with the compiler VC++ 6.0.

For you get AWE support you need to use the source distribution
and to compile yourself with Visual Studio .NET VC++ compiler. 

Thanks,
[14 Nov 2004 17:18] Heikki Tuuri
Changing this to a feature request. Some binary in the distro could be compiled with __WIN2000__

Regards,

Heikki
[17 Nov 2004 11:24] Ross Swithenbank
Please can you give me some idea when a build may be available for download which has this capability built in. I really don't want to build mysql from the source myself. 

Thanks,

Ross Swithenbank
[17 Nov 2004 13:10] Lenz Grimmer
We need to obtain and install the Visual Studio .NET VC++ compiler on one of our Windows build machines and perform some tests. I will add this to our engineering TODO list, but can not give you an estimate how long it will take until binary releases will be available for it - sorry.
[11 Feb 2005 14:30] Tyler Poland
Is there a binary available yet that supports this?

Regards,

Tyler Poland
[30 Mar 2005 1:42] Rodrigo Costa
There is already a installation of mysql for win2k (or later) WITH AWE support included ?
[12 Aug 2005 12:35] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/28222
[12 Aug 2005 13:15] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/28223
[17 Aug 2005 19:15] Reggie Burnett
Fixed in 4.1.15
[17 Aug 2005 19:27] Paul Dubois
Noted in 4.1.15 changelog.
[17 Aug 2005 19:28] Paul Dubois
Also noted in 5.0.12 changelog.
[30 Mar 2006 15:25] Vinnie Tran
Hello.

I am having problem with this also.  As MySQL website indicated that this problem has been fixed in 4.1.15 distribution.  I downloaded the 4.1.18 distribution and configured innodb_buffer_pool_awe_mem_mb=2000 on a 4G memory Windows 2003 Server.

I am getting the same error message:

InnoDB: Error: You have specified innodb_buffer_pool_awe_mem_mb
InnoDB: in my.cnf, but AWE can only be used in Windows 2000 and later.
041111 16:30:58 [ERROR] Can't init databases
041111 16:30:58 [ERROR] Aborting

Thanks for your help.

Vinnie