dbTalk Databases Forums  

windows aio error

mailing.database.mysql-win32 mailing.database.mysql-win32


Discuss windows aio error in the mailing.database.mysql-win32 forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
daniel kern
 
Posts: n/a

Default windows aio error - 09-09-2004 , 07:29 AM






Please help with the following issue.

I am trying to dump a table. My mysqldump command is:
mysqldump.exe -u xx -P xx --add-drop-table --quick --extended-insert
--result-file=xx "--where=cdrdate > CURDATE() - INTERVAL 1 MONTH" mydb
calldetailrecords

It consistenly crashes the database with the error (as seen in the
error log):

040909 8:16:17 InnoDB: Operating system error number 995 in a file
operation.
InnoDB: See section 13.2 at http://www.innodb.com/ibman.php
InnoDB: about operating system error numbers.
InnoDB: File name d:\mysql-4.1.4\data\ibdata1
InnoDB: File operation call: 'Windows aio'.
InnoDB: Cannot continue operation.

This first occured with mysql 4.0.16 on WinXP. I upgraded to 4.1.4
thinking it would solve the problem (see
http://dev.mysql.com/doc/mysql/en/In...ews-4.1.4.html where it
discusses the previous problems with IO and Innodb). The upgrade
didn't help - the same exact error and crashing occurs.

I tried to dump a different table and still received the same error.

Please email me at daniel (AT) kayote (DOT) com.
Thanks.
dan k.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.