ERROR 33 - AIO WRITE ERROR

"Smith, Christopher L." <[email protected]> Sat, 20 Dec 2003 13:41:30 -0600
Newsgroups	gmane.comp.db.mysql.bugs,gmane.comp.db.mysql.windows
Message-ID	<3080E1264732244B844860A7BD823A690253EE02@NAHOU-MSMBX07V.corp.enron.com>
All - 

This error hit me last night and I'm not quite sure what to make of it. I've researched the documentation and only found one reference to Error 33 within the INNODB & MYSQL documentation, but this wasn't helpful. I don't know if it is a bug or not, but I cannot make a test script because I cannot restart mysql under any state.  Would much appreciate any ideas.

Here is what I recovered from the 'err' file - the trace is attached below:

MySql: ready for connections.
Version: '4.0.16-nt'  socket: ''  port: 3306
031220  9:00:47  InnoDB: Operating system error number 33 in a file operation.
InnoDB: See http://www.innodb.com/ibman.html for installation help.
InnoDB: See section 13.2 at http://www.innodb.com/ibman.html
InnoDB: about operating system error numbers.
InnoDB: File name .\ibdata1
InnoDB: File operation call: 'aio write'.
InnoDB: Cannot continue operation.
031220  9:08:38  InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 2 131564226
InnoDB: Doing recovery: scanned up to log sequence number 2 131795858
031220  9:08:38  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 536631094, file name .\WNAHOU-14931-bin.007
031220  9:08:39  InnoDB: Flushing modified pages from the buffer pool...
031220  9:08:39  InnoDB: Operating system error number 33 in a file operation.
InnoDB: See http://www.innodb.com/ibman.html for installation help.
InnoDB: See section 13.2 at http://www.innodb.com/ibman.html
InnoDB: about operating system error numbers.
InnoDB: File name .\ibdata1
InnoDB: File operation call: 'aio write'.
InnoDB: Cannot continue operation.
031220 11:34:57  InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 2 131567174
InnoDB: Doing recovery: scanned up to log sequence number 2 131795858
031220 11:34:58  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 536631094, file name .\WNAHOU-14931-bin.007
031220 11:34:59  InnoDB: Flushing modified pages from the buffer pool...
031220 11:35:00  InnoDB: Operating system error number 33 in a file operation.
InnoDB: See http://www.innodb.com/ibman.html for installation help.
InnoDB: See section 13.2 at http://www.innodb.com/ibman.html
InnoDB: about operating system error numbers.
InnoDB: File name .\ibdata1
InnoDB: File operation call: 'aio write'.
InnoDB: Cannot continue operation.


-----
TRACE
-----
T@1    : >my_load_path
T@1    : | enter: path: C:\mysql\  prefix: 
T@1    : | exit: to: C:\mysql\
T@1    : <my_load_path
T@1    : >my_load_path
T@1    : | enter: path: C:\mysql\data\  prefix: C:\mysql\
T@1    : | exit: to: C:\mysql\data\
T@1    : <my_load_path
T@1    : >my_load_path
T@1    : | enter: path: WNAHOU-14931.pid  prefix: C:\mysql\data\
T@1    : | exit: to: C:\mysql\data\WNAHOU-14931.pid
T@1    : <my_load_path
T@1    : >my_load_path
T@1    : | enter: path: english\  prefix: C:\mysql\share\
T@1    : | exit: to: C:\mysql\share\english\
T@1    : <my_load_path
T@1    : >_mymalloc
T@1    : | enter: Size: 35
T@1    : | exit: ptr: c96468
T@1    : <_mymalloc
T@1    : >_mymalloc
T@1    : | enter: Size: 35
T@1    : | exit: ptr: c964e0
T@1    : <_mymalloc
T@1    : info: mysqld  Ver 4.0.16-max-debug for Win95/Win98 on i32

T@1    : >set_default_charset_by_name
T@1    : | enter: character set: latin1
T@1    : | >init_dynamic_array
T@1    : | | >_mymalloc
T@1    : | | | enter: Size: 64
T@1    : | | | exit: ptr: c96600
T@1    : | | <_mymalloc
T@1    : | <init_dynamic_array
T@1    : | >get_charsets_dir
T@1    : | | info: charsets dir='C:\mysql\share\charsets\'
T@1    : | <get_charsets_dir
T@1    : | >my_fopen
T@1    : | | my: Name: 'C:\mysql\share\charsets\Index'  Flags: 0  MyFlags: 0
T@1    : | | >_mymalloc
T@1    : | | | enter: Size: 30
T@1    : | | | exit: ptr: c96688
T@1    : | | <_mymalloc
T@1    : | | exit: stream: 775b18
T@1    : | <my_fopen
T@1    : | >init_dynamic_array
T@1    : | | >_mymalloc
T@1    : | | | enter: Size: 128
T@1    : | | | exit: ptr: c966f0
T@1    : | | <_mymalloc
T@1    : | <init_dynamic_array
T@1    : | test: my_once_malloc 4060 byte malloced
T@1    : | >my_fclose
T@1    : | | my: stream: 775b18  MyFlags: 0
T@1    : | | >_myfree
T@1    : | | | enter: ptr: c96688
T@1    : | | <_myfree
T@1    : | <my_fclose
T@1    : | >_myfree
T@1    : | | enter: ptr: c966f0
T@1    : | <_myfree
T@1    : <set_default_charset_by_name
T@1    : >init_dynamic_string
T@1    : | >_mymalloc
T@1    : | | enter: Size: 256
T@1    : | | exit: ptr: c94f68
T@1    : | <_mymalloc
T@1    : <init_dynamic_string
T@1    : >get_charsets_dir
T@1    : | info: charsets dir='C:\mysql\share\charsets\'
T@1    : <get_charsets_dir
T@1    : >my_stat
T@1    : | my: path: 'C:\mysql\share\charsets\dec8.conf', stat_area: 12fae0, MyFlags: 0
T@1    : <my_stat
T@1    : >get_charsets_dir
T@1    : | info: charsets dir='C:\mysql\share\charsets\'
T@1    : <get_charsets_dir
T@1    : >my_stat
T@1    : | my: path: 'C:\mysql\share\charsets\dos.conf', stat_area: 12fae0, MyFlags: 0
T@1    : <my_stat
T@1    : >get_charsets_dir
T@1    : | info: charsets dir='C:\mysql\share\charsets\'
T@1    : <get_charsets_dir
T@1    : >my_stat
T@1    : | my: path: 'C:\mysql\share\charsets\german1.conf', stat_area: 12fae0, MyFlags: 0
T@1    : <my_stat
T@1    : >get_charsets_dir
T@1    : | info: charsets dir='C:\mysql\share\charsets\'
T@1    : <get_charsets_dir
T@1    : >my_stat
T@1    : | my: path: 'C:\mysql\share\charsets\hp8.conf', stat_area: 12fae0, MyFlags: 0
T@1    : <my_stat
T@1    : >get_charsets_dir
T@1    : | info: charsets dir='C:\mysql\share\charsets\'
T@1    : <get_charsets_dir
T@1    : >my_stat
T@1    : | my: path: 'C:\mysql\share\charsets\koi8_ru.conf', stat_area: 12fae0, MyFlags: 0
T@1    : <my_stat
T@1    : >get_charsets_dir
T@1    : | info: charsets dir='C:\mysql\share\charsets\'
T@1    : <get_charsets_dir
T@1    : >my_stat
T@1    : | my: path: 'C:\mysql\share\charsets\latin2.conf', stat_area: 12fae0, MyFlags: 0
T@1    : <my_stat
T@1    : >get_charsets_dir
T@1    : | info: charsets dir='C:\mysql\share\charsets\'
T@1    : <get_charsets_dir
T@1    : >my_stat
T@1    : | my: path: 'C:\mysql\share\charsets\swe7.conf', stat_area: 12fae0, MyFlags: 0
T@1    : <my_stat
T@1    : >get_charsets_dir
T@1    : | info: charsets dir='C:\mysql\share\charsets\'
T@1    : <get_charsets_dir
T@1    : >my_stat
T@1    : | my: path: 'C:\mysql\share\charsets\usa7.conf', stat_area: 12fae0, MyFlags: 0
T@1    : <my_stat
T@1    : >get_charsets_dir
T@1    : | info: charsets dir='C:\mysql\share\charsets\'
T@1    : <get_charsets_dir
T@1    : >my_stat
T@1    : | my: path: 'C:\mysql\share\charsets\cp1251.conf', stat_area: 12fae0, MyFlags: 0
T@1    : <my_stat
T@1    : >get_charsets_dir
T@1    : | info: charsets dir='C:\mysql\share\charsets\'
T@1    : <get_charsets_dir
T@1    : >my_stat
T@1    : | my: path: 'C:\mysql\share\charsets\danish.conf', stat_area: 12fae0, MyFlags: 0
T@1    : <my_stat
T@1    : >get_charsets_dir
T@1    : | info: charsets dir='C:\mysql\share\charsets\'
T@1    : <get_charsets_dir
T@1    : >my_stat
T@1    : | my: path: 'C:\mysql\share\charsets\hebrew.conf', stat_area: 12fae0, MyFlags: 0
T@1    : <my_stat
T@1    : >get_charsets_dir
T@1    : | info: charsets dir='C:\mysql\share\charsets\'
T@1    : <get_charsets_dir
T@1    : >my_stat
T@1    : | my: path: 'C:\mysql\share\charsets\win1251.conf', stat_area: 12fae0, MyFlags: 0
T@1    : <my_stat
T@1    : >get_charsets_dir
T@1    : | info: charsets dir='C:\mysql\share\charsets\'
T@1    : <get_charsets_dir
T@1    : >my_stat
T@1    : | my: path: 'C:\mysql\share\charsets\estonia.conf', stat_area: 12fae0, MyFlags: 0
T@1    : <my_stat
T@1    : >get_charsets_dir
T@1    : | info: charsets dir='C:\mysql\share\charsets\'
T@1    : <get_charsets_dir
T@1    : >my_stat
T@1    : | my: path: 'C:\mysql\share\charsets\hungarian.conf', stat_area: 12fae0, MyFlags: 0
T@1    : <my_stat
T@1    : >get_charsets_dir
T@1    : | info: charsets dir='C:\mysql\share\charsets\'
T@1    : <get_charsets_dir
T@1    : >my_stat
T@1    : | my: path: 'C:\mysql\share\charsets\koi8_ukr.conf', stat_area: 12fae0, MyFlags: 0
T@1    : <my_stat
T@1    : >get_charsets_dir
T@1    : | info: charsets dir='C:\mysql\share\charsets\'
T@1    : <get_charsets_dir
T@1    : >my_stat
T@1    : | my: path: 'C:\mysql\share\charsets\win1251ukr.conf', stat_area: 12fae0, MyFlags: 0
T@1    : <my_stat
T@1    : >get_charsets_dir
T@1    : | info: charsets dir='C:\mysql\share\charsets\'
T@1    : <get_charsets_dir
T@1    : >my_stat
T@1    : | my: path: 'C:\mysql\share\charsets\greek.conf', stat_area: 12fae0, MyFlags: 0
T@1    : <my_stat
T@1    : >get_charsets_dir
T@1    : | info: charsets dir='C:\mysql\share\charsets\'
T@1    : <get_charsets_dir
T@1    : >my_stat
T@1    : | my: path: 'C:\mysql\share\charsets\win1250.conf', stat_area: 12fae0, MyFlags: 0
T@1    : <my_stat
T@1    : >get_charsets_dir
T@1    : | info: charsets dir='C:\mysql\share\charsets\'
T@1    : <get_charsets_dir
T@1    : >my_stat
T@1    : | my: path: 'C:\mysql\share\charsets\croat.conf', stat_area: 12fae0, MyFlags: 0
T@1    : <my_stat
T@1    : >get_charsets_dir
T@1    : | info: charsets dir='C:\mysql\share\charsets\'
T@1    : <get_charsets_dir
T@1    : >my_stat
T@1    : | my: path: 'C:\mysql\share\charsets\cp1257.conf', stat_area: 12fae0, MyFlags: 0
T@1    : <my_stat
T@1    : >get_charsets_dir
T@1    : | info: charsets dir='C:\mysql\share\charsets\'
T@1    : <get_charsets_dir
T@1    : >my_stat
T@1    : | my: path: 'C:\mysql\share\charsets\latin5.conf', stat_area: 12fae0, MyFlags: 0
T@1    : <my_stat
T@1    : >_mymalloc
T@1    : | enter: Size: 210
T@1    : | exit: ptr: c96688
T@1    : <_mymalloc
T@1    : >_myfree
T@1    : | enter: ptr: c94f68
T@1    : <_myfree
T@1    : >unireg_init
T@1    : | >calc_daynr
T@1    : | | exit: year: 2003  month: 12  day: 20 -> daynr: 731934
T@1    : | <calc_daynr
T@1    : <unireg_init
T@1    : >init_errmessage
T@1    : | >read_texts
T@1    : | | >fn_format
T@1    : | | | enter: name: errmsg.sys  dir: C:\mysql\share\english\  extension:   flag: 4
T@1    : | | | >dirname_part
T@1    : | | | | enter: 'errmsg.sys'
T@1    : | | | <dirname_part
T@1    : | | | >unpack_dirname
T@1    : | | | | >dirname_part
T@1    : | | | | | enter: 'C:\mysql\share\english\'
T@1    : | | | | <dirname_part
T@1    : | | | | >cleanup_dirname
T@1    : | | | | | enter: from: 'C:\mysql\share\english\'
T@1    : | | | | | exit: to: 'C:\mysql\share\english\'
T@1    : | | | | <cleanup_dirname
T@1    : | | | <unpack_dirname
T@1    : | | | >strlength
T@1    : | | | <strlength
T@1    : | | <fn_format
T@1    : | | >my_open
T@1    : | | | my: Name: 'C:\mysql\share\english\errmsg.sys'  Flags: 36864  MyFlags: 0
T@1    : | | <my_open
T@1    : | | >_mymalloc
T@1    : | | | enter: Size: 34
T@1    : | | | exit: ptr: c94f68
T@1    : | | <_mymalloc
T@1    : | | exit: fd: 4
T@1    : | | >my_read
T@1    : | | | my: Fd: 4  Buffer: 12fcdc  Count: 32  MyFlags: 4
T@1    : | | <my_read
T@1    : | | >_myfree
T@1    : | | | enter: ptr: 0
T@1    : | | <_myfree
T@1    : | | >_mymalloc
T@1    : | | | enter: Size: 13005
T@1    : | | | exit: ptr: c977c0
T@1    : | | <_mymalloc
T@1    : | | >my_read
T@1    : | | | my: Fd: 4  Buffer: c97b78  Count: 476  MyFlags: 4
T@1    : | | <my_read
T@1    : | | >my_read
T@1    : | | | my: Fd: 4  Buffer: c97b78  Count: 12053  MyFlags: 4
T@1    : | | <my_read
T@1    : | | >my_close
T@1    : | | | my: fd: 4  MyFlags: 0
T@1    : | | | >_myfree
T@1    : | | | | enter: ptr: c94f68
T@1    : | | | <_myfree
T@1    : | | <my_close
T@1    : | <read_texts
T@1    : <init_errmessage
T@1    : >lex_init
T@1    : <lex_init
T@1    : >hash_init
T@1    : | enter: hash: 779930  size: 16
T@1    : | >init_dynamic_array
T@1    : | | >_mymalloc
T@1    : | | | enter: Size: 128
T@1    : | | | exit: ptr: c94f68
T@1    : | | <_mymalloc
T@1    : | <init_dynamic_array
T@1    : <hash_init
T@1    : >hash_init
T@1    : | enter: hash: 77d508  size: 90
T@1    : | >init_dynamic_array
T@1    : | | >_mymalloc
T@1    : | | | enter: Size: 720
T@1    : | | | exit: ptr: c95030
T@1    : | | <_mymalloc
T@1    : | <init_dynamic_array
T@1    : <hash_init
T@1    : >_mymalloc
T@1    : | enter: Size: 128
T@1    : | exit: ptr: c95928
T@1    : <_mymalloc
T@1    : >my_setwd
T@1    : | my: dir: 'C:\mysql\data\'  MyFlags 16
T@1    : <my_setwd
T@1    : >server_init
T@1    : | general: IP Socket is 3306
T@1    : | info: server started
T@1    : <server_init
T@1    : >hash_init
T@1    : | enter: hash: 77da38  size: 80
T@1    : | >init_dynamic_array
T@1    : | | >_mymalloc
T@1    : | | | enter: Size: 640
T@1    : | | | exit: ptr: c959f0
T@1    : | | <_mymalloc
T@1    : | <init_dynamic_array
T@1    : <hash_init
T@1    : >mysql_rm_tmp_tables
T@1    : | >my_dir
T@1    : | | my: path: 'C:\DOCUME~1\csmith8\LOCALS~1\Temp\' stat: 528  MyFlags: 1274864
T@1    : | | >_mymalloc
T@1    : | | | enter: Size: 32480
T@1    : | | | exit: ptr: 1250080
T@1    : | | <_mymalloc
T@1    : | | test: eof: -1  errno: 2
T@1    : | <my_dir
T@1    : | >my_dirend
T@1    : | | >_myfree
T@1    : | | | enter: ptr: 1250080
T@1    : | | <_myfree
T@1    : | <my_dirend
T@1    : <mysql_rm_tmp_tables
T@1    : >hash_free
T@1    : <hash_free
T@1    : >hash_init
T@1    : | enter: hash: c95cd8  size: 128
T@1    : | >init_dynamic_array
T@1    : | | >_mymalloc
T@1    : | | | enter: Size: 1024
T@1    : | | | exit: ptr: c9aad8
T@1    : | | <_mymalloc
T@1    : | <init_dynamic_array
T@1    : <hash_init
T@1    : >Query_cache::resize
T@1    : | qcache: from 0 to 0
T@1    : | >Query_cache::free_cache
T@1    : | <Query_cache::free_cache
T@1    : <Query_cache::resize
T@1    : >Query_cache::init_cache
T@1    : | >Query_cache::init
T@1    : | <Query_cache::init
T@1    : | >Query_cache::make_disabled
T@1    : | <Query_cache::make_disabled
T@1    : <Query_cache::init_cache
T@1    : >hash_init
T@1    : | enter: hash: 77cb50  size: 128
T@1    : | >init_dynamic_array
T@1    : | | >_mymalloc
T@1    : | | | enter: Size: 1024
T@1    : | | | exit: ptr: c9af20
T@1    : | | <_mymalloc
T@1    : | <init_dynamic_array
T@1    : <hash_init
T@1    : >fn_format
T@1    : | enter: name: WNAHOU-14931  dir: .  extension: .err  flag: 0
T@1    : | >dirname_part
T@1    : | | enter: 'WNAHOU-14931'
T@1    : | <dirname_part
T@1    : | >strlength
T@1    : | <strlength
T@1    : <fn_format
T@1    : >berkeley_init
T@1    : | bdb: berkeley_home: C:\mysql\data\
T@1    : | >hash_init
T@1    : | | enter: hash: 7796c8  size: 32
T@1    : | | >init_dynamic_array
T@1    : | | | >_mymalloc
T@1    : | | | | enter: Size: 256
T@1    : | | | | exit: ptr: c9bcf0
T@1    : | | | <_mymalloc
T@1    : | | <init_dynamic_array
T@1    : | <hash_init
T@1    : <berkeley_init
T@1    : >innobase_init
T@1    : | >_mymalloc
T@1    : | | enter: Size: 23
T@1    : | | exit: ptr: c9be38
T@1    : | <_mymalloc
T@1    : | >MYSQL_LOG::close
T@1    : | | enter: exiting: 1
T@1    : | <MYSQL_LOG::close
T@1    : | >MYSQL_LOG::close
T@1    : | | enter: exiting: 1
T@1    : | <MYSQL_LOG::close
T@1    : | >MYSQL_LOG::close
T@1    : | | enter: exiting: 1
T@1    : | <MYSQL_LOG::close
T@1    : | >MYSQL_LOG::close
T@1    : | | enter: exiting: 1
T@1    : | <MYSQL_LOG::close





**********************************************************************
This e-mail is the property of Enron Corp. and/or its relevant affiliate and may contain confidential and privileged material for the sole use of the intended recipient (s). Any review, use, distribution or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive for the recipient), please contact the sender or reply to Enron Corp. at [email protected] and delete all copies of the message. This e-mail (and any attachments hereto) are not intended to be an offer (or an acceptance) and do not create or evidence a binding and enforceable contract between Enron Corp. (or any of its affiliates) and the intended recipient or any other party, and may not be relied on by anyone as the basis of a contract by estoppel or otherwise. Thank you. 
**********************************************************************