Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - Error occurred during RECEIVEMESSAGE when
  FAQ FAQ  Forum Search   Register Register  Login Login

Error occurred during RECEIVEMESSAGE when

 Post Reply Post Reply
Author
JeffHildebrand View Drop Down
Newbie
Newbie


Joined: 26 January 2005
Location: United States
Status: Offline
Points: 15
Post Options Post Options   Thanks (0) Thanks(0)   Quote JeffHildebrand Quote  Post ReplyReply Direct Link To This Post Topic: Error occurred during RECEIVEMESSAGE when
    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

 

 



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

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

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

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

Joined: 27 January 2005
Location: United States
Status: Offline
Points: 1143
Post Options Post Options   Thanks (0) Thanks(0)   Quote Desperado Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
JeffHildebrand View Drop Down
Newbie
Newbie


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

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

Back to Top
Eric View Drop Down
Newbie
Newbie
Avatar

Joined: 23 February 2005
Location: Netherlands
Status: Offline
Points: 7
Post Options Post Options   Thanks (0) Thanks(0)   Quote Eric Quote  Post ReplyReply Direct Link To This Post 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 ;)]
Back to Top
Desperado View Drop Down
Senior Member
Senior Member
Avatar

Joined: 27 January 2005
Location: United States
Status: Offline
Points: 1143
Post Options Post Options   Thanks (0) Thanks(0)   Quote Desperado Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

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

LogSat Software

Spam Filter ISP
Back to Top
Eric View Drop Down
Newbie
Newbie
Avatar

Joined: 23 February 2005
Location: Netherlands
Status: Offline
Points: 7
Post Options Post Options   Thanks (0) Thanks(0)   Quote Eric Quote  Post ReplyReply Direct Link To This Post 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.

Back to Top
Eric View Drop Down
Newbie
Newbie
Avatar

Joined: 23 February 2005
Location: Netherlands
Status: Offline
Points: 7
Post Options Post Options   Thanks (0) Thanks(0)   Quote Eric Quote  Post ReplyReply Direct Link To This Post Posted: 23 February 2005 at 5:49pm
sorry, and updated the psapi of course ...
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

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

LogSat Software

Spam Filter ISP
Back to Top
Eric View Drop Down
Newbie
Newbie
Avatar

Joined: 23 February 2005
Location: Netherlands
Status: Offline
Points: 7
Post Options Post Options   Thanks (0) Thanks(0)   Quote Eric Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

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

LogSat Software

Spam Filter ISP
Back to Top
Eric View Drop Down
Newbie
Newbie
Avatar

Joined: 23 February 2005
Location: Netherlands
Status: Offline
Points: 7
Post Options Post Options   Thanks (0) Thanks(0)   Quote Eric Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.266 seconds.