A NOTE has been added to this issue. ====================================================================== http://www.dbmail.org/mantis/view.php?id=421 ====================================================================== Reported By: alex Assigned To: ====================================================================== Project: DBMail Issue ID: 421 Category: Command-Line programs (dbmail-users, dbmail-util) Reproducibility: always Severity: minor Priority: normal Status: new target: ====================================================================== Date Submitted: 05-Oct-06 16:32 CEST Last Modified: 05-Oct-06 16:44 CEST ====================================================================== Summary: envelope check fail to fix problem after upgrade Description: dbmail-util does not fix missing envelope values after adding the table. This may or may not be an issue when starting from scratch -- have not tested.
dbmail-util -by <snip> Repairing DBMAIL for cached envelopes... Ok. Found [95] missing envelope values. <snip> dbmail-util -by <snip> Repairing DBMAIL for cached envelopes... Ok. Found [95] missing envelope values. The envelope table remains empty. ====================================================================== Relationships ID Summary ---------------------------------------------------------------------- related to 0000409 SQL script fails to create dbmail_envel... ====================================================================== ---------------------------------------------------------------------- alex - 05-Oct-06 16:44 ---------------------------------------------------------------------- Oct 6 04:30:06 test dbmail/maintenance[4151]: Error dbmail-message.c,dbmail_message_cache_envelope: insert envelope failed [INSERT INTO dbmail_envelope (physmessage_id, envelope) VALUES (116,'(\"Wed, 04 Oct 2006 19:12:59 +0300\" \"hasa\" ((\"try\" NIL \"try\" \"test.kisise\")) ((\"try\" NIL \"try\" \"test.kisise\")) ((\"try\" NIL \"try\" \"test.kisise\")) ((\"test\" NIL \"test\" \"test.kisise\")) NIL NIL NIL \"<[EMAIL PROTECTED]>\")')] Oct 6 04:30:06 test dbmail/maintenance[4151]: Error dbmysql.c,db_query: [Cannot add or update a child row: a foreign key constraint fails (`mail/dbmail_envelope`, CONSTRAINT `dbmail_envelope_ibfk_1` FOREIGN KEY (`physmessage_id`) REFERENCES `dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)] [INSERT INTO dbmail_envelope (physmessage_id, envelope) VALUES (117,'(\"Wed, 04 Oct 2006 19:12:59 +0300\" \"hasa\" ((\"try\" NIL \"try\" \"test.kisise\")) ((\"try\" NIL \"try\" \"test.kisise\")) ((\"try\" NIL \"try\" \"test.kisise\")) ((\"test\" NIL \"test\" \"test.kisise\")) NIL NIL NIL \"<[EMAIL PROTECTED]>\")')] Oct 6 04:30:06 test dbmail/maintenance[4151]: Error dbmail-message.c,dbmail_message_cache_envelope: insert envelope failed [INSERT INTO dbmail_envelope (physmessage_id, envelope) VALUES (117,'(\"Wed, 04 Oct 2006 19:12:59 +0300\" \"hasa\" ((\"try\" NIL \"try\" \"test.kisise\")) ((\"try\" NIL \"try\" \"test.kisise\")) ((\"try\" NIL \"try\" \"test.kisise\")) ((\"test\" NIL \"test\" \"test.kisise\")) NIL NIL NIL \"<[EMAIL PROTECTED]>\")')] There you go. Foreign keys after all. Issue History Date Modified Username Field Change ====================================================================== 05-Oct-06 16:32 alex New Issue 05-Oct-06 16:34 aaron Relationship added related to 0000409 05-Oct-06 16:44 alex Note Added: 0001464 ======================================================================
