IMAP client not retrieving inbox

@daddycool

Hi,

Could you check the /opt/zextras/log/mailbox.log for any hint?

Regards,

Sharif

@sharif

I tailed /opt/zextras/log/mailbox.log and did a search in the webclient for an address I know I received mail from. No result on the search and the log gives me (really short version):

system failure: Failed to search and Index mail_item is corrupted

How can I repair this?

@daddycool 

It seems like the database item for the mailbox got corrupted. Let's check this:

Use following commands:

• List all databases 

zextras@mail:~$ mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 38
Server version: 10.5.25-MariaDB-log Zextras MariaDB binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| chat               |
| information_schema |
| mboxgroup1         |
| mboxgroup2         |
| mysql              |
| performance_schema |
| test               |
+--------------------+
8 rows in set (0.001 sec)

• Now select the mboxgroup* database one by one and check their status to understand which one got corrupted:

MariaDB [(none)]> use mboxgroup1;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [mboxgroup1]> check table mail_item;
+----------------------+-------+----------+----------+
| Table                | Op    | Msg_type | Msg_text |
+----------------------+-------+----------+----------+
| mboxgroup1.mail_item | check | status   | OK       |
+----------------------+-------+----------+----------+
1 row in set (0.002 sec)


##### And

MariaDB [(none)]> use mboxgroup2;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [mboxgroup2]> check table mail_item;
+----------------------+-------+----------+----------+
| Table                | Op    | Msg_type | Msg_text |
+----------------------+-------+----------+----------+
| mboxgroup2.mail_item | check | status   | OK       |
+----------------------+-------+----------+----------+
1 row in set (0.001 sec)

You could have more than 2 mboxgroup* databases, check them all.

Regards,

Sharif

@sharif I checked the 55 mboxgroups and mboxgroup26 is corrupt:

Database changed
MariaDB [mboxgroup26]> check table mail_item;
+-----------------------+-------+----------+-------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-----------------------+-------+----------+-------------------------------------------------------+
| mboxgroup26.mail_item | check | Warning | InnoDB: Index i_name_folder_id is marked as corrupted |
| mboxgroup26.mail_item | check | Warning | InnoDB: Index i_index_id is marked as corrupted |
| mboxgroup26.mail_item | check | Warning | InnoDB: Index i_date is marked as corrupted |
| mboxgroup26.mail_item | check | error | Corrupt |
+-----------------------+-------+----------+-------------------------------------------------------+
4 rows in set (0.189 sec)

@sharif Would this still be a relevant solution for the corrupt mboxgroup?
https://wiki.zimbra.com/wiki/How_to_recreate_corrupted_index_(mysql).