Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - Problem with Quarantine DB after update to .276
  FAQ FAQ  Forum Search   Register Register  Login Login

Problem with Quarantine DB after update to .276

 Post Reply Post Reply
Author
quat.net View Drop Down
Newbie
Newbie


Joined: 24 July 2007
Location: Germany
Status: Offline
Points: 5
Post Options Post Options   Thanks (0) Thanks(0)   Quote quat.net Quote  Post ReplyReply Direct Link To This Post Topic: Problem with Quarantine DB after update to .276
    Posted: 07 February 2020 at 2:09am
Hi

i get a database error in logfiles like 

02.07.20 08:00:00:956 -- (213502224) Exception occurred during TDeliverQuarantineThread.Execute inner loop: [MySQL][ODBC 3.51 Driver][mysqld-5.7.29-0ubuntu0.16.04.1]Table 'mx03.tblMsgs' doesn't exist 1 2 3 4 5 6 7 8

if i need to deliver mails out of the quarantine.

any ideas what to do?

regards
Frank


QUAT.NET GmbH
Back to Top
ik8sqi View Drop Down
Newbie
Newbie


Joined: 25 January 2005
Status: Offline
Points: 14
Post Options Post Options   Thanks (0) Thanks(0)   Quote ik8sqi Quote  Post ReplyReply Direct Link To This Post Posted: 07 February 2020 at 7:23am
Frank,

Can you please check if in the SpamFilter database on the MySQL server you are able to access the tblMsgs table, and view the data it contains?

If there are no issues accessing that table using your database tools, can you please stop and restart SpamFilter, wait about 5 minutes, and then zip us these two files so we can review them:
    • SpamFilter's activity logfile for today
    • Your SpamFilter.ini file

Please try to upload the file to our Box repository at:
https://logsat.com/sfi-upload-box.asp


Roberto Franceschetti
LogSat Software
Back to Top
tcig View Drop Down
Newbie
Newbie


Joined: 30 March 2005
Location: Germany
Status: Offline
Points: 9
Post Options Post Options   Thanks (0) Thanks(0)   Quote tcig Quote  Post ReplyReply Direct Link To This Post Posted: 26 February 2020 at 6:10am
is there a solution to the problem? We had the same phenomenon. After resetting to version .270 everything was as usual again.
In changelog we did not find the changes in version .276. Is this release stable on Windows 2012R2 and mysql?
Back to Top
ik8sqi View Drop Down
Newbie
Newbie


Joined: 25 January 2005
Status: Offline
Points: 14
Post Options Post Options   Thanks (0) Thanks(0)   Quote ik8sqi Quote  Post ReplyReply Direct Link To This Post Posted: 26 February 2020 at 8:33am
tcig, we never received the logs from the original poster so we were assuming the issue was due to a corrupt MySQL database.

If you could please send us the SpamFilter logs for the day you experienced the problem, as well as your SpamFilter.ini file we'll be able to look into this. It would also help if you could include the logs for the day you upgraded to .276 so we can see what happens when SpamFilter starts up.

Please upload the files to our Box repository at:
https://logsat.com/sfi-upload-box.as
Roberto Franceschetti
LogSat Software
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.117 seconds.