Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: DBMail: dev
[DBMail 0000934]: unconnected physmessages and mimeparts after DELETE
 

Index | Next | Previous | View Flat


bugtrack at dbmail

Oct 27, 2011, 6:26 AM


Views: 220
Permalink
[DBMail 0000934]: unconnected physmessages and mimeparts after DELETE [In reply to]

A NOTE has been added to this issue.
======================================================================
http://dbmail.org/mantis/view.php?id=934
======================================================================
Reported By: petteri
Assigned To:
======================================================================
Project: DBMail
Issue ID: 934
Category: Command-Line programs (dbmail-users, dbmail-util)
Reproducibility: always
Severity: minor
Priority: normal
Status: new
target:
======================================================================
Date Submitted: 27-Oct-11 15:11 CEST
Last Modified: 27-Oct-11 15:26 CEST
======================================================================
Summary: unconnected physmessages and mimeparts after DELETE
Description:
When dbmail-util has deleted messages with DELETE status or I have ran
'dbmail-users -e <username>' command, I get several unconnected
physmessages and -mimeparts on next run of 'dbmail-util -ay'. It seems that
DELETE query executed by dbmail-util or dbmail-users hits only to the
dbmail_messages table but leaves other tables unaffected. On the next run
of dbmail-util problem is fixed (message remainings from other tables are
deleted) but gives ugly impression that there is something wrong.

dbmail-util also prints wrongly the time spent when repairing unconnected
physmessages.
======================================================================

----------------------------------------------------------------------
(0003307) froeske (reporter) - 27-Oct-11 15:16
http://dbmail.org/mantis/view.php?id=934#c3307
----------------------------------------------------------------------
do you use MyISAM Tables for dbmail?

----------------------------------------------------------------------
(0003308) petteri (reporter) - 27-Oct-11 15:26
http://dbmail.org/mantis/view.php?id=934#c3308
----------------------------------------------------------------------
ENGINE=InnoDB
mysqld Ver 5.5.16-55-log for Linux on x86_64 (Percona Server (GPL),
Release 22.0)

Issue History
Date Modified Username Field Change
======================================================================
27-Oct-11 15:11 petteri New Issue
27-Oct-11 15:12 petteri Issue Monitored: petteri
27-Oct-11 15:16 froeske Note Added: 0003307
27-Oct-11 15:26 petteri Note Added: 0003308
======================================================================

_______________________________________________
Dbmail-dev mailing list
Dbmail-dev [at] dbmail
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev

Subject User Time
[DBMail 0000934]: unconnected physmessages and mimeparts after DELETE bugtrack at dbmail Oct 27, 2011, 6:11 AM
    [DBMail 0000934]: unconnected physmessages and mimeparts after DELETE bugtrack at dbmail Oct 27, 2011, 6:16 AM
    [DBMail 0000934]: unconnected physmessages and mimeparts after DELETE bugtrack at dbmail Oct 27, 2011, 6:26 AM
    [DBMail 0000934]: unconnected physmessages and mimeparts after DELETE bugtrack at dbmail Oct 27, 2011, 6:33 AM

  Index | Next | Previous | View Flat
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.