Summary: | akonadi_nepomuk_feeder can make Virtuoso eat all my CPU, when it autosuspends. | ||
---|---|---|---|
Product: | [Frameworks and Libraries] Akonadi | Reporter: | Alejandro Nova <alejandronova> |
Component: | Nepomuk Feeder Agents | Assignee: | Tobias Koenig <tokoe> |
Status: | RESOLVED NOT A BUG | ||
Severity: | normal | CC: | kdepim-bugs, manutortosa, vkrause |
Priority: | NOR | ||
Version: | 4.8 | ||
Target Milestone: | --- | ||
Platform: | Chakra | ||
OS: | Linux | ||
Latest Commit: | Version Fixed In: | ||
Sentry Crash Report: |
Description
Alejandro Nova
2011-11-21 20:16:52 UTC
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. Tried with a newly created database to isolate. 1. When the Akonadi activity detector decides the system is not idle (when I'm typing this, for instance), CPU usage is normal. 2. When I'm away from the computer, CPU usage is 100%. So, this is related to the activity detection code. IMHO, that code must go. Could you be so kind to test the new Akonadi and VIrtuoso packages provided by Chakra? Gracias, Manuel, por tomar mi solicitud ;) We have another issue in Chakra: we NEED shared-desktop-ontologies 0.8.0. I installed it, and the behaviour of Nepomuk improved immediately. I'll see how my testing goes, but I think we can close this as INVALID after we have some confirmations. Please confirm. Ok, please next time use our bugtracker instead before reporting upstream. Ok, but the issue remains when you try to mix results indexed with KDE 4.7 and KDE 4.8, so it's a valid bug. You will have either to tell users to recreate their database when they upgrade, or they will face trouble. I got only a good behaviour when I used a clean database and s-d-o 0.8. Tested in another computer, couldn't reproduce, INVALID ;). Seems I created some packaging issues on my own... |