1 Topic by tyllee

  • tyllee
  • Member
  • Offline
  • Registered: 2013-03-27
  • Posts: 98

Topic: /iredadmin/log is marked as crashed

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.5-1
- Linux/BSD distribution name and version:  Deb 8
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? Yes
- Related log if you're reporting an issue:
====

This is the second time I get this message:
/usr/lib/python2.7/dist-packages/web/db.py:587: Warning: Table './iredadmin/log' is marked as crashed and should be repaired

What is best practice to repair?

This is what I do:
root@iredmail:/opt/www# mysqlcheck --repair --databases iredadmin -p
Enter password:
iredadmin.deleted_mailboxes                        OK
iredadmin.log                                      OK
iredadmin.sessions                                 OK
iredadmin.updatelog                                OK

----

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

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,165

Re: /iredadmin/log is marked as crashed

Delete sql table "iredadmin.log", re-create it with sample SQL structure in file /opt/www/iredadmin/docs/samples/iredmadmin.sql.

3 Reply by tyllee

  • tyllee
  • Member
  • Offline
  • Registered: 2013-03-27
  • Posts: 98

Re: /iredadmin/log is marked as crashed

ZhangHuangbin wrote:

Delete sql table "iredadmin.log", re-create it with sample SQL structure in file /opt/www/iredadmin/docs/samples/iredmadmin.sql.

Thank you!

DROP table log;

mysql -u root -p iredadmin < iredadmin.sql

Worked perfekt.