[Nepomuk] Problem with storage crashing repeatedly

[Vishesh Handa]

On Sat, Jun 22, 2013 at 5:43 AM, Lindsay Mathieson
<lindsay.mathieson at gmail.com> wrote:
> On Fri, 21 Jun 2013 04:59:48 PM Vishesh Handa wrote:
>> On Fri, Jun 21, 2013 at 3:35 PM, Lindsay Mathieson
>>
>> <lindsay.mathieson at gmail.com> wrote:
>> > On Fri, 21 Jun 2013 05:07:19 AM you wrote:
>> >> Try starting virtuoso manually the same way the storage service starts
>> >> it, and then see if it is crashing.
>
>
> I'm seeing this consistently from storage just before the crash - any help?
>
> Also storage wasn't crashing until I got the mail feeder working again, so I
> presume its also to do with data from akonadi.
>
> nepomukstorage(3491)/nepomuk (storage service)
> Nepomuk2::Sync::ResourceIdentifier::runIdentification: KUrl("_:xth")  -->
> KUrl("nepomuk:/res/8bbd474c-a6ee-4541-ab1f-a0b794ec9414")
> nepomukstorage(3491)/nepomuk (storage service)
> Nepomuk2::DataManagementModel::storeResources:  MERGING FAILED!
> nepomukstorage(3491)/nepomuk (storage service)
> Nepomuk2::DataManagementModel::storeResources: Setting error! "SQLExecDirect
> failed on query 'sparql insert into <nepomuk:/ctx/51103ac5-2643-404b-
> a738-3c9c970cac4a> {  <nepomuk:/res/ed462f9d-3479-44be-907d-bd24606b57d8>
> <http://www.semanticdesktop.org/ontologies/2007/08/15/nao#prefSymbol>
> <nepomuk:/res/22665e9d-6a9a-4398-816b-3c1e551a19a7> ;
> <http://www.semanticdesktop.org/ontologies/2007/01/19/nie#isPartOf>
> <nepomuk:/res/7ee3361a-73b3-4cda-b164-f66ea732b5d1> ;
> <http://www.semanticdesktop.org/ontologies/2007/03/22/nmo#messageId>
> "<0C22A534.3751780 at telestar.ru>"^^<http://www.w3.org/2001/XMLSchema#string> ;
> <http://www.semanticdesktop.org/ontologies/2007/08/15/nao#prefLabel>
> "???????????????@softlog.com.au\r" ; <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/nmo#Email> ;
> <http://www.semanticdesktop.org/ontologies/2007/01/19/nie#lastModified>
> "2013-05-06T04:37:25Z"^^<http://www.w3.org/2001/XMLSchema#dateTime> ;
> <http://www.semanticdesktop.org/ontologies/2007/03/22/nmo#isRead>
> "true"^^<http://www.w3.org/2001/XMLSchema#boolean> ;
> <http://www.semanticdesktop.org/ontologies/2007/03/22/nmo#messageSubject>
> "???????????????@softlog.com.au\r"^^<http://www.w3.org/2001/XMLSchema#string>
> ; <http://www.semanticdesktop.org/ontologies/2007/03/22/nmo#to>
> <nepomuk:/res/8bbd474c-a6ee-4541-ab1f-a0b794ec9414> ; <http://akonadi-project.org/ontologies/aneo#akonadiItemId>
> "63298"^^<http://www.w3.org/2001/XMLSchema#string> ;
> <http://www.semanticdesktop.org/ontologies/2007/01/19/nie#byteSize>
> "11817"^^<http://www.w3.org/2001/XMLSchema#integer> ; <http://akonadi-project.org/ontologies/aneo#akonadiIndexCompatLevel>
> "3"^^<http://www.w3.org/2001/XMLSchema#int> ;
> <http://www.semanticdesktop.org/ontologies/2007/03/22/nmo#sentDate>
> "2010-12-24T23:02:36Z"^^<http://www.w3.org/2001/XMLSchema#dateTime> ;
> <http://www.semanticdesktop.org/ontologies/2007/03/22/nmo#from>
> <nepomuk:/res/e2611c57-2cbc-42a8-9763-ecc0527ad2bf> . }' (iODBC Error:
> [OpenLink][Virtuoso iODBC Driver][Virtuoso Serve' as narrow SQL atom)": SPARQL
> compiler: Suspicious result of printing '???????????????@softlog.com.au

This is bad. Can you track down this email address in akonadi and see
how it is stored?

Merging should never fail.

> nepomukstorage(3491)/nepomuk (storage service)
> Nepomuk2::Sync::ResourceIdentifier::runIdentification: KUrl("_:cuh")  -->
> KUrl("nepomuk:/res/78dda6d9-31d3-49ef-be08-adae53f28904")
> nepomukstorage(3491)/nepomuk (storage service)
> Nepomuk2::Sync::ResourceIdentifier::runIdentification: KUrl("_:buh")  -->
> KUrl("nepomuk:/res/426ae868-acfe-48db-9984-993dd3147b58")
> nepomukstorage(3491)/nepomuk (storage service)
> Nepomuk2::Repository::slotVirtuosoStopped: Virtuoso was killed or crashed.
> Restarting the repository.
> nepomukstorage(3491)/nepomuk (storage service) Nepomuk2::Repository::close:
> "main"
>
>
> --
> Lindsay
> _______________________________________________
> Nepomuk mailing list
> Nepomuk at kde.org
> https://mail.kde.org/mailman/listinfo/nepomuk
>



--
Vishesh Handa