Disk is full

[Steve Campbell]

----- Original Message ----- 
From: "Glenn Steen" <glenn.steen at gmail.com>
To: "MailScanner discussion" <mailscanner at lists.mailscanner.info>
Sent: Friday, January 13, 2006 11:59 AM
Subject: Re: Disk is full


> On 13/01/06, Billy A. Pumphrey <bpumphrey at woodmaclaw.com> wrote:
>> >
>> > Snip
>> >
>> > I am not out of the water quite yet.  My MailWatch is not working
>> > correctly now.  If I should move this to the mailwatch list, please
>> say
>> > so.  This happened because of the full disk I would assume, as it
>> worked
>> > before then.
>> >
>> > When I go to the web page for mailwatch I get:
>> >
>> > Error executing query:
>> >
>> > Can't open file: 'maillog.MYI' (errno: 145)
>> >
>>
>> Snip
>>
>> After trying some things in mysql such as...
>>
>> Use mailscanner
>>         I got:
>> Didn't find any fields in table 'maillog'
>>
>> mysql> select * from maillog
>>     -> ;
>> ERROR 1016 (HY000): Can't open file: 'maillog.MYI' (errno: 145)
>>
>>
>>
>> So.....
>> Does this mean that my maillog table got messed up/deleted and I cannot
>> get my rows back?
>
> Messed up ISAM file(s), yes. Try running mysqlismchk on it/them. IIRC
> mysql will not touch it before you do.
> --
> -- Glenn
> email: glenn < dot > steen < at > gmail < dot > com
> work: glenn < dot > steen < at > ap1 < dot > se
> -- 

You'll probably need to use the -r or -o option with that check.

I usually run the checks as follows:

cd /var/lib/mysql/mailscanner
myisamchk maillog.MYI

if that returns an error other than the one saying a user is still using the 
db then

stop mysql
myisamchk -r maillog.MYI

restart mysql

You may have more problems with more databases and tables. If mysql doesn't 
start, try checking all tables in all databases.

use something like in each database directory

myisamchk *.MYI

then run myisamchk with the -r or -o option as above on each index that 
reports an error with mysql stopped.

Steve Campbell
campbell at cnpapers.com
Charleston Newspapers