Print Page | Close Window

"Invalid Argument" with quarantine DB

Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: http://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5249
Printed Date: 20 October 2017 at 3:17am


Topic: "Invalid Argument" with quarantine DB
Posted By: BigDog
Subject: "Invalid Argument" with quarantine DB
Date Posted: 27 June 2005 at 1:20pm

Using Access quarantine DB which has grown to about 2 Gb;  started gettign this msg last April and I started over with a new fresh empty DB in May

BUT, In any case, it's now occuring again everytime when SpamFilter attempts to quarantine a message, it fails.  The following is a SPF fail of an incoming msg:

(2876) Resolving 216.59.195.132 - cust-216-59-195-132.t-speed.net

06/26/05 00:30:24:485 -- (2876) found SPF record: v=spf1 a mx a:gw.gocolumbiamo.com a:news.gocolumbiamo.com a:dns.gocolumbiamo.com a:dns2.gocolumbiamo.com -all

06/26/05 00:30:24:485 -- (2876) SPF query result:

06/26/05 00:30:24:485 -- (2876) - SPF analysis for gocolumbiamo.com done: - fail

06/26/05 00:30:24:485 -- (2876) failed SPF test (fail) - Disconnecting 216.59.195.132

06/26/05 00:30:24:485 -- (2876) 216.59.195.132 - Mail from: webmaster@gocolumbiamo.com To: andrew@gocolumbiamo.com will be rejected

06/26/05 00:30:25:188 -- (2876) Error occurred during RECEIVEMESSAGE when accessing the quarantine database: Invalid argument ( 1 2 3 4 5 6 7 8 9 11 12 13 15 16 17 18 19 29 30 31 32 33 54 55 56 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91)

06/26/05 00:30:25:235 -- (2876) EMail from webmaster@gocolumbiamo.com to andrew@gocolumbiamo.com was received and quarantined. Size: 56 KB, 57344 bytes

06/26/05 00:30:25:235 -- (2876) Disconnect

 

I am not a Access db expert, but is there something I may need to do to fix my DB as I assume that there is something wrong in it, I would rather not dump it and restart as I did a couple months ago.




Replies:
Posted By: pcmatt
Date Posted: 27 June 2005 at 8:25pm

Unless it has changed in 2003 MS Access is limited to 2 GB size. You have maxed out your database it sounds like.

You will need to reduce the number of days before the quarentine items are deleted as set in SpamFilter or get a different database.

If you can find a version of MySQL that will allow bigger databases you can use that if you can't get a copy of MS SQL Server.



-------------
-Matt R


Posted By: kspare
Date Posted: 28 June 2005 at 12:58am

Try setting spamfilter to delete anything older than 15 days too...

I'm sitting with 8000 items in my database and i'm using 200 megs of space....so if you have 80,000 items of spam, either you need to purge anything older than 15 days, or you need to get yourself a copy of mysql or even better open up your wallet and do it right and get ms-sql!



Posted By: Guests
Date Posted: 15 December 2005 at 10:14am
I had the same problem,  I lowered the number of days but the DB is stuck at 2,095,108 KB.  Is there a way to purge it?


Posted By: Marcus
Date Posted: 15 December 2005 at 4:27pm

MS Access has a build in tool for defrag/compact db.

Tools, Database utilities, compact and repair database. (make backup copy first-just in case)

I use it regularly on my spamfilter dbs with no problems, not sure if it will help with one that is already maxed out.

Marcus



Posted By: Guests
Date Posted: 17 December 2005 at 8:14pm
Originally posted by Marcus Marcus wrote:

MS Access has a build in tool for defrag/compact db.

Tools, Database utilities, compact and repair database. (make backup copy first-just in case)

I use it regularly on my spamfilter dbs with no problems, not sure if it will help with one that is already maxed out.

Marcus

Thanks I ran that and it claimed 300 MB but that quickly filled up again.  I'm going to try to set the retain days to 6 and see what happens.

 




Print Page | Close Window