Some users have been reporting errors with their mail since a while, today I sneeked a look and found this:
May 9 14:08:31 carota dbmail/smtp[363]: Error [Cannot delete or update a parent row: a foreign key constraint fails (`dbmail`.`dbmail_datefield`, CONSTRAINT `dbmail_datefield_ibfk_1` FOREIGN KEY (`physmessage_id`) REFERENCES `dbmail_physmessage` (`id`))] [DELETE FROM dbmail_physmessage WHERE id = 147004] May 9 14:08:31 carota dbmail/smtp[363]: Error failed to delete temporary message [243478] In the log.. I run dbmail-util -a -y (that is running every night anyhow) and it gave me this: Opening connection to database... Opening connection to authentication... Ok. Connected. Repairing DBMAIL messageblocks integrity... Ok. Found [0] unconnected messageblks. Checking DBMAIL message integrity... Ok. Found [0] unconnected messages. Checking DBMAIL mailbox integrity... Ok. Found [0] unconnected mailboxes. Repairing DBMAIL for NULL messages... Ok. Found [0] NULL messages. Checking DBMAIL for NULL physmessages... Ok. Found [0] physmessages without messageblocks. Deleting messages with DELETE status... Error [Cannot delete or update a parent row: a foreign key constraint fails (`dbmail`.`dbmail_datefield`, CONSTRAINT `dbmail_datefield_ibfk_1` FOREIGN KEY (`physmessage_id`) REFERENCES `dbmail_physmessage` (`id`))] [DELETE FROM dbmail_physmessage WHERE id = 2774] Error error deleting message Failed. An error occured. Please check log. Repairing DBMAIL for rfcsize field... Ok. Found [0] missing rfcsize values. Repairing DBMAIL for incorrect is_header flags... Ok. Found [0] incorrect is_header flags. Repairing DBMAIL for cached envelopes... Ok. Found [0] missing envelope values. Repairing DBMAIL for cached header values... Ok. Found [0] un-cached physmessages. Setting DELETE status for deleted messages... Ok. [236] messages set for deletion. Re-calculating used quota for all users... Ok. Used quota updated for all users. Vacuuming and optimizing database... Ok. Database cleaned up. Maintenance done. No errors found. What's happening? How can I fix this? Thanks ;)
_______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
