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.
regards _______________________________________________ sqlite-users mailing list firstname.lastname@example.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users