Bug 320911

Summary: Google Contacts resource + Akonadi Nepomuk Feeder = Transaction deadlocked.
Product: [Frameworks and Libraries] Akonadi Reporter: Alejandro Nova <alejandronova>
Component: Nepomuk Feeder AgentsAssignee: kdepim bugs <kdepim-bugs>
Status: RESOLVED UNMAINTAINED    
Severity: normal CC: aaronw, me, vkrause
Priority: NOR    
Version: 4.10   
Target Milestone: ---   
Platform: Other   
OS: Linux   
Latest Commit: Version Fixed In:

Description Alejandro Nova 2013-06-08 16:36:24 UTC
When Akonadi Nepomuk Feeder tries to index a contact generated by the Google Contacts resource, I get this:

akonadi_nepomuk_feeder(1877) ItemQueue::batchJobResult: Error while storing graph:  "SQLExecDirect failed on query 'sparql insert into <nepomuk:/ctx/bc00a4e0-2613-4f6f-bb82-e9fb06aeb1bd> {  <nepomuk:/res/5d01c258-6349-4ba4-ad77-542469cb1b74> <http://www.semanticdesktop.org/ontologies/2007/01/19/nie#isPartOf> <nepomuk:/res/95d71ff1-b11e-4525-a9d7-3bbec8cff179> ; <http://www.semanticdesktop.org/ontologies/2007/08/15/nao#prefLabel> "LlulluTuqo" ; <http://www.semanticdesktop.org/ontologies/2007/01/19/nie#url> <akonadi:?item=1362> ; <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://akonadi-project.org/ontologies/aneo#AkonadiDataObject>, <http://www.semanticdesktop.org/ontologies/2007/01/19/nie#InformationElement>, <http://www.semanticdesktop.org/ontologies/2007/03/22/nco#Contact>, <http://www.semanticdesktop.org/ontologies/2007/03/22/nco#PersonContact> ; <http://www.semanticdesktop.org/ontologies/2007/03/22/nco#contactUID> "http://www.google.com/m8/feeds/contacts/alejandronova%40gmail.com/base/3617a1390c5b3fa4"^^<http://www.w3.org/2001/XMLSchema#string> ; <http://www.semanticdesktop.org/ontologies/2007/03/22/nco#fullname> "LlulluTuqo"^^<http://www.w3.org/2001/XMLSchema#string> ; <http://www.semanticdesktop.org/ontologies/2007/01/19/nie#lastModified> "2013-05-06T23:43:06Z"^^<http://www.w3.org/2001/XMLSchema#dateTime> ; <http://www.semanticdesktop.org/ontologies/2007/03/22/nco#nameGiven> "LlulluTuqo"^^<http://www.w3.org/2001/XMLSchema#string> ; <http://www.semanticdesktop.org/ontologies/2007/08/15/nao#lastModified> "2013-06-08T16:19:39.626Z"^^<http://www.w3.org/2001/XMLSchema#dateTime> ; <http://akonadi-project.org/ontologies/aneo#akonadiItemId> "1362"^^<http://www.w3.org/2001/XMLSchema#string> ; <http://akonadi-project.org/ontologies/aneo#akonadiIndexCompatLevel> "3"^^<http://www.w3.org/2001/XMLSchema#int> ; <http://www.semanticdesktop.org/ontologies/2007/03/22/nco#hasEmailAddress> <nepomuk:/res/4bd8c8d8-eb5c-4ac0-b390-bfb2ec18a528> ; <http://www.semanticdesktop.org/ontologies/2007/08/15/nao#created> "2013-06-08T16:19:39.626Z"^^<http://www.w3.org/2001/XMLSchema#dateTime> . }' (iODBC Error: [OpenLink][Virtuoso iODBC Driver][Virtuoso Server]SR172: Transaction deadlocked)" 


Reproducible: Always

Steps to Reproduce:
1. Enable the Google Contacts resource
2. Try to index the resulting contacts with Akonadi Nepomuk Feeder.
3. Error
Actual Results:  
The contact doesn't get indexed, and I get that error

Expected Results:  
The contact is indexed.

I don't know if this is indeed an Akonadi Nepomuk Feeder bug, or if this bug belongs to the Google resources. Please, check.
Comment 1 Aaron Williams 2013-10-31 04:13:32 UTC
I can confirm that I am seeing the same thing with nepomukindexer 4.11.2 running on OpenSUSE. This happens with certain pdf files.

Here are some PDF files that generate the error:

www.nxp.com/documents/data_sheet/PCA9541.pdf‎
www.nxp.com/documents/data_sheet/PCA8574_PCA8574A.pdf
www.onfi.org/~/media/ONFI/specs/ONFI_1_0_Gold.pdf
http://www.ti.com/lit/ds/scds178c/scds178c.pdf
http://www.intel.com/content/dam/www/public/us/en/documents/datasheets/82599-10-gbe-controller-datasheet.pdf
http://www.ftdichip.com/Support/Documents/AppNotes/AN_107_AdvancedDriverOptions_AN_000073.pdf
http://www.ftdichip.com/Support/Documents/AppNotes/AN_135_MPSSE_Basics.pdf

All of these generate the following error:

nepomukindexer(2949)/nepomuk (strigi service): "SQLExecDirect failed on query 'sparql insert { graph <nepomuk:/ctx/a729a0da-d766-42ad-8491-12c992d2abdb> { <nepomuk:/res/708cd4ad-42f8-4d21-8c47-2134ab28521a> nie:plainTextContent "Open NAND Flash Interface Specification\n                Revision 1.0\n             28-December-2006\n         Hynix Semiconductor\n            Intel Corporation\n        Micron Technology, Inc.\n        Phison Electronics Corp.\n           Sony Corporation\n          STMicroelectronics\nThis 1.0 revision of the Open NAND Flash Interface specification (\"Final Specification\") is\navailable for download at www.onfi.org.\n
...
<http://www.w3.org/2001/XMLSchema#string> . } }' (iODBC Error: [OpenLink][Virtuoso iODBC Driver][Virtuoso Server]SR172: Transaction deadlocked)"
Comment 2 Vishesh Handa 2015-03-17 12:40:02 UTC
The Nepomuk project is no longer maintained in KDE since 4.13. For email indexing, Baloo provided an Akonadi resource to index emails, contacts and events. Tags are now maintained by Akonadi itself.