Bug 320911 - Google Contacts resource + Akonadi Nepomuk Feeder = Transaction deadlocked.
Summary: Google Contacts resource + Akonadi Nepomuk Feeder = Transaction deadlocked.
Status: RESOLVED UNMAINTAINED
Alias: None
Product: Akonadi
Classification: Frameworks and Libraries
Component: Nepomuk Feeder Agents (show other bugs)
Version: 4.10
Platform: Other Linux
: NOR normal
Target Milestone: ---
Assignee: kdepim bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-06-08 16:36 UTC by Alejandro Nova
Modified: 2015-03-17 12:40 UTC (History)
3 users (show)

See Also:
Latest Commit:
Version Fixed In:

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
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.