[Akonadi] [Bug 337396] Caldav (owncloud) hangs on sync caused by db issues

Robert G. Siebeck kde.bugzilla.2012 at r123.de
Sun Aug 2 16:56:28 BST 2015


https://bugs.kde.org/show_bug.cgi?id=337396

Robert G. Siebeck <kde.bugzilla.2012 at r123.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |kde.bugzilla.2012 at r123.de

--- Comment #3 from Robert G. Siebeck <kde.bugzilla.2012 at r123.de> ---
Same problem here with Akonadi 1.13 and KDE 4.14.10:

DATABASE ERROR:
Error code: 1452
DB error:  "Cannot add or update a child row: a foreign key constraint fails
(`akonadi`.`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`.`collectionpimitemrelation`
, CONSTRAINT `collectionpimitemrelation_ibfk_2` FOREIGN KEY (`PimItem_id`)
REFERENCES `pimitemtable` (`id`) ON DELET
E CASCADE ON UPDATE CASCADE) QMYSQL3: Unable to execute statement"
Query: "INSERT INTO CollectionPimItemRelation (Collection_id, PimItem_id)
VALUES (:0, :1)"
Error during adding a record to table "CollectionPimItemRelation" "Cannot add
or update a child row: a foreign key c
onstraint fails (`akonadi`.`collectionpimitemrelation`, CONSTRAINT
`collectionpimitemrelation_ibfk_2` FOREIGN KEY (`
PimItem_id`) REFERENCES `pimitemtable` (`id`) ON DELETE CASCADE ON UPDATE
CASCADE) QMYSQL3: Unable to execute statem
ent" 
DATABASE ERROR:
Error code: 1452
DB error:  "Cannot add or update a child row: a foreign key constraint fails
(`akonadi`.`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`.`collectionpimitemrelation`
, CONSTRAINT `collectionpimitemrelation_ibfk_2` FOREIGN KEY (`PimItem_id`)
REFERENCES `pimitemtable` (`id`) ON DELET
E CASCADE ON UPDATE CASCADE) QMYSQL3: Unable to execute statement"
Query: "INSERT INTO CollectionPimItemRelation (Collection_id, PimItem_id)
VALUES (:0, :1)"
Error during adding a record to table "CollectionPimItemRelation" "Cannot add
or update a child row: a foreign key c
onstraint fails (`akonadi`.`collectionpimitemrelation`, CONSTRAINT
`collectionpimitemrelation_ibfk_2` FOREIGN KEY (`
PimItem_id`) REFERENCES `pimitemtable` (`id`) ON DELETE CASCADE ON UPDATE
CASCADE) QMYSQL3: Unable to execute statem
ent" 


Are there any ways to get these errors resolved without deleting the whole
databases? Or workarounds?

-- 
You are receiving this mail because:
You are the assignee for the bug.



More information about the Kdepim-bugs mailing list