[Bug 226356] New: Nepomuk+strigi+virtuoso queries fail and flood .xsession-errors

[Nate Weibley]

https://bugs.kde.org/show_bug.cgi?id=226356

           Summary: Nepomuk+strigi+virtuoso queries fail and flood
                    .xsession-errors
           Product: kde
           Version: unspecified
          Platform: Gentoo Packages
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: general
        AssignedTo: unassigned-bugs at kde.org
        ReportedBy: nweibley at gmail.com


Version:            (using KDE 4.4.0)
Compiler:          GCC 4.4.3 
OS:                Linux
Installed from:    Gentoo Packages

When enabling strigi with a virtuoso backend in 4.4, as strigi indexes its
calls to virtuoso fail and/or it crashes the server but continues trying to
bombard it with queries and floods .xsession-errors with messages.

Last night when I noticed it my .xsession-errors had ballooned to approx.
780MB. Today after clearing ~/.kde4/share/apps/nepomuk/repository/ and
re-enabling strigi my .xsession-errors was flooded to ~150MB in a matter of 4-5
minutes. 

There are a myriad of errors that get output but some highlights are:
"/usr/bin/nepomukservicestub(24551)" Error in thread 139990499555088 :
"SQLExecDirect failed on query 'sparql  select distinct ?r  where { { { { ?r
?v1 ?v2 . ?v2 bif:contains "'Top*'" . } UNION { ?r ?v1 ?v3 . ?v3 ?v4 ?v2 . ?v4
<http://www.w3.org/2000/01/rdf-schema#subPropertyOf>
<http://www.w3.org/2000/01/rdf-schema#label> . ?v2 bif:contains "'Top*'" . } .
{ ?r ?v5 ?v6 . ?v6 bif:contains "'Gear*'" . } UNION { ?r ?v5 ?v7 . ?v7 ?v8 ?v6
. ?v8 <http://www.w3.org/2000/01/rdf-schema#subPropertyOf>
<http://www.w3.org/2000/01/rdf-schema#label> . ?v6 bif:contains "'Gear*'" . } .
} . { ?r a ?v9 . ?v9 <http://www.w3.org/2000/01/rdf-schema#subClassOf>
<http://www.semanticdesktop.org/ontologies/2007/03/22/nfo#FileDataObject> . }
UNION { ?r a ?v10 . ?v10 <http://www.w3.org/2000/01/rdf-schema#subClassOf>
<http://www.semanticdesktop.org/ontologies/2007/03/22/nfo#Folder> . } . } .   
}' (iODBC Error: [OpenLink][Virtuoso iODBC Driver][Virtuoso Server]FT370:
Wildcard word needs at least 4 leading characters)"

It wrote thousands of lines of what seemed to be binary data from a bitmap
escaped (sample: "BITMAP
\n00\n54\n2A\n54\n2A\n54\n2A\n54\n2A\n54\n2A\n54\n2A\n54\n2A\n00\nENDCHAR\nSTARTCHAR
U+20C0\nENCODING 8384\nSWIDTH 500 0\nDWIDTH 8 0\nBBX 8 16 0 -2\nBITMAP
\n00\n54\n2A\n54\n2A\n54\n2A\n54\n2A\n54\n2A\n54\n2A\n54\n2A\n00\nENDCHAR\nSTARTCHAR
U+20C1\nENCODING 8385\nSWIDTH 500 0\nDWIDTH 8 0\nBBX 8 16 0 -2\nBITMAP
\n00\n54\n2A\n54\n2A\n54\n2A\n54\n2A\n54\n2A\n54\n2A\n54\n2A\n00\nENDCHAR\nSTARTCHAR
U+20C2\nENCODING 8386\nSWIDTH 500 0\nDWIDTH 8 0\nBBX 8 16 0 -2\nBITMAP
\n00\n54")

It appears one thing that really messes with indexing are Canon RAW files
(CR2).

I'm not even sure what information to provide to be helpful because there is so
much junk in the error log it's impossible to sort through. Any of this
familiar? I read Virtuoso ODBC was misreporting its capabilities or something
to that effect, perhaps that has something to do with it.

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.