Page MenuHomePhorge

a lot of problems with akonadi synchronization
Closed, WontfixPublic

Description

xecuting search "searchUpdate-1461569723"
akonadiserver(22735)/kdecore (KSycoca) KSycocaPrivate::openDatabase: Trying to open
ksycoca from "/var/tmp/kdecache-wahmhoff/ksycoca4"
akonadi_kolab_resource_0(22757)/libakonadi Akonadi::ItemSync::setFullSyncItems: Received:
100 In total: 1200 Wanted: 2931
akonadiserver(22735): Xapian Database does not exist at
"/home/wahmhoff/.local/share/baloo/file/"
akonadiserver(22735) SearchPlugin::search: Got 104 results
searchUpdateResultsAvailable 183 104 results
Got 104 results, out of which 104 are already in the collection
Added 0
Search done "searchUpdate-1461569723" (without remote search)
Search update finished
All results: 104
Removed results: 0
Executing search "searchUpdate-1461569723"
akonadiserver(22735) SearchPlugin::search: Got 6455 results
searchUpdateResultsAvailable 182 6455 results
Got 6455 results, out of which 6454 are already in the collection
DATABASE ERROR:
Error code: 1452
DB error: "Cannot add or update a child row: a foreign key constraint fails
(akonadi_wahmhoff.CollectionPimItemRelation, CONSTRAINT
CollectionPimItemRelation_ibfk_2 FOREIGN KEY (PimItem_id) REFERENCES PimItemTable
(id) ON DELETE CASCADE ON UPDATE CASCADE)"
Error text: "Cannot add or update a child row: a foreign key constraint fails
(akonadi_wahmhoff.CollectionPimItemRelation, CONSTRAINT
CollectionPimItemRelation_ibfk_2 FOREIGN KEY (PimItem_id) REFERENCES PimItemTable
(id) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL3: Unable to execute statement"
Query: "INSERT INTO CollectionPimItemRelation (Collection_id, PimItem_id) VALUES (:0, :1)"

Reestablishing the connection
Not reestablishing the connection. -1 false 140449792653056
Error during adding a record to table "CollectionPimItemRelation" "Cannot add or update a
child row: a foreign key constraint fails (akonadi_wahmhoff.CollectionPimItemRelation,
CONSTRAINT CollectionPimItemRelation_ibfk_2 FOREIGN KEY (PimItem_id) REFERENCES
PimItemTable (id) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL3: Unable to execute
statement"
Added 1
Search done "searchUpdate-1461569723" (without remote search)
Search update finished
All results: 6455
Removed results: 0

Details

Ticket Type
Task

Event Timeline

adomaitis created this task.
adomaitis added projects: KDE PIM, Restricted Project.

OTRS #1016876, assigned to mollekopf. There are more comments from user.

mollekopf subscribed.

We currently have no information about any actual problems.

The above error message has nothing to do with synchronization but is being worked on in T1226

mollekopf claimed this task.