Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 27

Thread: [SOLVED] zimbra mailbox corrupt

  1. #11
    Join Date
    Sep 2009
    Location
    kenya
    Posts
    31
    Rep Power
    6

    Default

    the files under /opt/zimbra/db/data/mboxgroup27 are :-
    [root@letter ~]# ls -al /opt/zimbra/db/data/mboxgroup27
    total 1216
    drwx------ 2 zimbra zimbra 4096 Jul 26 2008 .
    drwxr-x--- 105 zimbra zimbra 4096 Feb 22 12:53 ..
    -rw-rw---- 1 zimbra zimbra 8716 Jul 26 2008 appointment.frm
    -rw-rw---- 1 zimbra zimbra 114688 Jul 26 2008 appointment.ibd
    -rw-rw---- 1 zimbra zimbra 61 Jul 26 2008 db.opt
    -rw-rw---- 1 zimbra zimbra 12886 Jul 26 2008 imap_folder.frm
    -rw-rw---- 1 zimbra zimbra 131072 Jul 26 2008 imap_folder.ibd
    -rw-rw---- 1 zimbra zimbra 8718 Jul 26 2008 imap_message.frm
    -rw-rw---- 1 zimbra zimbra 114688 Jul 26 2008 imap_message.ibd
    -rw-rw---- 1 zimbra zimbra 9342 Jul 26 2008 mail_item.frm
    -rw-rw---- 1 zimbra zimbra 294912 Jul 26 2008 mail_item.ibd
    -rw-rw---- 1 zimbra zimbra 8638 Jul 26 2008 open_conversation.frm
    -rw-rw---- 1 zimbra zimbra 114688 Jul 26 2008 open_conversation.ibd
    -rw-rw---- 1 zimbra zimbra 8686 Jul 26 2008 pop3_message.frm
    -rw-rw---- 1 zimbra zimbra 114688 Jul 26 2008 pop3_message.ibd
    -rw-rw---- 1 zimbra zimbra 8990 Jul 26 2008 revision.frm
    -rw-rw---- 1 zimbra zimbra 98304 Jul 26 2008 revision.ibd
    -rw-rw---- 1 zimbra zimbra 8698 Jul 26 2008 tombstone.frm
    -rw-rw---- 1 zimbra zimbra 114688 Jul 26 2008 tombstone.ibd

    And when i run
    [root@letter ~]# /opt/zimbra/mysql/bin/mysqlcheck --defaults-file=/opt/zimbra/conf/my.cnf -S /opt/zimbra/db/mysql.sock -A -C -s -u root --password=***** --auto-repair

    I get

    mboxgroup27.appointment
    Error : Table 'mboxgroup27.appointment' doesn't exist
    error : Corrupt
    mboxgroup27.imap_folder
    Error : Table 'mboxgroup27.imap_folder' doesn't exist
    error : Corrupt
    mboxgroup27.imap_message
    Error : Table 'mboxgroup27.imap_message' doesn't exist
    error : Corrupt
    mboxgroup27.mail_item
    Error : Table 'mboxgroup27.mail_item' doesn't exist
    error : Corrupt
    mboxgroup27.open_conversation
    Error : Table 'mboxgroup27.open_conversation' doesn't exist
    error : Corrupt
    mboxgroup27.pop3_message
    Error : Table 'mboxgroup27.pop3_message' doesn't exist
    error : Corrupt
    mboxgroup27.revision
    Error : Table 'mboxgroup27.revision' doesn't exist
    error : Corrupt
    mboxgroup27.tombstone
    Error : Table 'mboxgroup27.tombstone' doesn't exist
    error : Corrupt
    mboxgroup27.appointment
    Error : Table 'mboxgroup27.appointment' doesn't exist
    error : Corrupt
    mboxgroup27.imap_folder
    Error : Table 'mboxgroup27.imap_folder' doesn't exist
    error : Corrupt
    mboxgroup27.imap_message
    Error : Table 'mboxgroup27.imap_message' doesn't exist
    error : Corrupt
    mboxgroup27.mail_item
    Error : Table 'mboxgroup27.mail_item' doesn't exist
    error : Corrupt
    mboxgroup27.open_conversation
    Error : Table 'mboxgroup27.open_conversation' doesn't exist
    error : Corrupt
    mboxgroup27.pop3_message
    Error : Table 'mboxgroup27.pop3_message' doesn't exist
    error : Corrupt
    mboxgroup27.revision
    Error : Table 'mboxgroup27.revision' doesn't exist
    error : Corrupt
    mboxgroup27.tombstone
    Error : Table 'mboxgroup27.tombstone' doesn't exist
    error : Corrupt

    My server had crashed and mboxgroup27 was not available hence i restored it from a backup ia had created some time back

  2. #12
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    25

    Default

    Okay so dependant on how broken they are you can try
    Code:
    su - zimbra
    mysql
    use mboxgroup27
    repair table appointment
    and do the same for each table. If that does not work you may need to go through Mysql Crash Recovery - Zimbra :: Wiki.

  3. #13
    Join Date
    Sep 2009
    Location
    kenya
    Posts
    31
    Rep Power
    6

    Default

    Thanks was able to repair mysql but the inbox is still corrupted and cant access the mail.

    Am stranded dont know what to do???

    Please help

  4. #14
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    25

    Default

    I presume all errors have gone now from the MySQL log file ? You could try re-indexing the account now
    Code:
    su - zimbra
    zmprov ri user@domain.com

  5. #15
    Join Date
    Sep 2009
    Location
    kenya
    Posts
    31
    Rep Power
    6

    Default

    Have re-indexed the account

    [zimbra@letter root]$ zmprov rim xx@xxxx.org start
    status: started
    [zimbra@letter root]$ zmprov rim xx@xxxx.org status
    ERROR: service.NOT_IN_PROGRESS (mbox d6b68b4b-faff-4819-a348-fa35820674ab is not currently running action ReIndex)
    [zimbra@letter root]$

    but still no difference but there are no more errors in mysql log

  6. #16
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    25

    Default

    How does the mailbox show as corrupt then ?

  7. #17
    Join Date
    Sep 2009
    Location
    kenya
    Posts
    31
    Rep Power
    6

    Default

    the mailbox can be accessed but displays as the link "https://docs.google.com/Doc?docid=0AUPSrzZ7OnoLZGhtZm54cTRfNmRiNXdkM2dw&hl =en"

  8. #18
    Join Date
    Sep 2009
    Location
    kenya
    Posts
    31
    Rep Power
    6

    Default

    And when i run zmblobchk, this are the errors it displays

    "* /opt/zimbra/store/0/42/msg/2/8284-23406.msg: no associated metadata (delete blob)
    * /opt/zimbra/store/0/121/msg/0/882-1704.msg: no associated metadata (delete blob)
    * /opt/zimbra/store/0/8/msg/2/10180-35303.msg: no associated metadata (delete blob)
    * /opt/zimbra/store/0/118/msg/2/10262-24769.msg: no associated metadata (delete blob)
    * /opt/zimbra/store/0/137/msg/2/10654-29314.msg: no associated metadata (delete blob)
    * /opt/zimbra/store/0/170/msg/2/9541-29801.msg: no associated'

    and when i try to get their data
    zmmailbox -z -m xxx@xxxxx.org gms
    ERROR: mail.NO_SUCH_FOLDER (no such folder id: 1)
    [zimbra@letter Desktop]$ zmmailbox -z -m xxx@xxxxx.org gaf
    Id View Unread Msg Count Path
    ---------- ---- ---------- ---------- ----------
    ERROR: mail.NO_SUCH_FOLDER (no such folder id: 1)
    ""

  9. #19
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    25

    Default

    That does not look good at all ... First check to see which mailbox group that account uses
    Code:
    su - zimbra
    mysql
    use zimbra
    select group_id from mailbox where comment = 'user@domain.com';
    Once you have the group_id check under /opt/zimbra/store/0/<group_id>/msg are see whether there are .msg files in there ?

  10. #20
    Join Date
    Sep 2009
    Location
    kenya
    Posts
    31
    Rep Power
    6

    Default

    It does not look good

    "[zimbra@letter root]$ mysql
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 2909
    Server version: 5.0.51a-log Source distribution

    Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

    mysql> use zimbra
    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
    mysql> select group_id from mailbox where comment = 'name@domain.org';
    +----------+
    | group_id |
    +----------+
    | 27 |
    +----------+
    1 row in set (0.00 sec)"

    and in /opt/zimbra/store/0/27/msg/ there are messages but still the error

    "[root@letter ~]# ls -al /opt/zimbra/store/0/27/msg/
    total 348
    drwxr-x--- 6 zimbra zimbra 4096 Feb 9 11:01 .
    drwxr-x--- 3 zimbra zimbra 4096 Oct 3 2008 ..
    drwxr-x--- 2 zimbra zimbra 77824 Feb 1 10:15 0
    drwxr-x--- 2 zimbra zimbra 118784 Jan 28 14:09 1
    drwxr-x--- 2 zimbra zimbra 126976 Feb 15 22:49 2
    drwxr-x--- 2 zimbra zimbra 12288 Feb 16 18:19 3"
    Last edited by kkimani; 02-23-2010 at 12:30 AM.

Similar Threads

  1. Zimbra spam system
    By rajahd in forum Administrators
    Replies: 9
    Last Post: 04-16-2008, 08:25 PM
  2. Replies: 12
    Last Post: 02-25-2008, 07:28 PM
  3. Post instsallation problems
    By Assaf in forum Installation
    Replies: 14
    Last Post: 01-29-2007, 11:38 AM
  4. Zimbra server crashed
    By goetzi in forum Administrators
    Replies: 6
    Last Post: 03-25-2006, 01:00 PM
  5. Fedora Core 3, Clean Install - Not working!
    By pcjackson in forum Installation
    Replies: 17
    Last Post: 03-05-2006, 07:38 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •