MySQL Bugs: #6581: Failure to start mysql server on Windows with AWE option enabled

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:	Windows (Windows Server 2003 Enterprise)
Assigned to:	Reggie Burnett	CPU Architecture:	Any

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

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

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,

Changing this to a feature request. Some binary in the distro could be compiled with __WIN2000__

Regards,

Heikki

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

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.

Is there a binary available yet that supports this?

Regards,

Tyler Poland

There is already a installation of mysql for win2k (or later) WITH AWE support included ?

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

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

Fixed in 4.1.15

Noted in 4.1.15 changelog.

Also noted in 5.0.12 changelog.

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