Error occurred during RECEIVEMESSAGE when |
Post Reply 
|
| Author | |
JeffHildebrand 
Newbie 
Joined: 26 January 2005 Location: United States Status: Offline Points: 15 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Error occurred during RECEIVEMESSAGE whenPosted: 26 January 2005 at 8:50pm |
|
We started receiving this error message a couple of days ago for each incomming email that was to be quaranteened. This basicly ended up with none of the (to be quaranteened) email coming through and of course not being quaranteened either. 01/24/05 19:14:36:578 -- (8164) Error occurred during RECEIVEMESSAGE when accessing the quarantine database: Operation must use an updateable query ( 1 2 3 4 5 6 7 8 9 11 12 13 15 16 17 18 19 29 31 32 33 54 55 56 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91) We were also receiving a similar error on ResolveSpam.asp along the lines of: UPDATE tblQuarantine SET Expire=1 WHERE QuarID=434963
I tried installing the latest version of v2.1.2.402, but after the install that error was stilling occuring. Rebooting the server did seem to clear up what ever conflict that was occuring, atleast for the time being. We are running under windows server 2003 with an access database on the same server. No permissions where changed before or after the reboot, but were verified as correct. My best guess is a web session might have improperly locked the database. Just a thought for a feature request, add an option of specifing an email alert for unusual errors? With perhaps a few notification options for example: Thanks,
Edited by JeffHildebrand |
|
 |
|
|
Eric
Guest Group 
|
Post Options
Thanks(0)
Quote Reply
Posted: 23 February 2005 at 12:17pm |
|
yes, it is true, on dual machines, version 402 -> 406 all don`t work, i went back to an old version in a second.(really scary bug)
-eric- |
|
|
|
|
Eric
Guest Group
|
Post Options
Thanks(0)
Quote Reply
Posted: 23 February 2005 at 12:19pm |
|
on single cpu machines, it runs perfect, and of course the log :
02/23/05 18:12:07:515 -- (1420) Exception occurred during RECEIVEMESSAGE: ( 1 2 3 4 5 6 7 8 9 11 12 13 15 16 17 18 19 111) Access violation at address 0055FDEA in module 'SpamFilter.exe'. Read of address 00000000 |
|
|
|
|
Eric
Guest Group
|
Post Options
Thanks(0)
Quote Reply
Posted: 23 February 2005 at 1:08pm |
|
this behaviour does not occurs on version [licensed] 1.2.0.212 on the same machine(s) installed and even older versions. for logsat support you can contact me at beheer[at]aquasense.nl |
|
|
|
|
Desperado
Senior Member 
Joined: 27 January 2005 Location: United States Status: Offline Points: 1143 |
Post Options
Thanks(0)
Quote Reply
Posted: 23 February 2005 at 1:47pm |
|
Eric, I am trying to follow your thread. I searched all my servers logs for the last week and do not see ANY errors like the one you describe. What version are you running? I am on build 406. And What Database? Regards, Dan S. |
|
|
The Desperado
Dan Seligmann. Work: http://www.mags.net Personal: http://www.desperado.com |
|
|
|
|
JeffHildebrand
Newbie
Joined: 26 January 2005 Location: United States Status: Offline Points: 15 |
Post Options
Thanks(0)
Quote Reply
Posted: 23 February 2005 at 2:51pm |
|
Eric's messages should probably be split into a seperate thread. The error I was receiving was "(8164) Error occurred during RECEIVEMESSAGE when accessing the quarantine database: Operation must use an updateable query" his error was "(1420) Exception occurred during RECEIVEMESSAGE:... Access violation at address 0055FDEA in module 'SpamFilter.exe'. Read of address 00000000"
The biggest problem with the 8164 error is that I think it is basicly black holing the email flagged as spam since they can not be saved to the database, and doubt if an error message is returned to the delivering server? Jeff |
|
|
|
|
Eric
Guest Group
|
Post Options
Thanks(0)
Quote Reply
Posted: 23 February 2005 at 4:25pm |
|
i used the default access database to start with, with version 402, later 406. spamfilter runs on w2k machines, dell 2650 default, w2k sp4 all hotfixes. with the database not used at all, it still happens. the debug window shows that is between "rcpto to:" en the "data dot" <cr><cr> with all features disabled, and even a default install it happens. now one for the faint of heart : other servers, like a dell 1650 or a compaq, don`t have it ... now what ? i suspect an apic/hal problem my servers handle up to 250.000 emails a day flawlessly with the old 212 version. latest news : i have one dell 2650 with 1 cpu instead of 2, and ... the problem does not happen/occur .. ;-( ???? |
|
|
|
|
Eric
Newbie
Joined: 23 February 2005 Location: Netherlands Status: Offline Points: 7 |
Post Options
Thanks(0)
Quote Reply
Posted: 23 February 2005 at 4:49pm |
|
i didn`t get paid to post this however, on all amd based systems, either single or dual (hp dl5xx) spamfilter runs rocksolid ...
maybe spamfilter.exe was compiled with some new or even was not compiled so, with the weird new intel hyper-dual-puke features ? the problems on all the dells are so vague that even i don`t know why this happens .... [i finally registered, yes i`am the old-forum eric ;)] |
|
|
|
|
Desperado
Senior Member
Joined: 27 January 2005 Location: United States Status: Offline Points: 1143 |
Post Options
Thanks(0)
Quote Reply
Posted: 23 February 2005 at 5:18pm |
|
Hmmm ... We have ONLY Dell Servers and run on a Quad PIII and a QUAD Xeon w/o any issues. I also have a test bed which is a single PIV. Dan S. |
|
|
The Desperado
Dan Seligmann. Work: http://www.mags.net Personal: http://www.desperado.com |
|
|
|
|
LogSat
Admin Group 
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
Posted: 23 February 2005 at 5:23pm |
|
There are two isseus going on in this thread. One does not appear to be
SpamFilter-related (Operation must use an updateable query), the other
(Access Violations) instead does.
For the 1st, "Operation must use an updateable query" is an error generated by the Microsoft's Jet MDAC components. Jeff is receiving it from ASP pages as well (which completely SpamFilter as having a problem). Most likely this is caused by a problem within the Access database. Please note that even though we include MS Access support, this is really not a good/stable platform to be using, and we do ont recommend using it on sites that process a lot of email traffic. The best suggestion is to try with a new, empty database and see if the problem goes away. Record locking may be an issue, and if so restarting SpamFilter/web server may also help. When the error "Error occurred during RECEIVEMESSAGE when accessing the quarantine database" occurrs, SpamFilter is in the process of adding the email to the database, so it knows that at that point the email is spam. Even with this error, SpamFilter should be able to exit cleanly and provide the sender's server the usual 55x error code that informs them the mail is spam. The second issue, the Access Violation errors, are a different story. Eric, can you please let us know what version of SpamFilter is causing them? |
|
|
|
|
Eric
Newbie
Joined: 23 February 2005 Location: Netherlands Status: Offline Points: 7 |
Post Options
Thanks(0)
Quote Reply
Posted: 23 February 2005 at 5:47pm |
|
version (latest registered) 402 and 406.
the servers were running more then a year rock solid with 1.2.0.212, and yesterday i upgraded the following way : update geoip.dat, spamfilter.exe spamfiltersvc.exe and showgui. start the spamfilter.exe, unregister service / register service. save settings. this gave the error. i cleaned up everything, reinstalling spamfilter default, and falling back on my mx2&3. still i doesn`t want to do the transfer of valid email, al other things, like spf etc function like it should. however legitimate email which is valid is not transferred to the destination server. part of log : 02/23/05 18:12:11:968 -- (1420) Resolving 212.115.192.151 - mail1.zeelandnet.nl 02/23/05 18:12:12:046 -- (1420) - SPF analysis for zeelandnet.nl done: - none 02/23/05 18:12:12:046 -- (1420) Mail from: sjbrouwer@zeelandnet.nl 02/23/05 18:12:18:468 -- (1420) - MAPS search done... 02/23/05 18:12:18:468 -- (1420) RCPT TO: rudy.dingemanse@grontmij.nl accepted 02/23/05 18:12:18:781 -- (680) Connection from: 207.244.37.243 - Originating country : United States 02/23/05 18:12:19:421 -- (1420) Exception occurred during RECEIVEMESSAGE: ( 1 2 3 4 5 6 7 8 9 11 12 13 15 16 17 18 19 111) Access violation at address 0055FDEA in module 'SpamFilter.exe'. Read of address 00000000 02/23/05 18:12:19:453 -- (1420) Disconnect it`s not my ini or a bad copy of the executebles, i used the default ini, after a default setup, and on several other servers there is no problem.(at-all rocksolid) as soon as i can tell more i found out so far, i will post it. |
|
|
|
|
Eric
Newbie
Joined: 23 February 2005 Location: Netherlands Status: Offline Points: 7 |
Post Options
Thanks(0)
Quote Reply
Posted: 23 February 2005 at 5:49pm |
|
sorry, and updated the psapi of course ...
|
|
|
|
|
LogSat
Admin Group
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
Posted: 23 February 2005 at 10:36pm |
|
Eric,
Are you receiving the Access Violation on every single email, or sporadically. Without knowing which exactly which build you're using we can 't pinpont the memory location address in the error - they're different in each build. At first sight it would seem that the problem occurs while checking either the whitelist or the blacklist keyword files. Can you try disablin that filter to see if it helps? |
|
|
|
|
Eric
Newbie
Joined: 23 February 2005 Location: Netherlands Status: Offline Points: 7 |
Post Options
Thanks(0)
Quote Reply
Posted: 24 February 2005 at 3:58am |
|
the error occurs on every single email which should be transferred to the destination server.
the error doe not occur on an block, quarantaine action or spf / baysian hit.(block action) as soon as the email is considered valid, and the transfer of data sequence starts(after rcpt to:), the error occurs. occurs on version : 2.1.2.402 and 2.1.2.406, where version 1.2.0.212 was running fine for a year with a througput of 100.000+ emails a day. i now have an testserver, it is a dual pentium pro with 512mb ram and 2 scsi drives on an aic-87xx controller, where i can debug, its happening on this testserver also.(default intel oem mainboard) the server is completely new installed, with a default setup of spamfilter 2.1.2.406, and w2k sp4. the access violation looks like a null pointer from logsat exe, on this testserver version 1.2.0.212 also runs fine, without any problem. |
|
|
|
|
LogSat
Admin Group
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
Posted: 24 February 2005 at 3:48pm |
|
Eric,
I'm not sure I follow. The error you posted: Exception occurred during RECEIVEMESSAGE: ( 1 2 3 4 5 6 7 8 9 11 12 13 15 16 17 18 19 111) Access violation at address 0055FDEA in module 'SpamFilter.exe'. Read of address 00000000 is occurring when SpamFilter is receiving an email, not when it's forwarding it to the destination SMTP server. Without knowing exactly which build the error applied to, we can't pinpoint at what phase this occurred, but it appears to be caused while SpamFilter checks either the whitelist or blacklist keyword file for a match against the content of the email it's receiving. Please note that SpamFilter is multi-threaded, so while the error occurred because of a problem receiving an email, there may well have been an email which was being delivered to your destination SMTP server at that moment. If you'd like for us to try remoting into your test server to see if we can spot what's going on, please contact us via email or private message on the board so we can go in the specifics. |
|
|
|
|
Eric
Newbie
Joined: 23 February 2005 Location: Netherlands Status: Offline Points: 7 |
Post Options
Thanks(0)
Quote Reply
Posted: 25 February 2005 at 3:19am |
|
ok, i will do that, as what i stated is not correct,
if the email passes all checks, and the transfer of data/body starts, spamfilter ends in the posted error, also if a valid email is pasted in the queue directory, and the flush queue is pressed, it also happens. so far only my testbed and 2 dual dell 2650 server have this. i brought the new version online on a new hpdl545 dual opteron, and that runs fine. we are currently testing of the high pci latency of dell 2650 servers brings the issue, as a timer problem. so far it looks like that ! no other type of dell servers we have ( a lot) have the issue. |
|
|
|
Topic Options|
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.234 seconds.