Hi,
A few days ago, an addressbook sync failed with the following error
(which I anonymized) on the N9:
[INFO] addressbook: updating "ThisFirstName ThisLastName"
[ERROR] stderr: QTrackerDirectSyncResult: QSparqlError(4,
"GDBus.Error:org.freedesktop.Tracker1.SparqlError.Constraint: Unable to insert
multiple values for subject `urn:uuid:15cdee1e-e3f1-dcef-59fc-2e734089ffc0' and single
valued property `nao:prefLabel' (old_value: 'BUSINESS', new value:
'Business')", 1) "
followed by lots more output, included below. This appeared to come
totally out of the blue; I have no idea what I did differently than
before (no unusual addressbook edits, no N9 software updates, no related
laptop updates AFAICT, though I closely track Debian testing). Working
around this involved removing all category tags from all of my
addressbook records (which was OK because I need a better scheme
anyway), but this is of course no long-term solution.
During my attempts to get back into a syncable state with "syncevolution
--sync refresh-from-server", the system irritated me by stating
[INFO] addressbook: resuming first time sync from server
even though I meant to restart the refresh from scratch. This might be
just the message though; the sync may have done the right thing.
Or, more accurately, attempted to do the right thing, because the Sparql
error persisted for all records bearing category tags, until I removed
them all.
Afterwards my calendars refused to sync (thanks to preventSlowSync=1):
[ERROR] sync: aborted on behalf of user (local, status 20017)
[INFO] calendar: starting first time sync, two-way
[INFO] calendar: first time sync done unsuccessfully
[ERROR] calendar: unexpected slow sync (local, status 22000)
[ERROR] error code from Synthesis engine local, status 20048
even though, so I would think, calendar sync status should be totally
unrelated to addressbook sync status.
Thanks for any help, hints and pointers!
Justus
N9$ syncevolution -q client-for-laptop addressbook
[INFO] calendarprof: inactive
[INFO] calendarattrs: inactive
[INFO] memo: inactive
[INFO] calendar: inactive
[INFO] todo: inactive
[INFO] addressbook: starting normal sync, two-way
[INFO] addressbook: started
[INFO] addressbook: updating "ThisFirstName ThisLastName"
[ERROR] stderr: QTrackerDirectSyncResult: QSparqlError(4,
"GDBus.Error:org.freedesktop.Tracker1.SparqlError.Constraint: Unable to insert
multiple values for subject `urn:uuid:15cdee1e-e3f1-dcef-59fc-2e734089ffc0' and single
valued property `nao:prefLabel' (old_value: 'BUSINESS', new value:
'Business')", 1) "
DELETE
{
GRAPH <urn:uuid:08070f5c-a334-4d19-a8b0-12a3071bfab9>
{
?subject
<
http://www.semanticdesktop.org/ontologies/2007/03/22/nco#hasPostalAddress... ?object
.
}
}
WHERE
{
GRAPH <urn:uuid:08070f5c-a334-4d19-a8b0-12a3071bfab9>
{
<urn:uuid:6eb5afc6-a536-4c4c-90d8-dce01360538f>
<
http://www.semanticdesktop.org/ontologies/2007/03/22/nco#hasAffiliation> ?subject
.
?subject
<
http://www.semanticdesktop.org/ontologies/2007/03/22/nco#hasPostalAddress... ?object
.
}
}
DELETE
{
GRAPH <urn:uuid:08070f5c-a334-4d19-a8b0-12a3071bfab9>
{
?subject <
http://www.semanticdesktop.org/ontologies/2007/04/02/ncal#dtstart>
?object .
}
}
WHERE
{
GRAPH <urn:uuid:08070f5c-a334-4d19-a8b0-12a3071bfab9>
{
<urn:uuid:6eb5afc6-a536-4c4c-90d8-dce01360538f>
<
http://www.semanticdesktop.org/ontologies/2007/04/02/ncal#anniversary> ?subject .
?subject <
http://www.semanticdesktop.org/ontologies/2007/04/02/ncal#dtstart>
?object .
}
}
DELETE
{
GRAPH <urn:uuid:08070f5c-a334-4d19-a8b0-12a3071bfab9>
{
?subject
<
http://www.semanticdesktop.org/ontologies/2007/03/22/nco#hasPostalAddress... ?object
.
}
}
WHERE
{
GRAPH <urn:uuid:08070f5c-a334-4d19-a8b0-12a3071bfab9>
{
<urn:uuid:6eb5afc6-a536-4c4c-90d8-dce01360538f>
<
http://www.semanticdesktop.org/ontologies/2007/03/22/nco#hasAffiliation> [
<
http://www.semanticdesktop.org/ontologies/2007/03/22/nco#org> ?subject ] .
?subject
<
http://www.semanticdesktop.org/ontologies/2007/03/22/nco#hasPostalAddress... ?object
.
}
}
DELETE
{
GRAPH <urn:uuid:08070f5c-a334-4d19-a8b0-12a3071bfab9>
{
?subject <
http://www.semanticdesktop.org/ontologies/2007/03/22/nco#org> ?object
.
}
}
WHERE
{
GRAPH <urn:uuid:08070f5c-a334-4d19-a8b0-12a3071bfab9>
{
<urn:uuid:6eb5afc6-a536-4c4c-90d8-dce01360538f>
<
http://www.semanticdesktop.org/ontologies/2007/03/22/nco#hasAffiliation> ?subject
.
?subject <
http://www.semanticdesktop.org/ontologies/2007/03/22/nco#org> ?object
.
}
}
DELETE
{
<urn:x-maemo-phone:+49%200000%2011%203333> ?predicate ?object .
}
WHERE
{
<urn:x-maemo-phone:+49%200000%2011%203333> ?predicate ?object .
FILTER(?predicate IN
(<
http://www.semanticdesktop.org/ontologies/2007/08/15/nao#hasProperty>,
<
http://www.semanticdesktop.org/ontologies/2007/03/22/nco#phoneNumber>,
<
http://maemo.org/ontologies/tracker#localPhoneNumber>)) .
}
DELETE
{
<urn:x-maemo-phone:mobile:+49%20176%2012345678> ?predicate ?object .
}
WHERE
{
<urn:x-maemo-phone:mobile:+49%20176%2012345678> ?predicate ?object .
FILTER(?predicate IN
(<
http://www.semanticdesktop.org/ontologies/2007/08/15/nao#hasProperty>,
<
http://www.semanticdesktop.org/ontologies/2007/03/22/nco#phoneNumber>,
<
http://maemo.org/ontologies/tracker#localPhoneNumber>)) .
}
DELETE
{
<urn:x-maemo-phone:fax:+49%200000%2011%202222> ?predicate ?object .
}
WHERE
{
<urn:x-maemo-phone:fax:+49%200000%2011%202222> ?predicate ?object .
FILTER(?predicate IN
(<
http://www.semanticdesktop.org/ontologies/2007/08/15/nao#hasProperty>,
<
http://www.semanticdesktop.org/ontologies/2007/03/22/nco#phoneNumber>,
<
http://maemo.org/ontologies/tracker#localPhoneNumber>)) .
}
DELETE
{
?resource a
<
http://www.semanticdesktop.org/ontologies/2007/03/22/nco#CarPhoneNumber>,
<
http://www.semanticdesktop.org/ontologies/2007/03/22/nco#BbsNumber>,
<
http://www.semanticdesktop.org/ontologies/2007/03/22/nco#PagerNumber>,
<
http://www.semanticdesktop.org/ontologies/2007/03/22/nco#VideoTelephoneNu...;,
<
http://www.semanticdesktop.org/ontologies/2007/03/22/nco#MessagingNumber>,
<
http://www.semanticdesktop.org/ontologies/2007/03/22/nco#VoicePhoneNumber>,
<
http://www.semanticdesktop.org/ontologies/2007/03/22/nco#CellPhoneNumber>,
<
http://www.semanticdesktop.org/ontologies/2007/03/22/nco#FaxNumber>,
<
http://www.semanticdesktop.org/ontologies/2007/03/22/nco#ModemNumber> .
}
WHERE
{
?resource a <
http://www.semanticdesktop.org/ontologies/2007/03/22/nco#PhoneNumber>
.
FILTER(?resource IN (<urn:x-maemo-phone:+49%200000%2011%203333>,
<urn:x-maemo-phone:mobile:+49%20176%2012345678>,
<urn:x-maemo-phone:fax:+49%200000%2011%202222>)) .
}
DELETE
{
GRAPH <urn:uuid:08070f5c-a334-4d19-a8b0-12a3071bfab9>
{
<urn:uuid:6eb5afc6-a536-4c4c-90d8-dce01360538f> ?predicate ?object .
}
}
WHERE
{
GRAPH <urn:uuid:08070f5c-a334-4d19-a8b0-12a3071bfab9>
{
<urn:uuid:6eb5afc6-a536-4c4c-90d8-dce01360538f> ?predicate ?object .
FILTER(?predicate NOT
IN(rdf:type,nco:belongsToGroup,nco:contactUID,nie:contentCreated)) .
}
}
INSERT
{
_:_ a <
http://www.semanticdesktop.org/ontologies/2007/08/15/nao#Tag>,
<
http://www.w3.org/2000/01/rdf-schema#Resource> ;
<
http://www.semanticdesktop.org/ontologies/2007/08/15/nao#prefLabel>
"Business" .
}
WHERE
{
OPTIONAL
{
?resource a <
http://www.semanticdesktop.org/ontologies/2007/08/15/nao#Tag>,
<
http://www.w3.org/2000/01/rdf-schema#Resource> ;
<
http://www.semanticdesktop.org/ontologies/2007/08/15/nao#prefLabel> ?value .
FILTER(fn:lower-case("Business") = fn:lower-case(?value)) .
}
FILTER(!bound(?resource)) .
}
INSERT {GRAPH <urn:uuid:08070f5c-a334-4d19-a8b0-12a3071bfab9>
{<urn:uuid:6eb5afc6-a536-4c4c-90d8-dce01360538f> rdf:type
<
http://www.semanticdesktop.org/ontologies/2007/03/22/nco#PersonContact> ;
nco:hasAffiliation _:_Affiliation2, _:_Organization_Resource4, _:_Affiliation_Work1 ;
nco:nameGiven "ThisFirstName" ; nco:nameFamily "ThisLastName" ;
nco:fullname "ThisFirstName ThisLastName" ; nao:hasTag ?_Tag_Resource3 ;
nie:generator "addressbook" ; nie:contentLastModified
"2012-02-23T07:40:42" . _:_Affiliation2 rdf:type nco:Affiliation ;
nco:hasPhoneNumber <urn:x-maemo-phone:+49%200000%2011%203333>,
<urn:x-maemo-phone:mobile:+49%20176%2012345678>,
<urn:x-maemo-phone:fax:+49%200000%2011%202222> .
<urn:x-maemo-phone:+49%200000%2011%203333> rdf:type
<
http://www.semanticdesktop.org/ontologies/2007/03/22/nco#PhoneNumber> ;
nco:phoneNumber "+49 0000 11 3333" ; maemo:localPhoneNumber "1113333"
. ?_Tag_Resource3 rdf:type <
http://www.w3.org/2000/01/rdf-schema#Resource>,
<
http://www.semanticdesktop.org/ontologies/2007/08/15/nao#Tag> ; nao:prefLabel
"Business" . _:_Organization_Resource4 rdf:type
<
http://www.semanticdesktop.org/ontologies/2007/03/22/nco#Affiliation> ; nco:org
_:_Organization_Resource5 . _:_Organization_Resource5 rdf:type
<
http://www.semanticdesktop.org/ontologies/2007/03/22/nco#OrganizationCont...;,
<
http://www.semanticdesktop.org/ontologies/2007/03/22/nco#Contact>,
<
http://www.semanticdesktop.org/ontologies/2007/03/22/nco#Role> ; nco:fullname
"ThisCompany" . <urn:x-maemo-phone:mobile:+49%20176%2012345678> rdf:type
<
http://www.semanticdesktop.org/ontologies/2007/03/22/nco#CellPhoneNumber>,
<
http://www.semanticdesktop.org/ontologies/2007/03/22/nco#PhoneNumber> ;
nco:phoneNumber "+49 176 12345678" ; maemo:localPhoneNumber "7654321"
. <urn:x-maemo-phone:fax:+49%200000%2011%202222> rdf:type
<
http://www.semanticdesktop.org/ontologies/2007/03/22/nco#FaxNumber>,
<
http://www.semanticdesktop.org/ontologies/2007/03/22/nco#PhoneNumber> ;
nco:phoneNumber "+49 0000 11 2222" ; maemo:localPhoneNumber "1112222"
. _:_Affiliation_Work1 rdf:type nco:Affiliation ; rdfs:label "Work" ;
nco:hasPostalAddress _:_Address_Resource6 . _:_Address_Resource6 rdf:type
<
http://www.semanticdesktop.org/ontologies/2007/03/22/nco#PostalAddress> ;
nco:country "Germany" ; nco:locality "ThisCity" ; nco:postalcode
"99999" ; nco:streetAddress "Raum AB 02 | C888"}} WHERE
{?_Tag_Resource3 nao:prefLabel ?auto55 FILTER((fn:lower-case(?auto55) =
fn:lower-case("Business")))}INSERT INTO
<urn:uuid:08070f5c-a334-4d19-a8b0-12a3071bfab9>
{<urn:uuid:6eb5afc6-a536-4c4c-90d8-dce01360538f> nie:contentCreated
"2012-02-23T07:40:42"} WHERE {OPTIONAL
{<urn:uuid:6eb5afc6-a536-4c4c-90d8-dce01360538f> nie:contentCreated ?auto56}
FILTER(!(bound(?auto56)))}INSERT INTO
<urn:uuid:08070f5c-a334-4d19-a8b0-12a3071bfab9>
{<urn:uuid:6eb5afc6-a536-4c4c-90d8-dce01360538f> nco:contac
[ERROR] stderr: libqtcontacts-tracker: abstractrequest.cpp:237: QTrackerContactSaveRequest
failed: GDBus.Error:org.freedesktop.Tracker1.SparqlError.Constraint: Unable to insert
multiple values for subject `urn:uuid:15cdee1e-e3f1-dcef-59fc-2e734089ffc0' and single
valued property `nao:prefLabel' (old_value: 'BUSINESS', new value:
'Business')
[ERROR] addressbook: error code from SyncEvolution fatal error (local, status 10500):
addressbook: saving contact: failed with error 11, entry #0 failed with error 11
[INFO] addressbook: received 1/3