Zimbra offers Open Source email server software and shared calendar for Linux and the Mac
Go Back   Zimbra :: Forums > Zimbra Collaboration Suite > Administrators

Welcome to the Zimbra :: Forums!
Welcome, if you would like to post a comment please register. We also encourage you to explore all things Zimbra with our team and members of the community.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-28-2008, 02:06 AM
Loyal Member
 
Posts: 78
Exclamation [SOLVED] After a file system failure - EMPTY INBOX

Hi,

I'm using Zimbra OS 5.0.9.

Yesterday there was a file system (reiserfs) failure, and some files are lost after a reiserfsck.

One of accounts as an inbox of one message, but moving the mouse over the "INBOX" text it tells he has over 2200 messages.

Can I recover them? Rebuilding MYSQL tables?
Reply With Quote
  #2 (permalink)  
Old 11-28-2008, 02:26 AM
Zimbra Consultant & Moderator
 
Posts: 20,312
Default

Try and re-index the mailbox.
__________________
Regards


Bill
Reply With Quote
  #3 (permalink)  
Old 11-28-2008, 03:14 AM
Loyal Member
 
Posts: 78
Default

Quote:
Originally Posted by phoenix View Post
Try and re-index the mailbox.
how can I do it?
Reply With Quote
  #4 (permalink)  
Old 11-28-2008, 03:20 AM
Zimbra Consultant & Moderator
 
Posts: 20,312
Default

Go to the Admin UI and in the Account details hit the re-index option.
__________________
Regards


Bill
Reply With Quote
  #5 (permalink)  
Old 12-01-2008, 03:49 AM
Loyal Member
 
Posts: 78
Default

it doesn't work. I did a mysqlcheck:

Code:
mboxgroup4.appointment
Error    : Table 'mboxgroup4.appointment' doesn't exist
error    : Corrupt
mboxgroup4.imap_folder
Error    : Table 'mboxgroup4.imap_folder' doesn't exist
error    : Corrupt
mboxgroup4.imap_message
Error    : Table 'mboxgroup4.imap_message' doesn't exist
error    : Corrupt
mboxgroup4.mail_item
Error    : Table 'mboxgroup4.mail_item' doesn't exist
error    : Corrupt
mboxgroup4.open_conversation
Error    : Table 'mboxgroup4.open_conversation' doesn't exist
error    : Corrupt
mboxgroup4.pop3_message
Error    : Table 'mboxgroup4.pop3_message' doesn't exist
error    : Corrupt
mboxgroup4.revision
Error    : Table 'mboxgroup4.revision' doesn't exist
error    : Corrupt
mboxgroup4.tombstone
Error    : Table 'mboxgroup4.tombstone' doesn't exist
error    : Corrupt
how can I fix this?
Reply With Quote
  #6 (permalink)  
Old 12-01-2008, 03:55 AM
Moderator
 
Posts: 7,928
Default

You could try Mysql Crash Recovery - Zimbra :: Wiki but I would recommend taking a backup of /opt/zimbra first. If it is only MySQL that is broken and the message store is intact then the emails could be recovered by re-injecting them once the database is sorted.
__________________
Reply With Quote
  #7 (permalink)  
Old 12-02-2008, 01:07 AM
Loyal Member
 
Posts: 78
Default

thank you ! I had to rebuild InnoDB index ... it was too corrupt...
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes


Similar Threads

Why Join?

Registering let's you ask questions, makes it easier to search, displays any files attached to posts, and notifies you about replies.

blog.zimbra.com




 

SEO by vBSEO ©2011, Crawlability, Inc.