On 10-04-14 11:19, Gennadiy Poryev wrote: > Hi, > > I'm running dbmail 3.0.2 in pop3-only setup (it was upgraded from 2.x). > Today I accidentally forgot to empty user's mailbox before deleting the > user.
That should not make a difference, unless you didn't fix the foreign keys while upgrading to dbmail-3.0.2 :-( > Now dbmail-util -ayv returns this http://bpaste.net/show/200156/ > Repeated runs shows the same. > How do I fix those before upgrading to current stable? missing rfcsize means physmessage.rfcsize == 0 missing envelope values means some physmessage rows don't have a corresponding row in the envelope table. un-cached physmessages means the same for the header table. So, from the output of dbmail-util, build a list of all physmessage.id values involved, and delete them from the database. Of course, the Error output is bogus. If the messageblks table doesn't exists, that should *not* be a problem. I can, and will fix that for 3.1 and master, but *not* for 3.0. -- ________________________________________________________________ Paul J Stevens pjstevns @ gmail, twitter, github, linkedin www.nfg.nl/[email protected]/+31.85.877.99.97 _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
