Results 1 to 1 of 1

Thread: ZCS Critical Bug Alert

  1. #1
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default ZCS Critical Bug Alert

    I. Description
    There is a bug in ZCS where the mailbox server may delete data that contains information about user mailboxes. This information includes folder names, a list of messages stored in those folders, contacts, user-defined tags, and more. This behavior occurs under certain, unlikely error conditions, but if encountered the users will be unable to login and a full restore of the impacted mailboxes will be required. To prevent any possible data loss on your system we recommend that you follow the steps below to patch all mailbox stores in your system as soon as possible.

    II. Impact
    ZCS 4.5.0 and greater are affected. ZCS 4.0.x and 3.1.x are not affected.

    We have discovered a lack of robustness in our code to handle MySQL error conditions. Under certain combinations of conditions, such as errors in connectivity to the database during mailbox creation, a Zimbra server can drop mailbox group databases. Mailbox group databases store the metadata for a set of user mailboxes. Metadata includes user folder names, a list of messages in those folders, contacts, user-defined tags, and most other information about the mailbox that is not in the actual messages. The loss of the mailbox group database will prevent logins for all users that were in the mailbox group database. On average a mailbox group database has 1% of the users on a server. This error can happen repeatedly, impacting a different mailbox group database with each occurrence.

    Details of this bug can be found in http://bugzilla.zimbra.com/show_bug.cgi?id=16879.

    This is a critical data loss issue. Any mailboxes affected by this bug will have to be restored from backups.

    ZCS 4.5.6 will include the fix for this issue.

    III. Solution
    This can be done on a live server without taking the server offline. We recommend that all Zimbra administrators perform the following workaround immediately by editing the file:

    /opt/zimbra/db/create_database.sql

    and *REMOVE* the following line of SQL code (it should be just below the license preamble text) in that file:

    Code:
       DROP DATABASE IF EXISTS ${DATABASE_NAME};
    This should be done on all servers with a mailbox store. This file is re-read each time a mailbox is created, and therefore can be edited without a server restart. We recommend the follow sequence of steps if you choose to edit the file while the server is running

    (commands should be executed as the 'zimbra' Unix user):
    Code:
       cd /opt/zimbra/db
    
       cp create_database.sql create_database.sql.orig
    
       cp create_database.sql create_database.sql.edit
    (commands should be executed as the 'root' Unix user):

    * edit (vi, emacs etc) create_database.sql.edit to remove line *

    Code:
       mv create_database.sql.edit create_database.sql
    The Unix mv command is atomic, and if you follow the above steps, the server will not see an inconsistent copy of this script.

    Network Edition Customers: If you have any questions or would like assistance please contact Zimbra Support via the Support Portal.

    Open Source Users: If you have any questions, please confine them to the thread in the administrators forum. You can also private message jholder, KevinH, or Phoenix with any private questions or comments.
    Last edited by gmsmith; 05-17-2007 at 05:22 PM. Reason: modification of permissions required

Similar Threads

  1. Trouble Sending mail - All Messages deferred!
    By SiteDiscovery in forum Administrators
    Replies: 7
    Last Post: 09-03-2009, 04:52 AM
  2. ZCS Critical Bug Alert
    By jholder in forum Announcements
    Replies: 0
    Last Post: 05-17-2007, 05:00 PM
  3. ZCS 4.05 - Do two bug fixes make a release?
    By greenrenault in forum Administrators
    Replies: 7
    Last Post: 12-21-2006, 02:26 AM
  4. ZCS 3.2 Beta Available
    By KevinH in forum Announcements
    Replies: 31
    Last Post: 07-07-2006, 03:46 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
  •