maillog.myi Cannot Insert row

Pete pete at EATATHOME.COM.AU
Tue Jul 20 00:09:10 IST 2004


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?

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



More information about the MailScanner mailing list