Hi Jon, Going to test that and see if it correct the problem once for all. Most probably Friday night or Saturday night when no one is supposed to be working (unless me)
> -----Original Message----- > From: dbmail-dev-boun...@dbmail.org [mailto:dbmail-dev- > boun...@dbmail.org] On Behalf Of Jonathan Feally > Sent: domingo, 2 de Agosto de 2009 18:40 > To: DBMAIL Developers Mailinglist > Subject: Re: [Dbmail-dev] Errors after nightly dbmail-util > > Jorge Bastos wrote: > > Hi Jon, > > > > > >> Jorge Bastos wrote: > >> > >>> John & Paul, > >>> > >>> To recreate the complete cache, can i: > >>> > >>> --- > >>> Delete from dbmail_header; > >>> Delete from dbmail_headername; > >>> Delete from dbmail_headervalue; > >>> Delete from dbmail_envelope; > >>> > >>> Dbmail-util -by > >>> > >>> > >> Yes - delete from all 4 tables. Do take your daemons down while > doing > >> this to be from cache pollution and client pulling bogus data. I > >> don't see anything wrong with your db schema that we haven't > corrected. > >> > >> use dbmail-util -tuby twice to make sure all is well. > >> > > > > To continue this matter, > > > > I was checking the table structure, and, are you sure I can delete > > from dbmail_header? > > It has some connections by foreign keys, data won't be deleted from > > the other tables and consequently I'll lose data? > > The same goes for dbmail_envelope. > > > > Or should I do before this: > > SET FOREIGN_KEY_CHECKS=0; > > After: > > SET FOREIGN_KEY_CHECKS=1; ? > > > > Jorge, > > > > > > > > _______________________________________________ > > Dbmail-dev mailing list > > Dbmail-dev@dbmail.org > > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev > > > > > The foreign key constraints are based upon the physmessage_id being > there. So if a physmessage is deleted, then the envelope and header > cache for the message is deleted. Subsequently, any unused header names > or values are removed when the pointers to them are deleted. You do not > need turn off the key check. It would be faster though to run the > attached script to drop the tables and recreate them. This script > should clean out all the caching. You would then need to run dbmail- > util -by to fill in the cache tables. If you have a bunch of messages > that can be purged, the do a purge run before rebuilding the cache to > speed it up. > > -Jon > > -- > Scanned for viruses and dangerous content by MailScanner _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
