Re: ERROR 33 - AIO WRITE ERROR
"Heikki Tuuri" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.bugs,gmane.comp.db.mysql.windows |
|---|---|
| Message-ID | <227a01c3c895$501cc190$155110ac@hebis> |
Christopher, with Google http://www.google.com/advanced_group_search?hl=en, I found the following advice by Kevin: " Message 3 in thread From: "PF: MySQL" ([email protected]) Subject: RE: External lock causing mysql crash. View this article only Newsgroups: mailing.database.mysql-win32 Date: 2003-08-21 07:01:40 PST > -----Original Message----- > From: Clark Wright [mailto:[email protected]]=20 > Posted At: Wednesday, August 20, 2003 12:18 PM > Posted To: MySQL > Conversation: External lock causing mysql crash. > Subject: External lock causing mysql crash. > Importance: Low >=20 Check and make sure your virus scanning is NOT scanning the mysql data directory. -Kevin " Please look from the Task Manager that you do not have backup programs, virus scans, viruses, or something else constantly running in the computer. Also run CHKDSK If these do not produce any light to the problem, then it may be that the disk is broken. Best regards, Heikki Innobase Oy http://www.innodb.com InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL support from http://www.mysql.com/support/index.html ----- Alkuperäinen viesti ----- Lähettäjä: "Smith, Christopher L." <[email protected]> Vastaanottaja: "Heikki Tuuri" <[email protected]>; <[email protected]>; <[email protected]> Lähetetty: Sunday, December 21, 2003 9:09 PM Aihe: RE: ERROR 33 - AIO WRITE ERROR No - Nothing. And I rebooted several times, closed down all extaneous services, etc. -----Original Message----- From: Heikki Tuuri [mailto:[email protected]] Sent: Sunday, December 21, 2003 10:15 AM To: [email protected]; [email protected] Subject: Re: ERROR 33 - AIO WRITE ERROR Christopher, http://www.innodb.com/ibman.php#OS_Error_codes " 33 (ERROR_LOCK_VIOLATION) The process cannot access the file because another process has locked a portion of the file. " are you running some backup program which locks files or parts of files? Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL technical support from https://order.mysql.com/ ----- Original Message ----- From: "Smith, Christopher L." <[email protected]> To: <[email protected]>; <[email protected]> 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 ********************************************************************** 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. ********************************************************************** -- MySQL Bugs Mailing List For list archives: http://lists.mysql.com/bugs To unsubscribe: http://lists.mysql.com/[email protected] -- MySQL Bugs Mailing List For list archives: http://lists.mysql.com/bugs To unsubscribe: http://lists.mysql.com/[email protected]