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

2015-08-20 Thread Grégory Oestreicher 
https://bugs.kde.org/show_bug.cgi?id=337396

Grégory Oestreicher g...@kamago.net changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 CC||g...@kamago.net
 Resolution|--- |FIXED

--- Comment #5 from Grégory Oestreicher g...@kamago.net ---
So I think that the root issue is fixed now that there's a conflict resolution.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs

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

2015-08-02 Thread Robert G . Siebeck 
https://bugs.kde.org/show_bug.cgi?id=337396

Robert G. Siebeck kde.bugzilla.2...@r123.de changed:

   What|Removed |Added

 CC||kde.bugzilla.2...@r123.de

--- Comment #3 from Robert G. Siebeck kde.bugzilla.2...@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.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs

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

2015-08-02 Thread Robert G . Siebeck 
https://bugs.kde.org/show_bug.cgi?id=337396

--- Comment #4 from Robert G. Siebeck kde.bugzilla.2...@r123.de ---
I could resolve this issue by deleting
~.config/akonadi/agent_config_akonadi_davgroupware_resource*_changes.dat

This killed all my unsynced local changes, but at least I can sync the account
now.

This tip is from a comment: https://bugs.kde.org/show_bug.cgi?id=335090#c1

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs

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

2015-03-09 Thread Niels Dettenbach 
https://bugs.kde.org/show_bug.cgi?id=337396

Niels Dettenbach n...@syndicat.com changed:

   What|Removed |Added

 CC||n...@syndicat.com

--- Comment #2 from Niels Dettenbach n...@syndicat.com ---
It seems i can confirm the bug, because i get a similiar error with akonadi
1.13.0 (in kontact 4.14.3 / Gentoo). Beside this, akonadi is hardly consuming
system ressources from time to time (for ~30 seconds in steps of 10-20 minutes
- leads to nearly full hang of KDE only, while text konsoles are not affected
from time to time and some times the full system) on a relatively powerful
machine (Mac Book Pro 6,1 with fast SSD, 8 GB, i7 Dual/Quad CPU):

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 DELETE 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 constraint fails
(`akonadi`.`collectionpimitemrelation`, CONSTRAINT
`collectionpimitemrelation_ibfk_2` FOREIGN KEY (`PimItem_id`) REFERENCES
`pimitemtable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL3: Unable to
execute statement 
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 DELETE 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 constraint fails
(`akonadi`.`collectionpimitemrelation`, CONSTRAINT
`collectionpimitemrelation_ibfk_2` FOREIGN KEY (`PimItem_id`) REFERENCES
`pimitemtable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL3: Unable to
execute statement 
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 DELETE 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 constraint fails
(`akonadi`.`collectionpimitemrelation`, CONSTRAINT
`collectionpimitemrelation_ibfk_2` FOREIGN KEY (`PimItem_id`) REFERENCES
`pimitemtable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL3: Unable to
execute statement 
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 DELETE 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 constraint fails
(`akonadi`.`collectionpimitemrelation`, CONSTRAINT
`collectionpimitemrelation_ibfk_2` FOREIGN KEY (`PimItem_id`) REFERENCES
`pimitemtable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL3: Unable to
execute statement 
DATABASE ERROR:
Error code: 1452
DB error:  Cannot add or update a child row: a foreign key constraint fails

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

2014-11-07 Thread Rigo Wenning 
https://bugs.kde.org/show_bug.cgi?id=337396

Rigo Wenning r...@w3.org changed:

   What|Removed |Added

 CC||r...@w3.org

--- Comment #1 from Rigo Wenning r...@w3.org ---
Probably related to Bug #335090 https://bugs.kde.org/show_bug.cgi?id=335090 and
then corrupting the akonadi cache. I think this is a duplicate. The reason
given in #335090 is that akonadi does not implement a local/remote conflict
resolution. Thus, korganizer/akonadi pair misses essential parts of the needed
functionality for remote calendars and corrupts its own database

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs