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>


  ______________________________**_________________
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


_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to