On Mon, May 16, 2011 at 11:59 AM, ChingChang Hsiao <
chingchang.hs...@overturenetworks.com> wrote:

> I have sent the core dump in the previous email. And I found that one
> thread receives an event and access DB at the same time with another thread
> accesses the same DB. It happens in the heavy load for DB access. Is there a
> way to prevent this core dump?
>
> Use -DSQLITE_THREADSAFE=1.  The use of -DSQLITE_THREADSAFE=2 is not
sufficient if you have multiple threads using the same database connection.


> ChingChang
>
>
> Version is 3.7.5
> journal mode = DELETE
> SELECT sqlite_source_id(); 2011-01-28 17:03:50
> ed759d5a9edb3bba5f48f243df47be29e3fe8cd7
>
> OTHER_FLAGS=-DSQLITE_THREADSAFE=2  -DSQLITE_THREAD_OVERRIDE_LOCK=-1
> -DSQLITE_DEBUG=1
> CFLAGS += -O0 -w $(OTHER_FLAGS)
> in Makefile
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to