[Tracker] SQLite 3.8.4.2 causes crash with Tracker

[Martyn Russell <martyn lanedo com>]

Hi all,

Just a quick heads up, earlier tonight Cosimo Cecchi mentioned a crash 
that is happening for him on the latest Fedora with GNOME 3.12. The 
details of the crash are attached in a backtrace in case others see 
something similar. Here is the initial dump:

"""
#0  0xb7f58d12 in wherePathSatisfiesOrderBy 
(pWInfo=pWInfo entry=0x86c5898, wctrlFlags=wctrlFlags entry=512,
    nLoop=2, pLast=0x85dfa88, pRevMask=pRevMask entry=0xbfffe0f0, 
pPath=0x86bd088, pOrderBy=<optimized out>,
    pOrderBy=<optimized out>) at sqlite3.c:114184
        revSet = <optimized out>
        rev = <optimized out>
        revIdx = <optimized out>
        isOrderDistinct = 1 '\001'
        distinctColumns = <optimized out>
        isMatch = <optimized out>
        nKeyCol = <optimized out>
        nOrderBy = 4
        iLoop = <optimized out>
        i = <optimized out>
        j = <optimized out>
        iCur = 3
        iColumn = <optimized out>
        pLoop = 0x85dff08
        pTerm = <optimized out>
        pOBExpr = <optimized out>
        pColl = <optimized out>
        pIndex = 0x10000
        db = 0x85d0c08
        obSat = <optimized out>
        obDone = 15
        orderDistinctMask = <optimized out>
        ready = 0
#1  0xb7f599e7 in wherePathSolver (pWInfo=pWInfo entry=0x86c5898, 
nRowEst=nRowEst entry=44) at sqlite3.c:114581
        notUsed = 0
        rc = <optimized out>
        mxChoice = <optimized out>
        nLoop = <optimized out>
        pParse = <optimized out>
        db = <optimized out>
        iLoop = <optimized out>
        ii = <optimized out>
        jj = <optimized out>
        mxI = <optimized out>
        rCost = <optimized out>
        nOut = <optimized out>
        mxCost = <optimized out>
        mxOut = <optimized out>
        rSortCost = 66
        nTo = <optimized out>
        nFrom = <optimized out>
        aFrom = <optimized out>
        aTo = <optimized out>
        pFrom = <optimized out>
        pTo = <optimized out>
        pWLoop = <optimized out>
        pX = <optimized out>
        pSpace = <optimized out>
#2  0xb7f6eea1 in sqlite3WhereBegin (pParse=pParse entry=0x86732b0, 
pTabList=pTabList entry=0x86bc790,
    pWhere=pWhere entry=0x85df408, pOrderBy=pOrderBy entry=0x85df388, 
pResultSet=0x85e5188, wctrlFlags=1024,
    iIdxCur=iIdxCur entry=0) at sqlite3.c:114975
...
"""

See the attached file for full details.

Anyway, 3.8.2 seems to be fine. We've not tested 3.8.3 (which is in 
between) yet, but be aware.

I will be pushing a commit to warn users building with that version, as 
we do with other versions that break for Tracker.

Thanks,

--
Regards,
Martyn

Founder & Director @ Lanedo GmbH.
http://www.linkedin.com/in/martynrussell

Attachment: sqlite-3.8.4.2-gdb-dump.txt
Description: Text document