I believe it is a bug in 3.7.5. It didn't happen in 3.6.22. It causes core dump
when using "BEGIN DEFERRED TRANSACTION" in one of our application to access DB
periodically(every 1 second) . There are other applications access the same DB
periodically but using "BEGIN EXCLUSIVE/IMMEDIATE TRANSACTION". Only the
application with "BEGIN DEFERRED TRANSACTION" went to core dump. It seems that
it doesn't get the lock for some reasons and fails in assert. After changing
from "BEGIN DEFERRED TRANSACTION" to "BEGIN EXCLUSIVE TRANSACTION" in this
application, the problem is gone. The core dump report is shown as below.
ChingChang
(gdb) bt
#0 0x3370bb04 in raise () from /lib/libc.so.6
#1 0x3370d2f4 in abort () from /lib/libc.so.6
#2 0x337032a4 in __assert_fail () from /lib/libc.so.6
#3 0x100dc940 in btreeInvokeBusyHandler (pArg=0x102b3b50) at sqlite3.c:47153
#4 0x1013f1dc in sqlite3VdbeHalt (p=0x103ae298) at sqlite3.c:38543
#5 0x1018fda8 in sqlite3VdbeExec (p=<value optimized out>) at sqlite3.c:63340
#6 sqlite3Step (p=0x103ae298) at sqlite3.c:59036
#7 0x101987e8 in sqlite3_step (pStmt=0x103ae298) at sqlite3.c:59101
#8 0x1016cb7c in sqlite3_exec (db=0x10856e18, zSql=0x106b3aa4 "COMMIT;",
xCallback=0, pArg=0x0, pzErrMsg=0x388a87c0) at sqlite3.c:84523
#9 0x1003f744 in SqlQuery::execw (this=0x388a8844,
sql_stmt=0x106b3aa4 "COMMIT;", context=0x101b91b8 "SlotUtilEvent.cpp",
linenum=69, warnings=<value optimized out>) at SqlQuery.cpp:281
#10 0x10089db8 in SlotUtilEvent::run (this=0x10a81e94) at SlotUtilEvent.cpp:94
#11 0x10003f40 in HwMonListener::run (this=0x106b28a8)
at
/mnt/local/cch/bugfix_test_11_01_02232011/isg6000/isg6k/mgmt-crd/linuxapps/hwmon/hwmon.cpp:1993
#12 0x10025c8c in Thread::start_thread (arg=0x106b28a8) at thread.cpp:199
#13 0x334265cc in ?? () from /lib/libpthread.so.0
#14 0x337b0b88 in clone () from /lib/libc.so.6
Backtrace stopped: previous frame inner to this frame (corrupt stack?)
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
