Few days back, our zimbra(8.6) has been crashed, and we recovered it on another server. But after that we are regularly facing issue, that suddenly user not able to login and it keeps showing "Loading"
I got following error, i reindex user mail and also upgrade SSL certificate, but still same issue.
com.zimbra.common.service.ServiceException: system failure: fetching folder data for mailbox 15010
ExceptionId:qtp509886383-228889:http://127.0.0.1:8080/service/soap/GetF ... 5acd1c5bcb
Code:service.FAILURE
.
.
.
at java.lang.Thread.run(Thread.java:745)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'mboxgroup10.mail_item' doesn't exist
Query being executed when exception was thrown:
SELECT mi.id, mi.type, mi.parent_id, mi.folder_id, mi.prev_folders, mi.index_id,mi.imap_id, mi.date, mi.size, mi.locator, mi.blob_digest, mi.unread, mi.flags, mi.tag_names, mi.subject,mi.name, mi.metadata, mi.mod_metadata, mi.change_date, mi.mod_content, mi.uuid FROM mboxgroup10.mail_item AS mi WHERE mailbox_id = 15010 AND type IN (1,2,13)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.zimbra.common.soap.SoapFaultException: system failure: fetching folder data for mailbox 15010
ExceptionId:qtp509886383-228889:http://127.0.0.1:8080/service/soap/GetF ... 5acd1c5bcb
Code:service.FAILURE
I have checked table in DB but it is not there
Please advice.MariaDB [(none)]> use mboxgroup10
Database changed
MariaDB [mboxgroup10]> show tables;
Empty set (0.00 sec)
MariaDB [mboxgroup10]> Ctrl-C -- exit!
Aborted
[zimbra@IBEXDC1ZMAIL01 log]$ mysql -e "check table mboxgroup10.mail_item"
+-----------------------+-------+----------+---------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-----------------------+-------+----------+---------------------------------------------+
| mboxgroup10.mail_item | check | Error | Table 'mboxgroup10.mail_item' doesn't exist |
| mboxgroup10.mail_item | check | status | Operation failed |
+-----------------------+-------+----------+---------------------------------------------+
Thanks