maillog.myi Cannot Insert row

[Ugo Bellavance]

Pete wrote:
> Today i have started seeing
> Cannot insert row: Can't open file: 'maillog.MYI'. (errno: 144)
> in my log file a lot. The Maillog.myd file is 130mb, so i would love to
> be 'reset' this. Can i just delete these files and restart?

no, you'd lose the table's structure.

See MailWatch's archives for a script to clean MailWatch's DB.

>
> I have restart mysql and mailscanner but non seem to rid m of this
> error. File permissions havent changed either.
> -su-2.05b# ls -lah /var/db/mysql/mailscanner/
> total 138M
> drwx------    2 mysql    mysql         512 Jul 20 08:58 .
> drwx------    5 mysql    mysql         512 Jul 20 09:08 ..
> -rw-rw----    1 mysql    mysql           0 Mar 30 09:03 inq.MYD
> -rw-rw----    1 mysql    mysql        1.0k Mar 30 09:03 inq.MYI
> -rw-rw----    1 mysql    mysql        8.7k Mar 30 09:03 inq.frm
> -rw-rw----    1 mysql    mysql        130M Jul 20 08:50 maillog.MYD
> -rw-rw----    1 mysql    mysql        6.5M Jul 20 08:50 maillog.MYI
> -rw-rw----    1 mysql    mysql        9.2k Mar 30 09:03 maillog.frm
> -rw-rw----    1 mysql    mysql           0 Mar 30 09:03 outq.MYD
> -rw-rw----    1 mysql    mysql        1.0k Mar 30 09:03 outq.MYI
> -rw-rw----    1 mysql    mysql        8.7k Mar 30 09:03 outq.frm
> -rw-rw----    1 mysql    mysql           0 Mar 30 09:03 relay.MYD
> -rw-rw----    1 mysql    mysql        1.0k Mar 30 09:03 relay.MYI
> -rw-rw----    1 mysql    mysql        8.5k Mar 30 09:03 relay.frm
> -rw-rw----    1 mysql    mysql        100k Apr  8 11:49 sa_rules.MYD
> -rw-rw----    1 mysql    mysql         31k May  3 11:45 sa_rules.MYI
> -rw-rw----    1 mysql    mysql        8.4k Mar 30 09:03 sa_rules.frm
> -rw-rw----    1 mysql    mysql           0 Mar 30 09:03 user_filters.MYD
> -rw-rw----    1 mysql    mysql        1.0k Mar 30 09:03 user_filters.MYI
> -rw-rw----    1 mysql    mysql        8.5k Mar 30 09:03 user_filters.frm
> -rw-rw----    1 mysql    mysql          64 Mar 30 09:14 users.MYD
> -rw-rw----    1 mysql    mysql        2.0k Mar 30 10:39 users.MYI
> -rw-rw----    1 mysql    mysql        8.5k Mar 30 09:03 users.frm
>
> -------------------------- MailScanner list ----------------------
> To leave, send    leave mailscanner    to jiscmail at jiscmail.ac.uk
> Before posting, please see the Most Asked Questions at
> http://www.mailscanner.biz/maq/     and the archives at
> http://www.jiscmail.ac.uk/lists/mailscanner.html
>

-------------------------- MailScanner list ----------------------
To leave, send    leave mailscanner    to jiscmail at jiscmail.ac.uk
Before posting, please see the Most Asked Questions at
http://www.mailscanner.biz/maq/     and the archives at
http://www.jiscmail.ac.uk/lists/mailscanner.html