Hi All, 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. One thing to notice that, I never hit this issue when i was using 3.8.10.2 for couple of months. First time i hit the issue only after updating 3.15.2 recently. 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 <COLUMNS> FROM <TABLE_NAME> WHERE <CONDITION>"..., 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 <COLUMNS> FROM <TABLE_NAME> WHERE <CONDITION> "..., 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 <COLUMNS> FROM <TABLE_NAME> WHERE <CONDITION>"..., 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 <COLUMNS> FROM <TABLE_NAME> WHERE <CONDITION> "..., 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