1

Topic: Warning: Table './iredadmin/log' is marked as crashed ...

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.2
- Linux/BSD distribution name and version: Debian 8
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): Mysql
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? No
- Related log if you're reporting an issue: 
====
Hi,
Report from Cron daemon / Cron <root@zobe> python /opt/www/iredadmin/tools/cleanup_amavisd_db.py >/dev/null

* [2015-09-29 02:01:02] Backend: mysql
* [2015-09-29 02:01:02] Delete quarantined mails which older than 7 days
* [2015-09-29 02:01:02] Delete incoming/outgoing emails which older than 3 days
* [2015-09-29 02:01:02] [-] Deleting 39 records
* [2015-09-29 02:01:02] Delete unreferenced records from table `msgrcpt`.
* [2015-09-29 02:01:02] Delete unreferenced records from table `quarantine`.
* [2015-09-29 02:01:03] Delete unreferenced records from table `maddr`.
* [2015-09-29 02:01:03] Delete unreferenced records from table `mailaddr`.
/usr/local/lib/python2.7/dist-packages/DBUtils-1.1-py2.7.egg/DBUtils/SteadyDB.py:552: Warning: Table './iredadmin/log' is marked as crashed and should be repaired
  result = method(*args, **kwargs) # try to execute
/usr/local/lib/python2.7/dist-packages/DBUtils-1.1-py2.7.egg/DBUtils/SteadyDB.py:552: Warning: Table 'log' is marked as crashed and should be repaired
  result = method(*args, **kwargs) # try to execute
/usr/local/lib/python2.7/dist-packages/DBUtils-1.1-py2.7.egg/DBUtils/SteadyDB.py:552: Warning: 1 client is using or hasn't closed the table properly
  result = method(*args, **kwargs) # try to execute
* [2015-09-29 02:01:03] Log cleanup status.

I did install DBUtils followed my previous problem (iredapd) ....

Thx

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2

Re: Warning: Table './iredadmin/log' is marked as crashed ...

Repair it will mysql 'repair' comman.

3

Re: Warning: Table './iredadmin/log' is marked as crashed ...

Heu ? I didn't understand anything ... Sorry sad

4

Re: Warning: Table './iredadmin/log' is marked as crashed ...

Login to MySQL server as root user, then execute command to repair it like below:

sql> USE iredadmin;
sql> REPAIR log;

5

Re: Warning: Table './iredadmin/log' is marked as crashed ...

ZhangHuangbin wrote:

Login to MySQL server as root user, then execute command to repair it like below:

sql> USE iredadmin;
sql> REPAIR log;

Did you meant :

REPAIR TABLE log;

wink

6

Re: Warning: Table './iredadmin/log' is marked as crashed ...

Thierry wrote:

Did you meant :
REPAIR TABLE log;

yes. Sorry about the typo.