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 crashed and last repair failed warning : Size of datafile is: 4294967256 Should be: 4112108256 warning : Datafile is almost full, 4294967256 of 4294967294 used error : Found 106921 keys of 80477 error : Corrupt It has been fixed now, but does this point to some issue with max row count? On 11/10/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > 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 limit. As > for the exact syntax, I don't remember. > > Check: > > http://dev.mysql.com/doc/refman/5.0/en/full-table.html > > ALTER TABLE tbl_name MAX_ROWS=1000000000 AVG_ROW_LENGTH=nnn; > > Check the page to see what value to put for nnn. > > Xing > > Simon wrote: > > 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=<[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>, > > orig_to=<[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>, > > relay=dbmail, delay=1, status=deferred (temporary failure) > > Nov 10 16:55:52 mx1 dbmail/smtp[2722]: > > db.c,db_insert_message_block_physmessage: dbquery failed > > Nov 10 16:55:52 mx1 dbmail/smtp[2722]: db.c,db_insert_message_block: > > error inserting messageblks for physmessage [407191] > > Nov 10 16:55:52 mx1 dbmail/smtp[2722]: store_message_temp(): error > > inserting msgblock [header] > > Nov 10 16:55:52 mx1 dbmail/smtp[2722]: pipe.c, insert_messages: failed > > to store temporary message. > > Nov 10 16:55:52 mx1 dbmail/smtp[2722]: dbmysql.c,db_query: executing > > query [ROLLBACK] > > Nov 10 16:55:52 mx1 dbmail/smtp[2722]: main(): insert_messages failed > > Nov 10 16:55:52 mx1 dbmail/smtp[2722]: main(): freeing dsnuser list > > Nov 10 16:55:52 mx1 dbmail/smtp[2722]: dsn.c, dsnuser_free: dsnuser > freed > > Nov 10 16:55:52 mx1 dbmail/smtp[2722]: main(): freeing all other lists > > Nov 10 16:55:52 mx1 dbmail/smtp[2722]: main(): freeing memory blocks > > Nov 10 16:55:52 mx1 dbmail/smtp[2722]: main(): they're all free. we're > done. > > Nov 10 16:55:52 mx1 dbmail/smtp[2722]: main(): exit code is [75]. > > > > Anybody who is onhand to help, please. > > > > Simon > > > > > > ------------------------------------------------------------------------ > > > > _______________________________________________ > > Dbmail mailing list > > Dbmail@dbmail.org > > https://mailman.fastxs.nl/mailman/listinfo/dbmail > _______________________________________________ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail >
