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

[Oliver Jaksch]

Interesting...just tried that with my wife's account she never used on my box:
I've started _kontact_, which askes users account detail an so on. After 
finishing that I receive the same errors - but if I use the 2nd "fix" of the 
given URL then, and after restarting akonadi (akonadictl restart), everything 
is up and okay.

In short:
# mysql --socket=/tmp/akonadi-USERID.XXXXXX/mysql.socket -e 'create database 
mysql'
# mysql_upgrade --socket=/tmp/akonadi-USERID.XXXXXX/mysql.socket
# akonadictl restart

And yes, this should by fixed by the kde devs, definitively.




On Sunday, 30 June 2019, 10:51:36 CEST you wrote:
> 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.