Spam Filter ISP Forums : Database busy https://www.logsat.com/spamfilter/forums/ Tue, 09 Jun 2026 23:05:05 +0000 Wed, 26 Dec 2007 09:07:56 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 11.04 360 https://www.logsat.com/spamfilter/forums/RSS_post_feed.asp?TID=6267 <![CDATA[Spam Filter ISP Forums]]> https://www.logsat.com/spamfilter/forums/forum_images/web_wiz_forums.png https://www.logsat.com/spamfilter/forums/ <![CDATA[Database busy : With Msql, we run innoDB storage...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6267&PID=11386&title=database-busy#11386 Author: dcook
Subject: 6267
Posted: 26 December 2007 at 9:07am

With Msql, we run innoDB storage engine.  That helped us a bunch.  Just curious are you also running innoDB and still getting these issues?

]]> Wed, 26 Dec 2007 09:07:56 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6267&PID=11386&title=database-busy#11386 <![CDATA[Database busy : Pignet, Did anyone get some...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6267&PID=11370&title=database-busy#11370 Author: Desperado
Subject: 6267
Posted: 20 December 2007 at 11:40am

Pignet,
 
Did anyone get some SQL Stored Procedures to you for scheduling SQL to do the cleanup?
]]> Thu, 20 Dec 2007 11:40:36 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6267&PID=11370&title=database-busy#11370 <![CDATA[Database busy : Thank you for the suggestions....]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6267&PID=11369&title=database-busy#11369 Author: Pignet
Subject: 6267
Posted: 20 December 2007 at 12:57am

Thank you for the suggestions. I will implement the ideas and look forward to less errors.

 

 

]]> Thu, 20 Dec 2007 00:57:10 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6267&PID=11369&title=database-busy#11369 <![CDATA[Database busy : Jeremy, I also set the following:...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6267&PID=11368&title=database-busy#11368 Author: Desperado
Subject: 6267
Posted: 19 December 2007 at 4:38pm

Jeremy,
 
I also set the following: DeleteExpiredEmailInterval=0
 
This should prevent SpamFilter from doing the actual message removal (I believe) and lets my SQL stored procedure do it.  My cleanup procedure runs every 15 minutes and once in a while, one of my "steps" fails but it completes the next run.  I have a grand total of ZERO database busy errors over the last 30 days.


Edited by Desperado - 19 December 2007 at 4:40pm]]> Wed, 19 Dec 2007 16:38:53 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6267&PID=11368&title=database-busy#11368 <![CDATA[Database busy : Pignet - We have almost the...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6267&PID=11367&title=database-busy#11367 Author: jerbo128
Subject: 6267
Posted: 19 December 2007 at 4:30pm

Pignet -
We have almost the same setup - but receive about 750K emails a day.  Our quarantine runs about 5-7GB.  We keep them for 7 days too.
 
We had the same issues several months ago also.  At that time, Roberto had me try the following settings so prevent spamfilter from doing the cleanup:
interval in minutes to delete expired items in quarantine=0
days to store quarantined emails=30
I now clean our database using sql scripts that are set to run automatically every 5 mintues.
 
I have not had any issues with this problem since.
If you want a copy of the scripts email me.  jerbo128 - hotmail
 
Jeremy
 


Edited by jerbo128 - 19 December 2007 at 4:32pm]]> Wed, 19 Dec 2007 16:30:04 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6267&PID=11367&title=database-busy#11367 <![CDATA[Database busy : Pignet, 210K errors sounds...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6267&PID=11366&title=database-busy#11366 Author: Desperado
Subject: 6267
Posted: 19 December 2007 at 10:35am

Pignet,
 
210K errors sounds very excessive.  However, some of us run SQL "Jobs" to do the expire from the DB and set SpamFilter to not do that task and I have not seen a DB Busy error since.  BUT ... as I said, 210K errors really sounds like something else is going on.  Curious though, what is your "DeleteExpiredEmailInterval" set to in the ini file?
]]> Wed, 19 Dec 2007 10:35:08 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6267&PID=11366&title=database-busy#11366 <![CDATA[Database busy : I see this issue on 718. We...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6267&PID=11363&title=database-busy#11363 Author: Pignet
Subject: 6267
Posted: 19 December 2007 at 1:05am

I see this issue on 718.
 
We are using SQL 2005 Ent, on a Dual processor HP server, with 3.5gb ram.
 
Our volume is 400,000+ into quarantine
We have a 7 day rentention
Our current database is up to 10GB
Today we have over 210,000 Database is busy messages...
I have not research if they do get inserted later, I am concerned we are dropping them...
Is there a way to see the reason why that message is returned? Our SQL server is running 3 other small databases that work fine and the server has plenty of free memory and processor.
 
Thanks for the help...
 
 
]]> Wed, 19 Dec 2007 01:05:42 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6267&PID=11363&title=database-busy#11363 <![CDATA[Database busy : I had the same sort of problems...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6267&PID=11042&title=database-busy#11042 Author: DavidF
Subject: 6267
Posted: 18 October 2007 at 4:17pm

I had the same sort of problems with SF v.3.5.4.704 and MySQL 4.1. On a fairly regular basis I had to stop and restart MySQL. I have found with SF 3.5.4.718 the problem has gone away. The one thing that I did do in addition to installing the lastest version of SF was modify the ini file settings for PDF scanning so I can't say for certain what has caused the problem  to go away although the whole SF system seems to run a lot smoother with version 718 of SF.]]> Thu, 18 Oct 2007 16:17:13 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6267&PID=11042&title=database-busy#11042 <![CDATA[Database busy : The machine is Dell poweredge...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6267&PID=11040&title=database-busy#11040 Author: Stupid
Subject: 6267
Posted: 16 October 2007 at 6:28pm

The machine is Dell poweredge 1425 with 2GB memory. I am also running a Blackberry enterprise server and websense filtering on there. It usually has 700M memory left.


I typically have 20-30K items in tblquarantine.
]]> Tue, 16 Oct 2007 18:28:49 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6267&PID=11040&title=database-busy#11040 <![CDATA[Database busy : can you please give some specs...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6267&PID=11038&title=database-busy#11038 Author: atifghaffar
Subject: 6267
Posted: 16 October 2007 at 5:17pm

can you please give some specs of your mysql database.
hardware, software (OS, what else is running on this machine)
some stats on daily volume in tblquarantine,
etc


]]> Tue, 16 Oct 2007 17:17:52 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6267&PID=11038&title=database-busy#11038