Page 1 of 1

Zimbra Desktop database locked

Posted: Sat May 07, 2016 3:31 pm
by mhammett
I'm getting a bunch of these. By a bunch, I meant... hundreds per minute.

Code: Select all

2016-05-07 10:26:47,548 WARN  [sync-mbox-[redacted]] [] dbconn - retrying connection attempt:1 due to possibly recoverable exception:
java.sql.SQLException: [SQLITE_BUSY]  The database file is locked (database is locked)
   at org.sqlite.DB.newSQLException(
   at org.sqlite.DB.newSQLException(
   at org.sqlite.DB.execute(
   at org.sqlite.DB.executeUpdate(
   at org.sqlite.PrepStmt.executeUpdate(
   at com.zimbra.cs.db.DebugPreparedStatement.executeUpdate(
   at com.zimbra.cs.db.RetryPreparedStatement.superExecuteUpdate(
   at com.zimbra.cs.db.RetryPreparedStatement.access$800(
   at com.zimbra.cs.db.RetryPreparedStatement$9.execute(
   at com.zimbra.cs.db.AbstractRetry.doRetry(
   at com.zimbra.cs.db.RetryPreparedStatement.executeUpdate(
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(
   at com.zimbra.cs.db.DbMailItem.alterTag(
   at com.zimbra.cs.mailbox.Folder.alterTag(
   at com.zimbra.cs.mailbox.MailItem.setTags(
   at com.zimbra.cs.mailbox.ZcsMailbox.syncMetadata(
   at com.zimbra.cs.mailbox.DeltaSync.syncFolder(
   at com.zimbra.cs.mailbox.InitialSync.syncFolder(
   at com.zimbra.cs.mailbox.InitialSync.syncContainer(
   at com.zimbra.cs.mailbox.InitialSync.initialFolderSync(
   at com.zimbra.cs.mailbox.InitialSync.resume(
   at com.zimbra.cs.mailbox.InitialSync.resume(
   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)

Re: Zimbra Desktop database locked

Posted: Sat May 07, 2016 6:13 pm
by jorgedlcruz
Which version of Zimbra Desktop are you running? It was any change in your computer or so?

Best regards

Re: Zimbra Desktop database locked

Posted: Sat May 07, 2016 6:39 pm
by mhammett

I had to completely re-install ZD to resolve a different problem, but nothing system-wide.

If I close ZD and re-open it, it works for a few seconds.

It does generate hundreds of those locked DB errors per minute.

Re: Zimbra Desktop database locked

Posted: Sat May 07, 2016 8:52 pm
by mhammett
Frak, looks like everything has gone to crap again.

ZD is *very* delicate.

Re: Zimbra Desktop database locked

Posted: Mon May 09, 2016 2:06 pm
by DualBoot
At this point, maybe you should try with 7.2.8 RC ?