Hi,

I upgraded from 14.04 to 16.04 not knowing, that this was not recommended and because I was running into diffuculties, I installed 18.04.

After the installation Kontact was running fine. Then i installed more than 200 updates with Discover. After rebooting I could no longer start Kontact: Akonadi ist not running.

Code: Select all

akonadictl status

gives the information:

Code: Select all

konadi Control: stopped
Akonadi Server: stopped
Akonadi Server Search Support: available (Remote Search)
Available Agent Types: akonadi_akonotes_resource, akonadi_archivemail_agent, akonadi_birthdays_resource, akonadi_contacts_resource, akonadi_davgroupware_resource, akonadi_ews_resource, akonadi_ewsmta_resource, akonadi_facebook_resource, akonadi_followupreminder_agent, akonadi_googlecalendar_resource, akonadi_googlecontacts_resource, akonadi_ical_resource, akonadi_icaldir_resource, akonadi_imap_resource, akonadi_indexing_agent, akonadi_invitations_agent, akonadi_kalarm_dir_resource, akonadi_kalarm_resource, akonadi_kolab_resource, akonadi_maildir_resource, akonadi_maildispatcher_agent, akonadi_mailfilter_agent, akonadi_mbox_resource, akonadi_migration_agent, akonadi_mixedmaildir_resource, akonadi_newmailnotifier_agent, akonadi_notes_agent, akonadi_notes_resource, akonadi_openxchange_resource, akonadi_pop3_resource, akonadi_sendlater_agent, akonadi_tomboynotes_resource, akonadi_vcard_resource, akonadi_vcarddir_resource


Trying:

Code: Select all

akonadictl start

gives:

Code: Select all

Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
akonadi.collectionattributetable                   OK
akonadi.collectionmimetyperelation                 OK
akonadi.collectionpimitemrelation                  OK
akonadi.collectiontable                            OK
akonadi.flagtable                                  OK
akonadi.mimetypetable                              OK
akonadi.parttable                                  OK
akonadi.parttypetable                              OK
akonadi.pimitemflagrelation                        OK
akonadi.pimitemtable                               OK
akonadi.pimitemtagrelation                         OK
akonadi.relationtable
Error    : Table 'akonadi.relationtable' doesn't exist
status   : Operation failed
akonadi.relationtypetable
Error    : Table 'akonadi.relationtypetable' doesn't exist
status   : Operation failed
akonadi.resourcetable                              OK
akonadi.schemaversiontable                         OK
akonadi.tagattributetable                          OK
akonadi.tagremoteidresourcerelationtable           OK
akonadi.tagtable                                   OK
akonadi.tagtypetable
Error    : Table 'akonadi.tagtypetable' doesn't exist
status   : Operation failed

Repairing tables
akonadi.relationtable
Error    : Table 'akonadi.relationtable' doesn't exist
status   : Operation failed
akonadi.relationtypetable
Error    : Table 'akonadi.relationtypetable' doesn't exist
status   : Operation failed
akonadi.tagtypetable
Error    : Table 'akonadi.tagtypetable' doesn't exist
status   : Operation failed
org.kde.pim.akonadiserver: "\nSql error: Table 'akonadi.tagtypetable' doesn't exist QMYSQL: Unable to execute query\nQuery: ALTER TABLE TagTypeTable ADD COLUMN id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY"
org.kde.pim.akonadiserver: Unable to initialize database.
org.kde.pim.akonadicontrol: Application 'akonadiserver' exited normally...


I see the Error-messages of the missing tables, but I don't know how to fix it.

Maybe it has to do with different SQL Version from 14.04, 16.04 and 18.04.

Thank you for your help

Malefiz

Hi,

I read here (in German) https://wiki.ubuntuusers.de/Akonadi/#Ressourcen-einrichten how to reset Akonadi.

In short it is:

Stopp Akonadi
Check related processes
Delete all Folders/Files
Restart Akonadi

Which Folders/Files must be deleted?

Best regards

Malefiz