MySQL Bugs: #29344: MySQL Vista

Bug #29344	MySQL Vista
Submitted:	25 Jun 2007 19:53	Modified:	25 Jun 2007 22:40
Reporter:	James Hume	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S3 (Non-critical)
Version:	MySql 5	OS:	Windows (Vista)
Assigned to:		CPU Architecture:	Any
Tags:	server startup problems, vista

Description:
Hello,

I have searched through your forum to find a solution to my problem and there are threads that seem to be similar, but I have had no joy.

I have, as suggested, deleted the ib* data files. I also have UAC turned OFF and the command line below was run from a terminal with admin priviladges. I'm not sure what the problem is... access permissions?? Following suggestions in the formum allows the server to at least try to start, however, the following message is displayed:

InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
070625 20:44:15 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
070625 20:44:16 InnoDB: Log file .\ib_logfile0 did not exist: new to be created

InnoDB: Setting log file .\ib_logfile0 size to 10 MB
InnoDB: Database physically writes the file full: wait...
070625 20:44:16 InnoDB: Log file .\ib_logfile1 did not exist: new to be created

InnoDB: Setting log file .\ib_logfile1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
070625 20:44:18 InnoDB: Operating system error number 32 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html

InnoDB: File name .\ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.

For some reason one of the files fails to be created and then the "open" call also seems to fail. Have you seem something like this before? My appologies if this has been addressed else where. I have tried to search thoroughly.

Thank you for any help you an offer,
James

How to repeat:
As far as i know, installing on windows vista. Server will not start. But then delete the ib* files, disable uac and use the command line above.

For me MySQL 4.0, 5.0 5.2 and 6.0 have all installed perfectly on Vista! (Home Premiun Danish)

The only issue for me is that the MySQL Administator 'tray applet' won't stop and start service.  That is a privilege issue with the 'extended user acccount control' (or what exactly it is named in English) with this 'feature' disabled also this issue disappears.  

Further I can tell that I also had to turn off this 'feature' to install Apache (2.2.4) .. but not MySQL!

Thank you for the bug report. You have Windows privileges issues or an
my.ini file which is pointing for an older installation which already
has the InnoDB files.

Microsoft Windows [versão 6.0.6000]
Copyright (c) 2006 Microsoft Corporation. Todos os direitos reservados.

c:\dev>cd 5.0

c:\dev\5.0>del data\ib*

c:\dev\5.0>bin\mysqld-nt --standalone --console
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
070625 19:37:15  InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
070625 19:37:15  InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
070625 19:37:15  InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
070625 19:37:16  InnoDB: Started; log sequence number 0 0
070625 19:37:17 [Note] bin\mysqld-nt: ready for connections.
Version: '5.0.46-nt'  socket: ''  port: 3306  Source distribution