Zimbra slow

[wjro00]

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,

[uxbod]

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.