Error occurred during RECEIVEMESSAGE when
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=5030
Printed Date: 12 March 2025 at 11:40am
Topic: Error occurred during RECEIVEMESSAGE when
Posted By: JeffHildebrand
Subject: Error occurred during RECEIVEMESSAGE when
Date Posted: 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
Microsoft JET Database Engine erorr '80004005'
Operation must use an updateable query.
/spam/ResolveSpam.asp, line 135.
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:
-Max Frequency to send an alert (1-999 hours)
-Max number of errors to send with the alert
-Secondary email to attempt if first fails
Thanks,
Jeff
|
Replies:
Posted By: Guests
Date 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-
|
Posted By: Guests
Date 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
02/23/05 18:12:07:843 -- (1420) Disconnect
|
Posted By: Guests
Date 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
|
Posted By: Desperado
Date 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
|
Posted By: JeffHildebrand
Date 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
|
Posted By: Guests
Date 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 .. ;-( ????
|
Posted By: Eric
Date 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 ;)]
|
Posted By: Desperado
Date 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
|
Posted By: LogSat
Date 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?
-------------
Roberto Franceschetti
http://www.logsat.com" rel="nofollow - LogSat Software
http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP
|
Posted By: Eric
Date 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.
|
Posted By: Eric
Date Posted: 23 February 2005 at 5:49pm
|
sorry, and updated the psapi of course ...
|
Posted By: LogSat
Date 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?
-------------
Roberto Franceschetti
http://www.logsat.com" rel="nofollow - LogSat Software
http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP
|
Posted By: Eric
Date 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.
|
Posted By: LogSat
Date 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.
-------------
Roberto Franceschetti
http://www.logsat.com" rel="nofollow - LogSat Software
http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP
|
Posted By: Eric
Date 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.
|
|