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
