GNU C (Sourcery CodeBench 2011.03-95) version 4.5.2 (mips-linux-gnu) compiled by GNU C version 4.3.2, GMP version 4.3.2, MPFR version 2.4.2, MPC version 0.8.1
On Mon, Mar 5, 2012 at 6:12 PM, Richard Hipp <d...@sqlite.org> wrote: > On Mon, Mar 5, 2012 at 7:04 AM, Sreekumar TP <sreekumar...@gmail.com> > wrote: > > > The crash is a result of -O3 flag used during compiling the library. > > > > A compiler bug, then. OK. Good to know. SQLite has previously uncovered > bugs in GCC, MSVC, and LLVM. Which compiler are you using? > > > > > > > -Sreekumar > > > > > > > > On Sat, Mar 3, 2012 at 2:00 PM, Sreekumar TP <sreekumar...@gmail.com> > > wrote: > > > > > Its does not crash on x86. I havent built the shell for my mips device. > > > > > > Sreekumar > > > On Mar 3, 2012 10:26 AM, "Dan Kennedy" <danielk1...@gmail.com> wrote: > > > > > >> On 03/03/2012 10:30 AM, Sreekumar TP wrote: > > >> > > >>> Could someone throw some light on this issue too? > > >>> > > >> > > >> I can't see from the stack trace why this is crashing. > > >> > > >> Does it crash if you run the query from the sqlite shell? > > >> > > >> Maybe try building the shell without optimizations, and > > >> then running it under valgrind. > > >> > > >> Dan. > > >> > > >> > > >> > > >>> Sreekumar > > >>> On Mar 2, 2012 10:05 AM, "Sreekumar TP"<sreekumar...@gmail.com> > > wrote: > > >>> > > >>> The backtrace > > >>>> =============== > > >>>> > > >>>> > > >>>> Program received signal SIGSEGV, Segmentation fault. > > >>>> 0x2b657288 in sqlite3Parser (yyp=0x2d401e40, yymajor=119, > yyminor=..., > > >>>> pParse=0x2d4035c8) at sqlite3.c:106740 > > >>>> 106740 }while( yymajor!=YYNOCODE&& yypParser->yyidx>=0 ); > > >>>> #0 0x2b657288 in sqlite3Parser (yyp=0x2d401e40, yymajor=119, > > >>>> yyminor=..., > > >>>> pParse=0x2d4035c8) at sqlite3.c:106740 > > >>>> yyminorunion = { > > >>>> yyinit = 735636932, > > >>>> yy0 = { > > >>>> z = 0x2bd8edc4 "FROM dir_table", > > >>>> n = 4 > > >>>> }, > > >>>> yy4 = 735636932, > > >>>> yy90 = { > > >>>> a = 735636932, > > >>>> b = 0x4 > > >>>> }, > > >>>> yy118 = { > > >>>> pExpr = 0x2bd8edc4, > > >>>> zStart = 0x4<Address 0x4 out of bounds>, > > >>>> zEnd = 0x2b697000 "" > > >>>> }, > > >>>> yy203 = 0x2bd8edc4, > > >>>> yy210 = 196 '\304', > > >>>> yy215 = { > > >>>> value = 735636932, > > >>>> mask = 4 > > >>>> }, > > >>>> yy259 = 0x2bd8edc4, > > >>>> yy292 = { > > >>>> pLimit = 0x2bd8edc4, > > >>>> pOffset = 0x4 > > >>>> }, > > >>>> yy314 = 0x2bd8edc4, > > >>>> yy322 = 0x2bd8edc4, > > >>>> yy342 = { > > >>>> eOperator = { > > >>>> z = 0x2bd8edc4 "FROM dir_table", > > >>>> n = 4 > > >>>> }, > > >>>> not = 728330240 > > >>>> }, > > >>>> yy384 = 0x2bd8edc4, > > >>>> yy387 = 0x2bd8edc4 > > >>>> } > > >>>> yyact = 21104640 > > >>>> yyendofinput = 0 > > >>>> yypParser = 0x2d401e40 > > >>>> #1 0x2b65a210 in sqlite3RunParser (pParse=0x2d4035c8, > zSql=0x2bd8eda4 > > >>>> "SELECT COUNT(distinct Alb_Name) FROM dir_table", > pzErrMsg=0x2bd8cbf8) > > >>>> at > > >>>> sqlite3.c:107465 > > >>>> nErr = 0 > > >>>> i = 36 > > >>>> pEngine = 0x2d401e40 > > >>>> tokenType = 119 > > >>>> lastTokenParsed =<value optimized out> > > >>>> enableLookaside = 1 '\001' > > >>>> db = 0x6a14b0 > > >>>> mxSqlLen = 1000000000 > > >>>> #2 0x2b65ac68 in sqlite3Prepare (db=0x6a14b0, zSql=0x2bd8eda4 > "SELECT > > >>>> COUNT(distinct Alb_Name) FROM dir_table", nBytes=-1, saveSqlFlag=0, > > >>>> pReprepare=0x0, ppStmt=0x2bd8cca8, pzTail=0x0) at sqlite3.c:90212 > > >>>> pParse = 0x2d4035c8 > > >>>> zErrMsg = 0x0 > > >>>> rc =<value optimized out> > > >>>> i =<value optimized out> > > >>>> #3 0x2b65b468 in sqlite3LockAndPrepare (db=<value optimized out>, > > >>>> zSql=<value optimized out>, nBytes=-1, ppStmt=<value optimized out>, > > >>>> pzTail=0x0) at sqlite3.c:90304 > > >>>> rc =<value optimized out> > > >>>> #4 sqlite3_prepare (db=<value optimized out>, zSql=<value optimized > > >>>> out>, > > >>>> nBytes=-1, ppStmt=<value optimized out>, pzTail=0x0) at > > sqlite3.c:24831 > > >>>> rc = 21104640 > > >>>> #5 0x00466730 in sql_stmt (db=9, stmt=0xffffffc0<Address 0xffffffc0 > > out > > >>>> of bounds>) at /localhome/user/a/b/c/d/e/f/g/**h/k.c:496 > > >>>> errmsg = 0x0 > > >>>> retval =<value optimized out> > > >>>> __PRETTY_FUNCTION__ = "\000\000\000\000\000\000\000\**000" > > >>>> > > >>>> > > >>>> > > >>>> ================ > > >>>> > > >>>> > > >>>> > > >>>> > > >>>> On Thu, Mar 1, 2012 at 11:42 PM, Dan Kennedy<danielk1...@gmail.com > >** > > >>>> wrote: > > >>>> > > >>>> On 03/01/2012 10:54 PM, Sreekumar TP wrote: > > >>>>> > > >>>>> version 3.7.7.1 > > >>>>>> The query works on x86, but fails on MIPS processor! > > >>>>>> > > >>>>>> > > >>>>> Are you able to post a stack trace? Ideally generated by > > >>>>> the gdb "where full" command. Thanks. > > >>>>> > > >>>>> Dan. > > >>>>> > > >>>>> > > >>>>> > > >>>>> > > >>>>>> Sreekumar > > >>>>>> > > >>>>>> > > >>>>>> > > >>>>>> On Thu, Mar 1, 2012 at 7:00 PM, Dan Kennedy<danielk1...@gmail.com > > > > >>>>>> wrote: > > >>>>>> > > >>>>>> On 03/01/2012 05:48 PM, Sreekumar TP wrote: > > >>>>>> > > >>>>>>> > > >>>>>>> In my system, the statement causes sqlite3parser function to > > crash. > > >>>>>>> > > >>>>>>>> My compiler is mips , little endian, gcc version is 4.5.2 > > >>>>>>>> > > >>>>>>>> > > >>>>>>>> SQLite version? 3.7.10 seems Ok here. > > >>>>>>> > > >>>>>>> Dan. > > >>>>>>> > > >>>>>>> ______________________________******_________________ > > >>>>>>> sqlite-users mailing list > > >>>>>>> sqlite-users@sqlite.org > > >>>>>>> http://sqlite.org:8080/cgi-******bin/mailman/listinfo/sqlite-*** > > >>>>>>> ***users< > > http://sqlite.org:8080/cgi-****bin/mailman/listinfo/sqlite-****users> > > >>>>>>> <http://sqlite.org:**8080/cgi-**bin/mailman/** > > >>>>>>> listinfo/sqlite-**users< > > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users> > > >>>>>>> > > > >>>>>>> <http://sqlite.org:8080/**cgi-**bin/mailman/listinfo/**sqlite-** > > >>>>>>> users< > > http://sqlite.org:8080/**cgi-bin/mailman/listinfo/**sqlite-users> > > >>>>>>> < > http://sqlite.org:8080/**cgi-bin/mailman/listinfo/**sqlite-users< > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > > >>>>>>> > > > >>>>>>> > > >>>>>>>> > > >>>>>>>> > > >>>>>>> ______________________________****_________________ > > >>>>>>> > > >>>>>> sqlite-users mailing list > > >>>>>> sqlite-users@sqlite.org > > >>>>>> > > http://sqlite.org:8080/cgi-****bin/mailman/listinfo/sqlite-****users< > > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users> > > >>>>>> <http://sqlite.org:8080/**cgi-bin/mailman/listinfo/**sqlite-users > < > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > > >>>>>> > > > >>>>>> > > >>>>>> > > >>>>>> ______________________________****_________________ > > >>>>> sqlite-users mailing list > > >>>>> sqlite-users@sqlite.org > > >>>>> > http://sqlite.org:8080/cgi-****bin/mailman/listinfo/sqlite-****users > > <http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users> > > >>>>> <http://sqlite.org:8080/**cgi-bin/mailman/listinfo/**sqlite-users< > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > > >>>>> > > > >>>>> > > >>>>> > > >>>> > > >>>> ______________________________**_________________ > > >>> sqlite-users mailing list > > >>> sqlite-users@sqlite.org > > >>> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users< > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > > >>> > > >>> > > >> ______________________________**_________________ > > >> sqlite-users mailing list > > >> sqlite-users@sqlite.org > > >> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users< > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > > >> > > > > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > > -- > D. Richard Hipp > d...@sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users