Re: [sqlite] Database is locked exceptions

2014-10-29 Thread Sohail Somani
On 2014-10-29, 12:13 PM, Mike McWhinney wrote: System.Windows.Forms.Control.ControlNativeWindow.OnThreadException(Exception e) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) at

Re: [sqlite] Database is locked exceptions

2014-10-29 Thread Simon Slavin
On 29 Oct 2014, at 4:13pm, Mike McWhinney wrote: > "URI=file:mydb.db; default timeout=10; Pooling=True; Max Pool Size=100;"; Can you please change your timeout to 1 (really, 1ms == 10 seconds) and see if this makes the problems go away ? It may not be necessary

[sqlite] Database is locked exceptions

2014-10-29 Thread Mike McWhinney
Hello, I have written a program in C# Visual Studio Winforms. In general the SQLite database is working quite well. However, lately we have been plagued with database locking errors: Here is the exeption: database is locked database is locked at