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.
sqlite-users mailing list