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
Attachment:
signature.asc
Description: This is a digitally signed message part.