Hello, Always when dbmail-util has deleted messages with DELETE status or I have run 'dbmail-users -e <username>' command, I get several unconnected physmessages and -mimeparts on next run of 'dbmail-util -ay'. It seems that DELETE query hits only to the dbmail_messages table but leaves other tables unaffected. dbmail-util also prints wrongly the time spent when repairing unconnected physmessages.
I have clean install DBMail version 3.0.0-rc3 and mysqld Ver 5.5.15-55-log for Linux on x86_64 (Percona Server (GPL), Release 21.0) Opening connection to database... Opening connection to authentication... Ok. Connected. Repairing DBMAIL message integrity... Repairing DBMAIL physmessage integrity... Ok. Found [80] unconnected physmessages. Ok. Orphaned physmessages deleted. --- Repairing unconnected physmessages took -1.40334e+14 seconds Repairing DBMAIL partlists integrity... Ok. Found [0] unconnected partlists. --- Repairing unconnected partlists took 0 seconds Repairing DBMAIL mimeparts integrity... Ok. Found [184] unconnected mimeparts. Ok. Orphaned mimeparts deleted. --- Repairing unconnected mimeparts took 8 seconds --- Repairing block integrity took 8 seconds Deleting messages with DELETE status... Ok. Messages deleted. Repairing DBMAIL for rfcsize field... Ok. Found [0] missing rfcsize values. --- checking rfcsize field took 0 seconds Repairing DBMAIL for cached envelopes... Ok. Found [0] missing envelope values. --- checking envelope cache took 1 seconds Repairing DBMAIL for cached header values... Ok. Found [0] un-cached physmessages. --- checking cached headervalues took 3 seconds Setting DELETE status for deleted messages... Ok. Messages set for deletion. Re-calculating used quota for all users... Ok. Used quota updated for all users. Removing aliases with nonexistent delivery userid's... Ok. Found [0] dangling aliases. Removing IP entries older than [2011-10-13 03:28:17]... Ok. IP entries older than [2011-10-13 03:28:17] removed. Vacuuming and optimizing database... Ok. Database cleaned up. regards, petteri -- View this message in context: http://old.nabble.com/unconnected-physmessages-and-mimeparts-after-DELETE-%283.0.0-rc3%29-tp32673910p32673910.html Sent from the dbmail users mailing list archive at Nabble.com. _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
