----- Original Message ----- From: "Smith, Christopher L." <Chri...@ENRON.com> To: <bu...@lists.mysql.com>; <win...@lists.mysql.com> Sent: Saturday, December 20, 2003 9:41 PM Subject: ERROR 33 - AIO WRITE ERROR

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