Results 1 to 2 of 2

Thread: Zimbra slow

  1. #1
    wjro00 is offline Junior Member
    Join Date
    Jul 2008
    Posts
    5
    Rep Power
    6

    Unhappy Zimbra slow

    Hello,

    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
    ExceptionId:ImapServer-1334:1216644413131:a07fe779da1b5c93
    Code:service.FAILURE
    at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:253)
    at com.zimbra.cs.db.DbMailItem.getFoldersAndTags(DbMa ilItem.java:1568)
    at com.zimbra.cs.mailbox.Mailbox.loadFoldersAndTags(M ailbox.java:1465)
    at com.zimbra.cs.mailbox.Mailbox.beginTransaction(Mai lbox.java:1190)
    at com.zimbra.cs.mailbox.Mailbox.beginTransaction(Mai lbox.java:1138)
    at com.zimbra.cs.mailbox.Mailbox.getItemById(Mailbox. java:1938)
    at com.zimbra.cs.mailbox.Mailbox.getFolderById(Mailbo x.java:2723)
    at com.zimbra.cs.mailbox.Mailbox.getFolderByPath(Mail box.java:2760)
    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 ndler.java:1148)
    at com.zimbra.cs.imap.ImapHandler.doSELECT(ImapHandle r.java:1110)
    at com.zimbra.cs.imap.ImapHandler.executeRequest(Imap Handler.java:604)
    at com.zimbra.cs.imap.TcpImapHandler.processCommand(T cpImapHandler.java:125)
    at com.zimbra.cs.tcpserver.ProtocolHandler.processCon nection(ProtocolHandler.java:160)
    at com.zimbra.cs.tcpserver.ProtocolHandler.run(Protoc olHandler.java:128)
    at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Wo rker.run(Unknown Source)
    at java.lang.Thread.run(Thread.java:595)
    Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorExceptio n: Table 'mboxgroup19.mail_item' doesn't exist

    Query being executed when exception was thrown:

    SELECT mi.id, mi.type, mi.parent_id, mi.folder_id, mi.index_id, mi.imap_id, mi.date, mi.size, mi.volume_id, mi.blob_digest, mi.unread, mi.flags, mi.tags, mi.subject, mi.name, 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 r.java:936)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2870)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:15 73)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1665)
    at com.mysql.jdbc.Connection.execSQL(Connection.java: 3124)
    at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:1149)
    at com.mysql.jdbc.PreparedStatement.executeQuery(Prep aredStatement.java:1262)
    at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeQuery(DelegatingPreparedStatement.java:20 5)
    at com.zimbra.cs.db.DbMailItem.getFoldersAndTags(DbMa ilItem.java:1481)
    ... 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?

    att,

  2. #2
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,016
    Rep Power
    24

    Default

    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.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 8
    Last Post: 01-12-2012, 02: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, 07:28 PM
  4. dspam logrotate errors
    By michaeln in forum Users
    Replies: 7
    Last Post: 02-19-2007, 12:45 PM
  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
  •