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 <[email protected]> wrote:
> On Mon, Mar 5, 2012 at 7:04 AM, Sreekumar TP <[email protected]>
> 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 <[email protected]>
> > 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" <[email protected]> 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"<[email protected]>
> > 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<[email protected]
> >**
> > >>>> 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<[email protected]
> >
> > >>>>>> 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
> > >>>>>>> [email protected]
> > >>>>>>> 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
> > >>>>>> [email protected]
> > >>>>>>
> > 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
> > >>>>> [email protected]
> > >>>>>
> 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
> > >>> [email protected]
> > >>> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users>
> > >>>
> > >>>
> > >> ______________________________**_________________
> > >> sqlite-users mailing list
> > >> [email protected]
> > >> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users>
> > >>
> > >
> > _______________________________________________
> > sqlite-users mailing list
> > [email protected]
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
>
>
>
> --
> D. Richard Hipp
> [email protected]
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
