IMAP client not ret...
 
Notifications
Clear all

IMAP client not retrieving inbox

6 Posts
2 Users
0 Reactions
243 Views
(@daddycool)
Joined: 12 months ago
Posts: 12
Topic starter  

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?


   
Quote
(@sharif)
Admin
Joined: 3 years ago
Posts: 591
 

@daddycool

Hi,

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

Regards,

Sharif


   
ReplyQuote
(@daddycool)
Joined: 12 months ago
Posts: 12
Topic starter  

@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?

This post was modified 3 months ago by daddycool

   
ReplyQuote
(@sharif)
Admin
Joined: 3 years ago
Posts: 591
 

@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


   
ReplyQuote
(@daddycool)
Joined: 12 months ago
Posts: 12
Topic starter  

@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)


   
ReplyQuote
(@daddycool)
Joined: 12 months ago
Posts: 12
Topic starter  

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


   
ReplyQuote