I just manually run
alter table dbmail_datefield
add FOREIGN KEY (physmessage_id)
REFERENCES dbmail_physmessage(id)
ON UPDATE CASCADE ON DELETE CASCADE
maybe i fixed it?
how can I retrieve foreign key description from innodb database
within mysql, just to check if everything is correct....
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
