SQL Server Compact Timed Out Waiting for a Lock

Thursday, March 28, 2013 by Karin Huber

First of all, a big thank you to our customers! Since we have added the feature to send error reports via email, we have received lots of information from you. Please keep on sending us your problems with time cockpit, so we can learn what we should improve. We really appreciate your feedback.

We definitely had one frontrunner in your error reports: SQL Server Compact timed out waiting for a lock.

SQL Server Compact timed out waiting for a lock. 
The default lock time is 2000ms for devices and 5000ms for desktops. 
The default lock timeout can be increased in the connection string using the ssce: 
default lock timeout property. 

[ Session id = 5,Thread id = 3384,Process id = 6656,Table name = SYS_SyncConfig,
Conflict type = u lock (x blocks),Resource = RID: 1048:0 ]

Cause of Error

Synchronization of the client and server database is currently in progressThis error usually occurs when you are saving a time sheet entry or some other data, and at the same time data is downloaded from the server during synchronization. In this case the database is locked until all data is downloaded. When synchronization has finished you are able to save you data again.

You can easily check if synchronization is currently in progress in the lower left corner of time cockpit. If saving data fails, just wait until you will see in the status bar that synchronization has finished. Then save your data again.

Resolution

In the next version of time cockpit (planned for May 2013) we will try to avoid this error message by waiting for the synchronization to finish before saving your data. And if synchronization really takes longer, we will at least show you a better error message.

comments powered by Disqus