"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: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5249
Printed Date: 26 December 2024 at 6:15pm
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
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.
|
Marcus wrote: