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