Results 1 to 2 of 2

Thread: Zimbra slow

  1. #1
    Join Date
    Jul 2008
    Rep Power

    Unhappy Zimbra slow


    Last friday my server with Zimbra 5.0.6 in a RH5.0 started to be very slow in answers to network. The CPU and Memory dont have a great use. Looking mailbox.log, a found this error:

    com.zimbra.common.service.ServiceException: system failure: fetching folder data for mailbox 119
    at com.zimbra.common.service.ServiceException.FAILURE (
    at com.zimbra.cs.db.DbMailItem.getFoldersAndTags(DbMa
    at com.zimbra.cs.mailbox.Mailbox.loadFoldersAndTags(M
    at com.zimbra.cs.mailbox.Mailbox.beginTransaction(Mai
    at com.zimbra.cs.mailbox.Mailbox.beginTransaction(Mai
    at com.zimbra.cs.mailbox.Mailbox.getItemById(Mailbox. java:1938)
    at com.zimbra.cs.mailbox.Mailbox.getFolderById(Mailbo
    at com.zimbra.cs.mailbox.Mailbox.getFolderByPath(Mail
    at com.zimbra.cs.imap.ImapPath.getFolder(ImapPath.jav a:315)
    at com.zimbra.cs.imap.ImapPath.isVisible(ImapPath.jav a:520)
    at com.zimbra.cs.imap.ImapPath.isSelectable(ImapPath. java:493)
    at com.zimbra.cs.imap.ImapFolder.<init>(ImapFolder.ja va:111)
    at com.zimbra.cs.imap.ImapHandler.selectFolder(ImapHa
    at com.zimbra.cs.imap.ImapHandler.doSELECT(ImapHandle
    at com.zimbra.cs.imap.ImapHandler.executeRequest(Imap
    at com.zimbra.cs.imap.TcpImapHandler.processCommand(T
    at com.zimbra.cs.tcpserver.ProtocolHandler.processCon nection(
    at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Wo Source)
    Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorExceptio n: Table 'mboxgroup19.mail_item' doesn't exist

    Query being executed when exception was thrown:

    SELECT, mi.type, mi.parent_id, mi.folder_id, mi.index_id, mi.imap_id,, mi.size, mi.volume_id, mi.blob_digest, mi.unread, mi.flags, mi.tags, mi.subject,, mi.metadata, mi.mod_metadata, mi.change_date, mi.mod_content FROM mboxgroup19.mail_item AS mi WHERE mailbox_id = 119 AND type IN (1,2,13,3)
    at com.mysql.jdbc.SQLError.createSQLException(SQLErro
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2870)
    at com.mysql.jdbc.MysqlIO.sendCommand( 73)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect( :1665)
    at com.mysql.jdbc.Connection.execSQL( 3124)
    at com.mysql.jdbc.PreparedStatement.executeInternal(P
    at com.mysql.jdbc.PreparedStatement.executeQuery(Prep
    at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeQuery( 5)
    at com.zimbra.cs.db.DbMailItem.getFoldersAndTags(DbMa
    ... 18 more

    Someone have any idea of whats happened? If I need reinstall, there is one way of migrate the zimbra to other server, but without the error, but with all accounts and mailboxes?


  2. #2
    Join Date
    Nov 2006
    Rep Power


    Welcome to the forums

    Check in /opt/zimbra/logger/db/data/ for any files with .err on the end. Potentially you have a corrupt MySQL database.

Similar Threads

  1. Replies: 8
    Last Post: 01-12-2012, 01:20 AM
  2. slapd message error
    By smoke in forum Administrators
    Replies: 7
    Last Post: 04-27-2008, 03:23 PM
  3. Replies: 12
    Last Post: 02-25-2008, 06:28 PM
  4. dspam logrotate errors
    By michaeln in forum Users
    Replies: 7
    Last Post: 02-19-2007, 11:45 AM
  5. 3.1 on FC4 problems
    By cohnhead in forum Installation
    Replies: 8
    Last Post: 05-26-2006, 11:16 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