Creating a separate connection for the SELECTs does not seem to solve
the problem. What is the preferred way of tackling such a scenario? I
guarded all the calls with a mutex, but it did not help.
śr., 4 lip 2018 o 19:34 Wojtek Mamrak <wmam...@gmail.com> napisał(a):
>
> 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