Zimbra Desktop database locked

If Zimbra Desktop had a sync failure, it may have told you to post your error in this section.
mhammett
Advanced member
Advanced member
Posts: 100
Joined: Sat Jul 19, 2014 7:07 am
ZCS/ZD Version: Release 8.6.0.GA.1153.UBUNTU14.64 U

Zimbra Desktop database locked

Postby mhammett » Sat May 07, 2016 3:31 pm

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)


Release 8.6.0.GA.1153.UBUNTU14.64 UBUNTU14_64 FOSS edition.
User avatar
jorgedlcruz
Zimbra Alumni
Zimbra Alumni
Posts: 2773
Joined: Thu May 22, 2014 4:47 pm

Re: Zimbra Desktop database locked

Postby jorgedlcruz » Sat May 07, 2016 6:13 pm

Hello,
Which version of Zimbra Desktop are you running? It was any change in your computer or so?

Best regards
Jorge de la Cruz https://jorgedelacruz.es
Systems Engineer at Veeam Software https://www.veeam.com/
mhammett
Advanced member
Advanced member
Posts: 100
Joined: Sat Jul 19, 2014 7:07 am
ZCS/ZD Version: Release 8.6.0.GA.1153.UBUNTU14.64 U

Re: Zimbra Desktop database locked

Postby mhammett » Sat May 07, 2016 6:39 pm

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.
Release 8.6.0.GA.1153.UBUNTU14.64 UBUNTU14_64 FOSS edition.
mhammett
Advanced member
Advanced member
Posts: 100
Joined: Sat Jul 19, 2014 7:07 am
ZCS/ZD Version: Release 8.6.0.GA.1153.UBUNTU14.64 U

Re: Zimbra Desktop database locked

Postby mhammett » Sat May 07, 2016 8:52 pm

Frak, looks like everything has gone to crap again.

ZD is *very* delicate.
Release 8.6.0.GA.1153.UBUNTU14.64 UBUNTU14_64 FOSS edition.
User avatar
DualBoot
Elite member
Elite member
Posts: 1090
Joined: Mon Apr 18, 2016 8:18 pm
Location: France - Earth
ZCS/ZD Version: ZCS FLOSS - 8.8.15 Mutli servers
Contact:

Re: Zimbra Desktop database locked

Postby DualBoot » Mon May 09, 2016 2:06 pm

Hi,
At this point, maybe you should try with 7.2.8 RC ?
The Guy - DualBoot

PostMaster - WikiMaster - SysAdmin
"Free Your Mind. Think Open Source"
april.org
Zetalliance Member - zetalliance.org

Return to “Error Reports”

Who is online

Users browsing this forum: No registered users and 4 guests