Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - SpamFilter server hangs abruptly & mysql crashes
  FAQ FAQ  Forum Search   Register Register  Login Login

SpamFilter server hangs abruptly & mysql crashes

 Post Reply Post Reply
Author
prsahant31 View Drop Down
Newbie
Newbie


Joined: 31 January 2011
Status: Offline
Points: 1
Post Options Post Options   Thanks (0) Thanks(0)   Quote prsahant31 Quote  Post ReplyReply Direct Link To This Post Topic: SpamFilter server hangs abruptly & mysql crashes
    Posted: 09 February 2011 at 8:56am
Recently I have been facing a mysterious problem with Spam Filer ISP Server. All of a sudden it hangs up and I need to hard reboot. When I check the System Logs it says 'Unexpected Shutdown' and the application log shows G:\mysql5.1\bin\mysqld-nt : Table :\spamdb\tblmsgs's is marked as crashed and should be repaired

This has happened almost 6-7 times in last 2 days. My total database size is not more than 1.5 Gb.  My server hardware is Dual processors Xeon 2.4 with 2 gb ram. Can someone suggest anything on this.
Generally the processor and memory load is not more than 50%
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4068
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 12 February 2011 at 3:55pm
prsahant31,

We already replied via email on the 9th, but in case other users have similar issues, here is the reply:

The error you see "G:\mysql5.1\bin\mysqld-nt : Table :\spamdb\tblmsgs's is marked
as crashed and should be repaired" occurs as one of the MySQL tables (tblMsgs) is corrupted. This likely occurred when the server was hard rebooted, as database files are usually open files with ongoing transactions, and are very sensitive to unexpected restarts.
To repair the database, you can try to use MySQL’s “repair table” functionality, but to do that you may need to stop SpamFilter first as MySQL may require single user access to the database. If that’s the case, and the database is large (+1GB), you could try to stop SpamFilter, start the repair procedure, and while that goes on restart SpamFilter, as SpamFilter should be able to work even without a database present.

Please do note that while the SpamFilter application may crash, this would not bring down an entire server. There are usually other factors involved, either hardware or software (often caused by kernel drivers) that can cause hard crashes and/or blue screens. Depending on your OS settings, there may be debug logs being created by Windows for you to examine and possibly locate the root cause of the crashes.

Roberto Franceschetti

LogSat Software

Spam Filter ISP
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.046 seconds.