what can I provide to you to figure out what the problem is? Its happening again now on the same server as the other times. The sqlite DB has a count of 100.000 emails. The log shows it logging to sql
[root@inbound ~]# tail -f /var/log/maillog|grep "Baruwa" Aug 16 20:47:58 inbound MailScanner[32578]: Starting Baruwa SQL logger Aug 16 20:47:58 inbound MailScanner[28138]: Logging message p7GIcEiW031892 to Baruwa SQL Aug 16 20:48:00 inbound MailScanner[32227]: Logging message p7GIl9fG001572 to Baruwa SQL Aug 16 20:48:03 inbound MailScanner[32578]: Logging message p7GIe7PQ032518 to Baruwa SQL Aug 16 20:48:03 inbound MailScanner[970]: Logging message p7GIeiGb032753 to Baruwa SQL Aug 16 20:48:06 inbound MailScanner[1703]: Logging message p7GIguuW000682 to Baruwa SQL Aug 16 20:48:07 inbound MailScanner[28138]: Logging message p7GIbh0x031786 to Baruwa SQL Aug 16 20:48:09 inbound MailScanner[5535]: Logging message p7GIXoUp031113 to Baruwa SQL Aug 16 20:48:11 inbound MailScanner[31852]: Logging message p7GIb6uT031686 to Baruwa SQL Aug 16 20:48:14 inbound MailScanner[31852]: Logging message p7GIb6ul031686 to Baruwa SQL Aug 16 20:48:15 inbound MailScanner[32519]: Starting Baruwa SQL logger Aug 16 20:48:16 inbound MailScanner[28138]: Logging message p7GIcEiR031892 to Baruwa SQL Aug 16 20:48:19 inbound MailScanner[28138]: Logging message p7GIZk8I031387 to Baruwa SQL Aug 16 20:48:20 inbound MailScanner[32519]: Logging message p7GIVLhR030640 to Baruwa SQL Aug 16 20:48:21 inbound MailScanner[32227]: Starting Baruwa SQL logger Aug 16 20:48:22 inbound MailScanner[1336]: Starting Baruwa SQL logger Aug 16 20:48:23 inbound MailScanner[31852]: Logging message p7GIadpe031529 to Baruwa SQL Aug 16 20:48:24 inbound MailScanner[32578]: Starting Baruwa SQL logger Aug 16 20:48:25 inbound MailScanner[970]: Starting Baruwa SQL logger Aug 16 20:48:26 inbound MailScanner[32227]: Logging message p7GIguuY000682 to Baruwa SQL Aug 16 20:48:27 inbound MailScanner[1703]: Starting Baruwa SQL logger Aug 16 20:48:28 inbound MailScanner[28138]: Logging message p7GIY7s1031176 to Baruwa SQL Aug 16 20:48:28 inbound MailScanner[317]: Starting Baruwa SQL logger it looks strange that its starting the logger so often or? -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Andrew Colin Kissa Sent: 16. august 2011 20:36 To: Baruwa users list Subject: Re: [Baruwa] baruwa2.db 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 _______________________________________________ Baruwa mailing list [email protected] http://lists.baruwa.org/mailman/listinfo/baruwa Keep Baruwa FREE - http://pledgie.com/campaigns/12056
