[drupal-support] Corrupted Sessions Table

[Ken Dow]

Ah! That's exactly what happened. I hadn't changed the default settings 
for the target site prior to the move, and there was a disk quota 
exceeded error shortly afterward. I corrected it right away, but 
obviously not soon enough. Thanks - that's good to know. I'll check the 
remaining tables for problems.

On Mar 17, 2005, at 12:49 PM, Dries Buytaert wrote:

> On 15 Mar 2005, at 15:43, Ken Dow wrote:
>> Fatal error: Can't open file: 'sessions.MYD'. (errno: 145) query: 
>> SELECT u.*, s.*, r.name AS role FROM users u INNER JOIN sessions s ON 
>> u.uid = s.uid LEFT JOIN role r ON u.rid = r.rid WHERE s.sid = 
>> 'e9cc93bab76197fbf51609636250a9f8' AND u.status < 3 LIMIT 0, 1 in 
>> /home/httpd/vhosts/mydomain.ca/httpdocs/includes/database.mysql.inc 
>> on line 97
>
> Most of the time this is caused by a harddisk (partition) running out 
> of disk space/quota.  This could have corrupted any table and may 
> cause data loss.

--
Ken

Nobody is smart enough to be wrong all the time.
- Ken Wilber