[arch-general] maria update to 10.4.6 breaks akonadi's db [solved]

[SET]

Le vendredi 28 juin 2019 12:10:43 CEST Oliver Jaksch via arch-general a écrit 
:
> The solution found at https://bbs.archlinux.org/viewtopic.php?id=184192
> fixed 'em all.

Just a sidenote.

New users just can't use akonadi with this new mysql.
Create a new user with an empty home directory, login and start akonadi in a 
console, there are tons of errors like :

...
org.kde.pim.akonadiserver: DATABASE ERROR: 
org.kde.pim.akonadiserver:   Error code: "1452" 
org.kde.pim.akonadiserver:   DB error:  "Cannot add or update a child row: a 
foreign key constraint fails (`akonadi`.`collectionmimetyperelatio
n`, CONSTRAINT `collectionmimetyperelation_ibfk_1` FOREIGN KEY 
(`Collection_id`) REFERENCES `collectiontable` (`id`) ON DELETE CASCADE ON 
UPDAT
E CASCADE)" 
org.kde.pim.akonadiserver:   Error text: "Cannot add or update a child row: a 
foreign key constraint fails (`akonadi`.`collectionmimetyperelati
on`, CONSTRAINT `collectionmimetyperelation_ibfk_1` FOREIGN KEY 
(`Collection_id`) REFERENCES `collectiontable` (`id`) ON DELETE CASCADE ON 
UPDA
TE CASCADE) QMYSQL3: Unable to execute statement" 
org.kde.pim.akonadiserver:   Values: QMap((":0", QVariant(qlonglong, 2))(":1", 
QVariant(qlonglong, 2))) 
org.kde.pim.akonadiserver:   Query: "INSERT INTO CollectionMimeTypeRelation 
(Collection_id, MimeType_id) VALUES (:0, :1)" 
org.kde.pim.akonadiserver: Error during adding a record to table 
"CollectionMimeTypeRelation" 
org.kde.pim.akonadiserver: Failed to append mimetype "application/x-
vnd.akonadi.calendar.event" to Collection 2 
org.kde.pim.akonadiserver: Failed to append mimetypes ("application/x-
vnd.akonadi.calendar.event") to new collection "Birthdays & Anniversaries
" (ID 2 ) in resource "akonadi_birthdays_resource" 
org.kde.pim.akonadiserver: Error while handling command CreateCollection on 
connection akonadi_birthdays_resource (0x56188ad4b440) 
org.kde.pim.akonadiserver: DATABASE ERROR: 
org.kde.pim.akonadiserver:   Error code: "1452"
...

Until KDE devs consider this newer version of mysql.

Regards.