Hello, I am using sqlite as library 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. Could anyone please help me with this? 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 <https://github.com/sqlitebrowser/sqlitebrowser/pull/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 <https://github.com/sqlitebrowser/sqlitebrowser/issues/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 <https://github.com/sqlitebrowser/sqlitebrowser/pull/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 <https://github.com/sqlitebrowser/sqlitebrowser/issues/4> 0x419892fc in whereLoopAddAll (pBuilder=0x0) at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:131229 #5 <https://github.com/sqlitebrowser/sqlitebrowser/issues/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 <https://github.com/sqlitebrowser/sqlitebrowser/issues/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 <https://github.com/sqlitebrowser/sqlitebrowser/issues/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 <https://github.com/sqlitebrowser/sqlitebrowser/issues/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 <https://github.com/sqlitebrowser/sqlitebrowser/issues/9> sqlite3RunParser (pParse=pParse@entry=0xbec43e68, zSql=0xe8 <error: Cannot access memory at address 0xe8>, zSql@entry=0x198248 "SELECT FROM WHERE "..., pzErrMsg=0x1c1dd0, pzErrMsg@entry=0xbec43e58) at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:6324 #10 <https://github.com/sqlitebrowser/sqlitebrowser/issues/10> 0x419bdae8 in sqlite3Prepare (db=db@entry=0x19be78, zSql=zSql@entry=0x198248 "SELECT FROMWHERE "..., nBytes=nBytes@entry=233, saveSqlFlag=-1094435176, saveSqlFlag@entry=1, pReprepare=pReprepare@entry=0x0, ppStmt=ppStmt@entry=0xbec440d8, pzTail=pzTail@entry=0x0) at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:114126 #11 <https://github.com/sqlitebrowser/sqlitebrowser/issues/11> 0x419bdfb4 in sqlite3LockAndPrepare (db=0x19be78, zSql=0x198248 "SELECT FROMWHERE "..., nBytes=233, saveSqlFlag=1, pOld=0x0, ppStmt=0xbec440d8, pzTail=0x0) at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:114217 #12 <https://github.com/sqlitebrowser/sqlitebrowser/issues/12> 0x419be27c in sqlite3_prepare_v2 (db=, zSql=zSql@entry=0x198248 "SELECT FROMWHERE "..., nBytes=, ppStmt=ppStmt@entry=0xbec440d8, pzTail=pzTail@entry=0x0) at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:114293
Thanks, Rochak Gupta _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
