Occasional crash (signal SIGFPE) is being observed while sqlite3_prepare_v2() is being performed for following SQLite query. Same query run fine usually but crashes once in a while.
Query:
"SELECT column1, column2, column3, column4, column5, column6 FROM MetaDataTable WHERE column1=? COLLATE NOCASE AND column2=? COLLATE NOCASE "
Back trace:
Program terminated with signal SIGFPE, Arithmetic exception.
#0 raise (sig=8) at ../sysdeps/unix/sysv/linux/raise.c:50
(gdb) bt
#0 raise (sig=8) at ../sysdeps/unix/sysv/linux/raise.c:50
#1 0x48c26e3c in __aeabi_ldiv0 () at ../../../../../../../work-shared/gcc-8.2.0-r0/gcc-8.2.0/libgcc/config/arm/lib1funcs.S:1545
#2 0x48b68b00 in findElementWithHash (pH=pH@entry=0xe2064, pKey=pKey@entry=0xa6c24be4 "NOCASE", pHash=pHash@entry=0x0)
at ../sqlite-autoconf-3310100/sqlite3.c:32688
#3 0x48b760e4 in sqlite3HashFind (pKey=0xa6c24be4 "NOCASE", pH=0xe2064) at ../sqlite-autoconf-3310100/sqlite3.c:32843
#4 findCollSeqEntry (db=db@entry=0xe1ed0, zName=zName@entry=0xa6c24be4 "NOCASE", create=0) at ../sqlite-autoconf-3310100/sqlite3.c:48727
#5 0x48ba24fc in sqlite3FindCollSeq (create=0, zName=0xa6c24be4 "NOCASE", enc=1 '\001', db=0xe1ed0) at ../sqlite-autoconf-3310100/sqlite3.c:114317
#6 sqlite3GetCollSeq (pParse=pParse@entry=0xaefff098, enc=<optimized out>, pColl=0x0, zName=0xa6c24be4 "NOCASE")
at ../sqlite-autoconf-3310100/sqlite3.c:48816
#7 0x48ba3d64 in sqlite3ExprCollSeq (pParse=0xaefff098, pExpr=<optimized out>) at ../sqlite-autoconf-3310100/sqlite3.c:98853
#8 0x48ba8884 in whereScanNext (pScan=0xaeffe734) at ../sqlite-autoconf-3310100/sqlite3.c:144115
#9 0x48ba8aa0 in sqlite3WhereFindTerm (pWC=pWC@entry=0xa6c21a38, iCur=iCur@entry=0, iColumn=iColumn@entry=0, notReady=0, op=op@entry=130,
pIdx=pIdx@entry=0x119f70) at ../sqlite-autoconf-3310100/sqlite3.c:144252
#10 0x48be2df0 in whereShortCut (pBuilder=0x0, pBuilder=0x0) at ../sqlite-autoconf-3310100/sqlite3.c:148298
#11 sqlite3WhereBegin (pParse=pParse@entry=0xaefff098, pTabList=0xa6c240b0, pTabList@entry=0x0, pWhere=pWhere@entry=0x0, pOrderBy=<optimized out>,
pResultSet=0xa6c22800, wctrlFlags=7888, wctrlFlags@entry=60280, iAuxArg=320) at ../sqlite-autoconf-3310100/sqlite3.c:17587
#12 0x48bd088c in sqlite3Select (pParse=pParse@entry=0xaefff098, p=<optimized out>, pDest=0x804000, pDest@entry=0xaeffeb70)
at ../sqlite-autoconf-3310100/sqlite3.c:134081
#13 0x48c010a4 in yy_reduce (yyLookahead=<optimized out>, pParse=<optimized out>, yyLookaheadToken=..., yyruleno=1219997008, yypParser=0xaeffeb88)
at ../sqlite-autoconf-3310100/sqlite3.c:155887
#14 sqlite3Parser (yyminor=..., yymajor=<optimized out>, yyp=0xaeffeb88) at ../sqlite-autoconf-3310100/sqlite3.c:26109
#15 sqlite3RunParser (pParse=pParse@entry=0xaefff098, zSql=<optimized out>,
zSql@entry=0x16e4f0 "SELECT column1, column2, column3, column4, column5, column6 FROM MetaDataTable WHERE column1=? COLLATE NOCASE AND column2=? COLLATE NOCASE ", pzErrMsg=pzErrMsg@entry=0xaefff088) at ../sqlite-autoconf-3310100/sqlite3.c:27383
#16 0x48c0600c in sqlite3Prepare (db=db@entry=0xe1ed0,
zSql=zSql@entry=0x16e4f0 "SELECT column1, column2, column3, column4, column5, column6 FROM MetaDataTable WHERE column1=? COLLATE NOCASE AND column2=? COLLATE NOCASE ", nBytes=nBytes@entry=171, prepFlags=prepFlags@entry=128, pReprepare=pReprepare@entry=0x0,
ppStmt=ppStmt@entry=0xaefff250, pzTail=pzTail@entry=0x0) at ../sqlite-autoconf-3310100/sqlite3.c:127575
#17 0x48c06394 in sqlite3LockAndPrepare (db=0xe1ed0,
zSql=0x16e4f0 "SELECT column1, column2, column3, column4, column5, column6 FROM MetaDataTable WHERE column1=? COLLATE NOCASE AND column2=? COLLATE NOCASE ", nBytes=171, prepFlags=128, pOld=0x0, ppStmt=0xaefff250, pzTail=0x0) at ../sqlite-autoconf-3310100/sqlite3.c:127647
#18 0x48c064cc in sqlite3_prepare_v2 (db=<optimized out>,
zSql=zSql@entry=0x16e4f0 "SELECT column1, column2, column3, column4, column5, column6 FROM MetaDataTable WHERE column1=? COLLATE NOCASE AND column2=? COLLATE NOCASE ", nBytes=<optimized out>, ppStmt=ppStmt@entry=0xaefff250, pzTail=pzTail@entry=0x0)
at ../sqlite-autoconf-3310100/sqlite3.c:127731