> > mysql> DELETE dbmail_mimeparts.* FROM dbmail_mimeparts LEFT JOIN > > dbmail_partlists ON (dbmail_mimeparts.id=dbmail_partlists.part_id) > WHERE > > dbmail_partlists.physmessage_id IS NULL; > > I'm pretty sure we don't use that kind of query. I wasn't even aware of > this trick.
It was something I used in 2.3.2. Thanks for your fix! This fixes this problem, and also something I reported about having uncached messages all the time when running "dbmail-util -by". Only one question, In every run, the partlists part, always has 0 unconnected partlists's. Is it normal? Example below. --- 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. Maintenance done. No errors found. Deleting messages with DELETE status... Ok. Messages deleted. Maintenance done. No errors found. Repairing DBMAIL message integrity... Repairing DBMAIL physmessage integrity... Ok. Found [12181] unconnected physmessages. Ok. Orphaned physmessages deleted. Repairing DBMAIL partlists integrity... Ok. Found [0] unconnected partlists. Repairing DBMAIL mimeparts integrity... Ok. Found [40492] unconnected mimeparts. Ok. Orphaned mimeparts deleted. Maintenance done. No errors found. _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
