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
