Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - "Invalid Argument" with quarantine DB
  FAQ FAQ  Forum Search   Register Register  Login Login

"Invalid Argument" with quarantine DB

 Post Reply Post Reply
Author
BigDog View Drop Down
Newbie
Newbie


Joined: 26 January 2005
Location: United States
Status: Offline
Points: 11
Post Options Post Options   Thanks (0) Thanks(0)   Quote BigDog Quote  Post ReplyReply Direct Link To This Post Topic: "Invalid Argument" with quarantine DB
    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.

Back to Top
pcmatt View Drop Down
Senior Member
Senior Member
Avatar

Joined: 15 February 2005
Location: United States
Status: Offline
Points: 116
Post Options Post Options   Thanks (0) Thanks(0)   Quote pcmatt Quote  Post ReplyReply Direct Link To This Post 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.



Edited by pcmatt
-Matt R
Back to Top
kspare View Drop Down
Senior Member
Senior Member


Joined: 26 January 2005
Location: Canada
Status: Offline
Points: 334
Post Options Post Options   Thanks (0) Thanks(0)   Quote kspare Quote  Post ReplyReply Direct Link To This Post 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!

Back to Top
AJ View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote AJ Quote  Post ReplyReply Direct Link To This Post 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?
Back to Top
Marcus View Drop Down
Newbie
Newbie


Joined: 25 July 2005
Location: United States
Status: Offline
Points: 21
Post Options Post Options   Thanks (0) Thanks(0)   Quote Marcus Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
AJ View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote AJ Quote  Post ReplyReply Direct Link To This Post 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.

 

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.203 seconds.