ERROR 33 - AIO WRITE ERROR

am 20.12.2003 20:41:30 von Christopher.L.Smith

------_=_NextPart_001_01C3C731.44363084
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

All -=20

This error hit me last night and I'm not quite sure what to make of it. I'v=
e researched the documentation and only found one reference to Error 33 wit=
hin 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 re=
start 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 operati=
on.
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 data=
base...
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=20
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 536631094, file name .\WNAHOU-149=
31-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 operati=
on.
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 data=
base...
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=20
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 536631094, file name .\WNAHOU-149=
31-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 operati=
on.
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:=20
T@1 : | exit: to: C:\mysql\
T@1 : T@1 : >my_load_path
T@1 : | enter: path: C:\mysql\data\ prefix: C:\mysql\
T@1 : | exit: to: C:\mysql\data\
T@1 : 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 : T@1 : >my_load_path
T@1 : | enter: path: english\ prefix: C:\mysql\share\
T@1 : | exit: to: C:\mysql\share\english\
T@1 : 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 : | T@1 : | >get_charsets_dir
T@1 : | | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : | 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 : | T@1 : | >init_dynamic_array
T@1 : | | >_mymalloc
T@1 : | | | enter: Size: 128
T@1 : | | | exit: ptr: c966f0
T@1 : | | <_mymalloc
T@1 : | 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 : | T@1 : | >_myfree
T@1 : | | enter: ptr: c966f0
T@1 : | <_myfree
T@1 : T@1 : >init_dynamic_string
T@1 : | >_mymalloc
T@1 : | | enter: Size: 256
T@1 : | | exit: ptr: c94f68
T@1 : | <_mymalloc
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\dec8.conf', stat_area: 12fae0=
, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\dos.conf', stat_area: 12fae0,=
MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\german1.conf', stat_area: 12f=
ae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\hp8.conf', stat_area: 12fae0,=
MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\koi8_ru.conf', stat_area: 12f=
ae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\latin2.conf', stat_area: 12fa=
e0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\swe7.conf', stat_area: 12fae0=
, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\usa7.conf', stat_area: 12fae0=
, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\cp1251.conf', stat_area: 12fa=
e0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\danish.conf', stat_area: 12fa=
e0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\hebrew.conf', stat_area: 12fa=
e0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\win1251.conf', stat_area: 12f=
ae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\estonia.conf', stat_area: 12f=
ae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\hungarian.conf', stat_area: 1=
2fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\koi8_ukr.conf', stat_area: 12=
fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\win1251ukr.conf', stat_area: =
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\greek.conf', stat_area: 12fae=
0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\win1250.conf', stat_area: 12f=
ae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\croat.conf', stat_area: 12fae=
0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\cp1257.conf', stat_area: 12fa=
e0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\latin5.conf', stat_area: 12fa=
e0, MyFlags: 0
T@1 : 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 : | T@1 : T@1 : >init_errmessage
T@1 : | >read_texts
T@1 : | | >fn_format
T@1 : | | | enter: name: errmsg.sys dir: C:\mysql\share\english\ exten=
sion: flag: 4
T@1 : | | | >dirname_part
T@1 : | | | | enter: 'errmsg.sys'
T@1 : | | | T@1 : | | | >unpack_dirname
T@1 : | | | | >dirname_part
T@1 : | | | | | enter: 'C:\mysql\share\english\'
T@1 : | | | | T@1 : | | | | >cleanup_dirname
T@1 : | | | | | enter: from: 'C:\mysql\share\english\'
T@1 : | | | | | exit: to: 'C:\mysql\share\english\'
T@1 : | | | | T@1 : | | | T@1 : | | | >strlength
T@1 : | | | T@1 : | | T@1 : | | >my_open
T@1 : | | | my: Name: 'C:\mysql\share\english\errmsg.sys' Flags: 36864 =
MyFlags: 0
T@1 : | | 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 : | | 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 : | | T@1 : | | >my_read
T@1 : | | | my: Fd: 4 Buffer: c97b78 Count: 12053 MyFlags: 4
T@1 : | | T@1 : | | >my_close
T@1 : | | | my: fd: 4 MyFlags: 0
T@1 : | | | >_myfree
T@1 : | | | | enter: ptr: c94f68
T@1 : | | | <_myfree
T@1 : | | T@1 : | T@1 : T@1 : >lex_init
T@1 : 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 : | T@1 : 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 : | T@1 : 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 : T@1 : >server_init
T@1 : | general: IP Socket is 3306
T@1 : | info: server started
T@1 : 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 : | T@1 : T@1 : >mysql_rm_tmp_tables
T@1 : | >my_dir
T@1 : | | my: path: 'C:\DOCUME~1\csmith8\LOCALS~1\Temp\' stat: 528 MyFl=
ags: 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 : | T@1 : | >my_dirend
T@1 : | | >_myfree
T@1 : | | | enter: ptr: 1250080
T@1 : | | <_myfree
T@1 : | T@1 : T@1 : >hash_free
T@1 : 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 : | T@1 : T@1 : >Query_cache::resize
T@1 : | qcache: from 0 to 0
T@1 : | >Query_cache::free_cache
T@1 : | T@1 : T@1 : >Query_cache::init_cache
T@1 : | >Query_cache::init
T@1 : | T@1 : | >Query_cache::make_disabled
T@1 : | T@1 : 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 : | T@1 : 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 : | T@1 : | >strlength
T@1 : | T@1 : 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 : | | T@1 : | T@1 : 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 : | T@1 : | >MYSQL_LOG::close
T@1 : | | enter: exiting: 1
T@1 : | T@1 : | >MYSQL_LOG::close
T@1 : | | enter: exiting: 1
T@1 : | T@1 : | >MYSQL_LOG::close
T@1 : | | enter: exiting: 1
T@1 : |

************************************************************ **********
This e-mail is the property of Enron Corp. and/or its relevant affiliate an=
d may contain confidential and privileged material for the sole use of the =
intended recipient (s). Any review, use, distribution or disclosure by othe=
rs is strictly prohibited. If you are not the intended recipient (or author=
ized to receive for the recipient), please contact the sender or reply to E=
nron Corp. at enron.messaging.administration@enron.com and delete all copie=
s 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 any=
one as the basis of a contract by estoppel or otherwise. Thank you.=20
************************************************************ **********

------_=_NextPart_001_01C3C731.44363084--

Re: ERROR 33 - AIO WRITE ERROR

am 20.12.2003 21:24:31 von Sinisa Milivojevic

Smith, Christopher L. writes:
> 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.

Hi!

The above truly looks like our bug.

It is either our bug or some memory corruption, because if you get
'Numerical argument out of domain' in the write operation, that is
truly a heavy error.

However, I do not see how can we repeat that.

I have looked at the trace and it seems that it has been started after
that error was raised.

We would be happy if you would come up with fully repeatable test
case, that would always lead to this error.

Thanks in advance.

--

Sincerely,

--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB
/_/ /_/\_, /___/\___\_\___/ Fulltime Developer and Support Coordinator
<___/ www.mysql.com Larnaca, Cyprus

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: ERROR 33 - AIO WRITE ERROR

am 20.12.2003 21:24:31 von Sinisa Milivojevic

RE: ERROR 33 - AIO WRITE ERROR

am 20.12.2003 22:51:26 von Christopher.L.Smith

------_=_NextPart_001_01C3C743.6B0761DF
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64

U2luaXNhIC0NCiANClRoZSBlcnJvciByZXBlYXRzIGl0c2VsZiB3aGVuZXZl ciBJIGF0dGVtcHQg
dG8gcmVzdGFydCBteXNxbGQvbXlzcWxkLW50L2V0YyB3aXRoIHRoZSB1c3Vh bCBvciBkZWJ1dCBz
ZXR0aW5ncy4gIElzIHRoZXJlIGEgcGFydGljdWxhciB3YXkgdGhhdCBJIGNh biBjYXB0dXJlIHRo
ZSBkYXRhIGZvciB5b3Ugc3VjaCB0aGF0IGl0IHdvdWxkIGJlIHVzZWZ1bD8g IA0KIA0KQWxzbywg
SSB3aWxsIHRlbGwgeW91IHRoYXQgSSBtb3ZlZCB0aGUgZGlyZWN0b3J5IG92 ZXIgdG8gYSBuZXcg
c2VydmVyLCBhbmQgbXlzcWwvaW5ub2RiIGFwcGVhcmVkIGFibGUgdG8gbG9h ZCB0aGUgZmlsZSAo
aS5lLiwgbWFrZSBpdCBwYXN0IHRoaXMgZXJyb3IpLiAgVGhhdCBtaWdodCBp bmRpY2F0ZSBhIHBy
b2JsZW0gb24gdGhlIGhvc3QgcmVsYXRlZCB0byBkaXNrIHJlYWQvd3JpdGUg b3Igc29tZXRoaW5n
IChoYXJkd2FyZSBvciBzb2Z0d2FyZS93aG8ga25vd3MpLg0KIA0KQ2hyaXMN Cg0KCS0tLS0tT3Jp
Z2luYWwgTWVzc2FnZS0tLS0tIA0KCUZyb206IFNpbmlzYSBNaWxpdm9qZXZp YyBbbWFpbHRvOnNp
bmlzYUBteXNxbC5jb21dIA0KCVNlbnQ6IFNhdCAxMi8yMC8yMDAzIDI6MjQg UE0gDQoJVG86IFNt
aXRoLCBDaHJpc3RvcGhlciBMLiANCglDYzogYnVnc0BsaXN0cy5teXNxbC5j b207IHdpbjMyQGxp
c3RzLm15c3FsLmNvbSANCglTdWJqZWN0OiBSZTogRVJST1IgMzMgLSBBSU8g V1JJVEUgRVJST1IN
CgkNCgkNCg0KCVNtaXRoLCBDaHJpc3RvcGhlciBMLiB3cml0ZXM6IA0KCT4g QWxsIC0gDQoJPiAN
Cgk+IFRoaXMgZXJyb3IgaGl0IG1lIGxhc3QgbmlnaHQgYW5kIEknbSBub3Qg cXVpdGUgc3VyZSB3
aGF0IHRvIG1ha2Ugb2YgaXQuIEkndmUgcmVzZWFyY2hlZCB0aGUgZG9jdW1l bnRhdGlvbiBhbmQg
b25seSBmb3VuZCBvbmUgcmVmZXJlbmNlIHRvIEVycm9yIDMzIHdpdGhpbiB0 aGUgSU5OT0RCICYg
TVlTUUwgZG9jdW1lbnRhdGlvbiwgYnV0IHRoaXMgd2Fzbid0IGhlbHBmdWwu IEkgZG9uJ3Qga25v
dyBpZiBpdCBpcyBhIGJ1ZyBvciBub3QsIGJ1dCBJIGNhbm5vdCBtYWtlIGEg dGVzdCBzY3JpcHQg
YmVjYXVzZSBJIGNhbm5vdCByZXN0YXJ0IG15c3FsIHVuZGVyIGFueSBzdGF0 ZS4gIFdvdWxkIG11
Y2ggYXBwcmVjaWF0ZSBhbnkgaWRlYXMuDQoNCgk+IA0KCT4gSGVyZSBpcyB3 aGF0IEkgcmVjb3Zl
cmVkIGZyb20gdGhlICdlcnInIGZpbGUgLSB0aGUgdHJhY2UgaXMgYXR0YWNo ZWQgYmVsb3c6IA0K
CT4gDQoJPiBNeVNxbDogcmVhZHkgZm9yIGNvbm5lY3Rpb25zLiANCgk+IFZl cnNpb246ICc0LjAu
MTYtbnQnICBzb2NrZXQ6ICcnICBwb3J0OiAzMzA2IA0KCT4gMDMxMjIwICA5 OjAwOjQ3ICBJbm5v
REI6IE9wZXJhdGluZyBzeXN0ZW0gZXJyb3IgbnVtYmVyIDMzIGluIGEgZmls ZSBvcGVyYXRpb24u
IA0KDQoJSGkhIA0KDQoJVGhlIGFib3ZlIHRydWx5IGxvb2tzIGxpa2Ugb3Vy IGJ1Zy4gDQoNCglJ
dCBpcyBlaXRoZXIgb3VyIGJ1ZyBvciBzb21lIG1lbW9yeSBjb3JydXB0aW9u LCBiZWNhdXNlIGlm
IHlvdSBnZXQgDQoJJ051bWVyaWNhbCBhcmd1bWVudCBvdXQgb2YgZG9tYWlu JyBpbiB0aGUgd3Jp
dGUgb3BlcmF0aW9uLCB0aGF0IGlzIA0KCXRydWx5IGEgaGVhdnkgZXJyb3Iu IA0KDQoJSG93ZXZl
ciwgSSBkbyBub3Qgc2VlIGhvdyBjYW4gd2UgcmVwZWF0IHRoYXQuIA0KDQoJ SSBoYXZlIGxvb2tl
ZCBhdCB0aGUgdHJhY2UgYW5kIGl0IHNlZW1zIHRoYXQgaXQgaGFzIGJlZW4g c3RhcnRlZCBhZnRl
ciANCgl0aGF0IGVycm9yIHdhcyByYWlzZWQuIA0KDQoJV2Ugd291bGQgYmUg aGFwcHkgaWYgeW91
IHdvdWxkIGNvbWUgdXAgd2l0aCBmdWxseSByZXBlYXRhYmxlIHRlc3QgDQoJ Y2FzZSwgdGhhdCB3
b3VsZCBhbHdheXMgbGVhZCB0byB0aGlzIGVycm9yLiANCg0KCVRoYW5rcyBp biBhZHZhbmNlLiAN
Cg0KCS0tIA0KDQoJU2luY2VyZWx5LCANCg0KCS0tIA0KCUZvciB0ZWNobmlj YWwgc3VwcG9ydCBj
b250cmFjdHMsIGdvIHRvIGh0dHBzOi8vb3JkZXIubXlzcWwuY29tLz9yZWY9 bXNtaSANCgkgICBf
XyAgX19fICAgICBfX18gX19fXyAgX18gDQoJICAvICB8LyAgL18gX18vIF9f LyBfXyBcLyAvICAg
IE1yLiBTaW5pc2EgTWlsaXZvamV2aWMgPHNpbmlzYUBteXNxbC5jb20+IA0K CSAvIC98Xy8gLyAv
LyAvXCBcLyAvXy8gLyAvX18gICBNeVNRTCBBQiANCgkvXy8gIC9fL1xfLCAv X19fL1xfX19cX1xf
X18vICAgRnVsbHRpbWUgRGV2ZWxvcGVyIGFuZCBTdXBwb3J0IENvb3JkaW5h dG9yIA0KCSAgICAg
ICA8X19fLyAgIHd3dy5teXNxbC5jb20gICBMYXJuYWNhLCBDeXBydXMgDQoN Cg0KDQoqKioqKioq
KioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioq KioqKioqKioqKioq
KioqKioqDQpUaGlzIGUtbWFpbCBpcyB0aGUgcHJvcGVydHkgb2YgRW5yb24g Q29ycC4gYW5kL29y
IGl0cyByZWxldmFudCBhZmZpbGlhdGUgYW5kIG1heSBjb250YWluIGNvbmZp ZGVudGlhbCBhbmQg
cHJpdmlsZWdlZCBtYXRlcmlhbCBmb3IgdGhlIHNvbGUgdXNlIG9mIHRoZSBp bnRlbmRlZCByZWNp
cGllbnQgKHMpLiBBbnkgcmV2aWV3LCB1c2UsIGRpc3RyaWJ1dGlvbiBvciBk aXNjbG9zdXJlIGJ5
IG90aGVycyBpcyBzdHJpY3RseSBwcm9oaWJpdGVkLiBJZiB5b3UgYXJlIG5v dCB0aGUgaW50ZW5k
ZWQgcmVjaXBpZW50IChvciBhdXRob3JpemVkIHRvIHJlY2VpdmUgZm9yIHRo ZSByZWNpcGllbnQp
LCBwbGVhc2UgY29udGFjdCB0aGUgc2VuZGVyIG9yIHJlcGx5IHRvIEVucm9u IENvcnAuIGF0IGVu
cm9uLm1lc3NhZ2luZy5hZG1pbmlzdHJhdGlvbkBlbnJvbi5jb20gYW5kIGRl bGV0ZSBhbGwgY29w
aWVzIG9mIHRoZSBtZXNzYWdlLiBUaGlzIGUtbWFpbCAoYW5kIGFueSBhdHRh Y2htZW50cyBoZXJl
dG8pIGFyZSBub3QgaW50ZW5kZWQgdG8gYmUgYW4gb2ZmZXIgKG9yIGFuIGFj Y2VwdGFuY2UpIGFu
ZCBkbyBub3QgY3JlYXRlIG9yIGV2aWRlbmNlIGEgYmluZGluZyBhbmQgZW5m b3JjZWFibGUgY29u
dHJhY3QgYmV0d2VlbiBFbnJvbiBDb3JwLiAob3IgYW55IG9mIGl0cyBhZmZp bGlhdGVzKSBhbmQg
dGhlIGludGVuZGVkIHJlY2lwaWVudCBvciBhbnkgb3RoZXIgcGFydHksIGFu ZCBtYXkgbm90IGJl
IHJlbGllZCBvbiBieSBhbnlvbmUgYXMgdGhlIGJhc2lzIG9mIGEgY29udHJh Y3QgYnkgZXN0b3Bw
ZWwgb3Igb3RoZXJ3aXNlLiBUaGFuayB5b3UuIA0KKioqKioqKioqKioqKioq KioqKioqKioqKioq
KioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKg0K DQo=

------_=_NextPart_001_01C3C743.6B0761DF--

Re: ERROR 33 - AIO WRITE ERROR

am 21.12.2003 17:14:58 von Heikki Tuuri

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."
To: ;
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 : T@1 : >my_load_path
T@1 : | enter: path: C:\mysql\data\ prefix: C:\mysql\
T@1 : | exit: to: C:\mysql\data\
T@1 : 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 : T@1 : >my_load_path
T@1 : | enter: path: english\ prefix: C:\mysql\share\
T@1 : | exit: to: C:\mysql\share\english\
T@1 : 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 : | T@1 : | >get_charsets_dir
T@1 : | | info: charsets dir='C:\mysql\share\charsets\'
T@1 : | 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 : | T@1 : | >init_dynamic_array
T@1 : | | >_mymalloc
T@1 : | | | enter: Size: 128
T@1 : | | | exit: ptr: c966f0
T@1 : | | <_mymalloc
T@1 : | 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 : | T@1 : | >_myfree
T@1 : | | enter: ptr: c966f0
T@1 : | <_myfree
T@1 : T@1 : >init_dynamic_string
T@1 : | >_mymalloc
T@1 : | | enter: Size: 256
T@1 : | | exit: ptr: c94f68
T@1 : | <_mymalloc
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\dec8.conf', stat_area: 12fae0,
MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\dos.conf', stat_area: 12fae0,
MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\german1.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\hp8.conf', stat_area: 12fae0,
MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\koi8_ru.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\latin2.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\swe7.conf', stat_area: 12fae0,
MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\usa7.conf', stat_area: 12fae0,
MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\cp1251.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\danish.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\hebrew.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\win1251.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\estonia.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\hungarian.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\koi8_ukr.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\win1251ukr.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\greek.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\win1250.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\croat.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\cp1257.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\latin5.conf', stat_area:
12fae0, MyFlags: 0
T@1 : 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 : | T@1 : 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 : | | | T@1 : | | | >unpack_dirname
T@1 : | | | | >dirname_part
T@1 : | | | | | enter: 'C:\mysql\share\english\'
T@1 : | | | | T@1 : | | | | >cleanup_dirname
T@1 : | | | | | enter: from: 'C:\mysql\share\english\'
T@1 : | | | | | exit: to: 'C:\mysql\share\english\'
T@1 : | | | | T@1 : | | | T@1 : | | | >strlength
T@1 : | | | T@1 : | | T@1 : | | >my_open
T@1 : | | | my: Name: 'C:\mysql\share\english\errmsg.sys' Flags: 36864
MyFlags: 0
T@1 : | | 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 : | | 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 : | | T@1 : | | >my_read
T@1 : | | | my: Fd: 4 Buffer: c97b78 Count: 12053 MyFlags: 4
T@1 : | | T@1 : | | >my_close
T@1 : | | | my: fd: 4 MyFlags: 0
T@1 : | | | >_myfree
T@1 : | | | | enter: ptr: c94f68
T@1 : | | | <_myfree
T@1 : | | T@1 : | T@1 : T@1 : >lex_init
T@1 : 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 : | T@1 : 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 : | T@1 : 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 : T@1 : >server_init
T@1 : | general: IP Socket is 3306
T@1 : | info: server started
T@1 : 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 : | T@1 : 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 : | T@1 : | >my_dirend
T@1 : | | >_myfree
T@1 : | | | enter: ptr: 1250080
T@1 : | | <_myfree
T@1 : | T@1 : T@1 : >hash_free
T@1 : 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 : | T@1 : T@1 : >Query_cache::resize
T@1 : | qcache: from 0 to 0
T@1 : | >Query_cache::free_cache
T@1 : | T@1 : T@1 : >Query_cache::init_cache
T@1 : | >Query_cache::init
T@1 : | T@1 : | >Query_cache::make_disabled
T@1 : | T@1 : 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 : | T@1 : 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 : | T@1 : | >strlength
T@1 : | T@1 : 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 : | | T@1 : | T@1 : 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 : | T@1 : | >MYSQL_LOG::close
T@1 : | | enter: exiting: 1
T@1 : | T@1 : | >MYSQL_LOG::close
T@1 : | | enter: exiting: 1
T@1 : | T@1 : | >MYSQL_LOG::close
T@1 : | | enter: exiting: 1
T@1 : |

************************************************************ **********
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 enron.messaging.administration@enron.com 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/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: ERROR 33 - AIO WRITE ERROR

am 21.12.2003 17:14:58 von Heikki Tuuri

RE: ERROR 33 - AIO WRITE ERROR

am 21.12.2003 20:09:46 von Christopher.L.Smith

No - Nothing. And I rebooted several times, closed down all extaneous =
services, etc.

-----Original Message-----
From: Heikki Tuuri [mailto:Heikki.Tuuri@innodb.com]
Sent: Sunday, December 21, 2003 10:15 AM
To: bugs@lists.mysql.com; win32@lists.mysql.com
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 -----=20
From: "Smith, Christopher L."
To: ;
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 : T@1 : >my_load_path
T@1 : | enter: path: C:\mysql\data\ prefix: C:\mysql\
T@1 : | exit: to: C:\mysql\data\
T@1 : 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 : T@1 : >my_load_path
T@1 : | enter: path: english\ prefix: C:\mysql\share\
T@1 : | exit: to: C:\mysql\share\english\
T@1 : 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 : | T@1 : | >get_charsets_dir
T@1 : | | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : | 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 : | T@1 : | >init_dynamic_array
T@1 : | | >_mymalloc
T@1 : | | | enter: Size: 128
T@1 : | | | exit: ptr: c966f0
T@1 : | | <_mymalloc
T@1 : | 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 : | T@1 : | >_myfree
T@1 : | | enter: ptr: c966f0
T@1 : | <_myfree
T@1 : T@1 : >init_dynamic_string
T@1 : | >_mymalloc
T@1 : | | enter: Size: 256
T@1 : | | exit: ptr: c94f68
T@1 : | <_mymalloc
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\dec8.conf', stat_area: =
12fae0,
MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\dos.conf', stat_area: =
12fae0,
MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\german1.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\hp8.conf', stat_area: =
12fae0,
MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\koi8_ru.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\latin2.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\swe7.conf', stat_area: =
12fae0,
MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\usa7.conf', stat_area: =
12fae0,
MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\cp1251.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\danish.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\hebrew.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\win1251.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\estonia.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\hungarian.conf', =
stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\koi8_ukr.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\win1251ukr.conf', =
stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\greek.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\win1250.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\croat.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\cp1257.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\latin5.conf', stat_area:
12fae0, MyFlags: 0
T@1 : 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 : | T@1 : 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 : | | | T@1 : | | | >unpack_dirname
T@1 : | | | | >dirname_part
T@1 : | | | | | enter: 'C:\mysql\share\english\'
T@1 : | | | | T@1 : | | | | >cleanup_dirname
T@1 : | | | | | enter: from: 'C:\mysql\share\english\'
T@1 : | | | | | exit: to: 'C:\mysql\share\english\'
T@1 : | | | | T@1 : | | | T@1 : | | | >strlength
T@1 : | | | T@1 : | | T@1 : | | >my_open
T@1 : | | | my: Name: 'C:\mysql\share\english\errmsg.sys' Flags: =
36864
MyFlags: 0
T@1 : | | 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 : | | 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 : | | T@1 : | | >my_read
T@1 : | | | my: Fd: 4 Buffer: c97b78 Count: 12053 MyFlags: 4
T@1 : | | T@1 : | | >my_close
T@1 : | | | my: fd: 4 MyFlags: 0
T@1 : | | | >_myfree
T@1 : | | | | enter: ptr: c94f68
T@1 : | | | <_myfree
T@1 : | | T@1 : | T@1 : T@1 : >lex_init
T@1 : 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 : | T@1 : 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 : | T@1 : 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 : T@1 : >server_init
T@1 : | general: IP Socket is 3306
T@1 : | info: server started
T@1 : 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 : | T@1 : 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 : | T@1 : | >my_dirend
T@1 : | | >_myfree
T@1 : | | | enter: ptr: 1250080
T@1 : | | <_myfree
T@1 : | T@1 : T@1 : >hash_free
T@1 : 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 : | T@1 : T@1 : >Query_cache::resize
T@1 : | qcache: from 0 to 0
T@1 : | >Query_cache::free_cache
T@1 : | T@1 : T@1 : >Query_cache::init_cache
T@1 : | >Query_cache::init
T@1 : | T@1 : | >Query_cache::make_disabled
T@1 : | T@1 : 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 : | T@1 : 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 : | T@1 : | >strlength
T@1 : | T@1 : 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 : | | T@1 : | T@1 : 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 : | T@1 : | >MYSQL_LOG::close
T@1 : | | enter: exiting: 1
T@1 : | T@1 : | >MYSQL_LOG::close
T@1 : | | enter: exiting: 1
T@1 : | T@1 : | >MYSQL_LOG::close
T@1 : | | enter: exiting: 1
T@1 : |

************************************************************ **********
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 enron.messaging.administration@enron.com 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.
************************************************************ **********

--=20
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: =
http://lists.mysql.com/bugs?unsub=3Dchristopher.l.smith@enro n.com

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=3Dgcdmb-bugs@m.gmane.org

RE: ERROR 33 - AIO WRITE ERROR

am 22.12.2003 13:05:09 von Sinisa Milivojevic

Smith, Christopher L. writes:
> No - Nothing. And I rebooted several times, closed down all extaneous services, etc.
>

Hi!

Please check out that directory containing a datadir is not on some
share.

And, as I said before, we need a fully repeatable test case to fix it,
if it is our bug.

--

Sincerely,

--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB
/_/ /_/\_, /___/\___\_\___/ Fulltime Developer and Support Coordinator
<___/ www.mysql.com Larnaca, Cyprus

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

RE: ERROR 33 - AIO WRITE ERROR

am 22.12.2003 13:05:09 von Sinisa Milivojevic

Re: ERROR 33 - AIO WRITE ERROR

am 22.12.2003 15:10:11 von Heikki Tuuri

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" (ml.mysql@in-genius.com)
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:cwright@liquidmachines.com]=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."
Vastaanottaja: "Heikki Tuuri" ;
;
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:Heikki.Tuuri@innodb.com]
Sent: Sunday, December 21, 2003 10:15 AM
To: bugs@lists.mysql.com; win32@lists.mysql.com
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."
To: ;
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 : T@1 : >my_load_path
T@1 : | enter: path: C:\mysql\data\ prefix: C:\mysql\
T@1 : | exit: to: C:\mysql\data\
T@1 : 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 : T@1 : >my_load_path
T@1 : | enter: path: english\ prefix: C:\mysql\share\
T@1 : | exit: to: C:\mysql\share\english\
T@1 : 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 : | T@1 : | >get_charsets_dir
T@1 : | | info: charsets dir='C:\mysql\share\charsets\'
T@1 : | 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 : | T@1 : | >init_dynamic_array
T@1 : | | >_mymalloc
T@1 : | | | enter: Size: 128
T@1 : | | | exit: ptr: c966f0
T@1 : | | <_mymalloc
T@1 : | 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 : | T@1 : | >_myfree
T@1 : | | enter: ptr: c966f0
T@1 : | <_myfree
T@1 : T@1 : >init_dynamic_string
T@1 : | >_mymalloc
T@1 : | | enter: Size: 256
T@1 : | | exit: ptr: c94f68
T@1 : | <_mymalloc
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\dec8.conf', stat_area: 12fae0,
MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\dos.conf', stat_area: 12fae0,
MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\german1.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\hp8.conf', stat_area: 12fae0,
MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\koi8_ru.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\latin2.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\swe7.conf', stat_area: 12fae0,
MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\usa7.conf', stat_area: 12fae0,
MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\cp1251.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\danish.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\hebrew.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\win1251.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\estonia.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\hungarian.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\koi8_ukr.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\win1251ukr.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\greek.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\win1250.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\croat.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\cp1257.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir='C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\latin5.conf', stat_area:
12fae0, MyFlags: 0
T@1 : 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 : | T@1 : 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 : | | | T@1 : | | | >unpack_dirname
T@1 : | | | | >dirname_part
T@1 : | | | | | enter: 'C:\mysql\share\english\'
T@1 : | | | | T@1 : | | | | >cleanup_dirname
T@1 : | | | | | enter: from: 'C:\mysql\share\english\'
T@1 : | | | | | exit: to: 'C:\mysql\share\english\'
T@1 : | | | | T@1 : | | | T@1 : | | | >strlength
T@1 : | | | T@1 : | | T@1 : | | >my_open
T@1 : | | | my: Name: 'C:\mysql\share\english\errmsg.sys' Flags: 36864
MyFlags: 0
T@1 : | | 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 : | | 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 : | | T@1 : | | >my_read
T@1 : | | | my: Fd: 4 Buffer: c97b78 Count: 12053 MyFlags: 4
T@1 : | | T@1 : | | >my_close
T@1 : | | | my: fd: 4 MyFlags: 0
T@1 : | | | >_myfree
T@1 : | | | | enter: ptr: c94f68
T@1 : | | | <_myfree
T@1 : | | T@1 : | T@1 : T@1 : >lex_init
T@1 : 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 : | T@1 : 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 : | T@1 : 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 : T@1 : >server_init
T@1 : | general: IP Socket is 3306
T@1 : | info: server started
T@1 : 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 : | T@1 : 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 : | T@1 : | >my_dirend
T@1 : | | >_myfree
T@1 : | | | enter: ptr: 1250080
T@1 : | | <_myfree
T@1 : | T@1 : T@1 : >hash_free
T@1 : 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 : | T@1 : T@1 : >Query_cache::resize
T@1 : | qcache: from 0 to 0
T@1 : | >Query_cache::free_cache
T@1 : | T@1 : T@1 : >Query_cache::init_cache
T@1 : | >Query_cache::init
T@1 : | T@1 : | >Query_cache::make_disabled
T@1 : | T@1 : 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 : | T@1 : 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 : | T@1 : | >strlength
T@1 : | T@1 : 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 : | | T@1 : | T@1 : 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 : | T@1 : | >MYSQL_LOG::close
T@1 : | | enter: exiting: 1
T@1 : | T@1 : | >MYSQL_LOG::close
T@1 : | | enter: exiting: 1
T@1 : | T@1 : | >MYSQL_LOG::close
T@1 : | | enter: exiting: 1
T@1 : |

************************************************************ **********
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 enron.messaging.administration@enron.com 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/bugs?unsub=christopher.l.smith@enron. com

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: ERROR 33 - AIO WRITE ERROR

am 22.12.2003 15:10:11 von Heikki Tuuri

RE: ERROR 33 - AIO WRITE ERROR

am 22.12.2003 16:29:30 von Christopher.L.Smith

Heikki --

That's very helpful.=20

I copied the files, all 5.6 GB +, to another server...after INNODB =
repaired the file it worked fine. I then moved the file back to the =
original server where the problem appeared and mysql started up =
correctly and operates fine. =20

A couple of things I just wanted to let you know:

(a) I did have a virus check application running -- however it is also =
running on the new server but is causing no problems;
(b) It is on a local share drive (the whole drive is shared, but has no =
clients).

What I can't understand is why mysql wouldn't restart, even after a =
reboot, etc.

I do not think there is anyone I can recreate the problem at this point =
as the file is repaired and back up in operation.

Chris

-----Original Message-----
From: Heikki Tuuri [mailto:Heikki.Tuuri@innodb.com]
Sent: Monday, December 22, 2003 8:10 AM
To: Smith, Christopher L.; bugs@lists.mysql.com; win32@lists.mysql.com
Subject: Re: ERROR 33 - AIO WRITE ERROR

Christopher,

with Google http://www.google.com/advanced_group_search?hl=3Den, I found =
the
following advice by Kevin:

"
Message 3 in thread
From: "PF: MySQL" (ml.mysql@in-genius.com)
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:cwright@liquidmachines.com]=3D20
> 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
>=3D20

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 -----=20
Lähettäjä: "Smith, Christopher L."
Vastaanottaja: "Heikki Tuuri" ;
;
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:Heikki.Tuuri@innodb.com]
Sent: Sunday, December 21, 2003 10:15 AM
To: bugs@lists.mysql.com; win32@lists.mysql.com
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 -----=20
From: "Smith, Christopher L."
To: ;
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 : T@1 : >my_load_path
T@1 : | enter: path: C:\mysql\data\ prefix: C:\mysql\
T@1 : | exit: to: C:\mysql\data\
T@1 : 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 : T@1 : >my_load_path
T@1 : | enter: path: english\ prefix: C:\mysql\share\
T@1 : | exit: to: C:\mysql\share\english\
T@1 : 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 : | T@1 : | >get_charsets_dir
T@1 : | | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : | 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 : | T@1 : | >init_dynamic_array
T@1 : | | >_mymalloc
T@1 : | | | enter: Size: 128
T@1 : | | | exit: ptr: c966f0
T@1 : | | <_mymalloc
T@1 : | 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 : | T@1 : | >_myfree
T@1 : | | enter: ptr: c966f0
T@1 : | <_myfree
T@1 : T@1 : >init_dynamic_string
T@1 : | >_mymalloc
T@1 : | | enter: Size: 256
T@1 : | | exit: ptr: c94f68
T@1 : | <_mymalloc
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\dec8.conf', stat_area: =
12fae0,
MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\dos.conf', stat_area: =
12fae0,
MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\german1.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\hp8.conf', stat_area: =
12fae0,
MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\koi8_ru.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\latin2.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\swe7.conf', stat_area: =
12fae0,
MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\usa7.conf', stat_area: =
12fae0,
MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\cp1251.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\danish.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\hebrew.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\win1251.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\estonia.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\hungarian.conf', =
stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\koi8_ukr.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\win1251ukr.conf', =
stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\greek.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\win1250.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\croat.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\cp1257.conf', stat_area:
12fae0, MyFlags: 0
T@1 : T@1 : >get_charsets_dir
T@1 : | info: charsets dir=3D'C:\mysql\share\charsets\'
T@1 : T@1 : >my_stat
T@1 : | my: path: 'C:\mysql\share\charsets\latin5.conf', stat_area:
12fae0, MyFlags: 0
T@1 : 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 : | T@1 : 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 : | | | T@1 : | | | >unpack_dirname
T@1 : | | | | >dirname_part
T@1 : | | | | | enter: 'C:\mysql\share\english\'
T@1 : | | | | T@1 : | | | | >cleanup_dirname
T@1 : | | | | | enter: from: 'C:\mysql\share\english\'
T@1 : | | | | | exit: to: 'C:\mysql\share\english\'
T@1 : | | | | T@1 : | | | T@1 : | | | >strlength
T@1 : | | | T@1 : | | T@1 : | | >my_open
T@1 : | | | my: Name: 'C:\mysql\share\english\errmsg.sys' Flags: =
36864
MyFlags: 0
T@1 : | | 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 : | | 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 : | | T@1 : | | >my_read
T@1 : | | | my: Fd: 4 Buffer: c97b78 Count: 12053 MyFlags: 4
T@1 : | | T@1 : | | >my_close
T@1 : | | | my: fd: 4 MyFlags: 0
T@1 : | | | >_myfree
T@1 : | | | | enter: ptr: c94f68
T@1 : | | | <_myfree
T@1 : | | T@1 : | T@1 : T@1 : >lex_init
T@1 : 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 : | T@1 : 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 : | T@1 : 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 : T@1 : >server_init
T@1 : | general: IP Socket is 3306
T@1 : | info: server started
T@1 : 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 : | T@1 : 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 : | T@1 : | >my_dirend
T@1 : | | >_myfree
T@1 : | | | enter: ptr: 1250080
T@1 : | | <_myfree
T@1 : | T@1 : T@1 : >hash_free
T@1 : 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 : | T@1 : T@1 : >Query_cache::resize
T@1 : | qcache: from 0 to 0
T@1 : | >Query_cache::free_cache
T@1 : | T@1 : T@1 : >Query_cache::init_cache
T@1 : | >Query_cache::init
T@1 : | T@1 : | >Query_cache::make_disabled
T@1 : | T@1 : 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 : | T@1 : 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 : | T@1 : | >strlength
T@1 : | T@1 : 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 : | | T@1 : | T@1 : 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 : | T@1 : | >MYSQL_LOG::close
T@1 : | | enter: exiting: 1
T@1 : | T@1 : | >MYSQL_LOG::close
T@1 : | | enter: exiting: 1
T@1 : | T@1 : | >MYSQL_LOG::close
T@1 : | | enter: exiting: 1
T@1 : |

************************************************************ **********
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 enron.messaging.administration@enron.com 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.
************************************************************ **********

--=20
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:
http://lists.mysql.com/bugs?unsub=3Dchristopher.l.smith@enro n.com

--=20
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: =
http://lists.mysql.com/bugs?unsub=3Dchristopher.l.smith@enro n.com

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=3Dgcdmb-bugs@m.gmane.org