Hi all,
first-poster here so bear with me.

Anyway, I have been having an issue with Nepomuk file(?) indexer for some time now. IIRC the problem came with KDE 4.11 and is still present in 4.11.1, which I use now.

The problem is that Nepomuk keeps spamming .xsession-errors with messages like this one:

Code: Select all

nepomukindexer(4191)/nepomuk (strigi service): SimpleIndexerError:  "SQLExecDirect failed on query 'sparql insert into <nepomuk:/ctx/26b325b1-2f03-434d-b441-f6d9e54fb5c3> {  <nepomuk:/res/495009be-2109-4621-9908-007323a6e3a4> <http://www.semanticdesktop.org/ontologies/2007/01/19/nie#title> "3"^^<http://www.w3.org/2001/XMLSchema#string> ; <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://www.semanticdesktop.org/ontologies/2009/02/19/nmm#MusicAlbum> .<nepomuk:/res/0eb0ce65-4450-41a3-aad0-77949b4cb459> <http://www.semanticdesktop.org/ontologies/2007/03/22/nfo#averageBitrate> "1.2800000000e+05"^^<http://www.w3.org/2001/XMLSchema#float> ; <http://www.semanticdesktop.org/ontologies/2007/03/22/nfo#sampleRate> "4.8000000000e+04"^^<http://www.w3.org/2001/XMLSchema#float> ; <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://www.semanticdesktop.org/ontologies/2009/02/19/nmm#MusicPiece> ; <http://www.semanticdesktop.org/ontologies/2009/02/19/nmm#genre> ""^^<http://www.w3.org/2001/XMLSchema#string> ; <http://www.semanticdesktop.org/ontologies/2007/03/22/nfo#channels> "2"^^<http://www.w3.org/2001/XMLSchema#int> ; <http://www.semanticdesktop.org/ontologies/2009/02/19/nmm#musicAlbum> <nepomuk:/res/495009be-2109-4621-9908-007323a6e3a4> ; <http://www.semanticdesktop.org/ontologies/2009/02/19/nmm#releaseDate> "10392054-12-28T00:00:00Z"^^<http://www.w3.org/2001/XMLSchema#dateTime> ; <http://www.semanticdesktop.org/ontologies/2007/03/22/nfo#duration> "16"^^<http://www.w3.org/2001/XMLSchema#string> . }' (iODBC Error: [OpenLink][Virtuoso iODBC Driver][Virtuoso Server]SQ074: Line 1: DT006: Cannot convert 10392054-12-28T00:00:00Z to datetime : Incorrect minute delimiter)"


or

Code: Select all

nepomukindexer(4172)/nepomuk (strigi service): SimpleIndexerError:  "SQLExecDirect failed on query 'sparql insert into <nepomuk:/ctx/26b325b1-2f03-434d-b441-f6d9e54fb5c3> {  <nepomuk:/res/c1c368d0-1aa5-42f8-9d78-a1fc49571abb> <http://www.semanticdesktop.org/ontologies/2007/03/22/nfo#averageBitrate> "1.2800000000e+05"^^<http://www.w3.org/2001/XMLSchema#float> ; <http://www.semanticdesktop.org/ontologies/2007/03/22/nfo#sampleRate> "4.8000000000e+04"^^<http://www.w3.org/2001/XMLSchema#float> ; <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://www.semanticdesktop.org/ontologies/2009/02/19/nmm#MusicPiece> ; <http://www.semanticdesktop.org/ontologies/2009/02/19/nmm#genre> ""^^<http://www.w3.org/2001/XMLSchema#string> ; <http://www.semanticdesktop.org/ontologies/2007/03/22/nfo#channels> "2"^^<http://www.w3.org/2001/XMLSchema#int> ; <http://www.semanticdesktop.org/ontologies/2009/02/19/nmm#musicAlbum> <nepomuk:/res/a09b2346-edaa-4f6b-a380-7bf9462fd84e> ; <http://www.semanticdesktop.org/ontologies/2009/02/19/nmm#releaseDate> "1134179-03-12T00:00:00Z"^^<http://www.w3.org/2001/XMLSchema#dateTime> ; <http://www.semanticdesktop.org/ontologies/2007/03/22/nfo#duration> "12"^^<http://www.w3.org/2001/XMLSchema#string> . }' (iODBC Error: [OpenLink][Virtuoso iODBC Driver][Virtuoso Server]SQ074: Line 1: DT006: Cannot convert 1134179-03-12T00:00:00Z to datetime : Incorrect year field length)"


When I say "spamming", I really mean it -- the log can grow to gigabytes in a few days.

I have no idea where it takes those values. I might be able to track down the erroneous file but I have no idea where to start looking or how to use the resource ID's to find out what's behind them.

Any help or guidance would be greatly appreciated.

Thanks in advance, guys!

This seems to be a bug in Nepomuk.

With 4.11.2 the error message spamming has been fixed. However, we should still fix the faulty indexer. It would be great if you could locate the faulty file via -

Code: Select all

$ nepomukshow nepomuk:/res/c1c368d0-1aa5-42f8-9d78-a1fc49571abb

I got the 'nepomuk:/res/fadfasdfasdf' from your output. That is the unique identifier for that file stored in Nepomuk. 'nepomukshow' will output all the data that it knows about the file. In that there will be the url of the file.

Please file a bug on bugs.kde.org and upload that file. If we can reproduce the problem then it will be fixed with the next point release.