SQLite.NET PCL Busy Exception

Question

We use SQLite.NET PCL in the Xamarin application.

When placing the database under pressure, inserting it into several tables, we see that exceptions from BUSY are excluded.

Can anyone explain what the difference is between BUSY and LOCKED? And what makes the BASE BE?

Our code uses one connection to a database created using the following code:

var connectionString = new SQLiteConnectionString(GetDefaultConnectionString(), 
                                                      _databaseConfiguration.StoreTimeAsTicks);
var connectionWithLock = new SQLiteConnectionWithLock(new SQLitePlatformAndroid(), connectionString);

return new SQLiteAsyncConnection (() => { return connectionWithLock; });

Answer 1

, , , , , , , , . , ,

:

, , , .

, , , , .

Answer 2

... , ...

, async - , , , . , . , , FIFO . , X , Exception.

SQLiteBusyException - , , SQLite SQLITE_BUSY SQLITE_IOERR_BLOCKED. , , .

SQLiteConnection.setBusyTimeout(long), SQLite , .

: http://www.sqlite.org/lockingv3.html

: http://sqlite.org/capi3ref.html#sqlite3_busy_timeout