[Dbmail] mysql_real_query failed: Can't open file: 'dbmail_messageblks.MYI' (errno: 144)

2005-11-10 Thread Simon
Now im getting these errors: Nov 10 16:55:52 mx1 dbmail/smtp[2721]: main(): exit code is [75]. Nov 10 16:55:52 mx1 dbmail/smtp[2722]: dbmysql.c,db_query: mysql_real_query failed: Can't open file: 'dbmail_messageblks.MYI' (errno: 144) Nov 10 16:55:52 mx1 postfix/pipe[2719]: A91C82620177: to=

Re: [Dbmail] mysql_real_query failed: Can't open file: 'dbmail_messageblks.MYI' (errno: 144)

2005-11-10 Thread [EMAIL PROTECTED]
1) Disk full. 2) More likely. You have reached the max row count limit of the table. This is a well known problem that can be easily fixed by rebuldind the mysql table with ALTER and changing the avg row size I believe. Do a show tables in phpmyadmin and you see if you have reached this

Re: [Dbmail] mysql_real_query failed: Can't open file: 'dbmail_messageblks.MYI' (errno: 144)

2005-11-10 Thread Simon
I had a f*ked dbmail_messageblks.MYI file, so did a repair on that table and things have come right. The dbmail_messageblks.MYD is 3.9GB, checking the number of records in the dbmail_messageblks table, there are 107107. Here is a error report after restarting mysql: warning : Table is marked as