Intermittent SQLite.SQLiteException when updating

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Simple domain object: Id (PK autoincrement), CategoryId int, Title string
2. Update the object
3. SQLite.SQLiteException: Busy occurs each time

What is the expected output? What do you see instead?
Expect SQLite to update successfully.

What version of the product are you using? On what operating system?
Monotouch, lastest version

Please provide any additional information below.
The same Insert() calls works within exactly the same context. This is 
something strange to do 
with the CategoryId field.

Original issue reported on code.google.com by mrshrink...@gmail.com on 25 Apr 2010 at 11:22

[GoogleCodeExporter]

I can repro this also on Inserts quite often.
I went back to a very old version of the file and there is no problem.
The files have no version info in them so I'm not sure which version but it was 
one before the caching of the Table Mapping that was also using the 
SQLiteStatementHandle to keep track of the current handle.
I've updated my code to use the SQLIteStatementHandle around the area where now 
is Create/Finalize and I have no issues anymore.

Original comment by corneliu...@gtempaccount.com on 17 Jun 2010 at 2:35

[GoogleCodeExporter]

Please download and begin using Rev 58. There were bugs where the queries 
weren't always being finished and were leaving tables locked. Also sqlite is 
now instructed to retry itself if it does hit a locked table.

Original comment by frank.al...@gmail.com on 29 Jun 2010 at 6:50

• Changed state: Fixed