On Saturday 01 August 2015 18:56:09 Martin Steigerwald wrote: > Do you want to take the time to share what regressions you got, so I can > report them upstream? > > If you already reported them, disregard my mail.
I did not have time to chase those problems with upstream, unfortunately... On MySQL backend I've seen ~~~~ Error code: 1452 DB error: "Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`PartTable`, CONSTRAINT `PartTable_ibfk_2` FOREIGN KEY (`partTypeId`) REFERENCES `PartTypeTable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)" Error text: "Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`PartTable`, CONSTRAINT `PartTable_ibfk_2` FOREIGN KEY (`partTypeId`) REFERENCES `PartTypeTable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL3: Unable to execute statement" Query: "INSERT INTO PartTable (pimItemId, data, datasize, version, external) VALUES (:0, :1, :2, :3, :4)" Error during insertion into table "PartTable" "Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`PartTable`, CONSTRAINT `PartTable_ibfk_2` FOREIGN KEY (`partTypeId`) REFERENCES `PartTypeTable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL3: Unable to execute statement" ~~~~ and other errors like invalid SQL sentences etc. I don't remember what caused this particular error but the whole process felt so fragile I almost lost confidence in Akonadi. :( Cherry-picking optimisations in Akonadi is not too easy as they cascade on top of each other. It turned out that it is extremely time consuming to apply even those that look safe and testing often proves that impression wrong... > I forgot to mention, I have this one installed already, using sid with some > packages from experimental on this machine. Nice. I hope updated Akonadi will work well for you. :) > Thank you for your work on the package and your testing with all backends. Thanks for your help and sorry for not chasing problems in Akonady any further. In order to report bugs upstream it might be better to test Akonadi's matser but I can't risk breaking my email by doing that. Fiddling with Akonadi already took a whole week of my time and I simply can't afford to continue working on. Luckily my email is working again... -- All the best, Dmitry Smirnov --- The foundation of morality should not be made dependent on myth nor tied to any authority lest doubt about the myth or about the legitimacy of the authority imperil the foundation of sound judgment and action. -- Albert Einstein
signature.asc
Description: This is a digitally signed message part.