I don't use pgsql or whatever can understand \d. I'm using MySQL...
anyhow I'm on the tracks of your suggestion so now I'll try to
understand what's the foreign key definition that it's currently
defined.
Il giorno 14/mag/07, alle ore 14:11, Aaron Stone ha scritto:
Please log into your database with psql on the command line, and post
back the output of '\d dbmail_datefield'. I suspect that you might be
missing the "ON UPDATE CASCADE ON DELETE CASCADE" part of the foreign
key definition.
Aaron
On Wed, 2007-05-09 at 14:22 +0200, Andrea Brancatelli wrote:
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
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
Andrea Brancatelli
[EMAIL PROTECTED]
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
