On 16 Aug 2011, at 8:07 PM, Jan Agermose wrote: > Andrew?
Sorry busy with the day job, this fell off the wagon. > > From: [email protected] > [mailto:[email protected]] On Behalf Of Jan Agermose > Sent: 12. august 2011 16:45 > To: 'Baruwa users list' > Subject: Re: [Baruwa] baruwa2.db > > I deleted all entries in the temp database. > > a few questions about this temp DB > > 1) is it supposed to be used all the time or just when there is no direct > connection to the mysql database? Only when a clean insert cannot be made to the mysql db > > 2) is it supposed to delete entries in the temp db when logging to the msyql > database later? Yes on reconciling the data the old entires are deleted. > > to me it seams that its logging to the tmp db all the times no mater that its > perfectly possible to connect to the mysql database. Also entries are not > deleted from the temp db. That means your mysql db is not returning the correct return values to indicate an update happened. > > Does this explain the problems im seeing where no mails show up in the > webadmin until restarting MailScanner. Then 1000s of inserts are done of even > very old emails. To me it seams when starting up MailScanner its running the > temp database and flushing to the mail mysql database. When finished it > starts only inserting to the temp again (or its simply taking to long to > finish the flush so Im not seeing the new). It is possible that a race condition happens in this case which makes the issue worse. This requires further investigation on your actual system, since i am not able to replicate it on my side. > > more over, when starting up, EVERY mailscanner worker actually seams to do > this so every worker runs the temp databse flushing every old email in the > temp databsae to the master mysql. Thats not correct if you look at the code, the backup db handling code only gets run by the worker that gets hold of the tcp socket all other workers cannot access the backup db handling code. > . -- Baruwa - www.baruwa.org _______________________________________________ Baruwa mailing list [email protected] http://lists.baruwa.org/mailman/listinfo/baruwa Keep Baruwa FREE - http://pledgie.com/campaigns/12056
