| Summary: | knotes has no akonadi collection table, could be the primary cause of failure | ||
|---|---|---|---|
| Product: | [Unmaintained] knotes | Reporter: | nmset <nmset> |
| Component: | general | Assignee: | kdepim bugs <pim-bugs-null> |
| Status: | RESOLVED UNMAINTAINED | ||
| Severity: | normal | CC: | myriam, nmset |
| Priority: | NOR | ||
| Version First Reported In: | 5.11.2 | ||
| Target Milestone: | --- | ||
| Platform: | Other | ||
| OS: | Linux | ||
| Latest Commit: | Version Fixed/Implemented In: | ||
| Sentry Crash Report: | |||
This is a general akonadi failure with newer mariadb version 10.4.6. This fix from Arch's forum gives a usable akonadi server, though knotes itself is not immediately usable on a new account :
> # mysql --socket=/tmp/akonadi-USERID.XXXXXX/mysql.socket -e 'create database
> mysql'
> # mysql_upgrade --socket=/tmp/akonadi-USERID.XXXXXX/mysql.socket
> # akonadictl restart
Let's hope akonadi devs come around this issue.
KNotes is no longer maintained since 24.08. Please migrate to Marknote. https://apps.kde.org/marknote/ See https://invent.kde.org/sysadmin/release-tools/-/merge_requests/53 |
SUMMARY knotes has no collection in collectiontable on fresh start. knotes is not usable at all. STEPS TO REPRODUCE 1. Create a new user and login. 2. Start knotes in a terminal 3. Start akonadiconsole. In DB Browser, collectiontable has no entries for knotes. OBSERVED RESULT When the created-by-default 'Notes' agent is restarted : 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`.`collectionmimetyperelation`, CONSTRAINT `collectionmimetyperelation_ibfk_1` FOREIGN KEY (`Collection_id`) REFERENCES `collectiontable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)" org.kde.pim.akonadiserver: Error text: "Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`collectionmimetyperelation`, CONSTRAINT `collectionmimetyperelation_ibfk_1` FOREIGN KEY (`Collection_id`) REFERENCES `collectiontable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL3: Impossible d'exécuter la requête" org.kde.pim.akonadiserver: Values: QMap((":0", QVariant(qlonglong, 14))(":1", QVariant(qlonglong, 8))) 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 "inode/directory" to Collection 14 org.kde.pim.akonadiserver: Failed to append mimetypes ("inode/directory", "text/x-vnd.akonadi.note") to new collection "Notes" (ID 14 ) in resource "akonadi_akonotes_resource_0" org.kde.pim.akonadiserver: Error while handling command CreateCollection on connection akonadi_akonotes_resource_0 (0x5595780c70a0) EXPECTED RESULT A usable knotes application, with a Notes collection in akonadiconsole, and all downstream DB constraints honored. SOFTWARE/OS VERSIONS Linux/KDE Plasma: 5.16-1 (available in About System) KDE Plasma Version: KDE Frameworks Version: 5.59.0 Qt Version: 5.12.4 ADDITIONAL INFORMATION Arch Linux