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]@ics-il.net] [] 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(DB.java:383)
   at org.sqlite.DB.newSQLException(DB.java:387)
   at org.sqlite.DB.execute(DB.java:339)
   at org.sqlite.DB.executeUpdate(DB.java:363)
   at org.sqlite.PrepStmt.executeUpdate(PrepStmt.java:85)
   at com.zimbra.cs.db.DebugPreparedStatement.executeUpdate(DebugPreparedStatement.java:169)
   at com.zimbra.cs.db.RetryPreparedStatement.superExecuteUpdate(RetryPreparedStatement.java:171)
   at com.zimbra.cs.db.RetryPreparedStatement.access$800(RetryPreparedStatement.java:30)
   at com.zimbra.cs.db.RetryPreparedStatement$9.execute(RetryPreparedStatement.java:164)
   at com.zimbra.cs.db.AbstractRetry.doRetry(AbstractRetry.java:58)
   at com.zimbra.cs.db.RetryPreparedStatement.executeUpdate(RetryPreparedStatement.java:167)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
   at com.zimbra.cs.db.DbMailItem.alterTag(DbMailItem.java:1279)
   at com.zimbra.cs.mailbox.Folder.alterTag(Folder.java:965)
   at com.zimbra.cs.mailbox.MailItem.setTags(MailItem.java:1950)
   at com.zimbra.cs.mailbox.ZcsMailbox.syncMetadata(ZcsMailbox.java:511)
   at com.zimbra.cs.mailbox.DeltaSync.syncFolder(DeltaSync.java:607)
   at com.zimbra.cs.mailbox.InitialSync.syncFolder(InitialSync.java:540)
   at com.zimbra.cs.mailbox.InitialSync.syncContainer(InitialSync.java:439)
   at com.zimbra.cs.mailbox.InitialSync.initialFolderSync(InitialSync.java:262)
   at com.zimbra.cs.mailbox.InitialSync.resume(InitialSync.java:227)
   at com.zimbra.cs.mailbox.InitialSync.resume(InitialSync.java:211)
   at com.zimbra.cs.mailbox.MailboxSync.sync(MailboxSync.java:190)
   at com.zimbra.cs.mailbox.ZcsMailbox.sync(ZcsMailbox.java:124)
   at com.zimbra.cs.mailbox.ZcsMailbox.syncOnTimer(ZcsMailbox.java:105)
   at com.zimbra.cs.mailbox.SyncMailbox$1.run(SyncMailbox.java:279)
   at java.util.TimerThread.mainLoop(Unknown Source)
   at java.util.TimerThread.run(Unknown Source)

Re: Zimbra Desktop database locked

Posted: Sat May 07, 2016 6:13 pm
by jorgedlcruz
Hello,
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
7.2.7

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
Hi,
At this point, maybe you should try with 7.2.8 RC ?