That is the case, thank you!
śr., 4 lip 2018 o 18:15 Dan Kennedy <danielk1...@gmail.com> napisał(a):
>
> 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
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to