Merkuro (Mail/Calendar/Contacts) - no account (Akonadi)

Not sure this is related, but it’s definitely a problem, I restarted the Akonadi server and got an error message. I don’t understand this kind of info.
What can I delete and reinstall to fix it? Since there’s no accounts in Kmail or Merkuro or similar apps, it’s no problem to start fresh. But what exactly :slight_smile: ?

akonadictl restart
org.kde.pim.akonadictl: Starting Akonadi Server...
org.kde.pim.akonadictl:    done.
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
jonathan@C4-3D-1A-5B-28-EF:~$ org.kde.pim.akonadiserver: Starting up the Akonadi Server...
Installing MariaDB/MySQL system tables in '/home/jonathan/.local/share/akonadi/db_data/' ...
OK

To start mariadbd at boot time you have to copy
support-files/mariadb.service to the right place for your system


Two all-privilege accounts were created.
One is root@localhost, it has no password, but you need to
be system 'root' user to connect. Use, for example, sudo mysql
The second is jonathan@localhost, it has no password either, but
you need to be the system 'jonathan' user to connect.
After connecting you can set the password, if you would need to be
able to connect as any of these users with a password and without sudo

See the MariaDB Knowledgebase at https://mariadb.com/kb

You can start the MariaDB daemon with:
cd '/usr' ; /usr/bin/mariadb-safe --datadir='/home/jonathan/.local/share/akonadi/db_data/'

You can test the MariaDB daemon with mysql-test-run.pl
cd '/usr/share/mysql-test' ; perl mariadb-test-run.pl

Please report any problems at https://mariadb.org/jira

The latest information about MariaDB is available at https://mariadb.org/.

Consider joining MariaDB's strong and vibrant community:
https://mariadb.org/get-involved/

/usr/bin/mysqlcheck: Got error: 1049: Unknown database 'akonadi' when selecting the database
This installation of MariaDB is already upgraded to 10.5.23-MariaDB.
There is no need to run mysql_upgrade again for 10.5.23-MariaDB.
You can use --force if you still want to run mysql_upgrade
org.kde.pim.akonadiserver: Running DB initializer
org.kde.pim.akonadiserver: DB initializer done
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
org.kde.pim.akonadicontrol: Akonadi server is now operational.
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7f0b28001700) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7f0b28010410) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7f0b280106b0) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7f0b2801c560) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7f0b28013250) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7f0b2801e4b0) )
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7f0b28001700) identified as "KMailManager Kernel ETM - 94702276926544"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7f0b28010410) identified as "ETMCalendarMonitor - 94358883356528"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7f0b280106b0) identified as "TagModelMonitor - 94358885795696"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7f0b28013250) identified as "SpecialCollectionsMonitor - 94702276809552"
org.kde.pim.akonadiserver.search: Executing search "searchUpdate-1711552691"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7f0b2801c560) identified as "KAddressBook::GlobalContactSession - 94191506172096"
org.kde.pim.akonadi_search_xapian: Xapian Database does not exist at  "/home/jonathan/.local/share/akonadi/search_db/calendars/"
org.kde.pim.akonadi_search_xapian: Xapian Database does not exist at  "/home/jonathan/.local/share/akonadi/search_db/contacts/"
org.kde.pim.akonadi_search_xapian: Xapian Database does not exist at  "/home/jonathan/.local/share/akonadi/search_db/email/"
org.kde.pim.akonadi_search_xapian: Xapian Database does not exist at  "/home/jonathan/.local/share/akonadi/search_db/notes/"
org.kde.pim.akonadiserver.search: Search  "searchUpdate-1711552691" done (without remote search)
org.kde.pim.akonadiserver.search: Search update for collection "OpenInvitations" ( 2 ) finished: all results:  0 , removed results: 0
org.kde.pim.akonadiserver.search: Executing search "searchUpdate-1711552691"
org.kde.pim.akonadiserver.search: Search  "searchUpdate-1711552691" done (without remote search)
org.kde.pim.akonadiserver.search: Search update for collection "DeclinedInvitations" ( 3 ) finished: all results:  0 , removed results: 0
org.kde.pim.akonadiserver: DATABASE ERROR:
org.kde.pim.akonadiserver:   Error code: "1062"
org.kde.pim.akonadiserver:   DB error:  "Duplicate entry '1-OpenInvitations' for key 'CollectionTable_parentAndNameIndex'"
org.kde.pim.akonadiserver:   Error text: "Duplicate entry '1-OpenInvitations' for key 'CollectionTable_parentAndNameIndex' QMYSQL3: Kon statement niet uitvoeren"
org.kde.pim.akonadiserver:   Values: QMap((":0", QVariant(QString, "OpenInvitations"))(":1", QVariant(qlonglong, 1))(":2", QVariant(qlonglong, 1))(":3", QVariant(QString, "{\n    \"limit\": -1,\n    \"negated\": false,\n    \"rel\": 1,\n    \"subTerms\": [\n        {\n            \"cond\": 0,\n            \"key\": \"partstatus\",\n            \"negated\": false,\n            \"value\": \"jon@han-pilate.be0\"\n        }\n    ]\n}\n"))(":4", QVariant(QString, ""))(":5", QVariant(QString, ""))(":6", QVariant(bool, true)))
org.kde.pim.akonadiserver:   Query: "INSERT INTO CollectionTable (name, parentId, resourceId, queryString, queryAttributes, queryCollections, isVirtual) VALUES (:0, :1, :2, :3, :4, :5, :6)"
org.kde.pim.akonadiserver: Error during insertion into table "CollectionTable" "Duplicate entry '1-OpenInvitations' for key 'CollectionTable_parentAndNameIndex' QMYSQL3: Kon statement niet uitvoeren"
org.kde.pim.akonadiserver: Failed to append Collection "OpenInvitations" in resource "akonadi_search_resource"
org.kde.pim.akonadiserver: Error while handling command StoreSearch on connection merkuro.calendar-1635699386 (0x56161a0c3350)
org.kde.pim.akonadiserver: DATABASE ERROR:
org.kde.pim.akonadiserver:   Error code: "1062"
org.kde.pim.akonadiserver:   DB error:  "Duplicate entry '1-DeclinedInvitations' for key 'CollectionTable_parentAndNameIndex'"
org.kde.pim.akonadiserver:   Error text: "Duplicate entry '1-DeclinedInvitations' for key 'CollectionTable_parentAndNameIndex' QMYSQL3: Kon statement niet uitvoeren"
org.kde.pim.akonadiserver:   Values: QMap((":0", QVariant(QString, "DeclinedInvitations"))(":1", QVariant(qlonglong, 1))(":2", QVariant(qlonglong, 1))(":3", QVariant(QString, "{\n    \"limit\": -1,\n    \"negated\": false,\n    \"rel\": 1,\n    \"subTerms\": [\n        {\n            \"cond\": 0,\n            \"key\": \"partstatus\",\n            \"negated\": false,\n            \"value\": \"jon@han-pilate.be2\"\n        }\n    ]\n}\n"))(":4", QVariant(QString, ""))(":5", QVariant(QString, ""))(":6", QVariant(bool, true)))
org.kde.pim.akonadiserver:   Query: "INSERT INTO CollectionTable (name, parentId, resourceId, queryString, queryAttributes, queryCollections, isVirtual) VALUES (:0, :1, :2, :3, :4, :5, :6)"
org.kde.pim.akonadiserver: Error during insertion into table "CollectionTable" "Duplicate entry '1-DeclinedInvitations' for key 'CollectionTable_parentAndNameIndex' QMYSQL3: Kon statement niet uitvoeren"
org.kde.pim.akonadiserver: Failed to append Collection "DeclinedInvitations" in resource "akonadi_search_resource"
org.kde.pim.akonadiserver: Error while handling command StoreSearch on connection merkuro.calendar-1635699386 (0x56161a0c3350)
org.kde.pim.akonadiserver.search: Executing search "searchUpdate-1711552691"
org.kde.pim.akonadiserver.search: Search  "searchUpdate-1711552691" done (without remote search)
org.kde.pim.akonadiserver.search: Search update for collection "OpenInvitations" ( 2 ) finished: all results:  0 , removed results: 0
org.kde.pim.akonadiserver.search: Executing search "searchUpdate-1711552691"
org.kde.pim.akonadiserver.search: Search  "searchUpdate-1711552691" done (without remote search)
org.kde.pim.akonadiserver.search: Search update for collection "DeclinedInvitations" ( 3 ) finished: all results:  0 , removed results: 0
org.kde.pim.akonadiserver: Subscriber "TagModelMonitor - 94358885795696" disconnected
org.kde.pim.akonadiserver: Subscriber "ETMCalendarMonitor - 94358883356528" disconnected
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7f0b2801e4b0) identified as "ETMCalendarMonitor - 94827498530336"
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7f0b280106b0) )
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7f0b280106b0) identified as "AgentBaseChangeRecorder - 94057891985856"
org.kde.pim.akonadiserver: Subscriber "SpecialCollectionsMonitor - 94702276809552" disconnected
org.kde.pim.akonadiserver: Subscriber "KMailManager Kernel ETM - 94702276926544" disconnected

EDIT: after restarting and trying again, all the error messages weren’t there anymore, so it’s fixed automatically. I removed Merkuro again, and tried to delete all akonadi files (in .config and .local) I could see.

EDIT2:
What I tried without luck so far:
I repeatedly deleted the Akonadi files in .config and .local/shared, after which I did akonadictl start. I tried sudo dnf reinstall mysql, sudo dnf reinstall mariadb - because: Having issues with Akonadi, Kmail, MySql, sudo dnf install akonadi.x86_64, sudo dnf install akonadi.i686 (those last two, because I did sudo dnf search akonadi and saw those mentioned in the response), sudo dnf check, sudo dnf upgrade --refresh.
Also I removed and installed Kontact again.
Now Kontact with this error:
afbeelding
(Akonadi personal informationmanager-service doesn’t run)

I Ecosia-searched a lot, but I didn’t find recommendations to try.