Bug #3105 error 127 and 1016
Submitted: 8 Mar 2004 6:18 Modified: 8 Mar 2004 6:52
Reporter: [ name withheld ] Email Updates:
Status: Closed Impact on me:
Category:MySQL Server Severity:S1 (Critical)
Version:MySQL 4.0.15-nt OS:Windows (windows xp)
Assigned to: CPU Architecture:Any

[8 Mar 2004 6:18] [ name withheld ]
how is possible that crashing a client that was quering a mysql db  located in a server this db(not sure a dbms...) it report the errors:

 "Got error 127 from table handler" 


"Database error: Metadata query failed.
MySQL Error: 1016 (Can't open file: 'cartella.MYI'. (errno: 145))
Session halted."

i recovered everything with myisamchk but who assure me that is possible everytime?
i suppose that a "dbms" take care at first the data integrity, why mysql doesn't take it?!

How to repeat:
crashing the client while it's quering the db...
[8 Mar 2004 6:52] MySQL Verification Team
The version 4.0.15 reported, had a bug with a function SetFilePointer(..)
which marked tables wrongly as crashed when doing commands like delete.
Please upgrade to 4.0.18 and test your case, if the problem continues
re-open this bug report and give for us a repeatable test case.