I have a strange problem that I need some input on:
Carbonio CE 24.7.1 - works as intended. Webclient and the Android Carbonio app, everything is there.
Outlook (classic) and the Gmail-app for Android, only the subfolders in the Inbox contain any e-mail, root Inbox is empty?!
And this is only for one account, I have two other accounts that works just fine in Outlook.
Any advice before I loose the last of my marbles?
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?
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).