Repository navigation
Intermittently crashes when sqlite3_prepare_v2 called with sqlite version 3.15.2 #976
Description
Details for the issue
I am using sqlite in multi-threaded environment where multiple applications use sqlite queries to perform get/set operations on attributes available in sqlite db tables. Intermittently i am seeing applications crashing when get operation is performed which intern call sqlite3_prepare_v2.
Crash is not frequent. I rarely see this issue. One thing to notice that, I never hit this issue when i was using 3.8.10.2. First time i hit the issue only after updating 3.15.2.
Following is the GDB back trace for the same. Please let me know if this is a known issue and if its fixed in latest sqlite version.
#0 0x4ffc9494 in __aeabi_memcpy8 () at ../sysdeps/arm/armv7/multiarch/memcpy_impl.S:352
#1 0x4194d514 in whereLoopXfer (pFrom=0x19a560, pTo=0x1c14d0, db=) at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:129646
#2 whereLoopInsert (pTemplate=pTemplate@entry=0x19a560, pBuilder=0x1c2858, pBuilder=0x1c2858) at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:64414
#3 0x419700f0 in whereLoopAddBtree (pBuilder=0x1c2858, pBuilder@entry=0x0, mPrereq=7281790634533488) at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:130653
#4 0x419892fc in whereLoopAddAll (pBuilder=0x0) at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:131229
#5 sqlite3WhereBegin (pParse=pParse@entry=0xbec43e68, pTabList=0x0, pTabList@entry=0x1c2850, pWhere=pWhere@entry=0xbec43cd0, pOrderBy=, pDistinctSet=0x1c2e50,
wctrlFlags=48760, iAuxArg=320) at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:1283
#6 0x4198d8e0 in sqlite3Select (pParse=pParse@entry=0xbec43e68, p=, pDest=0x0, pDest@entry=0xbec43e08)
at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:119546
#7 0x419b8358 in yy_reduce (yyruleno=, yypParser=0x1b2990) at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:135340
#8 sqlite3Parser (pParse=0xbec43e68, yyminor=..., yymajor=, yyp=) at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:5377
#9 sqlite3RunParser (pParse=pParse@entry=0xbec43e68, zSql=0xe8 <error: Cannot access memory at address 0xe8>,
zSql@entry=0x198248 "SELECT FROM
#10 0x419bdae8 in sqlite3Prepare (db=db@entry=0x19be78,
zSql=zSql@entry=0x198248 "SELECT FROM
pzTail=pzTail@entry=0x0) at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:114126
#11 0x419bdfb4 in sqlite3LockAndPrepare (db=0x19be78,
zSql=0x198248 "SELECT FROM
#12 0x419be27c in sqlite3_prepare_v2 (db=,
zSql=zSql@entry=0x198248 "SELECT FROM
at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:114293
Useful extra information
I'm opening this issue because:
- DB4S is crashing
- DB4S has a bug
- DB4S needs a feature
- DB4S has another problem
I'm using DB4S on:
- Windows: ( version: ___ )
- Linux: ( distro: ___ )
- Mac OS: ( version: ___ )
- Other: ___
I'm using DB4S version:
- 3.9.1
- 3.9.0
- Other: ___
I have also:
- Tried out the nightly version: https://github.com/sqlitebrowser/sqlitebrowser#windows
- Searched for an existing similar issue: https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20
Activity
justinclift commentedon Mar 8, 2017
Interesting. Would you be ok to run
lddon the sqlitebrowser executable and paste the result here? It sounds like there might be a linking problem.Er... just to confirm, you are using sqlitebrowser yeah, not straight SQLite itself?
romio102 commentedon Mar 8, 2017
@justinclift ,
I downloaded SQLite tarball (sqlite-autoconf-3150200.tar.gz) from https://sqlite.org/download.html and I am using SQLite as library itself. Not using SQLite browser.
Also, i guess if its a linking problem then i should face the problem every time using SQLite APIs. But i am facing this issue once in a while and its quiet random.
chrisjlocke commentedon Mar 9, 2017
You have posted this question on the DB Browser for SQLite support issue system. This is for support for the application DB Browser for SQLite - not SQLite itself.
You can post your question to the SQLite support group by emailing the question to sqlite-users@mailinglists.sqlite.org
romio102 commentedon Mar 9, 2017
Sure. I will drop a mail to SQLite support group. Thanks for the help.
justinclift commentedon Mar 9, 2017
@romio102 No worries at all. Hopefully you get it solved. 😄