Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - Tblmsgs corrupt
  FAQ FAQ  Forum Search   Register Register  Login Login

Tblmsgs corrupt
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
susheel View Drop Down
Newbie
Newbie
Avatar

Joined: 12 March 2008
Location: Bombay
Status: Offline
Points: 8 		Post Options Post Options   Thanks (0) Thanks(0)   Quote susheel Quote  Post ReplyReply Direct Link To This Post Topic: Tblmsgs corrupt
    Posted: 16 November 2009 at 3:37am
Dear Roberto,

The tblmsgs table in the SpamFilter database is corrupt and is eating up all space on the hard drive. I tried repairing the table using MySQL Administrator but even after waiting for hours, the repair isn't happening. Can you please help me to get this resolved?

Regards,

Susheel
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: 16 November 2009 at 10:36pm
Susheel,

If the quarantine database is several dozens of gigs in size, it can indeed take several hours for the repair process to take place. To try speeding it up you can try to temporarily disable SpamFilter's quarantine, which will prevent new records from being added to the database while it's being repaired. You can disable the quarantine by setting to 0 the value "Enter the number of days to store quarantined rejected emails" located in the database tab in SpamFilter.

If MySQL is not able to repair the table, unfortunately you will need to try restoring it for backup, if one is available.

If none of these options work, please let us know if you're using SpamFilter ISP Standard or Enterprise, so we can try to see how to proceed in creating a new database and/or new tables.
Roberto Franceschetti

LogSat Software

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

Joined: 12 March 2008
Location: Bombay
Status: Offline
Points: 8 		Post Options Post Options   Thanks (0) Thanks(0)   Quote susheel Quote  Post ReplyReply Direct Link To This Post Posted: 17 November 2009 at 1:08am
Roberto,
I managed to repair the table using "myisamch" and after several hours the repair was successful. I although wasn't able to find any previous quarantine data in the web interface. I can see the data through MySQL though.

I am using the Enterprise edition. Can you please assist me in displaying the earlier data?

Awaiting,

Susheel
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.139 seconds.

Copyright (c)2002-2021 LogSat Software LLC - Sales: sales@LogSat.com
Contact Us