Zimbra Desktop database locked

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

Zimbra Desktop database locked

Post 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)
Release 8.8.12.GA.3794.UBUNTU14.64 UBUNTU14_64 FOSS edition.
User avatar
jorgedlcruz
Zimbra Alumni
Zimbra Alumni
Posts: 2782
Joined: Thu May 22, 2014 4:47 pm

Re: Zimbra Desktop database locked

Post by jorgedlcruz »

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: 133
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

Post 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.
Release 8.8.12.GA.3794.UBUNTU14.64 UBUNTU14_64 FOSS edition.
mhammett
Advanced member
Advanced member
Posts: 133
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

Post by mhammett »

Frak, looks like everything has gone to crap again.

ZD is *very* delicate.
Release 8.8.12.GA.3794.UBUNTU14.64 UBUNTU14_64 FOSS edition.
User avatar
DualBoot
Elite member
Elite member
Posts: 1326
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

Post by DualBoot »

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
Post Reply