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
