On 07/04/2018 11:06 PM, Wojtek Mamrak wrote:
Hello,
I have encountered a significant change in behavior between versions
3.24 and 3.23.
I have compiled SQLite using msvc 15.7.4 with SQLITE_THREADSAFE and I
am setting threading mode option to SQLITE_CONFIG_SERIALIZED before
initializing SQLite. I have a single database connection handle which
is used by several threads which insert records into a single table.
Up to version 3.23 there were no issues with this approach, even for
multiple working threads. In version 3.24 I am getting a "database
table is locked" error. Strangely enough, many times it happens during
the first INSERT execution. The insert takes place in an insert
trigger, and records are added to an rtree_i32 table.
There was this change:
https://sqlite.org/src/info/d4ce66610851c825
R-tree now prevents you from writing if the same connection currently
has an active SELECT on the same r-tree table. If you don't think this
is the case (if your app doesn't have an active SELECT) it might be a
bug. In that case can you post the database schema and the SQL statement
being executed?
Dan.
regards
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
