Solved

BrightMail Error

Posted on 2006-06-13
3
1,208 Views
Last Modified: 2007-12-19
Dear All
Am using Brightmail Control Center version: 6.0.2.100 on Linux Enterbrise ES 3.0 it work fine for long time ,before one month when i log in to bright mail by the web site to the control center i cannot check the Quarantin spam and even when i go to Summary i see red cross at all system status . but the Brightmail is stell work i can see the carve for the spam , i look to the brightmail log file i foun a error but i don't know what shall i do. and this is the error.

Jun 13 2006 02:05:54 [Thread-22] ERROR - Cannot create a spam message in the database.
com.brightmail.dl.DataAccessException: null; nested exception is:
        java.sql.SQLException: General error,  message from server: "Can't open file: 'spam_message.MYI'. (errno: 145)"
        at com.brightmail.dl.impl.DAOHelper.executeUpdate(DAOHelper.java:318)
        at com.brightmail.dl.impl.QuarantineDAOImpl.createSpamMessage(QuarantineDAOImpl.java:118)
        at com.brightmail.bl.bo.impl.QuarantineManager.create(QuarantineManager.java:206)
        at com.brightmail.service.smtp.impl.SmtpConsumer.run(SmtpConsumer.java:222)
Caused by: java.sql.SQLException: General error,  message from server: "Can't open file: 'spam_message.MYI'. (errno: 145)"
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1905)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1109)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1203)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2090)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1680)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1527)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:207)
        at com.brightmail.dl.impl.DAOHelper.executeUpdate(DAOHelper.java:313)
        ... 3 more


Pls. Can any one help me.

Thanks
0
Comment
Question by:DAL_Group
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 19

Accepted Solution

by:
Gabriel Orozco earned 500 total points
ID: 16903434
it appears you probably have a crashed or corrupt table.
You can check and repair the table from a mysql prompt like this:
check table spam_message.MYI;

you can also try with the command line index utility:

myisamchk -r spam_message

0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hello EE, Today we will learn how to send all your network traffic through Tor which is useful to get around censorship and being tracked all together to a certain degree. This article assumes you will be using Linux, have a minimal knowledge of …
Fine Tune your automatic Updates for Ubuntu / Debian
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question