"Invalid Argument" with quarantine DB |
Post Reply 
|
| Author | |
BigDog 
Newbie 
Joined: 26 January 2005 Location: United States Status: Offline Points: 11 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: "Invalid Argument" with quarantine DBPosted: 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. |
|
 |
|
|
pcmatt
Senior Member 
Joined: 15 February 2005 Location: United States Status: Offline Points: 116 |
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
|
kspare
Senior Member
Joined: 26 January 2005 Location: Canada Status: Offline Points: 334 |
Post Options
Thanks(0)
Quote Reply
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! |
|
|
|
|
AJ
Guest Group 
|
Post Options
Thanks(0)
Quote Reply
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?
|
|
|
|
|
Marcus
Newbie
Joined: 25 July 2005 Location: United States Status: Offline Points: 21 |
Post Options
Thanks(0)
Quote Reply
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 |
|
|
|
|
AJ
Guest Group
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
Topic Options
Marcus wrote:|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0.086 seconds.