1016 - Can't open file: 'sessions.MYD'. (errno: 145)

[cadbilbao]

Hi.

Using MySQL 4.1.9, I got my 'sessions' table corruputed:
---------
1016 - Can't open file: 'sessions.MYD'. (errno: 145)
---------

In order to fix it, I removed it, and created a new one. Now I want to know why
I suffered this problem, since I think it's a common problem with session tables
on websites.

Any similar experience with session tables? Regards.

 

[TonyGroves]

It looks like file corruption, pure and simple.

That sort of thing could be caused by a number of factors. Hardware fault, filesystem fault, obscure MySQL bug, whatever. If it's not causing loss of critical data, or significant downtime, then maybe it's best to just restore backup and hope it doesn't happen again.

If it is causing serious inconvenience, then it might be worth looking at upgrading your system hardware and/or software to something more reliable.