windows server 2003
on a dedicated database server with an external SCSI RAID array with a 1 TB of disk space (over 400 GIG free)
1 gig of RAM
basic settings key buffer 512 MB sort Buffer 32 Mb
innof db Buffer Pool Size 512 MB
my innodb datafile is about 200 gig is size and I have 6 innodb databses. 3 are very large 40+ gigs with about 800 million records.
The other 3 are very small few MB is size. Every two weeks I rebuild one of the large db and use the other 2 as backups.
This configuration as worked fine for the last 2 months.
I was in the process of rebuilding one of the large databases when I got the following error.
050214 16:46:56 InnoDB: Operating system error number 995 in a file operation.
InnoDB: See http://www.innodb.com/ibman.php for installation help.
InnoDB: See section 13.2 at http://www.innodb.com/ibman.php
InnoDB: about operating system error numbers.
InnoDB: File name .\ibdata1
InnoDB: File operation call: 'Windows aio'.
InnoDB: Cannot continue operation.
after restarting mysql, innodb rolled back my tables in the db that crashed and the rest of my data seems fine.
I have googled around and there seems to be some info that this errors is some kind windows driver. Is there any more info regarding this error?
Any help would be useful.
Thank you
-Ben
------------------------------------------------------------------------ --------------------------------------------------
Ben Kutsch Developer
Suite 304, 121 South 13th ST Dept. of Computer Science and Eng.
phone: (402) 472-2340 University of Nebraska-Lincoln
fax: (402) 472-3135 Lincoln NE 68588-0115
email: [EMAIL PROTECTED] http://nadss.unl.edu
------------------------------------------------------------------------ --------------------------------------------------
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
