Spam Filter ISP Support - Problem with Quarantine DB after update to .276

Problem with Quarantine DB after update to .276

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=7166
Printed Date: 21 December 2024 at 9:38am

Topic: Problem with Quarantine DB after update to .276

Posted By: quat.net
Subject: Problem with Quarantine DB after update to .276
Date Posted: 07 February 2020 at 2:09am

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

Replies:

Posted By: ik8sqi
Date 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

Posted By: tcig
Date 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?

Posted By: ik8sqi
Date 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