[Bug 287187] akonadi_nepomuk_feeder can make Virtuoso eat all my CPU, when it autosuspends.

[Alejandro Nova]

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





--- Comment #1 from Alejandro Nova <alejandronova gmail com>  2011-11-21 20:40:32 ---
Update: a lot of messages flow when I interrupt Virtuoso. This is a snippet
(something like this happens with my entire contact list, around 1,000
contacts)

"
"" Soprano: "SQLExecDirect failed on query 'sparql select distinct ?r count(?p)
as ?cnt where { ?r ?p ?o. filter( ?p in
(<http://www.semanticdesktop.org/ontologies/2007/08/15/nao#prefLabel>,<http://www.semanticdesktop.org/ontologies/2007/03/22/nco#fullname>)
). optional { ?r
<http://www.semanticdesktop.org/ontologies/2007/08/15/nao#prefLabel> ?o0 . } .
filter(!bound(?o0) || ?o0="CONSTANZA NAVARRETE VALENZUELA").  ?r a
<http://www.semanticdesktop.org/ontologies/2007/03/22/nco#PersonContact> . 
optional { ?r
<http://www.semanticdesktop.org/ontologies/2007/03/22/nco#fullname> ?o1 . } .
filter(!bound(?o1) || ?o1="CONSTANZA NAVARRETE
VALENZUELA"^^<http://www.w3.org/2001/XMLSchema#string>). filter(  bound(?o0) ||
 bound(?o1) ) . } order by desc(?cnt)' (iODBC Error: [OpenLink][Virtuoso iODBC
Driver]CL064: Lost connection to server)"
[/usr/bin/nepomukservicestub] Query failed: "sparql select distinct ?r
count(?p) as ?cnt where { ?r ?p ?o. filter( ?p in
(<http://www.semanticdesktop.org/ontologies/2007/08/15/nao#prefLabel>,<http://www.semanticdesktop.org/ontologies/2007/03/22/nco#fullname>)
). optional { ?r
<http://www.semanticdesktop.org/ontologies/2007/08/15/nao#prefLabel> ?o0 . } .
filter(!bound(?o0) || ?o0="CONSTANZA NAVARRETE VALENZUELA").  ?r a
<http://www.semanticdesktop.org/ontologies/2007/03/22/nco#PersonContact> . 
optional { ?r
<http://www.semanticdesktop.org/ontologies/2007/03/22/nco#fullname> ?o1 . } .
filter(!bound(?o1) || ?o1="CONSTANZA NAVARRETE
VALENZUELA"^^<http://www.w3.org/2001/XMLSchema#string>). filter(  bound(?o0) ||
 bound(?o1) ) . } order by desc(?cnt)" 
"" Soprano: "SQLExecDirect failed on query 'sparql select distinct ?r count(?p)
as ?cnt where { ?r ?p ?o. filter( ?p in
(<http://www.semanticdesktop.org/ontologies/2007/08/15/nao#prefLabel>,<http://www.semanticdesktop.org/ontologies/2007/03/22/nco#fullname>)
). optional { ?r
<http://www.semanticdesktop.org/ontologies/2007/08/15/nao#prefLabel> ?o0 . } .
filter(!bound(?o0) || ?o0="CONSTANZA NAVARRETE VALENZUELA").  ?r a
<http://www.semanticdesktop.org/ontologies/2007/03/22/nco#PersonContact> . 
optional { ?r
<http://www.semanticdesktop.org/ontologies/2007/03/22/nco#fullname> ?o1 . } .
filter(!bound(?o1) || ?o1="CONSTANZA NAVARRETE
VALENZUELA"^^<http://www.w3.org/2001/XMLSchema#string>). filter(  bound(?o0) ||
 bound(?o1) ) . } order by desc(?cnt)' (iODBC Error: [OpenLink][Virtuoso iODBC
Driver]CL064: Lost connection to server)"
"" Soprano: "SQLExecDirect failed on query 'sparql select distinct ?r count(?p)
as ?cnt where { ?r ?p ?o. filter( ?p in
(<http://www.semanticdesktop.org/ontologies/2007/08/15/nao#prefLabel>,<http://www.semanticdesktop.org/ontologies/2007/03/22/nco#fullname>)
). optional { ?r
<http://www.semanticdesktop.org/ontologies/2007/08/15/nao#prefLabel> ?o0 . } .
filter(!bound(?o0) || ?o0="CONSTANZA NAVARRETE VALENZUELA").  ?r a
<http://www.semanticdesktop.org/ontologies/2007/03/22/nco#PersonContact> . 
optional { ?r
<http://www.semanticdesktop.org/ontologies/2007/03/22/nco#fullname> ?o1 . } .
filter(!bound(?o1) || ?o1="CONSTANZA NAVARRETE
VALENZUELA"^^<http://www.w3.org/2001/XMLSchema#string>). filter(  bound(?o0) ||
 bound(?o1) ) . } order by desc(?cnt)' (iODBC Error: [OpenLink][Virtuoso iODBC
Driver]CL064: Lost connection to server)"

I can reproduce them always, so, the process causing this is the Contact
indexer.

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