Results 1 to 8 of 8

Thread: [SOLVED] Anyone else having trouble restoring mail accounts on 6.0.5?

  1. #1
    Jesster's Avatar
    Jesster is offline Trained Alumni
    Join Date
    Nov 2007
    Location
    Santa Barbara, CA.
    Posts
    109
    Rep Power
    7

    Default [SOLVED] Anyone else having trouble restoring mail accounts on 6.0.5?

    Hey Everyone,

    I'm having zero success restoring any mailbox account on ALL our 6.0.5 mailbox servers. Is anyone else having issues? The backups are successful, and now we need to restore a few accounts. Anyways, I've already opened a Support Ticket, so we'll see if they uncover anything obvious (mailboxd restarts didn't fix it).

    Java is throwing all kinds of tracebacks- heres a few:

    Code:
    Caused by: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`mboxgroup29/mail_item`, CONSTRAINT `fk_mail_item_mailbox_id` FOREIGN KEY (`mailbox_id`) REFERENCES `zimbra`.`mailbox` (`id`))
    and

    Code:
    Caused by: com.zimbra.common.service.ServiceException: system failure: writing new object of type 5
    ExceptionId:LmtpServer-20:1267676645098:dc967d3c5dbedcba
    Code:service.FAILURE
    We've tried a random sample accounts, and all have failed:
    Code:
    [zimbra@zmbx02 ~]$ time zmrestore -a username@example.org -ca -pre restore_
    Error occurred: Read timed out
    
    real    5m3.001s
    user    0m4.733s
    sys     0m0.301s
    [zimbra@zmbx02 ~]$
    Last edited by Jesster; 03-03-2010 at 09:56 PM. Reason: Clarified commands - and included CLI error message.

  2. #2
    Jesster's Avatar
    Jesster is offline Trained Alumni
    Join Date
    Nov 2007
    Location
    Santa Barbara, CA.
    Posts
    109
    Rep Power
    7

    Default

    Also experiencing this "Read timed out" on mailbox moves:

    Code:
    [zimbra@zimbra]$ time (zmmailboxmove -a username@example.org -t server2.example.org)
    Error occurred: Read timed out
    
    real    5m2.333s
    user    0m4.189s
    sys     0m0.232s

  3. #3
    LMStone's Avatar
    LMStone is offline Moderator
    Join Date
    Sep 2006
    Location
    477 Congress Street | Portland, ME 04101
    Posts
    1,366
    Rep Power
    10

    Default

    Quote Originally Posted by Jesster View Post
    Also experiencing this "Read timed out" on mailbox moves:

    Code:
    [zimbra@zimbra]$ time (zmmailboxmove -a username@example.org -t server2.example.org)
    Error occurred: Read timed out
    
    real    5m2.333s
    user    0m4.189s
    sys     0m0.232s
    FWIW we are getting the same read time out errors on 6.0.5 larger mailbox moves, but the mailbox move completes OK in the background. We just refresh the Admin Console and wait until the mailbox status changes from "Maintenance" to "Active".

    Haven't tried restoring a mailbox yet, but will do so and report back in the next day or so.

    All the best,
    Mark

  4. #4
    Jesster's Avatar
    Jesster is offline Trained Alumni
    Join Date
    Nov 2007
    Location
    Santa Barbara, CA.
    Posts
    109
    Rep Power
    7

    Default

    Thanks LMStone,

    I noticed my tests are with accounts 800MB or greater. They are all successful regardless of the CLI error. I am working with support on this, and it sounds like they have a 5 minute Soap Timeout

    Code:
    zmlocalconfig httpclient_soaphttptransport_so_timeout
    mine is set to 300000 which Support says is 5 minutes
    to set the timeout to Infinite, just set it to 0. I will do some testing today.

    --
    Jessie

  5. #5
    ewilen's Avatar
    ewilen is offline Moderator
    Join Date
    Jun 2008
    Location
    Berkeley, CA
    Posts
    1,474
    Rep Power
    8

    Default

    Any update on this? I haven't tested but it'd be good to know if this is a common issue.

  6. #6
    Jesster's Avatar
    Jesster is offline Trained Alumni
    Join Date
    Nov 2007
    Location
    Santa Barbara, CA.
    Posts
    109
    Rep Power
    7

    Default

    Quote Originally Posted by ewilen View Post
    Any update on this? I haven't tested but it'd be good to know if this is a common issue.
    Hey Elliot,

    See my previous post - we needed to change the timeout for the soap stuff to 0, the 6.0.x default is 5 minutes. I'm not sure why others aren't complaining. maybe they are restoring smaller mailboxes.

  7. #7
    ewilen's Avatar
    ewilen is offline Moderator
    Join Date
    Jun 2008
    Location
    Berkeley, CA
    Posts
    1,474
    Rep Power
    8

    Default

    Ah, so after changing the default, you got rid of the (cosmetic) error. Thanks.

  8. #8
    rusty is offline Loyal Member
    Join Date
    Nov 2007
    Posts
    92
    Rep Power
    7

    Default

    zmlocalconfig httpclient_soaphttptransport_so_timeout

    Running this command shows my timeout to be 300000 as well.

    What is the command to actually change the timeout value?

    Is it better to increase the value to 10 or 20 minutes? Seems like setting it to infinite defeats the purpose of a timeout.

    Eric

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 7
    Last Post: 02-03-2011, 07:01 AM
  2. Replies: 30
    Last Post: 01-13-2009, 08:00 AM
  3. Large volume of spam messages; see the log
    By snake_eyes in forum Administrators
    Replies: 1
    Last Post: 12-31-2008, 06:54 AM
  4. Migration Assistance
    By dwill in forum Administrators
    Replies: 10
    Last Post: 12-02-2008, 08:20 AM
  5. fresh install down may be due to tomcat
    By gon in forum Installation
    Replies: 10
    Last Post: 07-25-2007, 08:09 AM

Posting Permissions

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