[arch-general] maria update to 10.4.6 breaks akonadi's db [solved]
Oliver Jaksch
arch-general at com-in.de
Sun Jun 30 09:48:20 UTC 2019
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.
More information about the arch-general
mailing list