Page 1 of 1

SQL Table Missing

Posted: Tue Sep 01, 2015 8:27 pm
by mhammett

I added an IMAP account to my otherwise Zimbra & GMAIl only Zimbra Desktop today. In a short order afterwards, I was getting errors when sending e-mail. I could receive all new messages, but read status wasn't syncing properly and I couldn't send.

I tried a bunch of things server level thinking the servers were jacked up, but I later discovered that web mail worked fine. I tried resetting the GAL and the index, but still broken, finally I tried resetting accounts. The first one worked. The second account I tried to reset gave me this:

Failure communicating with remote server. Please try again later.
(debug info)
[SQLITE_ERROR] SQL error or missing database (no such table: mboxgroup2.tombstone) Exception:

com.zimbra.common.service.ServiceException: system failure: reading tombstones since change: 0
at com.zimbra.common.service.ServiceException.FAILURE(
at com.zimbra.cs.db.DbMailItem.readTombstones(
at com.zimbra.cs.mailbox.Mailbox.getTombstones(
at com.zimbra.cs.mailbox.PushChanges.sync(
at com.zimbra.cs.mailbox.PushChanges.sync(
at com.zimbra.cs.mailbox.MailboxSync.sync(
at com.zimbra.cs.mailbox.ZcsMailbox.sync(
at com.zimbra.cs.mailbox.ZcsMailbox.syncOnTimer(
at com.zimbra.cs.mailbox.SyncMailbox$
at java.util.TimerThread.mainLoop(Unknown Source)
at Source)
Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such table: mboxgroup2.tombstone)
at org.sqlite.DB.newSQLException(
at org.sqlite.DB.newSQLException(
at org.sqlite.DB.throwex(
at org.sqlite.NativeDB.prepare(Native Method)
at org.sqlite.DB.prepare(
at org.sqlite.PrepStmt.(
at org.sqlite.Conn.prepareStatement(
at org.sqlite.Conn.prepareStatement(
at org.sqlite.Conn.prepareStatement(
at com.zimbra.cs.db.RetryConnection$1.execute(
at com.zimbra.cs.db.AbstractRetry.doRetry(
at com.zimbra.cs.db.RetryConnection.prepareStatement(
at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(
at com.zimbra.cs.db.DbPool$Connection.prepareStatement(
at com.zimbra.cs.db.DbMailItem.readTombstones(
... 9 more

If issue persists please post description and debug information here.

Is everything just fscked?