The crash is a result of -O3 flag used during compiling the library.
-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
