Re: Fwd: Re: Akonadi server won't start

On Dienstag, 17. August 2021 17:30:57 CEST Thomas Tanghus wrote:
> On 17/08/2021 17:09, Ianseeks wrote:
> > I've no idea to the solution but this may be the reason (from your txt
> > file)
> > org.kde.pim.akonadiserver: DATABASE ERROR:
> > org.kde.pim.akonadiserver:   Error code: "2013"
> > org.kde.pim.akonadiserver:   DB error:  "Lost connection to MySQL
> > server during query"
> > org.kde.pim.akonadiserver:   Error text: "Lost connection to MySQL
> > server during query QMYSQL3: Unable to execute statement"
> 
> So maybe it's the mysql server that dies instead?

Maybe the following helps:
https://stackoverflow.com/questions/10563619/error-code-2013-lost-connection-to-mysql-server-during-query

If tweaking weird MySQL configuration options doesn't help, then I suggest to 
switch to PostgreSQL as database for Akonadi which works much better for many 
people who made the switch (including me).

WARNING: Switching the database will make Akonadi forget more or less 
everything. Make a backup before proceeding. If you have lots of filters 
configured, then export them before the switch. If you have mail stored in 
local folders, i.e. if you are not using IMAP exclusively, then you might also 
want to export those folders. Akonadi may not have written all local mail to 
local files so that some of those mails may only be stored in the database.

The safest approach is to start from scratch, i.e. by moving all the old 
Akonadi and KMail related files out of the way as described at
https://userbase.kde.org/KMail/
FAQs_Hints_and_Tips#Clean_start_after_a_failed_migration
Except that instead of deleting files and folders I suggest to rename the 
files/folders.

Don't forget to make a backup of everything before proceeding. Actually, you 
should also make a backup if you are not proceeding unless you are already 
doing regular backups.

To tell Akonadi that it should use PostgreSQL all you need to do is insert 
these lines in
~/.config/akonadi/akonadiserverrc:
[%General]
Driver=QPSQL

You also may have to install the PostgreSQL server and some other PostgreSQL 
and/or Akonadi packages. Check what packages are available for you 
distribution.

Regards,
Ingo

-----BEGIN PGP SIGNATURE-----

iF0EABECAB0WIQRxKgkQMhrHYtSAVAgadH5FMOC52AUCYRwNSAAKCRAadH5FMOC5
2OdfAJ991+fkf3yBjrXsAyq0cXqICyD1UgCeMrmsiBEPyYh241vZuxEGB53TS5Y=
=V3Rd
-----END PGP SIGNATURE-----